40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
-
-
-
+
+
+
+
+
+
+
|
DROP TABLE IF EXISTS archives;
DROP TABLE IF EXISTS session_vars;
DROP TABLE IF EXISTS sessions;
DROP TABLE IF EXISTS tags;
DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS webviews;
DROP TABLE IF EXISTS area_tags;
DROP TABLE IF EXISTS users_webviews;
DROP TABLE IF EXISTS users_webviews;
DROP TABLE IF EXISTS base_paths;
DROP TABLE IF EXISTS area_owners;
DROP TABLE IF EXISTS shared_user_views;
DROP TABLE IF EXISTS cctrl_info;
DROP TABLE IF EXISTS cctrl_config;
DROP TABLE IF EXISTS platforms;
CREATE TABLE IF NOT EXISTS session_vars (
id SERIAL PRIMARY KEY,
session_id INTEGER,
page TEXT,
key TEXT,
|
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
|
-
+
|
CREATE TABLE IF NOT EXISTS area_tags (
id SERIAL PRIMARY KEY,
tag_id INTEGER DEFAULT 0,
area_id INTEGER DEFAULT 0,
CONSTRAINT areatagconstraint UNIQUE (tag_id, area_id));
CREATE VIEW area_tag_view as
select a.id as aid, t.id as tid,area_name,tag_name from areas as a inner join area_tags as at on at.area_id = a.id
select a.id as aid, t.id as tid,area_name,tag_name,area_path from areas as a inner join area_tags as at on at.area_id = a.id
inner join tags as t on t.id = at.tag_id ;
INSERT INTO areas (id,area_name,area_path) VALUES (0,'local','.');
CREATE TABLE IF NOT EXISTS ttype (
id SERIAL PRIMARY KEY,
target_spec TEXT DEFAULT '');
|
100
101
102
103
104
105
106
107
108
109
110
111
112
113
|
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
|
+
+
+
+
+
+
+
+
|
event_time INTEGER DEFAULT extract(epoch from now()),
comment TEXT DEFAULT '',
fail_count INTEGER DEFAULT 0,
pass_count INTEGER DEFAULT 0,
last_update INTEGER DEFAULT extract(epoch from now()),
area_id INTEGER DEFAULT 0,
CONSTRAINT runsconstraint UNIQUE (target,ttype_id,run_name, area_id));
create Table if not exists change_triggers (
id SERIAL PRIMARY KEY,
target TEXT NOT NULL,
area TEXT NOT NULL,
iteration INTEGER NOT NULL,
iteration_timestamp TIMESTAMP WITHOUT TIME ZONE DEFAULT now(),
reason TEXT Not null);
CREATE TABLE IF NOT EXISTS run_stats (
id SERIAL PRIMARY KEY,
run_id INTEGER,
state TEXT,
status TEXT,
count INTEGER,
|
252
253
254
255
256
257
258
259
260
261
262
263
264
265
|
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
|
+
|
CREATE TABLE IF NOT EXISTS users(
id SERIAL PRIMARY KEY ,
username TEXT NOT NULL,
fullname TEXT NOT NULL,
email TEXT NOT NULL,
default_view TEXT default '',
is_admin boolean default 'f',
deleted INTEGER default 0
);
CREATE TABLE IF NOT EXISTS base_paths(
id SERIAL PRIMARY KEY ,
path TEXT NOT NULL,
deleted INTEGER default 0
|
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
|
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
|
+
-
-
-
-
-
+
+
+
+
+
+
+
-
|
owner_id INTEGER NOT NULL,
name TEXT NOT NULL,
ttype_id INTEGER DEFAULT 0,
view_specifics TEXT ,
col TEXT NOT NULL,
row TEXT NOT NULL,
public INTEGER DEFAULT 0,
search_patt TEXT default '.*',
deleted INTEGER default 0
);
CREATE TABLE IF NOT EXISTS users_webviews(
id SERIAL PRIMARY KEY ,
user_id INTEGER NOT NULL,
webview_id INTEGER NOT NULL,
deleted INTEGER default 0,
searchpattern TEXT Default '',
web_page TEXT Default '',
user_id INTEGER NOT NULL,
webview_id INTEGER NOT NULL,
deleted INTEGER default 0,
searchpattern TEXT Default '',
web_page TEXT Default '',
is_default boolean default 'f',
other_search_data TEXT Default ''
);
CREATE TABLE IF NOT EXISTS cctrl_info(
id SERIAL PRIMARY KEY ,
user_id INTEGER NOT NULL,
input TEXT Default '',
result_file TEXT Default NULL,
chksum TEXT
);
CREATE TABLE IF NOT EXISTS cctrl_config(
id SERIAL PRIMARY KEY ,
area_type Text,
metadata text default '',
cmd TEXT
);
CREATE TABLE IF NOT EXISTS platforms(
id SERIAL PRIMARY KEY ,
name Text
);
|