Bg9cEm8n

1
2SET NAMES utf8;
3SET time_zone = '+00:00';
4SET foreign_key_checks = 0;
5SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
6
7DROP TABLE IF EXISTS `ld_bruteforce`;
8CREATE TABLE `ld_bruteforce` (
9  `idb` int(11) NOT NULL AUTO_INCREMENT,
10  `ip` varchar(16) NOT NULL,
11  `attack` datetime NOT NULL,
12  PRIMARY KEY (`idb`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8;
14
15
16DROP TABLE IF EXISTS `ld_success`;
17CREATE TABLE `ld_success` (
18  `idc` int(11) NOT NULL AUTO_INCREMENT,
19  `id_user` int(11) NOT NULL,
20  `idl_level` int(11) NOT NULL,
21  `time_spent` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP,
22  PRIMARY KEY (`idc`)
23) ENGINE=MyISAM DEFAULT CHARSET=utf8;
24
25
26DROP TABLE IF EXISTS `ld_users`;
27CREATE TABLE `ld_users` (
28  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `Pseudo` varchar(65) NOT NULL,
30  `Mail` varchar(255) NOT NULL,
31  `Password` varchar(255) NOT NULL,
32  `Session` varchar(255) NOT NULL,
33  `Level` int(11) NOT NULL DEFAULT '0',
34  `Ip` varchar(25) NOT NULL,
35  PRIMARY KEY (`id`)
36) ENGINE=MyISAM DEFAULT CHARSET=utf8;