Context Navigation

627.sql

Last change on this file was 627, checked in by george, 15 years ago
Upraveno: Strkutura a názvy tabulek gm_tym, finance, finance_rewards. Upraveno: Stránka informací o serveru doplněna pro podporu zobrazení více fyzických serverů. Přidáno: Zobrazení dřívějších GM v dolní částí stránky GM týmu.
File size: 1.2 KB

Line
1	ALTER TABLE `gm_tym` ADD `TimeFrom` DATE NULL ,
2	ADD `TimeTo` DATE NULL DEFAULT NULL ;
3
4	RENAME TABLE `gm_tym` TO `GmTeam` ;
5	ALTER TABLE `GmTeam` ENGINE = InnoDB;
6
7	RENAME TABLE `finance` TO `Finance` ;
8	ALTER TABLE `Finance` ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
9
10	ALTER TABLE `Finance` CHANGE `id` `Id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
11	CHANGE `time` `Time` DATETIME NULL DEFAULT NULL ,
12	CHANGE `money` `Money` INT( 11 ) NULL DEFAULT NULL ,
13	CHANGE `operation` `Operation` ENUM( 'contribution', 'consumption', 'buy', 'internet', 'sell', 'hosting' ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL DEFAULT 'contribution',
14	CHANGE `description` `Description` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL DEFAULT NULL ,
15	CHANGE `odmena` `Reward` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL ;
16
17	ALTER TABLE `finance_reward` ENGINE = InnoDB;
18	RENAME TABLE `finance_reward` TO `FinanceReward` ;
19
20	DROP TABLE `CharacterOnlineHistory`;
21	DROP TABLE `debug`;
22
23	ALTER TABLE `GuildHouse` CHANGE `Id` `Guild` INT( 255 ) NULL DEFAULT NULL ;
24	ALTER TABLE `GuildHouse` ADD `Realm` INT NOT NULL AFTER `Guild` ;
25

Note: See TracBrowser for help on using the repository browser.