1 ALTER TABLE ONLY doc_data ADD CONSTRAINT docdata_languageid_fk FOREIGN KEY (language_id) REFERENCES supported_languages(language_id) MATCH FULL;
2 ALTER TABLE ONLY forum ADD CONSTRAINT forum_posted_by_fk FOREIGN KEY (posted_by) REFERENCES users(user_id) MATCH FULL;
4 DROP TABLE forum_attachment_type;
5 DROP FUNCTION forums_search(text, integer, text, boolean);
6 DROP TABLE foundry_data;
7 DROP TABLE foundry_news;
8 DROP TABLE foundry_preferred_projects;
9 DROP TABLE foundry_project_downloads_agg;
10 DROP TABLE foundry_project_rankings_agg;
11 DROP TABLE foundry_projects;
12 DROP TABLE group_type;
14 ALTER TABLE ONLY project_task_external_order DROP CONSTRAINT roject_task_external_order_pkey;
15 ALTER TABLE ONLY project_task_external_order ADD CONSTRAINT project_task_external_order_pkey PRIMARY KEY (project_task_id);
17 DROP SEQUENCE foundry_projects_pk_seq;
18 DROP SEQUENCE foundry_preferred_projec_pk_seq;
19 DROP SEQUENCE artifact_perm_id_seq;
21 ALTER TABLE forum_attachment ALTER COLUMN mimetype SET NOT NULL;
22 ALTER TABLE forum_pending_attachment ALTER COLUMN mimetype SET NOT NULL;
24 ALTER TABLE project_category ALTER COLUMN category_id SET DEFAULT nextval('project_categor_category_id_seq'::regclass);
25 ALTER TABLE activity_log ALTER COLUMN ver SET DEFAULT 0::double precision;
27 ALTER TABLE users DROP COLUMN sys_state;
28 ALTER TABLE groups DROP COLUMN sys_state;
29 ALTER TABLE user_group DROP COLUMN sys_state;