view release on metacpan or  search on metacpan

testdata.sql.dump  view on Meta::CPAN

DROP TABLE IF EXISTS `games`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `games` (
  `Game_ID` int(10) unsigned NOT NULL auto_increment,
  `Tournament_Code` varchar(20) character set latin1 collate latin1_bin NOT NULL default '0',
  `Game_Date` date NOT NULL default '0000-00-00',
  `Round` tinyint(2) unsigned NOT NULL default '0',
  `Pin_Player_1` int(8) unsigned NOT NULL default '0',
  `Color_1` char(1) character set latin1 collate latin1_bin NOT NULL default '_',
  `Rank_1` char(3) character set latin1 collate latin1_bin NOT NULL default '',
  `Pin_Player_2` int(8) unsigned NOT NULL default '0',
  `Color_2` char(1) character set latin1 collate latin1_bin NOT NULL default '_',
  `Rank_2` char(3) character set latin1 collate latin1_bin NOT NULL default '',
  `Handicap` tinyint(2) unsigned NOT NULL default '0',
  `Komi` tinyint(2) NOT NULL default '0',
  `Result` char(1) character set latin1 collate latin1_bin NOT NULL default '_',
  `Online` tinyint(1) default '0',
  `Exclude` tinyint(1) default '0',
  `Rated` tinyint(1) default '0',
  `Elab_Date` date NOT NULL default '0000-00-00',
  UNIQUE KEY `Game_ID` (`Game_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1096393 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `games`
--

LOCK TABLES `games` WRITE;
/*!40000 ALTER TABLE `games` DISABLE KEYS */;
INSERT INTO `games` VALUES (7372,'tourn13','2000-05-02',1,87993,'W','11k',18107,'B','10k',0,5,'B',0,0,0,'0000-00-00'),(7382,'tourn13','2000-05-02',1,10467,'W','28k',62738,'B','30k',2,0,'W',0,0,0,'0000-00-00'),(7392,'tourn13','2000-05-02',1,8432,'W','...
/*!40000 ALTER TABLE `games` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `players`
--

DROP TABLE IF EXISTS `players`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `players` (
  `Pin_Player` int(8) unsigned NOT NULL,
  `Name` varchar(30) character set latin1 collate latin1_bin NOT NULL default '',
  `Rating` float(8,6) default '0.000000',
  `Sigma` float(7,6) default '0.000000',
  `Elab_Date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Pin_Player`),
  KEY `Ind_Players` (`Name`),
  KEY `Reverse_Ind` (`Name`,`Pin_Player`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `players`
--

LOCK TABLES `players` WRITE;
/*!40000 ALTER TABLE `players` DISABLE KEYS */;
INSERT INTO `players` VALUES (44576,'KENT KNOKE',1.654260,0.515218,'0000-00-00'),(7762,'CASEY PILGER',2.752110,0.275794,'0000-00-00'),(19235,'LYNWOOD GIN',5.507065,0.254119,'0000-00-00'),(67533,'EDMOND PENCEK',3.972718,0.343634,'0000-00-00'),(58060,'...
/*!40000 ALTER TABLE `players` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ratings`
--

DROP TABLE IF EXISTS `ratings`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ratings` (
  `Pin_Player` int(8) unsigned NOT NULL,
  `Rating` float(8,6) default NULL,
  `Sigma` float(7,6) default NULL,
  `Elab_Date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Pin_Player`,`Elab_Date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `ratings`
--

LOCK TABLES `ratings` WRITE;
/*!40000 ALTER TABLE `ratings` DISABLE KEYS */;
/*!40000 ALTER TABLE `ratings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tournaments`
--

DROP TABLE IF EXISTS `tournaments`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tournaments` (
  `Tournament_Code` varchar(20) character set latin1 collate latin1_bin NOT NULL default '0',
  `Tournament_Descr` varchar(80) character set latin1 collate latin1_bin default '',
  `Tournament_Date` date NOT NULL default '0000-00-00',
  UNIQUE KEY `Tournament_Code` (`Tournament_Code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `tournaments`
--

LOCK TABLES `tournaments` WRITE;
/*!40000 ALTER TABLE `tournaments` DISABLE KEYS */;
INSERT INTO `tournaments` VALUES ('tourn13','Tournament 13','2000-05-02'),('tourn41','Tournament 41','2000-11-10'),('tourn81','Tournament 81','2001-05-25'),('tourn6','Tournament 6','2000-03-31'),('tourn59','Tournament 59','2001-02-12'),('tourn22','To...
/*!40000 ALTER TABLE `tournaments` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;