-- phpMyAdmin SQL Dump -- version 4.3.11 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: 01-Jul-2015 às 02:03 -- Versão do servidor: 5.6.24 -- PHP Version: 5.6.8 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `owl_mta` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `duty_allowed` -- CREATE TABLE IF NOT EXISTS `duty_allowed` ( `id` int(11) NOT NULL, `faction` int(11) NOT NULL, `itemID` int(11) NOT NULL, `itemValue` varchar(45) NOT NULL DEFAULT '1' ) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=latin1 COMMENT='Used for an admin allow list.'; -- -- Extraindo dados da tabela `duty_allowed` -- INSERT INTO `duty_allowed` (`id`, `faction`, `itemID`, `itemValue`) VALUES (1, 1, 45, '1'), (2, 1, 1, '1'), (3, 1, 26, '1'), (5, 4, -41, '50000'), (6, 4, -43, '500'), (8, 4, 46, ''), (9, 4, 57, '500'), (11, 4, 126, 'Rapid'), (12, 4, 183, ''), (13, 4, 118, ''), (15, 11, -41, '1500'), (16, 11, -43, '250'), (17, 1, -31, '250'), (18, 1, -24, '35'), (19, 1, -29, '150'), (20, 1, -34, '10'), (21, 1, -33, '10'), (22, 1, -23, '68'), (23, 1, -25, '50'), (24, 1, -27, '35'), (25, 1, -43, '50'), (26, 1, -44, '1'), (27, 1, -45, '1'), (28, 1, -46, '1'), (29, 1, -17, '5'), (30, 1, -3, '1'), (31, 1, 126, '1'), (33, 1, 137, '1'), (34, 1, 13, ''), (35, 1, 83, ''), (36, 1, 29, ''), (37, 1, 56, ''), (38, 1, -4, '1'), (39, 11, 26, '1'), (40, 11, 27, '1'), (41, 11, 45, '1'), (43, 11, 137, '1'), (46, 11, 177, '1'), (47, 11, 113, '5'), (48, 11, 126, '1'), (50, 11, -3, '1'), (51, 11, -25, '20'), (52, 11, -27, '30'), (53, 11, -29, '90'), (55, 11, -23, '68'), (56, 11, -24, '50'), (57, 11, -31, '250'), (59, 11, -34, '20'), (60, 11, -33, '40'), (61, 11, -17, '2'), (62, 11, -42, '2000'), (63, 11, -44, '1'), (64, 11, -46, '1'), (65, 11, -45, '1'), (66, 11, 80, 'Recording Device'), (67, 11, 0, '100'), (68, 1, 27, '4'), (69, 1, -100, '100'), (73, 11, -100, '200'), (74, 1, 120, ''), (75, 4, 96, ''), (76, 7, 126, 'FAA'), (77, 7, 163, 'FAA'), (78, 7, 174, 'FAA'), (79, 7, -41, '500'), (80, 7, -100, '200'), (82, 7, -24, '50'), (83, 7, -31, '100'), (84, 7, -43, '100'), (85, 7, 45, 'FAA'), (86, 8, -31, '250'), (87, 8, -24, '50'), (88, 8, -29, '200'), (89, 8, -27, '150'), (90, 8, -23, '50'), (91, 8, -43, '50'), (92, 8, -34, '20'), (93, 8, -17, '5'), (94, 8, -100, '100'), (95, 8, 66, ''), (96, 8, 45, ''), (97, 8, 137, ''), (98, 8, 29, ''), (99, 8, 27, ''), (100, 8, 26, ''), (101, 8, 56, ''), (102, 8, 76, ''), (103, 8, 120, ''), (104, 8, 163, ''), (105, 12, -42, '500'), (106, 12, -43, '1'), (107, 12, -9, '1'), (110, 12, 141, '1'), (112, 2, -42, '1000'), (113, 2, -9, '0'), (114, 2, 26, 'Gas Mask'), (115, 2, 70, 'BLS Kit'), (116, 2, 113, 'Glowsticks'), (117, 2, 120, 'Scuba Gear'), (118, 2, 145, 'Flashlight'), (119, 2, 164, ''); -- -- Indexes for dumped tables -- -- -- Indexes for table `duty_allowed` -- ALTER TABLE `duty_allowed` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id_UNIQUE` (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `duty_allowed` -- ALTER TABLE `duty_allowed` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=120; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;