-- http://www.phpmyadmin.net
--
-- Client :  localhost:8889
-- Généré le :  Ven 30 Décembre 2016 à 19:21
-- Version du serveur :  5.5.34
-- Version de PHP :  5.5.10




--
-- Base de données :  `go2score`
--

-- --------------------------------------------------------

--
-- Structure de la table `abonnement`
--

CREATE TABLE `abonnement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `division_id` int(11) DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `activationUpdateAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_351268BBA76ED395` (`user_id`),
  KEY `IDX_351268BB41859289` (`division_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;

--
-- Contenu de la table `abonnement`
--

INSERT INTO `abonnement` (`id`, `user_id`, `division_id`, `active`, `createdAt`, `updatedAt`, `activationUpdateAt`) VALUES
(12, 1, 3, 1, '2016-12-29 22:59:25', '2016-12-29 22:59:25', '2016-12-29 23:01:31'),
(13, 4, 3, 0, '2016-12-30 00:33:17', '2016-12-30 00:33:17', '2016-12-30 00:35:01'),
(16, 5, 1, 0, '2016-12-30 18:32:07', '2016-12-30 18:32:07', '2016-12-30 18:32:07'),
(17, 5, 3, 1, '2016-12-30 19:05:10', '2016-12-30 19:05:10', '2016-12-30 19:13:20');

-- --------------------------------------------------------

--
-- Structure de la table `championnat`
--

