/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, ' SET FOREIGN_KEY_CHECKS = 0');
$db->query(NULL, 'DROP TABLE roles_users');
$db->query(NULL, ' SET FOREIGN_KEY_CHECKS = 1');
$db->query(NULL, 'DROP TABLE roles');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'DROP TABLE IF EXISTS `oauth2_access_tokens`;');
$db->query(NULL, 'DROP TABLE IF EXISTS `oauth2_auth_codes`;');
$db->query(NULL, 'DROP TABLE IF EXISTS `oauth2_clients`;');
$db->query(NULL, 'DROP TABLE IF EXISTS `oauth2_refresh_tokens`;');
}
/**
* Run queries needed to apply this migration
*
* @param Kohana_Database $db Database connection
*/
public function up(Kohana_Database $db)
{
$db->query(NULL, 'ALTER TABLE `forum_topics` DROP `total`;');
$db->query(NULL, 'ALTER TABLE `forum_topics` DROP `status`;');
$db->query(NULL, 'ALTER TABLE `forum_topics` ADD `replies` INT(10) UNSIGNED NOT NULL AFTER `locked`;');
$db->query(NULL, 'ALTER TABLE `forum_topics` ADD `views` INT(10) UNSIGNED NOT NULL AFTER `replies`;');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'DROP TABLE roles;');
$db->query(NULL, 'DROP TABLE roles_users;');
$db->query(NULL, 'DROP TABLE users;');
$db->query(NULL, 'DROP TABLE user_tokens;');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, ' SET FOREIGN_KEY_CHECKS = 0');
$db->query(NULL, 'DROP TABLE IF EXISTS `users_avatars`;');
$db->query(NULL, ' SET FOREIGN_KEY_CHECKS = 1');
$db->query(NULL, 'DROP TABLE `avatars`;');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'DROP TABLE `quill_locations`');
$db->query(NULL, 'DROP TABLE `quill_categories`');
$db->query(NULL, 'DROP TABLE `quill_topics`');
$db->query(NULL, 'DROP TABLE `quill_replies`');
}
/**
* Run queries needed to apply this migration
*
* @param Kohana_Database $db Database connection
*/
public function up(Kohana_Database $db)
{
$db->query(NULL, "ALTER TABLE `users` DROP `avatar_id`");
$db->query(NULL, "ALTER TABLE `users` DROP `points`");
$db->query(NULL, "ALTER TABLE `users` DROP `post_count`");
$db->query(NULL, "ALTER TABLE `users` DROP `avatar`");
$db->query(NULL, "ALTER TABLE `users` DROP `signature`");
$db->query(NULL, "ALTER TABLE `users` DROP `about`");
$db->query(NULL, "ALTER TABLE `users` DROP `gravatar`");
$db->query(NULL, "ALTER TABLE `users` MODIFY COLUMN `title_id` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `last_login`");
}
/**
* Creates a new select query which includes all fields in the migrations
* table plus a `id` field which is a combination of the timestamp and the
* description
*
* @return Database_Query_Builder_Select
*/
protected function _select()
{
$group = $this->_db->quote_column('group');
$timestamp = $this->_db->quote_column('timestamp');
$id = $this->_db->quote_column('id');
$colon = $this->_db->quote(':');
return DB::select('*')->from($this->_table);
}
/**
* Checks to see if the minion migrations table exists and attempts to
* create it if it doesn't
*
* @return boolean
*/
public function ensure_table_exists()
{
$query = $this->_db->query(Database::SELECT, "SHOW TABLES like '" . $this->_table . "'");
if (!count($query)) {
$sql = file_get_contents(Kohana::find_file('', 'minion_schema', 'sql'));
$this->_db->query(NULL, $sql);
}
}
/**
* Checks to see if the minion migrations table exists and attempts to
* create it if it doesn't
*
* @return boolean
*/
public function ensure_table_exists()
{
$table = $this->_db->table_prefix() . $this->_table;
$query = $this->_db->query(\Gleez\Database\Database::SELECT, "SHOW TABLES like '" . $table . "'");
if (!count($query)) {
$sql = View::factory('minion/db/schema')->set('table_name', $table)->render();
$this->_db->query(NULL, $sql);
}
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'DROP TABLE forum_categories');
$db->query(NULL, 'DROP TABLE forum_polls');
$db->query(NULL, 'DROP TABLE forum_poll_options');
$db->query(NULL, 'DROP TABLE forum_poll_votes');
$db->query(NULL, 'DROP TABLE forum_topics');
$db->query(NULL, 'DROP TABLE forum_posts');
}
/**
* @param null $name
*
* @return Database
* @throws ErrorException
*/
protected static function _instance($name = NULL)
{
if (!class_exists('Kohana_Database')) {
throw new ErrorException('Kohana_Database module not loaded');
}
$name = static::instanceName($name);
if (!array_key_exists($name, static::$transactions)) {
static::$transactions[$name] = FALSE;
}
return Kohana_Database::instance($name);
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, ' SET FOREIGN_KEY_CHECKS = 0');
$db->query(NULL, 'DROP TABLE `user_notifications` ');
$db->query(NULL, ' SET FOREIGN_KEY_CHECKS = 1');
$db->query(NULL, 'DROP TABLE `user_notification_icons` ');
$db->query(NULL, 'DROP TABLE `logs` ');
}
/**
* Run queries needed to apply this migration
*
* @param Kohana_Database $db Database connection
*/
public function up(Kohana_Database $db)
{
$db->query(NULL, "ALTER TABLE `forum_poll_options` CHANGE `votes` `votes` INT(11) UNSIGNED NOT NULL");
$db->query(NULL, "ALTER TABLE `forum_polls` CHANGE `votes` `votes` INT(11) UNSIGNED NOT NULL;");
$db->query(NULL, "ALTER TABLE `forum_posts` CHANGE `updated` `updated` INT(10) UNSIGNED NOT NULL;");
$db->query(NULL, "ALTER TABLE `forum_posts` CHANGE `created` `created` INT(10) UNSIGNED NOT NULL;");
$db->query(NULL, "ALTER TABLE `forum_topics` CHANGE `created` `created` INT(10) UNSIGNED NOT NULL;");
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'ALTER TABLE `oauth2_clients` CHANGE `client_id` `client_id` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL');
$db->query(NULL, 'ALTER TABLE `oauth2_clients` CHANGE `client_secret` `client_secret` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL');
$db->query(NULL, 'ALTER TABLE `oauth2_access_tokens` CHANGE `client_id` `client_id` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL');
$db->query(NULL, 'ALTER TABLE `oauth2_auth_codes` CHANGE `client_id` `client_id` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL');
$db->query(NULL, 'ALTER TABLE `oauth2_refresh_tokens` CHANGE `client_id` `client_id` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL');
}
Kohana::init(array('base_url' => '/', 'index_file' => ''));
/**
* Attach the file write to logging. Multiple writers are supported.
*/
Kohana::$log->attach(new Log_File(APPPATH . 'logs'));
/**
* Attach a file reader to config. Multiple readers are supported.
*/
Kohana::$config->attach(new Config_File());
// Sessions & Cookies
Session::$default = 'native';
/**
* Enable modules. Modules are referenced by a relative or absolute path.
*/
Kohana::modules(array('auth' => MODPATH . 'auth', 'cache' => MODPATH . 'cache', 'database' => MODPATH . 'database', 'orm' => MODPATH . 'orm', 'email' => MODPATH . 'email'));
Kohana::$config->attach(new Config_Database(array('instance' => Kohana_Database::instance(), 'table_name' => 'config')));
/**
* Set the routes. Each route must have a minimum of a name, a URI and a set of
* defaults for the URI.
*/
// Админ роут по-умолчанию
Route::set('admin', 'admin(/<controller>(/<action>(/<id>)))', array('id' => '.+'))->defaults(array('directory' => 'admin', 'controller' => 'main', 'action' => 'index'));
// Если сайт оффлайн
Route::set('offline', 'offline')->defaults(array('directory' => 'site', 'controller' => 'main', 'action' => 'offline'));
// Обработчик ошибок
Route::set('error', 'error/<action>(/<message>)', array('action' => '[0-9]++', 'message' => '.+'))->defaults(array('controller' => 'error'));
// Роут каталога
Route::set('catalias', 'c/<catalias>', array('catalias' => '.+'))->defaults(array('directory' => 'site', 'controller' => 'catalog', 'action' => 'index'));
// Роут страницы БЕЗ каталога
Route::set('pagealias', '(<catalias>/)<pagealias>', array('catalias' => '.+', 'pagealias' => '.+'))->defaults(array('directory' => 'site', 'controller' => 'page', 'action' => 'index'));
// Роут по-умолчанию
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query('NULL', 'DROP TABLE users');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'DROP TABLE roles_users, roles, user_tokens,
tags_tasks, tags, tasks, users');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, "UPDATE `mg`.`items` SET `name` = 'Blocks' WHERE `items`.`id` =21");
$db->query(NULL, "UPDATE `mg`.`items` SET `name` = 'Cards' WHERE `items`.`id` =23");
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, "ALTER TABLE shop_restocks CHANGE id id INT( 11 ) NOT NULL");
$db->query(NULL, "ALTER TABLE shop_restocks DROP PRIMARY KEY");
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, ' SET FOREIGN_KEY_CHECKS = 0');
$db->query(NULL, "DROP TABLE IF EXISTS `items`, `item_types`, `user_items`, `item_recipes`, `item_recipe_materials`");
$db->query(NULL, ' SET FOREIGN_KEY_CHECKS = 1');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'ALTER TABLE `messages` DROP COLUMN `read`, DROP COLUMN `sent`');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'ALTER TABLE `payment_packages` DROP `rewards`');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, ' SET FOREIGN_KEY_CHECKS = 0');
$db->query(NULL, 'DROP TABLE `user_trades`, `user_trade_bids`;');
$db->query(NULL, ' SET FOREIGN_KEY_CHECKS = 1');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'ALTER TABLE `users` DROP COLUMN cached_properties');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'DROP TABLE user_properties');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'DROP TABLE `shops` ');
$db->query(NULL, 'DROP TABLE `shop_inventories` ');
$db->query(NULL, 'DROP TABLE `shop_restocks` ');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, "DELETE FROM `shop_inventories` WHERE id IN(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27)");
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'DROP TABLE user_timezones');
}
/**
* Run queries needed to remove this migration
*
* @param Kohana_Database $db Database connection
*/
public function down(Kohana_Database $db)
{
$db->query(NULL, 'DROP TABLE messages');
}
