<commit_before>-- --------------------------------------------------------
-- Hôte :                        127.0.0.1
-- Version du serveur:           5.7.16-0ubuntu0.16.04.1 - (Ubuntu)
-- SE du serveur:                Linux
-- HeidiSQL Version:             9.4.0.5130
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- Export de la structure de la base pour CSMCaen
DROP DATABASE IF EXISTS `CSMCaen`;
CREATE DATABASE IF NOT EXISTS `CSMCaen` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `CSMCaen`;

-- Export de la structure de la table CSMCaen. Match
DROP TABLE IF EXISTS `Match`;
CREATE TABLE IF NOT EXISTS `Match` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `team` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Les données exportées n'étaient pas sélectionnées.
-- Export de la structure de la table CSMCaen. Post
DROP TABLE IF EXISTS `Post`;
CREATE TABLE IF NOT EXISTS `Post` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `content` text NOT NULL,
  `match` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_Post_Match` (`match`),
  CONSTRAINT `FK_Post_Match` FOREIGN KEY (`match`) REFERENCES `Match` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Les données exportées n'étaient pas sélectionnées.
-- Export de la structure de la table CSMCaen. Tweet
DROP TABLE IF EXISTS `Tweet`;
CREATE TABLE IF NOT EXISTS `Tweet` (
  `id` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `username` text NOT NULL,
  `date` date NOT NULL,
  `match` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_Tweet_Match` (`match`),
  CONSTRAINT `FK_Tweet_Match` FOREIGN KEY (`match`) REFERENCES `Match` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- Les données exportées n'étaient pas sélectionnées.
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;<commit_msg>Convert collation to utf8mb4<commit_after>-- --------------------------------------------------------
-- Hôte :                        127.0.0.1
-- Version du serveur:           5.7.16-0ubuntu0.16.04.1 - (Ubuntu)
-- SE du serveur:                Linux
-- HeidiSQL Version:             9.4.0.5130
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- Export de la structure de la base pour CSMCaen
DROP DATABASE IF EXISTS `CSMCaen`;
CREATE DATABASE IF NOT EXISTS `CSMCaen` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `CSMCaen`;

-- Export de la structure de la table CSMCaen. Match
DROP TABLE IF EXISTS `Match`;
CREATE TABLE IF NOT EXISTS `Match` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `team` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Les données exportées n'étaient pas sélectionnées.
-- Export de la structure de la table CSMCaen. Post
DROP TABLE IF EXISTS `Post`;
CREATE TABLE IF NOT EXISTS `Post` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `content` varchar(255) NOT NULL,
  `match` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_Post_Match` (`match`),
  CONSTRAINT `FK_Post_Match` FOREIGN KEY (`match`) REFERENCES `Match` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Les données exportées n'étaient pas sélectionnées.
-- Export de la structure de la table CSMCaen. Tweet
DROP TABLE IF EXISTS `Tweet`;
CREATE TABLE IF NOT EXISTS `Tweet` (
  `id` int(6) unsigned NOT NULL AUTO_INCREMENT,
  `content` varchar(255) NOT NULL,
  `username` varchar(50) NOT NULL,
  `date` date NOT NULL,
  `match` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_Tweet_Match` (`match`),
  CONSTRAINT `FK_Tweet_Match` FOREIGN KEY (`match`) REFERENCES `Match` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Les données exportées n'étaient pas sélectionnées.
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
{'fraction_non_alphanumeric': 0.1671244453834777, 'fraction_numerical': 0.040777519543629834, 'mean_word_length': 3.261026102610261, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 6, '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': '5058557', 'n_tokens_mistral': 1869, 'n_tokens_neox': 1701, 'n_words': 492}