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;