From 5fd9fa480f302902328b81f912dd67ce378284f8 Mon Sep 17 00:00:00 2001
From: citizenz7 <citizenz7@protonmail.com>
Date: Thu, 20 Apr 2017 18:50:55 +0200
Subject: V.1.4.6

---
 SQL/database.sql | 544 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 544 insertions(+)
 create mode 100644 SQL/database.sql

(limited to 'SQL/database.sql')

diff --git a/SQL/database.sql b/SQL/database.sql
new file mode 100644
index 0000000..19e118e
--- /dev/null
+++ b/SQL/database.sql
@@ -0,0 +1,544 @@
+-- phpMyAdmin SQL Dump
+-- version 4.2.12deb2+deb8u2
+-- http://www.phpmyadmin.net
+--
+-- Client :  localhost
+-- Généré le :  Jeu 20 Avril 2017 à 17:51
+-- Version du serveur :  10.0.30-MariaDB-0+deb8u1
+-- Version de PHP :  5.6.30-0+deb8u1
+
+SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
+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 utf8 */;
+
+--
+-- Base de données :  `c4_freetorrent`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `blog_cats`
+--
+
+CREATE TABLE IF NOT EXISTS `blog_cats` (
+`catID` int(11) unsigned NOT NULL,
+  `catTitle` varchar(255) DEFAULT NULL,
+  `catSlug` varchar(255) DEFAULT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `blog_cats`
+--
+
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `blog_licences`
+--
+
+CREATE TABLE IF NOT EXISTS `blog_licences` (
+`licenceID` int(11) unsigned NOT NULL,
+  `licenceTitle` varchar(255) NOT NULL,
+  `licenceSlug` varchar(255) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `blog_licences`
+--
+
+INSERT INTO `blog_licences` (`licenceID`, `licenceTitle`, `licenceSlug`) VALUES
+(23, 'CeCILL', 'cecill'),
+(22, 'C.C. Public Domain', 'c-c-public-domain'),
+(21, 'Apache 2.0', 'apache-2-0'),
+(20, 'C.C. 0', 'c-c-0'),
+(17, 'FreeBSD', 'freebsd'),
+(16, 'AGPL', 'agpl'),
+(14, 'C.C. By-Nc-Nd', 'c-c-by-nc-nd'),
+(13, 'C.C. By-Nc-Sa', 'c-c-by-nc-sa'),
+(12, 'C.C. By-Nc', 'c-c-by-nc'),
+(1, 'GPL V2', 'gpl-v2'),
+(2, 'GPL V3', 'gpl-v3'),
+(3, 'LGPL V2', 'lgpl-v2'),
+(4, 'LGPL V3', 'lgpl-v3'),
+(6, 'BSD', 'bsd'),
+(7, 'MIT', 'mit'),
+(9, 'C.C. By', 'c-c-by'),
+(10, 'C.C. By-Nd', 'c-c-by-nd'),
+(11, 'C.C. By-Sa', 'c-c-by-sa');
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `blog_logs`
+--
+
+CREATE TABLE IF NOT EXISTS `blog_logs` (
+`log_id` int(11) NOT NULL,
+  `remote_addr` varchar(255) NOT NULL,
+  `request_uri` varchar(255) NOT NULL,
+  `message` text NOT NULL,
+  `log_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB AUTO_INCREMENT=1891 DEFAULT CHARSET=latin1;
+
+--
+-- Contenu de la table `blog_logs`
+--
+
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `blog_members`
+--
+
+CREATE TABLE IF NOT EXISTS `blog_members` (
+`memberID` int(11) unsigned NOT NULL,
+  `username` varchar(255) DEFAULT NULL,
+  `password` varchar(255) DEFAULT NULL,
+  `email` varchar(255) DEFAULT NULL,
+  `pid` varchar(32) NOT NULL,
+  `memberDate` datetime NOT NULL,
+  `avatar` varchar(255) NOT NULL,
+  `active` varchar(255) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `blog_members`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `blog_messages`
+--
+
+CREATE TABLE IF NOT EXISTS `blog_messages` (
+`messages_id` int(11) NOT NULL,
+  `messages_id_expediteur` int(11) NOT NULL DEFAULT '0',
+  `messages_id_destinataire` int(11) NOT NULL DEFAULT '0',
+  `messages_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `messages_titre` text NOT NULL,
+  `messages_message` text NOT NULL,
+  `messages_lu` enum('0','1') NOT NULL DEFAULT '0'
+) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `blog_messages`
+--
+
+
+--
+-- Structure de la table `blog_posts_seo`
+--
+
+CREATE TABLE IF NOT EXISTS `blog_posts_seo` (
+`postID` int(11) unsigned NOT NULL,
+  `postHash` varchar(40) NOT NULL,
+  `postTitle` varchar(255) DEFAULT NULL,
+  `postAuthor` varchar(255) NOT NULL,
+  `postSlug` varchar(255) DEFAULT NULL,
+  `postLink` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
+  `postDesc` text,
+  `postCont` text,
+  `postTaille` bigint(20) NOT NULL DEFAULT '0',
+  `postDate` datetime DEFAULT NULL,
+  `postTorrent` varchar(150) NOT NULL,
+  `postImage` varchar(255) NOT NULL,
+  `postViews` int(11) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `blog_posts_seo`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `blog_post_cats`
+--
+
+CREATE TABLE IF NOT EXISTS `blog_post_cats` (
+`id` int(11) unsigned NOT NULL,
+  `postID` int(11) DEFAULT NULL,
+  `catID` int(11) DEFAULT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=277 DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `blog_post_cats`
+--
+
+
+
+--
+-- Structure de la table `blog_post_licences`
+--
+
+CREATE TABLE IF NOT EXISTS `blog_post_licences` (
+`id_BPL` int(11) unsigned NOT NULL,
+  `postID_BPL` int(11) NOT NULL,
+  `licenceID_BPL` int(11) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=391 DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `blog_post_licences`
+--
+
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `compteur`
+--
+
+CREATE TABLE IF NOT EXISTS `compteur` (
+  `ip` varchar(15) NOT NULL,
+  `timestamp` int(11) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `compteur`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `connectes`
+--
+
+CREATE TABLE IF NOT EXISTS `connectes` (
+  `ip` varchar(15) NOT NULL,
+  `pseudo` varchar(255) NOT NULL,
+  `timestamp` int(11) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `connectes`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `xbt_announce_log`
+--
+
+CREATE TABLE IF NOT EXISTS `xbt_announce_log` (
+`id` int(11) NOT NULL,
+  `ipa` int(10) unsigned NOT NULL,
+  `port` int(11) NOT NULL,
+  `event` int(11) NOT NULL,
+  `info_hash` binary(20) NOT NULL,
+  `peer_id` binary(20) NOT NULL,
+  `downloaded` bigint(20) unsigned NOT NULL,
+  `left0` bigint(20) unsigned NOT NULL,
+  `uploaded` bigint(20) unsigned NOT NULL,
+  `uid` int(11) NOT NULL,
+  `mtime` int(11) NOT NULL
+) ENGINE=MyISAM AUTO_INCREMENT=31148 DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `xbt_announce_log`
+--
+
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `xbt_config`
+--
+
+CREATE TABLE IF NOT EXISTS `xbt_config` (
+  `name` varchar(255) CHARACTER SET latin1 NOT NULL,
+  `value` varchar(255) CHARACTER SET latin1 NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `xbt_config`
+--
+
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `xbt_deny_from_hosts`
+--
+
+CREATE TABLE IF NOT EXISTS `xbt_deny_from_hosts` (
+  `begin` int(10) unsigned NOT NULL,
+  `end` int(10) unsigned NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `xbt_files`
+--
+
+CREATE TABLE IF NOT EXISTS `xbt_files` (
+`fid` int(11) NOT NULL,
+  `info_hash` binary(20) NOT NULL,
+  `leechers` int(11) NOT NULL DEFAULT '0',
+  `seeders` int(11) NOT NULL DEFAULT '0',
+  `completed` int(11) NOT NULL DEFAULT '0',
+  `flags` int(11) NOT NULL DEFAULT '0',
+  `mtime` int(11) NOT NULL,
+  `ctime` int(11) NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `xbt_files`
+--
+
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `xbt_files_users`
+--
+
+CREATE TABLE IF NOT EXISTS `xbt_files_users` (
+  `fid` int(11) NOT NULL,
+  `uid` int(11) NOT NULL,
+  `active` tinyint(4) NOT NULL,
+  `announced` int(11) NOT NULL,
+  `completed` int(11) NOT NULL,
+  `downloaded` bigint(20) unsigned NOT NULL,
+  `left` bigint(20) unsigned NOT NULL,
+  `uploaded` bigint(20) unsigned NOT NULL,
+  `mtime` int(11) NOT NULL,
+  `down_rate` int(10) unsigned NOT NULL,
+  `up_rate` int(10) unsigned NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `xbt_files_users`
+--
+
+
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `xbt_scrape_log`
+--
+
+CREATE TABLE IF NOT EXISTS `xbt_scrape_log` (
+`id` int(11) NOT NULL,
+  `ipa` int(10) unsigned NOT NULL,
+  `info_hash` binary(20) DEFAULT NULL,
+  `uid` int(11) NOT NULL,
+  `mtime` int(11) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `xbt_users`
+--
+
+CREATE TABLE IF NOT EXISTS `xbt_users` (
+`uid` int(11) NOT NULL,
+  `torrent_pass_version` int(11) NOT NULL DEFAULT '0',
+  `downloaded` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `uploaded` bigint(20) unsigned NOT NULL DEFAULT '0',
+  `torrent_pass` char(32) CHARACTER SET latin1 NOT NULL,
+  `torrent_pass_secret` bigint(20) unsigned NOT NULL
+) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8;
+
+--
+-- Contenu de la table `xbt_users`
+--
+
+
+
+--
+-- Index pour les tables exportées
+--
+
+--
+-- Index pour la table `blog_cats`
+--
+ALTER TABLE `blog_cats`
+ ADD PRIMARY KEY (`catID`);
+
+--
+-- Index pour la table `blog_licences`
+--
+ALTER TABLE `blog_licences`
+ ADD PRIMARY KEY (`licenceID`);
+
+--
+-- Index pour la table `blog_logs`
+--
+ALTER TABLE `blog_logs`
+ ADD PRIMARY KEY (`log_id`);
+
+--
+-- Index pour la table `blog_members`
+--
+ALTER TABLE `blog_members`
+ ADD PRIMARY KEY (`memberID`);
+
+--
+-- Index pour la table `blog_messages`
+--
+ALTER TABLE `blog_messages`
+ ADD PRIMARY KEY (`messages_id`);
+
+--
+-- Index pour la table `blog_posts_seo`
+--
+ALTER TABLE `blog_posts_seo`
+ ADD PRIMARY KEY (`postID`);
+
+--
+-- Index pour la table `blog_post_cats`
+--
+ALTER TABLE `blog_post_cats`
+ ADD PRIMARY KEY (`id`);
+
+--
+-- Index pour la table `blog_post_licences`
+--
+ALTER TABLE `blog_post_licences`
+ ADD PRIMARY KEY (`id_BPL`);
+
+--
+-- Index pour la table `connectes`
+--
+ALTER TABLE `connectes`
+ ADD PRIMARY KEY (`ip`);
+
+--
+-- Index pour la table `xbt_announce_log`
+--
+ALTER TABLE `xbt_announce_log`
+ ADD PRIMARY KEY (`id`);
+
+--
+-- Index pour la table `xbt_config`
+--
+ALTER TABLE `xbt_config`
+ ADD UNIQUE KEY `name` (`name`);
+
+--
+-- Index pour la table `xbt_files`
+--
+ALTER TABLE `xbt_files`
+ ADD PRIMARY KEY (`fid`), ADD UNIQUE KEY `info_hash` (`info_hash`);
+
+--
+-- Index pour la table `xbt_files_users`
+--
+ALTER TABLE `xbt_files_users`
+ ADD UNIQUE KEY `fid` (`fid`,`uid`), ADD KEY `uid` (`uid`);
+
+--
+-- Index pour la table `xbt_scrape_log`
+--
+ALTER TABLE `xbt_scrape_log`
+ ADD PRIMARY KEY (`id`);
+
+--
+-- Index pour la table `xbt_users`
+--
+ALTER TABLE `xbt_users`
+ ADD PRIMARY KEY (`uid`);
+
+--
+-- AUTO_INCREMENT pour les tables exportées
+--
+
+--
+-- AUTO_INCREMENT pour la table `blog_cats`
+--
+ALTER TABLE `blog_cats`
+MODIFY `catID` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=43;
+--
+-- AUTO_INCREMENT pour la table `blog_licences`
+--
+ALTER TABLE `blog_licences`
+MODIFY `licenceID` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=26;
+--
+-- AUTO_INCREMENT pour la table `blog_logs`
+--
+ALTER TABLE `blog_logs`
+MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1891;
+--
+-- AUTO_INCREMENT pour la table `blog_members`
+--
+ALTER TABLE `blog_members`
+MODIFY `memberID` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=118;
+--
+-- AUTO_INCREMENT pour la table `blog_messages`
+--
+ALTER TABLE `blog_messages`
+MODIFY `messages_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=106;
+--
+-- AUTO_INCREMENT pour la table `blog_posts_seo`
+--
+ALTER TABLE `blog_posts_seo`
+MODIFY `postID` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=59;
+--
+-- AUTO_INCREMENT pour la table `blog_post_cats`
+--
+ALTER TABLE `blog_post_cats`
+MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=277;
+--
+-- AUTO_INCREMENT pour la table `blog_post_licences`
+--
+ALTER TABLE `blog_post_licences`
+MODIFY `id_BPL` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=391;
+--
+-- AUTO_INCREMENT pour la table `xbt_announce_log`
+--
+ALTER TABLE `xbt_announce_log`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=31148;
+--
+-- AUTO_INCREMENT pour la table `xbt_files`
+--
+ALTER TABLE `xbt_files`
+MODIFY `fid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=59;
+--
+-- AUTO_INCREMENT pour la table `xbt_scrape_log`
+--
+ALTER TABLE `xbt_scrape_log`
+MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
+--
+-- AUTO_INCREMENT pour la table `xbt_users`
+--
+ALTER TABLE `xbt_users`
+MODIFY `uid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=118;
+--
+-- Contraintes pour les tables exportées
+--
+
+--
+-- Contraintes pour la table `xbt_files_users`
+--
+ALTER TABLE `xbt_files_users`
+ADD CONSTRAINT `xbt_files_users_ibfk_1` FOREIGN KEY (`fid`) REFERENCES `xbt_files` (`fid`) ON DELETE CASCADE,
+ADD CONSTRAINT `xbt_files_users_ibfk_2` FOREIGN KEY (`fid`) REFERENCES `xbt_files` (`fid`) ON DELETE CASCADE,
+ADD CONSTRAINT `xbt_files_users_ibfk_3` FOREIGN KEY (`fid`) REFERENCES `xbt_files` (`fid`) ON DELETE CASCADE,
+ADD CONSTRAINT `xbt_files_users_ibfk_4` FOREIGN KEY (`uid`) REFERENCES `xbt_users` (`uid`) ON DELETE CASCADE,
+ADD CONSTRAINT `xbt_files_users_ibfk_5` FOREIGN KEY (`uid`) REFERENCES `xbt_users` (`uid`) ON DELETE CASCADE,
+ADD CONSTRAINT `xbt_files_users_ibfk_6` FOREIGN KEY (`uid`) REFERENCES `xbt_users` (`uid`) ON DELETE CASCADE,
+ADD CONSTRAINT `xbt_files_users_ibfk_7` FOREIGN KEY (`uid`) REFERENCES `xbt_users` (`uid`) ON DELETE CASCADE;
+
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-- 
cgit v1.2.1

