On évite de mettre du SQL dans un Readme ^^
-- phpMyAdmin SQL Dump -- version 4.9.2 -- https://www.phpmyadmin.net/
-- Hôte : 127.0.0.1:3306 -- Généré le : ven. 18 juin 2021 à 13:56 -- Version du serveur : 10.4.10-MariaDB -- Version de PHP : 7.4.19
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /; /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /; /!40101 SET NAMES utf8mb4 */;
CREATE DATABASE IF NOT EXISTS hanged DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE hanged;
DROP TABLE IF EXISTS users;
CREATE TABLE IF NOT EXISTS users (
id int(11) NOT NULL AUTO_INCREMENT,
user varchar(255) NOT NULL,
pwd varchar(255) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY user (user)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
INSERT INTO users (id, user, pwd) VALUES
(4, 'abc', '$argon2id$v=19$m=65536,t=4,p=1$Z0RhbzkyNi5vTU9TSUZ6cg$1YsVpmrNTo4tqgZyXFbT4nrZZmIaMQvPo75wo1V7jx0'),
(3, 'toto', '$argon2id$v=19$m=65536,t=4,p=1$WnBnZDdYOU41anAueFd2WA$VVU6EDu/lXViQfpokbzQVmIOZ1g39DDnSVz67blZdok');
DROP TABLE IF EXISTS words;
CREATE TABLE IF NOT EXISTS words (
id int(11) NOT NULL AUTO_INCREMENT,
word varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=405 DEFAULT CHARSET=latin1;
INSERT INTO words (id, word) VALUES
(1, 'Acajou'),
(2, 'Acajou'),
(3, 'Agneau'),
(4, 'Alarme'),
(5, 'Ananas'),
(6, 'Angora'),
(7, 'Animal'),
(8, 'Arcade'),
(9, 'Aviron'),
(10, 'Azimut'),
(11, 'Babine'),
(12, 'Balade'),
(13, 'Bonzai'),
(14, 'Basson'),
(15, 'Billet'),
(16, 'Bouche'),
(17, 'Boucle'),
(18, 'Bronze'),
(19, 'Cabane'),
(20, 'Caiman'),
(21, 'Cloche'),
(22, 'Cheque'),
(23, 'Cirage'),
(24, 'Coccyx'),
(25, 'Crayon'),
(26, 'Garage'),
(27, 'Gospel'),
(28, 'Goulot'),
(29, 'Gramme'),
(30, 'Grelot'),
(31, 'Guenon'),
(32, 'Hochet'),
(33, 'Hormis'),
(34, 'Humour'),
(35, 'Hurler'),
(36, 'Jargon'),
(37, 'Limite'),
(38, 'Lionne'),
(39, 'Menthe'),
(40, 'Oiseau'),
(41, 'Podium'),
(42, 'Poulpe'),
(43, 'Poumon'),
(44, 'Puzzle'),
(45, 'Quartz'),
(46, 'Rapide'),
(47, 'Seisme'),
(48, 'Tetine'),
(49, 'Tomate'),
(50, 'Walabi'),
(51, 'Whisky'),
(52, 'Zipper'),
(53, 'Abriter'),
(54, 'Ballast'),
(55, 'Baryton'),
(56, 'Bassine'),
(57, 'Batavia'),
(58, 'Billard'),
(59, 'Bretzel'),
(60, 'Cithare'),
(61, 'Chariot'),
(62, 'Clairon'),
(63, 'Corbeau'),
(64, 'Cortege'),
(65, 'Crapaud'),
(66, 'Cymbale'),
(67, 'Dentier'),
(68, 'Djembe'),
(69, 'Drapeau'),
(70, 'Exemple'),
(71, 'Fourmis'),
(72, 'Grandir'),
(73, 'Iceberg'),
(74, 'Javelot'),
(75, 'Jockey'),
(76, 'Journal'),
(77, 'Journee'),
(78, 'Jouxter'),
(79, 'Losange'),
(80, 'Macadam'),
(81, 'Mondial'),
(82, 'Notable'),
(83, 'Oxygene'),
(84, 'Panique'),
(85, 'Petrole'),
(86, 'Poterie'),
(87, 'Pouvoir'),
(88, 'Renegat'),
(89, 'Scooter'),
(90, 'Senteur'),
(91, 'Sifflet'),
(92, 'Spirale'),
(93, 'Sucette'),
(94, 'Strophe'),
(95, 'Tonneau'),
(96, 'Trousse'),
(97, 'Tunique'),
(98, 'Ukulele'),
(99, 'Vautour'),
(100, 'Zozoter'),
(101, 'Aquarium'),
(102, 'Araignee'),
(103, 'Arbalete'),
(104, 'Archipel'),
(105, 'Banquise'),
(106, 'Batterie'),
(107, 'Brocante'),
(108, 'Brouhaha'),
(109, 'Capeline'),
(110, 'Clavecin'),
(111, 'Cloporte'),
(112, 'Debutant'),
(113, 'Diapason'),
(114, 'Gangster'),
(115, 'Gothique'),
(116, 'Hautbois'),
(117, 'Herisson'),
(118, 'Logiciel'),
(119, 'Objectif'),
(120, 'Paranoia'),
(121, 'Parcours'),
(122, 'Pastiche'),
(123, 'Question'),
(124, 'Quetsche'),
(125, 'Scarabee'),
(126, 'Scorpion'),
(127, 'Symptome'),
(128, 'Tabouret'),
(129, 'Tomahawk'),
(130, 'Toujours'),
(131, 'Tourisme'),
(132, 'Triangle'),
(133, 'Utopique'),
(134, 'Zeppelin'),
(135, 'Accordeon'),
(136, 'Ascenseur'),
(137, 'Ascension'),
(138, 'Aseptiser'),
(139, 'Autoroute'),
(140, 'Avalanche'),
(141, 'Balalaika'),
(142, 'Bilboquet'),
(143, 'Bourricot'),
(144, 'Brillance'),
(145, 'Cabriolet'),
(146, 'Contrario'),
(147, 'Cornemuse'),
(148, 'Dangereux'),
(149, 'epluchage'),
(150, 'Feodalite'),
(151, 'Forteresse'),
(152, 'Gondolier'),
(153, 'Graphique'),
(154, 'Horoscope'),
(155, 'Intrepide'),
(156, 'Klaxonner'),
(157, 'Mascarade'),
(158, 'Metaphore'),
(159, 'Narrateur'),
(160, 'Peripetie'),
(161, 'Populaire'),
(162, 'Printemps'),
(163, 'Quemander'),
(164, 'Tambourin'),
(165, 'Vestiaire'),
(166, 'Xylophone'),
(167, 'Acrostiche'),
(168, 'Apocalypse'),
(169, 'Attraction'),
(170, 'Aventurier'),
(171, 'Bouillotte'),
(172, 'Citrouille'),
(173, 'Controverse'),
(174, 'Coquelicot'),
(175, 'Dissimuler'),
(176, 'Flibustier'),
(177, 'Forestiere'),
(178, 'Grenouille'),
(179, 'Impossible'),
(180, 'Labyrinthe'),
(181, 'Maharadjah'),
(182, 'Prudemment'),
(183, 'Quadriceps'),
(184, 'Soliloquer'),
(185, 'Subjective'),
(186, 'Baccalaureat'),
(187, 'Abracadabra'),
(188, 'Francophile'),
(189, 'Pandemonium'),
(190, 'Chlorophylle'),
(191, 'Metallurgie'),
(192, 'Metamorphose'),
(193, 'Montgolfiere'),
(194, 'Kaleidoscope'),
(195, 'Conquistador'),
(196, 'Conspirateur'),
(197, 'Rhododendron'),
(198, 'Qualification'),
(199, 'Protozoaire'),
(200, 'Quadrilatere'),
(201, 'Zygomatique'),
(202, 'Sorcellerie'),
(203, 'Acajou'),
(204, 'Agneau'),
(205, 'Alarme'),
(206, 'Ananas'),
(207, 'Angora'),
(208, 'Animal'),
(209, 'Arcade'),
(210, 'Aviron'),
(211, 'Azimut'),
(212, 'Babine'),
(213, 'Balade'),
(214, 'Bonzai'),
(215, 'Basson'),
(216, 'Billet'),
(217, 'Bouche'),
(218, 'Boucle'),
(219, 'Bronze'),
(220, 'Cabane'),
(221, 'Caiman'),
(222, 'Cloche'),
(223, 'Cheque'),
(224, 'Cirage'),
(225, 'Coccyx'),
(226, 'Crayon'),
(227, 'Garage'),
(228, 'Gospel'),
(229, 'Goulot'),
(230, 'Gramme'),
(231, 'Grelot'),
(232, 'Guenon'),
(233, 'Hochet'),
(234, 'Hormis'),
(235, 'Humour'),
(236, 'Hurler'),
(237, 'Jargon'),
(238, 'Limite'),
(239, 'Lionne'),
(240, 'Menthe'),
(241, 'Oiseau'),
(242, 'Podium'),
(243, 'Poulpe'),
(244, 'Poumon'),
(245, 'Puzzle'),
(246, 'Quartz'),
(247, 'Rapide'),
(248, 'Seisme'),
(249, 'Tetine'),
(250, 'Tomate'),
(251, 'Walabi'),
(252, 'Whisky'),
(253, 'Zipper'),
(254, 'Abriter'),
(255, 'Ballast'),
(256, 'Baryton'),
(257, 'Bassine'),
(258, 'Batavia'),
(259, 'Billard'),
(260, 'Bretzel'),
(261, 'Cithare'),
(262, 'Chariot'),
(263, 'Clairon'),
(264, 'Corbeau'),
(265, 'Cortege'),
(266, 'Crapaud'),
(267, 'Cymbale'),
(268, 'Dentier'),
(269, 'Djembe'),
(270, 'Drapeau'),
(271, 'Exemple'),
(272, 'Fourmis'),
(273, 'Grandir'),
(274, 'Iceberg'),
(275, 'Javelot'),
(276, 'Jockey'),
(277, 'Journal'),
(278, 'Journee'),
(279, 'Jouxter'),
(280, 'Losange'),
(281, 'Macadam'),
(282, 'Mondial'),
(283, 'Notable'),
(284, 'Oxygene'),
(285, 'Panique'),
(286, 'Petrole'),
(287, 'Poterie'),
(288, 'Pouvoir'),
(289, 'Renegat'),
(290, 'Scooter'),
(291, 'Senteur'),
(292, 'Sifflet'),
(293, 'Spirale'),
(294, 'Sucette'),
(295, 'Strophe'),
(296, 'Tonneau'),
(297, 'Trousse'),
(298, 'Tunique'),
(299, 'Ukulele'),
(300, 'Vautour'),
(301, 'Zozoter'),
(302, 'Aquarium'),
(303, 'Araignee'),
(304, 'Arbalete'),
(305, 'Archipel'),
(306, 'Banquise'),
(307, 'Batterie'),
(308, 'Brocante'),
(309, 'Brouhaha'),
(310, 'Capeline'),
(311, 'Clavecin'),
(312, 'Cloporte'),
(313, 'Debutant'),
(314, 'Diapason'),
(315, 'Gangster'),
(316, 'Gothique'),
(317, 'Hautbois'),
(318, 'Herisson'),
(319, 'Logiciel'),
(320, 'Objectif'),
(321, 'Paranoia'),
(322, 'Parcours'),
(323, 'Pastiche'),
(324, 'Question'),
(325, 'Quetsche'),
(326, 'Scarabee'),
(327, 'Scorpion'),
(328, 'Symptome'),
(329, 'Tabouret'),
(330, 'Tomahawk'),
(331, 'Toujours'),
(332, 'Tourisme'),
(333, 'Triangle'),
(334, 'Utopique'),
(335, 'Zeppelin'),
(336, 'Accordeon'),
(337, 'Ascenseur'),
(338, 'Ascension'),
(339, 'Aseptiser'),
(340, 'Autoroute'),
(341, 'Avalanche'),
(342, 'Balalaika'),
(343, 'Bilboquet'),
(344, 'Bourricot'),
(345, 'Brillance'),
(346, 'Cabriolet'),
(347, 'Contrario'),
(348, 'Cornemuse'),
(349, 'Dangereux'),
(350, 'epluchage'),
(351, 'Feodalite'),
(352, 'Forteresse'),
(353, 'Gondolier'),
(354, 'Graphique'),
(355, 'Horoscope'),
(356, 'Intrepide'),
(357, 'Klaxonner'),
(358, 'Mascarade'),
(359, 'Metaphore'),
(360, 'Narrateur'),
(361, 'Peripetie'),
(362, 'Populaire'),
(363, 'Printemps'),
(364, 'Quemander'),
(365, 'Tambourin'),
(366, 'Vestiaire'),
(367, 'Xylophone'),
(368, 'Acrostiche'),
(369, 'Apocalypse'),
(370, 'Attraction'),
(371, 'Aventurier'),
(372, 'Bouillotte'),
(373, 'Citrouille'),
(374, 'Controverse'),
(375, 'Coquelicot'),
(376, 'Dissimuler'),
(377, 'Flibustier'),
(378, 'Forestiere'),
(379, 'Grenouille'),
(380, 'Impossible'),
(381, 'Labyrinthe'),
(382, 'Maharadjah'),
(383, 'Prudemment'),
(384, 'Quadriceps'),
(385, 'Soliloquer'),
(386, 'Subjective'),
(387, 'Baccalaureat'),
(388, 'Abracadabra'),
(389, 'Francophile'),
(390, 'Pandemonium'),
(391, 'Chlorophylle'),
(392, 'Metallurgie'),
(393, 'Metamorphose'),
(394, 'Montgolfiere'),
(395, 'Kaleidoscope'),
(396, 'Conquistador'),
(397, 'Conspirateur'),
(398, 'Rhododendron'),
(399, 'Qualification'),
(400, 'Protozoaire'),
(401, 'Quadrilatere'),
(402, 'Zygomatique'),
(403, 'Sorcellerie'),
(404, 'Belligerant');
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /; /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;