 
 DROP TABLE IF EXISTS `utilisateur`;
 CREATE TABLE IF NOT EXISTS `utilisateur` (
-  `Id` int(5) NOT NULL,
+  `Id` int(10) NOT NULL,
   `Login` varchar(20) NOT NULL,
   `Mot_de_passe` varchar(20) NOT NULL,
   `Nom` varchar(20) NOT NULL,
   `Prenom` varchar(20) NOT NULL,
   `Email` varchar(30) NOT NULL,
-  `Photo` int(11) NOT NULL
+  `Photo` int(10) DEFAULT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 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 */;
+
+insert into parties values(default, 'tictactoo', 1, 2, 'En attente', DEFAULT, DEFAULT, DEFAULT);
-- --------------------------------------------------------

--
-- Structure de la table `partie`
--

DROP TABLE IF EXISTS `partie`;
CREATE TABLE IF NOT EXISTS `partie` (
  `Id` int(5) NOT NULL,
  `Id_utilisateur1` int(5) NOT NULL,
  `Id_utilisateur2` int(5) NOT NULL,
  `Status Enum` enum('En cours','Finis','En attente') NOT NULL,
  `Score_joueur1` int(1) DEFAULT NULL,
  `Score_joueur2` int(1) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

CREATE DATABASE IF NOT EXISTS projectGame;
USE projectGame;
-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
