1 -- alter table plugin_forumml_message add column last_thread_update int unsigned not null default 0 after body;
2 CREATE SEQUENCE plugin_forumml_pk_seq
9 CREATE TABLE plugin_forumml_attachment (
10 id_attachment INTEGER DEFAULT nextval('plugin_forumml_pk_seq'::text) NOT NULL,
11 id_message INTEGER NOT NULL,
12 file_name TEXT NOT NULL,
13 file_type character varying(80) NOT NULL,
14 file_size INTEGER NOT NULL,
15 file_path character varying(255) NOT NULL,
16 content_id character varying(255) not null default '',
17 PRIMARY KEY(id_attachment)
22 CREATE SEQUENCE plugin_forumml_header_pk_seq
29 CREATE TABLE plugin_forumml_header (
30 id_header INTEGER DEFAULT nextval('plugin_forumml_header_pk_seq'::text) NOT NULL,
31 name character varying(255) NOT NULL,
32 PRIMARY KEY(id_header)
35 CREATE SEQUENCE plugin_forumml_message_pk_seq
42 CREATE TABLE plugin_forumml_message (
43 id_message INTEGER DEFAULT nextval('plugin_forumml_message_pk_seq'::text) NOT NULL,
44 id_list INTEGER NOT NULL,
45 id_parent INTEGER NOT NULL,
47 last_thread_update INTEGER NOT NULL DEFAULT 0,
48 msg_type character varying(30) not null default '',
49 cached_html text default null,
50 PRIMARY KEY(id_message)
53 CREATE TABLE plugin_forumml_messageheader (
54 id_message INTEGER NOT NULL,
55 id_header INTEGER NOT NULL,
57 PRIMARY KEY(id_message, id_header)
60 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('1','message-id');
61 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('2','date');
62 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('3','from');
63 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('4','subject');
64 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('5','return-path');
65 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('6','delivered-to');
66 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('7','to');
67 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('8','in-reply-to');
68 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('9','references');
69 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('10','x-mailer');
70 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('11','mime-version');
71 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('12','content-type');
72 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('13','content-transfer-encoding');
73 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('14','sender');
74 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('15','errors-to');
75 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('16','x-beenthere');
76 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('17','x-mailman-version');
77 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('18','precedence');
78 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('19','list-help');
79 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('20','list-post');
80 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('21','list-subscribe');
81 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('22','list-id');
82 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('23','list-unsubscribe');
83 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('24','list-archive');
84 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('25','x-original-to');
85 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('26','x-priority');
86 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('27','x-msmail-priority');
87 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('28','importance');
88 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('29','x-mimeole');
89 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('30','reply-to');
90 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('31','x-list-received-date');
91 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('32','user-agent');
92 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('33','x-mailman-approved-at');
93 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('34','cc');
94 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('35','x-mozilla-status');
95 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('36','x-mozilla-status2');
96 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('37','thread-index');
97 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('38','x-accept-language');
98 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('39','keywords');
99 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('40','organization');
100 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('41','x-reply-to');
101 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('42','x-enigmail-version');
102 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('43','x-enigmail-supports');
103 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('44','x-ms-tnef-correlator');
104 INSERT INTO plugin_forumml_header (id_header, name) VALUES ('45','x-pgp-universal');