diff options
| author | Jonathan Bradley <jcb@pikum.xyz> | 2025-10-13 15:27:59 -0400 |
|---|---|---|
| committer | Jonathan Bradley <jcb@pikum.xyz> | 2025-10-13 15:44:17 -0400 |
| commit | 6d53452ebc24287a72eedb9a2cc3f9e21c55362c (patch) | |
| tree | 04ce0135a9718c41f24f217b587088dd9d59241a /src/sql/song_upsert.sql | |
| parent | 62dae6011db94dd52c3ac0fce517c6e9cc0abcf6 (diff) | |
pke-at: second-pass sql storage
Diffstat (limited to 'src/sql/song_upsert.sql')
| -rw-r--r-- | src/sql/song_upsert.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/sql/song_upsert.sql b/src/sql/song_upsert.sql index d0e4fcc..4f2a165 100644 --- a/src/sql/song_upsert.sql +++ b/src/sql/song_upsert.sql @@ -1,5 +1,5 @@ INSERT INTO [at_song] (uuid,ccli,title,arrangement,beats_per_minute) - VALUES('%s','%s','%s','%s','%s') + VALUES('%s','%lu','%s','%s','%u') ON CONFLICT(uuid) DO UPDATE SET ccli=excluded.ccli ,title=excluded.title |