diff options
| author |   Preston Cody <codeman@gentoo.org> | 2006-05-29 22:52:36 +0000 |
|---|---|---|
| committer | Preston Cody <codeman@gentoo.org> | 2006-05-29 22:52:36 +0000 |
| commit | 7f9f89fa0b77dde8d4b4634b6e27f55636576908 (patch) | |
| tree | c1d0ea80f3e634b0205216dd44053012987f3263 /docs | |
| parent | still totally a work in progress but here's an (diff) | |
| download | scire-7f9f89fa0b77dde8d4b4634b6e27f55636576908.tar.gz scire-7f9f89fa0b77dde8d4b4634b6e27f55636576908.tar.bz2 scire-7f9f89fa0b77dde8d4b4634b6e27f55636576908.zip | |
small update
svn path=/; revision=87
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/scire.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/docs/scire.sql b/docs/scire.sql index c752fd4..076de02 100644 --- a/docs/scire.sql +++ b/docs/scire.sql @@ -80,10 +80,11 @@ CREATE TABLE rec_jobs ( end_period TIMESTAMP, permission INT NOT NULL, scriptid INT NOT NULL, - clients INT NOT NULL -- LIST!!! + clientid INT NOT NULL, FOREIGN KEY (permission) REFERENCES permissions.permid, FOREIGN KEY (scriptid) REFERENCES scripts.scriptid, - FOREIGN KEY (creator) REFERENCES users.userid + FOREIGN KEY (creator) REFERENCES users.userid, + FOREIGN KEY (clientid) REFERENCES clients.clientid ) ENGINE = MyISAM; DROP TABLE IF EXISTS scripts; |