From 1797e8a78986407156170980742a8b960edd86ef Mon Sep 17 00:00:00 2001
From: Jonathan Bradley <jcb@pikum.xyz>
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(+)

(limited to 'src/sql/schema-000-000.sql')

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

