pears.EmailSignature

Table holding definitions and rules for e-mail signatures.

• EmailSignatureID

• No outgoing foreign keys found.

• No indexes found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."EmailSignature"
-- Table comment: Table holding definitions and rules for e-mail signatures.
-- Statement count: 6
 
CREATE TABLE "pears"."EmailSignature" (
    "EmailSignatureID"               CHAR(20) NOT NULL
   ,"Signature"                      long VARCHAR NULL
   ,PRIMARY KEY ("EmailSignatureID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."EmailSignature" IS 
	'Table holding definitions and rules for e-mail signatures.'
GO
 
 
CREATE TRIGGER "EmailSignatureUpdateAudit" after UPDATE OF "EmailSignatureID",
"Signature" ORDER 1 ON "pears"."EmailSignature"
REFERENCING OLD AS "old_ESig" NEW AS "new_ESig"
FOR each ROW
BEGIN
  IF UPDATE("EmailSignatureID") THEN
    CALL "AuditLog"('EMAILSIGNATURE',"old_ESig"."EmailSignatureID","string"('EMAILSIGNATURE Updated - ID : ',"old_ESig"."EmailSignatureID"),"old_ESig"."EmailSignatureID","new_ESig"."EmailSignatureID")
  END IF;
  IF UPDATE("Signature") THEN
    CALL "AuditLog"('EMAILSIGNATURE',"old_ESig"."EmailSignatureID","string"('EMAILSIGNATURE Updated - Signature : ',"old_ESig"."Signature"),"old_ESig"."Signature","new_ESig"."Signature")
  END IF
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."EmailSignature"."EmailSignatureUpdateAudit" IS 
{CREATE TRIGGER EmailSignatureUpdateAudit 
after UPDATE OF 
EmailSignatureID, Signature
 ORDER 1 ON pears.EmailSignature
REFERENCING OLD AS old_ESig NEW AS new_ESig
FOR each ROW
BEGIN
  IF UPDATE(EmailSignatureID) THEN 
    CALL AuditLog('EMAILSIGNATURE',old_ESig.EmailSignatureID,string('EMAILSIGNATURE Updated - ID : ',old_ESig.EmailSignatureID),old_ESig.EmailSignatureID,new_ESig.EmailSignatureID)
  END IF ; 
  IF UPDATE(Signature) THEN 
    CALL AuditLog('EMAILSIGNATURE',old_ESig.EmailSignatureID,string('EMAILSIGNATURE Updated - Signature : ',old_ESig.Signature),old_ESig.Signature,new_ESig.Signature)
  END IF ; 
END
}
GO
 
 
CREATE TRIGGER "EmailSignatureDeleteAudit" after DELETE ORDER 1 ON
"pears"."EmailSignature"
REFERENCING OLD AS "old_ESig"
FOR each ROW
BEGIN
  CALL "AuditLog"('EMAILSIGNATURE',"old_ESig"."EmailSignatureID",'Deleted E-mail Signature ',"string"('ID = ',"old_ESig"."EmailSignatureID",', Signature = ',"old_ESig"."Signature"),'')
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."EmailSignature"."EmailSignatureDeleteAudit" IS 
{CREATE TRIGGER EmailSignatureDeleteAudit 
 after DELETE ORDER 1 ON
EmailSignature
REFERENCING OLD AS old_ESig
FOR each ROW
BEGIN
  CALL AuditLog('EMAILSIGNATURE',old_ESig.EmailSignatureID,'Deleted E-mail Signature ',string('ID = ',old_ESig.EmailSignatureID,', Signature = ',old_ESig.Signature),'')
END
}
GO