2 id INT PRIMARY KEY AUTO_INCREMENT,
3 submitter VARCHAR(32) NOT NULL,
4 submitter_type INTEGER NOT NULL default 1,
5 fb_post_id BIGINT UNSIGNED UNIQUE NOT NULL,
6 uri VARCHAR(1024) NOT NULL,
7 prefix VARCHAR(512) NOT NULL,
8 comment VARCHAR(1024) NOT NULL,
9 scheme VARCHAR(1024) NOT NULL,
10 path VARCHAR(1024) NOT NULL,
11 post_time BIGINT UNSIGNED NOT NULL
12 ) ENGINE = innodb DEFAULT CHARSET utf8;
14 create index posts_fb_post_id_idx on posts(fb_post_id);
15 create index posts_post_time_idx on posts(post_time);
16 create index submitter_idx on posts(submitter);
17 create index uri_idx on posts(uri);
18 create index path_idx on posts(path);