SQL/mysql.update.sql
@@ -1,6 +1,11 @@ -- RoundCube Webmail update script for MySQL databases -- Version 0.1-20051007 -- Updates from version 0.1-beta and 0.1-beta2 ALTER TABLE `messages` DROP `body`, DROP INDEX `cache_key`, ADD `structure` TEXT, ADD UNIQUE `uniqueness` (`cache_key`, `uid`); ALTER TABLE session ADD ip VARCHAR(15) NOT NULL AFTER changed; ALTER TABLE users ADD alias VARCHAR(128) NOT NULL AFTER mail_host; ALTER TABLE 'identities' ADD 'html_signature' tinyint(1) default 0 NOT NULL;