CREATE TABLE `championnat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `circonscription_id` int(11) NOT NULL,
  `sport_id` int(11) NOT NULL,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_AB8C220A4D60759` (`libelle`),
  KEY `IDX_AB8C220755DBAE` (`circonscription_id`),
  KEY `IDX_AB8C220AC78BCF8` (`sport_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Contenu de la table `championnat`
--

INSERT INTO `championnat` (`id`, `circonscription_id`, `sport_id`, `libelle`, `createdAt`, `updatedAt`) VALUES
(1, 1, 1, 'Football National', '2016-09-04 23:05:09', '2016-09-04 23:05:09'),
(2, 2, 1, 'Football Provincial Namurois', '2016-09-04 23:55:55', '2016-09-05 23:19:56'),
(3, 2, 2, 'Challenge de la ville de Namur', '2016-09-09 00:45:55', '2016-09-09 00:50:57');

-- --------------------------------------------------------

--
-- Structure de la table `circonscription`
--

CREATE TABLE `circonscription` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `DisplayDivisionAppendix` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_FEDDA65AA4D60759` (`libelle`),
  UNIQUE KEY `UNIQ_FEDDA65A37076DAF` (`DisplayDivisionAppendix`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Contenu de la table `circonscription`
--

INSERT INTO `circonscription` (`id`, `libelle`, `createdAt`, `updatedAt`, `DisplayDivisionAppendix`) VALUES
(1, 'Nationale', '2016-09-04 23:04:13', '2016-09-04 23:04:13', 'Belge'),
(2, 'Provinciale Namuroise', '2016-09-04 23:55:32', '2016-09-04 23:55:32', 'Namuroise');

-- --------------------------------------------------------

--
-- Structure de la table `club`
--

CREATE TABLE `club` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stade_id` int(11) NOT NULL,
  `matricule` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B8EE38726538AB43` (`stade_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=35 ;

--
-- Contenu de la table `club`
--

INSERT INTO `club` (`id`, `stade_id`, `matricule`, `libelle`, `address`, `createdAt`, `updatedAt`) VALUES
(1, 1, 'BLOP123', 'FCO Namur', 'rue des fond de salzinne', '2016-09-05 16:03:45', '2016-09-05 16:03:45'),
(2, 2, 'ASI123', 'Aische', 'grand rue à Aische', '2016-09-07 11:08:11', '2016-09-07 11:08:11'),
(3, 1, '12345678', 'Yellow-Red KV.Mechelen ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(4, 1, '12345678', 'Club Brugge KV. ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(5, 1, '12345678', 'Excel Mouscron ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(6, 1, '12345678', 'R.SC.Anderlecht ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(7, 1, '12345678', 'SV.Zulte Waregem ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(8, 1, '12345678', 'K.AS.Eupen ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(9, 1, '12345678', 'K.St.-Truidense VV. ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(10, 1, '12345678', 'K.SC.Lokeren O.Vl. ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(11, 1, '12345678', 'Sp.du Pays de Charleroi ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(12, 1, '12345678', 'KV.RS.Waasland-SK.Beveren ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(13, 1, '12345678', 'K.VC.Westerlo ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(14, 1, '12345678', 'R.Standard de Li', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(15, 1, '12345678', 'K.RC.Genk ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(16, 1, '12345678', 'KV.Oostende ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(17, 1, '12345678', 'KV.Kortrijk ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(18, 1, '12345678', 'K.AA.Gent ', 'addr', '2016-09-07 22:20:05', '2016-09-07 22:20:05'),
(19, 1, '12345678', 'FC Ligny', 'adr', '2016-09-09 02:09:30', '2016-09-10 20:33:39'),
(20, 1, '12345678', 'RUS Loyers', 'adr', '2016-09-09 02:09:30', '2016-09-10 20:33:49'),
(21, 1, '12345678', 'RFC Spy', 'adr', '2016-09-09 02:09:30', '2016-09-10 20:34:00'),
(22, 1, '12345678', 'RUS Assesse', 'adr', '2016-09-09 02:09:30', '2016-09-10 20:34:16'),
(23, 1, '12345678', 'Wépion', 'adr', '2016-09-09 02:09:30', '2016-09-10 20:34:28'),
(24, 1, '12345678', 'Pesche', 'adr', '2016-09-09 02:09:30', '2016-09-10 20:34:38'),
(25, 1, '12345678', 'Fosses', 'adr', '2016-09-09 02:09:30', '2016-09-10 20:34:45'),
(26, 1, '12345678', 'Jeunesse Rochefortoise FC', 'adr', '2016-09-09 02:09:30', '2016-09-10 20:34:59'),
(27, 1, '12345678', 'OC Nismes ', 'adr', '2016-09-09 02:09:31', '2016-09-09 02:09:31'),
(28, 1, '12345678', 'R. Anhée', 'adr', '2016-09-09 02:09:31', '2016-09-09 02:12:29'),
(29, 1, '12345678', 'ES Moligné', 'adr', '2016-09-09 02:09:31', '2016-09-09 02:12:39'),
(30, 1, '12345678', 'Cercle Sportif Andennais', 'adr', '2016-09-09 02:09:31', '2016-09-10 20:35:13'),
(31, 1, '12345678', 'RFC Grand-Leez', 'adr', '2016-09-09 02:09:31', '2016-09-10 20:35:25'),
(32, 1, '12345678', 'Flavion', 'adr', '2016-09-09 02:09:31', '2016-09-10 20:35:46'),
(33, 1, '12345678', 'R. Arquet FC', 'adr', '2016-09-09 02:09:31', '2016-09-10 20:35:56'),
(34, 1, '12345678', 'RFC Meux', 'adr', '2016-09-09 02:09:31', '2016-09-10 20:36:05');

-- --------------------------------------------------------

--
-- Structure de la table `cmsxmlrequest`
--

CREATE TABLE `cmsxmlrequest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `request` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=208 ;

--
-- Contenu de la table `cmsxmlrequest`
--

INSERT INTO `cmsxmlrequest` (`id`, `request`) VALUES
(158, ''),
(159, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032473344515</TO><BODY>Merci, pour confirmer votre abonement a P1NAM, envoyez "OK" au 8806 (gratuit)! Flood Alert! Vous ne receverez plus les alertes redondantes!</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>170</REFERENCE></MSG></MESSAGES>\n'),
(160, ''),
(161, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032473344515</TO><BODY>Tu es mainteant abonn&#xE9;(e) aux alertes pour P1NAM! A bientot. Go2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>172</REFERENCE></MSG></MESSAGES>\n'),
(162, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032473344515</TO><BODY>P1 Namur\nGo2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>173</REFERENCE></MSG></MESSAGES>\n'),
(163, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>P1NAM</MESSAGE>\n                    <SENDER OPERATOR="1123" >0032477220308</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(164, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>P1NAM</MESSAGE>\n                    <SENDER OPERATOR="1123" >0032477220308</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(165, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>P1NAM</MESSAGE>\n                    <SENDER OPERATOR="1123" >0032477220308</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(166, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>P1NAM</MESSAGE>\n                    <SENDER OPERATOR="1123" >0032477220308</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(167, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032477220308</TO><BODY>Merci, pour confirmer votre abonement a P1NAM, envoyez "OK" au 8806 (gratuit)</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>175</REFERENCE></MSG></MESSAGES>\n'),
(168, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>OK</MESSAGE>\n                    <SENDER OPERATOR="1123" >0032477220308</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(169, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032477220308</TO><BODY>Tu es mainteant abonn&#xE9;(e) aux alertes pour P1NAM! A bientot. Go2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>177</REFERENCE></MSG></MESSAGES>\n'),
(170, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>SOTP</MESSAGE>\n                    <SENDER OPERATOR="1123" >0032477220308</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(171, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032473344515</TO><BODY>P1 Namur\nFIN: LIG - ROC 2 - 1 / LOY - PES 1 - 4\nGo2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>179</REFERENCE></MSG></MESSAGES>\n'),
(172, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032473344515</TO><BODY>P1 Namur\nGo2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>180</REFERENCE></MSG></MESSAGES>\n'),
(173, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032473344515</TO><BODY>P1 Namur\nGo2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>181</REFERENCE></MSG></MESSAGES>\n'),
(174, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032473344515</TO><BODY>P1 Namur\nGo2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>182</REFERENCE></MSG></MESSAGES>\n'),
(175, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032473344515</TO><BODY>P1 Namur\nGo2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>183</REFERENCE></MSG></MESSAGES>\n'),
(176, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032473344515</TO><BODY>P1 Namur\nANH - AND: FFD / \nGo2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>184</REFERENCE></MSG></MESSAGES>\n'),
(177, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032473344515</TO><BODY>P1 Namur\nGo2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>185</REFERENCE></MSG></MESSAGES>\n'),
(178, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>SOTP</MESSAGE>\n                    <SENDER OPERATOR="1123" >0032477220308</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(179, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032477220308</TO><BODY>Tous tes abonnements sont arr&#xEA;t&#xE9;s. Retrouve tous les codes sur Go2Score.be!</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE>187</REFERENCE></MSG></MESSAGES>\n'),
(180, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>D1ANAM</MESSAGE>\n                    <SENDER OPERATOR="1123" >0032477220308</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(181, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>0032477220308</TO><BODY>Merci, pour confirmer votre abonement a D1ANAM, envoyez "OK" au 8806 (gratuit)</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(182, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>D1ANAM</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(183, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>Merci, pour confirmer votre abonement a D1ANAM, envoyez "OK" au 8806 (gratuit)</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(184, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>D1ANAM</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(185, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>Merci, pour confirmer votre abonement a D1ANAM, envoyez "OK" au 8806 (gratuit)</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(186, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>STOP</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(187, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>stop_sms_confirmation</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(188, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>STOP</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(189, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>stop_sms_confirmation</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(190, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>STOP</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(191, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>stop_sms_confirmation</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(192, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>STOP</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(193, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>stop_sms_confirmation</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(194, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>STOP</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(195, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>Tous tes abonnements sont arr&#xEA;t&#xE9;s. Retrouve tous les codes sur Go2Score.be!</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(196, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>P1NAM</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(197, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>Merci, pour confirmer votre abonement a P1NAM, envoyez "OK" au 8806 (gratuit)</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(198, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>OK</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(199, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>sms.new_abo P1NAMA bient&#xF4;t! Go2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(200, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>OK</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(201, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>Tu es maintenant abonn&#xE9; aux alertes pour %P1NAM%!A bient&#xF4;t! Go2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(202, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>OK</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(203, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>Tu es maintenant abonn&#xE9; aux alertes pour %P1NAM% !A bient&#xF4;t! Go2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(204, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>OK</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(205, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>Tu es maintenant abonn&#xE9; aux alertes pour P1NAM.A bient&#xF4;t! Go2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n'),
(206, '<MESSAGES>\n                  <MSG>\n                    <ID>123</ID>\n                    <RECEIVER>9304</RECEIVER>\n                    <MESSAGE>OK</MESSAGE>\n                    <SENDER OPERATOR="1123" >003247334515</SENDER>\n                    <BINARY>FALSE</BINARY>\n                    <SENT>2016-12-23T12:54:33</SENT>\n                  </MSG>\n                </MESSAGES>'),
(207, '<?xml version="1.0"?>\n<MESSAGES><AUTHENTICATION><PRODUCTTOKEN>e5eae6a3-dfc9-42f1-a59b-641f80bc0536</PRODUCTTOKEN></AUTHENTICATION><MSG><FROM>Go2Score</FROM><TO>003247334515</TO><BODY>Tu es maintenant abonn&#xE9; aux alertes pour P1NAM. A bient&#xF4;t, Go2Score.be</BODY><MINIMUMNUMBEROFMESSAGEPARTS >1</MINIMUMNUMBEROFMESSAGEPARTS ><MAXIMUMNUMBEROFMESSAGEPARTS>8</MAXIMUMNUMBEROFMESSAGEPARTS><REFERENCE/></MSG></MESSAGES>\n');

-- --------------------------------------------------------

--
-- Structure de la table `division`
--

CREATE TABLE `division` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `saison_championnat_id` int(11) NOT NULL,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `codeCSVBelgianFootball` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `libelleSms` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `codeAboSMS` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_10174714BE1F40A` (`saison_championnat_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Contenu de la table `division`
--

INSERT INTO `division` (`id`, `saison_championnat_id`, `libelle`, `createdAt`, `updatedAt`, `codeCSVBelgianFootball`, `libelleSms`, `codeAboSMS`) VALUES
(1, 3, 'D1 A', '2016-09-05 13:57:44', '2016-09-07 22:57:10', '', 'D1 A Namur', 'D1ANAM'),
(2, 4, 'Vétéran A', '2016-09-09 01:03:52', '2016-09-09 01:03:52', '', 'Vétéran A Namur', ''),
(3, 2, 'P1', '2016-09-09 01:58:31', '2016-09-09 01:58:31', '', 'P1 Namur', 'P1NAM');

-- --------------------------------------------------------

--
-- Structure de la table `division_equipe`
--

CREATE TABLE `division_equipe` (
  `division_id` int(11) NOT NULL,
  `equipe_id` int(11) NOT NULL,
  PRIMARY KEY (`division_id`,`equipe_id`),
  KEY `IDX_DE6FC39241859289` (`division_id`),
  KEY `IDX_DE6FC3926D861B89` (`equipe_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `division_equipe`
--

INSERT INTO `division_equipe` (`division_id`, `equipe_id`) VALUES
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(1, 11),
(1, 12),
(1, 13),
(1, 14),
(1, 15),
(1, 16),
(1, 17),
(1, 18);

-- --------------------------------------------------------

--
-- Structure de la table `division_user`
--

CREATE TABLE `division_user` (
  `division_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`division_id`,`user_id`),
  KEY `IDX_10BE503041859289` (`division_id`),
  KEY `IDX_10BE5030A76ED395` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `division_user`
--

INSERT INTO `division_user` (`division_id`, `user_id`) VALUES
(3, 1);

-- --------------------------------------------------------

--
-- Structure de la table `equipe`
--

CREATE TABLE `equipe` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `club_id` int(11) NOT NULL,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `suffixeNomClub` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `trigram` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_2449BA1561190A32` (`club_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=35 ;

--
-- Contenu de la table `equipe`
--

INSERT INTO `equipe` (`id`, `club_id`, `libelle`, `createdAt`, `updatedAt`, `suffixeNomClub`, `trigram`) VALUES
(1, 1, 'Equipe D1 Pro', '2016-09-05 16:06:37', '2016-09-07 11:10:27', '', ''),
(2, 2, 'Equipe D1 Pro', '2016-09-07 11:08:34', '2016-09-07 11:10:33', '', ''),
(3, 3, 'D1 A', '2016-09-07 22:20:05', '2016-10-22 17:08:40', NULL, 'MEC'),
(4, 4, 'D1 A', '2016-09-07 22:20:05', '2016-09-07 22:20:05', '', ''),
(5, 5, 'D1 A', '2016-09-07 22:20:05', '2016-10-22 17:08:23', NULL, 'MOU'),
(6, 6, 'D1 A', '2016-09-07 22:20:05', '2016-09-07 22:20:05', '', ''),
(7, 7, 'D1 A', '2016-09-07 22:20:05', '2016-10-22 17:07:16', NULL, 'ZUW'),
(8, 8, 'D1 A', '2016-09-07 22:20:05', '2016-09-07 22:20:05', '', ''),
(9, 9, 'D1 A', '2016-09-07 22:20:05', '2016-09-07 22:20:05', '', ''),
(10, 10, 'D1 A', '2016-09-07 22:20:05', '2016-10-22 17:06:55', NULL, 'LOK'),
(11, 11, 'D1 A', '2016-09-07 22:20:05', '2016-10-22 17:09:10', NULL, 'CHA'),
(12, 12, 'D1 A', '2016-09-07 22:20:05', '2016-09-07 22:20:05', '', ''),
(13, 13, 'D1 A', '2016-09-07 22:20:05', '2016-10-22 17:08:57', NULL, 'WES'),
(14, 14, 'D1 A', '2016-09-07 22:20:05', '2016-09-07 22:20:05', '', ''),
(15, 15, 'D1 A', '2016-09-07 22:20:05', '2016-09-07 22:20:05', '', ''),
(16, 16, 'D1 A', '2016-09-07 22:20:05', '2016-09-07 22:20:05', '', ''),
(17, 17, 'D1 A', '2016-09-07 22:20:05', '2016-09-07 22:20:05', '', ''),
(18, 18, 'D1 A', '2016-09-07 22:20:05', '2016-09-07 22:20:05', '', ''),
(19, 19, 'P1', '2016-09-09 02:09:30', '2016-10-23 02:22:46', 'A', 'LIG'),
(20, 20, 'P1', '2016-09-09 02:09:30', '2016-10-23 00:49:58', 'A', 'LOY'),
(21, 21, 'P1', '2016-09-09 02:09:30', '2016-10-23 00:50:16', 'A', 'SPY'),
(22, 22, 'P1', '2016-09-09 02:09:30', '2016-10-23 00:50:26', 'A', 'ASS'),
(23, 23, 'P1', '2016-09-09 02:09:30', '2016-10-23 00:50:37', 'A', 'WEP'),
(24, 24, 'P1', '2016-09-09 02:09:30', '2016-10-23 00:50:47', 'A', 'PES'),
(25, 25, 'P1', '2016-09-09 02:09:31', '2016-10-23 00:50:58', 'A', 'FOS'),
(26, 26, 'P1', '2016-09-09 02:09:31', '2016-10-23 00:51:10', 'A', 'ROC'),
(27, 27, 'P1', '2016-09-09 02:09:31', '2016-10-23 00:51:24', NULL, 'NIS'),
(28, 28, 'P1', '2016-09-09 02:09:31', '2016-10-23 00:51:34', NULL, 'ANH'),
(29, 29, 'P1', '2016-09-09 02:09:31', '2016-10-23 00:51:42', NULL, 'MOL'),
(30, 30, 'P1', '2016-09-09 02:09:31', '2016-10-23 00:51:51', 'A', 'AND'),
(31, 31, 'P1', '2016-09-09 02:09:31', '2016-10-23 00:52:03', 'A', 'GLZ'),
(32, 32, 'P1', '2016-09-09 02:09:31', '2016-10-23 00:52:13', 'A', 'FLA'),
(33, 33, 'P1', '2016-09-09 02:09:31', '2016-10-23 00:52:22', NULL, 'ARQ'),
(34, 34, 'P1', '2016-09-09 02:09:31', '2016-10-23 00:52:32', 'B', 'MEU');

-- --------------------------------------------------------

--
-- Structure de la table `equipe_division`
--

CREATE TABLE `equipe_division` (
  `equipe_id` int(11) NOT NULL,
  `division_id` int(11) NOT NULL,
  PRIMARY KEY (`equipe_id`,`division_id`),
  KEY `IDX_D218B8AF6D861B89` (`equipe_id`),
  KEY `IDX_D218B8AF41859289` (`division_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `personne`
--

CREATE TABLE `personne` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `prenom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `datenaissance` datetime DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `club_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_FCEC9EF61190A32` (`club_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Structure de la table `relais`
--

CREATE TABLE `relais` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rencontre_id` int(11) NOT NULL,
  `type_resultat_id` int(11) NOT NULL,
  `creator_id` int(11) NOT NULL,
  `scoreHome` int(11) DEFAULT NULL,
  `scoreAway` int(11) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E32CEC906CFC0818` (`rencontre_id`),
  KEY `IDX_E32CEC90992A3ECD` (`type_resultat_id`),
  KEY `IDX_E32CEC9061220EA6` (`creator_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Contenu de la table `relais`
--

INSERT INTO `relais` (`id`, `rencontre_id`, `type_resultat_id`, `creator_id`, `scoreHome`, `scoreAway`, `createdAt`, `updatedAt`) VALUES
(1, 242, 1, 1, 0, 1, '2016-09-25 17:28:06', '2016-09-25 17:28:06');

-- --------------------------------------------------------

--
-- Structure de la table `rencontre`
--

CREATE TABLE `rencontre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `division_id` int(11) NOT NULL,
  `home_id` int(11) DEFAULT NULL,
  `away_id` int(11) DEFAULT NULL,
  `stade_id` int(11) NOT NULL,
  `status_id` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `scoreHome` int(11) DEFAULT NULL,
  `scoreAway` int(11) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `type_id` int(11) NOT NULL,
  `libelle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mt_id` int(11) DEFAULT NULL,
  `fi_id` int(11) DEFAULT NULL,
  `et_id` int(11) DEFAULT NULL,
  `pe_id` int(11) DEFAULT NULL,
  `statusFlagSMS` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_460C35ED41859289` (`division_id`),
  KEY `IDX_460C35ED28CDC89C` (`home_id`),
  KEY `IDX_460C35ED8DEF089F` (`away_id`),
  KEY `IDX_460C35ED6538AB43` (`stade_id`),
  KEY `IDX_460C35ED6BF700BD` (`status_id`),
  KEY `IDX_460C35EDC54C8C93` (`type_id`),
  KEY `IDX_460C35EDDADD6F08` (`mt_id`),
  KEY `IDX_460C35EDF7ED15B` (`fi_id`),
  KEY `IDX_460C35EDEAAD24C9` (`et_id`),
  KEY `IDX_460C35EDAA080CC1` (`pe_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=723 ;

--
-- Contenu de la table `rencontre`
--

INSERT INTO `rencontre` (`id`, `division_id`, `home_id`, `away_id`, `stade_id`, `status_id`, `date`, `scoreHome`, `scoreAway`, `createdAt`, `updatedAt`, `type_id`, `libelle`, `mt_id`, `fi_id`, `et_id`, `pe_id`, `statusFlagSMS`) VALUES
(242, 1, 3, 4, 1, 3, '2016-12-15 20:30:00', 0, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(243, 1, 5, 6, 1, 3, '2016-12-15 20:30:00', 1, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(244, 1, 7, 8, 1, 3, '2016-12-15 20:30:00', 3, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(245, 1, 9, 10, 1, 3, '2016-12-15 20:30:00', 1, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(246, 1, 11, 12, 1, 3, '2016-07-30 20:30:00', 1, 0, '2016-12-15 20:30:00', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(247, 1, 13, 14, 1, 3, '2016-12-15 20:30:00', 2, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(248, 1, 15, 16, 1, 3, '2016-12-15 20:30:00', 2, 1, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(249, 1, 17, 18, 1, 3, '2016-12-15 20:30:00', 1, 1, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(250, 1, 16, 4, 1, 3, '2016-08-05 20:30:00', 1, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(251, 1, 5, 11, 1, 3, '2016-08-06 18:00:00', 0, 1, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(252, 1, 8, 3, 1, 3, '2016-08-06 20:00:00', 0, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(253, 1, 12, 7, 1, 3, '2016-08-06 20:00:00', 0, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(254, 1, 14, 9, 1, 3, '2016-08-06 20:30:00', 2, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(255, 1, 10, 13, 1, 3, '2016-08-07 14:30:00', 3, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(256, 1, 6, 17, 1, 3, '2016-08-07 18:00:00', 5, 1, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(257, 1, 18, 15, 1, 3, '2016-08-07 20:00:00', 1, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(258, 1, 9, 6, 1, 3, '2016-08-12 20:30:00', 0, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(259, 1, 11, 18, 1, 3, '2016-08-13 18:00:00', 1, 1, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(260, 1, 13, 8, 1, 3, '2016-08-13 20:00:00', 1, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(261, 1, 3, 17, 1, 3, '2016-08-13 20:00:00', 0, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(262, 1, 15, 12, 1, 3, '2016-08-13 20:30:00', 2, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(263, 1, 7, 14, 1, 3, '2016-08-14 14:30:00', 1, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(264, 1, 4, 10, 1, 3, '2016-08-14 18:00:00', 1, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(265, 1, 16, 5, 1, 3, '2016-08-14 20:00:00', 2, 1, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(266, 1, 14, 11, 1, 3, '2016-08-19 20:30:00', 0, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(267, 1, 17, 4, 1, 3, '2016-08-20 18:00:00', 2, 1, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(268, 1, 12, 3, 1, 3, '2016-08-20 20:00:00', 2, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(269, 1, 5, 9, 1, 3, '2016-08-20 20:00:00', 2, 1, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(270, 1, 7, 16, 1, 3, '2016-08-20 20:30:00', 1, 1, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(271, 1, 8, 6, 1, 3, '2016-08-21 14:30:00', 2, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(272, 1, 10, 15, 1, 3, '2016-08-21 18:00:00', 0, 3, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(273, 1, 18, 13, 1, 3, '2016-08-21 20:00:00', 4, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(274, 1, 11, 8, 1, 3, '2016-08-26 20:30:00', 3, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(275, 1, 10, 5, 1, 3, '2016-08-27 18:00:00', 2, 1, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(276, 1, 9, 17, 1, 3, '2016-08-27 20:00:00', 1, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(277, 1, 13, 3, 1, 3, '2016-08-27 20:00:00', 1, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(278, 1, 16, 12, 1, 3, '2016-08-27 20:30:00', 2, 1, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(279, 1, 4, 14, 1, 3, '2016-08-28 14:30:00', 2, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(280, 1, 6, 18, 1, 3, '2016-08-28 18:00:00', 2, 2, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(281, 1, 15, 7, 1, 3, '2016-08-28 20:00:00', 1, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(282, 1, 12, 4, 1, 1, '2016-09-09 20:30:00', 0, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(283, 1, 8, 16, 1, 1, '2016-09-10 18:00:00', 0, 0, '2016-09-07 23:01:59', '2016-09-07 23:01:59', 1, NULL, NULL, NULL, NULL, NULL, 0),
(284, 1, 3, 9, 1, 1, '2016-09-10 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(285, 1, 17, 13, 1, 1, '2016-09-10 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(286, 1, 5, 7, 1, 1, '2016-09-10 20:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(287, 1, 18, 10, 1, 1, '2016-09-11 14:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(288, 1, 6, 11, 1, 1, '2016-09-11 18:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(289, 1, 14, 15, 1, 1, '2016-09-11 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(290, 1, 11, 3, 1, 1, '2016-09-16 20:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(291, 1, 4, 8, 1, 1, '2016-09-17 18:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(292, 1, 9, 12, 1, 1, '2016-09-17 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(293, 1, 13, 5, 1, 1, '2016-09-17 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(294, 1, 7, 17, 1, 1, '2016-09-17 20:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(295, 1, 15, 6, 1, 2, '2016-09-18 14:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(296, 1, 10, 14, 1, 1, '2016-09-18 18:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(297, 1, 16, 18, 1, 1, '2016-09-18 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(298, 1, 5, 4, 1, 1, '2016-09-23 20:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(299, 1, 12, 10, 1, 1, '2016-09-24 18:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(300, 1, 3, 7, 1, 1, '2016-09-24 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(301, 1, 18, 9, 1, 1, '2016-09-24 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(302, 1, 11, 16, 1, 1, '2016-09-24 20:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(303, 1, 14, 8, 1, 1, '2016-09-25 14:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(304, 1, 17, 15, 1, 1, '2016-09-25 18:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(305, 1, 6, 13, 1, 1, '2016-09-25 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(306, 1, 16, 9, 1, 1, '2016-09-30 20:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(307, 1, 7, 11, 1, 1, '2016-10-01 18:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(308, 1, 13, 12, 1, 1, '2016-10-01 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(309, 1, 8, 5, 1, 1, '2016-10-01 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(310, 1, 10, 17, 1, 1, '2016-10-01 20:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(311, 1, 4, 18, 1, 1, '2016-10-02 14:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(312, 1, 14, 6, 1, 1, '2016-10-02 18:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(313, 1, 15, 3, 1, 1, '2016-10-02 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(314, 1, 11, 4, 1, 1, '2016-10-14 20:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(315, 1, 17, 14, 1, 1, '2016-10-15 18:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(316, 1, 12, 8, 1, 1, '2016-10-15 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(317, 1, 9, 13, 1, 1, '2016-10-15 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(318, 1, 5, 15, 1, 1, '2016-10-15 20:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(319, 1, 18, 7, 1, 1, '2016-10-16 14:30:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(320, 1, 6, 10, 1, 1, '2016-10-16 18:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(321, 1, 3, 16, 1, 1, '2016-10-16 20:00:00', 0, 0, '2016-09-07 23:02:00', '2016-09-07 23:02:00', 1, NULL, NULL, NULL, NULL, NULL, 0),
(322, 1, 16, 17, 1, 1, '2016-10-21 20:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(323, 1, 7, 10, 1, 1, '2016-10-22 18:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(324, 1, 3, 5, 1, 1, '2016-10-22 20:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(325, 1, 13, 11, 1, 1, '2016-10-22 20:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(326, 1, 4, 6, 1, 1, '2016-10-23 14:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(327, 1, 15, 9, 1, 1, '2016-10-23 18:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(328, 1, 8, 18, 1, 1, '2016-10-23 20:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(329, 1, 14, 12, 1, 1, '2016-10-23 20:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(330, 1, 10, 16, 1, 1, '2016-10-25 20:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(331, 1, 11, 15, 1, 1, '2016-10-26 20:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(332, 1, 9, 7, 1, 1, '2016-10-26 20:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(333, 1, 4, 13, 1, 1, '2016-10-26 20:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(334, 1, 17, 8, 1, 1, '2016-10-26 20:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(335, 1, 6, 3, 1, 1, '2016-10-26 20:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(336, 1, 18, 14, 1, 1, '2016-10-27 20:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(337, 1, 12, 5, 1, 1, '2016-10-27 20:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(338, 1, 7, 4, 1, 1, '2016-10-29 18:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(339, 1, 15, 13, 1, 1, '2016-10-29 20:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(340, 1, 8, 10, 1, 1, '2016-10-29 20:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(341, 1, 9, 11, 1, 1, '2016-10-29 20:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(342, 1, 16, 14, 1, 1, '2016-10-30 14:30:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(343, 1, 3, 18, 1, 1, '2016-10-30 18:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(344, 1, 12, 6, 1, 1, '2016-10-30 20:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(345, 1, 5, 17, 1, 1, '2016-10-30 20:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(346, 1, 18, 12, 1, 1, '2016-11-06 15:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(347, 1, 14, 5, 1, 1, '2016-11-06 15:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(348, 1, 6, 16, 1, 1, '2016-11-06 15:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(349, 1, 4, 15, 1, 1, '2016-11-06 15:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(350, 1, 10, 3, 1, 1, '2016-11-06 15:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(351, 1, 13, 7, 1, 1, '2016-11-06 15:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(352, 1, 17, 11, 1, 1, '2016-11-06 15:00:00', 0, 0, '2016-09-07 23:02:01', '2016-09-07 23:02:01', 1, NULL, NULL, NULL, NULL, NULL, 0),
(353, 1, 8, 9, 1, 1, '2016-11-06 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(354, 1, 7, 6, 1, 1, '2016-11-20 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(355, 1, 12, 17, 1, 1, '2016-11-20 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(356, 1, 15, 8, 1, 1, '2016-11-20 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(357, 1, 11, 10, 1, 1, '2016-11-20 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(358, 1, 9, 4, 1, 1, '2016-11-20 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(359, 1, 3, 14, 1, 1, '2016-11-20 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(360, 1, 16, 13, 1, 1, '2016-11-20 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(361, 1, 5, 18, 1, 1, '2016-11-20 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(362, 1, 8, 13, 1, 1, '2016-11-27 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(363, 1, 12, 11, 1, 1, '2016-11-27 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(364, 1, 14, 7, 1, 1, '2016-11-27 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(365, 1, 10, 9, 1, 1, '2016-11-27 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(366, 1, 4, 3, 1, 1, '2016-11-27 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(367, 1, 16, 15, 1, 1, '2016-11-27 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(368, 1, 6, 5, 1, 1, '2016-11-27 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(369, 1, 18, 17, 1, 1, '2016-11-27 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(370, 1, 3, 8, 1, 1, '2016-12-04 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(371, 1, 11, 14, 1, 1, '2016-12-04 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(372, 1, 4, 16, 1, 1, '2016-12-04 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(373, 1, 15, 10, 1, 1, '2016-12-04 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(374, 1, 13, 18, 1, 1, '2016-12-04 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(375, 1, 9, 5, 1, 1, '2016-12-04 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(376, 1, 7, 12, 1, 1, '2016-12-04 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(377, 1, 17, 6, 1, 1, '2016-12-04 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(378, 1, 12, 15, 1, 1, '2016-12-11 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(379, 1, 18, 16, 1, 1, '2016-12-11 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(380, 1, 10, 7, 1, 1, '2016-12-11 15:00:00', 0, 0, '2016-09-07 23:02:02', '2016-09-07 23:02:02', 1, NULL, NULL, NULL, NULL, NULL, 0),
(381, 1, 6, 4, 1, 1, '2016-12-11 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(382, 1, 5, 3, 1, 1, '2016-12-11 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(383, 1, 8, 11, 1, 1, '2016-12-11 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(384, 1, 14, 13, 1, 1, '2016-12-11 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(385, 1, 17, 9, 1, 1, '2016-12-11 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(386, 1, 13, 10, 1, 1, '2016-12-18 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(387, 1, 15, 14, 1, 1, '2016-12-18 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(388, 1, 3, 12, 1, 1, '2016-12-18 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(389, 1, 16, 7, 1, 1, '2016-12-18 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(390, 1, 11, 5, 1, 1, '2016-12-18 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(391, 1, 9, 18, 1, 1, '2016-12-18 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(392, 1, 4, 17, 1, 1, '2016-12-18 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(393, 1, 6, 8, 1, 1, '2016-12-18 15:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(394, 1, 8, 4, 1, 1, '2016-12-21 20:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(395, 1, 12, 9, 1, 1, '2016-12-21 20:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(396, 1, 3, 11, 1, 1, '2016-12-21 20:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(397, 1, 7, 15, 1, 1, '2016-12-21 20:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(398, 1, 17, 16, 1, 1, '2016-12-21 20:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(399, 1, 14, 10, 1, 1, '2016-12-21 20:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(400, 1, 18, 6, 1, 1, '2016-12-21 20:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(401, 1, 5, 13, 1, 1, '2016-12-21 20:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(402, 1, 16, 8, 1, 1, '2016-12-27 20:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(403, 1, 15, 18, 1, 1, '2016-12-27 20:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(404, 1, 7, 3, 1, 1, '2016-12-27 20:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(405, 1, 11, 6, 1, 1, '2016-12-27 20:00:00', 0, 0, '2016-09-07 23:02:03', '2016-09-07 23:02:03', 1, NULL, NULL, NULL, NULL, NULL, 0),
(406, 1, 4, 5, 1, 1, '2016-12-27 20:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(407, 1, 13, 17, 1, 1, '2016-12-27 20:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(408, 1, 9, 14, 1, 1, '2016-12-27 20:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(409, 1, 10, 12, 1, 1, '2016-12-27 20:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(410, 1, 17, 7, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(411, 1, 14, 4, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(412, 1, 18, 11, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(413, 1, 6, 9, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(414, 1, 12, 16, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(415, 1, 3, 13, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(416, 1, 8, 15, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(417, 1, 5, 10, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(418, 1, 15, 17, 1, 1, '2017-01-25 20:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(419, 1, 8, 14, 1, 1, '2017-01-25 20:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(420, 1, 7, 5, 1, 1, '2017-01-25 20:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(421, 1, 4, 12, 1, 1, '2017-01-25 20:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(422, 1, 9, 3, 1, 1, '2017-01-25 20:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(423, 1, 13, 6, 1, 1, '2017-01-25 20:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(424, 1, 10, 18, 1, 1, '2017-01-25 20:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(425, 1, 16, 11, 1, 1, '2017-01-25 20:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(426, 1, 11, 7, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-07 23:02:04', '2016-09-07 23:02:04', 1, NULL, NULL, NULL, NULL, NULL, 0),
(427, 1, 12, 13, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(428, 1, 6, 14, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(429, 1, 9, 16, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(430, 1, 3, 15, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(431, 1, 5, 8, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(432, 1, 18, 4, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(433, 1, 17, 10, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(434, 1, 16, 3, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(435, 1, 13, 9, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(436, 1, 7, 18, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(437, 1, 10, 6, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(438, 1, 15, 5, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(439, 1, 14, 17, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(440, 1, 4, 11, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(441, 1, 8, 12, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(442, 1, 17, 3, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(443, 1, 10, 4, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(444, 1, 5, 16, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(445, 1, 9, 15, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-07 23:02:05', '2016-09-07 23:02:05', 1, NULL, NULL, NULL, NULL, NULL, 0),
(446, 1, 18, 8, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(447, 1, 6, 7, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(448, 1, 12, 14, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(449, 1, 11, 13, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(450, 1, 13, 4, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(451, 1, 16, 6, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(452, 1, 7, 9, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(453, 1, 14, 18, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(454, 1, 8, 17, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(455, 1, 3, 10, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(456, 1, 15, 11, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(457, 1, 5, 12, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(458, 1, 14, 3, 1, 1, '2017-02-26 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(459, 1, 6, 15, 1, 1, '2017-02-26 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(460, 1, 13, 16, 1, 1, '2017-02-26 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(461, 1, 18, 5, 1, 1, '2017-02-26 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(462, 1, 4, 7, 1, 1, '2017-02-26 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(463, 1, 10, 8, 1, 1, '2017-02-26 15:00:00', 0, 0, '2016-09-07 23:02:06', '2016-09-07 23:02:06', 1, NULL, NULL, NULL, NULL, NULL, 0),
(464, 1, 17, 12, 1, 1, '2017-02-26 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(465, 1, 11, 9, 1, 1, '2017-02-26 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(466, 1, 16, 10, 1, 1, '2017-03-05 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(467, 1, 9, 8, 1, 1, '2017-03-05 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(468, 1, 5, 14, 1, 1, '2017-03-05 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(469, 1, 12, 18, 1, 1, '2017-03-05 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(470, 1, 7, 13, 1, 1, '2017-03-05 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(471, 1, 15, 4, 1, 1, '2017-03-05 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(472, 1, 3, 6, 1, 1, '2017-03-05 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(473, 1, 11, 17, 1, 1, '2017-03-05 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(474, 1, 6, 12, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(475, 1, 4, 9, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(476, 1, 8, 7, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(477, 1, 10, 11, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(478, 1, 17, 5, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(479, 1, 18, 3, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(480, 1, 14, 16, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(481, 1, 13, 15, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-07 23:02:07', '2016-09-07 23:02:07', 1, NULL, NULL, NULL, NULL, NULL, 0),
(482, 3, 19, 20, 1, 3, '2016-08-20 20:00:00', 3, 1, '2016-09-09 02:09:30', '2016-09-09 02:09:30', 1, NULL, NULL, NULL, NULL, NULL, 0),
(483, 3, 21, 22, 1, 3, '2016-08-20 20:00:00', 0, 1, '2016-09-09 02:09:30', '2016-09-09 02:09:30', 1, NULL, NULL, NULL, NULL, NULL, 0),
(484, 3, 23, 24, 1, 3, '2016-08-20 20:00:00', 6, 0, '2016-09-09 02:09:30', '2016-09-09 02:09:30', 1, NULL, NULL, NULL, NULL, NULL, 0),
(485, 3, 25, 26, 1, 3, '2016-08-21 15:00:00', 1, 2, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(486, 3, 27, 28, 1, 3, '2016-08-21 15:00:00', 4, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(487, 3, 29, 30, 1, 3, '2016-08-21 15:00:00', 5, 2, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(488, 3, 31, 32, 1, 3, '2016-08-21 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(489, 3, 33, 34, 1, 3, '2016-08-21 15:00:00', 1, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(490, 3, 26, 33, 1, 3, '2016-08-27 20:00:00', 4, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(491, 3, 24, 21, 1, 3, '2016-08-27 20:30:00', 0, 1, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(492, 3, 30, 23, 1, 3, '2016-08-28 15:00:00', 0, 2, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(493, 3, 34, 19, 1, 3, '2016-08-28 15:00:00', 0, 2, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(494, 3, 22, 25, 1, 3, '2016-08-28 15:00:00', 3, 1, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(495, 3, 28, 31, 1, 3, '2016-08-28 17:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(496, 3, 20, 27, 1, 3, '2016-08-28 18:00:00', 1, 1, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(497, 3, 32, 29, 1, 3, '2016-08-28 18:00:00', 0, 3, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(498, 3, 26, 22, 1, 3, '2016-09-03 20:00:00', 1, 1, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(499, 3, 27, 34, 1, 3, '2016-09-04 15:00:00', 2, 2, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(500, 3, 31, 20, 1, 3, '2016-09-04 15:00:00', 2, 2, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(501, 3, 23, 32, 1, 3, '2016-09-04 15:00:00', 6, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(502, 3, 21, 30, 1, 3, '2016-09-04 15:00:00', 3, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(503, 3, 25, 24, 1, 3, '2016-09-04 15:00:00', 3, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(504, 3, 33, 19, 1, 3, '2016-09-04 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(505, 3, 29, 28, 1, 3, '2016-09-04 18:00:00', 2, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(506, 3, 19, 27, 1, 1, '2016-09-09 20:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(507, 3, 22, 33, 1, 1, '2016-09-09 20:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(508, 3, 32, 21, 1, 1, '2016-09-10 20:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(509, 3, 30, 25, 1, 1, '2016-09-11 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(510, 3, 28, 23, 1, 1, '2016-09-11 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(511, 3, 24, 26, 1, 1, '2016-09-11 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(512, 3, 20, 29, 1, 1, '2016-09-11 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(513, 3, 34, 31, 1, 1, '2016-09-11 18:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(514, 3, 22, 24, 1, 1, '2016-09-17 20:30:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(515, 3, 25, 32, 1, 1, '2016-09-18 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(516, 3, 26, 30, 1, 1, '2016-09-18 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(517, 3, 23, 20, 1, 1, '2016-09-18 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(518, 3, 31, 19, 1, 1, '2016-09-18 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(519, 3, 33, 27, 1, 1, '2016-09-18 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(520, 3, 29, 34, 1, 1, '2016-09-18 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(521, 3, 21, 28, 1, 1, '2016-09-18 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(522, 3, 30, 22, 1, 1, '2016-09-23 20:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(523, 3, 20, 21, 1, 1, '2016-09-25 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(524, 3, 28, 25, 1, 1, '2016-09-25 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(525, 3, 32, 26, 1, 1, '2016-09-25 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(526, 3, 27, 31, 1, 1, '2016-09-25 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(527, 3, 19, 29, 1, 1, '2016-09-25 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(528, 3, 24, 33, 1, 1, '2016-09-25 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(529, 3, 34, 23, 1, 1, '2016-09-25 15:00:00', 0, 0, '2016-09-09 02:09:31', '2016-09-09 02:09:31', 1, NULL, NULL, NULL, NULL, NULL, 0),
(530, 3, 22, 32, 1, 1, '2016-10-02 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(531, 3, 23, 19, 1, 1, '2016-10-02 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(532, 3, 24, 30, 1, 1, '2016-10-02 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(533, 3, 33, 31, 1, 1, '2016-10-02 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(534, 3, 26, 28, 1, 1, '2016-10-02 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(535, 3, 29, 27, 1, 1, '2016-10-02 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(536, 3, 21, 34, 1, 1, '2016-10-02 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(537, 3, 25, 20, 1, 1, '2016-10-02 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(538, 3, 28, 22, 1, 1, '2016-10-09 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(539, 3, 30, 33, 1, 1, '2016-10-09 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(540, 3, 31, 29, 1, 1, '2016-10-09 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(541, 3, 32, 24, 1, 1, '2016-10-09 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(542, 3, 27, 23, 1, 1, '2016-10-09 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(543, 3, 20, 26, 1, 1, '2016-10-09 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(544, 3, 34, 25, 1, 1, '2016-10-09 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(545, 3, 19, 21, 1, 1, '2016-10-09 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(546, 3, 30, 32, 1, 1, '2016-10-16 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(547, 3, 26, 34, 1, 1, '2016-10-16 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(548, 3, 23, 31, 1, 1, '2016-10-16 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(549, 3, 25, 19, 1, 1, '2016-10-16 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(550, 3, 22, 20, 1, 1, '2016-10-16 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(551, 3, 33, 29, 1, 1, '2016-10-16 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(552, 3, 21, 27, 1, 1, '2016-10-16 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(553, 3, 24, 28, 1, 1, '2016-10-16 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(554, 3, 19, 26, 1, 3, '2016-10-23 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, 6, 4, NULL, NULL, 0),
(555, 3, 31, 21, 1, 1, '2016-10-23 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, 7, NULL, NULL, NULL, 0),
(556, 3, 34, 22, 1, 1, '2016-10-23 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, 8, NULL, NULL, NULL, 0),
(557, 3, 32, 33, 1, 1, '2016-10-23 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, 9, NULL, NULL, NULL, 0),
(558, 3, 20, 24, 1, 1, '2016-10-23 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, 10, NULL, NULL, 0),
(559, 3, 28, 30, 1, 6, '2016-10-23 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 1),
(560, 3, 29, 23, 1, 1, '2016-10-23 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(561, 3, 27, 25, 1, 1, '2016-10-23 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(562, 3, 21, 29, 1, 1, '2016-10-30 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(563, 3, 30, 20, 1, 1, '2016-10-30 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(564, 3, 32, 28, 1, 1, '2016-10-30 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(565, 3, 33, 23, 1, 1, '2016-10-30 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(566, 3, 25, 31, 1, 1, '2016-10-30 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(567, 3, 26, 27, 1, 1, '2016-10-30 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(568, 3, 22, 19, 1, 1, '2016-10-30 15:00:00', 0, 0, '2016-09-09 02:09:32', '2016-09-09 02:09:32', 1, NULL, NULL, NULL, NULL, NULL, 0),
(569, 3, 24, 34, 1, 1, '2016-10-30 15:00:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(570, 3, 20, 34, 1, 1, '2016-11-06 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(571, 3, 32, 27, 1, 1, '2016-11-06 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(572, 3, 30, 31, 1, 1, '2016-11-06 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(573, 3, 22, 23, 1, 1, '2016-11-06 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(574, 3, 26, 21, 1, 1, '2016-11-06 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(575, 3, 25, 33, 1, 1, '2016-11-06 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(576, 3, 24, 29, 1, 1, '2016-11-06 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(577, 3, 28, 19, 1, 1, '2016-11-06 17:00:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(578, 3, 19, 32, 1, 1, '2016-11-13 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(579, 3, 27, 30, 1, 1, '2016-11-13 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(580, 3, 29, 22, 1, 1, '2016-11-13 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(581, 3, 23, 26, 1, 1, '2016-11-13 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(582, 3, 34, 28, 1, 1, '2016-11-13 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(583, 3, 33, 20, 1, 1, '2016-11-13 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(584, 3, 21, 25, 1, 1, '2016-11-13 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(585, 3, 31, 24, 1, 1, '2016-11-13 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(586, 3, 22, 31, 1, 1, '2016-11-20 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(587, 3, 25, 23, 1, 1, '2016-11-20 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(588, 3, 24, 27, 1, 1, '2016-11-20 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(589, 3, 30, 19, 1, 1, '2016-11-20 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(590, 3, 33, 21, 1, 1, '2016-11-20 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(591, 3, 32, 34, 1, 1, '2016-11-20 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(592, 3, 28, 20, 1, 1, '2016-11-20 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(593, 3, 26, 29, 1, 1, '2016-11-20 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(594, 3, 29, 25, 1, 1, '2016-11-27 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(595, 3, 19, 24, 1, 1, '2016-11-27 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(596, 3, 31, 26, 1, 1, '2016-11-27 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(597, 3, 34, 30, 1, 1, '2016-11-27 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(598, 3, 28, 33, 1, 1, '2016-11-27 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(599, 3, 23, 21, 1, 1, '2016-11-27 14:30:00', 0, 0, '2016-09-09 02:09:33', '2016-09-09 02:09:33', 1, NULL, NULL, NULL, NULL, NULL, 0),
(600, 3, 27, 22, 1, 1, '2016-11-27 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(601, 3, 20, 32, 1, 1, '2016-11-27 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(602, 3, 23, 30, 1, 1, '2016-12-04 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(603, 3, 21, 24, 1, 1, '2016-12-04 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(604, 3, 29, 32, 1, 1, '2016-12-04 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(605, 3, 25, 22, 1, 1, '2016-12-04 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(606, 3, 31, 28, 1, 1, '2016-12-04 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(607, 3, 27, 20, 1, 1, '2016-12-04 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(608, 3, 33, 26, 1, 1, '2016-12-04 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(609, 3, 19, 34, 1, 1, '2016-12-04 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(610, 3, 20, 19, 1, 1, '2016-12-11 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(611, 3, 28, 27, 1, 1, '2016-12-11 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(612, 3, 32, 31, 1, 1, '2016-12-11 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(613, 3, 26, 25, 1, 1, '2016-12-11 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(614, 3, 24, 23, 1, 1, '2016-12-11 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(615, 3, 34, 33, 1, 1, '2016-12-11 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(616, 3, 30, 29, 1, 1, '2016-12-11 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `rencontre` (`id`, `division_id`, `home_id`, `away_id`, `stade_id`, `status_id`, `date`, `scoreHome`, `scoreAway`, `createdAt`, `updatedAt`, `type_id`, `libelle`, `mt_id`, `fi_id`, `et_id`, `pe_id`, `statusFlagSMS`) VALUES
(617, 3, 22, 21, 1, 1, '2016-12-11 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(618, 3, 27, 24, 1, 1, '2016-12-18 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(619, 3, 21, 33, 1, 1, '2016-12-18 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(620, 3, 23, 25, 1, 1, '2016-12-18 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(621, 3, 20, 28, 1, 1, '2016-12-18 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(622, 3, 31, 22, 1, 1, '2016-12-18 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(623, 3, 29, 26, 1, 1, '2016-12-18 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(624, 3, 34, 32, 1, 1, '2016-12-18 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(625, 3, 19, 30, 1, 1, '2016-12-18 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(626, 3, 32, 20, 1, 1, '2017-01-15 14:30:00', 0, 0, '2016-09-09 02:09:34', '2016-09-09 02:09:34', 1, NULL, NULL, NULL, NULL, NULL, 0),
(627, 3, 21, 23, 1, 1, '2017-01-15 14:30:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(628, 3, 25, 29, 1, 1, '2017-01-15 14:30:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(629, 3, 26, 31, 1, 1, '2017-01-15 14:30:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(630, 3, 22, 27, 1, 1, '2017-01-15 14:30:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(631, 3, 24, 19, 1, 1, '2017-01-15 14:30:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(632, 3, 30, 34, 1, 1, '2017-01-15 14:30:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(633, 3, 33, 28, 1, 1, '2017-01-15 14:30:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(634, 3, 24, 25, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(635, 3, 32, 23, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(636, 3, 22, 26, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(637, 3, 20, 31, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(638, 3, 28, 29, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(639, 3, 19, 33, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(640, 3, 34, 27, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(641, 3, 30, 21, 1, 1, '2017-01-22 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(642, 3, 23, 28, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(643, 3, 29, 20, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(644, 3, 25, 30, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(645, 3, 31, 34, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(646, 3, 27, 19, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(647, 3, 33, 22, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(648, 3, 26, 24, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(649, 3, 21, 32, 1, 1, '2017-01-29 15:00:00', 0, 0, '2016-09-09 02:09:35', '2016-09-09 02:09:35', 1, NULL, NULL, NULL, NULL, NULL, 0),
(650, 3, 24, 22, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(651, 3, 20, 23, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(652, 3, 34, 29, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(653, 3, 32, 25, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(654, 3, 19, 31, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(655, 3, 30, 26, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(656, 3, 27, 33, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(657, 3, 28, 21, 1, 1, '2017-02-05 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(658, 3, 22, 30, 1, 1, '2017-02-11 20:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(659, 3, 33, 24, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(660, 3, 25, 28, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(661, 3, 31, 27, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(662, 3, 29, 19, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(663, 3, 21, 20, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(664, 3, 26, 32, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(665, 3, 23, 34, 1, 1, '2017-02-12 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(666, 3, 19, 23, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(667, 3, 27, 29, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(668, 3, 34, 21, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(669, 3, 31, 33, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-09 02:09:36', '2016-09-09 02:09:36', 1, NULL, NULL, NULL, NULL, NULL, 0),
(670, 3, 20, 25, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(671, 3, 32, 22, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(672, 3, 28, 26, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(673, 3, 30, 24, 1, 1, '2017-02-19 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(674, 3, 22, 28, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(675, 3, 23, 27, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(676, 3, 24, 32, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(677, 3, 33, 30, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(678, 3, 29, 31, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(679, 3, 21, 19, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(680, 3, 25, 34, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(681, 3, 26, 20, 1, 1, '2017-03-12 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(682, 3, 20, 22, 1, 1, '2017-03-19 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(683, 3, 19, 25, 1, 1, '2017-03-19 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(684, 3, 34, 26, 1, 1, '2017-03-19 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(685, 3, 32, 30, 1, 1, '2017-03-19 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(686, 3, 29, 33, 1, 1, '2017-03-19 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(687, 3, 28, 24, 1, 1, '2017-03-19 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(688, 3, 27, 21, 1, 1, '2017-03-19 15:00:00', 0, 0, '2016-09-09 02:09:37', '2016-09-09 02:09:37', 1, NULL, NULL, NULL, NULL, NULL, 0),
(689, 3, 31, 23, 1, 1, '2017-03-19 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(690, 3, 21, 31, 1, 1, '2017-04-02 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(691, 3, 30, 28, 1, 1, '2017-04-02 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(692, 3, 22, 34, 1, 1, '2017-04-02 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(693, 3, 23, 29, 1, 1, '2017-04-02 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(694, 3, 24, 20, 1, 1, '2017-04-02 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(695, 3, 33, 32, 1, 1, '2017-04-02 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(696, 3, 26, 19, 1, 1, '2017-04-02 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(697, 3, 25, 27, 1, 1, '2017-04-02 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(698, 3, 27, 26, 1, 1, '2017-04-09 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(699, 3, 23, 33, 1, 1, '2017-04-09 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(700, 3, 28, 32, 1, 1, '2017-04-09 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(701, 3, 20, 30, 1, 1, '2017-04-09 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(702, 3, 19, 22, 1, 1, '2017-04-09 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(703, 3, 34, 24, 1, 1, '2017-04-09 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(704, 3, 31, 25, 1, 1, '2017-04-09 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(705, 3, 29, 21, 1, 1, '2017-04-09 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(706, 3, 24, 31, 1, 1, '2017-04-23 15:00:00', 0, 0, '2016-09-09 02:09:38', '2016-09-09 02:09:38', 1, NULL, NULL, NULL, NULL, NULL, 0),
(707, 3, 30, 27, 1, 1, '2017-04-23 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(708, 3, 32, 19, 1, 1, '2017-04-23 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(709, 3, 20, 33, 1, 1, '2017-04-23 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(710, 3, 26, 23, 1, 1, '2017-04-23 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(711, 3, 25, 21, 1, 1, '2017-04-23 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(712, 3, 22, 29, 1, 1, '2017-04-23 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(713, 3, 28, 34, 1, 1, '2017-04-23 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(714, 3, 27, 32, 1, 1, '2017-04-30 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(715, 3, 33, 25, 1, 1, '2017-04-30 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(716, 3, 31, 30, 1, 1, '2017-04-30 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(717, 3, 29, 24, 1, 1, '2017-04-30 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(718, 3, 21, 26, 1, 1, '2017-04-30 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(719, 3, 34, 20, 1, 1, '2017-04-30 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(720, 3, 23, 22, 1, 1, '2017-04-30 15:00:00', 0, 0, '2016-09-09 02:09:39', '2016-09-09 02:09:39', 1, NULL, NULL, NULL, NULL, NULL, 0),
(721, 3, 19, 28, 1, 1, '2017-04-30 15:00:00', 0, 0, '2016-09-09 02:09:40', '2016-09-09 02:09:40', 1, NULL, NULL, NULL, NULL, NULL, 0),
(722, 2, NULL, NULL, 1, 1, '2016-09-18 10:00:00', NULL, NULL, '2016-09-11 17:11:07', '2016-09-11 17:23:46', 2, 'Corrida de Namur', NULL, NULL, NULL, NULL, 0);

-- --------------------------------------------------------

--
-- Structure de la table `rencontre_display_mode`
--

CREATE TABLE `rencontre_display_mode` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Contenu de la table `rencontre_display_mode`
--

INSERT INTO `rencontre_display_mode` (`id`, `libelle`, `createdAt`, `updatedAt`) VALUES
(1, 'Par division', '2016-09-11 18:49:13', '2016-09-11 18:49:13'),
(2, 'Par championnat', '2016-09-11 18:49:26', '2016-09-11 18:49:26'),
(3, 'Par Sport', '2016-09-13 01:06:27', '2016-09-13 01:06:27');

-- --------------------------------------------------------

--
-- Structure de la table `rencontre_status`
--

CREATE TABLE `rencontre_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `abreviationDisplayed` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `libelleSms` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;

--
-- Contenu de la table `rencontre_status`
--

INSERT INTO `rencontre_status` (`id`, `libelle`, `createdAt`, `updatedAt`, `abreviationDisplayed`, `libelleSms`) VALUES
(1, 'Planifié', '2016-09-07 15:11:31', '2016-09-07 15:11:31', '&nbsp', 'PLAN'),
(2, 'En cours', '2016-09-07 15:12:04', '2016-09-07 15:12:04', '<img height="12px" style="margin-top:5px" src="../assets/img/green.gif" />', 'COUR'),
(3, 'Terminé', '2016-09-07 15:12:16', '2016-09-07 15:12:16', 'FI', 'FIN'),
(4, 'Arrêté', '2016-09-07 15:12:25', '2016-09-07 15:12:25', 'ST', 'STOP'),
(5, 'Remis', '2016-09-07 15:12:35', '2016-09-07 15:12:35', 'RE', 'REMI'),
(6, 'Forfait de l''équipe à domicile', '2016-09-07 15:13:02', '2016-09-07 15:13:02', 'F1', 'FFD'),
(7, 'Forfait de l''équipe en déplacement', '2016-09-07 15:13:19', '2016-09-07 15:13:19', 'F2', 'FFV'),
(8, 'Forfait des deux équipes', '2016-09-07 15:13:34', '2016-09-07 15:13:34', 'FA', 'FFA');

-- --------------------------------------------------------

--
-- Structure de la table `resultat`
--

CREATE TABLE `resultat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rencontre_id` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `scoreHome` int(11) DEFAULT NULL,
  `scoreAway` int(11) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `flagSMS` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E7DB5DE26CFC0818` (`rencontre_id`),
  KEY `IDX_E7DB5DE2C54C8C93` (`type_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;

--
-- Contenu de la table `resultat`
--

INSERT INTO `resultat` (`id`, `rencontre_id`, `type_id`, `scoreHome`, `scoreAway`, `createdAt`, `updatedAt`, `flagSMS`) VALUES
(1, 303, 1, 0, 1, '2016-09-08 00:50:46', '2016-09-08 00:50:46', 0),
(2, 554, 1, 1, 1, '2016-12-15 22:39:23', '2016-12-15 22:39:23', 1),
(3, 554, 2, 2, 9, '2016-12-15 22:40:19', '2016-12-15 22:40:19', 0),
(4, 554, 2, 2, 1, '2016-12-15 22:58:59', '2016-12-15 22:58:59', 1),
(5, 554, 1, 1, 0, '2016-12-29 10:38:10', '2016-12-29 10:38:10', 0),
(6, 554, 1, 1, 2, '2016-12-29 12:36:32', '2016-12-29 12:36:32', 1),
(7, 555, 1, 3, 0, '2016-12-29 13:16:35', '2016-12-29 13:16:35', 1),
(8, 556, 1, 2, 1, '2016-12-29 13:16:35', '2016-12-29 13:16:35', 1),
(9, 557, 1, 1, 1, '2016-12-29 13:16:35', '2016-12-29 13:16:35', 1),
(10, 558, 2, 1, 4, '2016-12-29 15:35:04', '2016-12-29 15:35:04', 1);

-- --------------------------------------------------------

--
-- Structure de la table `resultat_temps`
--

CREATE TABLE `resultat_temps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personne_id` int(11) NOT NULL,
  `resultat_id` int(11) NOT NULL,
  `temps` time NOT NULL,
  `relais_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_2C7B12F2A21BD112` (`personne_id`),
  KEY `IDX_2C7B12F2D233E95C` (`resultat_id`),
  KEY `IDX_2C7B12F25B41AD20` (`relais_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Structure de la table `saison`
--

CREATE TABLE `saison` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `startingDate` datetime NOT NULL,
  `endingDate` datetime NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Contenu de la table `saison`
--

INSERT INTO `saison` (`id`, `libelle`, `startingDate`, `endingDate`, `createdAt`, `updatedAt`) VALUES
(1, '2016-2017', '2016-08-15 00:00:00', '2017-07-01 00:00:00', '2016-09-04 23:04:40', '2016-09-04 23:04:40'),
(2, '2016', '2016-01-01 00:00:00', '2016-12-31 23:59:00', '2016-09-09 00:50:12', '2016-09-09 00:50:12');

-- --------------------------------------------------------

--
-- Structure de la table `saison_championnat`
--

CREATE TABLE `saison_championnat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `championnat_id` int(11) NOT NULL,
  `saison_id` int(11) NOT NULL,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_42217226A4D60759` (`libelle`),
  KEY `IDX_42217226627A0DA8` (`championnat_id`),
  KEY `IDX_42217226F965414C` (`saison_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Contenu de la table `saison_championnat`
--

INSERT INTO `saison_championnat` (`id`, `championnat_id`, `saison_id`, `libelle`, `createdAt`, `updatedAt`) VALUES
(1, 1, 2, 'foot nat 16-17', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 2, 1, '', '2016-09-04 23:52:52', '2016-09-04 23:52:52'),
(3, 1, 1, 'football national saison 2016-2017', '2016-09-05 13:51:53', '2016-09-05 13:51:53'),
(4, 3, 2, 'Challenge de la ville de namur 2016', '2016-09-09 00:50:35', '2016-09-09 00:50:35');

-- --------------------------------------------------------

--
-- Structure de la table `sms`
--

CREATE TABLE `sms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `to_id` int(11) DEFAULT NULL,
  `content` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sendingDate` datetime NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `from_id` int(11) DEFAULT NULL,
  `operator` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `request_id` int(11) DEFAULT NULL,
  `initiates_abo_id` int(11) DEFAULT NULL,
  `confirms_abo_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B0A93A7730354A65` (`to_id`),
  KEY `IDX_B0A93A7778CED90B` (`from_id`),
  KEY `IDX_B0A93A77427EB8A5` (`request_id`),
  KEY `IDX_B0A93A771FA00101` (`initiates_abo_id`),
  KEY `IDX_B0A93A7734F79FC7` (`confirms_abo_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=216 ;

--
-- Contenu de la table `sms`
--

INSERT INTO `sms` (`id`, `to_id`, `content`, `sendingDate`, `type`, `from_id`, `operator`, `request_id`, `initiates_abo_id`, `confirms_abo_id`) VALUES
(169, 3, 'P1NAM', '2016-12-23 12:54:33', 'MO', 1, '1123', 158, 12, NULL),
(170, 1, 'Merci, pour confirmer votre abonement a P1NAM, envoyez "OK" au 8806 (gratuit)! Flood Alert! Vous ne receverez plus les alertes redondantes!', '2016-12-29 22:59:25', 'MT', NULL, NULL, NULL, NULL, NULL),
(171, 3, 'OK', '2016-12-23 12:54:33', 'MO', 1, '1123', 160, NULL, NULL),
(172, 1, 'Tu es mainteant abonné(e) aux alertes pour P1NAM! A bientot. Go2Score.be', '2016-12-29 23:01:32', 'MT', NULL, NULL, NULL, NULL, NULL),
(173, 1, 'P1 Namur\nGo2Score.be', '2016-12-29 23:02:17', 'MT', NULL, NULL, NULL, NULL, NULL),
(174, 3, 'P1NAM', '2016-12-23 12:54:33', 'MO', 4, '1123', 166, 13, NULL),
(175, 4, 'Merci, pour confirmer votre abonement a P1NAM, envoyez "OK" au 8806 (gratuit)', '2016-12-30 00:33:17', 'MT', NULL, NULL, NULL, NULL, NULL),
(176, 3, 'OK', '2016-12-23 12:54:33', 'MO', 4, '1123', 168, NULL, NULL),
(177, 4, 'Tu es mainteant abonné(e) aux alertes pour P1NAM! A bientot. Go2Score.be', '2016-12-30 00:34:22', 'MT', NULL, NULL, NULL, NULL, NULL),
(178, 3, 'SOTP', '2016-12-23 12:54:33', 'MO', 4, '1123', 170, NULL, NULL),
(179, 1, 'P1 Namur\nFIN: LIG - ROC 2 - 1 / LOY - PES 1 - 4\nGo2Score.be', '2016-12-30 09:46:26', 'MT', NULL, NULL, NULL, NULL, NULL),
(180, 1, 'P1 Namur\nGo2Score.be', '2016-12-30 12:17:12', 'MT', NULL, NULL, NULL, NULL, NULL),
(181, 1, 'P1 Namur\nGo2Score.be', '2016-12-30 12:17:32', 'MT', NULL, NULL, NULL, NULL, NULL),
(182, 1, 'P1 Namur\nGo2Score.be', '2016-12-30 12:17:55', 'MT', NULL, NULL, NULL, NULL, NULL),
(183, 1, 'P1 Namur\nGo2Score.be', '2016-12-30 13:09:58', 'MT', NULL, NULL, NULL, NULL, NULL),
(184, 1, 'P1 Namur\nANH - AND: FFD / \nGo2Score.be', '2016-12-30 13:20:25', 'MT', NULL, NULL, NULL, NULL, NULL),
(185, 1, 'P1 Namur\nGo2Score.be', '2016-12-30 13:32:24', 'MT', NULL, NULL, NULL, NULL, NULL),
(186, 3, 'SOTP', '2016-12-23 12:54:33', 'MO', 4, '1123', 178, NULL, NULL),
(187, 4, 'Tous tes abonnements sont arrêtés. Retrouve tous les codes sur Go2Score.be!', '2016-12-30 18:19:08', 'MT', NULL, NULL, NULL, NULL, NULL),
(192, 3, 'D1ANAM', '2016-12-23 12:54:33', 'MO', 5, '1123', 184, 16, NULL),
(193, 5, 'Merci, pour confirmer votre abonement a D1ANAM, envoyez "OK" au 8806 (gratuit)', '2016-12-30 18:32:07', 'MT', NULL, NULL, 185, NULL, NULL),
(194, 3, 'STOP', '2016-12-23 12:54:33', 'MO', 5, '1123', 186, NULL, NULL),
(195, 5, 'stop_sms_confirmation', '2016-12-30 18:45:12', 'MT', NULL, NULL, 187, NULL, NULL),
(196, 3, 'STOP', '2016-12-23 12:54:33', 'MO', 5, '1123', 188, NULL, NULL),
(197, 5, 'stop_sms_confirmation', '2016-12-30 18:46:39', 'MT', NULL, NULL, 189, NULL, NULL),
(198, 3, 'STOP', '2016-12-23 12:54:33', 'MO', 5, '1123', 190, NULL, NULL),
(199, 5, 'stop_sms_confirmation', '2016-12-30 18:52:04', 'MT', NULL, NULL, 191, NULL, NULL),
(200, 3, 'STOP', '2016-12-23 12:54:33', 'MO', 5, '1123', 192, NULL, NULL),
(201, 5, 'stop_sms_confirmation', '2016-12-30 18:55:59', 'MT', NULL, NULL, 193, NULL, NULL),
(202, 3, 'STOP', '2016-12-23 12:54:33', 'MO', 5, '1123', 194, NULL, NULL),
(203, 5, 'Tous tes abonnements sont arrêtés. Retrouve tous les codes sur Go2Score.be!', '2016-12-30 19:00:11', 'MT', NULL, NULL, 195, NULL, NULL),
(204, 3, 'P1NAM', '2016-12-23 12:54:33', 'MO', 5, '1123', 196, 17, NULL),
(205, 5, 'Merci, pour confirmer votre abonement a P1NAM, envoyez "OK" au 8806 (gratuit)', '2016-12-30 19:05:10', 'MT', NULL, NULL, 197, NULL, NULL),
(206, 3, 'OK', '2016-12-23 12:54:33', 'MO', 5, '1123', 198, NULL, NULL),
(207, 5, 'sms.new_abo P1NAMA bientôt! Go2Score.be', '2016-12-30 19:05:26', 'MT', NULL, NULL, 199, NULL, NULL),
(208, 3, 'OK', '2016-12-23 12:54:33', 'MO', 5, '1123', 200, NULL, NULL),
(209, 5, 'Tu es maintenant abonné aux alertes pour %P1NAM%!A bientôt! Go2Score.be', '2016-12-30 19:07:41', 'MT', NULL, NULL, 201, NULL, NULL),
(210, 3, 'OK', '2016-12-23 12:54:33', 'MO', 5, '1123', 202, NULL, NULL),
(211, 5, 'Tu es maintenant abonné aux alertes pour %P1NAM% !A bientôt! Go2Score.be', '2016-12-30 19:11:39', 'MT', NULL, NULL, 203, NULL, NULL),
(212, 3, 'OK', '2016-12-23 12:54:33', 'MO', 5, '1123', 204, NULL, NULL),
(213, 5, 'Tu es maintenant abonné aux alertes pour P1NAM.A bientôt! Go2Score.be', '2016-12-30 19:12:22', 'MT', NULL, NULL, 205, NULL, NULL),
(214, 3, 'OK', '2016-12-23 12:54:33', 'MO', 5, '1123', 206, NULL, NULL),
(215, 5, 'Tu es maintenant abonné aux alertes pour P1NAM. A bientôt, Go2Score.be', '2016-12-30 19:13:20', 'MT', NULL, NULL, 207, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `sport`
--

CREATE TABLE `sport` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  `libelleDivision` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rencontre_display_mode_id` int(11) NOT NULL,
  `toDisplay` tinyint(1) NOT NULL,
  `displayOrder` int(11) NOT NULL,
  `icon` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `current_saison_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_1A85EFD2A4D60759` (`libelle`),
  UNIQUE KEY `UNIQ_1A85EFD2276F3545` (`libelleDivision`),
  KEY `IDX_1A85EFD2999A6216` (`rencontre_display_mode_id`),
  KEY `IDX_1A85EFD22243F0E0` (`current_saison_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Contenu de la table `sport`
--

INSERT INTO `sport` (`id`, `libelle`, `createdAt`, `updatedAt`, `libelleDivision`, `rencontre_display_mode_id`, `toDisplay`, `displayOrder`, `icon`, `current_saison_id`) VALUES
(1, 'Football', '2016-09-04 23:04:01', '2016-09-11 14:24:43', 'Division', 1, 1, 1, 'sport-icon-foot', 1),
(2, 'Jogging', '2016-09-09 00:45:14', '2016-09-11 19:13:05', 'Catégorie', 2, 1, 2, 'sport-icon-jogging', 1);

-- --------------------------------------------------------

--
-- Structure de la table `stade`
--

CREATE TABLE `stade` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Contenu de la table `stade`
--

INSERT INTO `stade` (`id`, `libelle`, `address`, `createdAt`, `updatedAt`) VALUES
(1, 'Stade des bas prés', 'Rue des fons de salzinnes', '2016-09-05 16:01:52', '2016-09-05 16:01:52'),
(2, 'Stade de Aische', 'aische les bains', '2016-09-07 11:07:47', '2016-09-07 11:07:47');

-- --------------------------------------------------------

--
-- Structure de la table `type_rencontre`
--

CREATE TABLE `type_rencontre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Contenu de la table `type_rencontre`
--

INSERT INTO `type_rencontre` (`id`, `libelle`, `createdAt`, `updatedAt`) VALUES
(1, 'Duel par équipes', '2016-09-11 15:49:19', '2016-09-11 15:49:19'),
(2, 'Rencontre individuelle contre la montre', '2016-09-11 15:50:19', '2016-09-11 15:50:19');

-- --------------------------------------------------------

--
-- Structure de la table `type_resultat`
--

CREATE TABLE `type_resultat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Contenu de la table `type_resultat`
--

INSERT INTO `type_resultat` (`id`, `libelle`, `createdAt`, `updatedAt`) VALUES
(1, 'Mi-temps', '2016-09-07 15:00:08', '2016-09-07 15:00:08'),
(2, 'Fin', '2016-09-07 15:01:59', '2016-09-07 15:01:59'),
(3, 'Mi-temps prologations', '2016-09-07 15:02:20', '2016-09-07 15:02:48'),
(4, 'Fin prolongations', '2016-09-07 15:02:36', '2016-09-07 15:02:36'),
(5, 'Fin pénalties', '2016-09-07 15:03:05', '2016-09-07 15:03:05');

-- --------------------------------------------------------

--
-- Structure de la table `user_division`
--

CREATE TABLE `user_division` (
  `user_id` int(11) NOT NULL,
  `division_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`,`division_id`),
  KEY `IDX_F09AA314A76ED395` (`user_id`),
  KEY `IDX_F09AA31441859289` (`division_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contraintes pour les tables exportées
--

--
-- Contraintes pour la table `abonnement`
--
ALTER TABLE `abonnement`
  ADD CONSTRAINT `FK_351268BB41859289` FOREIGN KEY (`division_id`) REFERENCES `division` (`id`),
  ADD CONSTRAINT `FK_351268BBA76ED395` FOREIGN KEY (`user_id`) REFERENCES `g2s_user` (`id`);

--
-- Contraintes pour la table `championnat`
--
ALTER TABLE `championnat`
  ADD CONSTRAINT `FK_AB8C220755DBAE` FOREIGN KEY (`circonscription_id`) REFERENCES `circonscription` (`id`),
  ADD CONSTRAINT `FK_AB8C220AC78BCF8` FOREIGN KEY (`sport_id`) REFERENCES `sport` (`id`);

--
-- Contraintes pour la table `club`
--
ALTER TABLE `club`
  ADD CONSTRAINT `FK_B8EE38726538AB43` FOREIGN KEY (`stade_id`) REFERENCES `stade` (`id`);

--
-- Contraintes pour la table `division`
--
ALTER TABLE `division`
  ADD CONSTRAINT `FK_10174714BE1F40A` FOREIGN KEY (`saison_championnat_id`) REFERENCES `saison_championnat` (`id`);

--
-- Contraintes pour la table `division_equipe`
--
ALTER TABLE `division_equipe`
  ADD CONSTRAINT `FK_DE6FC39241859289` FOREIGN KEY (`division_id`) REFERENCES `division` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_DE6FC3926D861B89` FOREIGN KEY (`equipe_id`) REFERENCES `equipe` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `division_user`
--
ALTER TABLE `division_user`
  ADD CONSTRAINT `FK_10BE5030A76ED395` FOREIGN KEY (`user_id`) REFERENCES `g2s_user` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_10BE503041859289` FOREIGN KEY (`division_id`) REFERENCES `division` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `equipe`
--
ALTER TABLE `equipe`
  ADD CONSTRAINT `FK_2449BA1561190A32` FOREIGN KEY (`club_id`) REFERENCES `club` (`id`);

--
-- Contraintes pour la table `equipe_division`
--
ALTER TABLE `equipe_division`
  ADD CONSTRAINT `FK_D218B8AF41859289` FOREIGN KEY (`division_id`) REFERENCES `division` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_D218B8AF6D861B89` FOREIGN KEY (`equipe_id`) REFERENCES `equipe` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `personne`
--
ALTER TABLE `personne`
  ADD CONSTRAINT `FK_FCEC9EF61190A32` FOREIGN KEY (`club_id`) REFERENCES `club` (`id`);

--
-- Contraintes pour la table `relais`
--
ALTER TABLE `relais`
  ADD CONSTRAINT `FK_E32CEC9061220EA6` FOREIGN KEY (`creator_id`) REFERENCES `g2s_user` (`id`),
  ADD CONSTRAINT `FK_E32CEC906CFC0818` FOREIGN KEY (`rencontre_id`) REFERENCES `rencontre` (`id`),
  ADD CONSTRAINT `FK_E32CEC90992A3ECD` FOREIGN KEY (`type_resultat_id`) REFERENCES `type_resultat` (`id`);

--
-- Contraintes pour la table `rencontre`
--
ALTER TABLE `rencontre`
  ADD CONSTRAINT `FK_460C35ED28CDC89C` FOREIGN KEY (`home_id`) REFERENCES `equipe` (`id`),
  ADD CONSTRAINT `FK_460C35ED41859289` FOREIGN KEY (`division_id`) REFERENCES `division` (`id`),
  ADD CONSTRAINT `FK_460C35ED6538AB43` FOREIGN KEY (`stade_id`) REFERENCES `stade` (`id`),
  ADD CONSTRAINT `FK_460C35ED6BF700BD` FOREIGN KEY (`status_id`) REFERENCES `rencontre_status` (`id`),
  ADD CONSTRAINT `FK_460C35ED8DEF089F` FOREIGN KEY (`away_id`) REFERENCES `equipe` (`id`),
  ADD CONSTRAINT `FK_460C35EDAA080CC1` FOREIGN KEY (`pe_id`) REFERENCES `resultat` (`id`),
  ADD CONSTRAINT `FK_460C35EDC54C8C93` FOREIGN KEY (`type_id`) REFERENCES `type_rencontre` (`id`),
  ADD CONSTRAINT `FK_460C35EDDADD6F08` FOREIGN KEY (`mt_id`) REFERENCES `resultat` (`id`),
  ADD CONSTRAINT `FK_460C35EDEAAD24C9` FOREIGN KEY (`et_id`) REFERENCES `resultat` (`id`),
  ADD CONSTRAINT `FK_460C35EDF7ED15B` FOREIGN KEY (`fi_id`) REFERENCES `resultat` (`id`);

--
-- Contraintes pour la table `resultat`
--
ALTER TABLE `resultat`
  ADD CONSTRAINT `FK_E7DB5DE26CFC0818` FOREIGN KEY (`rencontre_id`) REFERENCES `rencontre` (`id`),
  ADD CONSTRAINT `FK_E7DB5DE2C54C8C93` FOREIGN KEY (`type_id`) REFERENCES `type_resultat` (`id`);

--
-- Contraintes pour la table `resultat_temps`
--
ALTER TABLE `resultat_temps`
  ADD CONSTRAINT `FK_2C7B12F25B41AD20` FOREIGN KEY (`relais_id`) REFERENCES `relais` (`id`),
  ADD CONSTRAINT `FK_2C7B12F2A21BD112` FOREIGN KEY (`personne_id`) REFERENCES `personne` (`id`),
  ADD CONSTRAINT `FK_2C7B12F2D233E95C` FOREIGN KEY (`resultat_id`) REFERENCES `resultat` (`id`);

--
-- Contraintes pour la table `saison_championnat`
--
ALTER TABLE `saison_championnat`
  ADD CONSTRAINT `FK_42217226627A0DA8` FOREIGN KEY (`championnat_id`) REFERENCES `championnat` (`id`),
  ADD CONSTRAINT `FK_42217226F965414C` FOREIGN KEY (`saison_id`) REFERENCES `saison` (`id`);

--
-- Contraintes pour la table `sms`
--
ALTER TABLE `sms`
  ADD CONSTRAINT `FK_B0A93A7734F79FC7` FOREIGN KEY (`confirms_abo_id`) REFERENCES `abonnement` (`id`),
  ADD CONSTRAINT `FK_B0A93A771FA00101` FOREIGN KEY (`initiates_abo_id`) REFERENCES `abonnement` (`id`),
  ADD CONSTRAINT `FK_B0A93A7730354A65` FOREIGN KEY (`to_id`) REFERENCES `g2s_user` (`id`),
  ADD CONSTRAINT `FK_B0A93A77427EB8A5` FOREIGN KEY (`request_id`) REFERENCES `cmsxmlrequest` (`id`),
  ADD CONSTRAINT `FK_B0A93A7778CED90B` FOREIGN KEY (`from_id`) REFERENCES `g2s_user` (`id`);

--
-- Contraintes pour la table `sport`
--
ALTER TABLE `sport`
  ADD CONSTRAINT `FK_1A85EFD22243F0E0` FOREIGN KEY (`current_saison_id`) REFERENCES `saison` (`id`),
  ADD CONSTRAINT `FK_1A85EFD2999A6216` FOREIGN KEY (`rencontre_display_mode_id`) REFERENCES `rencontre_display_mode` (`id`);

--
-- Contraintes pour la table `user_division`
--
ALTER TABLE `user_division`
  ADD CONSTRAINT `FK_F09AA31441859289` FOREIGN KEY (`division_id`) REFERENCES `division` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_F09AA314A76ED395` FOREIGN KEY (`user_id`) REFERENCES `g2s_user` (`id`) ON DELETE CASCADE;

