Mercurial > lada > lada-server
diff 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 |
line wrap: on
line diff
--- a/db_schema/setup-db.sh Thu Feb 09 14:13:14 2017 +0100 +++ b/db_schema/setup-db.sh Fri Feb 24 14:27:10 2017 +0100 @@ -63,6 +63,10 @@ echo create lada schema psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_schema.sql + +echo create audit-trail table/trigger/views +psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/audit.sql + echo set grants psql $DB_CONNECT_STRING -d $DB_NAME --command \ "GRANT USAGE ON SCHEMA stammdaten, land TO $ROLE_NAME;