#!/bin/sh
slonik << _END_
#
# Define cluster namespace and node connection information
#
cluster name = gb;
node 1 admin conninfo = 'dbname=gb host=localhost port=5434 user=postgres';
node 2 admin conninfo = 'dbname=gb host=localhost port=5430 user=postgres';

create set (id=1, origin=1, comment='gb tables');
echo 'Set created';
set add table (set id=1, origin=1, id=1, full qualified name = 'public.issues', comment='Issues table');
set add table (set id=1, origin=1, id=2, full qualified name = 'public.articles');
set add table (set id=1, origin=1, id=3, full qualified name = 'public.arttext');
set add table (set id=1, origin=1, id=4, full qualified name = 'public.contrib');
set add table (set id=1, origin=1, id=5, full qualified name = 'public.keywords');
set add table (set id=1, origin=1, id=6, full qualified name = 'public.sqlbase');
set add table (set id=1, origin=1, id=7, full qualified name = 'public.sqlkw');
set add table (set id=1, origin=1, id=8, full qualified name = 'public.whoall');
set add table (set id=1, origin=1, id=9, full qualified name = 'public.artfile');
echo 'set 1 of gb tables created';

_END_