136
137
138
139
140
141
142
143
144
145
146
147
148
149
|
;; "ALTER TABLE tests ADD COLUMN tol_perc REAL;"
"ALTER TABLE tests ADD COLUMN first_err TEXT;"
"ALTER TABLE tests ADD COLUMN first_warn TEXT;"
;; "ALTER TABLE tests ADD COLUMN units TEXT;"
))))
(if (< mver 1.25)
(begin
(sqlite3:execute db "DROP TABLE test_meta;")
(sqlite3:execute db test-meta-def)
(sqlite3:execute db "CREATE TABLE IF NOT EXISTS test_data (id INTEGER PRIMARY KEY,
test_id INTEGER,
category TEXT DEFAULT '',
variable TEXT,
value REAL,
|
>
|
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
;; "ALTER TABLE tests ADD COLUMN tol_perc REAL;"
"ALTER TABLE tests ADD COLUMN first_err TEXT;"
"ALTER TABLE tests ADD COLUMN first_warn TEXT;"
;; "ALTER TABLE tests ADD COLUMN units TEXT;"
))))
(if (< mver 1.25)
(begin
(sqlite3:execute db "DROP TABLE test_data;")
(sqlite3:execute db "DROP TABLE test_meta;")
(sqlite3:execute db test-meta-def)
(sqlite3:execute db "CREATE TABLE IF NOT EXISTS test_data (id INTEGER PRIMARY KEY,
test_id INTEGER,
category TEXT DEFAULT '',
variable TEXT,
value REAL,
|