diff options
| author | Jonathan Bradley <jcb@pikum.xyz> | 2025-12-04 22:45:26 -0500 |
|---|---|---|
| committer | Jonathan Bradley <jcb@pikum.xyz> | 2025-12-04 22:45:26 -0500 |
| commit | 1797e8a78986407156170980742a8b960edd86ef (patch) | |
| tree | 851896f8b503c204fcee36fc971147cc8514f99b | |
| parent | 93774ad8403c7c03925d7543bafdc5c80d5f8b07 (diff) | |
pke-at: at_setlist_song compound primary key
| -rw-r--r-- | src/sql/schema-000-000.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/sql/schema-000-000.sql b/src/sql/schema-000-000.sql index f1881cc..3e96dcf 100644 --- a/src/sql/schema-000-000.sql +++ b/src/sql/schema-000-000.sql @@ -32,6 +32,7 @@ CREATE TABLE [at_setlist_song] ( ,is_deleted INTEGER NOT NULL DEFAULT 0 ,creation_dt INTEGER DEFAULT (unixepoch('now')) ,modification_dt INTEGER DEFAULT (unixepoch('now')) + ,PRIMARY KEY (setlist_uuid, song_uuid) ); CREATE TABLE [at_section] ( |