Mercurial > dive4elements > river
view backend/contrib/dump-schema.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 | 5aa05a7a34b7 |
| children |
line wrap: on
line source
#!/bin/bash DB_URL=jdbc:postgresql://czech-republic.atlas.intevation.de:5432/flys3 DB_USER=flys DB_PASS=flys DB_DIALECT=org.hibernatespatial.oracle.OracleSpatial10gDialect mvn compile package -e \ -Dlog4j.configuration=file://`readlink -f contrib/log4j.properties` \ -Dflys.backend.user=$DB_USER \ -Dflys.backend.password=$DB_PASS \ -Dflys.backend.dialect=$DB_DIALECT \ -Dflys.backend.url=$DB_URL \ -Dexec.mainClass=de.intevation.flys.App \ exec:java