Metacat

 */

CREATE SEQUENCE policy_id_seq;

ALTER TABLE smReplicationPolicy ADD policy_id number(20);

CREATE TRIGGER smReplicationPolicy_before_insert

BEFORE INSERT ON smReplicationPolicy FOR EACH ROW

BEGIN

  SELECT policy_id_seq.nextval

    INTO :new.policy_id

    FROM dual;

END;

/

UPDATE smReplicationPolicy SET policy_id=policy_id_seq.nextval;

/*

 */

UPDATE db_version SET status=0;

INSERT INTO db_version (version, status, date_created)

  VALUES ('2.6.0', 1, CURRENT_DATE);