maintenance/oracle/archives/patch-slot_roles.sql

   1 CREATE SEQUENCE slot_roles_role_id_seq;
   2 CREATE TABLE &mw_prefix.slot_roles (
   3   role_id NUMBER NOT NULL,
   4   role_name VARCHAR2(64) NOT NULL
   5 );
   6
   7 ALTER TABLE &mw_prefix.slot_roles ADD CONSTRAINT &mw_prefix.slot_roles_pk PRIMARY KEY (role_id);
   8
   9 CREATE UNIQUE INDEX &mw_prefix.role_name_u01 ON &mw_prefix.slot_roles (role_name);
  10
  11 /*$mw$*/
  12 CREATE TRIGGER &mw_prefix.slot_roles_seq_trg BEFORE INSERT ON &mw_prefix.slot_roles
  13         FOR EACH ROW WHEN (new.role_id IS NULL)
  14 BEGIN
  15         &mw_prefix.lastval_pkg.setLastval(slot_roles_role_id_seq.nextval, :new.role_id);
  16 END;
  17 /*$mw$*/