Mercurial > dive4elements > river
view contrib/make_flys_release/h2/createDatacage.sh @ 4776:20b6ebf23916
!!! FLYS backend schema change !!! Add column bfg_id column to discharge_tables.
Alter existing databases with
alter table discharge_tables add column bfg_id varchar(50);
This column is now used to synchronize FLYS with the AFT database.
| author | Sascha L. Teichmann <teichmann@intevation.de> |
|---|---|
| date | Sat, 05 Jan 2013 15:05:51 +0100 |
| parents | 9d404069f361 |
| children | 3ba2917e49d3 |
line wrap: on
line source
#!/bin/bash mkdir datacagedb DIR=`dirname $0` DIR=`readlink -f "$DIR"` CLASSPATH= for l in `find "$DIR" -name \*.jar -print`; do CLASSPATH=$CLASSPATH:$l done export CLASSPATH java org.h2.tools.RunScript \ -url jdbc:h2:`readlink -f datacagedb`/datacage \ -script $DIR/datacage.sql