source: branches/posledni/sql/updates/650.sql

ALTER TABLE `GmTeam` ADD INDEX ( `TimeFrom` ) ;
ALTER TABLE `GmTeam` ADD INDEX ( `TimeTo` ) ;
ALTER TABLE `GmTeam` ADD INDEX ( `RealmId` ) ;

DROP TABLE `achievement` ,
`chyby` ,
`diskuze` ,
`export_list` ,
`uzivatele` ;

CREATE TABLE IF NOT EXISTS `Realm` (
  `Id` int(11) NOT NULL auto_increment,
  `Host` int(11) NOT NULL,
  `Logon` int(11) NOT NULL,
  `DatabaseHost` varchar(255) NOT NULL,
  `DatabaseUser` varchar(255) NOT NULL,
  `DatabasePassword` varchar(255) NOT NULL,
  `DatabaseCharacters` varchar(255) NOT NULL,
  `DatabaseMangos` varchar(255) NOT NULL,
  `DatabaseScriptDev2` varchar(255) NOT NULL,
  `MaxOnlinePlayers` int(11) NOT NULL,
  `Rate` int(11) NOT NULL,
  `Type` varchar(255) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

CREATE TABLE IF NOT EXISTS `Logon` (
  `Id` int(11) NOT NULL auto_increment,
  `Host` int(11) NOT NULL,
  `DatabaseUser` varchar(255) NOT NULL,
  `DatabasePassword` varchar(255) NOT NULL,
  `DatabaseHost` varchar(255) NOT NULL,
  `DatabaseRealmd` varchar(255) NOT NULL,
  `ClientVersion` varchar(255) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;


CREATE TABLE IF NOT EXISTS `Host` (
  `Id` int(11) NOT NULL auto_increment,
  `OS` varchar(255) NOT NULL,
  `CPU` varchar(255) NOT NULL,
  `Memory` varchar(255) NOT NULL,
  `HDD` varchar(255) NOT NULL,
  `Internet` varchar(255) NOT NULL,
  `Address` varchar(255) NOT NULL,
  `Statistic` varchar(255) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

ALTER TABLE `Logon` ADD INDEX ( `Host` ) ;
ALTER TABLE `Logon` ADD FOREIGN KEY ( `Host` ) REFERENCES `Host` (`Id`);

ALTER TABLE `Realm` ADD INDEX ( `Host` ) ;
ALTER TABLE `Realm` ADD INDEX ( `Logon` ) ;

ALTER TABLE `Realm` ADD FOREIGN KEY ( `Host` ) REFERENCES `Host` (`Id`);
ALTER TABLE `Realm` ADD FOREIGN KEY ( `Logon` ) REFERENCES `Logon` (`Id`);

ALTER TABLE `Article` ADD INDEX ( `Time` ) ;

ALTER TABLE `Realm` ADD `Online` INT NOT NULL DEFAULT '0';
ALTER TABLE `Logon` ADD `Port` INT NOT NULL ;