aboutsummaryrefslogtreecommitdiff
path: root/steuermann
diff options
context:
space:
mode:
authorsienkiew <sienkiew@d34015c8-bcbb-4646-8ac8-8ba5febf221d>2013-08-15 10:09:53 -0400
committersienkiew <sienkiew@d34015c8-bcbb-4646-8ac8-8ba5febf221d>2013-08-15 10:09:53 -0400
commitb55ca4d2cbe3527f9cef3498e60d5514db941e80 (patch)
treea445787cd7528f81d2b896b26a25e688102282ea /steuermann
parenta4b5a4157c61ea4a106c3d6ab73b26b24052250a (diff)
downloadsteuermann-b55ca4d2cbe3527f9cef3498e60d5514db941e80.tar.gz
add count of errors to list of runs
git-svn-id: https://svn.stsci.edu/svn/ssb/etal/steuermann/trunk@1017 d34015c8-bcbb-4646-8ac8-8ba5febf221d
Diffstat (limited to 'steuermann')
-rw-r--r--steuermann/db.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/steuermann/db.sql b/steuermann/db.sql
index bc35f62..919ab6a 100644
--- a/steuermann/db.sql
+++ b/steuermann/db.sql
@@ -46,7 +46,8 @@ 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_time VARCHAR(26)
+ create_time VARCHAR(26),
+ errors int
);
CREATE UNIQUE INDEX sm_runs_idx1 ON sm_runs(run);