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.
username varchar(64) UNIQUE NOT NULL,
password TEXT NOT NULL,
hashversion integer NOT NULL DEFAULT 0,
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'
-ADD COLUMN authenticator varchar(64) NOT NULL DEFAULT "Database";
+ADD COLUMN authenticator varchar(64) NOT NULL DEFAULT 'Database';