@@ -239,10 +239,32 @@ 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, @@ -259,12 +281,34 @@ 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 '' + 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;