From 8fd4e06a6a0ccc7d8a7ad15b492ab8311b59a0b8 Mon Sep 17 00:00:00 2001 From: Ben Rosser Date: Thu, 24 Nov 2016 18:51:11 -0500 Subject: [PATCH] Fix quasseluser table setup on PostgreSQL and sort sql.qrc It seems that at some point the DEFAULT option for a varchar() column has become sensitive to whether or not single or double quotation marks are used. In particular when ""s were used, core setup failed with the message 'ERROR: column "Database" does not exist'. Changing to single quotation marks (''s) resolved the issue. Also include @digitalcircuit's sorted version of sql.qrc. Fix the upgrade script too. --- src/core/SQL/PostgreSQL/setup_000_quasseluser.sql | 2 +- .../22/upgrade_000_alter_quasseluser_add_authenticator.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/core/SQL/PostgreSQL/setup_000_quasseluser.sql b/src/core/SQL/PostgreSQL/setup_000_quasseluser.sql index c668e69b..57abcea6 100644 --- a/src/core/SQL/PostgreSQL/setup_000_quasseluser.sql +++ b/src/core/SQL/PostgreSQL/setup_000_quasseluser.sql @@ -3,5 +3,5 @@ CREATE TABLE quasseluser ( username varchar(64) UNIQUE NOT NULL, password TEXT NOT NULL, hashversion integer NOT NULL DEFAULT 0, - authenticator varchar(64) NOT NULL DEFAULT "Database" + authenticator varchar(64) NOT NULL DEFAULT 'Database' ) diff --git a/src/core/SQL/PostgreSQL/version/22/upgrade_000_alter_quasseluser_add_authenticator.sql b/src/core/SQL/PostgreSQL/version/22/upgrade_000_alter_quasseluser_add_authenticator.sql index 50a52034..55733e0e 100644 --- a/src/core/SQL/PostgreSQL/version/22/upgrade_000_alter_quasseluser_add_authenticator.sql +++ b/src/core/SQL/PostgreSQL/version/22/upgrade_000_alter_quasseluser_add_authenticator.sql @@ -1,2 +1,2 @@ ALTER TABLE quasseluser -ADD COLUMN authenticator varchar(64) NOT NULL DEFAULT "Database"; +ADD COLUMN authenticator varchar(64) NOT NULL DEFAULT 'Database'; -- 2.20.1