cas.sql | 16 +++++++++++----- 1 file changed, 11 insertions(+), 5 deletions(-)
New commits: commit d6d04e7de0e22d11d70cb39f44e0c300ce5d9716 Author: Adam Stokes adam.stokes@gmail.com Date: Wed Mar 18 13:16:26 2009 -0400
- update sql
diff --git a/cas.sql b/cas.sql index 7017d37..ef3aa33 100644 --- a/cas.sql +++ b/cas.sql @@ -1,7 +1,13 @@ +-- +-- cas jobs +-- CREATE TABLE cas_jobs ( - 'ID' PRIMARY AUTO_INCREMENT INTEGER, - 'PATH' TEXT, - 'COREFILEPATH' TEXT, - 'DEBUGPATH' TEXT, - 'CREATION_TIME' DATETIME CURRENT_TIMESTAMP + id MEDIUMINT NOT NULL AUTO_INCREMENT, + submitter VARCHAR(255), + creation TIMESTAMP DEFAULT CURRENT_TIMESTAMP, + modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP, + jobpath TEXT, + corefile TEXT, + debug TEXT, + PRIMARY KEY (id) )