diff options
| author | thomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2006-08-25 11:51:11 +0000 |
|---|---|---|
| committer | thomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2006-08-25 11:51:11 +0000 |
| commit | 12c7e7b88c581c3cf8e07a85d587a6add927d750 (patch) | |
| tree | 97e3c52d3ec16a4fea87d582b74c2fa07a602a31 /roundcubemail/SQL/postgres.update.sql | |
| parent | a6bf50cf3e8d9d49516242947619c97806c30d56 (diff) | |
Finalized new message parsing. Attention: changes in database schema
git-svn-id: https://svn.roundcube.net/trunk@325 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/SQL/postgres.update.sql')
| -rw-r--r-- | roundcubemail/SQL/postgres.update.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/roundcubemail/SQL/postgres.update.sql b/roundcubemail/SQL/postgres.update.sql new file mode 100644 index 000000000..6ca855edc --- /dev/null +++ b/roundcubemail/SQL/postgres.update.sql @@ -0,0 +1,7 @@ +-- RoundCube Webmail update script for Postres databases +-- Updates from version 0.1-beta and older + +ALTER TABLE "messages" DROP body; +ALTER TABLE "messages" ADD structure TEXT; +ALTER TABLE "messages" ADD UNIQUE (cache_key, uid); + |