/**
* 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 $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 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, ' 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 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 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 $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 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');
}
/**
* 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 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`");
}
/**
* 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');
}
/**
* 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, '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, "DELETE FROM `shops` WHERE id IN(1,2,3,4,5)");
}
/**
* 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');
}
/**
* 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` ADD INDEX `fk_poll_id` (`poll_id`);');
$db->query(NULL, 'ALTER TABLE `forum_poll_options` ADD CONSTRAINT `forum_poll_options_ibfk_1` FOREIGN KEY (`poll_id`) REFERENCES `forum_polls` (`id`) ON DELETE CASCADE;');
$db->query(NULL, 'ALTER TABLE `forum_poll_votes` ADD INDEX `fk_poll_id` (`poll_id`);');
$db->query(NULL, 'ALTER TABLE `forum_poll_votes` ADD INDEX `fk_option_id` (`option_id`);');
$db->query(NULL, 'ALTER TABLE `forum_poll_votes` ADD INDEX `fk_user_id` (`user_id`);');
$db->query(NULL, 'ALTER TABLE `forum_poll_votes` ADD CONSTRAINT `forum_poll_votes_ibfk_1` FOREIGN KEY (`poll_id`) REFERENCES `forum_polls` (`id`) ON DELETE CASCADE;');
$db->query(NULL, 'ALTER TABLE `forum_poll_votes` ADD CONSTRAINT `forum_poll_votes_ibfk_2` FOREIGN KEY (`option_id`) REFERENCES `forum_poll_options` (`id`) ON DELETE CASCADE;');
$db->query(NULL, 'ALTER TABLE `forum_poll_votes` ADD CONSTRAINT `forum_poll_votes_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;');
$db->query(NULL, 'ALTER TABLE `forum_polls` ADD INDEX `fk_topic_id` (`topic_id`);');
$db->query(NULL, 'ALTER TABLE `forum_polls` ADD CONSTRAINT `forum_polls_ibfk_1` FOREIGN KEY (`topic_id`) REFERENCES `forum_topics` (`id`);');
$db->query(NULL, 'ALTER TABLE `forum_posts` ADD INDEX `fk_topic_id` (`topic_id`);');
$db->query(NULL, 'ALTER TABLE `forum_posts` ADD INDEX `fk_user_id` (`user_id`);');
$db->query(NULL, 'ALTER TABLE `forum_posts` ADD CONSTRAINT `forum_posts_ibfk_1` FOREIGN KEY (`topic_id`) REFERENCES `forum_topics` (`id`) ON DELETE CASCADE;');
$db->query(NULL, 'ALTER TABLE `forum_posts` ADD CONSTRAINT `forum_posts_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;');
$db->query(NULL, 'ALTER TABLE `forum_topics` ADD INDEX `fk_category_id` (`category_id`);');
$db->query(NULL, 'ALTER TABLE `forum_topics` ADD INDEX `fk_user_id` (`user_id`);');
$db->query(NULL, 'ALTER TABLE `forum_topics` ADD CONSTRAINT `forum_topics_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `forum_categories` (`id`) ON DELETE CASCADE;');
$db->query(NULL, 'ALTER TABLE `forum_topics` ADD CONSTRAINT `forum_topics_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;');
}
/**
* 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, '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, "DROP TABLE IF EXISTS `pet_species`, `pet_colours`, `user_pets`, `pet_species_colours`;");
}
/**
* 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 `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, '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, '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_timezones');
}
/**
* 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)");
}
