1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
-- The table 'status' contains a record for each command in a run.
-- Before we start running anything, we insert a record for every
-- command in the test run. The initial status is 'S'.
CREATE TABLE sm_status (
run VARCHAR(100),
-- name of this run
host VARCHAR,
tablename VARCHAR,
cmd VARCHAR,
-- name of the command (node)
depth INTEGER,
-- depth in the tree of this node (used to create report tables)
status VARCHAR(5),
-- N = not started
-- R = started, not finished
-- S = skipped
-- P = prereq not satisfied, so not attempted
-- E = error internal to steuermann
-- 0-255 = exit code
start_time VARCHAR(30),
end_time VARCHAR(30),
-- times initially blank
-- YYYY-MM-DD HH:MM:SS.SSS
-- (space for resolution to nanosecond is a bit extreme)
-- a log file name is implicit in the run/host/tablename/cmd tuple
notes VARCHAR(1000),
-- notes reported by the script
FOREIGN KEY(run) REFERENCES runs(run)
-- run name has to be in the run table
);
create unique index sm_status_idx1 on sm_status ( run, host, tablename, cmd );
-- table lists all run names in the system
CREATE TABLE sm_runs (
run VARCHAR(100)
);
CREATE UNIQUE INDEX sm_runs_idx1 ON sm_runs(run);
|
