pears.SMSIncomingNumber [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.SMSIncomingNumber ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **SMSIncomingNumberID** | char(20) | NOT NULL |  |  |
| TempdeskID | char(20) | NULL |  |  |
| DepartmentID | char(2) | NULL |  |  |
| VirtualMobileNumber | char(50) | NULL |  |  |
| Inbox | long varchar | NULL |  |  |
| StaffID | char(20) | NULL |  |  |
| Inactive | smallint | NULL | 0 |  |

===== Primary Key =====
  * SMSIncomingNumberID

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

===== Referenced By =====
  * No incoming foreign keys found.

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

===== Triggers =====
^ Name ^ Timing ^ Event ^
| SMSIncomingNumberInsertAudit | after | insert order 1 |
| SMSIncomingNumberUpdateAudit | after | update order 1 |
| SMSIncomingNumberDeleteAudit | after | delete order 1 |

===== Original SQL =====
<code sql>
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."SMSIncomingNumber"
-- Table comment: 
-- Statement count: 7

CREATE TABLE "pears"."SMSIncomingNumber" (
    "SMSIncomingNumberID"            char(20) NOT NULL
   ,"TempdeskID"                     char(20) NULL
   ,"DepartmentID"                   char(2) NULL
   ,"VirtualMobileNumber"            char(50) NULL
   ,"Inbox"                          long varchar NULL
   ,"StaffID"                        char(20) NULL
   ,"Inactive"                       smallint NULL DEFAULT 0
   ,PRIMARY KEY ("SMSIncomingNumberID" ASC) 
)
go


create trigger "SMSIncomingNumberInsertAudit" after insert order 1 on
"pears"."SMSIncomingNumber"
referencing new as "new_num"
for each row
begin
  declare "StaffName" char(25);
  select "userid" into "StaffName" from "staff" where "staffid" = "new_num"."staffid";
  call "AuditLog"('USER','',"string"("StaffName",' Mobile Added '),'',"new_num"."VirtualMobileNumber")
end
go


COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."SMSIncomingNumber"."SMSIncomingNumberInsertAudit" IS 
{create trigger SMSIncomingNumberInsertAudit 
 after insert order 1 on
"pears"."SMSIncomingNumber"
referencing new as "new_num"
for each row
begin
  declare "StaffName" char(25);
  select "userid" into "StaffName" from "staff" where "staffid" = "new_num"."staffid";
  call "AuditLog"('USER','',"string"("StaffName",' Mobile Added '),'',"new_num"."VirtualMobileNumber")
end
}
go


create trigger "SMSIncomingNumberUpdateAudit" after update order 1 on
"pears"."SMSIncomingNumber"
referencing old as "old_num" new as "new_num"
for each row
begin
  declare "StaffName" char(25);
  select "userid" into "StaffName" from "staff" where "staffid" = "new_num"."staffid";
  call "AuditLog"('USER','',"string"("StaffName",' Mobile Changed '),"old_num"."VirtualMobileNumber","new_num"."VirtualMobileNumber")
end
go


COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."SMSIncomingNumber"."SMSIncomingNumberUpdateAudit" IS 
{create trigger SMSIncomingNumberUpdateAudit 
 after update order 1 on
"pears"."SMSIncomingNumber"
referencing old as "old_num" new as "new_num"
for each row
begin
  declare "StaffName" char(25);
  select "userid" into "StaffName" from "staff" where "staffid" = "new_num"."staffid";
  call "AuditLog"('USER','',"string"("StaffName",' Mobile Changed '),"old_num"."VirtualMobileNumber","new_num"."VirtualMobileNumber")
end
}
go


create trigger "SMSIncomingNumberDeleteAudit" after delete order 1 on
"pears"."SMSIncomingNumber"
referencing old as "old_num"
for each row
begin
  declare "StaffName" char(25);
  select "userid" into "StaffName" from "staff" where "staffid" = "old_num"."staffid";
  call "AuditLog"('USER','',"string"("StaffName",' Mobile Deleted '),"old_num"."VirtualMobileNumber",'')
end
go


COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."SMSIncomingNumber"."SMSIncomingNumberDeleteAudit" IS 
{create trigger SMSIncomingNumberDeleteAudit 
 after delete order 1 on
"pears"."SMSIncomingNumber"
referencing old as "old_num"
for each row
begin
  declare "StaffName" char(25);
  select "userid" into "StaffName" from "staff" where "staffid" = "old_num"."staffid";
  call "AuditLog"('USER','',"string"("StaffName",' Mobile Deleted '),"old_num"."VirtualMobileNumber",'')
end
}
go
</code>