diff options
Diffstat (limited to 'steuermann/db.sql')
| -rw-r--r-- | steuermann/db.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/steuermann/db.sql b/steuermann/db.sql index 99bc752..bc35f62 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 sm_status ( +CREATE TABLE sm_status ( run VARCHAR(100), -- name of this run @@ -33,6 +33,8 @@ CREATE TABLE sm_status ( notes VARCHAR(1000), -- notes reported by the script + logs INTEGER, + FOREIGN KEY(run) REFERENCES runs(run) -- run name has to be in the run table ); |