2 DROP SCHEMA offline CASCADE;
8 CREATE TABLE offline.script (
10 session TEXT NOT NULL,
11 requestor INTEGER NOT NULL,
12 create_time INTEGER NOT NULL,
13 workstation TEXT NOT NULL,
14 logfile TEXT NOT NULL,
15 time_delta INTEGER NOT NULL DEFAULT 0,
16 count INTEGER NOT NULL DEFAULT 0
18 CREATE INDEX offline_script_pkey ON offline.script (id);
19 CREATE INDEX offline_script_ws ON offline.script (workstation);
20 CREATE INDEX offline_script_session ON offline.script (session);
23 CREATE TABLE offline.session (
27 creator INTEGER NOT NULL,
28 create_time INTEGER NOT NULL,
29 in_process INTEGER NOT NULL DEFAULT 0,
32 num_complete INTEGER NOT NULL DEFAULT 0
34 CREATE INDEX offline_session_pkey ON offline.session (key);
35 CREATE INDEX offline_session_org ON offline.session (org);
36 CREATE INDEX offline_session_creation ON offline.session (create_time);