diff options
Diffstat (limited to 'steuermann/db.sql')
| -rw-r--r-- | steuermann/db.sql | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/steuermann/db.sql b/steuermann/db.sql index dd6a569..b6d2ae6 100644 --- a/steuermann/db.sql +++ b/steuermann/db.sql @@ -2,7 +2,7 @@ -- Before we start running anything, we insert a record for every -- command in the test run. The initial status is 'S'. -CREATE TABLE status ( +CREATE TABLE sm_status ( run VARCHAR(100), -- name of this run @@ -19,6 +19,7 @@ CREATE TABLE status ( -- 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), @@ -37,13 +38,13 @@ CREATE TABLE status ( ); -create unique index idx_status_1 on status ( run, host, tablename, cmd ); +create unique index sm_status_idx1 on sm_status ( run, host, tablename, cmd ); -- table lists all run names in the system -CREATE TABLE runs ( +CREATE TABLE sm_runs ( run VARCHAR(100) ); -CREATE UNIQUE INDEX idx_runs_run ON runs(run); +CREATE UNIQUE INDEX sm_runs_idx1 ON sm_runs(run); |