/usr/share/gforge/db/20021212.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 | --
-- Post pre6 changes
--
DROP VIEW forum_group_list_vw;
CREATE VIEW forum_group_list_vw AS
SELECT forum_group_list.*, forum_agg_msg_count.count as total,
(SELECT max(date) AS recent FROM forum WHERE group_forum_id=forum_group_list.group_forum_id) AS recent,
(SELECT count(*) FROM
(SELECT thread_id
FROM forum
WHERE group_forum_id=forum_group_list.group_forum_id GROUP BY thread_id) as tmp) AS threads
FROM forum_group_list LEFT JOIN forum_agg_msg_count USING (group_forum_id);
--
-- Skills system additions by John Maguire
--
-- DROP SEQUENCE "skills_data_pk_seq";
-- DROP SEQUENCE "skills_data_types_pk_seq";
-- DROP TABLE "skills_data";
-- DROP TABLE "skills_data_types";
CREATE SEQUENCE "skills_data_pk_seq";
CREATE SEQUENCE "skills_data_types_pk_seq" START 0 MINVALUE 0;
CREATE TABLE "skills_data_types"(
"type_id" integer DEFAULT nextval('skills_data_types_pk_seq'::text) NOT NULL,
"type_name" character varying(25) DEFAULT '' NOT NULL,
PRIMARY KEY("type_id")
);
CREATE TABLE "skills_data"(
"skills_data_id" integer DEFAULT nextval('skills_data_pk_seq'::text) NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL REFERENCES users(user_id),
"type" integer DEFAULT '0' NOT NULL REFERENCES skills_data_types (type_id),
"title" character varying(100) DEFAULT '' NOT NULL,
"start" integer DEFAULT '0' NOT NULL,
"finish" integer DEFAULT '0' NOT NULL,
"keywords" character varying(255) DEFAULT '' NOT NULL,
PRIMARY KEY("skills_data_id")
);
INSERT INTO skills_data_types (type_name) values('Unspecified');
INSERT INTO skills_data_types (type_name) values('Project');
INSERT INTO skills_data_types (type_name) values('Training');
INSERT INTO skills_data_types (type_name) values('Proposal');
INSERT INTO skills_data_types (type_name) values('Investigation');
UPDATE project_group_list
set project_name='Default',description='Default Project - Don\'t Change'
where group_project_id=1;
|