5 DROP VIEW forum_group_list_vw;
6 CREATE VIEW forum_group_list_vw AS
7 SELECT forum_group_list.*, forum_agg_msg_count.count as total,
8 (SELECT max(date) AS recent FROM forum WHERE group_forum_id=forum_group_list.group_forum_id) AS recent,
12 WHERE group_forum_id=forum_group_list.group_forum_id GROUP BY thread_id) as tmp) AS threads
13 FROM forum_group_list LEFT JOIN forum_agg_msg_count USING (group_forum_id);
16 -- Skills system additions by John Maguire
18 -- DROP SEQUENCE "skills_data_pk_seq";
19 -- DROP SEQUENCE "skills_data_types_pk_seq";
20 -- DROP TABLE "skills_data";
21 -- DROP TABLE "skills_data_types";
23 CREATE SEQUENCE "skills_data_pk_seq";
25 CREATE SEQUENCE "skills_data_types_pk_seq" START 0 MINVALUE 0;
27 CREATE TABLE "skills_data_types"(
28 "type_id" integer DEFAULT nextval('skills_data_types_pk_seq'::text) NOT NULL,
29 "type_name" character varying(25) DEFAULT '' NOT NULL,
30 PRIMARY KEY("type_id")
33 CREATE TABLE "skills_data"(
34 "skills_data_id" integer DEFAULT nextval('skills_data_pk_seq'::text) NOT NULL,
35 "user_id" integer DEFAULT '0' NOT NULL REFERENCES users(user_id),
36 "type" integer DEFAULT '0' NOT NULL REFERENCES skills_data_types (type_id),
37 "title" character varying(100) DEFAULT '' NOT NULL,
38 "start" integer DEFAULT '0' NOT NULL,
39 "finish" integer DEFAULT '0' NOT NULL,
40 "keywords" character varying(255) DEFAULT '' NOT NULL,
41 PRIMARY KEY("skills_data_id")
44 INSERT INTO skills_data_types (type_name) values('Unspecified');
45 INSERT INTO skills_data_types (type_name) values('Project');
46 INSERT INTO skills_data_types (type_name) values('Training');
47 INSERT INTO skills_data_types (type_name) values('Proposal');
48 INSERT INTO skills_data_types (type_name) values('Investigation');
50 UPDATE project_group_list
51 set project_name='Default',description='Default Project - Don\'t Change'
52 where group_project_id=1;