maintenance/postgres/archives/patch-change_tag.sql

   1
   2 CREATE TABLE change_tag (
   3         ct_rc_id INTEGER NULL,
   4         ct_log_id INTEGER NULL,
   5         ct_rev_id INTEGER NULL,
   6         ct_tag TEXT NOT NULL,
   7         ct_params TEXT NULL
   8 );
   9 CREATE UNIQUE INDEX change_tag_rc_tag ON change_tag(ct_rc_id,ct_tag);
  10 CREATE UNIQUE INDEX change_tag_log_tag ON change_tag(ct_log_id,ct_tag);
  11 CREATE UNIQUE INDEX change_tag_rev_tag ON change_tag(ct_rev_id,ct_tag);
  12 CREATE INDEX change_tag_tag_id ON change_tag(ct_tag,ct_rc_id,ct_rev_id,ct_log_id);
  13
  14
  15 CREATE TABLE tag_summary (
  16         ts_rc_id INTEGER NULL,
  17         ts_log_id INTEGER NULL,
  18         ts_rev_id INTEGER NULL,
  19         ts_tags TEXT NOT NULL
  20 );
  21 CREATE UNIQUE INDEX tag_summary_rc_id ON tag_summary(ts_rc_id);
  22 CREATE UNIQUE INDEX tag_summary_log_id ON tag_summary(ts_log_id);
  23 CREATE UNIQUE INDEX tag_summary_rev_id ON tag_summary(ts_rev_id);
  24
  25
  26 CREATE TABLE valid_tag (
  27         vt_tag TEXT NOT NULL PRIMARY KEY
  28 );