fwiffos schema looks like this:
Code: Select all
DROP TABLE IF EXISTS `stats`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `stats` (
`id` int(10) NOT NULL auto_increment,
`place` int(11) NOT NULL,
`callsign` varchar(20) NOT NULL,
`mu` decimal(11,2) NOT NULL,
`sigma` decimal(11,2) NOT NULL,
`rank` decimal(11,2) NOT NULL,
`wins` int(11) NOT NULL,
`losses` int(11) NOT NULL,
`draws` int(11) NOT NULL,
`defects` int(11) NOT NULL,
`stack_rating` decimal(11,2) NOT NULL,
`cmd_mu` decimal(11,2) NOT NULL,
`cmd_sigma` decimal(11,2) NOT NULL,
`cmd_rank` decimal(11,2) NOT NULL,
`cmd_wins` int(11) NOT NULL,
`cmd_losses` int(11) NOT NULL,
`cmd_draws` int(11) NOT NULL,
`kills` int(11) NOT NULL,
`ejects` int(11) NOT NULL,
`drn_kills` int(11) NOT NULL,
`stn_kills` int(11) NOT NULL,
`stn_caps` int(11) NOT NULL,
`kills_per_ejects` decimal(11,2) NOT NULL,
`hrs_played` decimal(11,2) NOT NULL,
`kills_per_hr` decimal(11,2) NOT NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`status` int(1) NOT NULL,
`lgp` int(8) NOT NULL,
PRIMARY KEY (`id`),
KEY `index` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=932403 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;this is just a suggestion to see us though in R6 until R7/CSS. If this is feasible, then am i right in understanding that allsrv would have the required info. necessary to perform autobalance "bakers way"?

