sourceforge2.5oci8-trigger_auto.sql

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

        ON frs_status FOR EACH ROW
BEGIN
        IF (:new.status_id is null) then
          IF INSERTING THEN
            SELECT frs_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_group_cvs_history_pk_seq
        BEFORE INSERT OR UPDATE of id
        ON group_cvs_history FOR EACH ROW
BEGIN
        IF (:new.id is null) then
          IF INSERTING THEN
            SELECT group_cvs_history_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_group_history_pk_seq
        BEFORE INSERT OR UPDATE of group_history_id
        ON group_history FOR EACH ROW
BEGIN
        IF (:new.group_history_id is null) then
          IF INSERTING THEN
            SELECT group_history_pk_seq.nextval INTO :new.group_history_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.group_history_id := :old.group_history_id;
          END IF;
        END IF;
END;


/

CREATE OR REPLACE TRIGGER A_group_type_pk_seq
        BEFORE INSERT OR UPDATE of type_id
        ON group_type FOR EACH ROW
BEGIN
        IF (:new.type_id is null) then
          IF INSERTING THEN
            SELECT group_type_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_groups_pk_seq
        BEFORE INSERT OR UPDATE of group_id
        ON groups FOR EACH ROW
BEGIN
        IF (:new.group_id is null) then
          IF INSERTING THEN
            SELECT groups_pk_seq.nextval INTO :new.group_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.group_id := :old.group_id;
          END IF;
        END IF;
END;


/

/

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


/

CREATE OR REPLACE TRIGGER A_news_bytes_pk_seq
        BEFORE INSERT OR UPDATE of id
        ON news_bytes FOR EACH ROW
BEGIN
        IF (:new.id is null) then
          IF INSERTING THEN
            SELECT news_bytes_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_patch_pk_seq
        BEFORE INSERT OR UPDATE of patch_id
        ON patch FOR EACH ROW
BEGIN
        IF (:new.patch_id is null) then
          IF INSERTING THEN
            SELECT patch_pk_seq.nextval INTO :new.patch_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.patch_id := :old.patch_id;
          END IF;
        END IF;
END;


/

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


/

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


/

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


/

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


/

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


/

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


/

CREATE OR REPLACE TRIGGER A_people_job_status_pk_seq
        BEFORE INSERT OR UPDATE of status_id
        ON people_job_status FOR EACH ROW
BEGIN
        IF (:new.status_id is null) then
          IF INSERTING THEN
            SELECT people_job_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_people_skill_pk_seq
        BEFORE INSERT OR UPDATE of skill_id
        ON people_skill FOR EACH ROW
BEGIN
        IF (:new.skill_id is null) then
          IF INSERTING THEN
            SELECT people_skill_pk_seq.nextval INTO :new.skill_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.skill_id := :old.skill_id;
          END IF;
        END IF;
END;


/

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


/

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


/

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


/

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


/

/

/

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


/

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


/

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


/

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


/

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


/

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


/

CREATE OR REPLACE TRIGGER A_project_status_pk_seq
        BEFORE INSERT OR UPDATE of status_id
        ON project_status FOR EACH ROW
BEGIN
        IF (:new.status_id is null) then
          IF INSERTING THEN
            SELECT project_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_project_task_pk_seq
        BEFORE INSERT OR UPDATE of project_task_id
        ON project_task FOR EACH ROW
BEGIN
        IF (:new.project_task_id is null) then
          IF INSERTING THEN
            SELECT project_task_pk_seq.nextval INTO :new.project_task_id FROM DUAL;
          ELSIF UPDATING THEN
            :new.project_task_id := :old.project_task_id;
          END IF;
        END IF;
END;


/

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


/