Mercurial > dive4elements > river
view contrib/make_flys_release/h2/createDatacage.sh @ 6721:df402b3e0281
minfo-schema-change/issue1393: add kind column to sediment_yield table.
To change existing databases, issue following sql command:
ALTER TABLE sediment_yield ADD kind INT DEFAULT 0;
For oracles it might look like
ALTER TABLE sediment_yield ADD kind NUMBER(38,0) DEFAULT 0;
.
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Wed, 31 Jul 2013 11:10:11 +0200 |
| parents | 3ba2917e49d3 |
| children | 19472d3877d6 |
line wrap: on
line source
#!/bin/bash mkdir -p datacagedb DIR=`dirname $0` DIR=`readlink -f "$DIR"` CLASSPATH= for l in `find "$DIR" -name \*.jar -print`; do CLASSPATH=$CLASSPATH:$l done export CLASSPATH if [ $# != 1 ]; then echo "Usage: $0 <schema_file>" fi java org.h2.tools.RunScript \ -url jdbc:h2:`readlink -f datacagedb`/datacage \ -script "$1"