From fa412cdb5985ec4199f89510d8d8cde9b7664e2d Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Fri, 24 Jan 2020 19:47:43 +0000 Subject: Alter the Builds table to have an id field The internal rowid's are used for builds as you can request builds by using the rowid in the URL. The motivation here is to enable running VACUUM operations in SQLite, without risking the rowid's for Builds changing. It would be bad if they change, as they're used in the URL's for builds. * src/schema.sql (Builds): Add id column. * src/curiass/dataabse.scm (db-add-build): Change PRIMARYKEY constraint to UNIQUE constraint. * src/sql/upgrade-6.sql: New file. * Makefile.am (dist_sql_DATA): Add it. --- Makefile.am | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'Makefile.am') diff --git a/Makefile.am b/Makefile.am index 5448420..bc0e90c 100644 --- a/Makefile.am +++ b/Makefile.am @@ -70,7 +70,8 @@ dist_sql_DATA = \ src/sql/upgrade-2.sql \ src/sql/upgrade-3.sql \ src/sql/upgrade-4.sql \ - src/sql/upgrade-5.sql + src/sql/upgrade-5.sql \ + src/sql/upgrade-6.sql dist_css_DATA = \ src/static/css/bootstrap.css \ -- cgit v1.2.3