Advertisement
Guest User

Untitled

a guest
Jun 30th, 2015
318
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.69 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.3.11
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: 01-Jul-2015 às 02:03
  7. -- Versão do servidor: 5.6.24
  8. -- PHP Version: 5.6.8
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18.  
  19. --
  20. -- Database: `owl_mta`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Estrutura da tabela `duty_allowed`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `duty_allowed` (
  30.   `id` INT(11) NOT NULL,
  31.   `faction` INT(11) NOT NULL,
  32.   `itemID` INT(11) NOT NULL,
  33.   `itemValue` VARCHAR(45) NOT NULL DEFAULT '1'
  34. ) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=latin1 COMMENT='Used for an admin allow list.';
  35.  
  36. --
  37. -- Extraindo dados da tabela `duty_allowed`
  38. --
  39.  
  40. INSERT INTO `duty_allowed` (`id`, `faction`, `itemID`, `itemValue`) VALUES
  41. (1, 1, 45, '1'),
  42. (2, 1, 1, '1'),
  43. (3, 1, 26, '1'),
  44. (5, 4, -41, '50000'),
  45. (6, 4, -43, '500'),
  46. (8, 4, 46, ''),
  47. (9, 4, 57, '500'),
  48. (11, 4, 126, 'Rapid'),
  49. (12, 4, 183, ''),
  50. (13, 4, 118, ''),
  51. (15, 11, -41, '1500'),
  52. (16, 11, -43, '250'),
  53. (17, 1, -31, '250'),
  54. (18, 1, -24, '35'),
  55. (19, 1, -29, '150'),
  56. (20, 1, -34, '10'),
  57. (21, 1, -33, '10'),
  58. (22, 1, -23, '68'),
  59. (23, 1, -25, '50'),
  60. (24, 1, -27, '35'),
  61. (25, 1, -43, '50'),
  62. (26, 1, -44, '1'),
  63. (27, 1, -45, '1'),
  64. (28, 1, -46, '1'),
  65. (29, 1, -17, '5'),
  66. (30, 1, -3, '1'),
  67. (31, 1, 126, '1'),
  68. (33, 1, 137, '1'),
  69. (34, 1, 13, ''),
  70. (35, 1, 83, ''),
  71. (36, 1, 29, ''),
  72. (37, 1, 56, ''),
  73. (38, 1, -4, '1'),
  74. (39, 11, 26, '1'),
  75. (40, 11, 27, '1'),
  76. (41, 11, 45, '1'),
  77. (43, 11, 137, '1'),
  78. (46, 11, 177, '1'),
  79. (47, 11, 113, '5'),
  80. (48, 11, 126, '1'),
  81. (50, 11, -3, '1'),
  82. (51, 11, -25, '20'),
  83. (52, 11, -27, '30'),
  84. (53, 11, -29, '90'),
  85. (55, 11, -23, '68'),
  86. (56, 11, -24, '50'),
  87. (57, 11, -31, '250'),
  88. (59, 11, -34, '20'),
  89. (60, 11, -33, '40'),
  90. (61, 11, -17, '2'),
  91. (62, 11, -42, '2000'),
  92. (63, 11, -44, '1'),
  93. (64, 11, -46, '1'),
  94. (65, 11, -45, '1'),
  95. (66, 11, 80, 'Recording Device'),
  96. (67, 11, 0, '100'),
  97. (68, 1, 27, '4'),
  98. (69, 1, -100, '100'),
  99. (73, 11, -100, '200'),
  100. (74, 1, 120, ''),
  101. (75, 4, 96, ''),
  102. (76, 7, 126, 'FAA'),
  103. (77, 7, 163, 'FAA'),
  104. (78, 7, 174, 'FAA'),
  105. (79, 7, -41, '500'),
  106. (80, 7, -100, '200'),
  107. (82, 7, -24, '50'),
  108. (83, 7, -31, '100'),
  109. (84, 7, -43, '100'),
  110. (85, 7, 45, 'FAA'),
  111. (86, 8, -31, '250'),
  112. (87, 8, -24, '50'),
  113. (88, 8, -29, '200'),
  114. (89, 8, -27, '150'),
  115. (90, 8, -23, '50'),
  116. (91, 8, -43, '50'),
  117. (92, 8, -34, '20'),
  118. (93, 8, -17, '5'),
  119. (94, 8, -100, '100'),
  120. (95, 8, 66, ''),
  121. (96, 8, 45, ''),
  122. (97, 8, 137, ''),
  123. (98, 8, 29, ''),
  124. (99, 8, 27, ''),
  125. (100, 8, 26, ''),
  126. (101, 8, 56, ''),
  127. (102, 8, 76, ''),
  128. (103, 8, 120, ''),
  129. (104, 8, 163, ''),
  130. (105, 12, -42, '500'),
  131. (106, 12, -43, '1'),
  132. (107, 12, -9, '1'),
  133. (110, 12, 141, '1'),
  134. (112, 2, -42, '1000'),
  135. (113, 2, -9, '0'),
  136. (114, 2, 26, 'Gas Mask'),
  137. (115, 2, 70, 'BLS Kit'),
  138. (116, 2, 113, 'Glowsticks'),
  139. (117, 2, 120, 'Scuba Gear'),
  140. (118, 2, 145, 'Flashlight'),
  141. (119, 2, 164, '');
  142.  
  143. --
  144. -- Indexes for dumped tables
  145. --
  146.  
  147. --
  148. -- Indexes for table `duty_allowed`
  149. --
  150. ALTER TABLE `duty_allowed`
  151.   ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id_UNIQUE` (`id`);
  152.  
  153. --
  154. -- AUTO_INCREMENT for dumped tables
  155. --
  156.  
  157. --
  158. -- AUTO_INCREMENT for table `duty_allowed`
  159. --
  160. ALTER TABLE `duty_allowed`
  161.   MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=120;
  162. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  163. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  164. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement