dump sql.sql

À propos

Type de fichier

Fichier SQL de 9 Ko (text/plain)

Confidentialité

Fichier public, envoyé le 11 septembre 2015 à 14:45, depuis l'adresse IP 85.201.x.x (Belgique)

Sécurité

Ne contient aucun Virus ou Malware connus - Dernière vérification: 3 jours

Statistiques

La présente page de téléchargement a été vue 509 fois depuis l'envoi du fichier

Page de téléchargement

https://www.petit-fichier.fr/2015/09/11/dump-sql/   Copier

Aperçu du fichier

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

Partager le fichier

Télécharger dump_sql.sql