Mercurial > lada > lada-server
comparison db_schema/setup-db.sh @ 1031:2977a7ac414f schema-update
Removed schema bund from setup_db script.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Wed, 31 Aug 2016 15:46:59 +0200 |
| parents | bc44dcda6f69 |
| children |
comparison
equal
deleted
inserted
replaced
| 1030:330dec7ee0bb | 1031:2977a7ac414f |
|---|---|
| 63 | 63 |
| 64 echo create lada schema | 64 echo create lada schema |
| 65 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_schema.sql | 65 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_schema.sql |
| 66 echo set grants | 66 echo set grants |
| 67 psql $DB_CONNECT_STRING -d $DB_NAME --command \ | 67 psql $DB_CONNECT_STRING -d $DB_NAME --command \ |
| 68 "GRANT USAGE ON SCHEMA stammdaten, bund, land TO $ROLE_NAME; | 68 "GRANT USAGE ON SCHEMA stammdaten, land TO $ROLE_NAME; |
| 69 GRANT USAGE | 69 GRANT USAGE |
| 70 ON ALL SEQUENCES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME; | 70 ON ALL SEQUENCES IN SCHEMA stammdaten, land TO $ROLE_NAME; |
| 71 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES | 71 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES |
| 72 ON ALL TABLES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;" | 72 ON ALL TABLES IN SCHEMA stammdaten, land TO $ROLE_NAME;" |
| 73 | 73 |
| 74 if [ "$NO_DATA" != "true" ]; then | 74 if [ "$NO_DATA" != "true" ]; then |
| 75 echo import stammdaten | 75 echo import stammdaten |
| 76 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_data.sql | 76 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_data.sql |
| 77 | 77 |