237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
|
id SERIAL PRIMARY KEY ,
username TEXT NOT NULL,
fullname TEXT NOT NULL,
email TEXT NOT NULL,
default_view TEXT default '',
deleted INTEGER default 0
);
CREATE TABLE IF NOT EXISTS webviews(
id SERIAL PRIMARY KEY ,
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,
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 ''
);
-- 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;
|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
|
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
|
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
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
|
id SERIAL PRIMARY KEY ,
username TEXT NOT NULL,
fullname TEXT NOT NULL,
email TEXT NOT NULL,
default_view TEXT default '',
deleted INTEGER default 0
);
CREATE TABLE IF NOT EXISTS base_paths(
id SERIAL PRIMARY KEY ,
path TEXT NOT NULL,
deleted INTEGER default 0
);
CREATE TABLE IF NOT EXISTS area_owners(
id SERIAL PRIMARY KEY ,
user_id INTEGER,
base_path_id INTEGER,
deleted INTEGER default 0
);
CREATE TABLE IF NOT EXISTS shared_user_views(
id SERIAL PRIMARY KEY ,
user_id INTEGER,
view_id INTEGER,
deleted INTEGER default 0
);
CREATE TABLE IF NOT EXISTS webviews(
id SERIAL PRIMARY KEY ,
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,
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 '',
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,
cmd TEXT
);
CREATE TABLE IF NOT EXISTS platforms(
id SERIAL PRIMARY KEY ,
name 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;
|