table for queue

diff --git a/queue.mysql b/queue.mysql
new file mode 100644 (file)
index 0000000..7106f54
--- /dev/null
+++ b/queue.mysql
@@ -0,0 +1,10 @@
+CREATE TABLE job (
+        id           int(10) unsigned NOT NULL auto_increment,
+        func         varchar(255)     NOT NULL,
+        arg          MEDIUMBLOB,
+        enqueue_time DATETIME         NOT NULL,
+        primary key ( id )
+) ENGINE=InnoDB;
+
+create index func_idx on job(func);
+