view flys-backend/README @ 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 90142c839fe5
children 790353fadf30
line wrap: on
line source
For the artifact database
# su - postgres
$ createuser --no-createrole --no-superuser --pwprompt --no-createdb artifacts
$ createdb --encoding=UTF-8 --owner artifacts artifactsdb

For the flys database

# su - postgres
$ createuser --no-createrole --no-superuser --pwprompt --no-createdb flys
$ createdb --encoding=UTF-8 --owner flys flystest1

Standalone DateGuesser testing example:

mvn -e -Dexec.mainClass=de.intevation.flys.utils.DateGuesser -Dexec.args="110803" exec:java <<EOF
110803
EOF

http://dive4elements.wald.intevation.org