1 select setval('bug_pk_seq', (select max(bug_id)+1 from bug));
2 select setval('bug_bug_dependencies_pk_seq', (select max(bug_depend_id)+1 from bug_bug_dependencies));
3 select setval('bug_canned_responses_pk_seq', (select max(bug_canned_id)+1 from bug_canned_responses));
4 select setval('bug_category_pk_seq', (select max(bug_category_id)+1 from bug_category));
5 select setval('bug_filter_pk_seq', (select max(filter_id)+1 from bug_filter));
6 select setval('bug_group_pk_seq', (select max(bug_group_id)+1 from bug_group));
7 select setval('bug_history_pk_seq', (select max(bug_history_id)+1 from bug_history));
8 select setval('bug_resolution_pk_seq', (select max(resolution_id)+1 from bug_resolution));
9 select setval('bug_status_pk_seq', (select max(status_id)+1 from bug_status));
10 select setval('bug_task_dependencies_pk_seq', (select max(bug_depend_id)+1 from bug_task_dependencies));
11 select setval('canned_responses_pk_seq', (select max(response_id)+1 from canned_responses));
12 select setval('db_images_pk_seq', (select max(id)+1 from db_images));
13 select setval('doc_data_pk_seq', (select max(docid)+1 from doc_data));
14 select setval('doc_groups_pk_seq', (select max(doc_group)+1 from doc_groups));
15 select setval('doc_states_pk_seq', (select max(stateid)+1 from doc_states));
16 select setval('filemodule_monitor_pk_seq', (select max(id)+1 from filemodule_monitor));
17 select setval('forum_pk_seq', (select max(msg_id)+1 from forum));
18 select setval('forum_group_list_pk_seq', (select max(group_forum_id)+1 from forum_group_list));
19 select setval('forum_monitored_forums_pk_seq', (select max(monitor_id)+1 from forum_monitored_forums));
20 select setval('forum_saved_place_pk_seq', (select max(saved_place_id)+1 from forum_saved_place));
21 select setval('foundry_news_pk_seq', (select max(foundry_news_id)+1 from foundry_news));
22 select setval('foundry_preferred_projec_pk_seq', (select max(foundry_project_id)+1 from foundry_preferred_projects));
23 select setval('foundry_projects_pk_seq', (select max(id)+1 from foundry_projects));
24 select setval('frs_file_pk_seq', (select max(file_id)+1 from frs_file));
25 select setval('frs_filetype_pk_seq', (select max(type_id)+1 from frs_filetype));
26 select setval('frs_package_pk_seq', (select max(package_id)+1 from frs_package));
27 select setval('frs_processor_pk_seq', (select max(processor_id)+1 from frs_processor));
28 select setval('frs_release_pk_seq', (select max(release_id)+1 from frs_release));
29 select setval('frs_status_pk_seq', (select max(status_id)+1 from frs_status));
30 select setval('group_cvs_history_pk_seq', (select max(id)+1 from group_cvs_history));
31 select setval('group_history_pk_seq', (select max(group_history_id)+1 from group_history));
32 select setval('group_type_pk_seq', (select max(type_id)+1 from group_type));
33 select setval('groups_pk_seq', (select max(group_id)+1 from groups));
34 select setval('mail_group_list_pk_seq', (select max(group_list_id)+1 from mail_group_list));
35 select setval('news_bytes_pk_seq', (select max(id)+1 from news_bytes));
36 select setval('patch_pk_seq', (select max(patch_id)+1 from patch));
37 select setval('patch_category_pk_seq', (select max(patch_category_id)+1 from patch_category));
38 select setval('patch_history_pk_seq', (select max(patch_history_id)+1 from patch_history));
39 select setval('patch_status_pk_seq', (select max(patch_status_id)+1 from patch_status));
40 select setval('people_job_pk_seq', (select max(job_id)+1 from people_job));
41 select setval('people_job_category_pk_seq', (select max(category_id)+1 from people_job_category));
42 select setval('people_job_inventory_pk_seq', (select max(job_inventory_id)+1 from people_job_inventory));
43 select setval('people_job_status_pk_seq', (select max(status_id)+1 from people_job_status));
44 select setval('people_skill_pk_seq', (select max(skill_id)+1 from people_skill));
45 select setval('people_skill_inventory_pk_seq', (select max(skill_inventory_id)+1 from people_skill_inventory));
46 select setval('people_skill_level_pk_seq', (select max(skill_level_id)+1 from people_skill_level));
47 select setval('people_skill_year_pk_seq', (select max(skill_year_id)+1 from people_skill_year));
48 select setval('project_assigned_to_pk_seq', (select max(project_assigned_id)+1 from project_assigned_to));
49 select setval('project_dependencies_pk_seq', (select max(project_depend_id)+1 from project_dependencies));
50 select setval('project_group_list_pk_seq', (select max(group_project_id)+1 from project_group_list));
51 select setval('project_history_pk_seq', (select max(project_history_id)+1 from project_history));
52 select setval('project_metric_pk_seq', (select max(ranking)+1 from project_metric));
53 select setval('project_metric_tmp1_pk_seq', (select max(ranking)+1 from project_metric_tmp1));
54 select setval('project_status_pk_seq', (select max(status_id)+1 from project_status));
55 select setval('project_task_pk_seq', (select max(project_task_id)+1 from project_task));
56 select setval('project_weekly_metric_pk_seq', (select max(ranking)+1 from project_weekly_metric));
57 select setval('snippet_pk_seq', (select max(snippet_id)+1 from snippet));
58 select setval('snippet_package_pk_seq', (select max(snippet_package_id)+1 from snippet_package));
59 select setval('snippet_package_item_pk_seq', (select max(snippet_package_item_id)+1 from snippet_package_item));
60 select setval('snippet_package_version_pk_seq', (select max(snippet_package_id)+1 from snippet_package_version));
61 select setval('snippet_version_pk_seq', (select max(snippet_version_id)+1 from snippet_version));
62 select setval('support_pk_seq', (select max(support_id)+1 from support));
63 select setval('support_canned_responses_pk_seq', (select max(support_canned_id)+1 from support_canned_responses));
64 select setval('support_category_pk_seq', (select max(support_category_id)+1 from support_category));
65 select setval('support_history_pk_seq', (select max(support_history_id)+1 from support_history));
66 select setval('support_messages_pk_seq', (select max(support_message_id)+1 from support_messages));
67 select setval('support_status_pk_seq', (select max(support_status_id)+1 from support_status));
68 select setval('supported_languages_pk_seq', (select max(language_id)+1 from supported_languages));
69 select setval('survey_question_types_pk_seq', (select max(id)+1 from survey_question_types));
70 select setval('survey_questions_pk_seq', (select max(question_id)+1 from survey_questions));
71 select setval('surveys_pk_seq', (select max(survey_id)+1 from surveys));
72 select setval('themes_pk_seq', (select max(theme_id)+1 from themes));
73 select setval('trove_cat_pk_seq', (select max(trove_cat_id)+1 from trove_cat));
74 select setval('trove_group_link_pk_seq', (select max(trove_group_id)+1 from trove_group_link));
75 select setval('trove_treesums_pk_seq', (select max(trove_treesums_id)+1 from trove_treesums));
76 select setval('user_bookmarks_pk_seq', (select max(bookmark_id)+1 from user_bookmarks));
77 select setval('user_diary_pk_seq', (select max(id)+1 from user_diary));
78 select setval('user_diary_monitor_pk_seq', (select max(monitor_id)+1 from user_diary_monitor));
79 select setval('user_group_pk_seq', (select max(user_group_id)+1 from user_group));
80 select setval('user_metric_pk_seq', (select max(ranking)+1 from user_metric));
81 select setval('user_metric0_pk_seq', (select max(ranking)+1 from user_metric0));
82 select setval('users_pk_seq', (select max(user_id)+1 from users));