API tools faq
paste
tubelius

Create a MySQL table with Minecraft blocks

tubelius
Apr 12th, 2013
60
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.05 KB | None | 0 0
raw download clone embed print report
  1. delimiter ;
  2.  
  3. CREATE TABLE `Block` (
  4. `Id` tinyint(3) unsigned NOT NULL,
  5. `Name` varchar(60) NOT NULL,
  6. PRIMARY KEY (`Id`)
  7. ) ENGINE=MyISAM DEFAULT CHARSET=latin1
  8. ;
  9.  
  10. INSERT INTO Block(Id,Name)
  11. VALUES
  12. (0,'Air')
  13. , (1,'Stone')
  14. , (2,'Grass Block')
  15. , (3,'Dirt')
  16. , (4,'Cobblestone')
  17. , (5,'Wood Planks')
  18. , (6,'Saplings')
  19. , (7,'Bedrock')
  20. , (8,'Water')
  21. , (9,'Stationary water')
  22. , (10,'Lava')
  23. , (11,'Stationary lava')
  24. , (12,'Sand')
  25. , (13,'Gravel')
  26. , (14,'Gold Ore')
  27. , (15,'Iron Ore')
  28. , (16,'Coal Ore')
  29. , (17,'Wood')
  30. , (18,'Leaves')
  31. , (19,'Sponge')
  32. , (20,'Glass')
  33. , (21,'Lapis Lazuli Ore')
  34. , (22,'Lapis Lazuli Block')
  35. , (23,'Dispenser')
  36. , (24,'Sandstone')
  37. , (25,'Note Block')
  38. , (26,'Bed')
  39. , (27,'Powered Rail')
  40. , (28,'Detector Rail')
  41. , (29,'Sticky Piston')
  42. , (30,'Cobweb')
  43. , (31,'Grass')
  44. , (32,'Dead Bush')
  45. , (33,'Piston')
  46. , (34,'Piston Extension')
  47. , (35,'Wool')
  48. , (36,'Block moved by Piston')
  49. , (37,'Dandelion')
  50. , (38,'Rose')
  51. , (39,'Brown Mushroom')
  52. , (40,'Red Mushroom')
  53. , (41,'Block of Gold')
  54. , (42,'Block of Iron')
  55. , (43,'Double Slabs')
  56. , (44,'Slabs')
  57. , (45,'Bricks')
  58. , (46,'TNT')
  59. , (47,'Bookshelf')
  60. , (48,'Moss Stone')
  61. , (49,'Obsidian')
  62. , (50,'Torch')
  63. , (51,'Fire')
  64. , (52,'Monster Spawner')
  65. , (53,'Oak Wood Stairs')
  66. , (54,'Chest')
  67. , (55,'Redstone Wire')
  68. , (56,'Diamond Ore')
  69. , (57,'Block of Diamond')
  70. , (58,'Crafting Table')
  71. , (59,'Wheat')
  72. , (60,'Farmland')
  73. , (61,'Furnace')
  74. , (62,'Burning Furnace')
  75. , (63,'Sign Post')
  76. , (64,'Woodenoor')
  77. , (65,'Ladders')
  78. , (66,'Rail')
  79. , (67,'Cobblestone Stairs')
  80. , (68,'Wall Sign')
  81. , (69,'Lever')
  82. , (70,'Stone Pressure Plate')
  83. , (71,'Ironoor')
  84. , (72,'Wooden Pressure Plate')
  85. , (73,'Redstone Ore')
  86. , (74,'Glowing Redstone Ore')
  87. , (75,'Redstone Torch (inactive)')
  88. , (76,'Redstone Torch (active)')
  89. , (77,'Stoneutton')
  90. , (78,'Snow')
  91. , (79,'Ice')
  92. , (80,'Snow Block')
  93. , (81,'Cactus')
  94. , (82,'Clay')
  95. , (83,'Sugar Cane')
  96. , (84,'Jukebox')
  97. , (85,'Fence')
  98. , (86,'Pumpkin')
  99. , (87,'Netherrack')
  100. , (88,'Soul Sand')
  101. , (89,'Glowstone')
  102. , (90,'Nether Portal')
  103. , (91,'Jack ''o'' Lantern')
  104. , (92,'Cake Block')
  105. , (93,'Redstone Repeater (inactive)')
  106. , (94,'Redstone Repeater (active)')
  107. , (95,'Locked Chest')
  108. , (96,'Trapdoor')
  109. , (97,'Monster Egg')
  110. , (98,'Stone Bricks')
  111. , (99,'Huge Brown Mushroom')
  112. , (100,'Huge Red Mushroom')
  113. , (101,'Iron Bars')
  114. , (102,'Glass Pane')
  115. , (103,'Melon')
  116. , (104,'Pumpkin Stem')
  117. , (105,'Melon Stem')
  118. , (106,'Vines')
  119. , (107,'Fence Gate')
  120. , (108,'Brick Stairs')
  121. , (109,'Stone Brick Stairs')
  122. , (110,'Mycelium')
  123. , (111,'Lily Pad')
  124. , (112,'Nether Brick')
  125. , (113,'Nether Brick Fence')
  126. , (114,'Nether Brick Stairs')
  127. , (115,'Nether Wart')
  128. , (116,'Enchantment Table')
  129. , (117,'Brewing Stand')
  130. , (118,'Cauldron')
  131. , (119,'End Portal')
  132. , (120,'End Portal block')
  133. , (121,'End Stone')
  134. , (122,'Dragon Egg')
  135. , (123,'Redstone Lamp (inactive)')
  136. , (124,'Redstone Lamp (active)')
  137. , (125,'Wooden Double Slab')
  138. , (126,'Wooden Slab')
  139. , (127,'Cocoa')
  140. , (128,'Sandstone Stairs')
  141. , (129,'Emerald Ore')
  142. , (130,'Ender Chest')
  143. , (131,'Tripwire Hook')
  144. , (132,'Tripwire')
  145. , (133,'Block of Emerald')
  146. , (134,'Spruce Wood Stairs')
  147. , (135,'Birch Wood Stairs')
  148. , (136,'Jungle Wood Stairs')
  149. , (137,'Command Block')
  150. , (138,'Beacon')
  151. , (139,'Cobblestone Wall')
  152. , (140,'Flower Pot')
  153. , (141,'Carrots')
  154. , (142,'Potatoes')
  155. , (143,'Wooden Button')
  156. , (144,'Mob head')
  157. , (145,'Anvil')
  158. , (146,'Trapped Chest')
  159. , (147,'Weighted Pressure Plate (Light)')
  160. , (148,'Weighted Pressure Plate (Heavy)')
  161. , (149,'Redstone Comparator (inactive)')
  162. , (150,'Redstone Comparator (active)')
  163. , (151,'Daylight Sensor')
  164. , (152,'Block of Redstone')
  165. , (153,'Nether Quartz Ore')
  166. , (154,'Hopper')
  167. , (155,'Block of Quartz')
  168. , (156,'Quartz Stairs')
  169. , (157,'Activator Rail')
  170. , (158,'Dropper')
  171. ;
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!