drop config param on queueing

[mubot4fb/mubot4fb.git] / mubot.mysql

diff --git a/mubot.mysql b/mubot.mysql
index f670c99..f286a31 100644 (file)
--- a/mubot.mysql
+++ b/mubot.mysql
@@ -1,13 +1,13 @@
 CREATE TABLE posts (
-       id INT PRIMARY KEY AUTO_INCREMENT,
+       id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
        submitter VARCHAR(32) NOT NULL,
        submitter_type INTEGER NOT NULL default 1,
        fb_post_id BIGINT UNSIGNED UNIQUE NOT NULL,
-       uri VARCHAR(512) NOT NULL,
+       uri VARCHAR(1024) NOT NULL,
        prefix VARCHAR(512) NOT NULL,
-       suffix VARCHAR(512) NOT NULL,
-       scheme VARCHAR(512) NOT NULL,
-       path VARCHAR(512) NOT NULL,
+       comment VARCHAR(1024) NOT NULL,
+       scheme VARCHAR(1024) NOT NULL,
+       path VARCHAR(1024) NOT NULL,
        post_time BIGINT UNSIGNED NOT NULL
 ) ENGINE = innodb DEFAULT CHARSET utf8;