db='tracker'

# LOAD TRACKER DATABASE
echo " " > load.sql
for table in  \
	fundedactivity invoicelineitem expense work cashwithdrawals cashdeposits \
	persbudgproj budgetproject accountsrecv project budget companyperson \
	company userauth person users domain
{
	echo deleting $table...
	echo "info status for $table;" >> load.sql
	echo "delete from $table;" >> load.sql
}

for table in  \
	domain users person userauth company companyperson budget project accountsrecv \
	budgetproject persbudgproj cashdeposits cashwithdrawals work expense  \
	invoicelineitem fundedactivity
{
	echo loading $table...
	echo "info status for $table;" >> load.sql
	echo "load from '$table.out' delimiter '|' insert into $table;" >> load.sql
}

dbaccess $db load.sql