view contrib/make_flys_release/h2/createDatacage.sh @ 5206:8667f629d238

SCHEME CHANGE: Add measurement_station to oracle table and rename comment column Comment is a reserved keyword in oracle. This also fixes a typo in the table name of time_intervals.
author Andre Heinecke <aheinecke@intevation.de>
date Fri, 08 Mar 2013 15:16:00 +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

http://dive4elements.wald.intevation.org