diff options
Diffstat (limited to 'src/sql/schema-000-000.sql')
| -rw-r--r-- | src/sql/schema-000-000.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/sql/schema-000-000.sql b/src/sql/schema-000-000.sql index f80977f..f1881cc 100644 --- a/src/sql/schema-000-000.sql +++ b/src/sql/schema-000-000.sql @@ -8,7 +8,7 @@ CREATE TABLE [db_version] ( ); CREATE TABLE [at_setlist] ( - uuid BLOB PRIMARY KEY + uuid NCHAR(56) PRIMARY KEY ,title nvarchar(128) DEFAULT '' ,is_deleted INTEGER NOT NULL DEFAULT 0 ,creation_dt INTEGER DEFAULT (unixepoch('now')) @@ -16,7 +16,7 @@ CREATE TABLE [at_setlist] ( ); CREATE TABLE [at_song] ( - uuid BLOB PRIMARY KEY + uuid NCHAR(56) PRIMARY KEY ,ccli INTEGER ,title nvarchar(128) DEFAULT '' ,arrangement nvarchar(128) DEFAULT '' @@ -27,17 +27,17 @@ CREATE TABLE [at_song] ( ); CREATE TABLE [at_setlist_song] ( - setlist_uuid BLOB - ,song_uuid BLOB + setlist_uuid NCHAR(56) + ,song_uuid NCHAR(56) ,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 + song_uuid NCHAR(56) ,sequence INTEGER + ,section_type INTEGER ,beats_per_bar INTEGER ,bar_count INTEGER ,is_deleted INTEGER NOT NULL DEFAULT 0 |