Nos partenaires et nous-mêmes utilisons différentes technologies, telles que les cookies, pour personnaliser les contenus et les publicités, proposer des fonctionnalités sur les réseaux sociaux et analyser le trafic. Merci de cliquer sur le bouton ci-dessous pour donner votre accord. Vous pouvez changer d’avis et modifier vos choix à tout moment. Informations RGPD
/* Navicat MySQL Data Transfer Source Server : vps-ssd Source Server Version : 50544 Source Host : 149.202.54.194:3306 Source Database : kubiks_site Target Server Type : MYSQL Target Server Version : 50544 File Encoding : 65001 Date: 2015-09-11 14:44:40 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `api_configurations` -- ---------------------------- DROP TABLE IF EXISTS `api_configurations`; CREATE TABLE `api_configurations` ( `id` int(20) NOT NULL AUTO_INCREMENT, `skins` int(1) NOT NULL DEFAULT '0', `skin_filename` varchar(150) NOT NULL, `skin_free` int(1) NOT NULL DEFAULT '0', `capes` int(1) NOT NULL DEFAULT '0', `cape_filename` varchar(150) NOT NULL, `cape_free` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of api_configurations -- ---------------------------- INSERT INTO `api_configurations` VALUES ('1', '1', 'skins/{PLAYER}_skin', '1', '1', 'skins/capes/{PLAYER}_cape', '0'); -- ---------------------------- -- Table structure for `comments` -- ---------------------------- DROP TABLE IF EXISTS `comments`; CREATE TABLE `comments` ( `id` int(20) NOT NULL AUTO_INCREMENT, `content` text NOT NULL, `created` datetime NOT NULL, `author` varchar(255) NOT NULL, `news_id` int(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of comments -- ---------------------------- -- ---------------------------- -- Table structure for `configurations` -- ---------------------------- DROP TABLE IF EXISTS `configurations`; CREATE TABLE `configurations` ( `id` int(20) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `lang` varchar(5) NOT NULL, `theme` varchar(50) NOT NULL DEFAULT 'default', `layout` varchar(255) NOT NULL, `maintenance` text NOT NULL, `money_name_singular` varchar(255) NOT NULL, `money_name_plural` varchar(255) NOT NULL, `server_state` int(1) NOT NULL, `server_secretkey` varchar(50) NOT NULL, `server_timeout` float NOT NULL, `version` varchar(50) NOT NULL, `skype` text NOT NULL, `youtube` text NOT NULL, `twitter` text NOT NULL, `facebook` text NOT NULL, `mineguard` varchar(5) NOT NULL, `banner_server` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of configurations -- ---------------------------- -- ---------------------------- -- Table structure for `histories` -- ---------------------------- DROP TABLE IF EXISTS `histories`; CREATE TABLE `histories` ( `id` int(20) NOT NULL AUTO_INCREMENT, `action` varchar(255) NOT NULL, `category` varchar(50) NOT NULL, `created` datetime NOT NULL, `author` varchar(255) NOT NULL, `other` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of histories -- ---------------------------- -- ---------------------------- -- Table structure for `likes` -- ---------------------------- DROP TABLE IF EXISTS `likes`; CREATE TABLE `likes` ( `id` int(20) NOT NULL AUTO_INCREMENT, `news_id` int(20) NOT NULL, `author` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of likes -- ---------------------------- -- ---------------------------- -- Table structure for `lostpasswords` -- ---------------------------- DROP TABLE IF EXISTS `lostpasswords`; CREATE TABLE `lostpasswords` ( `id` int(20) NOT NULL AUTO_INCREMENT, `email` varchar(50) NOT NULL, `key` varchar(10) NOT NULL, `created` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of lostpasswords -- ---------------------------- -- ---------------------------- -- Table structure for `navbars` -- ---------------------------- DROP TABLE IF EXISTS `navbars`; CREATE TABLE `navbars` ( `id` int(20) NOT NULL AUTO_INCREMENT, `order` int(2) NOT NULL, `name` varchar(50) NOT NULL, `type` int(1) NOT NULL DEFAULT '1', `url` varchar(250) NOT NULL, `submenu` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of navbars -- ---------------------------- -- ---------------------------- -- Table structure for `news` -- ---------------------------- DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `id` int(20) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, `content` text NOT NULL, `author` varchar(255) NOT NULL, `created` datetime NOT NULL, `updated` datetime NOT NULL, `comments` int(20) NOT NULL DEFAULT '0', `like` int(20) NOT NULL DEFAULT '0', `img` varchar(255) NOT NULL, `slug` varchar(150) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of news -- ---------------------------- -- ---------------------------- -- Table structure for `pages` -- ---------------------------- DROP TABLE IF EXISTS `pages`; CREATE TABLE `pages` ( `id` int(20) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `content` longtext NOT NULL, `slug` varchar(150) NOT NULL, `author` varchar(250) NOT NULL, `created` datetime NOT NULL, `updated` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of pages -- ---------------------------- -- ---------------------------- -- Table structure for `permissions` -- ---------------------------- DROP TABLE IF EXISTS `permissions`; CREATE TABLE `permissions` ( `id` int(20) NOT NULL AUTO_INCREMENT, `rank` int(1) NOT NULL, `permissions` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of permissions -- ---------------------------- INSERT INTO `permissions` VALUES ('1', '0', 'a:3:{i:0;s:12:\"COMMENT_NEWS\";i:1;s:9:\"LIKE_NEWS\";i:2;s:18:\"DELETE_HIS_COMMENT\";}'); INSERT INTO `permissions` VALUES ('2', '2', 'a:3:{i:0;s:12:\"COMMENT_NEWS\";i:1;s:9:\"LIKE_NEWS\";i:2;s:18:\"DELETE_HIS_COMMENT\";}'); -- ---------------------------- -- Table structure for `plugins` -- ---------------------------- DROP TABLE IF EXISTS `plugins`; CREATE TABLE `plugins` ( `id` int(20) NOT NULL AUTO_INCREMENT, `plugin_id` int(20) NOT NULL, `created` datetime NOT NULL, `name` varchar(50) NOT NULL, `author` varchar(50) NOT NULL, `version` varchar(20) NOT NULL, `tables` text NOT NULL, `state` int(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of plugins -- ---------------------------- -- ---------------------------- -- Table structure for `servers` -- ---------------------------- DROP TABLE IF EXISTS `servers`; CREATE TABLE `servers` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL DEFAULT '', `ip` varchar(20) NOT NULL DEFAULT '', `port` int(5) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of servers -- ---------------------------- -- ---------------------------- -- Table structure for `sliders` -- ---------------------------- DROP TABLE IF EXISTS `sliders`; CREATE TABLE `sliders` ( `id` int(20) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, `subtitle` text NOT NULL, `url_img` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of sliders -- ---------------------------- -- ---------------------------- -- Table structure for `users` -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(20) NOT NULL AUTO_INCREMENT, `pseudo` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `session` varchar(255) DEFAULT NULL, `rank` int(1) NOT NULL, `money` int(20) NOT NULL DEFAULT '0', `vote` int(3) NOT NULL DEFAULT '0', `ip` varchar(255) NOT NULL, `allowed_ip` text NOT NULL, `skin` int(1) NOT NULL DEFAULT '0', `cape` int(1) NOT NULL DEFAULT '0', `created` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of users -- ---------------------------- -- ---------------------------- -- Table structure for `visits` -- ---------------------------- DROP TABLE IF EXISTS `visits`; CREATE TABLE `visits` ( `id` int(20) NOT NULL AUTO_INCREMENT, `ip` varchar(20) NOT NULL, `created` datetime NOT NULL, `referer` text NOT NULL, `lang` varchar(4) NOT NULL, `navigator` varchar(255) NOT NULL, `page` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of visits -- ----------------------------