Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL dump 10.13 Distrib 5.5.37, for debian-linux-gnu (x86_64)
- --
- -- Host: localhost Database: minecraft
- -- ------------------------------------------------------
- -- Server version 5.5.37-0ubuntu0.14.04.1
- /*!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 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `heroes_binds`
- --
- DROP TABLE IF EXISTS `heroes_binds`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `heroes_binds` (
- `id_binds` INT(11) NOT NULL AUTO_INCREMENT,
- `bind_hero_id` INT(11) NOT NULL,
- `material` VARCHAR(45) NOT NULL,
- `bind` VARCHAR(280) NOT NULL,
- PRIMARY KEY (`id_binds`),
- UNIQUE KEY `uq_binds_hero_material` (`bind_hero_id`,`material`),
- KEY `fk_heroes_binds_1_idx` (`bind_hero_id`),
- CONSTRAINT `fk_heroes_binds_1` FOREIGN KEY (`bind_hero_id`) REFERENCES `heroes_hero` (`hero_id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Binding items to skill activations';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `heroes_binds`
- --
- LOCK TABLES `heroes_binds` WRITE;
- /*!40000 ALTER TABLE `heroes_binds` DISABLE KEYS */;
- INSERT INTO `heroes_binds` VALUES (1,3,'RED_ROSE','AssassinsBlade');
- /*!40000 ALTER TABLE `heroes_binds` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `heroes_cooldowns`
- --
- DROP TABLE IF EXISTS `heroes_cooldowns`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `heroes_cooldowns` (
- `id_cooldowns` INT(11) NOT NULL AUTO_INCREMENT,
- `cd_hero_id` INT(11) NOT NULL,
- `skill_name` VARCHAR(45) NOT NULL,
- `expire_time` datetime NOT NULL,
- PRIMARY KEY (`id_cooldowns`),
- UNIQUE KEY `uq_cooldowns_hero_skill` (`cd_hero_id`,`skill_name`),
- KEY `id_hero_idx` (`cd_hero_id`),
- CONSTRAINT `fk_heroes_cooldowns_1` FOREIGN KEY (`cd_hero_id`) REFERENCES `heroes_hero` (`hero_id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COMMENT='Cooldowns for skills';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `heroes_cooldowns`
- --
- LOCK TABLES `heroes_cooldowns` WRITE;
- /*!40000 ALTER TABLE `heroes_cooldowns` DISABLE KEYS */;
- INSERT INTO `heroes_cooldowns` VALUES (1,3,'class-change','2014-05-02 15:49:56');
- /*!40000 ALTER TABLE `heroes_cooldowns` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `heroes_experience`
- --
- DROP TABLE IF EXISTS `heroes_experience`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `heroes_experience` (
- `id_experience` INT(11) NOT NULL AUTO_INCREMENT,
- `exp_hero_id` INT(11) NOT NULL,
- `class_name` VARCHAR(45) NOT NULL,
- `exp` DOUBLE NOT NULL,
- PRIMARY KEY (`id_experience`),
- UNIQUE KEY `uq_exp_hero_class` (`exp_hero_id`,`class_name`),
- KEY `fk_heroes_experience_1_idx` (`exp_hero_id`),
- CONSTRAINT `fk_heroes_experience_1` FOREIGN KEY (`exp_hero_id`) REFERENCES `heroes_hero` (`hero_id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COMMENT='Experience for each class';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `heroes_experience`
- --
- LOCK TABLES `heroes_experience` WRITE;
- /*!40000 ALTER TABLE `heroes_experience` DISABLE KEYS */;
- INSERT INTO `heroes_experience` VALUES (1,3,'Citizen',0),(2,3,'Rogue',100000);
- /*!40000 ALTER TABLE `heroes_experience` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `heroes_hero`
- --
- DROP TABLE IF EXISTS `heroes_hero`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `heroes_hero` (
- `hero_id` INT(11) NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(45) NOT NULL,
- `uuid` BINARY(16) NOT NULL,
- `primary_class` VARCHAR(45) NOT NULL,
- `secondary_class` VARCHAR(45) DEFAULT NULL,
- `mana` INT(11) NOT NULL,
- `is_verbose` tinyint(1) NOT NULL,
- PRIMARY KEY (`hero_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COMMENT='Main data about each hero';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `heroes_hero`
- --
- LOCK TABLES `heroes_hero` WRITE;
- /*!40000 ALTER TABLE `heroes_hero` DISABLE KEYS */;
- INSERT INTO `heroes_hero` VALUES (3,'Riking','p��F��H���֍�5','Rogue',NULL,40,1);
- /*!40000 ALTER TABLE `heroes_hero` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `heroes_masteries`
- --
- DROP TABLE IF EXISTS `heroes_masteries`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `heroes_masteries` (
- `id_masteries` INT(11) NOT NULL AUTO_INCREMENT,
- `mast_hero_id` INT(11) NOT NULL,
- `class_name` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`id_masteries`),
- UNIQUE KEY `uq_masteries_hero_class` (`mast_hero_id`,`class_name`),
- KEY `fk_heroes_masteries_1_idx` (`mast_hero_id`),
- CONSTRAINT `fk_heroes_masteries_1` FOREIGN KEY (`mast_hero_id`) REFERENCES `heroes_hero` (`hero_id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of classes mastered';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `heroes_masteries`
- --
- LOCK TABLES `heroes_masteries` WRITE;
- /*!40000 ALTER TABLE `heroes_masteries` DISABLE KEYS */;
- /*!40000 ALTER TABLE `heroes_masteries` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `heroes_meta`
- --
- DROP TABLE IF EXISTS `heroes_meta`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `heroes_meta` (
- `meta_id` INT(11) NOT NULL AUTO_INCREMENT,
- `database_version` INT(11) DEFAULT NULL,
- PRIMARY KEY (`meta_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Versioning information about the database';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `heroes_meta`
- --
- LOCK TABLES `heroes_meta` WRITE;
- /*!40000 ALTER TABLE `heroes_meta` DISABLE KEYS */;
- INSERT INTO `heroes_meta` VALUES (1,3);
- /*!40000 ALTER TABLE `heroes_meta` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `heroes_skill_settings`
- --
- DROP TABLE IF EXISTS `heroes_skill_settings`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `heroes_skill_settings` (
- `skill_setting_id` INT(11) NOT NULL AUTO_INCREMENT,
- `set_hero_id` INT(11) NOT NULL,
- `skill_name` VARCHAR(45) NOT NULL,
- `key_name` VARCHAR(60) NOT NULL,
- `setting_value` BLOB NOT NULL,
- PRIMARY KEY (`skill_setting_id`),
- UNIQUE KEY `uq_skillsettings_hero_skill_key` (`set_hero_id`,`skill_name`,`key_name`),
- KEY `fk_heroes_skill_settings_1_idx` (`set_hero_id`),
- CONSTRAINT `fk_heroes_skill_settings_1` FOREIGN KEY (`set_hero_id`) REFERENCES `heroes_hero` (`hero_id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COMMENT='Arbitrary data set by skills';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `heroes_skill_settings`
- --
- LOCK TABLES `heroes_skill_settings` WRITE;
- /*!40000 ALTER TABLE `heroes_skill_settings` DISABLE KEYS */;
- INSERT INTO `heroes_skill_settings` VALUES (1,3,'recall','world','��\0t\0world'),(2,3,'recall','x','��\0sr\0java.lang.Double���J)k�\0D\0valuexr\0java.lang.Number���
- ���\0\0xp@{D���\0\0'),(3,3,'recall','y','��\0sr\0java.lang.Double���J)k�\0D\0valuexr\0java.lang.Number���
- ���\0\0xp@Q\0\0\0\0\0\0'),(4,3,'recall','z','��\0sr\0java.lang.Double���J)k�\0D\0valuexr\0java.lang.Number���
- ���\0\0xp@~<�^��'),(5,3,'recall','yaw','��\0sr\0java.lang.Double���J)k�\0D\0valuexr\0java.lang.Number���
- ���\0\0xp@D,�\0\0\0\0'),(6,3,'recall','pitch','��\0sr\0java.lang.Double���J)k�\0D\0valuexr\0java.lang.Number���
- ���\0\0xp@5�\0\0\0\0');
- /*!40000 ALTER TABLE `heroes_skill_settings` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `heroes_suppressed_skills`
- --
- DROP TABLE IF EXISTS `heroes_suppressed_skills`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `heroes_suppressed_skills` (
- `id_suppressed` INT(11) NOT NULL AUTO_INCREMENT,
- `sup_hero_id` INT(11) NOT NULL,
- `skill_name` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`id_suppressed`),
- UNIQUE KEY `uq_suppressed_hero_skill` (`sup_hero_id`,`skill_name`),
- KEY `fk_heroes_suppressed_skills_1_idx` (`sup_hero_id`),
- CONSTRAINT `fk_heroes_suppressed_skills_1` FOREIGN KEY (`sup_hero_id`) REFERENCES `heroes_hero` (`hero_id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Skills marked as suppressed';
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `heroes_suppressed_skills`
- --
- LOCK TABLES `heroes_suppressed_skills` WRITE;
- /*!40000 ALTER TABLE `heroes_suppressed_skills` DISABLE KEYS */;
- INSERT INTO `heroes_suppressed_skills` VALUES (1,3,'Jump');
- /*!40000 ALTER TABLE `heroes_suppressed_skills` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!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 */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2014-05-02 15:48:32
- kane@kane-HP-ENVY-TS-15-Notebook-PC:~/projects/heroes$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement