1 CREATE SEQUENCE ip_changes_ipc_rev_id_seq
;
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 ''
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
);