|
--
-- MASTER_AUDIT_BUILD.sql
--
-- Peter Robson, March 2001.
--
set echo off
--
--
-- This script runs the working scripts in order to build
-- the following components for Auditing and Logging of any
-- named table:
--
-- ADD_AUDIT_FIELDS.sql Adds necessary audit fields to master table
-- BUILD_CPY_TABLE.sql Builds the Copy table to store pre-change rows from the Master table
-- BUILD_AUD_TRIG.sql Builds the trigger to populate the Copy table
-- BUILD_LOG_TABLE.sql Builds the Logging table
-- BUILD_LOG_TRIG.sql Builds the trigger to populate the Logging table.
--
-- All these scripts can run one after the other. Should any of the
-- objects being created already exist, no error will occur, and the
-- next process will proceed. You will be prompted for the name of the
-- Master table by each script - variables are not passed to each script,
-- to retain the freedom of running any script independently.
--
--
@@ADD_AUDIT_FIELDS.sql
@@BUILD_CPY_TABLE.sql
@@BUILD_AUD_TRIG.sql
@@BUILD_LOG_TABLE.sql
@@BUILD_LOG_TRIG.sql
--
-- end
--
set echo on
--
|
|
