CREATE TABLE dbo.Audit_SY02300(
audit_ID uniqueidentifier DEFAULT NEWID() PRIMARY KEY,
audit_LOGTYPE varchar(3),
audit_UPSTDTFR smallint,
audit_BCHEXIST smallint,
audit_PTGENLED tinyint,
audit_SERIES smallint,
audit_TRXSOURC char(25),
audit_PSTOGLHW smallint,
audit_ALTRXPST tinyint,
audit_AUTPSTGL tinyint,
audit_VERBATOT tinyint,
audit_VERTRX tinyint,
audit_REQBAPRV tinyint,
audit_PASSWORD char(15),
audit_INCMCINF tinyint,
audit_Use_Account_Settings tinyint,
audit_POSTINDETAIL tinyint,
audit_USERID varchar(30) DEFAULT SUSER_NAME(),
audit_CHANGED datetime DEFAULT GETDATE()
);
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON dbo.Audit_SY02300 TO DYNGRP;
GO
CREATE TRIGGER trAudit_SY02300 ON dbo.SY02300 after update as
insert into Audit_SY02300 (
audit_LOGTYPE,
audit_UPSTDTFR,
audit_BCHEXIST,
audit_PTGENLED,
audit_SERIES,
audit_TRXSOURC,
audit_PSTOGLHW,
audit_ALTRXPST,
audit_AUTPSTGL,
audit_VERBATOT,
audit_VERTRX,
audit_REQBAPRV,
audit_PASSWORD,
audit_INCMCINF,
audit_Use_Account_Settings,
audit_POSTINDETAIL)
SELECT 'OLD',
UPSTDTFR,
BCHEXIST,
PTGENLED,
SERIES,
TRXSOURC,
PSTOGLHW,
ALTRXPST,
AUTPSTGL,
VERBATOT,
VERTRX,
REQBAPRV,
[PASSWORD],
INCMCINF,
Use_Account_Settings,
POSTINDETAIL
FROM deleted del;
insert into Audit_SY02300 (
audit_LOGTYPE,
audit_UPSTDTFR,
audit_BCHEXIST,
audit_PTGENLED,
audit_SERIES,
audit_TRXSOURC,
audit_PSTOGLHW,
audit_ALTRXPST,
audit_AUTPSTGL,
audit_VERBATOT,
audit_VERTRX,
audit_REQBAPRV,
audit_PASSWORD,
audit_INCMCINF,
audit_Use_Account_Settings,
audit_POSTINDETAIL)
SELECT 'NEW',
UPSTDTFR,
BCHEXIST,
PTGENLED,
SERIES,
TRXSOURC,
PSTOGLHW,
ALTRXPST,
AUTPSTGL,
VERBATOT,
VERTRX,
REQBAPRV,
[PASSWORD],
INCMCINF,
Use_Account_Settings,
POSTINDETAIL
FROM inserted ins;
GO
