HEADcourier-fixdev-browser-capabilitiespdorelease-0.6release-0.7release-0.8
|
Last change
on this file since f7bfec9 was
f7bfec9,
checked in by thomascube <thomas@…>, 7 years ago
|
|
Finalized new message parsing. Attention: changes in database schema
|
-
Property mode set to
100644
|
|
File size:
957 bytes
|
| Rev | Line | |
|---|
| [f7bfec9] | 1 | -- RoundCube Webmail update script for SQLite databases |
|---|
| 2 | -- Updates from version 0.1-beta2 and older |
|---|
| 3 | |
|---|
| 4 | DROP TABLE messages; |
|---|
| 5 | |
|---|
| 6 | CREATE TABLE messages ( |
|---|
| 7 | message_id integer NOT NULL PRIMARY KEY, |
|---|
| 8 | user_id integer NOT NULL default '0', |
|---|
| 9 | del tinyint NOT NULL default '0', |
|---|
| 10 | cache_key varchar(128) NOT NULL default '', |
|---|
| 11 | created datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 12 | idx integer NOT NULL default '0', |
|---|
| 13 | uid integer NOT NULL default '0', |
|---|
| 14 | subject varchar(255) NOT NULL default '', |
|---|
| 15 | "from" varchar(255) NOT NULL default '', |
|---|
| 16 | "to" varchar(255) NOT NULL default '', |
|---|
| 17 | cc varchar(255) NOT NULL default '', |
|---|
| 18 | date datetime NOT NULL default '0000-00-00 00:00:00', |
|---|
| 19 | size integer NOT NULL default '0', |
|---|
| 20 | headers text NOT NULL, |
|---|
| 21 | structure text |
|---|
| 22 | ); |
|---|
| 23 | |
|---|
| 24 | CREATE INDEX ix_messages_user_id ON messages(user_id); |
|---|
| 25 | CREATE INDEX ix_messages_cache_key ON messages(cache_key); |
|---|
| 26 | CREATE INDEX ix_messages_idx ON messages(idx); |
|---|
| 27 | CREATE INDEX ix_messages_uid ON messages(uid); |
|---|
Note: See
TracBrowser
for help on using the repository browser.
