Index: db.scm ================================================================== --- db.scm +++ db.scm @@ -939,12 +939,13 @@ last_update INTEGER DEFAULT (strftime('%s','now')), CONSTRAINT runsconstraint UNIQUE (runname" (if havekeys "," "") keystr "));")) (sqlite3:execute db "CREATE TRIGGER update_runs_trigger AFTER UPDATE ON runs FOR EACH ROW BEGIN - UPDATE runs SET last_update=strftime('%','now') - WHERE id=old.id;") + UPDATE runs SET last_update=(strftime('%','now')) + WHERE id=old.id; + END;") (sqlite3:execute db "CREATE TABLE IF NOT EXISTS test_meta ( id INTEGER PRIMARY KEY, testname TEXT DEFAULT '', author TEXT DEFAULT '', owner TEXT DEFAULT '', @@ -1039,12 +1040,13 @@ CONSTRAINT testsconstraint UNIQUE (run_id, testname, item_path));") (sqlite3:execute db "CREATE INDEX IF NOT EXISTS tests_index ON tests (run_id, testname, item_path);") (sqlite3:execute db "CREATE TRIGGER update_tests_trigger AFTER UPDATE ON tests FOR EACH ROW BEGIN - UPDATE tests SET last_update=strftime('%','now') - WHERE id=old.id;") + UPDATE tests SET last_update=(strftime('%','now')) + WHERE id=old.id; + END;") (sqlite3:execute db "CREATE TABLE IF NOT EXISTS test_steps (id INTEGER PRIMARY KEY, test_id INTEGER, stepname TEXT, state TEXT DEFAULT 'NOT_STARTED',