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

Diff of /trunk/docs/scire.sql

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

Revision 308 Revision 309
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 job_conditions; 107DROP TABLE IF EXISTS job_conditions;
108CREATE TABLE job_conditions ( 108CREATE TABLE job_conditions (
109 jobid INT NOT NULL, 109 jobid INT NOT NULL,
110 job_dependency INT NOT NULL, 110 job_dependency INT,
111 deploy_time TIMESTAMP, 111 deploy_time DATETIME,
112 expiration_time TIMESTAMP, 112 expiration_time DATETIME,
113 run_schedule VARCHAR(255), #a cron-like string showing the schedule to run. min interval of 1 minute. 113 run_schedule VARCHAR(255), #a cron-like string showing the schedule to run. min interval of 1 minute.
114 validity_period INT, # how many minutes will the job be available 114 validity_period INT, # how many minutes will the job be available
115 last_run INT, 115 last_run INT,
116 last_run_date TIMESTAMP, 116 last_run_date DATETIME,
117# conditions here (TBD) 117# conditions here (TBD)
118# other types of dependencies: 118# other types of dependencies:
119# right now time and proccess (other jobs) 119# right now time and proccess (other jobs)
120# might also include data (partition full?) 120# might also include data (partition full?)
121 121

Legend:
Removed from v.308  
changed lines
  Added in v.309

  ViewVC Help
Powered by ViewVC 1.1.20