From 1797e8a78986407156170980742a8b960edd86ef Mon Sep 17 00:00:00 2001 From: Jonathan Bradley Date: Thu, 4 Dec 2025 22:45:26 -0500 Subject: pke-at: at_setlist_song compound primary key --- src/sql/schema-000-000.sql | 1 + 1 file changed, 1 insertion(+) 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] ( -- cgit v1.2.3