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
7 ALTER TABLE &mw_prefix.slot_roles
ADD CONSTRAINT &mw_prefix.slot_roles_pk
PRIMARY KEY (role_id
);
9 CREATE UNIQUE INDEX &mw_prefix.role_name_u01
ON &mw_prefix.
slot_roles (role_name
);
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)
15 &mw_prefix.lastval_pkg.
setLastval(slot_roles_role_id_seq.nextval
, :new.role_id
);