diff options
Diffstat (limited to 'src/sql/schema-000-000.sql')
| -rw-r--r-- | src/sql/schema-000-000.sql | 48 |
1 files changed, 48 insertions, 0 deletions
diff --git a/src/sql/schema-000-000.sql b/src/sql/schema-000-000.sql new file mode 100644 index 0000000..f80977f --- /dev/null +++ b/src/sql/schema-000-000.sql @@ -0,0 +1,48 @@ +CREATE TABLE [db_version] ( + id INTEGER PRIMARY KEY + ,version_maj INTEGER NOT NULL + ,version_min INTEGER NOT NULL + ,is_deleted INTEGER NOT NULL DEFAULT 0 + ,creation_dt INTEGER DEFAULT (unixepoch('now')) + ,modification_dt INTEGER DEFAULT (unixepoch('now')) +); + +CREATE TABLE [at_setlist] ( + uuid BLOB PRIMARY KEY + ,title nvarchar(128) DEFAULT '' + ,is_deleted INTEGER NOT NULL DEFAULT 0 + ,creation_dt INTEGER DEFAULT (unixepoch('now')) + ,modification_dt INTEGER DEFAULT (unixepoch('now')) +); + +CREATE TABLE [at_song] ( + uuid BLOB PRIMARY KEY + ,ccli INTEGER + ,title nvarchar(128) DEFAULT '' + ,arrangement nvarchar(128) DEFAULT '' + ,beats_per_minute INTEGER + ,is_deleted INTEGER NOT NULL DEFAULT 0 + ,creation_dt INTEGER DEFAULT (unixepoch('now')) + ,modification_dt INTEGER DEFAULT (unixepoch('now')) +); + +CREATE TABLE [at_setlist_song] ( + setlist_uuid BLOB + ,song_uuid BLOB + ,is_deleted INTEGER NOT NULL DEFAULT 0 + ,creation_dt INTEGER DEFAULT (unixepoch('now')) + ,modification_dt INTEGER DEFAULT (unixepoch('now')) +); + +CREATE TABLE [at_section] ( + song_uuid BLOB + ,section_type INTEGER + ,sequence INTEGER + ,beats_per_bar INTEGER + ,bar_count INTEGER + ,is_deleted INTEGER NOT NULL DEFAULT 0 + ,creation_dt INTEGER DEFAULT (unixepoch('now')) + ,modification_dt INTEGER DEFAULT (unixepoch('now')) +); + +INSERT INTO [db_version](id,version_maj,version_min) VALUES(0,1,0); |