#!/bin/sh

/usr/local/bin/dropdb okihierarchy
/usr/local/bin/createdb okihierarchy
/usr/local/bin/psql -c "create table Hierarchies ( key varchar ( 128 ) primary key, name varchar ( 256 ) , description varchar ( 1024 ) ) ;" okihierarchy
/usr/local/bin/psql -c "create table Nodes ( key varchar( 128 ), hierarchy varchar ( 128 ), name varchar( 256 ) ) ;" okihierarchy
/usr/local/bin/psql -c "create table Links ( hierarchy varchar ( 128 ), parent varchar ( 128 ), child varchar ( 128 ) ) ;" okihierarchy