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
|
--
-- 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;
|
