Skip to content

Instantly share code, notes, and snippets.

@VinceMacBuche
Created August 28, 2014 14:44
Show Gist options
  • Save VinceMacBuche/41b72c2bf63bc55c442d to your computer and use it in GitHub Desktop.
Save VinceMacBuche/41b72c2bf63bc55c442d to your computer and use it in GitHub Desktop.
missing tables :(
CREATE TABLE ReportsExecution (
nodeId text NOT NULL
, date timestamp with time zone NOT NULL
, complete boolean NOT NULL
, PRIMARY KEY(nodeId, date)
);
CREATE INDEX reportsexecution_date_idx ON ReportsExecution (date);
CREATE TABLE StatusUpdate (
key text PRIMARY KEY
, lastId bigint NOT NULL
, date timestamp with time zone NOT NULL
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment