#!/bin/bash
RAILS_ENV=development bundle exec rake db:drop

RAILS_ENV=development bundle exec rake redmine:install app_title="VNCproject Demo App" REDMINE_LANG=en

RAILS_ENV=development bundle exec rake db:migrate

psql vncproject-dump;
ALTER SCHEMA public RENAME TO public_reusable_default_schema;
\q

pg_dump -O vncproject-dump > today-dump.sql
cp today-dump.sql db/dumps/en_vncproject.sql
rm today-dump.sql

psql vncproject-dump;
ALTER SCHEMA public_reusable_default_schema RENAME TO public;
\q
