diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-07-16 12:52:36 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-07-16 12:52:36 +0000 |
| commit | edf30a3c54543eadd60440687c39c52f46d5e98b (patch) | |
| tree | cd4085853d784e4e96f81f7000d5a263ca5cbca1 /phpBB/db/schemas/oracle_triggers.sql | |
| parent | d1698fdeb59df9a6e0c4594b25d2cb6944381d36 (diff) | |
| download | forums-edf30a3c54543eadd60440687c39c52f46d5e98b.tar forums-edf30a3c54543eadd60440687c39c52f46d5e98b.tar.gz forums-edf30a3c54543eadd60440687c39c52f46d5e98b.tar.bz2 forums-edf30a3c54543eadd60440687c39c52f46d5e98b.tar.xz forums-edf30a3c54543eadd60440687c39c52f46d5e98b.zip | |
Move to 'centralised' location in install/
git-svn-id: file:///svn/phpbb/trunk@2693 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/schemas/oracle_triggers.sql')
| -rw-r--r-- | phpBB/db/schemas/oracle_triggers.sql | 217 |
1 files changed, 0 insertions, 217 deletions
diff --git a/phpBB/db/schemas/oracle_triggers.sql b/phpBB/db/schemas/oracle_triggers.sql deleted file mode 100644 index f22fa46f66..0000000000 --- a/phpBB/db/schemas/oracle_triggers.sql +++ /dev/null @@ -1,217 +0,0 @@ -/* - phpBB2 Oracle 8i Triggers File - (c) 2001 The phpBB Group - - $Id$ - */ - -/* -------------------------------------------------------- - 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; |