Advertisement
Guest User

Untitled

a guest
Aug 8th, 2019
2,211
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. USE `fivem`;
  2.  
  3. CREATE TABLE IF NOT EXISTS `users` (
  4. `identifier` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  5. `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  6. `money` int(11) DEFAULT NULL,
  7. `bank` int(11) DEFAULT NULL,
  8. `permission_level` int(11) DEFAULT NULL,
  9. `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  10. PRIMARY KEY (`identifier`)
  11. );
  12.  
  13. ALTER TABLE `users`
  14. ADD COLUMN `name` VARCHAR(50) NULL DEFAULT '' AFTER `money`,
  15. ADD COLUMN `skin` LONGTEXT NULL AFTER `name`,
  16. ADD COLUMN `job` varchar(50) NULL DEFAULT 'unemployed' AFTER `skin`,
  17. ADD COLUMN `job_grade` INT NULL DEFAULT 0 AFTER `job`,
  18. ADD COLUMN `loadout` LONGTEXT NULL AFTER `job_grade`,
  19. ADD COLUMN `position` VARCHAR(36) NULL AFTER `loadout`
  20. ;
  21.  
  22. CREATE TABLE `items` (
  23. `name` varchar(50) NOT NULL,
  24. `label` varchar(50) NOT NULL,
  25. `limit` int(11) NOT NULL DEFAULT '-1',
  26. `rare` int(11) NOT NULL DEFAULT '0',
  27. `can_remove` int(11) NOT NULL DEFAULT '1',
  28.  
  29. PRIMARY KEY (`name`)
  30. );
  31.  
  32. CREATE TABLE `job_grades` (
  33. `id` int(11) NOT NULL AUTO_INCREMENT,
  34. `job_name` varchar(50) DEFAULT NULL,
  35. `grade` int(11) NOT NULL,
  36. `name` varchar(50) NOT NULL,
  37. `label` varchar(50) NOT NULL,
  38. `salary` int(11) NOT NULL,
  39. `skin_male` longtext NOT NULL,
  40. `skin_female` longtext NOT NULL,
  41.  
  42. PRIMARY KEY (`id`)
  43. );
  44.  
  45. INSERT INTO `job_grades` VALUES (1,'unemployed',0,'unemployed','Unemployed',200,'{}','{}');
  46.  
  47. CREATE TABLE `jobs` (
  48. `name` varchar(50) NOT NULL,
  49. `label` varchar(50) DEFAULT NULL,
  50.  
  51. PRIMARY KEY (`name`)
  52. );
  53.  
  54. INSERT INTO `jobs` VALUES ('unemployed','Unemployed');
  55.  
  56. CREATE TABLE `user_accounts` (
  57. `id` int(11) NOT NULL AUTO_INCREMENT,
  58. `identifier` varchar(22) NOT NULL,
  59. `name` varchar(50) NOT NULL,
  60. `money` double NOT NULL DEFAULT '0',
  61.  
  62. PRIMARY KEY (`id`)
  63. );
  64.  
  65. CREATE TABLE `user_inventory` (
  66. `id` int(11) NOT NULL AUTO_INCREMENT,
  67. `identifier` varchar(22) NOT NULL,
  68. `item` varchar(50) NOT NULL,
  69. `count` int(11) NOT NULL,
  70.  
  71. PRIMARY KEY (`id`)
  72. );
Advertisement
RAW Paste Data Copied
Advertisement