summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPreston Cody <codeman@gentoo.org>2007-07-22 21:58:08 +0000
committerPreston Cody <codeman@gentoo.org>2007-07-22 21:58:08 +0000
commit80a4c0e454a8f3dcadbb5a569121906b73f4c5bf (patch)
treee227f734a7d3540f2eb0637658696ff3cdc719d7
parentchanging the dyn_tags table to use scriptid instead of jobid (diff)
downloadscire-80a4c0e454a8f3dcadbb5a569121906b73f4c5bf.tar.gz
scire-80a4c0e454a8f3dcadbb5a569121906b73f4c5bf.tar.bz2
scire-80a4c0e454a8f3dcadbb5a569121906b73f4c5bf.zip
added sequences for jobs and scripts.
make jobs and scripts not auto_increment anymore. this will require those who have the tables made to drop and rebuild. svn path=/; revision=236
-rw-r--r--docs/scire.sql13
1 files changed, 11 insertions, 2 deletions
diff --git a/docs/scire.sql b/docs/scire.sql
index 7f05a6c..97aa753 100644
--- a/docs/scire.sql
+++ b/docs/scire.sql
@@ -57,7 +57,7 @@ CREATE TABLE permissions (
DROP TABLE IF EXISTS jobs;
CREATE TABLE jobs (
- jobid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
+ jobid INT NOT NULL PRIMARY KEY,
priority INT NOT NULL DEFAULT 0,
created TIMESTAMP NOT NULL DEFAULT NOW(),
creator INT NOT NULL,
@@ -126,7 +126,7 @@ CREATE TABLE job_conditions (
DROP TABLE IF EXISTS scripts;
CREATE TABLE scripts (
- scriptid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
+ scriptid INT NOT NULL PRIMARY KEY,
name VARCHAR(128) NOT NULL,
description VARCHAR(255),
location VARCHAR(255),
@@ -483,6 +483,7 @@ CREATE TABLE gacl_axo_groups_map (
);
+#########SEQUENCES (both PHPGACL and scire)##########
DROP TABLE IF EXISTS `gacl_acl_seq`;
CREATE TABLE `gacl_acl_seq` (
`id` int(11) NOT NULL default '0'
@@ -529,3 +530,11 @@ CREATE TABLE `gacl_axo_seq` (
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+DROP TABLE IF EXISTS `jobs_seq`;
+CREATE TABLE `jobs_seq` (
+ `id` int(11) NOT NULL default '0'
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+DROP TABLE IF EXISTS `scripts_seq`;
+CREATE TABLE `scripts_seq` (
+ `id` int(11) NOT NULL default '0'
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;