Split down patch-comment-table.sql
[lhc/web/wiklou.git] / maintenance / archives / patch-comment-table.sql
1 --
2 -- patch-comment-table.sql
3 --
4 -- T166732. Add a `comment` table.
5
6 CREATE TABLE /*_*/comment (
7 comment_id bigint unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
8 comment_hash INT NOT NULL,
9 comment_text BLOB NOT NULL,
10 comment_data BLOB
11 ) /*$wgDBTableOptions*/;
12 CREATE INDEX /*i*/comment_hash ON /*_*/comment (comment_hash);