Emistry

SQL - Job Changer DB

May 3rd, 2016
547
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.82 KB | None | 0 0
  1.  
  2. --
  3. -- Create table `e_jobchanger`
  4. --
  5.  
  6. CREATE TABLE IF NOT EXISTS `e_jobchanger` (
  7. `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  8. `job` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  9. `next_job` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  10. `base_lv` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
  11. `job_lv` SMALLINT(6) UNSIGNED NULL DEFAULT '0',
  12. `status` TINYINT(3) NOT NULL DEFAULT '1',
  13. PRIMARY KEY (`id`)
  14. ) ENGINE=MyISAM;
  15.  
  16. --
  17. -- Dumping data for table `e_jobchanger`
  18. --
  19.  
  20. INSERT INTO `e_jobchanger` (`job`, `next_job`, `base_lv`, `job_lv`, `status`) VALUES
  21. ( 0, 1, 0, 10, 1),
  22. ( 0, 2, 0, 10, 1),
  23. ( 0, 3, 0, 10, 1),
  24. ( 0, 4, 0, 10, 1),
  25. ( 0, 5, 0, 10, 1),
  26. ( 0, 6, 0, 10, 1),
  27. ( 0, 24, 0, 10, 1),
  28. ( 0, 25, 0, 10, 1),
  29. ( 0, 4046, 0, 10, 1),
  30. ( 0, 4023, 0, 10, 1),
  31. ( 4023, 4024, 0, 10, 1),
  32. ( 4023, 4025, 0, 10, 1),
  33. ( 4023, 4026, 0, 10, 1),
  34. ( 4023, 4027, 0, 10, 1),
  35. ( 4023, 4028, 0, 10, 1),
  36. ( 4023, 4029, 0, 10, 1),
  37. ( 1, 7, 0, 40, 1),
  38. ( 1, 14, 0, 40, 1),
  39. ( 2, 9, 0, 40, 1),
  40. ( 2, 16, 0, 40, 1),
  41. ( 3, 11, 0, 40, 1),
  42. ( 3, 19, 0, 40, 1),
  43. ( 3, 20, 0, 40, 1),
  44. ( 4, 8, 0, 40, 1),
  45. ( 4, 15, 0, 40, 1),
  46. ( 5, 10, 0, 40, 1),
  47. ( 5, 18, 0, 40, 1),
  48. ( 6, 12, 0, 40, 1),
  49. ( 6, 17, 0, 40, 1),
  50. ( 24, 4215, 0, 40, 1),
  51. ( 4046, 4047, 0, 40, 1),
  52. ( 4046, 4049, 0, 40, 1),
  53. ( 25, 4211, 0, 40, 1),
  54. ( 25, 4212, 0, 40, 1),
  55. ( 0, 23, 45, 10, 1),
  56. ( 4024, 4030, 0, 40, 1),
  57. ( 4024, 4037, 0, 40, 1),
  58. ( 4025, 4032, 0, 40, 1),
  59. ( 4025, 4039, 0, 40, 1),
  60. ( 4026, 4034, 0, 40, 1),
  61. ( 4026, 4042, 0, 40, 1),
  62. ( 4026, 4043, 0, 40, 1),
  63. ( 4027, 4031, 0, 40, 1),
  64. ( 4027, 4038, 0, 40, 1),
  65. ( 4028, 4033, 0, 40, 1),
  66. ( 4028, 4041, 0, 40, 1),
  67. ( 4029, 4035, 0, 40, 1),
  68. ( 4029, 4040, 0, 40, 1),
  69. ( 7, 4001, 99, 50, 1),
  70. ( 14, 4001, 99, 50, 1),
  71. ( 9, 4001, 99, 50, 1),
  72. ( 16, 4001, 99, 50, 1),
  73. ( 11, 4001, 99, 50, 1),
  74. ( 19, 4001, 99, 50, 1),
  75. ( 20, 4001, 99, 50, 1),
  76. ( 8, 4001, 99, 50, 1),
  77. ( 15, 4001, 99, 50, 1),
  78. ( 15, 4001, 99, 50, 1),
  79. ( 10, 4001, 99, 50, 1),
  80. ( 18, 4001, 99, 50, 1),
  81. ( 12, 4001, 99, 50, 1),
  82. ( 17, 4001, 99, 50, 1),
  83. ( 4001, 4002, 0, 10, 1),
  84. ( 4001, 4003, 0, 10, 1),
  85. ( 4001, 4004, 0, 10, 1),
  86. ( 4001, 4005, 0, 10, 1),
  87. ( 4001, 4006, 0, 10, 1),
  88. ( 4001, 4007, 0, 10, 1),
  89. ( 4002, 4008, 0, 50, 1),
  90. ( 4002, 4015, 0, 50, 1),
  91. ( 4003, 4010, 0, 50, 1),
  92. ( 4003, 4017, 0, 50, 1),
  93. ( 4004, 4012, 0, 50, 1),
  94. ( 4004, 4020, 0, 50, 1),
  95. ( 4004, 4021, 0, 50, 1),
  96. ( 4005, 4009, 0, 50, 1),
  97. ( 4005, 4016, 0, 50, 1),
  98. ( 4006, 4011, 0, 50, 1),
  99. ( 4006, 4019, 0, 50, 1),
  100. ( 4007, 4013, 0, 50, 1),
  101. ( 4007, 4018, 0, 50, 1),
  102. ( 4008, 4060, 99, 70, 1),
  103. ( 4015, 4073, 99, 70, 1),
  104. ( 4010, 4061, 99, 70, 1),
  105. ( 4017, 4074, 99, 70, 1),
  106. ( 4012, 4062, 99, 70, 1),
  107. ( 4020, 4075, 99, 70, 1),
  108. ( 4021, 4076, 99, 70, 1),
  109. ( 4009, 4063, 99, 70, 1),
  110. ( 4016, 4077, 99, 70, 1),
  111. ( 4011, 4064, 99, 70, 1),
  112. ( 4019, 4078, 99, 70, 1),
  113. ( 4013, 4065, 99, 70, 1),
  114. ( 4018, 4079, 99, 70, 1);
Add Comment
Please, Sign In to add comment