API tools faq
paste
Advertisement
Guest User

Crux Craft MySQL

a guest
Sep 7th, 2013
157
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 8.88 KB | None | 0 0
raw download clone embed print report
  1. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  2. SET time_zone = "+00:00";
  3.  
  4.  
  5. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  6. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  7. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  8. /*!40101 SET NAMES utf8 */;
  9.  
  10. --
  11. -- Adatbázis: `cruxcraft`
  12. --
  13. CREATE DATABASE IF NOT EXISTS `cruxcraft` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  14. USE `cruxcraft`;
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. --
  19. -- Tábla szerkezet ehhez a táblához `couponcodes`
  20. --
  21.  
  22. CREATE TABLE IF NOT EXISTS `couponcodes` (
  23.   `codeid` int(5) NOT NULL AUTO_INCREMENT,
  24.   `code` varchar(15) NOT NULL,
  25.   `remaining` int(5) NOT NULL,
  26.   PRIMARY KEY (`codeid`),
  27.   UNIQUE KEY `code` (`code`)
  28. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  29.  
  30. -- --------------------------------------------------------
  31.  
  32. --
  33. -- Tábla szerkezet ehhez a táblához `cruxcraft`
  34. --
  35.  
  36. CREATE TABLE IF NOT EXISTS `cruxcraft` (
  37.   `id` int(11) NOT NULL AUTO_INCREMENT,
  38.   `cruxcraft` varchar(255) NOT NULL,
  39.   `password` varchar(255) NOT NULL,
  40.   `ip` varchar(40) NOT NULL,
  41.   `lastlogin` bigint(20) DEFAULT NULL,
  42.   `x` smallint(6) DEFAULT '0',
  43.   `y` smallint(6) DEFAULT '0',
  44.   `z` smallint(6) DEFAULT '0',
  45.   `email` varchar(255) DEFAULT 'nem_menti@szilard',
  46.   `level` int(11) NOT NULL,
  47.   `pp` int(11) NOT NULL DEFAULT '0',
  48.   PRIMARY KEY (`id`),
  49.   UNIQUE KEY `cruxcraft` (`cruxcraft`)
  50. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 ;
  51.  
  52. --
  53. -- A tábla adatainak kiíratása `cruxcraft`
  54. --
  55.  
  56. INSERT INTO `cruxcraft` (`id`, `cruxcraft`, `password`, `ip`, `lastlogin`, `x`, `y`, `z`, `email`, `level`, `pp`) VALUES
  57. (0, 'admin', '21232f297a57a5a743894a0e4a801fc3', '0.0.0.0', 1371818516432, 0, 0, 0, 'nem_menti@szilard', 2, 5000);
  58.  
  59. -- --------------------------------------------------------
  60.  
  61. --
  62. -- Tábla szerkezet ehhez a táblához `is_categories`
  63. --
  64.  
  65. CREATE TABLE IF NOT EXISTS `is_categories` (
  66.   `id` int(11) NOT NULL AUTO_INCREMENT,
  67.   `nev` text CHARACTER SET utf8 COLLATE utf8_hungarian_ci NOT NULL,
  68.   PRIMARY KEY (`id`)
  69. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
  70.  
  71. --
  72. -- A tábla adatainak kiíratása `is_categories`
  73. --
  74.  
  75. INSERT INTO `is_categories` (`id`, `nev`) VALUES
  76. (1, 'Nyersanyagok'),
  77. (3, 'Spawner tojások');
  78.  
  79. -- --------------------------------------------------------
  80.  
  81. --
  82. -- Tábla szerkezet ehhez a táblához `is_items`
  83. --
  84.  
  85. CREATE TABLE IF NOT EXISTS `is_items` (
  86.   `id` int(11) NOT NULL AUTO_INCREMENT,
  87.   `pp` int(11) NOT NULL,
  88.   `nev` text CHARACTER SET utf8 COLLATE utf8_hungarian_ci NOT NULL,
  89.   `image` text NOT NULL,
  90.   `anev` text NOT NULL,
  91.   `cid` int(11) NOT NULL,
  92.   `altipus` int(11) NOT NULL DEFAULT '0',
  93.   PRIMARY KEY (`id`)
  94. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;
  95.  
  96. --
  97. -- A tábla adatainak kiíratása `is_items`
  98. --
  99.  
  100. INSERT INTO `is_items` (`id`, `pp`, `nev`, `image`, `anev`, `cid`, `altipus`) VALUES
  101. (1, 12, 'Gold Ingot', 'gold.png', 'GOLD_INGOT', 1, 0),
  102. (2, 24, 'Diamond', 'diamond.png', 'DIAMOND', 1, 0),
  103. (4, 6, 'Iron Ingot', 'iron.png', 'IRON_INGOT', 1, 0),
  104. (5, 1, 'Obsidian', 'obsidian.png', 'OBSIDIAN', 1, 0),
  105. (6, 4, 'Slimeball', 'slimeball.png', 'SLIME_BALL', 1, 0),
  106. (7, 5, 'Glowstone', 'glowstone.png', 'GLOWSTONE', 1, 0),
  107. (50, 20, 'Spawner Egg (Squid)', 'spawn_egg94.png', 'MONSTER_EGG', 3, 94),
  108. (49, 20, 'Spawner Egg (Chicken)', 'spawn_egg93.png', 'MONSTER_EGG', 3, 93),
  109. (48, 20, 'Spawner Egg (Cow)', 'spawn_egg92.png', 'MONSTER_EGG', 3, 92),
  110. (47, 20, 'Spawner Egg (Sheep)', 'spawn_egg91.png', 'MONSTER_EGG', 3, 91),
  111. (46, 20, 'Spawner Egg (Pig)', 'spawn_egg90.png', 'MONSTER_EGG', 3, 90),
  112. (45, 20, 'Spawner Egg (Witch)', 'spawn_egg66.png', 'MONSTER_EGG', 3, 66),
  113. (44, 20, 'Spawner Egg (Witch)', 'spawn_egg66.png', 'MONSTER_EGG', 3, 66),
  114. (43, 20, 'Spawner Egg (Bat)', 'spawn_egg65.png', 'MONSTER_EGG', 3, 65),
  115. (42, 20, 'Spawn Egg (Magma Cube)', 'spawn_egg61.png', 'MONSTER_EGG', 3, 61),
  116. (41, 20, 'Spawn Egg (Blaze)', 'spawn_egg60.png', 'MONSTER_EGG', 3, 60),
  117. (40, 20, 'Spawn Egg (Silverfish)', 'spawn_egg59.png', 'MONSTER_EGG', 3, 59),
  118. (39, 20, 'Spawn Egg (Cave Spider)', 'spawn_egg58.png', 'MONSTER_EGG', 3, 58),
  119. (38, 20, 'Spawn Egg (Endermen)', 'spawn_egg57.png', 'MONSTER_EGG', 3, 57),
  120. (37, 20, 'Spawn Egg (Zombie Pigmen)', 'spawn_egg56.png', 'MONSTER_EGG', 3, 56),
  121. (36, 20, 'Spawn Egg (Ghast)', 'spawn_egg55.png', 'MONSTER_EGG', 3, 55),
  122. (35, 20, 'Spawn Egg (Slime)', 'spawn_egg54.png', 'MONSTER_EGG', 3, 54),
  123. (34, 20, 'Spawn Egg (Zombie)', 'spawn_egg52.png', 'MONSTER_EGG', 3, 52),
  124. (33, 20, 'Spawn Egg (Spider)', 'spawn_egg51.png', 'MONSTER_EGG', 3, 51),
  125. (32, 20, 'Spawn Egg (Skeleton)', 'spawn_egg50.png', 'MONSTER_EGG', 3, 50),
  126. (51, 20, 'Spawner Egg (Wolf)', 'spawn_egg95.png', 'MONSTER_EGG', 3, 95),
  127. (52, 20, 'Spawner Egg (Mooshroom)', 'spawn_egg96.png', 'MONSTER_EGG', 3, 96),
  128. (53, 20, 'Spawner Egg (Ocelot)', 'spawn_egg98.png', 'MONSTER_EGG', 3, 98),
  129. (55, 20, 'Spawner Egg (Villager)', 'spawn_egg120.png', 'MONSTER_EGG', 3, 120);
  130.  
  131. -- --------------------------------------------------------
  132.  
  133. --
  134. -- Tábla szerkezet ehhez a táblához `packagecommands`
  135. --
  136.  
  137. CREATE TABLE IF NOT EXISTS `packagecommands` (
  138.   `id` int(11) NOT NULL,
  139.   `command` varchar(200) NOT NULL,
  140.   `console` tinyint(1) NOT NULL DEFAULT '1',
  141.   KEY `id` (`id`)
  142. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  143.  
  144. -- --------------------------------------------------------
  145.  
  146. --
  147. -- Tábla szerkezet ehhez a táblához `packageitems`
  148. --
  149.  
  150. CREATE TABLE IF NOT EXISTS `packageitems` (
  151.   `id` int(11) NOT NULL,
  152.   `item` text NOT NULL,
  153.   KEY `id` (`id`)
  154. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  155.  
  156. --
  157. -- A tábla adatainak kiíratása `packageitems`
  158. --
  159.  
  160. INSERT INTO `packageitems` (`id`, `item`) VALUES
  161. (21, 'item:\n  ==: org.bukkit.inventory.ItemStack\n  type: MONSTER_EGG\n  damage: 100'),
  162. (20, 'item:\n  ==: org.bukkit.inventory.ItemStack\n  type: MONSTER_EGG\n  damage: 50\n'),
  163. (19, 'item:\n  ==: org.bukkit.inventory.ItemStack\n  type: IRON_INGOT'),
  164. (22, 'item:\n  ==: org.bukkit.inventory.ItemStack\n  type: MONSTER_EGG\n  damage: 120'),
  165. (23, 'item:\n  ==: org.bukkit.inventory.ItemStack\n  type: OBSIDIAN'),
  166. (24, 'item:\n  ==: org.bukkit.inventory.ItemStack\n  type: MONSTER_EGG\n  damage: 93');
  167.  
  168. -- --------------------------------------------------------
  169.  
  170. --
  171. -- Tábla szerkezet ehhez a táblához `packages`
  172. --
  173.  
  174. CREATE TABLE IF NOT EXISTS `packages` (
  175.   `id` int(11) NOT NULL AUTO_INCREMENT,
  176.   `name` varchar(50) DEFAULT NULL,
  177.   `description` varchar(150) DEFAULT NULL,
  178.   `created` int(12) NOT NULL,
  179.   `creator` varchar(32) DEFAULT NULL,
  180.   `code` int(5) DEFAULT NULL,
  181.   `player` varchar(32) DEFAULT NULL,
  182.   `money` double DEFAULT NULL,
  183.   `redeemed` int(12) DEFAULT NULL,
  184.   `embargo` int(12) DEFAULT NULL,
  185.   `expiry` int(12) DEFAULT NULL,
  186.   `server` varchar(20) DEFAULT NULL,
  187.   PRIMARY KEY (`id`)
  188. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
  189.  
  190. --
  191. -- A tábla adatainak kiíratása `packages`
  192. --
  193.  
  194. INSERT INTO `packages` (`id`, `name`, `description`, `created`, `creator`, `code`, `player`, `money`, `redeemed`, `embargo`, `expiry`, `server`) VALUES
  195. (24, NULL, NULL, 1371895975, NULL, NULL, 'admin', NULL, NULL, NULL, NULL, NULL),
  196. (23, NULL, NULL, 1371895962, NULL, NULL, 'admin', NULL, NULL, NULL, NULL, NULL),
  197. (22, NULL, NULL, 1371895773, NULL, NULL, 'admin', NULL, 1371895777, NULL, NULL, NULL),
  198. (21, NULL, NULL, 1371895672, NULL, NULL, 'admin', NULL, 1371895683, NULL, NULL, NULL),
  199. (20, NULL, NULL, 1371818941, NULL, NULL, 'admin', NULL, 1371818991, NULL, NULL, NULL),
  200. (19, NULL, NULL, 1371818494, NULL, NULL, 'admin', NULL, 1371818521, NULL, NULL, NULL);
  201.  
  202. -- --------------------------------------------------------
  203.  
  204. --
  205. -- Tábla szerkezet ehhez a táblához `pp`
  206. --
  207.  
  208. CREATE TABLE IF NOT EXISTS `pp` (
  209.   `id` int(11) NOT NULL AUTO_INCREMENT,
  210.   `price` int(11) NOT NULL,
  211.   `pp` int(11) NOT NULL,
  212.   `telszam` text NOT NULL,
  213.   `keyword` text NOT NULL,
  214.   PRIMARY KEY (`id`)
  215. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
  216.  
  217. --
  218. -- A tábla adatainak kiíratása `pp`
  219. --
  220.  
  221. INSERT INTO `pp` (`id`, `price`, `pp`, `telszam`, `keyword`) VALUES
  222. (7, 508, 490, '0691336000', 'crux3'),
  223. (6, 305, 280, '0691555400', 'crux2'),
  224. (8, 1016, 990, '0690888338', 'crux4'),
  225. (9, 2032, 2000, '0690888448', 'crux5'),
  226. (10, 155, 135, '0691555100', 'crux');
  227.  
  228. -- --------------------------------------------------------
  229.  
  230. --
  231. -- Tábla szerkezet ehhez a táblához `smslog`
  232. --
  233.  
  234. CREATE TABLE IF NOT EXISTS `smslog` (
  235.   `id` int(11) NOT NULL AUTO_INCREMENT,
  236.   `ar` int(11) NOT NULL,
  237.   `telszam` text NOT NULL,
  238.   `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  239.   `txt` text NOT NULL,
  240.   PRIMARY KEY (`id`)
  241. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  242.  
  243. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  244. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  245. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!