<commit_before>USE tanaguru;

-- MySQL dump 10.11
--
-- Host: localhost    Database: tanaguru
-- ------------------------------------------------------
-- Server version	5.0.51a-3ubuntu5.4
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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,NO_KEY_OPTIONS,NO_TABLE_OPTIONS' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `AUDIT`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `AUDIT` (
  `Id_Audit` bigint(20) NOT NULL auto_increment,
  `Comment` varchar(255) default NULL,
  `Dt_Creation` datetime default NULL,
  `Mark` float default NULL,
  `Status` varchar(255) default NULL,
  PRIMARY KEY  (`Id_Audit`)
);
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `AUDIT_TEST`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `AUDIT_TEST` (
  `Id_Audit` bigint(20) NOT NULL,
  `Id_Test` bigint(20) NOT NULL,
  KEY `FK838E6E96493EC9C2` (`Id_Audit`),
  KEY `FK838E6E96A17A5FA8` (`Id_Test`)
);
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `CONTENT`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `CONTENT` (
  `DTYPE` varchar(31) NOT NULL,
  `Id_Content` bigint(20) NOT NULL auto_increment,
  `Dt_Loading` datetime NOT NULL,
  `Uri` varchar(255) NOT NULL,
  `Source` longtext,
  `Dom` longtext,
  `Javascript` longtext,
  `Stylesheet` longtext,
  `Id_Audit` bigint(20) NOT NULL,
  `Id_Ssp` bigint(20) default NULL,
  `Id_Page` bigint(20) default NULL,
  PRIMARY KEY  (`Id_Content`),
  UNIQUE KEY `Uri` (`Uri`,`Id_Audit`),
  KEY `FK6382C059493EC9C2` (`Id_Audit`),
  KEY `FK6382C05977C2CAAC` (`Id_Ssp`),
  KEY `FK6382C059A8A177A1` (`Id_Page`)
);
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `CRITERION`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `CRITERION` (
  `IdCriterion` bigint(20) NOT NULL auto_increment,
  `Cd_Criterion` varchar(255) default NULL,
  `Description` varchar(255) default NULL,
  `Label` varchar(255) default NULL,
  `Rank` int(11) default NULL,
  `Id_Reference` bigint(20) default NULL,
  `Id_Theme` bigint(20) default NULL,
  PRIMARY KEY  (`IdCriterion`),
  KEY `FKBCFA1E81DA004892` (`Id_Reference`),
  KEY `FKBCFA1E81D667448E` (`Id_Theme`)
);
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DECISION_LEVEL`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DECISION_LEVEL` (
  `Id_Decision_Level` bigint(20) NOT NULL auto_increment,<commit_msg>Feature #64 Implementation of the crawler component based on heritrix<commit_after>USE tanaguru;

-- MySQL dump 10.11
--
-- Host: localhost    Database: tanaguru
-- ------------------------------------------------------
-- Server version	5.0.51a-3ubuntu5.4
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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,NO_KEY_OPTIONS,NO_TABLE_OPTIONS' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `AUDIT`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `AUDIT` (
  `Id_Audit` bigint(20) NOT NULL auto_increment,
  `Comment` varchar(255) default NULL,
  `Dt_Creation` datetime default NULL,
  `Mark` float default NULL,
  `Status` varchar(255) default NULL,
  PRIMARY KEY  (`Id_Audit`)
);
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `AUDIT_TEST`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `AUDIT_TEST` (
  `Id_Audit` bigint(20) NOT NULL,
  `Id_Test` bigint(20) NOT NULL,
  KEY `FK838E6E96493EC9C2` (`Id_Audit`),
  KEY `FK838E6E96A17A5FA8` (`Id_Test`)
);
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `CONTENT`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `CONTENT` (
  `DTYPE` varchar(31) NOT NULL,
  `Id_Content` bigint(20) NOT NULL auto_increment,
  `Dt_Loading` datetime NOT NULL,
  `Uri` varchar(255) NOT NULL,
  `Source` longtext,
  `Adapted_Content` longtext,
  `Binary_Content` lonblob default NULL,
  `Http_StatusCode` int NOT NULL,
  `Id_Audit` bigint(20) NOT NULL,
  `Id_Ssp` bigint(20) default NULL,
  `Id_Page` bigint(20) default NULL,
  PRIMARY KEY  (`Id_Content`),
  KEY `FK6382C059493EC9C2` (`Id_Audit`),
  KEY `FK6382C05977C2CAAC` (`Id_Ssp`),
  KEY `FK6382C059A8A177A1` (`Id_Page`)
);
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `CONTENT_RELATIONSHIP`
--
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `CONTENT_RELATIONSHIP` (
`Id` bigint(20) NOT NULL AUTO_increment,
`Id_Content_Parent` bigint(20) NOT NULL,
`Id_Content_Child` bigint(20) NOT NULL,
PRIMARY KEY (`Id`),
FOREIGN KEY (`Id_Content_Parent`) REFERENCES CONTENT(`Id_Content`),
FOREIGN KEY (`Id_Content_Child`) REFERENCES CONTENT(`Id_Content`)
);
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `CRITERION`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `CRITERION` (
  `IdCriterion` bigint(20) NOT NULL auto_increment,
  `Cd_Criterion` varchar(255) default NULL,
  `Description` varchar(255) default NULL,
  `Label` varchar(255) default NULL,
  `Rank` int(11) default NULL,
  `Id_Reference` bigint(20) default NULL,
  `Id_Theme` bigint(20) default NULL,
  PRIMARY KEY  (`IdCriterion`),
  KEY `FKBCFA1E81DA004892` (`Id_Reference`),
  KEY `FKBCFA1E81D667448E` (`Id_Theme`)
);
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DECISION_LEVEL`
--

SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `DECISION_LEVEL` (
  `Id_Decision_Level` bigint(20) NOT NULL auto_increment,
{'fraction_non_alphanumeric': 0.14519870109788155, 'fraction_numerical': 0.053966290397402195, 'mean_word_length': 4.816546762589928, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, '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': '5013730', 'n_tokens_mistral': 2714, 'n_tokens_neox': 2452, 'n_words': 551}