diff options
| author | Jonathan Bradley <jcb@pikum.xyz> | 2025-10-13 15:27:59 -0400 |
|---|---|---|
| committer | Jonathan Bradley <jcb@pikum.xyz> | 2025-10-13 15:44:17 -0400 |
| commit | 6d53452ebc24287a72eedb9a2cc3f9e21c55362c (patch) | |
| tree | 04ce0135a9718c41f24f217b587088dd9d59241a /src/sql/schema-000-000.sql | |
| parent | 62dae6011db94dd52c3ac0fce517c6e9cc0abcf6 (diff) | |
pke-at: second-pass sql storage
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 |