comparison db_schema/setup-db.sh @ 764:9d2070b84238

Hibernate needs nextval to insert new datasets.
author Tom Gottfried <tom@intevation.de>
date Wed, 11 Nov 2015 11:12:23 +0100
parents 0cf9387c8da2
children e797391714a0
comparison
equal deleted inserted replaced
763:8cf21cd01287 764:9d2070b84238
8 psql --command "CREATE USER $ROLE_NAME PASSWORD '$ROLE_PW';" 8 psql --command "CREATE USER $ROLE_NAME PASSWORD '$ROLE_PW';"
9 createdb -E UTF-8 $DB_NAME 9 createdb -E UTF-8 $DB_NAME
10 psql -d $DB_NAME -f $DIR/lada_schema.sql 10 psql -d $DB_NAME -f $DIR/lada_schema.sql
11 psql -d $DB_NAME --command \ 11 psql -d $DB_NAME --command \
12 "GRANT USAGE ON SCHEMA stammdaten, bund, land TO $ROLE_NAME; 12 "GRANT USAGE ON SCHEMA stammdaten, bund, land TO $ROLE_NAME;
13 GRANT SELECT 13 GRANT USAGE
14 ON ALL SEQUENCES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME; 14 ON ALL SEQUENCES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;
15 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES 15 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES
16 ON ALL TABLES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;" 16 ON ALL TABLES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;"
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)