2 * Copyright (C) 2004-2008 Georgia Public Library Service
3 * Copyright (C) 2007-2008 Equinox Software, Inc.
4 * Mike Rylander <miker@esilibrary.com>
6 * This program is free software; you can redistribute it and/or
7 * modify it under the terms of the GNU General Public License
8 * as published by the Free Software Foundation; either version 2
9 * of the License, or (at your option) any later version.
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
20 SELECT auditor.create_auditor ( 'actor', 'usr' );
21 CREATE INDEX aud_actor_usr_hist_id_idx ON auditor.actor_usr_history ( id );
23 SELECT auditor.create_auditor ( 'actor', 'usr_address' );
24 CREATE INDEX aud_actor_usr_address_hist_id_idx ON auditor.actor_usr_address_history ( id );
26 SELECT auditor.create_auditor ( 'actor', 'org_unit' );
28 SELECT auditor.create_auditor ( 'biblio', 'record_entry' );
29 CREATE INDEX aud_bib_rec_entry_hist_creator_idx ON auditor.biblio_record_entry_history ( creator );
30 CREATE INDEX aud_bib_rec_entry_hist_editor_idx ON auditor.biblio_record_entry_history ( editor );
32 SELECT auditor.create_auditor ( 'asset', 'call_number' );
33 CREATE INDEX aud_asset_cn_hist_creator_idx ON auditor.asset_call_number_history ( creator );
34 CREATE INDEX aud_asset_cn_hist_editor_idx ON auditor.asset_call_number_history ( editor );
36 SELECT auditor.create_auditor ( 'asset', 'copy' );
37 CREATE INDEX aud_asset_cp_hist_creator_idx ON auditor.asset_copy_history ( creator );
38 CREATE INDEX aud_asset_cp_hist_editor_idx ON auditor.asset_copy_history ( editor );