--
-- patch-comment-table.sql
--
--- T166732. Add a `comment` table, and temporary tables to reference it.
+-- T166732. Add a `comment` table
CREATE SEQUENCE comment_comment_id_seq;
CREATE TABLE comment (
comment_data TEXT
);
CREATE INDEX comment_hash ON comment (comment_hash);
-
-CREATE TABLE revision_comment_temp (
- revcomment_rev INTEGER NOT NULL,
- revcomment_comment_id INTEGER NOT NULL,
- PRIMARY KEY (revcomment_rev, revcomment_comment_id)
-);
-CREATE UNIQUE INDEX revcomment_rev ON revision_comment_temp (revcomment_rev);
-
-CREATE TABLE image_comment_temp (
- imgcomment_name TEXT NOT NULL,
- imgcomment_description_id INTEGER NOT NULL,
- PRIMARY KEY (imgcomment_name, imgcomment_description_id)
-);
-CREATE UNIQUE INDEX imgcomment_name ON image_comment_temp (imgcomment_name);