API tools faq
paste
nPhoenix

Pokémon AZ - DB TEST

nPhoenix
Jun 22nd, 2014
352
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 12.67 KB | None | 0 0
raw download clone embed print report
  1. DROP TABLE IF EXISTS `GAME`;
  2. CREATE TABLE IF NOT EXISTS `GAME` (
  3. `IP` VARCHAR(50) NOT NULL,
  4. `X` VARCHAR(50) NOT NULL,
  5. `Y` VARCHAR(50) NOT NULL,
  6. `POS` VARCHAR(50) NOT NULL,
  7. `NICK` VARCHAR(50) NOT NULL
  8. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
  9.  
  10. DROP TABLE IF EXISTS `PVP`;
  11. CREATE TABLE IF NOT EXISTS `PVP` (
  12. `PLAYER1` VARCHAR(50) NOT NULL,
  13. `PLAYER2` VARCHAR(50) NOT NULL,
  14. `POKES_PLAYER1` VARCHAR(50) NOT NULL,
  15. `POKES_PLAYER2` VARCHAR(50) NOT NULL,
  16. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
  17.  
  18. -- ----------------------------
  19. -- Table structure for `POKEMON_WILD`
  20. -- ----------------------------
  21. DROP TABLE IF EXISTS `POKEMON_WILD`;
  22. CREATE TABLE `POKEMON_WILD` (
  23.   `ID` SMALLINT(3) NOT NULL AUTO_INCREMENT,
  24.   `CONTINENTE` VARCHAR(50) NOT NULL,
  25.   `NOME` VARCHAR(30) NOT NULL,
  26.   `RARIDADE` tinyint(1) NOT NULL,
  27.   `EVOLUCAO` tinyint(1) NOT NULL,
  28.   `TIPO1` VARCHAR(8) NOT NULL,
  29.   `TIPO2` VARCHAR(8) NOT NULL,
  30.   `MAPA_TIPO` VARCHAR(12) NOT NULL,
  31.   `CHANCE_CAPTURA` VARCHAR(16) NOT NULL,
  32.   `CRESCIMENTO` VARCHAR(11) NOT NULL,
  33.   `EXP_BASE` INT(3) NOT NULL,
  34.   `ATAQUE_1` VARCHAR(16) NOT NULL,
  35.   `ATAQUE_2` VARCHAR(16) NOT NULL,
  36.   `ATAQUE_3` VARCHAR(16) NOT NULL,
  37.   `ATAQUE_4` VARCHAR(16) NOT NULL,
  38.   `ATAQUE_BASE` SMALLINT(3) NOT NULL,
  39.   `DEFESA_BASE` SMALLINT(3) NOT NULL,
  40.   `SP.ATAQUE_BASE` SMALLINT(3) NOT NULL,
  41.   `SP.DEFESA_BASE` SMALLINT(3) NOT NULL,
  42.   `VELOCIDADE_BASE` SMALLINT(3) NOT NULL,
  43.   `HP_BASE` SMALLINT(3) NOT NULL,
  44.   `MONSTER_DROP_VALUE_ATAQUE` tinyint(1) NOT NULL,
  45.   `MONSTER_DROP_VALUE_DEFESA` tinyint(1) NOT NULL,
  46.   `MONSTER_DROP_VALUE_SP.ATAQUE` tinyint(1) NOT NULL,
  47.   `MONSTER_DROP_VALUE_SP.DEFESA` tinyint(1) NOT NULL,
  48.   `MONSTER_DROP_VALUE_VELOCIDADE` tinyint(1) NOT NULL,
  49.   `MONSTER_DROP_VALUE_HP` tinyint(1) NOT NULL,
  50.   PRIMARY KEY  (`ID`)
  51. ) ENGINE=MyISAM AUTO_INCREMENT=659 DEFAULT CHARSET=latin1;
  52.  
  53. -- ----------------------------
  54. -- Records of POKEMON_WILD
  55. -- ----------------------------
  56. INSERT INTO `POKEMON_WILD` VALUES ('1', 'Kanto', 'Bulbasaur', '3', '1', 'Grass', 'Poison', 'Gras', '45', 'Medium Slow', '64', 'Tackle', 'Growl', '', '', '49', '49', '65', '65', '45', '45', '0', '0', '1', '0', '0', '0');
  57. INSERT INTO `POKEMON_WILD` VALUES ('2', 'Kanto', 'Ivysaur', '3', '2', 'Grass', 'Poison', '', '45', 'Medium Slow', '141', 'Tackle', 'Growl', 'Leech Seed', '', '62', '63', '80', '80', '60', '60', '0', '0', '1', '1', '0', '0');
  58. INSERT INTO `POKEMON_WILD` VALUES ('3', 'Kanto', 'Venusaur', '3', '3', 'Grass', 'Poison', '', '45', 'Medium Slow', '208', 'Tackle', 'Growl', 'Vine Whip', 'Leech Seed', '82', '83', '100', '100', '80', '80', '0', '0', '2', '1', '0', '0');
  59. INSERT INTO `POKEMON_WILD` VALUES ('4', 'Kanto', 'Charmander', '3', '1', 'Fire', '', 'Lavagrot', '45', 'Medium Slow', '65', 'Growl', 'Scratch', '', '', '52', '43', '60', '50', '65', '39', '0', '0', '0', '0', '1', '0');
  60. INSERT INTO `POKEMON_WILD` VALUES ('5', 'Kanto', 'Charmeleon', '3', '2', 'Fire', '', '', '45', 'Medium Slow', '142', 'Ember', 'Scratch', 'Growl', '', '64', '58', '80', '65', '80', '58', '0', '0', '1', '0', '1', '0');
  61. INSERT INTO `POKEMON_WILD` VALUES ('6', 'Kanto', 'Charizard', '3', '3', 'Fire', 'Flying', '', '45', 'Medium Slow', '209', 'Air Slash', 'Shadow Claw', 'Dragon Claw', 'Ember', '84', '78', '109', '85', '100', '78', '0', '0', '3', '0', '0', '0');
  62. INSERT INTO `POKEMON_WILD` VALUES ('7', 'Kanto', 'Squirtle', '3', '1', 'Water', '', 'Water', '45', 'Medium Slow', '66', 'Tackle', 'Tail Whip', '', '', '48', '65', '50', '64', '43', '44', '0', '1', '0', '0', '0', '0');
  63. INSERT INTO `POKEMON_WILD` VALUES ('8', 'Kanto', 'Wartortle', '3', '2', 'Water', '', '', '45', 'Medium Slow', '143', 'Bubble', 'Tail Whip', 'Tackle', '', '63', '80', '65', '80', '58', '59', '0', '1', '0', '1', '0', '0');
  64. INSERT INTO `POKEMON_WILD` VALUES ('9', 'Kanto', 'Blastoise', '3', '3', 'Water', '', '', '45', 'Medium Slow', '210', 'Tackle', 'Tail Whip', 'Flash Cannon', 'Bubble', '83', '100', '85', '105', '78', '79', '0', '0', '0', '3', '0', '0');
  65.  
  66. DROP TABLE IF EXISTS `FRAQUEZA_RESISTENCIA`;
  67. CREATE TABLE `FRAQUEZA_RESISTENCIA` (
  68.   `ID` tinyint(3) NOT NULL AUTO_INCREMENT,
  69.   `ATAQUE` VARCHAR(8) NOT NULL,
  70.   `DEFENSOR` VARCHAR(8) NOT NULL,
  71.   `EFEITO` DECIMAL(6,2) NOT NULL,
  72.   PRIMARY KEY  (`ID`)
  73. ) ENGINE=MyISAM AUTO_INCREMENT=111 DEFAULT CHARSET=latin1;
  74.  
  75. -- ----------------------------
  76. -- Records of FRAQUEZA_RESISTENCIA
  77. -- ----------------------------
  78. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('1', 'Normal', 'Rock', '0.50');
  79. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('2', 'Normal', 'Ghost', '0.00');
  80. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('3', 'Normal', 'Steel', '0.50');
  81. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('4', 'Fire', 'Fire', '0.50');
  82. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('5', 'Fire', 'Water', '0.50');
  83. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('6', 'Fire', 'Grass', '2.00');
  84. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('7', 'Fire', 'Ice', '2.00');
  85. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('8', 'Fire', 'Bug', '2.00');
  86. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('9', 'Fire', 'Rock', '0.50');
  87. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('10', 'Fire', 'Dragon', '0.50');
  88. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('11', 'Fire', 'Steel', '2.00');
  89. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('12', 'Water', 'Fire', '2.00');
  90. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('13', 'Water', 'Water', '0.50');
  91. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('14', 'Water', 'Grass', '0.50');
  92. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('15', 'Water', 'Ground', '2.00');
  93. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('16', 'Water', 'Rock', '2.00');
  94. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('17', 'Water', 'Dragon', '0.50');
  95. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('18', 'Electric', 'Water', '2.00');
  96. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('19', 'Electric', 'Electric', '0.50');
  97. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('20', 'Electric', 'Grass', '0.50');
  98. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('21', 'Electric', 'Ground', '0.00');
  99. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('22', 'Electric', 'Flying', '2.00');
  100. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('23', 'Electric', 'Dragon', '0.50');
  101. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('24', 'Grass', 'Fire', '0.50');
  102. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('25', 'Grass', 'Water', '2.00');
  103. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('26', 'Grass', 'Grass', '0.50');
  104. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('27', 'Grass', 'Poison', '0.50');
  105. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('28', 'Grass', 'Ground', '2.00');
  106. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('29', 'Grass', 'Flying', '0.50');
  107. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('30', 'Grass', 'Bug', '0.50');
  108. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('31', 'Grass', 'Rock', '2.00');
  109. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('32', 'Grass', 'Dragon', '0.50');
  110. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('33', 'Grass', 'Steel', '0.50');
  111. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('34', 'Ice', 'Fire', '0.50');
  112. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('35', 'Ice', 'Water', '0.50');
  113. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('36', 'Ice', 'Grass', '2.00');
  114. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('37', 'Ice', 'Ice', '0.50');
  115. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('38', 'Ice', 'Ground', '2.00');
  116. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('39', 'Ice', 'Flying', '2.00');
  117. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('40', 'Ice', 'Dragon', '2.00');
  118. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('41', 'Ice', 'Steel', '0.50');
  119. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('42', 'Fighting', 'Normal', '2.00');
  120. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('43', 'Fighting', 'Ice', '2.00');
  121. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('44', 'Fighting', 'Poison', '0.50');
  122. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('45', 'Fighting', 'Flying', '0.50');
  123. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('46', 'Fighting', 'Psychic', '0.50');
  124. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('47', 'Fighting', 'Bug', '0.50');
  125. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('48', 'Fighting', 'Rock', '2.00');
  126. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('49', 'Fighting', 'Ghost', '0.00');
  127. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('50', 'Fighting', 'Dark', '2.00');
  128. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('51', 'Fighting', 'Steel', '2.00');
  129. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('52', 'Poison', 'Grass', '2.00');
  130. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('53', 'Poison', 'Poison', '0.50');
  131. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('54', 'Poison', 'Ground', '0.50');
  132. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('55', 'Poison', 'Rock', '0.50');
  133. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('56', 'Poison', 'Ghost', '0.50');
  134. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('57', 'Poison', 'Steel', '0.00');
  135. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('58', 'Ground', 'Fire', '2.00');
  136. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('59', 'Ground', 'Electric', '2.00');
  137. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('60', 'Ground', 'Grass', '0.50');
  138. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('61', 'Ground', 'Poison', '2.00');
  139. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('62', 'Ground', 'Flying', '0.00');
  140. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('63', 'Ground', 'Bug', '0.50');
  141. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('64', 'Ground', 'Rock', '2.00');
  142. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('65', 'Ground', 'Steel', '2.00');
  143. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('66', 'Flying', 'Electric', '0.50');
  144. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('67', 'Flying', 'Grass', '2.00');
  145. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('68', 'Flying', 'Fighting', '2.00');
  146. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('69', 'Flying', 'Bug', '2.00');
  147. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('70', 'Flying', 'Rock', '0.50');
  148. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('71', 'Flying', 'Steel', '0.50');
  149. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('72', 'Psychic', 'Fighting', '2.00');
  150. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('73', 'Psychic', 'Poison', '2.00');
  151. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('74', 'Psychic', 'Psychic', '0.50');
  152. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('75', 'Psychic', 'Dark', '0.00');
  153. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('76', 'Psychic', 'Steel', '0.50');
  154. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('77', 'Bug', 'Fire', '0.50');
  155. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('78', 'Bug', 'Grass', '2.00');
  156. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('79', 'Bug', 'Fighting', '0.50');
  157. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('80', 'Bug', 'Poison', '0.50');
  158. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('81', 'Bug', 'Flying', '0.50');
  159. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('82', 'Bug', 'Psychic', '2.00');
  160. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('83', 'Bug', 'Ghost', '0.50');
  161. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('84', 'Bug', 'Dark', '2.00');
  162. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('85', 'Bug', 'Steel', '0.50');
  163. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('86', 'Rock', 'Fire', '2.00');
  164. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('87', 'Rock', 'Ice', '2.00');
  165. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('88', 'Rock', 'Fighting', '0.50');
  166. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('89', 'Rock', 'Ground', '0.50');
  167. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('90', 'Rock', 'Flying', '2.00');
  168. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('91', 'Rock', 'Bug', '2.00');
  169. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('92', 'Rock', 'Steel', '0.50');
  170. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('93', 'Ghost', 'Normal', '0.00');
  171. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('94', 'Ghost', 'Psychic', '2.00');
  172. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('95', 'Ghost', 'Ghost', '2.00');
  173. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('96', 'Ghost', 'Dark', '0.50');
  174. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('97', 'Ghost', 'Steel', '0.50');
  175. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('98', 'Dragon', 'Dragon', '2.00');
  176. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('99', 'Dragon', 'Steel', '0.50');
  177. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('100', 'Dark', 'Fighting', '0.50');
  178. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('101', 'Dark', 'Psychic', '2.00');
  179. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('102', 'Dark', 'Ghost', '2.00');
  180. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('103', 'Dark', 'Dark', '0.50');
  181. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('104', 'Dark', 'Steel', '0.50');
  182. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('105', 'Steel', 'Fire', '0.50');
  183. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('106', 'Steel', 'Water', '0.50');
  184. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('107', 'Steel', 'Electric', '0.50');
  185. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('108', 'Steel', 'Ice', '2.00');
  186. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('109', 'Steel', 'Rock', '2.00');
  187. INSERT INTO `FRAQUEZA_RESISTENCIA` VALUES ('110', 'Steel', 'Steel', '0.50');
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!