Mercurial > lada > lada-server
comparison db_schema/setup-db.sh @ 1097:186d602e031a
Merged branch schema-update into default.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 14 Oct 2016 18:17:42 +0200 |
| parents | 1d1c50b7a23b |
| children | ea6b062e5305 1bc8ab13e1f7 |
comparison
equal
deleted
inserted
replaced
| 1096:565c8a67034d | 1097:186d602e031a |
|---|---|
| 63 | 63 |
| 64 echo create lada schema | 64 echo create lada schema |
| 65 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_schema.sql | 65 psql -q $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 -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_data.sql | 76 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_data.sql |
| 77 | 77 |