summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPreston Cody <codeman@gentoo.org>2008-01-05 03:03:02 +0000
committerPreston Cody <codeman@gentoo.org>2008-01-05 03:03:02 +0000
commitdff3fba3021f128610600f536c50cc4b2df78fc7 (patch)
treeef115dd5ec74cef56c4aa51e6faeeb90a52b73a5
parentdependency is not required. (diff)
downloadscire-dff3fba3021f128610600f536c50cc4b2df78fc7.tar.gz
scire-dff3fba3021f128610600f536c50cc4b2df78fc7.tar.bz2
scire-dff3fba3021f128610600f536c50cc4b2df78fc7.zip
statusid needs to be a part of the key to avoid
duplicate entry collisions. svn path=/trunk/; revision=319
-rw-r--r--docs/scire.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/docs/scire.sql b/docs/scire.sql
index 53105d5..047e9e9 100644
--- a/docs/scire.sql
+++ b/docs/scire.sql
@@ -78,7 +78,7 @@ CREATE TABLE job_history (
eventtime TIMESTAMP NOT NULL DEFAULT NOW(),
statusid INT NOT NULL,
eventmsg VARCHAR(255),
- PRIMARY KEY (jobid, clientid, eventtime),
+ PRIMARY KEY (jobid, clientid, eventtime,statusid),
FOREIGN KEY (jobid) REFERENCES jobs.jobid,
FOREIGN KEY (clientid) REFERENCES clients.clientid,
FOREIGN KEY (statusid) REFERENCES jobs_status.statusid