LaQEkKQU

1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4/*!40101 SET NAMES utf8mb4 */;
5/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
6/*!40103 SET TIME_ZONE='+00:00' */;
7/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
8/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
9/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
10/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
11
12
13DROP DATABASE IF EXISTS simple_bdd;
14
15CREATE DATABASE simple_bdd CHARACTER SET 'utf8';
16GRANT ALL PRIVILEGES ON simple_bdd.* TO 'admin'@'localhost';
17
18USE simple_bdd;
19
20--
21-- Table structure for table `ip_login`
22--
23DROP TABLE IF EXISTS `ip_login`;
24/*!40101 SET @saved_cs_client     = @@character_set_client */;
25/*!40101 SET character_set_client = utf8 */;
26CREATE TABLE `ip_login` (
27  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
28  `ip` varchar(16) DEFAULT NULL,
29  `lastLogin` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
30  `failedLogin` int(11) DEFAULT '0',
31  PRIMARY KEY (`id`)
32) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `ip_login`
37--
38
39LOCK TABLES `ip_login` WRITE;
40/*!40000 ALTER TABLE `ip_login` DISABLE KEYS */;
41/*!40000 ALTER TABLE `ip_login` ENABLE KEYS */;
42UNLOCK TABLES;
43
44--
45-- Table structure for table `messages`
46--
47
48DROP TABLE IF EXISTS `messages`;
49/*!40101 SET @saved_cs_client     = @@character_set_client */;
50/*!40101 SET character_set_client = utf8 */;
51CREATE TABLE `messages` (
52  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
53  `id_user` int(10) unsigned NOT NULL,
54  `content` text,
55  `posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
56  PRIMARY KEY (`id`),
57  KEY `fk_userId` (`id_user`),
58  CONSTRAINT `fk_userId` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
59) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
60/*!40101 SET character_set_client = @saved_cs_client */;
61
62--
63-- Dumping data for table `messages`
64--
65
66LOCK TABLES `messages` WRITE;
67/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
68/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
69UNLOCK TABLES;
70
71--
72-- Table structure for table `users`
73--
74
75DROP TABLE IF EXISTS `users`;
76/*!40101 SET @saved_cs_client     = @@character_set_client */;
77/*!40101 SET character_set_client = utf8 */;
78CREATE TABLE `users` (
79  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
80  `username` varchar(32) NOT NULL,
81  `pwd` varchar(124) NOT NULL,
82  `failedLogin` int(11) DEFAULT '0',
83  `isAdmin` tinyint(1) DEFAULT '0',
84  PRIMARY KEY (`id`)
85) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
86/*!40101 SET character_set_client = @saved_cs_client */;
87
88--
89-- Dumping data for table `users`
90--
91
92LOCK TABLES `users` WRITE;
93/*!40000 ALTER TABLE `users` DISABLE KEYS */;
94INSERT INTO `users` VALUES (1,'admin','$1$C.QfoftG$JTkD/rByk..VJx81/d5ds1',0,1);
95/*!40000 ALTER TABLE `users` ENABLE KEYS */;
96UNLOCK TABLES;
97
98--
99-- Table structure for table `vulnerability`
100--
101
102DROP TABLE IF EXISTS `vulnerability`;
103/*!40101 SET @saved_cs_client     = @@character_set_client */;
104/*!40101 SET character_set_client = utf8 */;
105CREATE TABLE `vulnerability` (
106  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
107  `name` varchar(32) DEFAULT NULL,
108  `isProtected` tinyint(1) DEFAULT NULL,
109  PRIMARY KEY (`id`)
110) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
111/*!40101 SET character_set_client = @saved_cs_client */;
112
113--
114-- Dumping data for table `vulnerability`
115--
116
117LOCK TABLES `vulnerability` WRITE;
118/*!40000 ALTER TABLE `vulnerability` DISABLE KEYS */;
119INSERT INTO `vulnerability` VALUES (1,'XSS',1),(2,'brute-force_login',1);
120/*!40000 ALTER TABLE `vulnerability` ENABLE KEYS */;
121UNLOCK TABLES;
122/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
123
124/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
125/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
126/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
127/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
128/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
129/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
130/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
131
132-- Dump completed on 2018-11-04 11:59:23