fwV7LFP1

1-- phpMyAdmin SQL Dump
2-- version 4.9.2
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le :  ven. 27 mars 2020 à 13:29
7-- Version du serveur :  10.4.10-MariaDB
8-- Version de PHP :  7.3.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Base de données :  `mvc`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `user`
29--
30
31DROP TABLE IF EXISTS `user`;
32CREATE TABLE IF NOT EXISTS `user` (
33  `id` int(11) NOT NULL AUTO_INCREMENT,
34  `username` varchar(255) NOT NULL,
35  `email` varchar(255) NOT NULL,
36  `password` varchar(255) NOT NULL,
37  `user_status` int(11) NOT NULL DEFAULT 1 COMMENT 'user ban(0) or not (1)',
38  `account_status` int(11) NOT NULL DEFAULT 1 COMMENT 'Account activated(1) or not(0)',
39  `created_at` datetime NOT NULL COMMENT 'Creation date\n',
40  `modified_at` datetime DEFAULT NULL COMMENT 'Date de dernière modification\n',
41  `group` int(11) DEFAULT 2 COMMENT '0 = Admin\n1 = writter\n2 = normal',
42  PRIMARY KEY (`id`)
43) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
44
45-- --------------------------------------------------------
46
47--
48-- Structure de la table `user_1`
49--
50
51DROP TABLE IF EXISTS `user_1`;
52CREATE TABLE IF NOT EXISTS `user_1` (
53  `id` int(11) DEFAULT NULL,
54  `username` varchar(1020) DEFAULT NULL,
55  `email` varchar(1020) DEFAULT NULL,
56  `password` varchar(1020) DEFAULT NULL,
57  `user_status` int(11) DEFAULT NULL,
58  `account_status` int(11) DEFAULT NULL,
59  `created_at` timestamp NULL DEFAULT NULL,
60  `modified_at` timestamp NULL DEFAULT NULL,
61  `group` int(11) DEFAULT NULL
62) ENGINE=MyISAM DEFAULT CHARSET=latin1;
63COMMIT;
64
65/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
66/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
67/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;