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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
--
-- Modification to forum table for bbcode support
--
alter table forum add bbcode_uid character varying(15);
--
-- forum_attachment
--
--
-- Name: forum_attachment; Type: TABLE; Schema: public; Owner: gforge; Tablespace:
--
CREATE TABLE forum_attachment (
attachmentid serial NOT NULL,
userid integer DEFAULT 0 NOT NULL,
dateline integer DEFAULT 0 NOT NULL,
filename character varying(100) DEFAULT ''::character varying NOT NULL,
filedata text NOT NULL,
visible smallint DEFAULT (0)::smallint NOT NULL,
counter smallint DEFAULT (0)::smallint NOT NULL,
filesize integer DEFAULT 0 NOT NULL,
msg_id integer DEFAULT 0 NOT NULL,
filehash character varying(32) DEFAULT ''::character varying NOT NULL
);
--
-- Name: filehash; Type: CONSTRAINT; Schema: public; Owner: gforge; Tablespace:
--
ALTER TABLE ONLY forum_attachment
ADD CONSTRAINT filehash UNIQUE (filehash);
--
-- Name: forum_attachment_key; Type: CONSTRAINT; Schema: public; Owner: gforge; Tablespace:
--
ALTER TABLE ONLY forum_attachment
ADD CONSTRAINT forum_attachment_key PRIMARY KEY (attachmentid);
--
-- Name: msg_id; Type: CONSTRAINT; Schema: public; Owner: gforge; Tablespace:
--
ALTER TABLE ONLY forum_attachment
ADD CONSTRAINT msg_id UNIQUE (msg_id);
--
-- forum_attachmenttype
--
--
-- Name: forum_attachmenttype; Type: TABLE; Schema: public; Owner: gforge; Tablespace:
--
CREATE TABLE forum_attachmenttype (
extension character varying(20) DEFAULT ''::character varying NOT NULL,
mimetype character varying(255) DEFAULT ''::character varying NOT NULL,
size integer DEFAULT 0 NOT NULL,
width smallint DEFAULT 0::smallint NOT NULL,
height smallint DEFAULT 0::smallint NOT NULL,
enabled smallint DEFAULT 1::smallint NOT NULL,
display smallint DEFAULT 0::smallint NOT NULL
);
--
-- Data for Name: forum_attachmenttype; Type: TABLE DATA; Schema: public; Owner: gforge
--
INSERT INTO forum_attachmenttype VALUES ('gif', 'a:1:{i:0;s:23:"Content-type: image/gif";}', 20000, 620, 280, 1, 0);
INSERT INTO forum_attachmenttype VALUES ('jpeg', 'a:1:{i:0;s:24:"Content-type: image/jpeg";}', 20000, 620, 280, 1, 0);
INSERT INTO forum_attachmenttype VALUES ('jpg', 'a:1:{i:0;s:24:"Content-type: image/jpeg";}', 100000, 0, 0, 1, 0);
INSERT INTO forum_attachmenttype VALUES ('jpe', 'a:1:{i:0;s:24:"Content-type: image/jpeg";}', 20000, 620, 280, 1, 0);
INSERT INTO forum_attachmenttype VALUES ('png', 'a:1:{i:0;s:23:"Content-type: image/png";}', 20000, 620, 280, 1, 0);
INSERT INTO forum_attachmenttype VALUES ('txt', 'a:1:{i:0;s:24:"Content-type: plain/text";}', 20000, 0, 0, 1, 2);
INSERT INTO forum_attachmenttype VALUES ('doc', 'a:2:{i:0;s:20:"Accept-ranges: bytes";i:1;s:32:"Content-type: application/msword";}', 20000, 0, 0, 1, 0);
INSERT INTO forum_attachmenttype VALUES ('pdf', 'a:1:{i:0;s:29:"Content-type: application/pdf";}', 20000, 0, 0, 1, 0);
INSERT INTO forum_attachmenttype VALUES ('bmp', 'a:1:{i:0;s:26:"Content-type: image/bitmap";}', 20000, 620, 280, 1, 0);
INSERT INTO forum_attachmenttype VALUES ('psd', 'a:1:{i:0;s:29:"Content-type: unknown/unknown";}', 20000, 0, 0, 1, 0);
INSERT INTO forum_attachmenttype VALUES ('zip', 'a:1:{i:0;s:29:"Content-type: application/zip";}', 100000, 0, 0, 1, 0);
--
-- Name: forum_attachmenttype_key; Type: CONSTRAINT; Schema: public; Owner: gforge; Tablespace:
--
ALTER TABLE ONLY forum_attachmenttype
ADD CONSTRAINT forum_attachmenttype_key PRIMARY KEY (extension);
--
-- change the views
--
DROP VIEW forum_user_vw;
CREATE VIEW forum_user_vw AS
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);
|
