7KiUr87p

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET AUTOCOMMIT = 0;
3START TRANSACTION;
4SET time_zone = "+00:00";
5
6/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
7/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
8/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
9/*!40101 SET NAMES utf8mb4 */;
10
11
12DROP TABLE IF EXISTS `article`;
13CREATE TABLE IF NOT EXISTS `article` (
14  `ID` int(11) NOT NULL AUTO_INCREMENT,
15  `TITLE` varchar(60) NOT NULL,
16  `TEXT` text NOT NULL,
17  `AUTHOR` int(11) NOT NULL,
18  `DATE` date NOT NULL,
19  PRIMARY KEY (`ID`)
20) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
21
22INSERT INTO `article` (`ID`, `TITLE`, `TEXT`, `AUTHOR`, `DATE`) VALUES
23(1, 'Mes vacances', 'Mes vacances se sont très bien passées, c\'était vraiment cool ducoup je viens partager ça avec vous.', 15, '2017-12-13');
24
25DROP TABLE IF EXISTS `commentaire`;
26CREATE TABLE IF NOT EXISTS `commentaire` (
27  `ID` int(11) NOT NULL AUTO_INCREMENT,
28  `TEXT` text NOT NULL,
29  `ID_ART` int(11) NOT NULL,
30  `AUTHOR` int(11) NOT NULL,
31  `DATE` date NOT NULL,
32  PRIMARY KEY (`ID`)
33) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
34
35INSERT INTO `commentaire` (`ID`, `TEXT`, `ID_ART`, `AUTHOR`, `DATE`) VALUES
36(1, 'Ton voyage c\'est de la merde', 1, 111, '2017-12-13'),
37(2, 'Ton voyage à l\'air cool', 1, 151, '2017-12-13');
38
39DROP TABLE IF EXISTS `photo`;
40CREATE TABLE IF NOT EXISTS `photo` (
41  `ID` int(11) NOT NULL AUTO_INCREMENT,
42  `Name` text,
43  `Lien` text NOT NULL,
44  PRIMARY KEY (`ID`)
45) ENGINE=MyISAM DEFAULT CHARSET=utf8;
46
47DROP TABLE IF EXISTS `user`;
48CREATE TABLE IF NOT EXISTS `user` (
49  `ID` int(11) NOT NULL AUTO_INCREMENT,
50  `LOGIN` varchar(30) NOT NULL,
51  `NOM` text NOT NULL,
52  `PRENOM` text NOT NULL,
53  PRIMARY KEY (`ID`)
54) ENGINE=MyISAM AUTO_INCREMENT=152 DEFAULT CHARSET=utf8;
55
56INSERT INTO `user` (`ID`, `LOGIN`, `NOM`, `PRENOM`) VALUES
57(111, 'LULU', 'Clementei', 'Lucas'),
58(151, 'Oim', 'Chermette', 'Mathis');
59COMMIT;
60
61/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
62/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
63/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;