1 ALTER FUNCTION frs_dlstats_filetotal_insert_ag() RENAME TO frs_dlstats_filetotal_insert_agg;
3 ALTER TABLE ONLY artifact_type_monitor ADD CONSTRAINT artifact_type_monitor_group_artifact_id_fkey FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) ON DELETE CASCADE;
4 ALTER TABLE ONLY artifact_type_monitor ADD CONSTRAINT artifact_type_monitor_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id);
6 ALTER TABLE artifact_type_monitor DROP CONSTRAINT "$1";
7 ALTER TABLE artifact_type_monitor DROP CONSTRAINT "$2";
9 ALTER TABLE ONLY forum_attachment ADD CONSTRAINT forum_attachment_msg_id_fkey FOREIGN KEY (msg_id) REFERENCES forum(msg_id) ON DELETE CASCADE;
10 ALTER TABLE ONLY forum_attachment ADD CONSTRAINT forum_attachment_userid_fkey FOREIGN KEY (userid) REFERENCES users(user_id) ON DELETE SET DEFAULT;
12 ALTER TABLE forum_attachment DROP CONSTRAINT "$1";
13 ALTER TABLE forum_attachment DROP CONSTRAINT "$2";
15 ALTER SEQUENCE supported_langu_language_id_seq RENAME TO supported_languages_pk_seq;
16 ALTER SEQUENCE group_cvs_history_id_seq RENAME TO group_cvs_history_pk_seq;
17 ALTER SEQUENCE project_messa_project_messa_seq RENAME TO project_messages_project_message_id_seq;
18 ALTER TABLE activity_log ALTER COLUMN ver SET DEFAULT 0::double precision;
19 ALTER TABLE artifact_extra_field_data ALTER COLUMN data_id SET DEFAULT nextval('artifact_extra_field_data_data_id_seq'::regclass);
20 ALTER TABLE artifact_extra_field_list ALTER COLUMN extra_field_id SET DEFAULT nextval('artifact_extra_field_list_extra_field_id_seq'::regclass);
21 ALTER TABLE artifact_extra_field_elements ALTER COLUMN element_id SET DEFAULT nextval('artifact_extra_field_elements_element_id_seq'::regclass);
23 ALTER TABLE db_images ALTER COLUMN upload_date SET DEFAULT 0;
24 ALTER TABLE db_images ALTER COLUMN version SET DEFAULT 0;
26 ALTER TABLE group_join_request DROP CONSTRAINT "$1";
27 ALTER TABLE group_join_request DROP CONSTRAINT "$2";
28 ALTER TABLE group_join_request ADD CONSTRAINT group_join_request_group_id_fkey FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE CASCADE;
29 ALTER TABLE group_join_request ADD CONSTRAINT group_join_request_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id);
30 ALTER TABLE groups ADD CONSTRAINT groups_license FOREIGN KEY (license) REFERENCES licenses(license_id) MATCH FULL;
32 DROP INDEX plugins_plugin_name_key;
33 ALTER TABLE plugins ADD CONSTRAINT plugins_plugin_name_key UNIQUE (plugin_name);
34 ALTER TABLE project_category ADD CONSTRAINT project_category_pkey PRIMARY KEY (category_id);
35 ALTER TABLE project_tags ADD CONSTRAINT project_tags_group_id_fkey FOREIGN KEY (group_id) REFERENCES groups(group_id) MATCH FULL;
36 ALTER TABLE project_task ADD CONSTRAINT project_task_group_project_id_f FOREIGN KEY (group_project_id) REFERENCES project_group_list(group_project_id) MATCH FULL;
38 ALTER TABLE project_task_external_order DROP CONSTRAINT "$1";
39 ALTER TABLE project_task_external_order ADD CONSTRAINT project_task_external_order_project_task_id_fkey FOREIGN KEY (project_task_id) REFERENCES project_task(project_task_id) MATCH FULL ON DELETE CASCADE;
41 ALTER TABLE project_weekly_metric ADD CONSTRAINT project_weekly_metric_pkey PRIMARY KEY (ranking);
43 ALTER TABLE role DROP CONSTRAINT "$1";
44 ALTER TABLE role ADD CONSTRAINT role_group_id_fkey FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE CASCADE;
46 ALTER TABLE ONLY themes ADD CONSTRAINT themes_pkey PRIMARY KEY (theme_id);
47 ALTER TABLE project_messages ALTER COLUMN project_message_id SET DEFAULT nextval('project_messages_project_message_id_seq'::regclass);
49 DROP SEQUENCE themes_pk_seq;
50 ALTER SEQUENCE themes_theme_id_seq RENAME TO themes_pk_seq;
52 DROP SEQUENCE trove_treesums_pk_seq;
53 ALTER SEQUENCE trove_treesum_trove_treesum_seq RENAME TO trove_treesums_pk_seq;
55 ALTER SEQUENCE group_cvs_history_pk_seq MAXVALUE 2147483647;
56 ALTER SEQUENCE supported_languages_pk_seq MAXVALUE 2147483647;
58 ALTER TABLE project_category ALTER COLUMN category_id SET DEFAULT nextval('project_categor_category_id_seq'::regclass);