- if (Config::get('mailstream', 'dbversion') == '0.1') {
- q('ALTER TABLE `mailstream_item` DROP INDEX `uid`');
- q('ALTER TABLE `mailstream_item` DROP INDEX `contact-id`');
- q('ALTER TABLE `mailstream_item` DROP INDEX `plink`');
- q('ALTER TABLE `mailstream_item` CHANGE `plink` `uri` char(255) NOT NULL');
- Config::set('mailstream', 'dbversion', '0.2');
- }
- if (Config::get('mailstream', 'dbversion') == '0.2') {
- q('DELETE FROM `pconfig` WHERE `cat` = "mailstream" AND `k` = "delay"');
- Config::set('mailstream', 'dbversion', '0.3');
- }
- if (Config::get('mailstream', 'dbversion') == '0.3') {
- q('ALTER TABLE `mailstream_item` CHANGE `created` `created` timestamp NOT NULL DEFAULT now()');
- q('ALTER TABLE `mailstream_item` CHANGE `completed` `completed` timestamp NULL DEFAULT NULL');
- Config::set('mailstream', 'dbversion', '0.4');
- }
- if (Config::get('mailstream', 'dbversion') == '0.4') {
- q('ALTER TABLE `mailstream_item` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin');
- Config::set('mailstream', 'dbversion', '0.5');
- }
- if (Config::get('mailstream', 'dbversion') == '0.5') {
- Config::set('mailstream', 'dbversion', '1.0');
- }