/** * 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)"); }