CREATE DATABASE bard;

\c bard

CREATE TABLE pending_sessions (
  session_id text PRIMARY KEY,
  start_time bigint NOT NULL,
  app_name text NOT NULL,
  most_recent_event_time bigint NOT NULL,
  error_count integer NOT NULL DEFAULT 0,
  max_idle_time integer NOT NULL
);

CREATE TABLE funnels (
  id serial PRIMARY KEY,
  name text NOT NULL,
  created_at_ms bigint NOT NULL,
  last_modified_at_ms bigint NOT NULL,
  funnel JSONB NOT NULL,
  is_deleted bool NOT NULL
);