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