DayZ | 100+ Buildables SQL script

/*
Navicat MySQL Data Transfer

Source Server         : DayZ server
Source Server Version : 50616
Source Host           : localhost:3306
Source Database       : overwatch

Target Server Type    : MYSQL
Target Server Version : 50616
File Encoding         : 65001

Date: 2014-04-12 22:45:24
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `deployable`
-- ----------------------------
DROP TABLE IF EXISTS `deployable`;
CREATE TABLE `deployable` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `class_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq1_deployable` (`class_name`)
) ENGINE=InnoDB AUTO_INCREMENT=302 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of deployable
-- ----------------------------
INSERT INTO `deployable` VALUES ('248', '76n6ClamShell');
INSERT INTO `deployable` VALUES ('249', 'Barrack2');
INSERT INTO `deployable` VALUES ('56', 'Base_WarfareBBarrier10x');
INSERT INTO `deployable` VALUES ('53', 'Base_WarfareBBarrier10xTall');
INSERT INTO `deployable` VALUES ('264', 'BearTrap_DZ');
INSERT INTO `deployable` VALUES ('41', 'CamoNet');
INSERT INTO `deployable` VALUES ('224', 'CamoNet_DZ');
INSERT INTO `deployable` VALUES ('243', 'Camp');
INSERT INTO `deployable` VALUES ('200', 'CampEast_EP1');
INSERT INTO `deployable` VALUES ('290', 'CDF_WarfareBUAVterminal');
INSERT INTO `deployable` VALUES ('38', 'Concrete_Wall_EP1');
INSERT INTO `deployable` VALUES ('42', 'DeerStand');
INSERT INTO `deployable` VALUES ('225', 'DomeTentStorage');
INSERT INTO `deployable` VALUES ('22', 'Fence_corrugated_plate');
INSERT INTO `deployable` VALUES ('33', 'Fence_Ind');
INSERT INTO `deployable` VALUES ('31', 'Fence_Ind_long');
INSERT INTO `deployable` VALUES ('291', 'FlagCarrierBAF');
INSERT INTO `deployable` VALUES ('292', 'FlagCarrierBIS_EP1');
INSERT INTO `deployable` VALUES ('293', 'FlagCarrierBLUFOR_EP1');
INSERT INTO `deployable` VALUES ('295', 'FlagCarrierCDFEnsign_EP1');
INSERT INTO `deployable` VALUES ('294', 'FlagCarrierCDF_EP1');
INSERT INTO `deployable` VALUES ('296', 'FlagCarrierCzechRepublic_EP1');
INSERT INTO `deployable` VALUES ('297', 'FlagCarrierGermany_EP1');
INSERT INTO `deployable` VALUES ('298', 'FlagCarrierINDFOR_EP1');
INSERT INTO `deployable` VALUES ('299', 'FlagCarrierUSA_EP1');
INSERT INTO `deployable` VALUES ('32', 'Fort_RazorWire');
INSERT INTO `deployable` VALUES ('52', 'Gate1_DZ');
INSERT INTO `deployable` VALUES ('35', 'Grave');
INSERT INTO `deployable` VALUES ('209', 'GuerillaCacheBox');
INSERT INTO `deployable` VALUES ('47', 'HBarrier');
INSERT INTO `deployable` VALUES ('4', 'Hedgehog_DZ');
INSERT INTO `deployable` VALUES ('114', 'HeliHCivil');
INSERT INTO `deployable` VALUES ('19', 'Hhedgehog_concrete');
INSERT INTO `deployable` VALUES ('208', 'Hhedgehog_concreteBig');
INSERT INTO `deployable` VALUES ('39', 'Infostand_2_EP1');
INSERT INTO `deployable` VALUES ('17', 'Ins_WarfareBContructionSite');
INSERT INTO `deployable` VALUES ('51', 'LadderSmall');
INSERT INTO `deployable` VALUES ('112', 'Land_arrows_desk_L');
INSERT INTO `deployable` VALUES ('111', 'Land_arrows_desk_R');
INSERT INTO `deployable` VALUES ('211', 'Land_A_Castle_Bastion');
INSERT INTO `deployable` VALUES ('212', 'Land_A_Castle_Bergfrit');
INSERT INTO `deployable` VALUES ('213', 'Land_A_Castle_Donjon');
INSERT INTO `deployable` VALUES ('214', 'Land_A_Castle_Gate');
INSERT INTO `deployable` VALUES ('215', 'Land_A_Castle_Stairs_A');
INSERT INTO `deployable` VALUES ('216', 'Land_A_Castle_Wall1_20');
INSERT INTO `deployable` VALUES ('217', 'Land_A_Castle_Wall1_Corner');
INSERT INTO `deployable` VALUES ('218', 'Land_A_Castle_Wall1_End');
INSERT INTO `deployable` VALUES ('219', 'Land_A_Castle_Wall2_30');
INSERT INTO `deployable` VALUES ('220', 'Land_A_Castle_Wall2_Corner');
INSERT INTO `deployable` VALUES ('221', 'Land_A_Castle_Wall2_End');
INSERT INTO `deployable` VALUES ('106', 'Land_A_FuelStation_Build');
INSERT INTO `deployable` VALUES ('107', 'Land_A_FuelStation_Shed');
INSERT INTO `deployable` VALUES ('255', 'Land_a_stationhouse');
INSERT INTO `deployable` VALUES ('40', 'Land_BagFenceRound');
INSERT INTO `deployable` VALUES ('257', 'Land_Barn_W_02');
INSERT INTO `deployable` VALUES ('203', 'Land_Barrack2');
INSERT INTO `deployable` VALUES ('201', 'Land_Barrack2_EP1');
INSERT INTO `deployable` VALUES ('25', 'Land_CamoNetB_EAST');
INSERT INTO `deployable` VALUES ('26', 'Land_CamoNetB_NATO');
INSERT INTO `deployable` VALUES ('27', 'Land_CamoNetVar_EAST');
INSERT INTO `deployable` VALUES ('28', 'Land_CamoNetVar_NATO');
INSERT INTO `deployable` VALUES ('29', 'Land_CamoNet_EAST');
INSERT INTO `deployable` VALUES ('30', 'Land_CamoNet_NATO');
INSERT INTO `deployable` VALUES ('239', 'Land_Campfire');
INSERT INTO `deployable` VALUES ('54', 'Land_CncBlock');
INSERT INTO `deployable` VALUES ('113', 'Land_CncBlock_Stripes');
INSERT INTO `deployable` VALUES ('258', 'Land_ConcreteRamp');
INSERT INTO `deployable` VALUES ('109', 'Land_coneLight');
INSERT INTO `deployable` VALUES ('252', 'Land_covering_hut_big_EP1');
INSERT INTO `deployable` VALUES ('259', 'Land_Dam_Barrier_40');
INSERT INTO `deployable` VALUES ('260', 'Land_dum_istan3_hromada2');
INSERT INTO `deployable` VALUES ('101', 'Land_Fire_barrel_burning');
INSERT INTO `deployable` VALUES ('10', 'Land_fortified_nest_big');
INSERT INTO `deployable` VALUES ('14', 'Land_fortified_nest_small');
INSERT INTO `deployable` VALUES ('250', 'Land_fort_artillery_nest');
INSERT INTO `deployable` VALUES ('207', 'Land_fort_bagfence_corner');
INSERT INTO `deployable` VALUES ('34', 'Land_fort_bagfence_long');
INSERT INTO `deployable` VALUES ('206', 'Land_fort_bagfence_round');
INSERT INTO `deployable` VALUES ('251', 'Land_fort_rampart');
INSERT INTO `deployable` VALUES ('12', 'Land_fort_rampart_EP1');
INSERT INTO `deployable` VALUES ('11', 'Land_Fort_Watchtower');
INSERT INTO `deployable` VALUES ('204', 'Land_Hangar_2');
INSERT INTO `deployable` VALUES ('13', 'Land_HBarrier_large');
INSERT INTO `deployable` VALUES ('202', 'Land_Hlidac_Budka_EP1');
INSERT INTO `deployable` VALUES ('120', 'Land_hruzdum');
INSERT INTO `deployable` VALUES ('261', 'Land_hut_old02');
INSERT INTO `deployable` VALUES ('115', 'Land_Ind_IlluminantTower');
INSERT INTO `deployable` VALUES ('103', 'Land_Ind_SawMillPen');
INSERT INTO `deployable` VALUES ('102', 'Land_Ind_TankSmall2_EP1');
INSERT INTO `deployable` VALUES ('238', 'Land_komin');
INSERT INTO `deployable` VALUES ('240', 'Land_ladder');
INSERT INTO `deployable` VALUES ('121', 'Land_leseni4x');
INSERT INTO `deployable` VALUES ('262', 'Land_majak2');
INSERT INTO `deployable` VALUES ('263', 'Land_majak_podesta');
INSERT INTO `deployable` VALUES ('222', 'Land_Misc_Cargo1D');
INSERT INTO `deployable` VALUES ('15', 'Land_Misc_Cargo2E');
INSERT INTO `deployable` VALUES ('105', 'Land_Misc_deerstand');
INSERT INTO `deployable` VALUES ('266', 'land_nav_pier_c');
INSERT INTO `deployable` VALUES ('286', 'land_nav_pier_c2');
INSERT INTO `deployable` VALUES ('287', 'land_nav_pier_c2_end');
INSERT INTO `deployable` VALUES ('268', 'land_nav_pier_c_270');
INSERT INTO `deployable` VALUES ('267', 'land_nav_pier_c_90');
INSERT INTO `deployable` VALUES ('269', 'land_nav_pier_c_big');
INSERT INTO `deployable` VALUES ('270', 'land_nav_pier_C_L10');
INSERT INTO `deployable` VALUES ('281', 'land_nav_pier_C_R');
INSERT INTO `deployable` VALUES ('282', 'land_nav_pier_C_R10');
INSERT INTO `deployable` VALUES ('283', 'land_nav_pier_C_R30');
INSERT INTO `deployable` VALUES ('284', 'land_nav_pier_c_t15');
INSERT INTO `deployable` VALUES ('285', 'land_nav_pier_c_t20');
INSERT INTO `deployable` VALUES ('288', 'land_nav_pier_m_1');
INSERT INTO `deployable` VALUES ('289', 'land_nav_pier_m_end');
INSERT INTO `deployable` VALUES ('21', 'Land_prebehlavka');
INSERT INTO `deployable` VALUES ('18', 'Land_pumpa');
INSERT INTO `deployable` VALUES ('108', 'Land_radar');
INSERT INTO `deployable` VALUES ('110', 'Land_RedWhiteBarrier');
INSERT INTO `deployable` VALUES ('253', 'Land_Shed_Ind02');
INSERT INTO `deployable` VALUES ('223', 'Land_Shed_wooden');
INSERT INTO `deployable` VALUES ('24', 'Land_tent_east');
INSERT INTO `deployable` VALUES ('116', 'Land_vez');
INSERT INTO `deployable` VALUES ('205', 'Land_Wall_Gate_Ind1_L');
INSERT INTO `deployable` VALUES ('265', 'Land_Wall_Gate_Kolchoz');
INSERT INTO `deployable` VALUES ('254', 'Land_water_tank');
INSERT INTO `deployable` VALUES ('246', 'Land_WoodenRamp');
INSERT INTO `deployable` VALUES ('244', 'MASH');
INSERT INTO `deployable` VALUES ('247', 'Mi8Wreck');
INSERT INTO `deployable` VALUES ('16', 'Misc_Cargo1Bo_military');
INSERT INTO `deployable` VALUES ('241', 'Misc_Cargo1B_military');
INSERT INTO `deployable` VALUES ('20', 'Misc_cargo_cont_small_EP1');
INSERT INTO `deployable` VALUES ('245', 'PARACHUTE_TARGET');
INSERT INTO `deployable` VALUES ('300', 'PowerGenerator_EP1');
INSERT INTO `deployable` VALUES ('242', 'RoadBarrier_light');
INSERT INTO `deployable` VALUES ('210', 'RoadBarrier_long');
INSERT INTO `deployable` VALUES ('5', 'Sandbag1_DZ');
INSERT INTO `deployable` VALUES ('49', 'Sandbag2_DZ');
INSERT INTO `deployable` VALUES ('50', 'Sandbag3_DZ');
INSERT INTO `deployable` VALUES ('45', 'SandBagNest');
INSERT INTO `deployable` VALUES ('48', 'Scaffolding');
INSERT INTO `deployable` VALUES ('117', 'SearchLight');
INSERT INTO `deployable` VALUES ('119', 'SignM_UN_Base_EP1');
INSERT INTO `deployable` VALUES ('118', 'Sign_Danger');
INSERT INTO `deployable` VALUES ('7', 'StashMedium');
INSERT INTO `deployable` VALUES ('6', 'StashSmall');
INSERT INTO `deployable` VALUES ('1', 'TentStorage');
INSERT INTO `deployable` VALUES ('2', 'TrapBear');
INSERT INTO `deployable` VALUES ('232', 'TrapBearTrapFlare');
INSERT INTO `deployable` VALUES ('233', 'TrapBearTrapSmoke');
INSERT INTO `deployable` VALUES ('234', 'TrapTripwireFlare');
INSERT INTO `deployable` VALUES ('235', 'TrapTripwireGrenade');
INSERT INTO `deployable` VALUES ('236', 'TrapTripwireSmoke');
INSERT INTO `deployable` VALUES ('237', 'Trap_Cans');
INSERT INTO `deployable` VALUES ('301', 'USVehicleBox_EP1');
INSERT INTO `deployable` VALUES ('256', 'WarfareBAirport');
INSERT INTO `deployable` VALUES ('55', 'WarfareBCamp');
INSERT INTO `deployable` VALUES ('57', 'WarfareBDepot');
INSERT INTO `deployable` VALUES ('44', 'WatchTower');
INSERT INTO `deployable` VALUES ('46', 'Wire2');
INSERT INTO `deployable` VALUES ('3', 'Wire_cat1');
INSERT INTO `deployable` VALUES ('23', 'ZavoraAnim');