<commit_before>-- phpMyAdmin SQL Dump
-- version 4.7.5
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost
-- Généré le :  jeu. 30 nov. 2017 à 11:48
-- Version du serveur :  5.7.20-0ubuntu0.16.04.1
-- Version de PHP :  7.1.12-1+ubuntu16.04.1+deb.sury.org+1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de données :  `authentication`
--
CREATE DATABASE IF NOT EXISTS `authentication` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `authentication`;

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

--
-- Structure de la table `lost_password`
--

CREATE TABLE `lost_password` (
  `mail` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `datetime` datetime NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `mail_validation`
--

CREATE TABLE `mail_validation` (
  `mail` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `datetime` datetime NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `mail_validation`
--

INSERT INTO `mail_validation` (`mail`, `token`, `datetime`, `created_at`, `updated_at`) VALUES
('<EMAIL>', 'd97823835cbfc218984773d54f87744be4ab7d1a6eff97c0f86d8a41de995cc6', '2017-11-30 11:32:29', '2017-11-30', '2017-11-30');

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

--
-- Structure de la table `users`
--

CREATE TABLE `users` (
  `name` varchar(40) NOT NULL,
  `firstname` varchar(40) NOT NULL,
  `mail` varchar(255) NOT NULL,
  `mdp` varchar(256) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `mail_validation` tinyint(1) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `users`
--

INSERT INTO `users` (`name`, `firstname`, `mail`, `mdp`, `status`, `mail_validation`, `type`, `created_at`, `updated_at`) VALUES
('Admin', 'Admin', '<EMAIL>', '$2y$10$jPFYnh8ShDAYEsVxxXm8WuTJO61/.8932ssqDEHhy.3jruX63xI6G', 1, 1, 1, '2017-11-30', '2017-11-30');

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `lost_password`
--
ALTER TABLE `lost_password`
  ADD PRIMARY KEY (`mail`);

--
-- Index pour la table `mail_validation`
--
ALTER TABLE `mail_validation`
  ADD PRIMARY KEY (`mail`);

--
-- Index pour la table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`mail`);
<commit_msg>new bdd<commit_after>-- phpMyAdmin SQL Dump
-- version 4.7.5
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost
-- Généré le :  mar. 12 déc. 2017 à 13:46
-- Version du serveur :  5.7.20-0ubuntu0.16.04.1
-- Version de PHP :  5.6.32-1+ubuntu16.04.1+deb.sury.org+1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de données :  `authentication`
--

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

--
-- Structure de la table `lost_password`
--

CREATE TABLE `lost_password` (
  `mail` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `datetime` datetime NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `mail_validation`
--

CREATE TABLE `mail_validation` (
  `mail` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `datetime` datetime NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `users`
--

CREATE TABLE `users` (
  `name` varchar(40) NOT NULL,
  `firstname` varchar(40) NOT NULL,
  `mail` varchar(255) NOT NULL,
  `mdp` varchar(256) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `mail_validation` tinyint(1) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL,
  `ORCID_ID` varchar(20) DEFAULT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Déchargement des données de la table `users`
--

INSERT INTO `users` (`name`, `firstname`, `mail`, `mdp`, `status`, `mail_validation`, `type`, `ORCID_ID`, `created_at`, `updated_at`) VALUES
('Admin', 'Admin', '<EMAIL>', '$2y$10$jPFYnh8ShDAYEsVxxXm8WuTJO61/.8932ssqDEHhy.3jruX63xI6G', 1, 1, 1, '0000-0000-0000-0001', '2017-11-30', '2017-12-12');

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `lost_password`
--
ALTER TABLE `lost_password`
  ADD PRIMARY KEY (`mail`);

--
-- Index pour la table `mail_validation`
--
ALTER TABLE `mail_validation`
  ADD PRIMARY KEY (`mail`);

--
-- Index pour la table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`mail`);

{'fraction_non_alphanumeric': 0.20964166974510529, 'fraction_numerical': 0.06353897303287773, 'mean_word_length': 3.011111111111111, 'pattern_counts': {'":': 0, '<': 6, '<?xml version=': 0, '>': 6, 'https://': 2, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 2, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5419436', 'n_tokens_mistral': 2213, 'n_tokens_neox': 1968, 'n_words': 515}