1 ALTER TABLE forum ALTER bbcode_uid SET DEFAULT -1;
3 ALTER TABLE forum_group_list ADD COLUMN moderation_level integer;
5 ALTER TABLE forum_group_list ALTER moderation_level SET DEFAULT 0;
7 DROP VIEW forum_group_list_vw;
9 CREATE VIEW forum_group_list_vw AS
10 SELECT forum_group_list.group_forum_id, forum_group_list.group_id, forum_group_list.forum_name, forum_group_list.is_public, forum_group_list.description, forum_group_list.allow_anonymous, forum_group_list.send_all_posts_to, forum_group_list.moderation_level, forum_agg_msg_count.count AS total, (SELECT max(forum.post_date) AS recent FROM forum WHERE (forum.group_forum_id = forum_group_list.group_forum_id)) AS recent, (SELECT count(*) AS count FROM (SELECT forum.thread_id FROM forum WHERE (forum.group_forum_id = forum_group_list.group_forum_id) GROUP BY forum.thread_id) tmp) AS threads FROM (forum_group_list LEFT JOIN forum_agg_msg_count USING (group_forum_id));
12 DROP VIEW forum_user_vw;
14 CREATE VIEW forum_user_vw AS
15 SELECT forum.msg_id, forum.group_forum_id, forum.posted_by, forum.subject, forum.body, forum.post_date, forum.is_followup_to, forum.thread_id, forum.has_followups, forum.most_recent_date, forum.bbcode_uid, users.user_name, users.realname FROM forum, users WHERE (forum.posted_by = users.user_id);
17 CREATE TABLE forum_pending_messages (
18 msg_id serial NOT NULL,
19 group_forum_id integer DEFAULT 0 NOT NULL,
20 posted_by integer DEFAULT 0 NOT NULL,
21 subject text DEFAULT ''::text NOT NULL,
22 body text DEFAULT ''::text NOT NULL,
23 post_date integer DEFAULT 0 NOT NULL,
24 is_followup_to integer DEFAULT 0 NOT NULL,
25 thread_id integer DEFAULT 0 NOT NULL,
26 has_followups integer DEFAULT 0,
27 most_recent_date integer DEFAULT 0 NOT NULL,
28 bbcode_uid character varying(15) DEFAULT -1
31 ALTER TABLE ONLY forum_pending_messages ADD CONSTRAINT forum_pending_messages_pkey PRIMARY KEY (msg_id);
33 ALTER TABLE ONLY forum_pending_messages
34 ADD CONSTRAINT forum_pending_messages_group_forum_id_fkey FOREIGN KEY (group_forum_id) REFERENCES forum_group_list(group_forum_id) ON DELETE CASCADE;
36 CREATE TABLE forum_pending_attachment (
37 attachmentid serial NOT NULL,
38 userid integer DEFAULT 100 NOT NULL,
39 dateline integer DEFAULT 0 NOT NULL,
40 filename character varying(100) DEFAULT ''::character varying NOT NULL,
41 filedata text NOT NULL,
42 visible smallint DEFAULT (0)::smallint NOT NULL,
43 counter smallint DEFAULT (0)::smallint NOT NULL,
44 filesize integer DEFAULT 0 NOT NULL,
45 msg_id integer DEFAULT 0 NOT NULL,
46 filehash character varying(32) DEFAULT ''::character varying NOT NULL
49 ALTER TABLE ONLY forum_pending_attachment
50 ADD CONSTRAINT forum_pending_attachment_pkey PRIMARY KEY (attachmentid);
53 ALTER TABLE ONLY forum_pending_attachment
54 ADD CONSTRAINT forum_pending_attachment_msg_id_fkey FOREIGN KEY (msg_id) REFERENCES forum_pending_messages(msg_id) ON DELETE CASCADE;
56 ALTER TABLE ONLY forum_pending_attachment
57 ADD CONSTRAINT forum_pending_attachment_userid_fkey FOREIGN KEY (userid) REFERENCES users(user_id) ON DELETE SET DEFAULT;
59 CREATE VIEW forum_pending_user_vw AS
60 SELECT forum_pending_messages.msg_id, forum_pending_messages.group_forum_id, forum_pending_messages.posted_by, forum_pending_messages.subject,
61 forum_pending_messages.body, forum_pending_messages.post_date, forum_pending_messages.is_followup_to, forum_pending_messages.thread_id, forum_pending_messages.has_followups,
62 forum_pending_messages.most_recent_date, forum_pending_messages.bbcode_uid, users.user_name, users.realname FROM forum_pending_messages, users WHERE (forum_pending_messages.posted_by = users.user_id);