pears.IQXNetPageText

Used to store the pagetext and their values

• IQXNetPageTextID

• 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"."IQXNetPageText"
-- Table comment: Used to store the pagetext and their values
-- Statement count: 6
 
CREATE TABLE "pears"."IQXNetPageText" (
    "IQXNetPageTextID"               CHAR(50) NOT NULL
   ,"PageText"                       long VARCHAR NULL
   ,"UpdatedFlag"                    tinyint NULL
   ,"TransferFlag"                   tinyint NULL
   ,PRIMARY KEY ("IQXNetPageTextID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."IQXNetPageText" IS 
	'Used to store the pagetext and their values'
GO
 
 
CREATE TRIGGER "IQXNetPageTextInsert" BEFORE INSERT ORDER 1 ON
"pears"."IQXNetPageText"
REFERENCING NEW AS "new_page"
FOR each ROW
BEGIN
  SET "new_page"."UpdatedFlag" = 1
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."IQXNetPageText"."IQXNetPageTextInsert" IS 
{CREATE TRIGGER IQXNetPageTextInsert 
 BEFORE INSERT ORDER 1 ON
IQXNetPageText
REFERENCING NEW AS new_page
FOR each ROW
BEGIN
  SET new_page.UpdatedFlag=1
END
}
GO
 
 
CREATE TRIGGER "IQXNetPageTextUpdate" BEFORE UPDATE OF "PageText"
ORDER 1 ON "pears"."IQXNetPageText"
REFERENCING NEW AS "new_page"
FOR each ROW
BEGIN
  SET "new_page"."UpdatedFlag" = 1
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."IQXNetPageText"."IQXNetPageTextUpdate" IS 
{CREATE TRIGGER IQXNetPageTextUpdate 
 BEFORE UPDATE OF PageText
ORDER 1 ON IQXNetPageText
REFERENCING NEW AS new_page
FOR each ROW
BEGIN
  SET new_page.UpdatedFlag=1
END
}
GO