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
|
DROP TABLE IF EXISTS msginfo;
CREATE TABLE msginfo (
msg_sid BIGSERIAL PRIMARY KEY,
file_size INTEGER,
file_mtime TIMESTAMP,
msg_date TIMESTAMP,
flags INTEGER,
hdr_from TEXT,
hdr_to TEXT,
hdr_cc TEXT,
hdr_newsgroups TEXT,
hdr_subject TEXT,
hdr_msgid TEXT UNIQUE NOT NULL,
hdr_inreplyto TEXT,
hdr_references TEXT,
body_text TEXT,
body_index TSVECTOR,
attach_num INTEGER
);
CREATE INDEX msginfo_msg_date_index ON msginfo (msg_date);
CREATE INDEX msginfo_body_index ON msginfo USING gin (body_index);
-- CREATE TRIGGER msginfo_update BEFORE UPDATE OR INSERT ON msginfo
-- FOR EACH ROW EXECUTE PROCEDURE tsearch(body_index, wakachi, body_text);
DROP TABLE IF EXISTS msg_folderinfo;
CREATE TABLE msg_folderinfo (
msg_sid BIGINT NOT NULL,
folder_id TEXT,
msgnum INTEGER,
PRIMARY KEY (folder_id, msgnum)
);
CREATE INDEX msg_sid_index ON msg_folderinfo (msg_sid);
|
