Changeset 23 for trunk/doc

Timestamp:

05/01/06 18:32:09 (4 years ago)

Author:

btrott

Message:

Implemented Job->replace_with with transactional support.

Files:

• trunk/doc/schema.sql (modified) (2 diffs)

trunk/doc/schema.sql

@@ -4 +4 @@
         arg             MEDIUMBLOB,
         uniqkey         VARCHAR(255) NULL,
-        insert_time     DATETIME,
-        run_after       DATETIME,
-        grabbed_until   DATETIME,
+        insert_time     INTEGER UNSIGNED,
+        run_after       INTEGER UNSIGNED,
+        grabbed_until   INTEGER UNSIGNED,
         priority        SMALLINT UNSIGNED,
         coalesce        VARCHAR(255),
@@ -13 +13 @@
 
 CREATE TABLE note (
-        jobid,
+        jobid           BIGINT UNSIGNED NOT NULL,
         notekey,
         value
-)
+);
 
 
 CREATE TABLE error (
-
-
-)
+        jobid           BIGINT UNSIGNED NOT NULL,
+        message         VARCHAR(255) NOT NULL
+);
 
 
 CREATE TABLE exitstatus (
-        jobid
-        status
-        completition_time
-        delete_after
-)
+        jobid           BIGINT UNSIGNED NOT NULL,
+        status          SMALLINT UNSIGNED,
+        completion_time INTEGER UNSIGNED,
+        delete_after    INTEGER UNSIGNED
+);