maintenance/postgres/archives/patch-change_tag_def.sql

   1 -- Table defining tag names for IDs. Also stores hit counts to avoid expensive queries on change_tag
   2
   3 CREATE SEQUENCE change_tag_def_ctd_id_seq;
   4 CREATE TABLE change_tag_def (
   5     ctd_id int NOT NULL PRIMARY KEY DEFAULT nextval('change_tag_def_ctd_id_seq'),
   6     ctd_name TEXT NOT NULL,
   7     ctd_user_defined SMALLINT NOT NULL DEFAULT 0,
   8     ctd_count INTEGER NOT NULL DEFAULT 0
   9 );
  10 ALTER SEQUENCE change_tag_def_ctd_id_seq OWNED BY change_tag_def.ctd_id;
  11
  12 CREATE UNIQUE INDEX ctd_name ON change_tag_def (ctd_name);
  13 CREATE INDEX ctd_count ON change_tag_def (ctd_count);
  14 CREATE INDEX ctd_user_defined ON change_tag_def (ctd_user_defined);