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