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; |