ALTER TABLE `gm_tym` ADD `TimeFrom` DATE NULL ,
ADD `TimeTo` DATE NULL DEFAULT NULL ;

RENAME TABLE `gm_tym`  TO `GmTeam` ;
ALTER TABLE `GmTeam`  ENGINE = InnoDB;

RENAME TABLE `finance`  TO `Finance` ;
ALTER TABLE `Finance`  ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE `Finance` CHANGE `id` `Id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
CHANGE `time` `Time` DATETIME NULL DEFAULT NULL ,
CHANGE `money` `Money` INT( 11 ) NULL DEFAULT NULL ,
CHANGE `operation` `Operation` ENUM( 'contribution', 'consumption', 'buy', 'internet', 'sell', 'hosting' ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL DEFAULT 'contribution',
CHANGE `description` `Description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL DEFAULT NULL ,
CHANGE `odmena` `Reward` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ;

ALTER TABLE `finance_reward`  ENGINE = InnoDB;
RENAME TABLE `finance_reward`  TO `FinanceReward` ;

DROP TABLE `CharacterOnlineHistory`;
DROP TABLE `debug`;

ALTER TABLE `GuildHouse` CHANGE `Id` `Guild` INT( 255 ) NULL DEFAULT NULL ;
ALTER TABLE `GuildHouse` ADD `Realm` INT NOT NULL AFTER `Guild` ;

