2 CREATE OR REPLACE TRIGGER A_bug_pk_seq
3 BEFORE INSERT OR UPDATE of bug_id
6 IF (:new.bug_id is null) then
8 SELECT bug_pk_seq.nextval INTO :new.bug_id FROM DUAL;
10 :new.bug_id := :old.bug_id;
18 CREATE OR REPLACE TRIGGER A_bug_bug_dependencies_pk_seq
19 BEFORE INSERT OR UPDATE of bug_depend_id
20 ON bug_bug_dependencies FOR EACH ROW
22 IF (:new.bug_depend_id is null) then
24 SELECT bug_bug_dependencies_pk_seq.nextval INTO :new.bug_depend_id FROM DUAL;
26 :new.bug_depend_id := :old.bug_depend_id;
34 CREATE OR REPLACE TRIGGER A_bug_canned_responses_pk_seq
35 BEFORE INSERT OR UPDATE of bug_canned_id
36 ON bug_canned_responses FOR EACH ROW
38 IF (:new.bug_canned_id is null) then
40 SELECT bug_canned_responses_pk_seq.nextval INTO :new.bug_canned_id FROM DUAL;
42 :new.bug_canned_id := :old.bug_canned_id;
50 CREATE OR REPLACE TRIGGER A_bug_category_pk_seq
51 BEFORE INSERT OR UPDATE of bug_category_id
52 ON bug_category FOR EACH ROW
54 IF (:new.bug_category_id is null) then
56 SELECT bug_category_pk_seq.nextval INTO :new.bug_category_id FROM DUAL;
58 :new.bug_category_id := :old.bug_category_id;
66 CREATE OR REPLACE TRIGGER A_bug_filter_pk_seq
67 BEFORE INSERT OR UPDATE of filter_id
68 ON bug_filter FOR EACH ROW
70 IF (:new.filter_id is null) then
72 SELECT bug_filter_pk_seq.nextval INTO :new.filter_id FROM DUAL;
74 :new.filter_id := :old.filter_id;
82 CREATE OR REPLACE TRIGGER A_bug_group_pk_seq
83 BEFORE INSERT OR UPDATE of bug_group_id
84 ON bug_group FOR EACH ROW
86 IF (:new.bug_group_id is null) then
88 SELECT bug_group_pk_seq.nextval INTO :new.bug_group_id FROM DUAL;
90 :new.bug_group_id := :old.bug_group_id;
98 CREATE OR REPLACE TRIGGER A_bug_history_pk_seq
99 BEFORE INSERT OR UPDATE of bug_history_id
100 ON bug_history FOR EACH ROW
102 IF (:new.bug_history_id is null) then
104 SELECT bug_history_pk_seq.nextval INTO :new.bug_history_id FROM DUAL;
106 :new.bug_history_id := :old.bug_history_id;
114 CREATE OR REPLACE TRIGGER A_bug_resolution_pk_seq
115 BEFORE INSERT OR UPDATE of resolution_id
116 ON bug_resolution FOR EACH ROW
118 IF (:new.resolution_id is null) then
120 SELECT bug_resolution_pk_seq.nextval INTO :new.resolution_id FROM DUAL;
122 :new.resolution_id := :old.resolution_id;
130 CREATE OR REPLACE TRIGGER A_bug_status_pk_seq
131 BEFORE INSERT OR UPDATE of status_id
132 ON bug_status FOR EACH ROW
134 IF (:new.status_id is null) then
136 SELECT bug_status_pk_seq.nextval INTO :new.status_id FROM DUAL;
138 :new.status_id := :old.status_id;
146 CREATE OR REPLACE TRIGGER A_bug_task_dependencies_pk_seq
147 BEFORE INSERT OR UPDATE of bug_depend_id
148 ON bug_task_dependencies FOR EACH ROW
150 IF (:new.bug_depend_id is null) then
152 SELECT bug_task_dependencies_pk_seq.nextval INTO :new.bug_depend_id FROM DUAL;
154 :new.bug_depend_id := :old.bug_depend_id;
162 CREATE OR REPLACE TRIGGER A_canned_responses_pk_seq
163 BEFORE INSERT OR UPDATE of response_id
164 ON canned_responses FOR EACH ROW
166 IF (:new.response_id is null) then
168 SELECT canned_responses_pk_seq.nextval INTO :new.response_id FROM DUAL;
170 :new.response_id := :old.response_id;
178 CREATE OR REPLACE TRIGGER A_db_images_pk_seq
179 BEFORE INSERT OR UPDATE of id
180 ON db_images FOR EACH ROW
182 IF (:new.id is null) then
184 SELECT db_images_pk_seq.nextval INTO :new.id FROM DUAL;
194 CREATE OR REPLACE TRIGGER A_doc_data_pk_seq
195 BEFORE INSERT OR UPDATE of docid
196 ON doc_data FOR EACH ROW
198 IF (:new.docid is null) then
200 SELECT doc_data_pk_seq.nextval INTO :new.docid FROM DUAL;
202 :new.docid := :old.docid;
210 CREATE OR REPLACE TRIGGER A_doc_groups_pk_seq
211 BEFORE INSERT OR UPDATE of doc_group
212 ON doc_groups FOR EACH ROW
214 IF (:new.doc_group is null) then
216 SELECT doc_groups_pk_seq.nextval INTO :new.doc_group FROM DUAL;
218 :new.doc_group := :old.doc_group;
226 CREATE OR REPLACE TRIGGER A_doc_states_pk_seq
227 BEFORE INSERT OR UPDATE of stateid
228 ON doc_states FOR EACH ROW
230 IF (:new.stateid is null) then
232 SELECT doc_states_pk_seq.nextval INTO :new.stateid FROM DUAL;
234 :new.stateid := :old.stateid;
242 CREATE OR REPLACE TRIGGER A_filemodule_monitor_pk_seq
243 BEFORE INSERT OR UPDATE of id
244 ON filemodule_monitor FOR EACH ROW
246 IF (:new.id is null) then
248 SELECT filemodule_monitor_pk_seq.nextval INTO :new.id FROM DUAL;
258 CREATE OR REPLACE TRIGGER A_forum_pk_seq
259 BEFORE INSERT OR UPDATE of msg_id
260 ON forum FOR EACH ROW
262 IF (:new.msg_id is null) then
264 SELECT forum_pk_seq.nextval INTO :new.msg_id FROM DUAL;
266 :new.msg_id := :old.msg_id;
276 CREATE OR REPLACE TRIGGER A_forum_group_list_pk_seq
277 BEFORE INSERT OR UPDATE of group_forum_id
278 ON forum_group_list FOR EACH ROW
280 IF (:new.group_forum_id is null) then
282 SELECT forum_group_list_pk_seq.nextval INTO :new.group_forum_id FROM DUAL;
284 :new.group_forum_id := :old.group_forum_id;
292 CREATE OR REPLACE TRIGGER A_forum_monitor_forums_pk_seq
293 BEFORE INSERT OR UPDATE of monitor_id
294 ON forum_monitored_forums FOR EACH ROW
296 IF (:new.monitor_id is null) then
298 SELECT forum_monitor_forums_pk_seq.nextval INTO :new.monitor_id FROM DUAL;
300 :new.monitor_id := :old.monitor_id;
308 CREATE OR REPLACE TRIGGER A_forum_saved_place_pk_seq
309 BEFORE INSERT OR UPDATE of saved_place_id
310 ON forum_saved_place FOR EACH ROW
312 IF (:new.saved_place_id is null) then
314 SELECT forum_saved_place_pk_seq.nextval INTO :new.saved_place_id FROM DUAL;
316 :new.saved_place_id := :old.saved_place_id;
326 CREATE OR REPLACE TRIGGER A_foundry_news_pk_seq
327 BEFORE INSERT OR UPDATE of foundry_news_id
328 ON foundry_news FOR EACH ROW
330 IF (:new.foundry_news_id is null) then
332 SELECT foundry_news_pk_seq.nextval INTO :new.foundry_news_id FROM DUAL;
334 :new.foundry_news_id := :old.foundry_news_id;
342 CREATE OR REPLACE TRIGGER A_foundry_prefer_proj_pk_seq
343 BEFORE INSERT OR UPDATE of foundry_project_id
344 ON foundry_preferred_projects FOR EACH ROW
346 IF (:new.foundry_project_id is null) then
348 SELECT foundry_prefer_proj_pk_seq.nextval INTO :new.foundry_project_id FROM DUAL;
350 :new.foundry_project_id := :old.foundry_project_id;
358 CREATE OR REPLACE TRIGGER A_foundry_projects_pk_seq
359 BEFORE INSERT OR UPDATE of id
360 ON foundry_projects FOR EACH ROW
362 IF (:new.id is null) then
364 SELECT foundry_projects_pk_seq.nextval INTO :new.id FROM DUAL;
386 CREATE OR REPLACE TRIGGER A_frs_file_pk_seq
387 BEFORE INSERT OR UPDATE of file_id
388 ON frs_file FOR EACH ROW
390 IF (:new.file_id is null) then
392 SELECT frs_file_pk_seq.nextval INTO :new.file_id FROM DUAL;
394 :new.file_id := :old.file_id;
402 CREATE OR REPLACE TRIGGER A_frs_filetype_pk_seq
403 BEFORE INSERT OR UPDATE of type_id
404 ON frs_filetype FOR EACH ROW
406 IF (:new.type_id is null) then
408 SELECT frs_filetype_pk_seq.nextval INTO :new.type_id FROM DUAL;
410 :new.type_id := :old.type_id;
418 CREATE OR REPLACE TRIGGER A_frs_package_pk_seq
419 BEFORE INSERT OR UPDATE of package_id
420 ON frs_package FOR EACH ROW
422 IF (:new.package_id is null) then
424 SELECT frs_package_pk_seq.nextval INTO :new.package_id FROM DUAL;
426 :new.package_id := :old.package_id;
434 CREATE OR REPLACE TRIGGER A_frs_processor_pk_seq
435 BEFORE INSERT OR UPDATE of processor_id
436 ON frs_processor FOR EACH ROW
438 IF (:new.processor_id is null) then
440 SELECT frs_processor_pk_seq.nextval INTO :new.processor_id FROM DUAL;
442 :new.processor_id := :old.processor_id;
450 CREATE OR REPLACE TRIGGER A_frs_release_pk_seq
451 BEFORE INSERT OR UPDATE of release_id
452 ON frs_release FOR EACH ROW
454 IF (:new.release_id is null) then
456 SELECT frs_release_pk_seq.nextval INTO :new.release_id FROM DUAL;
458 :new.release_id := :old.release_id;
466 CREATE OR REPLACE TRIGGER A_frs_status_pk_seq
467 BEFORE INSERT OR UPDATE of status_id
468 ON frs_status FOR EACH ROW
470 IF (:new.status_id is null) then
472 SELECT frs_status_pk_seq.nextval INTO :new.status_id FROM DUAL;
474 :new.status_id := :old.status_id;
482 CREATE OR REPLACE TRIGGER A_group_cvs_history_pk_seq
483 BEFORE INSERT OR UPDATE of id
484 ON group_cvs_history FOR EACH ROW
486 IF (:new.id is null) then
488 SELECT group_cvs_history_pk_seq.nextval INTO :new.id FROM DUAL;
498 CREATE OR REPLACE TRIGGER A_group_history_pk_seq
499 BEFORE INSERT OR UPDATE of group_history_id
500 ON group_history FOR EACH ROW
502 IF (:new.group_history_id is null) then
504 SELECT group_history_pk_seq.nextval INTO :new.group_history_id FROM DUAL;
506 :new.group_history_id := :old.group_history_id;
514 CREATE OR REPLACE TRIGGER A_group_type_pk_seq
515 BEFORE INSERT OR UPDATE of type_id
516 ON group_type FOR EACH ROW
518 IF (:new.type_id is null) then
520 SELECT group_type_pk_seq.nextval INTO :new.type_id FROM DUAL;
522 :new.type_id := :old.type_id;
530 CREATE OR REPLACE TRIGGER A_groups_pk_seq
531 BEFORE INSERT OR UPDATE of group_id
532 ON groups FOR EACH ROW
534 IF (:new.group_id is null) then
536 SELECT groups_pk_seq.nextval INTO :new.group_id FROM DUAL;
538 :new.group_id := :old.group_id;
548 CREATE OR REPLACE TRIGGER A_mail_group_list_pk_seq
549 BEFORE INSERT OR UPDATE of group_list_id
550 ON mail_group_list FOR EACH ROW
552 IF (:new.group_list_id is null) then
554 SELECT mail_group_list_pk_seq.nextval INTO :new.group_list_id FROM DUAL;
556 :new.group_list_id := :old.group_list_id;
564 CREATE OR REPLACE TRIGGER A_news_bytes_pk_seq
565 BEFORE INSERT OR UPDATE of id
566 ON news_bytes FOR EACH ROW
568 IF (:new.id is null) then
570 SELECT news_bytes_pk_seq.nextval INTO :new.id FROM DUAL;
580 CREATE OR REPLACE TRIGGER A_patch_pk_seq
581 BEFORE INSERT OR UPDATE of patch_id
582 ON patch FOR EACH ROW
584 IF (:new.patch_id is null) then
586 SELECT patch_pk_seq.nextval INTO :new.patch_id FROM DUAL;
588 :new.patch_id := :old.patch_id;
596 CREATE OR REPLACE TRIGGER A_patch_category_pk_seq
597 BEFORE INSERT OR UPDATE of patch_category_id
598 ON patch_category FOR EACH ROW
600 IF (:new.patch_category_id is null) then
602 SELECT patch_category_pk_seq.nextval INTO :new.patch_category_id FROM DUAL;
604 :new.patch_category_id := :old.patch_category_id;
612 CREATE OR REPLACE TRIGGER A_patch_history_pk_seq
613 BEFORE INSERT OR UPDATE of patch_history_id
614 ON patch_history FOR EACH ROW
616 IF (:new.patch_history_id is null) then
618 SELECT patch_history_pk_seq.nextval INTO :new.patch_history_id FROM DUAL;
620 :new.patch_history_id := :old.patch_history_id;
628 CREATE OR REPLACE TRIGGER A_patch_status_pk_seq
629 BEFORE INSERT OR UPDATE of patch_status_id
630 ON patch_status FOR EACH ROW
632 IF (:new.patch_status_id is null) then
634 SELECT patch_status_pk_seq.nextval INTO :new.patch_status_id FROM DUAL;
636 :new.patch_status_id := :old.patch_status_id;
644 CREATE OR REPLACE TRIGGER A_people_job_pk_seq
645 BEFORE INSERT OR UPDATE of job_id
646 ON people_job FOR EACH ROW
648 IF (:new.job_id is null) then
650 SELECT people_job_pk_seq.nextval INTO :new.job_id FROM DUAL;
652 :new.job_id := :old.job_id;
660 CREATE OR REPLACE TRIGGER A_people_job_category_pk_seq
661 BEFORE INSERT OR UPDATE of category_id
662 ON people_job_category FOR EACH ROW
664 IF (:new.category_id is null) then
666 SELECT people_job_category_pk_seq.nextval INTO :new.category_id FROM DUAL;
668 :new.category_id := :old.category_id;
676 CREATE OR REPLACE TRIGGER A_people_job_inventory_pk_seq
677 BEFORE INSERT OR UPDATE of job_inventory_id
678 ON people_job_inventory FOR EACH ROW
680 IF (:new.job_inventory_id is null) then
682 SELECT people_job_inventory_pk_seq.nextval INTO :new.job_inventory_id FROM DUAL;
684 :new.job_inventory_id := :old.job_inventory_id;
692 CREATE OR REPLACE TRIGGER A_people_job_status_pk_seq
693 BEFORE INSERT OR UPDATE of status_id
694 ON people_job_status FOR EACH ROW
696 IF (:new.status_id is null) then
698 SELECT people_job_status_pk_seq.nextval INTO :new.status_id FROM DUAL;
700 :new.status_id := :old.status_id;
708 CREATE OR REPLACE TRIGGER A_people_skill_pk_seq
709 BEFORE INSERT OR UPDATE of skill_id
710 ON people_skill FOR EACH ROW
712 IF (:new.skill_id is null) then
714 SELECT people_skill_pk_seq.nextval INTO :new.skill_id FROM DUAL;
716 :new.skill_id := :old.skill_id;
724 CREATE OR REPLACE TRIGGER A_people_skill_inv_pk_seq
725 BEFORE INSERT OR UPDATE of skill_inventory_id
726 ON people_skill_inventory FOR EACH ROW
728 IF (:new.skill_inventory_id is null) then
730 SELECT people_skill_inv_pk_seq.nextval INTO :new.skill_inventory_id FROM DUAL;
732 :new.skill_inventory_id := :old.skill_inventory_id;
740 CREATE OR REPLACE TRIGGER A_people_skill_level_pk_seq
741 BEFORE INSERT OR UPDATE of skill_level_id
742 ON people_skill_level FOR EACH ROW
744 IF (:new.skill_level_id is null) then
746 SELECT people_skill_level_pk_seq.nextval INTO :new.skill_level_id FROM DUAL;
748 :new.skill_level_id := :old.skill_level_id;
756 CREATE OR REPLACE TRIGGER A_people_skill_year_pk_seq
757 BEFORE INSERT OR UPDATE of skill_year_id
758 ON people_skill_year FOR EACH ROW
760 IF (:new.skill_year_id is null) then
762 SELECT people_skill_year_pk_seq.nextval INTO :new.skill_year_id FROM DUAL;
764 :new.skill_year_id := :old.skill_year_id;
772 CREATE OR REPLACE TRIGGER A_project_assigned_to_pk_seq
773 BEFORE INSERT OR UPDATE of project_assigned_id
774 ON project_assigned_to FOR EACH ROW
776 IF (:new.project_assigned_id is null) then
778 SELECT project_assigned_to_pk_seq.nextval INTO :new.project_assigned_id FROM DUAL;
780 :new.project_assigned_id := :old.project_assigned_id;
792 CREATE OR REPLACE TRIGGER A_project_dependencies_pk_seq
793 BEFORE INSERT OR UPDATE of project_depend_id
794 ON project_dependencies FOR EACH ROW
796 IF (:new.project_depend_id is null) then
798 SELECT project_dependencies_pk_seq.nextval INTO :new.project_depend_id FROM DUAL;
800 :new.project_depend_id := :old.project_depend_id;
808 CREATE OR REPLACE TRIGGER A_project_group_list_pk_seq
809 BEFORE INSERT OR UPDATE of group_project_id
810 ON project_group_list FOR EACH ROW
812 IF (:new.group_project_id is null) then
814 SELECT project_group_list_pk_seq.nextval INTO :new.group_project_id FROM DUAL;
816 :new.group_project_id := :old.group_project_id;
824 CREATE OR REPLACE TRIGGER A_project_history_pk_seq
825 BEFORE INSERT OR UPDATE of project_history_id
826 ON project_history FOR EACH ROW
828 IF (:new.project_history_id is null) then
830 SELECT project_history_pk_seq.nextval INTO :new.project_history_id FROM DUAL;
832 :new.project_history_id := :old.project_history_id;
840 CREATE OR REPLACE TRIGGER A_project_metric_pk_seq
841 BEFORE INSERT OR UPDATE of ranking
842 ON project_metric FOR EACH ROW
844 IF (:new.ranking is null) then
846 SELECT project_metric_pk_seq.nextval INTO :new.ranking FROM DUAL;
848 :new.ranking := :old.ranking;
856 CREATE OR REPLACE TRIGGER A_project_metric_tmp1_pk_seq
857 BEFORE INSERT OR UPDATE of ranking
858 ON project_metric_tmp1 FOR EACH ROW
860 IF (:new.ranking is null) then
862 SELECT project_metric_tmp1_pk_seq.nextval INTO :new.ranking FROM DUAL;
864 :new.ranking := :old.ranking;
872 CREATE OR REPLACE TRIGGER A_proj_metric_weekly_tm_pk_seq
873 BEFORE INSERT OR UPDATE of ranking
874 ON project_metric_weekly_tmp1 FOR EACH ROW
876 IF (:new.ranking is null) then
878 SELECT proj_metric_weekly_tm_pk_seq.nextval INTO :new.ranking FROM DUAL;
880 :new.ranking := :old.ranking;
888 CREATE OR REPLACE TRIGGER A_project_status_pk_seq
889 BEFORE INSERT OR UPDATE of status_id
890 ON project_status FOR EACH ROW
892 IF (:new.status_id is null) then
894 SELECT project_status_pk_seq.nextval INTO :new.status_id FROM DUAL;
896 :new.status_id := :old.status_id;
904 CREATE OR REPLACE TRIGGER A_project_task_pk_seq
905 BEFORE INSERT OR UPDATE of project_task_id
906 ON project_task FOR EACH ROW
908 IF (:new.project_task_id is null) then
910 SELECT project_task_pk_seq.nextval INTO :new.project_task_id FROM DUAL;
912 :new.project_task_id := :old.project_task_id;
920 CREATE OR REPLACE TRIGGER A_project_weekly_metric_pk_seq
921 BEFORE INSERT OR UPDATE of ranking
922 ON project_weekly_metric FOR EACH ROW
924 IF (:new.ranking is null) then
926 SELECT project_weekly_metric_pk_seq.nextval INTO :new.ranking FROM DUAL;
928 :new.ranking := :old.ranking;
938 CREATE OR REPLACE TRIGGER A_snippet_pk_seq
939 BEFORE INSERT OR UPDATE of snippet_id
940 ON snippet FOR EACH ROW
942 IF (:new.snippet_id is null) then
944 SELECT snippet_pk_seq.nextval INTO :new.snippet_id FROM DUAL;
946 :new.snippet_id := :old.snippet_id;
954 CREATE OR REPLACE TRIGGER A_snippet_package_pk_seq
955 BEFORE INSERT OR UPDATE of snippet_package_id
956 ON snippet_package FOR EACH ROW
958 IF (:new.snippet_package_id is null) then
960 SELECT snippet_package_pk_seq.nextval INTO :new.snippet_package_id FROM DUAL;
962 :new.snippet_package_id := :old.snippet_package_id;
970 CREATE OR REPLACE TRIGGER A_snippet_package_item_pk_seq
971 BEFORE INSERT OR UPDATE of snippet_package_item_id
972 ON snippet_package_item FOR EACH ROW
974 IF (:new.snippet_package_item_id is null) then
976 SELECT snippet_package_item_pk_seq.nextval INTO :new.snippet_package_item_id FROM DUAL;
978 :new.snippet_package_item_id := :old.snippet_package_item_id;
986 CREATE OR REPLACE TRIGGER A_snippet_package_ver_pk_seq
987 BEFORE INSERT OR UPDATE of snippet_package_version_id
988 ON snippet_package_version FOR EACH ROW
990 IF (:new.snippet_package_version_id is null) then
992 SELECT snippet_package_ver_pk_seq.nextval INTO :new.snippet_package_version_id FROM DUAL;
994 :new.snippet_package_version_id := :old.snippet_package_version_id;
1002 CREATE OR REPLACE TRIGGER A_snippet_version_pk_seq
1003 BEFORE INSERT OR UPDATE of snippet_version_id
1004 ON snippet_version FOR EACH ROW
1006 IF (:new.snippet_version_id is null) then
1008 SELECT snippet_version_pk_seq.nextval INTO :new.snippet_version_id FROM DUAL;
1010 :new.snippet_version_id := :old.snippet_version_id;
1046 CREATE OR REPLACE TRIGGER A_support_pk_seq
1047 BEFORE INSERT OR UPDATE of support_id
1048 ON support FOR EACH ROW
1050 IF (:new.support_id is null) then
1052 SELECT support_pk_seq.nextval INTO :new.support_id FROM DUAL;
1054 :new.support_id := :old.support_id;
1062 CREATE OR REPLACE TRIGGER A_support_canned_res_pk_seq
1063 BEFORE INSERT OR UPDATE of support_canned_id
1064 ON support_canned_responses FOR EACH ROW
1066 IF (:new.support_canned_id is null) then
1068 SELECT support_canned_res_pk_seq.nextval INTO :new.support_canned_id FROM DUAL;
1070 :new.support_canned_id := :old.support_canned_id;
1078 CREATE OR REPLACE TRIGGER A_support_category_pk_seq
1079 BEFORE INSERT OR UPDATE of support_category_id
1080 ON support_category FOR EACH ROW
1082 IF (:new.support_category_id is null) then
1084 SELECT support_category_pk_seq.nextval INTO :new.support_category_id FROM DUAL;
1086 :new.support_category_id := :old.support_category_id;
1094 CREATE OR REPLACE TRIGGER A_support_history_pk_seq
1095 BEFORE INSERT OR UPDATE of support_history_id
1096 ON support_history FOR EACH ROW
1098 IF (:new.support_history_id is null) then
1100 SELECT support_history_pk_seq.nextval INTO :new.support_history_id FROM DUAL;
1102 :new.support_history_id := :old.support_history_id;
1110 CREATE OR REPLACE TRIGGER A_support_messages_pk_seq
1111 BEFORE INSERT OR UPDATE of support_message_id
1112 ON support_messages FOR EACH ROW
1114 IF (:new.support_message_id is null) then
1116 SELECT support_messages_pk_seq.nextval INTO :new.support_message_id FROM DUAL;
1118 :new.support_message_id := :old.support_message_id;
1126 CREATE OR REPLACE TRIGGER A_support_status_pk_seq
1127 BEFORE INSERT OR UPDATE of support_status_id
1128 ON support_status FOR EACH ROW
1130 IF (:new.support_status_id is null) then
1132 SELECT support_status_pk_seq.nextval INTO :new.support_status_id FROM DUAL;
1134 :new.support_status_id := :old.support_status_id;
1142 CREATE OR REPLACE TRIGGER A_supported_languages_pk_seq
1143 BEFORE INSERT OR UPDATE of language_id
1144 ON supported_languages FOR EACH ROW
1146 IF (:new.language_id is null) then
1148 SELECT supported_languages_pk_seq.nextval INTO :new.language_id FROM DUAL;
1150 :new.language_id := :old.language_id;
1158 CREATE OR REPLACE TRIGGER A_survey_question_types_pk_seq
1159 BEFORE INSERT OR UPDATE of id
1160 ON survey_question_types FOR EACH ROW
1162 IF (:new.id is null) then
1164 SELECT survey_question_types_pk_seq.nextval INTO :new.id FROM DUAL;
1174 CREATE OR REPLACE TRIGGER A_survey_questions_pk_seq
1175 BEFORE INSERT OR UPDATE of question_id
1176 ON survey_questions FOR EACH ROW
1178 IF (:new.question_id is null) then
1180 SELECT survey_questions_pk_seq.nextval INTO :new.question_id FROM DUAL;
1182 :new.question_id := :old.question_id;
1196 CREATE OR REPLACE TRIGGER A_surveys_pk_seq
1197 BEFORE INSERT OR UPDATE of survey_id
1198 ON surveys FOR EACH ROW
1200 IF (:new.survey_id is null) then
1202 SELECT surveys_pk_seq.nextval INTO :new.survey_id FROM DUAL;
1204 :new.survey_id := :old.survey_id;
1214 CREATE OR REPLACE TRIGGER A_themes_pk_seq
1215 BEFORE INSERT OR UPDATE of theme_id
1216 ON themes FOR EACH ROW
1218 IF (:new.theme_id is null) then
1220 SELECT themes_pk_seq.nextval INTO :new.theme_id FROM DUAL;
1222 :new.theme_id := :old.theme_id;
1234 CREATE OR REPLACE TRIGGER A_trove_cat_pk_seq
1235 BEFORE INSERT OR UPDATE of trove_cat_id
1236 ON trove_cat FOR EACH ROW
1238 IF (:new.trove_cat_id is null) then
1240 SELECT trove_cat_pk_seq.nextval INTO :new.trove_cat_id FROM DUAL;
1242 :new.trove_cat_id := :old.trove_cat_id;
1250 CREATE OR REPLACE TRIGGER A_trove_group_link_pk_seq
1251 BEFORE INSERT OR UPDATE of trove_group_id
1252 ON trove_group_link FOR EACH ROW
1254 IF (:new.trove_group_id is null) then
1256 SELECT trove_group_link_pk_seq.nextval INTO :new.trove_group_id FROM DUAL;
1258 :new.trove_group_id := :old.trove_group_id;
1266 CREATE OR REPLACE TRIGGER A_trove_treesums_pk_seq
1267 BEFORE INSERT OR UPDATE of trove_treesums_id
1268 ON trove_treesums FOR EACH ROW
1270 IF (:new.trove_treesums_id is null) then
1272 SELECT trove_treesums_pk_seq.nextval INTO :new.trove_treesums_id FROM DUAL;
1274 :new.trove_treesums_id := :old.trove_treesums_id;
1282 CREATE OR REPLACE TRIGGER A_user_bookmarks_pk_seq
1283 BEFORE INSERT OR UPDATE of bookmark_id
1284 ON user_bookmarks FOR EACH ROW
1286 IF (:new.bookmark_id is null) then
1288 SELECT user_bookmarks_pk_seq.nextval INTO :new.bookmark_id FROM DUAL;
1290 :new.bookmark_id := :old.bookmark_id;
1298 CREATE OR REPLACE TRIGGER A_user_diary_pk_seq
1299 BEFORE INSERT OR UPDATE of id
1300 ON user_diary FOR EACH ROW
1302 IF (:new.id is null) then
1304 SELECT user_diary_pk_seq.nextval INTO :new.id FROM DUAL;
1314 CREATE OR REPLACE TRIGGER A_user_diary_monitor_pk_seq
1315 BEFORE INSERT OR UPDATE of monitor_id
1316 ON user_diary_monitor FOR EACH ROW
1318 IF (:new.monitor_id is null) then
1320 SELECT user_diary_monitor_pk_seq.nextval INTO :new.monitor_id FROM DUAL;
1322 :new.monitor_id := :old.monitor_id;
1330 CREATE OR REPLACE TRIGGER A_user_group_pk_seq
1331 BEFORE INSERT OR UPDATE of user_group_id
1332 ON user_group FOR EACH ROW
1334 IF (:new.user_group_id is null) then
1336 SELECT user_group_pk_seq.nextval INTO :new.user_group_id FROM DUAL;
1338 :new.user_group_id := :old.user_group_id;
1346 CREATE OR REPLACE TRIGGER A_user_metric_pk_seq
1347 BEFORE INSERT OR UPDATE of ranking
1348 ON user_metric FOR EACH ROW
1350 IF (:new.ranking is null) then
1352 SELECT user_metric_pk_seq.nextval INTO :new.ranking FROM DUAL;
1354 :new.ranking := :old.ranking;
1362 CREATE OR REPLACE TRIGGER A_user_metric0_pk_seq
1363 BEFORE INSERT OR UPDATE of ranking
1364 ON user_metric0 FOR EACH ROW
1366 IF (:new.ranking is null) then
1368 SELECT user_metric0_pk_seq.nextval INTO :new.ranking FROM DUAL;
1370 :new.ranking := :old.ranking;
1382 CREATE OR REPLACE TRIGGER A_users_pk_seq
1383 BEFORE INSERT OR UPDATE of user_id
1384 ON users FOR EACH ROW
1386 IF (:new.user_id is null) then
1388 SELECT users_pk_seq.nextval INTO :new.user_id FROM DUAL;
1390 :new.user_id := :old.user_id;