Created
September 22, 2010 03:29
-
-
Save kga/591087 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE funcmap ( | |
| funcid INTEGER PRIMARY KEY AUTOINCREMENT, | |
| funcname VARCHAR(255) NOT NULL, | |
| UNIQUE(funcname) | |
| ); | |
| CREATE TABLE job ( | |
| jobid INTEGER PRIMARY KEY AUTOINCREMENT, | |
| funcid INTEGER UNSIGNED NOT NULL, | |
| arg MEDIUMBLOB, | |
| uniqkey VARCHAR(255) NULL, | |
| insert_time INTEGER UNSIGNED, | |
| run_after INTEGER UNSIGNED NOT NULL, | |
| grabbed_until INTEGER UNSIGNED NOT NULL, | |
| priority SMALLINT UNSIGNED, | |
| coalesce VARCHAR(255), | |
| UNIQUE(funcid,uniqkey) | |
| ); | |
| CREATE TABLE error ( | |
| error_time INTEGER UNSIGNED NOT NULL, | |
| jobid INTEGER NOT NULL, | |
| message VARCHAR(255) NOT NULL, | |
| funcid INT UNSIGNED NOT NULL DEFAULT 0 | |
| ); | |
| CREATE TABLE exitstatus ( | |
| jobid INTEGER PRIMARY KEY NOT NULL, | |
| funcid INT UNSIGNED NOT NULL DEFAULT 0, | |
| status SMALLINT UNSIGNED, | |
| completion_time INTEGER UNSIGNED, | |
| delete_after INTEGER UNSIGNED | |
| ); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment