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