bXGF8xw1

1USE portaldb;
2ALTER TABLE hierarchy_server_array ADD COLUMN `hierarchy_server_array_hash_type` TINYINT DEFAULT 0;
3
4DROP TABLE IF EXISTS `hierarchy_server_hash`;
5CREATE TABLE `hierarchy_server_hash` (
6`hierarchy_server_hash_id` INT(11) NOT NULL AUTO_INCREMENT,
7`hierarchy_server_id` INT(11) NOT NULL,
8`hierarchy_server_hash_hash` BIGINT UNSIGNED NOT NULL,
9PRIMARY KEY (`hierarchy_server_hash_id`),
10UNIQUE KEY `hierarchy_server_id_to_hash` (`hierarchy_server_id`, `hierarchy_server_hash_hash`)
11) ENGINE=MyISAM DEFAULT CHARSET=utf8;