diff options
| -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; |