1 CREATE SEQUENCE OBJECTSCRIPS_seq;
2 CREATE TABLE ObjectScrips (
4 CONSTRAINT ObjectScrips_Key PRIMARY KEY,
5 Scrip NUMBER(11,0) NOT NULL,
6 Stage VARCHAR2(32) DEFAULT 'TransactionCreate' NOT NULL,
7 ObjectId NUMBER(11,0) NOT NULL,
8 SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL,
9 Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
11 LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
14 ALTER TABLE Scrips ADD Disabled NUMBER(11,0) DEFAULT 0 NOT NULL;
16 INSERT INTO ObjectScrips(
17 id, Scrip, Stage, ObjectId,
18 Creator, Created, LastUpdatedBy, LastUpdated
20 (SELECT OBJECTSCRIPS_seq.nextval, id, Stage, Queue, Creator, Created, LastUpdatedBy, LastUpdated
24 UPDATE Scrips SET Disabled = 1 WHERE Stage = 'Disabled';
25 UPDATE ObjectScrips SET Stage = 'TransactionCreate' WHERE Stage = 'Disabled';
27 CREATE UNIQUE INDEX ObjectScrips1 ON ObjectScrips (ObjectId, Scrip);
29 ALTER TABLE Scrips DROP( Stage, Queue );