#!/bin/bash

sudo su postgres <<'EOF'
psql -c 'DROP SCHEMA public;' stagecraft
psql -c 'CREATE SCHEMA public;' stagecraft
psql -c 'ALTER SCHEMA public OWNER TO stagecraft;' stagecraft
EOF

Add script to drop all stagecraft tables
Add script to drop all stagecraft tables

Drop the entire 'public' schema and then recreate it.
