ALTER TABLE MBH.RATINGS_SP DROP PRIMARY KEY CASCADE; DROP TABLE MBH.RATINGS_SP CASCADE CONSTRAINTS; CREATE TABLE MBH.RATINGS_SP ( RID NUMBER(10) NOT NULL, RVALUE NUMBER(10) NOT NULL, RDATE DATE, VID NUMBER(10) NOT NULL, UID_ VARCHAR2(255 CHAR) ) TABLESPACE USERS PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE NOPARALLEL MONITORING; COMMENT ON COLUMN MBH.RATINGS_SP .UID_ IS 'ORIGINAL NAME:uID'; CREATE UNIQUE INDEX MBH.PRIMARY_1 ON MBH.RATINGS_SP (RID) LOGGING TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) NOPARALLEL; CREATE OR REPLACE TRIGGER MBH."RATINGS_RID_TRG" BEFORE INSERT OR UPDATE ON Ratings FOR EACH ROW DECLARE v_newVal NUMBER(12) := 0; v_incval NUMBER(12) := 0; BEGIN IF INSERTING AND :new.rID IS NULL THEN SELECT Ratings_rID_SEQ.NEXTVAL INTO v_newVal FROM DUAL; -- If this is the first time this table have been inserted into (sequence == 1) IF v_newVal = 1 THEN --get the max indentity value from the table SELECT NVL(max(rID),0) INTO v_newVal FROM Ratings; v_newVal := v_newVal + 1; --set the sequence to that value LOOP EXIT WHEN v_incval>=v_newVal; SELECT Ratings_rID_SEQ.nextval INTO v_incval FROM dual; END LOOP; END IF; --used to emulate LAST_INSERT_ID() --mysql_utilities.identity := v_newVal; -- assign the value from the sequence to emulate the identity column :new.rID := v_newVal; END IF; END; / ALTER TABLE MBH.RATINGS_SP ADD ( CONSTRAINT PRIMARY_1 PRIMARY KEY (RID) USING INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 ));