maintenance/postgres/archives/patch-comment-table.sql

   1 --
   2 -- patch-comment-table.sql
   3 --
   4 -- T166732. Add a `comment` table
   5
   6 CREATE SEQUENCE comment_comment_id_seq;
   7 CREATE TABLE comment (
   8         comment_id   INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('comment_comment_id_seq'),
   9         comment_hash INTEGER NOT NULL,
  10         comment_text TEXT    NOT NULL,
  11         comment_data TEXT
  12 );
  13 CREATE INDEX comment_hash ON comment (comment_hash);