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;
30 ALTER TABLE user_group DROP COLUMN dead1;
31 ALTER TABLE user_group DROP COLUMN dead2;
32 ALTER TABLE user_group DROP COLUMN dead3;
33 ALTER TABLE user_group DROP COLUMN sys_cvs_state;
35 ALTER TABLE project_task ALTER COLUMN hours SET DEFAULT 0::double precision;
36 ALTER TABLE survey_rating_aggregate ALTER COLUMN response SET DEFAULT 0::double precision;
38 ALTER TABLE user_metric ALTER COLUMN avg_raters_importance SET DEFAULT 0::double precision;
39 ALTER TABLE user_metric ALTER COLUMN avg_rating SET DEFAULT 0::double precision;
40 ALTER TABLE user_metric ALTER COLUMN importance_factor SET DEFAULT 0::double precision;
41 ALTER TABLE user_metric ALTER COLUMN metric SET DEFAULT 0::double precision;
42 ALTER TABLE user_metric ALTER COLUMN percentile SET DEFAULT 0::double precision;
44 ALTER TABLE user_metric0 ALTER COLUMN avg_raters_importance SET DEFAULT 0::double precision;
45 ALTER TABLE user_metric0 ALTER COLUMN avg_rating SET DEFAULT 0::double precision;
46 ALTER TABLE user_metric0 ALTER COLUMN importance_factor SET DEFAULT 0::double precision;
47 ALTER TABLE user_metric0 ALTER COLUMN metric SET DEFAULT 0::double precision;
48 ALTER TABLE user_metric0 ALTER COLUMN percentile SET DEFAULT 0::double precision;
50 DROP INDEX group_unix_uniq;
51 CREATE UNIQUE INDEX group_unix_uniq ON groups USING btree (unix_group_name);
53 CREATE UNIQUE INDEX project_messa_project_messa_key ON project_messages USING btree (project_message_id);
56 CREATE SEQUENCE plugin_cvstracker_artifact_seq START WITH 1 INCREMENT BY 1 NO MINVALUE MAXVALUE 2147483647 CACHE 1;
57 CREATE SEQUENCE plugin_cvstracker_master_seq START WITH 1 INCREMENT BY 1 NO MINVALUE MAXVALUE 2147483647 CACHE 1;
59 CREATE TABLE plugin_cvstracker_data_artifact ( id integer DEFAULT nextval(('plugin_cvstracker_artifact_seq'::text)::regclass) NOT NULL, kind integer DEFAULT 0 NOT NULL, group_artifact_id integer, project_task_id integer );
60 CREATE TABLE plugin_cvstracker_data_master ( id integer DEFAULT nextval(('plugin_cvstracker_master_seq'::text)::regclass) NOT NULL, holder_id integer NOT NULL, log_text text DEFAULT ''::text, file text DEFAULT ''::text NOT NULL, prev_version text DEFAULT ''::text, actual_version text DEFAULT ''::text, author text DEFAULT ''::text NOT NULL, cvs_date integer NOT NULL );
62 CREATE INDEX plugin_cvstracker_group_artifact_id ON plugin_cvstracker_data_artifact USING btree (group_artifact_id);
64 ALTER TABLE ONLY plugin_cvstracker_data_artifact ADD CONSTRAINT plugin_cvstracker_artifact_pkey PRIMARY KEY (id);
65 ALTER TABLE ONLY plugin_cvstracker_data_master ADD CONSTRAINT "$1" FOREIGN KEY (holder_id) REFERENCES plugin_cvstracker_data_artifact(id);
66 ALTER TABLE ONLY plugin_cvstracker_data_master ADD CONSTRAINT "$2" FOREIGN KEY (author) REFERENCES users(user_name);
67 ALTER TABLE ONLY plugin_cvstracker_data_master ADD CONSTRAINT plugin_cvstracker_master_pkey PRIMARY KEY (id);