/[scire]/trunk/docs/scire.sql
Gentoo

Diff of /trunk/docs/scire.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

Revision 337 Revision 338
102 FOREIGN KEY (groupid) REFERENCES groups.gropuid, 102 FOREIGN KEY (groupid) REFERENCES groups.gropuid,
103 FOREIGN KEY (clientid) REFERENCES clients.clientid 103 FOREIGN KEY (clientid) REFERENCES clients.clientid
104) ENGINE = MyISAM; 104) ENGINE = MyISAM;
105# Either clienid or groupid is required, if 1 is provided the other MUST be NULL 105# Either clienid or groupid is required, if 1 is provided the other MUST be NULL
106 106
107DROP TABLE IF EXISTS recurring_jobs_clients;
108CREATE TABLE recurring_jobs_clients (
109 jobid INT NOT NULL,
110 clientid INT,
111 groupid INT,
112 PRIMARY KEY (jobid, clientid, groupid),
113 FOREIGN KEY (jobid) REFERENCES jobs.jobid,
114 FOREIGN KEY (groupid) REFERENCES groups.gropuid,
115 FOREIGN KEY (clientid) REFERENCES clients.clientid
116) ENGINE = MyISAM;
117# Either clienid or groupid is required, if 1 is provided the other MUST be NULL
118
107DROP TABLE IF EXISTS job_conditions; 119DROP TABLE IF EXISTS job_conditions;
108CREATE TABLE job_conditions ( 120CREATE TABLE job_conditions (
109 jobid INT NOT NULL, 121 jobid INT NOT NULL,
110 job_dependency INT, 122 job_dependency INT,
111 deploy_time DATETIME, 123 deploy_time DATETIME,

Legend:
Removed from v.337  
changed lines
  Added in v.338

  ViewVC Help
Powered by ViewVC 1.1.20