<commit_before>-- phpMyAdmin SQL Dump
-- version 3.3.8
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 08-02-2013 a las 18:27:48
-- Versión del servidor: 5.5.29
-- Versión de PHP: 5.4.6-1ubuntu1.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 utf8 */;

--
-- Base de datos: `enode`
--

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

--
-- Estructura de tabla para la tabla `clients`
--

CREATE TABLE IF NOT EXISTS `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `hash` binary(16) NOT NULL,
  `id_ed2k` int(10) unsigned NOT NULL,
  `ipv4` int(10) unsigned NOT NULL,
  `port` smallint(5) unsigned NOT NULL,
  `time_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `online` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hash` (`hash`),
  KEY `id_ed2k` (`id_ed2k`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=188 ;

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

--
-- Estructura de tabla para la tabla `files`
--

CREATE TABLE IF NOT EXISTS `files` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `hash` binary(16) NOT NULL,
  `size` bigint(20) NOT NULL,
  `time_creation` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `time_offer` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `source_id` int(10) unsigned NOT NULL,
  `source_port` smallint(5) unsigned NOT NULL,
  `sources` int(11) NOT NULL,
  `completed` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hash_size` (`hash`,`size`),
  KEY `hash` (`hash`),
  KEY `size` (`size`),
  KEY `time_creation` (`time_creation`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=55629 ;

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

--
-- Estructura de tabla para la tabla `sources`
--

CREATE TABLE IF NOT EXISTS `sources` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_file` bigint(20) unsigned NOT NULL,
  `id_client` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `ext` varchar(8) NOT NULL,
  `time_offer` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `type` enum('Image','Audio','Video','Pro','Doc') NOT NULL,
  `rating` tinyint(2) unsigned NOT NULL,
  `title` varchar(128) NOT NULL,
  `artist` varchar(128) NOT NULL,
  `album` varchar(128) NOT NULL,
  `length` int(8) unsigned NOT NULL,
  `bitrate` int(8) unsigned NOT NULL,<commit_msg>update table structure<commit_after>-- phpMyAdmin SQL Dump
-- version 3.3.8
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 09-02-2013 a las 12:56:29
-- Versión del servidor: 5.5.29
-- Versión de PHP: 5.4.6-1ubuntu1.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 utf8 */;

--
-- Base de datos: `enode`
--

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

--
-- Estructura de tabla para la tabla `clients`
--

DROP TABLE IF EXISTS `clients`;
CREATE TABLE `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `hash` binary(16) NOT NULL,
  `id_ed2k` int(10) unsigned NOT NULL,
  `ipv4` int(10) unsigned NOT NULL,
  `port` smallint(5) unsigned NOT NULL,
  `time_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `online` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hash` (`hash`),
  KEY `id_ed2k` (`id_ed2k`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=188 ;

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

--
-- Estructura de tabla para la tabla `files`
--

DROP TABLE IF EXISTS `files`;
CREATE TABLE `files` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `hash` binary(16) NOT NULL,
  `size` bigint(20) NOT NULL,
  `time_creation` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `time_offer` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `source_id` int(10) unsigned NOT NULL,
  `source_port` smallint(5) unsigned NOT NULL,
  `sources` int(11) NOT NULL,
  `completed` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hash_size` (`hash`,`size`),
  KEY `hash` (`hash`),
  KEY `size` (`size`),
  KEY `time_creation` (`time_creation`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=55629 ;

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

--
-- Estructura de tabla para la tabla `sources`
--

DROP TABLE IF EXISTS `sources`;
CREATE TABLE `sources` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_file` bigint(20) unsigned NOT NULL,
  `id_client` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `ext` varchar(8) NOT NULL,
  `time_offer` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `type` enum('Image','Audio','Video','Pro','Doc') NOT NULL,
  `rating` tinyint(2) unsigned NOT NULL,
  `title` varchar(128) NOT NULL,
  `artist` varchar(128) NOT NULL,
  `album` varchar(128) NOT NULL,
  `length` int(8) unsigned NOT NULL,
  `bitrate` int(8) unsigned NOT NULL,
{'fraction_non_alphanumeric': 0.19794637763833428, 'fraction_numerical': 0.046016352918805854, 'mean_word_length': 3.197924980047885, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 2, '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': '5747287', 'n_tokens_mistral': 2079, 'n_tokens_neox': 1876, 'n_words': 527}