pears.SMSIncomingNumber

• SMSIncomingNumberID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

-- 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