diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-06-14 11:38:43 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-06-14 11:38:43 +0000 |
| commit | b3769d8cfac1a31ab4022694e406375772b51131 (patch) | |
| tree | a0ff29524a1ac21d9182b3cb639d77d83b924640 /phpBB/install/schemas | |
| parent | 66bc2cea5786e6a8e907551f6a840b1cb780b859 (diff) | |
| download | forums-b3769d8cfac1a31ab4022694e406375772b51131.tar forums-b3769d8cfac1a31ab4022694e406375772b51131.tar.gz forums-b3769d8cfac1a31ab4022694e406375772b51131.tar.bz2 forums-b3769d8cfac1a31ab4022694e406375772b51131.tar.xz forums-b3769d8cfac1a31ab4022694e406375772b51131.zip | |
Triggers in the schema
git-svn-id: file:///svn/phpbb/trunk@4126 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 213 |
1 files changed, 212 insertions, 1 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index 1d1cd35bdd..9cb1317e4e 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -517,4 +517,215 @@ CREATE TABLE phpbb_words ( CONSTRAINT phpbb_words_pkey PRIMARY KEY (word_id) ); -COMMIT; + +/* -------------------------------------------------------- + Trigger structure for table phpbb_groups +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_PHPBB_GROUPS_ID_SEQ" +BEFORE INSERT OR UPDATE OF "GROUP_ID" ON "PHPBB"."PHPBB_GROUPS" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_GROUPS_ID_SEQ.NEXTVAL +INTO :NEW.group_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_banlist +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_PHPBB_BANLIST_ID_SEQ" +BEFORE INSERT OR UPDATE OF "BAN_ID" ON "PHPBB"."PHPBB_BANLIST" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_BANLIST_ID_SEQ.NEXTVAL +INTO :NEW.ban_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_categories +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_CATEGORIES_ID_SEQ" +BEFORE INSERT OR UPDATE OF "CAT_ID" ON "PHPBB"."PHPBB_CATEGORIES" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_CATEGORIES_ID_SEQ.NEXTVAL +INTO :NEW.cat_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_disallow +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_DISALLOW_ID_SEQ" +BEFORE INSERT OR UPDATE OF "DISALLOW_ID" ON "PHPBB"."PHPBB_DISALLOW" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_DISALLOW_ID_SEQ.NEXTVAL +INTO :NEW.disallow_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_forums +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_FORUMS_ID_SEQ" +BEFORE INSERT OR UPDATE OF "FORUM_ID" ON "PHPBB"."PHPBB_FORUMS" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_FORUMS_ID_SEQ.NEXTVAL +INTO :NEW.forum_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_forum_prune +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_FORUM_PRUNE_ID_SEQ" +BEFORE INSERT OR UPDATE OF "PRUNE_ID" ON "PHPBB"."PHPBB_FORUM_PRUNE" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_FORUM_PRUNE_ID_SEQ.NEXTVAL +INTO :NEW.prune_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_posts +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_POSTS_ID_SEQ" +BEFORE INSERT OR UPDATE OF "POST_ID" ON "PHPBB"."PHPBB_POSTS" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_POSTS_ID_SEQ.NEXTVAL +INTO :NEW.post_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_privmsgs +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_PRIVMSGS_ID_SEQ" +BEFORE INSERT OR UPDATE OF "PRIVMSGS_ID" ON "PHPBB"."PHPBB_PRIVMSGS" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_PRIVMSGS_ID_SEQ.NEXTVAL +INTO :NEW.privmsgs_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_ranks +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_RANK_ID_SEQ" +BEFORE INSERT OR UPDATE OF "RANK_ID" ON "PHPBB"."PHPBB_RANKS" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_RANKS_ID_SEQ.NEXTVAL +INTO :NEW.rank_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_smilies +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_SMILIES_ID_SEQ" +BEFORE INSERT OR UPDATE OF "SMILIES_ID" ON "PHPBB"."PHPBB_SMILIES" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_SMILIES_ID_SEQ.NEXTVAL +INTO :NEW.smilies_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_themes +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_THEMES_ID_SEQ" +BEFORE INSERT OR UPDATE OF "THEMES_ID" ON "PHPBB"."PHPBB_THEMES" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_THEMES_ID_SEQ.NEXTVAL +INTO :NEW.themes_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_topics +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_TOPICS_ID_SEQ" +BEFORE INSERT OR UPDATE OF "TOPIC_ID" ON "PHPBB"."PHPBB_TOPICS" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_TOPICS_ID_SEQ.NEXTVAL +INTO :NEW.topic_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_users +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_USERS_ID_SEQ" +BEFORE INSERT OR UPDATE OF "USER_ID" ON "PHPBB"."PHPBB_USERS" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_USERS_ID_SEQ.NEXTVAL +INTO :NEW.user_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_vote_desc +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_VOTE_DESC_ID_SEQ" +BEFORE INSERT OR UPDATE OF "VOTE_ID" ON "PHPBB"."PHPBB_VOTE_DESC" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_VOTE_DESC_ID_SEQ.NEXTVAL +INTO :NEW.vote_id +FROM DUAL; +END; +/ + +/* -------------------------------------------------------- + Trigger structure for table phpbb_words +-------------------------------------------------------- */ +CREATE OR REPLACE TRIGGER "PHPBB"."SET_WORDS_ID_SEQ" +BEFORE INSERT OR UPDATE OF "WORD_ID" ON "PHPBB"."PHPBB_WORDS" +REFERENCING OLD AS OLD NEW AS NEW +FOR EACH ROW +BEGIN +SELECT PHPBB_WORDS_ID_SEQ.NEXTVAL +INTO :NEW.word_id +FROM DUAL; +END; +/ + +COMMIT;
\ No newline at end of file |