| commit | author | age | ||
| f7bfec | 1 | -- RoundCube Webmail update script for Postres databases |
| T | 2 | -- Updates from version 0.1-beta and older |
| 3 | ||
| 4 | ALTER TABLE "messages" DROP body; | |
| 5 | ALTER TABLE "messages" ADD structure TEXT; | |
| 43a42d | 6 | ALTER TABLE "messages" ADD UNIQUE (user_id, cache_key, uid); |
| f7bfec | 7 | |
| 6223e9 | 8 | ALTER TABLE "identities" ADD html_signature INTEGER; |
| T | 9 | ALTER TABLE "identities" ALTER html_signature SET DEFAULT 0; |
| 10 | UPDATE identities SET html_signature = 0; | |
| 11 | ALTER TABLE "identities" ALTER html_signature SET NOT NULL; | |
| a0109c | 12 | |
