-- MySQL dump 10.13  Distrib 5.5.62, for debian-linux-gnu (i686)
--
-- Host: analogdepat.mysql.db    Database: analogdepat
-- ------------------------------------------------------
-- Server version	5.6.51-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `clone_chessmaster_new`
--

DROP TABLE IF EXISTS `clone_chessmaster_new`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clone_chessmaster_new` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `blanc` varchar(30) NOT NULL DEFAULT '',
  `noir` varchar(30) NOT NULL DEFAULT '',
  `gagnant` varchar(30) NOT NULL DEFAULT '',
  `date` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clone_chessmaster_new`
--

LOCK TABLES `clone_chessmaster_new` WRITE;
/*!40000 ALTER TABLE `clone_chessmaster_new` DISABLE KEYS */;
INSERT INTO `clone_chessmaster_new` VALUES (1,'HenriqueF','FranckV','HenriqueF',1659823200),(2,'RemyS','HenriqueF','HenriqueF',1659823200),(3,'HenriqueF','FranckV','HenriqueF',1659996000),(4,'FranckV','HenriqueF','FranckV',1660082400);
/*!40000 ALTER TABLE `clone_chessmaster_new` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clone_classement_new`
--

DROP TABLE IF EXISTS `clone_classement_new`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clone_classement_new` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `joueur` varchar(30) NOT NULL DEFAULT '',
  `elo` int(11) NOT NULL DEFAULT '0',
  `initial` int(11) NOT NULL DEFAULT '0',
  `parties` int(11) NOT NULL DEFAULT '0',
  `prior` int(11) NOT NULL DEFAULT '0',
  `bonus` int(11) NOT NULL DEFAULT '0',
  `oldrating` int(11) NOT NULL DEFAULT '0',
  `gcount` int(11) NOT NULL DEFAULT '0',
  `wins` int(11) NOT NULL DEFAULT '0',
  `losses` int(11) NOT NULL DEFAULT '0',
  `draws` int(11) NOT NULL DEFAULT '0',
  `active` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clone_classement_new`
--

LOCK TABLES `clone_classement_new` WRITE;
/*!40000 ALTER TABLE `clone_classement_new` DISABLE KEYS */;
INSERT INTO `clone_classement_new` VALUES (1,'AlvaroM',1400,1400,0,0,0,0,0,0,0,0,1),(2,'DamienB',1200,1400,1,1,0,1400,1,0,1,0,1),(3,'EmileM',1400,1400,0,0,0,0,0,0,0,0,1),(4,'FranckV',1466,1400,3,3,0,1200,3,1,2,0,1),(5,'HenriqueF',1500,1400,4,4,0,1700,4,3,1,0,1),(6,'PatrickA',1400,1400,0,0,0,0,0,0,0,0,1),(7,'PhilippeA',1600,1400,1,1,0,1400,1,1,0,0,1),(8,'RemyS',1300,1400,1,1,0,1400,1,0,1,0,1),(9,'StephaneR',1400,1400,0,0,0,0,0,0,0,0,1);
/*!40000 ALTER TABLE `clone_classement_new` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clone_evolution_new`
--

DROP TABLE IF EXISTS `clone_evolution_new`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clone_evolution_new` (
  `playerID` int(11) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `date` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clone_evolution_new`
--

LOCK TABLES `clone_evolution_new` WRITE;
/*!40000 ALTER TABLE `clone_evolution_new` DISABLE KEYS */;
INSERT INTO `clone_evolution_new` VALUES (5,1600,1659823200),(4,1200,1659823200),(8,1300,1659823200),(5,1700,1659823200),(5,1700,1659996000),(4,1200,1659996000),(4,1466,1660082400),(5,1500,1660082400),(2,1200,1660168800),(7,1600,1660168800);
/*!40000 ALTER TABLE `clone_evolution_new` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clone_parties_new`
--

DROP TABLE IF EXISTS `clone_parties_new`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clone_parties_new` (
  `w_playerID` int(11) DEFAULT NULL,
  `w_name` varchar(30) NOT NULL DEFAULT '',
  `b_playerID` int(11) DEFAULT NULL,
  `b_name` varchar(30) NOT NULL DEFAULT '',
  `w_brating` int(11) DEFAULT NULL,
  `w_arating` int(11) DEFAULT NULL,
  `b_brating` int(11) DEFAULT NULL,
  `b_arating` int(11) DEFAULT NULL,
  `result` int(11) DEFAULT NULL,
  `date` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clone_parties_new`
--

LOCK TABLES `clone_parties_new` WRITE;
/*!40000 ALTER TABLE `clone_parties_new` DISABLE KEYS */;
INSERT INTO `clone_parties_new` VALUES (5,'HenriqueF',4,'FranckV',1400,1600,1400,1200,1,1659823200),(8,'RemyS',5,'HenriqueF',1400,1300,1600,1700,2,1659823200),(5,'HenriqueF',4,'FranckV',1700,1700,1200,1200,1,1659996000),(4,'FranckV',5,'HenriqueF',1200,1466,1700,1500,1,1660082400),(2,'DamienB',7,'PhilippeA',1400,1200,1400,1600,2,1660168800);
/*!40000 ALTER TABLE `clone_parties_new` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clone_elo_affectation`
--

DROP TABLE IF EXISTS `clone_elo_affectation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clone_elo_affectation` (
  `joueur` varchar(30) DEFAULT NULL,
  `elo` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clone_elo_affectation`
--

LOCK TABLES `clone_elo_affectation` WRITE;
/*!40000 ALTER TABLE `clone_elo_affectation` DISABLE KEYS */;
INSERT INTO `clone_elo_affectation` VALUES ('AlvaroM',1400),('DamienB',1400),('EmileM',1400),('FranckV',1400),('HenriqueF',1400),('PatrickA',1400),('PhilippeA',1400),('RemyS',1400),('StephaneR',1400);
/*!40000 ALTER TABLE `clone_elo_affectation` 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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-08-11 23:12:02
