sourceforge2.5oci8-trigger_auto.sql

来自「GForge 3.0 协作开发平台 支持CVS, mailing lists, 」· SQL 代码 · 共 1,401 行 · 第 1/3 页

CREATE OR REPLACE TRIGGER A_bug_pk_seq
        BEFORE INSERT OR UPDATE of bug_id
        ON bug FOR EACH ROW
BEGIN
        IF (:new.bug_id is null) then
          IF INSERTING THEN
            SELECT bug_pk_seq.nextval INTO :new.bug_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.bug_id := :old.bug_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_bug_bug_dependencies_pk_seq
        BEFORE INSERT OR UPDATE of bug_depend_id
        ON bug_bug_dependencies FOR EACH ROW
BEGIN
        IF (:new.bug_depend_id is null) then
          IF INSERTING THEN
            SELECT bug_bug_dependencies_pk_seq.nextval INTO :new.bug_depend_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.bug_depend_id := :old.bug_depend_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_bug_canned_responses_pk_seq
        BEFORE INSERT OR UPDATE of bug_canned_id
        ON bug_canned_responses FOR EACH ROW
BEGIN
        IF (:new.bug_canned_id is null) then
          IF INSERTING THEN
            SELECT bug_canned_responses_pk_seq.nextval INTO :new.bug_canned_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.bug_canned_id := :old.bug_canned_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_bug_category_pk_seq
        BEFORE INSERT OR UPDATE of bug_category_id
        ON bug_category FOR EACH ROW
BEGIN
        IF (:new.bug_category_id is null) then
          IF INSERTING THEN
            SELECT bug_category_pk_seq.nextval INTO :new.bug_category_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.bug_category_id := :old.bug_category_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_bug_filter_pk_seq
        BEFORE INSERT OR UPDATE of filter_id
        ON bug_filter FOR EACH ROW
BEGIN
        IF (:new.filter_id is null) then
          IF INSERTING THEN
            SELECT bug_filter_pk_seq.nextval INTO :new.filter_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.filter_id := :old.filter_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_bug_group_pk_seq
        BEFORE INSERT OR UPDATE of bug_group_id
        ON bug_group FOR EACH ROW
BEGIN
        IF (:new.bug_group_id is null) then
          IF INSERTING THEN
            SELECT bug_group_pk_seq.nextval INTO :new.bug_group_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.bug_group_id := :old.bug_group_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_bug_history_pk_seq
        BEFORE INSERT OR UPDATE of bug_history_id
        ON bug_history FOR EACH ROW
BEGIN
        IF (:new.bug_history_id is null) then
          IF INSERTING THEN
            SELECT bug_history_pk_seq.nextval INTO :new.bug_history_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.bug_history_id := :old.bug_history_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_bug_resolution_pk_seq
        BEFORE INSERT OR UPDATE of resolution_id
        ON bug_resolution FOR EACH ROW
BEGIN
        IF (:new.resolution_id is null) then
          IF INSERTING THEN
            SELECT bug_resolution_pk_seq.nextval INTO :new.resolution_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.resolution_id := :old.resolution_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_bug_status_pk_seq
        BEFORE INSERT OR UPDATE of status_id
        ON bug_status FOR EACH ROW
BEGIN
        IF (:new.status_id is null) then
          IF INSERTING THEN
            SELECT bug_status_pk_seq.nextval INTO :new.status_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.status_id := :old.status_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_bug_task_dependencies_pk_seq
        BEFORE INSERT OR UPDATE of bug_depend_id
        ON bug_task_dependencies FOR EACH ROW
BEGIN
        IF (:new.bug_depend_id is null) then
          IF INSERTING THEN
            SELECT bug_task_dependencies_pk_seq.nextval INTO :new.bug_depend_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.bug_depend_id := :old.bug_depend_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_canned_responses_pk_seq
        BEFORE INSERT OR UPDATE of response_id
        ON canned_responses FOR EACH ROW
BEGIN
        IF (:new.response_id is null) then
          IF INSERTING THEN
            SELECT canned_responses_pk_seq.nextval INTO :new.response_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.response_id := :old.response_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_db_images_pk_seq
        BEFORE INSERT OR UPDATE of id
        ON db_images FOR EACH ROW
BEGIN
        IF (:new.id is null) then
          IF INSERTING THEN
            SELECT db_images_pk_seq.nextval INTO :new.id FROM DUAL;
          ELSIF UPDATING THEN
            :new.id := :old.id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_doc_data_pk_seq
        BEFORE INSERT OR UPDATE of docid
        ON doc_data FOR EACH ROW
BEGIN
        IF (:new.docid is null) then
          IF INSERTING THEN
            SELECT doc_data_pk_seq.nextval INTO :new.docid FROM DUAL;
          ELSIF UPDATING THEN
            :new.docid := :old.docid;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_doc_groups_pk_seq
        BEFORE INSERT OR UPDATE of doc_group
        ON doc_groups FOR EACH ROW
BEGIN
        IF (:new.doc_group is null) then
          IF INSERTING THEN
            SELECT doc_groups_pk_seq.nextval INTO :new.doc_group FROM DUAL;
          ELSIF UPDATING THEN
            :new.doc_group := :old.doc_group;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_doc_states_pk_seq
        BEFORE INSERT OR UPDATE of stateid
        ON doc_states FOR EACH ROW
