/usr/share/gforge/db/schema-convergence-from-debian.sql is in gforge-db-postgresql 5.3.2+20141104-3+deb8u3.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 | ALTER TABLE ONLY doc_data ADD CONSTRAINT docdata_languageid_fk FOREIGN KEY (language_id) REFERENCES supported_languages(language_id) MATCH FULL;
ALTER TABLE ONLY forum ADD CONSTRAINT forum_posted_by_fk FOREIGN KEY (posted_by) REFERENCES users(user_id) MATCH FULL;
DROP TABLE forum_attachment_type;
DROP FUNCTION forums_search(text, integer, text, boolean);
DROP TABLE foundry_data;
DROP TABLE foundry_news;
DROP TABLE foundry_preferred_projects;
DROP TABLE foundry_project_downloads_agg;
DROP TABLE foundry_project_rankings_agg;
DROP TABLE foundry_projects;
DROP TABLE group_type;
ALTER TABLE ONLY project_task_external_order DROP CONSTRAINT roject_task_external_order_pkey;
ALTER TABLE ONLY project_task_external_order ADD CONSTRAINT project_task_external_order_pkey PRIMARY KEY (project_task_id);
DROP SEQUENCE foundry_projects_pk_seq;
DROP SEQUENCE foundry_preferred_projec_pk_seq;
DROP SEQUENCE artifact_perm_id_seq;
ALTER TABLE forum_attachment ALTER COLUMN mimetype SET NOT NULL;
ALTER TABLE forum_pending_attachment ALTER COLUMN mimetype SET NOT NULL;
ALTER TABLE project_category ALTER COLUMN category_id SET DEFAULT nextval('project_categor_category_id_seq'::regclass);
ALTER TABLE activity_log ALTER COLUMN ver SET DEFAULT 0::double precision;
ALTER TABLE users DROP COLUMN sys_state;
ALTER TABLE groups DROP COLUMN sys_state;
ALTER TABLE user_group DROP COLUMN sys_state;
ALTER TABLE user_group DROP COLUMN dead1;
ALTER TABLE user_group DROP COLUMN dead2;
ALTER TABLE user_group DROP COLUMN dead3;
ALTER TABLE user_group DROP COLUMN sys_cvs_state;
ALTER TABLE project_task ALTER COLUMN hours SET DEFAULT 0::double precision;
ALTER TABLE survey_rating_aggregate ALTER COLUMN response SET DEFAULT 0::double precision;
ALTER TABLE user_metric ALTER COLUMN avg_raters_importance SET DEFAULT 0::double precision;
ALTER TABLE user_metric ALTER COLUMN avg_rating SET DEFAULT 0::double precision;
ALTER TABLE user_metric ALTER COLUMN importance_factor SET DEFAULT 0::double precision;
ALTER TABLE user_metric ALTER COLUMN metric SET DEFAULT 0::double precision;
ALTER TABLE user_metric ALTER COLUMN percentile SET DEFAULT 0::double precision;
ALTER TABLE user_metric0 ALTER COLUMN avg_raters_importance SET DEFAULT 0::double precision;
ALTER TABLE user_metric0 ALTER COLUMN avg_rating SET DEFAULT 0::double precision;
ALTER TABLE user_metric0 ALTER COLUMN importance_factor SET DEFAULT 0::double precision;
ALTER TABLE user_metric0 ALTER COLUMN metric SET DEFAULT 0::double precision;
ALTER TABLE user_metric0 ALTER COLUMN percentile SET DEFAULT 0::double precision;
DROP INDEX group_unix_uniq;
CREATE UNIQUE INDEX group_unix_uniq ON groups USING btree (unix_group_name);
CREATE UNIQUE INDEX project_messa_project_messa_key ON project_messages USING btree (project_message_id);
|