Mercurial > lada > lada-server
comparison db_schema/setup-db.sh @ 908:51051e85348f
Added data dumps.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Thu, 07 Apr 2016 15:38:40 +0200 |
| parents | d47e6b8f3897 |
| children | 2b746f4e97d6 |
comparison
equal
deleted
inserted
replaced
| 907:ca1af8bbfe1f | 908:51051e85348f |
|---|---|
| 17 "GRANT USAGE ON SCHEMA stammdaten, bund, land TO $ROLE_NAME; | 17 "GRANT USAGE ON SCHEMA stammdaten, bund, land TO $ROLE_NAME; |
| 18 GRANT USAGE | 18 GRANT USAGE |
| 19 ON ALL SEQUENCES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME; | 19 ON ALL SEQUENCES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME; |
| 20 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES | 20 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES |
| 21 ON ALL TABLES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;" | 21 ON ALL TABLES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;" |
| 22 | |
| 23 psql -d $DB_NAME -f $DIR/stammdaten_data.sql | |
| 24 psql -d $DB_NAME -f $DIR/lada_data.sql |