summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPreston Cody <codeman@gentoo.org>2008-01-02 01:11:48 +0000
committerPreston Cody <codeman@gentoo.org>2008-01-02 01:11:48 +0000
commit1fd9ef9846157cbf778b34ad542fa48a2c53827c (patch)
tree7705be6edd2b77cef170bedaabc58a3c5c351ac7
parentget rid of that dependency thing. (diff)
downloadscire-1fd9ef9846157cbf778b34ad542fa48a2c53827c.tar.gz
scire-1fd9ef9846157cbf778b34ad542fa48a2c53827c.tar.bz2
scire-1fd9ef9846157cbf778b34ad542fa48a2c53827c.zip
dependency is not required.
changed timestamps to datetimes. svn path=/trunk/; revision=309
-rw-r--r--docs/scire.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/docs/scire.sql b/docs/scire.sql
index d9a0c37..53105d5 100644
--- a/docs/scire.sql
+++ b/docs/scire.sql
@@ -107,13 +107,13 @@ CREATE TABLE jobs_clients (
DROP TABLE IF EXISTS job_conditions;
CREATE TABLE job_conditions (
jobid INT NOT NULL,
- job_dependency INT NOT NULL,
- deploy_time TIMESTAMP,
- expiration_time TIMESTAMP,
+ job_dependency INT,
+ deploy_time DATETIME,
+ expiration_time DATETIME,
run_schedule VARCHAR(255), #a cron-like string showing the schedule to run. min interval of 1 minute.
validity_period INT, # how many minutes will the job be available
last_run INT,
- last_run_date TIMESTAMP,
+ last_run_date DATETIME,
# conditions here (TBD)
# other types of dependencies:
# right now time and proccess (other jobs)