devops/postgres/upgrade/0.0.5.9.sql

   1 create table public.node_stories (
   2   id SERIAL,
   3   node_id INTEGER NOT NULL,
   4   archive jsonb DEFAULT '{}'::jsonb NOT NULL,
   5   PRIMARY KEY (id),
   6   FOREIGN KEY (node_id) REFERENCES public.nodes(id) ON DELETE CASCADE
   7 );
   8 ALTER TABLE public.node_stories OWNER TO gargantua;
   9
  10 CREATE UNIQUE INDEX ON public.node_stories USING btree (node_id);