/usr/share/gforge/db/20050822-2.sql is in gforge-db-postgresql 5.1.1-2.
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 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 | --
-- 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);
|