maintenance/postgres/archives/patch-sites.sql

   1 CREATE SEQUENCE sites_site_id_seq;
   2 CREATE TABLE sites (
   3   site_id           INTEGER     NOT NULL    PRIMARY KEY DEFAULT nextval('sites_site_id_seq'),
   4   site_global_key   TEXT        NOT NULL,
   5   site_type         TEXT        NOT NULL,
   6   site_group        TEXT        NOT NULL,
   7   site_source       TEXT        NOT NULL,
   8   site_language     TEXT        NOT NULL,
   9   site_protocol     TEXT        NOT NULL,
  10   site_domain       TEXT        NOT NULL,
  11   site_data         TEXT        NOT NULL,
  12   site_forward      SMALLINT    NOT NULL,
  13   site_config       TEXT        NOT NULL
  14 );
  15 CREATE UNIQUE INDEX site_global_key ON sites (site_global_key);
  16 CREATE INDEX site_type ON sites (site_type);
  17 CREATE INDEX site_group ON sites (site_group);
  18 CREATE INDEX site_source ON sites (site_source);
  19 CREATE INDEX site_language ON sites (site_language);
  20 CREATE INDEX site_protocol ON sites (site_protocol);
  21 CREATE INDEX site_domain ON sites (site_domain);
  22 CREATE INDEX site_forward ON sites (site_forward);
  23
  24 CREATE TABLE site_identifiers (
  25   si_site   INTEGER NOT NULL,
  26   si_type   TEXT    NOT NULL,
  27   si_key    TEXT    NOT NULL
  28 );
  29 CREATE UNIQUE INDEX si_type_key ON site_identifiers (si_type, si_key);
  30 CREATE INDEX si_site ON site_identifiers (si_site);
  31 CREATE INDEX si_key ON site_identifiers (si_key);