diff options
Diffstat (limited to 'src/sql/schema-000-000.sql')
| -rw-r--r-- | src/sql/schema-000-000.sql | 22 |
1 files changed, 19 insertions, 3 deletions
diff --git a/src/sql/schema-000-000.sql b/src/sql/schema-000-000.sql index 3e96dcf..b57b977 100644 --- a/src/sql/schema-000-000.sql +++ b/src/sql/schema-000-000.sql @@ -9,7 +9,7 @@ CREATE TABLE [db_version] ( CREATE TABLE [at_setlist] ( uuid NCHAR(56) PRIMARY KEY - ,title nvarchar(128) DEFAULT '' + ,title NVARCHAR(128) DEFAULT '' ,is_deleted INTEGER NOT NULL DEFAULT 0 ,creation_dt INTEGER DEFAULT (unixepoch('now')) ,modification_dt INTEGER DEFAULT (unixepoch('now')) @@ -18,8 +18,8 @@ CREATE TABLE [at_setlist] ( CREATE TABLE [at_song] ( uuid NCHAR(56) PRIMARY KEY ,ccli INTEGER - ,title nvarchar(128) DEFAULT '' - ,arrangement nvarchar(128) DEFAULT '' + ,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')) @@ -46,4 +46,20 @@ CREATE TABLE [at_section] ( ,modification_dt INTEGER DEFAULT (unixepoch('now')) ); +CREATE TABLE [ext_source] ( + id INTEGER PRIMARY KEY + ,title NVARCHAR(255) NOT NULL +); + +CREATE TABLE [ext_mapping] ( + source_id INTEGER + ,id_external_integer INTEGER NOT NULL DEFAULT 0 + ,uuid NCHAR(56) NOT NULL + ,is_deleted INTEGER NOT NULL DEFAULT 0 + ,creation_dt INTEGER DEFAULT (unixepoch('now')) + ,modification_dt INTEGER DEFAULT (unixepoch('now')) + ,PRIMARY KEY (source_id, id_external_integer) +); + +INSERT INTO [ext_source](id,title) VALUES(1,'Planning Center Services'); INSERT INTO [db_version](id,version_maj,version_min) VALUES(0,1,0); |