1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE IF NOT EXISTS keys (
id INTEGER PRIMARY KEY,
fieldname TEXT,
fieldtype TEXT,
CONSTRAINT keyconstraint UNIQUE (fieldname));
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));
|
|
|
|
|
|
|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
-- CREATE TABLE IF NOT EXISTS keys (
-- id INTEGER PRIMARY KEY,
-- fieldname TEXT,
-- fieldtype TEXT,
-- CONSTRAINT keyconstraint UNIQUE (fieldname));
DROP TABLE IF EXISTS areas;
DROP TABLE IF EXISTS ttype;
DROP TABLE IF EXISTS runs;
DROP TABLE IF EXISTS run_stats;
DROP TABLE IF EXISTS test_meta;
DROP TABLE IF EXISTS tasks_queue;
DROP TABLE IF EXISTS archive_disks;
DROP TABLE IF EXISTS archive_blocks;
DROP TABLE IF EXISTS archive_allocations;
DROP TABLE IF EXISTS extradat;
DROP TABLE IF EXISTS metadat;
DROP TABLE IF EXISTS access_log;
DROP TABLE IF EXISTS tests;
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));
|
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
|
CREATE TABLE IF NOT EXISTS access_log (
id INTEGER PRIMARY KEY,
"user" TEXT,
accessed TIMESTAMP,
args TEXT);
CREATE TABLE tests (
id INTEGER PRIMARY KEY,
run_id INTEGER DEFAULT -1,
testname TEXT DEFAULT 'noname',
host TEXT DEFAULT 'n/a',
cpuload REAL DEFAULT -1,
diskfree INTEGER DEFAULT -1,
uname TEXT DEFAULT 'n/a',
|
|
|
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
|
CREATE TABLE IF NOT EXISTS access_log (
id INTEGER PRIMARY KEY,
"user" TEXT,
accessed TIMESTAMP,
args TEXT);
CREATE TABLE IF NOT EXISTS tests (
id INTEGER PRIMARY KEY,
run_id INTEGER DEFAULT -1,
testname TEXT DEFAULT 'noname',
host TEXT DEFAULT 'n/a',
cpuload REAL DEFAULT -1,
diskfree INTEGER DEFAULT -1,
uname TEXT DEFAULT 'n/a',
|