diff options
author | 2008-01-06 21:59:21 +0000 | |
---|---|---|
committer | 2008-01-06 21:59:21 +0000 | |
commit | 2726871de34bf4ca3b31699935eac179c30f45f3 (patch) | |
tree | cd4d76e8f3b0f7bb77f972c17756fc20a73111a5 /docs | |
parent | statusid needs to be a part of the key to avoid (diff) | |
download | scire-2726871de34bf4ca3b31699935eac179c30f45f3.tar.gz scire-2726871de34bf4ca3b31699935eac179c30f45f3.tar.bz2 scire-2726871de34bf4ca3b31699935eac179c30f45f3.zip |
adding recurring_jobs_clients to hold the information for recurring jobs.
svn path=/trunk/; revision=338
Diffstat (limited to 'docs')
-rw-r--r-- | docs/scire.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/docs/scire.sql b/docs/scire.sql index 047e9e9..6bd41ba 100644 --- a/docs/scire.sql +++ b/docs/scire.sql @@ -104,6 +104,18 @@ CREATE TABLE jobs_clients ( ) ENGINE = MyISAM; # Either clienid or groupid is required, if 1 is provided the other MUST be NULL +DROP TABLE IF EXISTS recurring_jobs_clients; +CREATE TABLE recurring_jobs_clients ( + jobid INT NOT NULL, + clientid INT, + groupid INT, + PRIMARY KEY (jobid, clientid, groupid), + FOREIGN KEY (jobid) REFERENCES jobs.jobid, + FOREIGN KEY (groupid) REFERENCES groups.gropuid, + FOREIGN KEY (clientid) REFERENCES clients.clientid +) ENGINE = MyISAM; +# Either clienid or groupid is required, if 1 is provided the other MUST be NULL + DROP TABLE IF EXISTS job_conditions; CREATE TABLE job_conditions ( jobid INT NOT NULL, |