diff options
| author |   Preston Cody <codeman@gentoo.org> | 2007-07-21 22:20:46 +0000 |
|---|---|---|
| committer | Preston Cody <codeman@gentoo.org> | 2007-07-21 22:20:46 +0000 |
| commit | 129ec6176718c60138cd40b26d24c0b13d9f3709 (patch) | |
| tree | 49576dc8740dc261557aadfbb9f6b4107e1c4cae /docs | |
| parent | adding back in the sequences DB code (diff) | |
| download | scire-129ec6176718c60138cd40b26d24c0b13d9f3709.tar.gz scire-129ec6176718c60138cd40b26d24c0b13d9f3709.tar.bz2 scire-129ec6176718c60138cd40b26d24c0b13d9f3709.zip | |
changing the dyn_tags table to use scriptid instead of jobid
fixing up the script creation section. still a work in progress.
svn path=/; revision=235
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/scire.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/docs/scire.sql b/docs/scire.sql index f449d95..7f05a6c 100644 --- a/docs/scire.sql +++ b/docs/scire.sql @@ -227,11 +227,11 @@ CREATE TABLE GLI_profiles ( DROP TABLE IF EXISTS dyn_tags; CREATE TABLE dyn_tags ( - jobid INT NOT NULL, + scriptid INT NOT NULL, tag VARCHAR(30) NOT NULL, tag_value VARCHAR(255), - PRIMARY KEY (jobid, tag), - FOREIGN KEY (jobid) REFERENCES jobs.jobid + PRIMARY KEY (scriptid, tag), + FOREIGN KEY (scriptid) REFERENCES scripts.scriptid ) ENGINE = MyISAM; drop table if exists modules; |