$migration->query($sql);
}
// [BUGFIX] make sure the password field is big enough
$sql = "alter table `users` change `password` `password` text character set utf8 COLLATE utf8_general_ci not null";
$migration->query($sql);
// apply changes
$migration->apply();
// update config
Config::set('application.admin_folder', 'admin');
Config::set('application.key', random(32));
/*
0.5 --> 0.6
*/
$migration = new Migrations();
$sql = "create table if not exists `sessions` (\n\t`id` char( 32 ) not null ,\n\t`date` datetime not null ,\n\t`ip` varchar( 15 ) not null ,\n\t`ua` varchar( 140 ) not null ,\n\t`data` text not null\n) engine=innodb charset=utf8 collate=utf8_general_ci;";
$migration->query($sql);
// comments auto published option
if (Schema::has('meta', 'key', 'auto_published_comments') === false) {
$sql = "insert into `meta` (`key`, `value`) values ('auto_published_comments', '0')";
$migration->query($sql);
}
// pagination
if (Schema::has('meta', 'key', 'posts_per_page') === false) {
$sql = "insert into `meta` (`key`, `value`) values ('posts_per_page', '10')";
$migration->query($sql);
}
// apply changes
$migration->apply();
// update config
Config::set('session.name', 'anchorcms');
Config::set('session.expire', 3600);
