- 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');
- }
-
- if (Config::get('retriever', 'dbversion') != '1.0') {
- $schema = file_get_contents(dirname(__file__).'/database.sql');
- $arr = explode(';', $schema);
- foreach ($arr as $a) {
- $r = q($a);
- }
- Config::set('mailstream', 'dbversion', '1.0');
- }