====== pears.EmailSignature ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Description =====
Table holding definitions and rules for e-mail signatures.

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **EmailSignatureID** | char(20) | NOT NULL |  |  |
| Signature | long varchar | NULL |  |  |

===== Primary Key =====
  * EmailSignatureID

===== Foreign Keys =====
  * No outgoing foreign keys found.

===== Referenced By =====
^ Table ^ Constraint ^ Columns ^ Referenced columns ^
| [[database:tables:pears_contactclass|pears.contactclass]] | EmailSignature | EmailSignatureID | EmailSignatureID |

===== Indexes =====
  * No indexes found.

===== Triggers =====
^ Name ^ Timing ^ Event ^
| EmailSignatureUpdateAudit | after | update of "EmailSignatureID", "Signature" order 1 |
| EmailSignatureDeleteAudit | after | delete order 1 |

===== Original SQL =====
<code sql>
-- 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
</code>