BEGIN
        IF (:new.stateid is null) then
          IF INSERTING THEN
            SELECT doc_states_pk_seq.nextval INTO :new.stateid FROM DUAL;
          ELSIF UPDATING THEN
            :new.stateid := :old.stateid;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_filemodule_monitor_pk_seq
        BEFORE INSERT OR UPDATE of id
        ON filemodule_monitor FOR EACH ROW
BEGIN
        IF (:new.id is null) then
          IF INSERTING THEN
            SELECT filemodule_monitor_pk_seq.nextval INTO :new.id FROM DUAL;
          ELSIF UPDATING THEN
            :new.id := :old.id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_forum_pk_seq
        BEFORE INSERT OR UPDATE of msg_id
        ON forum FOR EACH ROW
BEGIN
        IF (:new.msg_id is null) then
          IF INSERTING THEN
            SELECT forum_pk_seq.nextval INTO :new.msg_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.msg_id := :old.msg_id;
          END IF;
        END IF;
END;


/

/

CREATE OR REPLACE TRIGGER A_forum_group_list_pk_seq
        BEFORE INSERT OR UPDATE of group_forum_id
        ON forum_group_list FOR EACH ROW
BEGIN
        IF (:new.group_forum_id is null) then
          IF INSERTING THEN
            SELECT forum_group_list_pk_seq.nextval INTO :new.group_forum_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.group_forum_id := :old.group_forum_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_forum_monitor_forums_pk_seq
        BEFORE INSERT OR UPDATE of monitor_id
        ON forum_monitored_forums FOR EACH ROW
BEGIN
        IF (:new.monitor_id is null) then
          IF INSERTING THEN
            SELECT forum_monitor_forums_pk_seq.nextval INTO :new.monitor_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.monitor_id := :old.monitor_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_forum_saved_place_pk_seq
        BEFORE INSERT OR UPDATE of saved_place_id
        ON forum_saved_place FOR EACH ROW
BEGIN
        IF (:new.saved_place_id is null) then
          IF INSERTING THEN
            SELECT forum_saved_place_pk_seq.nextval INTO :new.saved_place_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.saved_place_id := :old.saved_place_id;
          END IF;
        END IF;
END;


/

/

CREATE OR REPLACE TRIGGER A_foundry_news_pk_seq
        BEFORE INSERT OR UPDATE of foundry_news_id
        ON foundry_news FOR EACH ROW
BEGIN
        IF (:new.foundry_news_id is null) then
          IF INSERTING THEN
            SELECT foundry_news_pk_seq.nextval INTO :new.foundry_news_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.foundry_news_id := :old.foundry_news_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_foundry_prefer_proj_pk_seq
        BEFORE INSERT OR UPDATE of foundry_project_id
        ON foundry_preferred_projects FOR EACH ROW
BEGIN
        IF (:new.foundry_project_id is null) then
          IF INSERTING THEN
            SELECT foundry_prefer_proj_pk_seq.nextval INTO :new.foundry_project_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.foundry_project_id := :old.foundry_project_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_foundry_projects_pk_seq
        BEFORE INSERT OR UPDATE of id
        ON foundry_projects FOR EACH ROW
BEGIN
        IF (:new.id is null) then
          IF INSERTING THEN
            SELECT foundry_projects_pk_seq.nextval INTO :new.id FROM DUAL;
          ELSIF UPDATING THEN
            :new.id := :old.id;
          END IF;
        END IF;
END;


/

/

/

/

/

/

/

CREATE OR REPLACE TRIGGER A_frs_file_pk_seq
        BEFORE INSERT OR UPDATE of file_id
        ON frs_file FOR EACH ROW
BEGIN
        IF (:new.file_id is null) then
          IF INSERTING THEN
            SELECT frs_file_pk_seq.nextval INTO :new.file_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.file_id := :old.file_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_frs_filetype_pk_seq
        BEFORE INSERT OR UPDATE of type_id
        ON frs_filetype FOR EACH ROW
BEGIN
        IF (:new.type_id is null) then
          IF INSERTING THEN
            SELECT frs_filetype_pk_seq.nextval INTO :new.type_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.type_id := :old.type_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_frs_package_pk_seq
        BEFORE INSERT OR UPDATE of package_id
        ON frs_package FOR EACH ROW
BEGIN
        IF (:new.package_id is null) then
          IF INSERTING THEN
            SELECT frs_package_pk_seq.nextval INTO :new.package_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.package_id := :old.package_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_frs_processor_pk_seq
        BEFORE INSERT OR UPDATE of processor_id
        ON frs_processor FOR EACH ROW
BEGIN
        IF (:new.processor_id is null) then
          IF INSERTING THEN
            SELECT frs_processor_pk_seq.nextval INTO :new.processor_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.processor_id := :old.processor_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_frs_release_pk_seq
        BEFORE INSERT OR UPDATE of release_id
        ON frs_release FOR EACH ROW
BEGIN
        IF (:new.release_id is null) then
          IF INSERTING THEN
            SELECT frs_release_pk_seq.nextval INTO :new.release_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.release_id := :old.release_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_frs_status_pk_seq
        BEFORE INSERT OR UPDATE of status_id