#!/bin/sh

# interpreter
SQL=pgsql --port5433 --username=spi1 -d=spi2 -f.
PHP=php

# env
DATA_PATH=absolute path to datadir/
SQL_PASSWORD=xxxxxxx

# testsystem
$SQL testsystem.sql

# migrate
$SQL groups.sql
$SQL files.sql
./file_import.pl /var/www/spi1-test/spi-v1-data/ $SQL_PASSWORD
$SQL board.sql
$SQL diary.sql
$SQL newsletter.sql
$SQL messages.sql
$SQL country.sql
$SQL carpool.sql
$SQL calendar_and_announce.sql
$SQL comments.sql
$SQL poll.sql
$SQL links.sql
$SQL properties.sql
$SQL rating.sql
$SQL shoutbox.sql
$SQL files2.sql
$SQL permission.sql
$SQL merge,sql
$SQL log.sql
$SQL subscriptions.sql
$SQL album.sql
$PHP album-import.php
$SQL search.sql
$SQL recent.sql
$SQL faq.sql
$SQL instant_message.sql
$SQL visitor.sql
$SQL shoutbox.sql
$SQL registration.sql
$SQL misc.sql