From 6d53452ebc24287a72eedb9a2cc3f9e21c55362c Mon Sep 17 00:00:00 2001
From: Jonathan Bradley <jcb@pikum.xyz>
Date: Mon, 13 Oct 2025 15:27:59 -0400
Subject: pke-at: second-pass sql storage

---
 src/sql/schema-000-000.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(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 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
-- 
cgit v1.2.3

