Commit | Line | Data |
---|---|---|
8581da38 | 1 | CREATE TABLE messages ( |
2 | message_id VARCHAR(50) PRIMARY KEY, | |
3 | from_addr VARCHAR(255) NOT NULL DEFAULT '', | |
4 | to_addr VARCHAR(255) NOT NULL DEFAULT '', | |
5 | cc VARCHAR(255) NOT NULL DEFAULT '', | |
6 | subject VARCHAR(255) NOT NULL DEFAULT '', | |
7 | date VARCHAR(255) NOT NULL DEFAULT '', | |
8 | body TEXT NOT NULL DEFAULT '' | |
9 | ); | |
10 | ||
11 | CREATE TABLE metadata ( | |
12 | schema_version INT PRIMARY KEY DEFAULT 0 | |
13 | ); |