Advertisement
riking

Untitled

May 2nd, 2014
546
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 10.83 KB | None | 0 0
  1. -- MySQL dump 10.13  Distrib 5.5.37, for debian-linux-gnu (x86_64)
  2. --
  3. -- Host: localhost    Database: minecraft
  4. -- ------------------------------------------------------
  5. -- Server version   5.5.37-0ubuntu0.14.04.1
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12. /*!40103 SET TIME_ZONE='+00:00' */;
  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17.  
  18. --
  19. -- Table structure for table `heroes_binds`
  20. --
  21.  
  22. DROP TABLE IF EXISTS `heroes_binds`;
  23. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  24. /*!40101 SET character_set_client = utf8 */;
  25. CREATE TABLE `heroes_binds` (
  26.   `id_binds` INT(11) NOT NULL AUTO_INCREMENT,
  27.   `bind_hero_id` INT(11) NOT NULL,
  28.   `material` VARCHAR(45) NOT NULL,
  29.   `bind` VARCHAR(280) NOT NULL,
  30.   PRIMARY KEY (`id_binds`),
  31.   UNIQUE KEY `uq_binds_hero_material` (`bind_hero_id`,`material`),
  32.   KEY `fk_heroes_binds_1_idx` (`bind_hero_id`),
  33.   CONSTRAINT `fk_heroes_binds_1` FOREIGN KEY (`bind_hero_id`) REFERENCES `heroes_hero` (`hero_id`) ON DELETE CASCADE ON UPDATE CASCADE
  34. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Binding items to skill activations';
  35. /*!40101 SET character_set_client = @saved_cs_client */;
  36.  
  37. --
  38. -- Dumping data for table `heroes_binds`
  39. --
  40.  
  41. LOCK TABLES `heroes_binds` WRITE;
  42. /*!40000 ALTER TABLE `heroes_binds` DISABLE KEYS */;
  43. INSERT INTO `heroes_binds` VALUES (1,3,'RED_ROSE','AssassinsBlade');
  44. /*!40000 ALTER TABLE `heroes_binds` ENABLE KEYS */;
  45. UNLOCK TABLES;
  46.  
  47. --
  48. -- Table structure for table `heroes_cooldowns`
  49. --
  50.  
  51. DROP TABLE IF EXISTS `heroes_cooldowns`;
  52. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  53. /*!40101 SET character_set_client = utf8 */;
  54. CREATE TABLE `heroes_cooldowns` (
  55.   `id_cooldowns` INT(11) NOT NULL AUTO_INCREMENT,
  56.   `cd_hero_id` INT(11) NOT NULL,
  57.   `skill_name` VARCHAR(45) NOT NULL,
  58.   `expire_time` datetime NOT NULL,
  59.   PRIMARY KEY (`id_cooldowns`),
  60.   UNIQUE KEY `uq_cooldowns_hero_skill` (`cd_hero_id`,`skill_name`),
  61.   KEY `id_hero_idx` (`cd_hero_id`),
  62.   CONSTRAINT `fk_heroes_cooldowns_1` FOREIGN KEY (`cd_hero_id`) REFERENCES `heroes_hero` (`hero_id`) ON DELETE CASCADE ON UPDATE CASCADE
  63. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COMMENT='Cooldowns for skills';
  64. /*!40101 SET character_set_client = @saved_cs_client */;
  65.  
  66. --
  67. -- Dumping data for table `heroes_cooldowns`
  68. --
  69.  
  70. LOCK TABLES `heroes_cooldowns` WRITE;
  71. /*!40000 ALTER TABLE `heroes_cooldowns` DISABLE KEYS */;
  72. INSERT INTO `heroes_cooldowns` VALUES (1,3,'class-change','2014-05-02 15:49:56');
  73. /*!40000 ALTER TABLE `heroes_cooldowns` ENABLE KEYS */;
  74. UNLOCK TABLES;
  75.  
  76. --
  77. -- Table structure for table `heroes_experience`
  78. --
  79.  
  80. DROP TABLE IF EXISTS `heroes_experience`;
  81. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  82. /*!40101 SET character_set_client = utf8 */;
  83. CREATE TABLE `heroes_experience` (
  84.   `id_experience` INT(11) NOT NULL AUTO_INCREMENT,
  85.   `exp_hero_id` INT(11) NOT NULL,
  86.   `class_name` VARCHAR(45) NOT NULL,
  87.   `exp` DOUBLE NOT NULL,
  88.   PRIMARY KEY (`id_experience`),
  89.   UNIQUE KEY `uq_exp_hero_class` (`exp_hero_id`,`class_name`),
  90.   KEY `fk_heroes_experience_1_idx` (`exp_hero_id`),
  91.   CONSTRAINT `fk_heroes_experience_1` FOREIGN KEY (`exp_hero_id`) REFERENCES `heroes_hero` (`hero_id`) ON DELETE CASCADE ON UPDATE CASCADE
  92. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COMMENT='Experience for each class';
  93. /*!40101 SET character_set_client = @saved_cs_client */;
  94.  
  95. --
  96. -- Dumping data for table `heroes_experience`
  97. --
  98.  
  99. LOCK TABLES `heroes_experience` WRITE;
  100. /*!40000 ALTER TABLE `heroes_experience` DISABLE KEYS */;
  101. INSERT INTO `heroes_experience` VALUES (1,3,'Citizen',0),(2,3,'Rogue',100000);
  102. /*!40000 ALTER TABLE `heroes_experience` ENABLE KEYS */;
  103. UNLOCK TABLES;
  104.  
  105. --
  106. -- Table structure for table `heroes_hero`
  107. --
  108.  
  109. DROP TABLE IF EXISTS `heroes_hero`;
  110. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  111. /*!40101 SET character_set_client = utf8 */;
  112. CREATE TABLE `heroes_hero` (
  113.   `hero_id` INT(11) NOT NULL AUTO_INCREMENT,
  114.   `name` VARCHAR(45) NOT NULL,
  115.   `uuid` BINARY(16) NOT NULL,
  116.   `primary_class` VARCHAR(45) NOT NULL,
  117.   `secondary_class` VARCHAR(45) DEFAULT NULL,
  118.   `mana` INT(11) NOT NULL,
  119.   `is_verbose` tinyint(1) NOT NULL,
  120.   PRIMARY KEY (`hero_id`)
  121. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COMMENT='Main data about each hero';
  122. /*!40101 SET character_set_client = @saved_cs_client */;
  123.  
  124. --
  125. -- Dumping data for table `heroes_hero`
  126. --
  127.  
  128. LOCK TABLES `heroes_hero` WRITE;
  129. /*!40000 ALTER TABLE `heroes_hero` DISABLE KEYS */;
  130. INSERT INTO `heroes_hero` VALUES (3,'Riking','p��F��H���֍�5','Rogue',NULL,40,1);
  131. /*!40000 ALTER TABLE `heroes_hero` ENABLE KEYS */;
  132. UNLOCK TABLES;
  133.  
  134. --
  135. -- Table structure for table `heroes_masteries`
  136. --
  137.  
  138. DROP TABLE IF EXISTS `heroes_masteries`;
  139. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  140. /*!40101 SET character_set_client = utf8 */;
  141. CREATE TABLE `heroes_masteries` (
  142.   `id_masteries` INT(11) NOT NULL AUTO_INCREMENT,
  143.   `mast_hero_id` INT(11) NOT NULL,
  144.   `class_name` VARCHAR(45) NOT NULL,
  145.   PRIMARY KEY (`id_masteries`),
  146.   UNIQUE KEY `uq_masteries_hero_class` (`mast_hero_id`,`class_name`),
  147.   KEY `fk_heroes_masteries_1_idx` (`mast_hero_id`),
  148.   CONSTRAINT `fk_heroes_masteries_1` FOREIGN KEY (`mast_hero_id`) REFERENCES `heroes_hero` (`hero_id`) ON DELETE CASCADE ON UPDATE CASCADE
  149. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of classes mastered';
  150. /*!40101 SET character_set_client = @saved_cs_client */;
  151.  
  152. --
  153. -- Dumping data for table `heroes_masteries`
  154. --
  155.  
  156. LOCK TABLES `heroes_masteries` WRITE;
  157. /*!40000 ALTER TABLE `heroes_masteries` DISABLE KEYS */;
  158. /*!40000 ALTER TABLE `heroes_masteries` ENABLE KEYS */;
  159. UNLOCK TABLES;
  160.  
  161. --
  162. -- Table structure for table `heroes_meta`
  163. --
  164.  
  165. DROP TABLE IF EXISTS `heroes_meta`;
  166. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  167. /*!40101 SET character_set_client = utf8 */;
  168. CREATE TABLE `heroes_meta` (
  169.   `meta_id` INT(11) NOT NULL AUTO_INCREMENT,
  170.   `database_version` INT(11) DEFAULT NULL,
  171.   PRIMARY KEY (`meta_id`)
  172. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Versioning information about the database';
  173. /*!40101 SET character_set_client = @saved_cs_client */;
  174.  
  175. --
  176. -- Dumping data for table `heroes_meta`
  177. --
  178.  
  179. LOCK TABLES `heroes_meta` WRITE;
  180. /*!40000 ALTER TABLE `heroes_meta` DISABLE KEYS */;
  181. INSERT INTO `heroes_meta` VALUES (1,3);
  182. /*!40000 ALTER TABLE `heroes_meta` ENABLE KEYS */;
  183. UNLOCK TABLES;
  184.  
  185. --
  186. -- Table structure for table `heroes_skill_settings`
  187. --
  188.  
  189. DROP TABLE IF EXISTS `heroes_skill_settings`;
  190. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  191. /*!40101 SET character_set_client = utf8 */;
  192. CREATE TABLE `heroes_skill_settings` (
  193.   `skill_setting_id` INT(11) NOT NULL AUTO_INCREMENT,
  194.   `set_hero_id` INT(11) NOT NULL,
  195.   `skill_name` VARCHAR(45) NOT NULL,
  196.   `key_name` VARCHAR(60) NOT NULL,
  197.   `setting_value` BLOB NOT NULL,
  198.   PRIMARY KEY (`skill_setting_id`),
  199.   UNIQUE KEY `uq_skillsettings_hero_skill_key` (`set_hero_id`,`skill_name`,`key_name`),
  200.   KEY `fk_heroes_skill_settings_1_idx` (`set_hero_id`),
  201.   CONSTRAINT `fk_heroes_skill_settings_1` FOREIGN KEY (`set_hero_id`) REFERENCES `heroes_hero` (`hero_id`) ON DELETE CASCADE ON UPDATE CASCADE
  202. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COMMENT='Arbitrary data set by skills';
  203. /*!40101 SET character_set_client = @saved_cs_client */;
  204.  
  205. --
  206. -- Dumping data for table `heroes_skill_settings`
  207. --
  208.  
  209. LOCK TABLES `heroes_skill_settings` WRITE;
  210. /*!40000 ALTER TABLE `heroes_skill_settings` DISABLE KEYS */;
  211. 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���
  212.                                  ���\0\0xp@{D���\0\0'),(3,3,'recall','y','��\0sr\0java.lang.Double���J)k�\0D\0valuexr\0java.lang.Number���
  213.          ���\0\0xp@Q\0\0\0\0\0\0'),(4,3,'recall','z','��\0sr\0java.lang.Double���J)k�\0D\0valuexr\0java.lang.Number���
  214.                                                                                                                              ���\0\0xp@~<�^��'),(5,3,'recall','yaw','��\0sr\0java.lang.Double���J)k�\0D\0valuexr\0java.lang.Number���
  215.                                                                                                     ���\0\0xp@D,�\0\0\0\0'),(6,3,'recall','pitch','��\0sr\0java.lang.Double���J)k�\0D\0valuexr\0java.lang.Number���
  216.                                                                                   ���\0\0xp@5�\0\0\0\0');
  217. /*!40000 ALTER TABLE `heroes_skill_settings` ENABLE KEYS */;
  218. UNLOCK TABLES;
  219.  
  220. --
  221. -- Table structure for table `heroes_suppressed_skills`
  222. --
  223.  
  224. DROP TABLE IF EXISTS `heroes_suppressed_skills`;
  225. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  226. /*!40101 SET character_set_client = utf8 */;
  227. CREATE TABLE `heroes_suppressed_skills` (
  228.   `id_suppressed` INT(11) NOT NULL AUTO_INCREMENT,
  229.   `sup_hero_id` INT(11) NOT NULL,
  230.   `skill_name` VARCHAR(45) NOT NULL,
  231.   PRIMARY KEY (`id_suppressed`),
  232.   UNIQUE KEY `uq_suppressed_hero_skill` (`sup_hero_id`,`skill_name`),
  233.   KEY `fk_heroes_suppressed_skills_1_idx` (`sup_hero_id`),
  234.   CONSTRAINT `fk_heroes_suppressed_skills_1` FOREIGN KEY (`sup_hero_id`) REFERENCES `heroes_hero` (`hero_id`) ON DELETE CASCADE ON UPDATE CASCADE
  235. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Skills marked as suppressed';
  236. /*!40101 SET character_set_client = @saved_cs_client */;
  237.  
  238. --
  239. -- Dumping data for table `heroes_suppressed_skills`
  240. --
  241.  
  242. LOCK TABLES `heroes_suppressed_skills` WRITE;
  243. /*!40000 ALTER TABLE `heroes_suppressed_skills` DISABLE KEYS */;
  244. INSERT INTO `heroes_suppressed_skills` VALUES (1,3,'Jump');
  245. /*!40000 ALTER TABLE `heroes_suppressed_skills` ENABLE KEYS */;
  246. UNLOCK TABLES;
  247. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  248.  
  249. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  250. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  251. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  252. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  253. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  254. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  255. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  256.  
  257. -- Dump completed on 2014-05-02 15:48:32
  258. kane@kane-HP-ENVY-TS-15-Notebook-PC:~/projects/heroes$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement