Mercurial > lada > lada-server
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;" |