maintenance/postgres/archives/patch-ip_changes.sql

   1 CREATE SEQUENCE ip_changes_ipc_rev_id_seq;
   2
   3 CREATE TABLE ip_changes (
   4   ipc_rev_id        INTEGER PRIMARY KEY NOT NULL DEFAULT nextval('ip_changes_ipc_rev_id_seq'),
   5   ipc_rev_timestamp TIMESTAMPTZ NOT NULL,
   6   ipc_hex           BYTEA NOT NULL DEFAULT ''
   7 );
   8
   9 CREATE INDEX ipc_rev_timestamp ON ip_changes (ipc_rev_timestamp);
  10 CREATE INDEX ipc_hex_time ON ip_changes (ipc_hex,ipc_rev_timestamp);