90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
run_id INTEGER DEFAULT 0,
CONSTRAINT areatagconstraint UNIQUE (tag_id, run_id));
CREATE VIEW area_tag_view as
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 '');
|
>
>
>
>
>
|
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
run_id INTEGER DEFAULT 0,
CONSTRAINT areatagconstraint UNIQUE (tag_id, run_id));
CREATE VIEW area_tag_view as
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 ;
CREATE VIEW run_tag_view as
select r.id as rid, t.id as tid,tag_name from runs as r inner join run_tags as rt on rt.run_id = r.id
inner join tags as t on t.id = rt.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 '');
|
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
owner TEXT DEFAULT '',
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,
|
>
|
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
owner TEXT DEFAULT '',
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,
publish_time INTEGER default date_part('epoch'::text, now()),
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,
|
311
312
313
314
315
316
317
318
319
320
321
322
323
324
|
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,
|
>
>
>
>
>
>
>
|
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
|
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 flexviews(
id SERIAL PRIMARY KEY ,
public INTEGER DEFAULT 0,
attributes TEXT NOT NULL,
name TEXT NOT NULL,
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,
|