20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
DROP TABLE IF EXISTS test_steps;
DROP TABLE IF EXISTS test_data;
DROP TABLE IF EXISTS test_rundat;
DROP TABLE IF EXISTS archives;
CREATE TABLE IF NOT EXISTS areas (
id INTEGER PRIMARY KEY,
areaname TEXT DEFAULT 'local',
areapath TEXT DEFAULT '.',
last_sync INTEGER DEFAULT 0,
CONSTRAINT areaconstraint UNIQUE (areaname));
INSERT INTO areas (id,areaname,areapath) VALUES (0,'local','.');
CREATE TABLE IF NOT EXISTS ttype (
id INTEGER PRIMARY KEY,
target_spec TEXT DEFAULT '');
CREATE TABLE IF NOT EXISTS runs (
id INTEGER PRIMARY KEY,
|
|
|
|
|
|
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
DROP TABLE IF EXISTS test_steps;
DROP TABLE IF EXISTS test_data;
DROP TABLE IF EXISTS test_rundat;
DROP TABLE IF EXISTS archives;
CREATE TABLE IF NOT EXISTS areas (
id INTEGER PRIMARY KEY,
area_name TEXT DEFAULT 'local',
area_path TEXT DEFAULT '.',
last_sync INTEGER DEFAULT 0,
CONSTRAINT areaconstraint UNIQUE (area_name));
INSERT INTO areas (id,area_name,area_path) VALUES (0,'local','.');
CREATE TABLE IF NOT EXISTS ttype (
id INTEGER PRIMARY KEY,
target_spec TEXT DEFAULT '');
CREATE TABLE IF NOT EXISTS runs (
id INTEGER PRIMARY KEY,
|
193
194
195
196
197
198
199
200
|
state TEXT DEFAULT 'new',
status TEXT DEFAULT 'n/a',
archive_type TEXT DEFAULT 'bup',
du INTEGER,
archive_path TEXT);
TRUNCATE archive_blocks, archive_allocations, extradat, metadat, access_log, tests, test_steps, test_data, test_rundat, archives, keys, runs, run_stats, test_meta, tasks_queue, archive_disks;
|
|
>
>
|
193
194
195
196
197
198
199
200
201
202
|
state TEXT DEFAULT 'new',
status TEXT DEFAULT 'n/a',
archive_type TEXT DEFAULT 'bup',
du INTEGER,
archive_path TEXT);
TRUNCATE archive_blocks, archive_allocations, extradat, metadat,
access_log, tests, test_steps, test_data, test_rundat, archives, runs,
run_stats, test_meta, tasks_queue, archive_disks;
|