maintenance/oracle/archives/patch-content.sql

   1 CREATE SEQUENCE content_content_id_seq;
   2 CREATE TABLE &mw_prefix.content (
   3   content_id NUMBER NOT NULL,
   4   content_size NUMBER NOT NULL,
   5   content_sha1 VARCHAR2(32) NOT NULL,
   6   content_model NUMBER NOT NULL,
   7   content_address VARCHAR2(255) NOT NULL
   8 );
   9
  10 ALTER TABLE &mw_prefix.content ADD CONSTRAINT &mw_prefix.content_pk PRIMARY KEY (content_id);
  11
  12 /*$mw$*/
  13 CREATE TRIGGER &mw_prefix.content_seq_trg BEFORE INSERT ON &mw_prefix.content
  14         FOR EACH ROW WHEN (new.content_id IS NULL)
  15 BEGIN
  16         &mw_prefix.lastval_pkg.setLastval(content_content_id_seq.nextval, :new.content_id);
  17 END;
  18 /*$mw$*/