API tools faq
paste
hhjfdgdfgdfg

sql schema

hhjfdgdfgdfg
Mar 21st, 2024
9
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.60 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 5.2.1
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Värd: 127.0.0.1
  6. -- Tid vid skapande: 20 mars 2024 kl 22:20
  7. -- Serverversion: 10.4.32-MariaDB
  8. -- PHP-version: 8.2.12
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. START TRANSACTION;
  12. SET time_zone = "+00:00";
  13.  
  14.  
  15. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  16. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  17. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  18. /*!40101 SET NAMES utf8mb4 */;
  19.  
  20. --
  21. -- Databas: `vorpcore_f750d4`
  22. --
  23.  
  24. -- --------------------------------------------------------
  25.  
  26. --
  27. -- Tabellstruktur `bank_users`
  28. --
  29.  
  30. CREATE TABLE `bank_users` (
  31. `id` int(11) NOT NULL,
  32. `name` varchar(50) NOT NULL,
  33. `identifier` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  34. `charidentifier` int(11) NOT NULL,
  35. `money` double(22,2) DEFAULT 0.00,
  36. `gold` double(22,2) DEFAULT 0.00,
  37. `items` longtext DEFAULT '[]',
  38. `invspace` int(11) NOT NULL
  39. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  40.  
  41. -- --------------------------------------------------------
  42.  
  43. --
  44. -- Tabellstruktur `banneds`
  45. --
  46.  
  47. CREATE TABLE `banneds` (
  48. `b_id` int(11) NOT NULL,
  49. `b_steam` varchar(100) NOT NULL,
  50. `b_license` varchar(255) DEFAULT NULL,
  51. `b_discord` varchar(100) DEFAULT NULL,
  52. `b_reason` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  53. `b_banned` varchar(100) NOT NULL,
  54. `b_unban` varchar(100) NOT NULL,
  55. `b_permanent` tinyint(1) NOT NULL DEFAULT 0
  56. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  57.  
  58. -- --------------------------------------------------------
  59.  
  60. --
  61. -- Tabellstruktur `bills`
  62. --
  63.  
  64. CREATE TABLE `bills` (
  65. `id` int(11) NOT NULL,
  66. `job` longtext DEFAULT NULL,
  67. `playername` longtext DEFAULT NULL,
  68. `identifier` varchar(50) DEFAULT NULL,
  69. `charidentifier` int(11) DEFAULT NULL,
  70. `issuer` longtext DEFAULT NULL,
  71. `amount` double DEFAULT NULL
  72. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  73.  
  74. -- --------------------------------------------------------
  75.  
  76. --
  77. -- Tabellstruktur `characters`
  78. --
  79.  
  80. CREATE TABLE `characters` (
  81. `identifier` varchar(50) NOT NULL DEFAULT '',
  82. `steamname` varchar(50) NOT NULL DEFAULT '',
  83. `charidentifier` int(11) NOT NULL,
  84. `group` varchar(10) DEFAULT 'user',
  85. `money` double(11,2) DEFAULT 0.00,
  86. `gold` double(11,2) DEFAULT 0.00,
  87. `rol` double(11,2) NOT NULL DEFAULT 0.00,
  88. `xp` int(11) DEFAULT 0,
  89. `healthouter` int(4) DEFAULT 500,
  90. `healthinner` int(4) DEFAULT 100,
  91. `staminaouter` int(4) DEFAULT 100,
  92. `staminainner` int(4) DEFAULT 100,
  93. `hours` float NOT NULL DEFAULT 0,
  94. `LastLogin` date DEFAULT NULL,
  95. `inventory` longtext DEFAULT NULL,
  96. `job` varchar(50) DEFAULT 'unemployed',
  97. `joblabel` varchar(255) DEFAULT 'job label',
  98. `status` varchar(140) DEFAULT '{}',
  99. `meta` varchar(255) NOT NULL DEFAULT '{}',
  100. `firstname` varchar(50) DEFAULT ' ',
  101. `lastname` varchar(50) DEFAULT ' ',
  102. `character_desc` mediumtext NOT NULL DEFAULT ' ',
  103. `gender` varchar(50) NOT NULL DEFAULT ' ',
  104. `age` int(11) NOT NULL DEFAULT 0,
  105. `nickname` varchar(50) DEFAULT ' ',
  106. `skinPlayer` longtext DEFAULT NULL,
  107. `compPlayer` longtext DEFAULT NULL,
  108. `compTints` longtext DEFAULT NULL,
  109. `jobgrade` int(11) DEFAULT 0,
  110. `coords` longtext DEFAULT '{}',
  111. `isdead` tinyint(1) DEFAULT 0,
  112. `trust` int(11) DEFAULT 0,
  113. `walk` varchar(50) DEFAULT 'noanim',
  114. `crafting` longtext DEFAULT '{"medical":0,"blacksmith":0,"basic":0,"survival":0,"brewing":0,"food":0}',
  115. `info` longtext DEFAULT '{}',
  116. `gunsmith` double(11,2) DEFAULT 0.00,
  117. `ammo` longtext DEFAULT '{}',
  118. `discordid` varchar(255) DEFAULT '0',
  119. `lastjoined` longtext DEFAULT '[]'
  120. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
  121.  
  122. --
  123. -- Dumpning av Data i tabell `characters`
  124. --
  125.  
  126. INSERT INTO `characters` (`identifier`, `steamname`, `charidentifier`, `group`, `money`, `gold`, `rol`, `xp`, `healthouter`, `healthinner`, `staminaouter`, `staminainner`, `hours`, `LastLogin`, `inventory`, `job`, `joblabel`, `status`, `meta`, `firstname`, `lastname`, `character_desc`, `gender`, `age`, `nickname`, `skinPlayer`, `compPlayer`, `compTints`, `jobgrade`, `coords`, `isdead`, `trust`, `walk`, `crafting`, `info`, `gunsmith`, `ammo`, `discordid`, `lastjoined`) VALUES
  127. ('steam:110000116f5f3f5', 'Thugger', 1, 'superadmin', 200.00, 0.00, 0.00, 0, 500, 100, 500, 100, 0, '2024-03-20', '{}', 'unemployed', 'Unemployed', '{\"Thirst\":0,\"Hunger\":500,\"Metabolism\":-2958}', '{}', 'Rober', 'Smitch', 'yes\n\n', 'Female', 29, 'Robert Smitch', '{\"complex_opacity\":0,\"shadows_palette_color_secondary\":0,\"FaceS\":0.0,\"MouthY\":0.0,\"NeckD\":0.0,\"lipsticks_palette_color_tertiary\":0,\"MouthCLLD\":0.0,\"Scale\":0.0,\"FaceD\":0.0,\"spots_visibility\":0,\"MouthCRW\":0.0,\"hair_color_primary\":0,\"HeadType\":1352772082,\"ageing_opacity\":0,\"blush_palette_color_primary\":0,\"paintedmasks_palette_color_secondary\":0,\"freckles_tx_id\":0,\"ChinW\":0.0,\"MouthCRD\":0.0,\"EyeBrowW\":0.0,\"EyeLidH\":0.0,\"ArmsS\":0.0,\"scars_visibility\":0,\"ChinH\":0.0,\"moles_opacity\":0,\"spots_tx_id\":0,\"foundation_palette_color_primary\":0,\"NoseS\":0.0,\"Hair\":3887861344,\"hair_visibility\":0,\"MouthCLH\":0.0,\"lipsticks_visibility\":0,\"eyebrows_color\":1064202495,\"hair_opacity\":0,\"freckles_opacity\":0,\"moles_tx_id\":0,\"paintedmasks_palette_color_tertiary\":0,\"ChestS\":0.0,\"NoseC\":0.0,\"hair_tx_id\":0,\"albedo\":-1532879544,\"acne_visibility\":0,\"WaistW\":0.0,\"LegsType\":1041575294,\"NoseAng\":0.0,\"grime_tx_id\":0,\"EyeAng\":0.0,\"ShouldersT\":0.0,\"ageing_visibility\":0,\"Body\":1058996709,\"EyeLidL\":0.0,\"paintedmasks_visibility\":0,\"grime_visibility\":0,\"shadows_tx_id\":0,\"MouthCLD\":0.0,\"LegsS\":0.0,\"EyeLidR\":0.0,\"shadows_palette_id\":0,\"CheekBonesH\":0.0,\"CalvesS\":0.0,\"eyebrows_visibility\":1,\"beardstabble_tx_id\":0,\"EyeH\":0.0,\"paintedmasks_opacity\":0,\"Beard\":0,\"LLiphH\":0.0,\"FaceW\":0.0,\"ChinD\":0.0,\"LLiphD\":0.0,\"ShouldersS\":0.0,\"lipsticks_opacity\":0,\"complex_visibility\":0,\"EyeDis\":0.0,\"lipsticks_tx_id\":0,\"EyeBrowD\":0.0,\"paintedmasks_palette_id\":0,\"ULiphH\":0.0,\"NoseH\":0.0,\"Torso\":0,\"paintedmasks_tx_id\":0,\"foundation_opacity\":0,\"eyeliner_palette_id\":0,\"foundation_palette_color_secondary\":0,\"MouthD\":0.0,\"CheekBonesW\":0.0,\"ULiphD\":0.0,\"foundation_visibility\":0,\"shadows_palette_color_tertiary\":0,\"JawD\":0.0,\"blush_opacity\":0,\"blush_palette_id\":0,\"blush_tx_id\":0,\"blush_visibility\":0,\"BodyType\":743432389,\"foundation_palette_color_tertiary\":0,\"ageing_tx_id\":0,\"eyeliner_color_primary\":0,\"eyeliner_opacity\":0,\"eyeliner_tx_id\":0,\"beardstabble_opacity\":0,\"disc_opacity\":0,\"beardstabble_color_primary\":0,\"ShouldersM\":0.0,\"beardstabble_visibility\":0,\"shadows_opacity\":0,\"foundation_tx_id\":0,\"shadows_palette_color_primary\":0,\"Eyes\":928002221,\"LLiphW\":0.0,\"EarsH\":0.0,\"shadows_visibility\":0,\"lipsticks_palette_color_secondary\":0,\"lipsticks_palette_color_primary\":0,\"lipsticks_palette_id\":0,\"paintedmasks_palette_color_primary\":0,\"grime_opacity\":0,\"moles_visibility\":0,\"disc_tx_id\":0,\"MouthW\":0.0,\"HeadSize\":0.0,\"eyebrows_opacity\":1.0,\"eyeliner_visibility\":0,\"NoseDis\":0.0,\"acne_opacity\":0,\"EyeLidW\":0.0,\"acne_tx_id\":0,\"complex_tx_id\":0,\"disc_visibility\":0,\"sex\":\"mp_female\",\"spots_opacity\":0,\"scars_opacity\":0,\"scars_tx_id\":0,\"EyeBrowH\":0.0,\"ULiphW\":0.0,\"freckles_visibility\":0,\"eyebrows_tx_id\":1,\"MouthCRLD\":0.0,\"Waist\":0,\"JawW\":0.0,\"MouthCLW\":0.0,\"JawH\":0.0,\"HipsS\":0.0,\"foundation_palette_id\":0,\"MouthCRH\":0.0,\"CheekBonesD\":0.0,\"NoseW\":0.0,\"EyeD\":0.0,\"EarsL\":0.0,\"NeckW\":0.0,\"EarsD\":0.0,\"EarsW\":0.0,\"MouthX\":0.0}', '{\"Loadouts\":-1,\"Gunbelt\":1511461630,\"CoatClosed\":-1,\"RingLh\":-1,\"Spats\":-1,\"Belt\":-1,\"Boots\":-571902733,\"Spurs\":-1,\"RingRh\":-1,\"Skirt\":-1,\"bow\":-1,\"Pant\":1803504493,\"Buckle\":-1,\"GunbeltAccs\":-1,\"NeckTies\":-1,\"Holster\":-1,\"Teeth\":-1,\"Suspender\":-1,\"Shirt\":-599669674,\"Satchels\":-1,\"Hat\":-1,\"Glove\":-1,\"Mask\":-1,\"Accessories\":-1,\"Coat\":-1,\"Cloak\":-1,\"Armor\":-1,\"Bracelet\":-1,\"Poncho\":-1,\"Gauntlets\":-1,\"Chap\":-1,\"Badge\":-1,\"EyeWear\":-1,\"Vest\":-1,\"Dress\":-1,\"NeckWear\":-1}', '{\"Shirt\":{\"-599669674\":{\"tint0\":0,\"tint1\":0,\"palette\":0,\"tint2\":0}},\"Pant\":{\"1803504493\":{\"tint0\":0,\"tint1\":0,\"palette\":0,\"tint2\":0}},\"Boots\":{\"-571902733\":{\"tint0\":0,\"tint1\":0,\"palette\":0,\"tint2\":0}}}', 0, '{\"z\":118.4154052734375,\"heading\":0.0,\"x\":-294.1054992675781,\"y\":788.2944946289063}', 0, 0, 'noanim', '{\"medical\":0,\"blacksmith\":0,\"basic\":0,\"survival\":0,\"brewing\":0,\"food\":0}', '{}', 0.00, '{}', '872577343426797589', '[]');
  128.  
  129. -- --------------------------------------------------------
  130.  
  131. --
  132. -- Tabellstruktur `character_inventories`
  133. --
  134.  
  135. CREATE TABLE `character_inventories` (
  136. `character_id` int(11) DEFAULT NULL,
  137. `inventory_type` varchar(100) NOT NULL DEFAULT 'default',
  138. `item_crafted_id` int(11) NOT NULL,
  139. `amount` int(11) DEFAULT NULL,
  140. `created_at` timestamp NULL DEFAULT current_timestamp()
  141. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  142.  
  143. --
  144. -- Dumpning av Data i tabell `character_inventories`
  145. --
  146.  
  147. INSERT INTO `character_inventories` (`character_id`, `inventory_type`, `item_crafted_id`, `amount`, `created_at`) VALUES
  148. (1, 'default', 2, 2, '2024-03-18 13:15:13'),
  149. (1, 'default', 1, 1, '2024-03-18 13:15:13'),
  150. (1, 'default', 4, 1, '2024-03-20 13:26:31');
  151.  
  152. -- --------------------------------------------------------
  153.  
  154. --
  155. -- Tabellstruktur `doors`
  156. --
  157.  
  158. CREATE TABLE `doors` (
  159. `id` int(11) NOT NULL,
  160. `doorinfo` longtext NOT NULL DEFAULT '[]',
  161. `job` longtext NOT NULL DEFAULT '[]',
  162. `item` longtext NOT NULL,
  163. `break` int(11) DEFAULT 0
  164. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  165.  
  166. -- --------------------------------------------------------
  167.  
  168. --
  169. -- Tabellstruktur `herbalists`
  170. --
  171.  
  172. CREATE TABLE `herbalists` (
  173. `identifier` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  174. `charidentifier` int(11) NOT NULL,
  175. `location` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
  176. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  177.  
  178. -- --------------------------------------------------------
  179.  
  180. --
  181. -- Tabellstruktur `horse_complements`
  182. --
  183.  
  184. CREATE TABLE `horse_complements` (
  185. `identifier` varchar(50) DEFAULT NULL,
  186. `charidentifier` int(11) NOT NULL,
  187. `complements` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
  188. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  189.  
  190. -- --------------------------------------------------------
  191.  
  192. --
  193. -- Tabellstruktur `housing`
  194. --
  195.  
  196. CREATE TABLE `housing` (
  197. `id` int(11) NOT NULL,
  198. `identifier` varchar(255) DEFAULT NULL,
  199. `charidentifier` int(11) NOT NULL,
  200. `inventory` longtext DEFAULT NULL,
  201. `furniture` longtext DEFAULT NULL,
  202. `open` tinyint(1) NOT NULL DEFAULT 0
  203. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  204.  
  205. -- --------------------------------------------------------
  206.  
  207. --
  208. -- Tabellstruktur `items`
  209. --
  210.  
  211. CREATE TABLE `items` (
  212. `item` varchar(50) NOT NULL,
  213. `label` varchar(50) NOT NULL,
  214. `limit` int(11) NOT NULL DEFAULT 1,
  215. `can_remove` tinyint(1) NOT NULL DEFAULT 1,
  216. `type` varchar(50) DEFAULT NULL,
  217. `usable` tinyint(1) DEFAULT NULL,
  218. `id` int(11) NOT NULL,
  219. `groupId` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Item Group ID for Filtering',
  220. `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '{}',
  221. `desc` varchar(5550) NOT NULL DEFAULT 'nice item'
  222. ) ;
  223.  
  224. --
  225. -- Dumpning av Data i tabell `items`
  226. --
  227.  
  228. INSERT INTO `items` (`item`, `label`, `limit`, `can_remove`, `type`, `usable`, `id`, `groupId`, `metadata`, `desc`) VALUES
  229. -- --------------------------------------------------------
  230.  
  231. --
  232. -- Tabellstruktur `items_crafted`
  233. --
  234.  
  235. CREATE TABLE `items_crafted` (
  236. `id` int(11) NOT NULL,
  237. `character_id` int(11) NOT NULL,
  238. `item_id` int(11) NOT NULL,
  239. `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  240. `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`metadata`))
  241. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  242.  
  243. --
  244. -- Dumpning av Data i tabell `items_crafted`
  245. --
  246.  
  247. INSERT INTO `items_crafted` (`id`, `character_id`, `item_id`, `updated_at`, `metadata`) VALUES
  248. (1, 1, 39, '2024-03-18 13:15:13', '[]'),
  249. (2, 1, 208, '2024-03-18 13:15:13', '[]'),
  250. (4, 1, 977, '2024-03-20 13:26:31', '[]');
  251.  
  252. -- --------------------------------------------------------
  253.  
  254. --
  255. -- Tabellstruktur `item_group`
  256. --
  257.  
  258. CREATE TABLE `item_group` (
  259. `id` int(10) UNSIGNED NOT NULL,
  260. `description` varchar(255) NOT NULL COMMENT 'Description of Item Group'
  261. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
  262.  
  263. --
  264. -- Dumpning av Data i tabell `item_group`
  265. --
  266.  
  267. INSERT INTO `item_group` (`id`, `description`) VALUES
  268. (1, 'default');
  269.  
  270. -- --------------------------------------------------------
  271.  
  272. --
  273. -- Tabellstruktur `loadout`
  274. --
  275.  
  276. CREATE TABLE `loadout` (
  277. `id` int(11) NOT NULL,
  278. `identifier` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  279. `charidentifier` int(11) DEFAULT NULL,
  280. `name` varchar(50) DEFAULT NULL,
  281. `ammo` varchar(255) NOT NULL DEFAULT '{}',
  282. `components` varchar(255) NOT NULL DEFAULT '{}',
  283. `dirtlevel` double DEFAULT 0,
  284. `mudlevel` double DEFAULT 0,
  285. `conditionlevel` double DEFAULT 0,
  286. `rustlevel` double DEFAULT 0,
  287. `used` tinyint(4) DEFAULT 0,
  288. `used2` tinyint(4) DEFAULT 0,
  289. `dropped` int(11) NOT NULL DEFAULT 0,
  290. `comps` longtext NOT NULL DEFAULT '{}',
  291. `label` varchar(50) DEFAULT NULL,
  292. `curr_inv` varchar(100) NOT NULL DEFAULT 'default',
  293. `serial_number` varchar(50) DEFAULT NULL,
  294. `custom_label` varchar(50) DEFAULT NULL,
  295. `custom_desc` varchar(50) DEFAULT NULL
  296. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  297.  
  298. --
  299. -- Dumpning av Data i tabell `loadout`
  300. --
  301.  
  302. INSERT INTO `loadout` (`id`, `identifier`, `charidentifier`, `name`, `ammo`, `components`, `dirtlevel`, `mudlevel`, `conditionlevel`, `rustlevel`, `used`, `used2`, `dropped`, `comps`, `label`, `curr_inv`, `serial_number`, `custom_label`, `custom_desc`) VALUES
  303. (1, 'steam:110000116f5f3f5', 1, 'WEAPON_MELEE_KNIFE', '[]', '[]', 0, 0, 0, 0, 0, 0, 0, '[]', 'Knife', 'default', '', 'Knife', NULL);
  304.  
  305. -- --------------------------------------------------------
  306.  
  307. --
  308. -- Tabellstruktur `mailbox_mails`
  309. --
  310.  
  311. CREATE TABLE `mailbox_mails` (
  312. `id` int(11) NOT NULL,
  313. `sender_id` varchar(50) DEFAULT NULL,
  314. `sender_firstname` varchar(50) DEFAULT NULL,
  315. `sender_lastname` varchar(50) DEFAULT NULL,
  316. `receiver_id` varchar(50) DEFAULT NULL,
  317. `receiver_firstname` varchar(50) DEFAULT NULL,
  318. `receiver_lastname` varchar(50) DEFAULT NULL,
  319. `message` text DEFAULT NULL,
  320. `opened` tinyint(1) DEFAULT 0,
  321. `received_at` datetime DEFAULT current_timestamp()
  322. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  323.  
  324. -- --------------------------------------------------------
  325.  
  326. --
  327. -- Tabellstruktur `outfits`
  328. --
  329.  
  330. CREATE TABLE `outfits` (
  331. `id` int(11) NOT NULL,
  332. `identifier` varchar(45) NOT NULL,
  333. `charidentifier` int(11) DEFAULT NULL,
  334. `title` varchar(255) DEFAULT NULL,
  335. `comps` longtext DEFAULT NULL,
  336. `compTints` longtext DEFAULT NULL
  337. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  338.  
  339. -- --------------------------------------------------------
  340.  
  341. --
  342. -- Tabellstruktur `player_backpacks`
  343. --
  344.  
  345. CREATE TABLE `player_backpacks` (
  346. `id` int(11) NOT NULL,
  347. `character_id` varchar(255) NOT NULL,
  348. `backpack_type` varchar(255) NOT NULL,
  349. `slots` int(11) NOT NULL
  350. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
  351.  
  352. -- --------------------------------------------------------
  353.  
  354. --
  355. -- Tabellstruktur `rooms`
  356. --
  357.  
  358. CREATE TABLE `rooms` (
  359. `id` int(11) NOT NULL,
  360. `interiorId` int(11) NOT NULL,
  361. `inventory` longtext DEFAULT NULL,
  362. `identifier` varchar(60) NOT NULL,
  363. `charidentifier` int(11) NOT NULL
  364. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC;
  365.  
  366. -- --------------------------------------------------------
  367.  
  368. --
  369. -- Tabellstruktur `stables`
  370. --
  371.  
  372. CREATE TABLE `stables` (
  373. `id` int(11) NOT NULL,
  374. `identifier` varchar(50) DEFAULT NULL,
  375. `charidentifier` int(11) NOT NULL,
  376. `name` varchar(30) NOT NULL,
  377. `modelname` varchar(70) NOT NULL,
  378. `type` varchar(11) NOT NULL,
  379. `status` longtext DEFAULT NULL,
  380. `xp` int(11) DEFAULT 0,
  381. `injured` int(11) DEFAULT 0,
  382. `gear` longtext DEFAULT NULL,
  383. `isDefault` int(11) NOT NULL DEFAULT 0,
  384. `inventory` longtext DEFAULT NULL
  385. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  386.  
  387. -- --------------------------------------------------------
  388.  
  389. --
  390. -- Tabellstruktur `users`
  391. --
  392.  
  393. CREATE TABLE `users` (
  394. `identifier` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  395. `group` varchar(50) DEFAULT 'user',
  396. `warnings` int(11) DEFAULT 0,
  397. `banned` tinyint(1) DEFAULT NULL,
  398. `banneduntil` int(10) DEFAULT 0,
  399. `char` int(11) DEFAULT 5
  400. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  401.  
  402. --
  403. -- Dumpning av Data i tabell `users`
  404. --
  405.  
  406. INSERT INTO `users` (`identifier`, `group`, `warnings`, `banned`, `banneduntil`, `char`) VALUES
  407. ('steam:110000116f5f3f5', 'superadmin', 0, 0, 0, 5);
  408.  
  409. -- --------------------------------------------------------
  410.  
  411. --
  412. -- Tabellstruktur `wagons`
  413. --
  414.  
  415. CREATE TABLE `wagons` (
  416. `id` int(11) NOT NULL,
  417. `identifier` varchar(40) NOT NULL,
  418. `charid` int(11) NOT NULL,
  419. `selected` int(11) NOT NULL DEFAULT 0,
  420. `model` varchar(50) NOT NULL,
  421. `name` varchar(50) NOT NULL,
  422. `items` longtext DEFAULT '{}'
  423. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  424.  
  425. -- --------------------------------------------------------
  426.  
  427. --
  428. -- Tabellstruktur `whitelist`
  429. --
  430.  
  431. CREATE TABLE `whitelist` (
  432. `id` int(11) NOT NULL,
  433. `identifier` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  434. `status` tinyint(1) DEFAULT NULL,
  435. `firstconnection` tinyint(1) DEFAULT 1,
  436. `discordid` varchar(255) DEFAULT '0'
  437. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;
  438.  
  439. --
  440. -- Index för dumpade tabeller
  441. --
  442.  
  443. --
  444. -- Index för tabell `bank_users`
  445. --
  446. ALTER TABLE `bank_users`
  447. ADD PRIMARY KEY (`id`),
  448. ADD KEY `name` (`name`),
  449. ADD KEY `bankusers` (`identifier`) USING BTREE;
  450.  
  451. --
  452. -- Index för tabell `banneds`
  453. --
  454. ALTER TABLE `banneds`
  455. ADD PRIMARY KEY (`b_id`) USING BTREE;
  456.  
  457. --
  458. -- Index för tabell `bills`
  459. --
  460. ALTER TABLE `bills`
  461. ADD PRIMARY KEY (`id`),
  462. ADD UNIQUE KEY `id` (`id`);
  463.  
  464. --
  465. -- Index för tabell `characters`
  466. --
  467. ALTER TABLE `characters`
  468. ADD UNIQUE KEY `identifier_charidentifier` (`identifier`,`charidentifier`) USING BTREE,
  469. ADD KEY `charidentifier` (`charidentifier`) USING BTREE,
  470. ADD KEY `crafting` (`crafting`(768)),
  471. ADD KEY `compPlayer` (`compPlayer`(768)),
  472. ADD KEY `info` (`info`(768)),
  473. ADD KEY `inventory` (`inventory`(768)),
  474. ADD KEY `coords` (`coords`(768)),
  475. ADD KEY `money` (`money`),
  476. ADD KEY `meta` (`meta`),
  477. ADD KEY `steamname` (`steamname`);
  478.  
  479. --
  480. -- Index för tabell `character_inventories`
  481. --
  482. ALTER TABLE `character_inventories`
  483. ADD KEY `character_inventory_idx` (`character_id`,`inventory_type`);
  484.  
  485. --
  486. -- Index för tabell `doors`
  487. --
  488. ALTER TABLE `doors`
  489. ADD PRIMARY KEY (`id`);
  490.  
  491. --
  492. -- Index för tabell `herbalists`
  493. --
  494. ALTER TABLE `herbalists`
  495. ADD PRIMARY KEY (`identifier`) USING BTREE,
  496. ADD UNIQUE KEY `identifier_charidentifier` (`identifier`,`charidentifier`) USING BTREE;
  497.  
  498. --
  499. -- Index för tabell `horse_complements`
  500. --
  501. ALTER TABLE `horse_complements`
  502. ADD UNIQUE KEY `identifier` (`identifier`) USING BTREE;
  503.  
  504. --
  505. -- Index för tabell `housing`
  506. --
  507. ALTER TABLE `housing`
  508. ADD PRIMARY KEY (`id`) USING BTREE;
  509.  
  510. --
  511. -- Index för tabell `items`
  512. --
  513. ALTER TABLE `items`
  514. ADD PRIMARY KEY (`item`) USING BTREE,
  515. ADD UNIQUE KEY `id` (`id`) USING BTREE,
  516. ADD KEY `FK_items_item_group` (`groupId`) USING BTREE;
  517.  
  518. --
  519. -- Index för tabell `items_crafted`
  520. --
  521. ALTER TABLE `items_crafted`
  522. ADD PRIMARY KEY (`id`),
  523. ADD UNIQUE KEY `ID` (`id`),
  524. ADD KEY `crafted_item_idx` (`character_id`);
  525.  
  526. --
  527. -- Index för tabell `item_group`
  528. --
  529. ALTER TABLE `item_group`
  530. ADD PRIMARY KEY (`id`);
  531.  
  532. --
  533. -- Index för tabell `loadout`
  534. --
  535. ALTER TABLE `loadout`
  536. ADD PRIMARY KEY (`id`),
  537. ADD KEY `id` (`id`);
  538.  
  539. --
  540. -- Index för tabell `mailbox_mails`
  541. --
  542. ALTER TABLE `mailbox_mails`
  543. ADD PRIMARY KEY (`id`);
  544.  
  545. --
  546. -- Index för tabell `outfits`
  547. --
  548. ALTER TABLE `outfits`
  549. ADD PRIMARY KEY (`id`) USING BTREE;
  550.  
  551. --
  552. -- Index för tabell `player_backpacks`
  553. --
  554. ALTER TABLE `player_backpacks`
  555. ADD PRIMARY KEY (`id`);
  556.  
  557. --
  558. -- Index för tabell `rooms`
  559. --
  560. ALTER TABLE `rooms`
  561. ADD PRIMARY KEY (`id`) USING BTREE;
  562.  
  563. --
  564. -- Index för tabell `stables`
  565. --
  566. ALTER TABLE `stables`
  567. ADD PRIMARY KEY (`id`) USING BTREE;
  568.  
  569. --
  570. -- Index för tabell `users`
  571. --
  572. ALTER TABLE `users`
  573. ADD PRIMARY KEY (`identifier`),
  574. ADD UNIQUE KEY `identifier` (`identifier`);
  575.  
  576. --
  577. -- Index för tabell `wagons`
  578. --
  579. ALTER TABLE `wagons`
  580. ADD PRIMARY KEY (`id`),
  581. ADD KEY `FK_horses_characters` (`charid`),
  582. ADD KEY `model` (`model`);
  583.  
  584. --
  585. -- Index för tabell `whitelist`
  586. --
  587. ALTER TABLE `whitelist`
  588. ADD PRIMARY KEY (`id`) USING BTREE,
  589. ADD UNIQUE KEY `identifier` (`identifier`) USING BTREE;
  590.  
  591. --
  592. -- AUTO_INCREMENT för dumpade tabeller
  593. --
  594.  
  595. --
  596. -- AUTO_INCREMENT för tabell `bank_users`
  597. --
  598. ALTER TABLE `bank_users`
  599. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  600.  
  601. --
  602. -- AUTO_INCREMENT för tabell `banneds`
  603. --
  604. ALTER TABLE `banneds`
  605. MODIFY `b_id` int(11) NOT NULL AUTO_INCREMENT;
  606.  
  607. --
  608. -- AUTO_INCREMENT för tabell `bills`
  609. --
  610. ALTER TABLE `bills`
  611. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  612.  
  613. --
  614. -- AUTO_INCREMENT för tabell `characters`
  615. --
  616. ALTER TABLE `characters`
  617. MODIFY `charidentifier` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  618.  
  619. --
  620. -- AUTO_INCREMENT för tabell `doors`
  621. --
  622. ALTER TABLE `doors`
  623. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  624.  
  625. --
  626. -- AUTO_INCREMENT för tabell `housing`
  627. --
  628. ALTER TABLE `housing`
  629. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34307;
  630.  
  631. --
  632. -- AUTO_INCREMENT för tabell `items`
  633. --
  634. ALTER TABLE `items`
  635. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  636.  
  637. --
  638. -- AUTO_INCREMENT för tabell `items_crafted`
  639. --
  640. ALTER TABLE `items_crafted`
  641. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  642.  
  643. --
  644. -- AUTO_INCREMENT för tabell `item_group`
  645. --
  646. ALTER TABLE `item_group`
  647. MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  648.  
  649. --
  650. -- AUTO_INCREMENT för tabell `loadout`
  651. --
  652. ALTER TABLE `loadout`
  653. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  654.  
  655. --
  656. -- AUTO_INCREMENT för tabell `mailbox_mails`
  657. --
  658. ALTER TABLE `mailbox_mails`
  659. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  660.  
  661. --
  662. -- AUTO_INCREMENT för tabell `outfits`
  663. --
  664. ALTER TABLE `outfits`
  665. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  666.  
  667. --
  668. -- AUTO_INCREMENT för tabell `player_backpacks`
  669. --
  670. ALTER TABLE `player_backpacks`
  671. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  672.  
  673. --
  674. -- AUTO_INCREMENT för tabell `rooms`
  675. --
  676. ALTER TABLE `rooms`
  677. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  678.  
  679. --
  680. -- AUTO_INCREMENT för tabell `stables`
  681. --
  682. ALTER TABLE `stables`
  683. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  684.  
  685. --
  686. -- AUTO_INCREMENT för tabell `wagons`
  687. --
  688. ALTER TABLE `wagons`
  689. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  690.  
  691. --
  692. -- AUTO_INCREMENT för tabell `whitelist`
  693. --
  694. ALTER TABLE `whitelist`
  695. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
  696.  
  697. --
  698. -- Restriktioner för dumpade tabeller
  699. --
  700.  
  701. --
  702. -- Restriktioner för tabell `bank_users`
  703. --
  704. ALTER TABLE `bank_users`
  705. ADD CONSTRAINT `bankusers` FOREIGN KEY (`identifier`) REFERENCES `users` (`identifier`) ON DELETE CASCADE ON UPDATE CASCADE;
  706.  
  707. --
  708. -- Restriktioner för tabell `characters`
  709. --
  710. ALTER TABLE `characters`
  711. ADD CONSTRAINT `FK_characters_users` FOREIGN KEY (`identifier`) REFERENCES `users` (`identifier`) ON DELETE CASCADE ON UPDATE CASCADE;
  712.  
  713. --
  714. -- Restriktioner för tabell `items`
  715. --
  716. ALTER TABLE `items`
  717. ADD CONSTRAINT `FK_items_item_group` FOREIGN KEY (`groupId`) REFERENCES `item_group` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
  718. COMMIT;
  719.  
  720. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  721. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  722. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  723.  
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!