]> git.evergreen-ils.org Git - working/Evergreen.git/blob - Open-ILS/src/sql/Pg/901.audit-tables.sql
logical division of some data/schema stuff; adding a pkey to the audit tables (easing...
[working/Evergreen.git] / Open-ILS / src / sql / Pg / 901.audit-tables.sql
1 DROP SCHEMA auditor CASCADE;
2
3 BEGIN;
4
5 SELECT auditor.create_auditor ( 'actor', 'usr' );
6 SELECT auditor.create_auditor ( 'actor', 'usr_address' );
7 SELECT auditor.create_auditor ( 'actor', 'org_unit' );
8 SELECT auditor.create_auditor ( 'biblio', 'record_entry' );
9 SELECT auditor.create_auditor ( 'asset', 'call_number' );
10 SELECT auditor.create_auditor ( 'asset', 'copy' );
11
12 COMMIT;
13