1 CREATE SEQUENCE content_models_model_id_seq
;
2 CREATE TABLE &mw_prefix.
content_models (
3 model_id
NUMBER NOT NULL,
4 model_name
VARCHAR2(64) NOT NULL
8 ALTER TABLE &mw_prefix.content_models
ADD CONSTRAINT &mw_prefix.content_models_pk
PRIMARY KEY (model_id
);
10 CREATE UNIQUE INDEX &mw_prefix.model_name_u01
ON &mw_prefix.
content_models (model_name
);
13 CREATE TRIGGER &mw_prefix.content_models_seq_trg
BEFORE INSERT ON &mw_prefix.content_models
14 FOR EACH ROW WHEN (new.model_id
IS NULL)
16 &mw_prefix.lastval_pkg.
setLastval(content_models_model_id_seq.nextval
, :new.model_id
);