Mercurial > lada > lada-server
comparison db_schema/setup-db.sh @ 1298:ba47994c1665
Add audit-trail table/trigger/views to database.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Fri, 24 Feb 2017 14:27:10 +0100 |
| parents | 6692b3bdc49d |
| children | b5ab25b7ac2c |
comparison
equal
deleted
inserted
replaced
| 1297:65166d1158fe | 1298:ba47994c1665 |
|---|---|
| 61 echo create stammdaten schema | 61 echo create stammdaten schema |
| 62 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_schema.sql | 62 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_schema.sql |
| 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 | |
| 67 echo create audit-trail table/trigger/views | |
| 68 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/audit.sql | |
| 69 | |
| 66 echo set grants | 70 echo set grants |
| 67 psql $DB_CONNECT_STRING -d $DB_NAME --command \ | 71 psql $DB_CONNECT_STRING -d $DB_NAME --command \ |
| 68 "GRANT USAGE ON SCHEMA stammdaten, land TO $ROLE_NAME; | 72 "GRANT USAGE ON SCHEMA stammdaten, land TO $ROLE_NAME; |
| 69 GRANT USAGE | 73 GRANT USAGE |
| 70 ON ALL SEQUENCES IN SCHEMA stammdaten, land TO $ROLE_NAME; | 74 ON ALL SEQUENCES IN SCHEMA stammdaten, land TO $ROLE_NAME; |