CREATE TABLE IF NOT EXISTS airship_tree_updates (
treeupdateid BIGSERIAL PRIMARY KEY,
channel TEXT,
channelupdateid BIGINT,
data TEXT,
merkleroot TEXT,
created TIMESTAMP DEFAULT NOW(),
modified TIMESTAMP DEFAULT NOW()
);
CREATE INDEX ON airship_tree_updates (channel);
CREATE INDEX ON airship_tree_updates (channelupdateid);
CREATE UNIQUE INDEX ON airship_tree_updates (channel, channelupdateid);
CREATE INDEX ON airship_tree_updates (merkleroot);
DROP TRIGGER IF EXISTS update_airship_tree_updates_modtime ON airship_tree_updates;
CREATE TRIGGER update_airship_tree_updates_modtime
BEFORE UPDATE ON airship_tree_updates
FOR EACH ROW EXECUTE PROCEDURE update_modtime();
|
Download
