maintenance/oracle/archives/patch-content_models.sql

   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
   5 );
   6
   7
   8 ALTER TABLE &mw_prefix.content_models ADD CONSTRAINT &mw_prefix.content_models_pk PRIMARY KEY (model_id);
   9
  10 CREATE UNIQUE INDEX &mw_prefix.model_name_u01 ON &mw_prefix.content_models (model_name);
  11
  12 /*$mw$*/
  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)
  15 BEGIN
  16         &mw_prefix.lastval_pkg.setLastval(content_models_model_id_seq.nextval, :new.model_id);
  17 END;
  18 /*$mw$*/