use [% e107 %];

SET FOREIGN_KEY_CHECKS = 0;

ALTER TABLE `[% table_prefix %]_dblog` CHANGE COLUMN `dblog_remarks` `dblog_remarks` text NOT NULL; # was varchar(255) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_dblog` DROP COLUMN `dblog_query`; # was text NOT NULL
ALTER TABLE `[% table_prefix %]_dblog` ADD COLUMN `dblog_title` varchar(255) NOT NULL default '';
ALTER TABLE `[% table_prefix %]_generic` ADD INDEX `gen_type` (`gen_type`);
ALTER TABLE `[% table_prefix %]_generic` ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; # was ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
ALTER TABLE `[% table_prefix %]_online` ADD COLUMN `online_active` int(10) unsigned NOT NULL default '0';
ALTER TABLE `[% table_prefix %]_plugin` DROP COLUMN `plugin_rss`; # was varchar(255) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_plugin` ADD COLUMN `plugin_addons` text NOT NULL;
ALTER TABLE `[% table_prefix %]_plugin` ADD INDEX `plugin_path` (`plugin_path`);
ALTER TABLE `[% table_prefix %]_tmp` ADD INDEX `tmp_ip` (`tmp_ip`);
ALTER TABLE `[% table_prefix %]_upload` ADD INDEX `upload_active` (`upload_active`);
ALTER TABLE `[% table_prefix %]_user` CHANGE COLUMN `user_timezone` `user_timezone` varchar(3) NOT NULL default ''; # was char(3) NOT NULL default ''

SET FOREIGN_KEY_CHECKS = 1;

