Skip to content

Instantly share code, notes, and snippets.

@steinarb

steinarb/emptyalbum.sql

Created September 8, 2020 19:59
Show Gist options
  • Save steinarb/dba5f579774d04e69f3073d029622027 to your computer and use it in GitHub Desktop.
Save steinarb/dba5f579774d04e69f3073d029622027 to your computer and use it in GitHub Desktop.
Download ZIP
Oldalbum database containing just the root album
Raw
emptyalbum.sql
--liquibase formatted sql
--changeset sb:empty_album
insert into albumentries (albumentry_id, parent, localpath, album, title, description, imageurl, thumbnailurl, sort, lastmodified, contenttype, contentlength) values (1, 0, '/', true, 'Pictures from the past', 'Old images 90, served up in a mobile friendly responsive layout and with OpenGraph-tags and twitter cards', '', '', 0, null, null, 0);
ALTER TABLE albumentries ALTER COLUMN albumentry_id RESTART WITH 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment