diff options
Diffstat (limited to 'www/wiki/maintenance/oracle/archives/patch-content.sql')
-rw-r--r-- | www/wiki/maintenance/oracle/archives/patch-content.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/www/wiki/maintenance/oracle/archives/patch-content.sql b/www/wiki/maintenance/oracle/archives/patch-content.sql new file mode 100644 index 00000000..17d76ae6 --- /dev/null +++ b/www/wiki/maintenance/oracle/archives/patch-content.sql @@ -0,0 +1,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$*/
\ No newline at end of file |