Advertisement
Guest User

Untitled

a guest
Jul 24th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.21 KB | None | 0 0
  1. [SQL] Query gta5_gamemode_essential start
  2. [ERR] 1050 - Table 'bans' already exists
  3. [ERR] -- phpMyAdmin SQL Dump
  4. -- version 4.6.4
  5. -- https://www.phpmyadmin.net/
  6. --
  7. -- Host: 127.0.0.1
  8. -- Generation Time: Jul 11, 2017 at 05:20 PM
  9. -- Server version: 5.7.14
  10. -- PHP Version: 5.6.25
  11.  
  12. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Database: `gta5_gamemode_essential`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `bans`
  29. --
  30.  
  31. CREATE TABLE `bans` (
  32. `id` int(10) UNSIGNED NOT NULL,
  33. `banned` varchar(50) NOT NULL DEFAULT '0',
  34. `banner` varchar(50) NOT NULL,
  35. `reason` varchar(150) NOT NULL DEFAULT '0',
  36. `expires` datetime NOT NULL,
  37. `timestamp` datetime NOT NULL
  38. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  39.  
  40. -- --------------------------------------------------------
  41.  
  42. --
  43. -- Table structure for table `clothes_outfits`
  44. --
  45.  
  46. CREATE TABLE `clothes_outfits` (
  47. `id` int(11) NOT NULL,
  48. `name` varchar(50) NOT NULL DEFAULT '0',
  49. `category` varchar(50) NOT NULL DEFAULT '0',
  50. `skin_model` varchar(50) NOT NULL DEFAULT '0',
  51. `price` int(11) NOT NULL DEFAULT '0',
  52. `arm` int(11) NOT NULL DEFAULT '0',
  53. `arm_txt` int(11) NOT NULL DEFAULT '0',
  54. `tshirt` int(11) NOT NULL DEFAULT '0',
  55. `tshirt_txt` int(11) NOT NULL DEFAULT '0',
  56. `jacket` int(11) NOT NULL DEFAULT '0',
  57. `jacket_txt` int(11) NOT NULL DEFAULT '0',
  58. `pant` int(11) NOT NULL DEFAULT '0',
  59. `pant_txt` int(11) NOT NULL DEFAULT '0',
  60. `shoe` int(11) NOT NULL DEFAULT '0',
  61. `shoe_txt` int(11) NOT NULL DEFAULT '0',
  62. `glasses` int(11) NOT NULL DEFAULT '0',
  63. `glasses_txt` int(11) NOT NULL DEFAULT '0',
  64. `hat` int(11) NOT NULL DEFAULT '0',
  65. `hat_txt` int(11) NOT NULL DEFAULT '0',
  66. `mask` int(11) NOT NULL DEFAULT '0',
  67. `mask_txt` int(11) NOT NULL DEFAULT '0',
  68. `shield` int(11) NOT NULL DEFAULT '0',
  69. `shield_txt` int(11) NOT NULL DEFAULT '0'
  70. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  71.  
  72. --
  73. -- Dumping data for table `clothes_outfits`
  74. --
  75.  
  76. INSERT INTO `clothes_outfits` (`id`, `name`, `category`, `skin_model`, `price`, `arm`, `arm_txt`, `tshirt`, `tshirt_txt`, `jacket`, `jacket_txt`, `pant`, `pant_txt`, `shoe`, `shoe_txt`, `glasses`, `glasses_txt`, `hat`, `hat_txt`, `mask`, `mask_txt`, `shield`, `shield_txt`) VALUES
  77. (3, 'Négligé', 'skincreator', 'mp_m_freemode_01', 1500, 0, 0, 15, 0, 22, 1, 5, 0, 12, 6, 0, 0, 0, 0, 0, 0, 0, 0),
  78. (2, 'Mauvais Goût', 'skincreator', 'mp_m_freemode_01', 1500, 5, 0, 15, 0, 5, 0, 12, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  79. (1, 'Bronzage', 'skincreator', 'mp_m_freemode_01', 1500, 5, 0, 15, 0, 5, 7, 16, 11, 16, 9, 0, 0, 0, 0, 0, 0, 0, 0),
  80. (4, 'Ordinaire', 'skincreator', 'mp_m_freemode_01', 1500, 6, 0, 5, 0, 3, 0, 2, 11, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  81. (5, 'Le Quartier', 'skincreator', 'mp_m_freemode_01', 1500, 6, 0, 5, 2, 7, 0, 7, 12, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  82. (6, 'Sportif', 'skincreator', 'mp_m_freemode_01', 1500, 6, 0, 0, 3, 3, 15, 3, 15, 2, 6, 0, 0, 0, 0, 0, 0, 0, 0),
  83. (21, 'Gangsta', 'skincreator', 'mp_f_freemode_01', 1500, 4, 0, 15, 0, 5, 0, 3, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0),
  84. (22, 'Garçon manqué', 'skincreator', 'mp_f_freemode_01', 1500, 3, 0, 14, 0, 3, 1, 1, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  85. (23, 'Normale', 'skincreator', 'mp_f_freemode_01', 1500, 4, 0, 14, 0, 0, 11, 1, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  86. (24, 'Jeune', 'skincreator', 'mp_f_freemode_01', 1500, 1, 0, 0, 9, 1, 11, 8, 7, 3, 5, 0, 0, 0, 0, 0, 0, 0, 0),
  87. (25, 'Sportive', 'skincreator', 'mp_f_freemode_01', 1500, 1, 0, 22, 2, 10, 0, 14, 0, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  88. (26, 'Diablesse', 'skincreator', 'mp_f_freemode_01', 1500, 15, 0, 15, 0, 4, 13, 2, 2, 11, 3, 0, 0, 0, 0, 0, 0, 0, 0),
  89. (7, 'Street', 'skincreator', 'mp_m_freemode_01', 1500, 4, 0, 15, 0, 14, 13, 9, 7, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0),
  90. (8, 'Loveur', 'skincreator', 'mp_m_freemode_01', 2000, 4, 0, 21, 1, 4, 2, 20, 0, 18, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  91. (9, 'Plage', 'skincreator', 'mp_m_freemode_01', 750, 5, 0, 15, 1, 17, 2, 14, 12, 34, 0,
  92. [SQL] Finished successfully with error
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement