Skip to content

Instantly share code, notes, and snippets.

@ski7777
Created February 5, 2018 19:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ski7777/5ee551467a8cbb6518d12a8270116f80 to your computer and use it in GitHub Desktop.
Save ski7777/5ee551467a8cbb6518d12a8270116f80 to your computer and use it in GitHub Desktop.
BEGIN TRANSACTION;
CREATE TABLE `sheets` ( `composition_id`INTEGER NOT NULL, `instrument`INTEGER,`uuid`TEXT UNIQUE);
CREATE TABLE `folder_contents` ( `folder_id` INTEGER, `sheet_id` TEXT, `instrument_id` INTEGER );
CREATE TABLE `compositions` ( `id` INTEGER NOT NULL UNIQUE, `name` TEXT NOT NULL, `author` TEXT NOT NULL );
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment