// Farms
ALTER TABLE `Farms` ADD `farm_name` VARCHAR(30) NOT NULL DEFAULT ' ' AFTER `farm_board_text`;

// Accounts
ALTER TABLE `nNHVrlXYmR` ADD `pFamQuest_4` VARCHAR(40) NOT NULL DEFAULT '0' AFTER `dialogstyle`;
ALTER TABLE `nNHVrlXYmR` ADD `pFamQuest_5` VARCHAR(40) NOT NULL DEFAULT '0' AFTER `pFamQuest_4`;
ALTER TABLE `nNHVrlXYmR` ADD `pFamQuest_6` VARCHAR(40) NOT NULL DEFAULT '0' AFTER `pFamQuest_5`;
ALTER TABLE `nNHVrlXYmR` ADD `pFamQuest_7` VARCHAR(40) NOT NULL DEFAULT '0' AFTER `pFamQuest_6`;
ALTER TABLE `nNHVrlXYmR` ADD `pFamQuest_8` VARCHAR(40) NOT NULL DEFAULT '0' AFTER `pFamQuest_7`;
ALTER TABLE `nNHVrlXYmR` ADD `pFamilyUninviteUnix` INT(11) NOT NULL DEFAULT '0' AFTER `pFamQuest_8`;
ALTER TABLE `nNHVrlXYmR` ADD `pBuyVideoCardUnix` INT(11) NOT NULL DEFAULT '0' AFTER `pFamilyUninviteUnix`;
ALTER TABLE `nNHVrlXYmR` ADD `pBoxIlonaMaskaTime` INT(11) NOT NULL DEFAULT '0' AFTER `pBuyVideoCardUnix`;

// ModelLimits
INSERT INTO `ModelLimit` (`model`, `value`) VALUES
(638, 0),
(639, 0),
(640, 0),
(641, 0),
(642, 0),
(643, 0),
(644, 0),
(645, 0),
(646, 0),
(647, 0),
(648, 0),
(649, 0),
(650, 0),
(651, 0),
(652, 0),
(653, 0),
(654, 0),
(655, 0),
(656, 0),
(657, 0),
(658, 0),
(659, 0),
(660, 0),
(661, 0),
(662, 0),
(663, 0),
(664, 0),
(665, 0),
(666, 0),
(667, 0),
(668, 0),
(669, 0),
(670, 0);

// Familys
ALTER TABLE `Familys` ADD `fRankSborDeneg` INT NOT NULL DEFAULT '1' COMMENT 'ранг доступа к автопарку семьи' AFTER `FlatTax`;

// Houses
ALTER TABLE `Houses` ADD `PodvalMiner` INT(11) NOT NULL DEFAULT '0' AFTER `PurchasePriceGos`;
ALTER TABLE `Houses` ADD `MinerSlot_1` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `PodvalMiner`;
ALTER TABLE `Houses` ADD `MinerSlot_2` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_1`;
ALTER TABLE `Houses` ADD `MinerSlot_3` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_2`;
ALTER TABLE `Houses` ADD `MinerSlot_4` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_3`;
ALTER TABLE `Houses` ADD `MinerSlot_5` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_4`;
ALTER TABLE `Houses` ADD `MinerSlot_6` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_5`;
ALTER TABLE `Houses` ADD `MinerSlot_7` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_6`;
ALTER TABLE `Houses` ADD `MinerSlot_8` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_7`;
ALTER TABLE `Houses` ADD `MinerSlot_9` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_8`;
ALTER TABLE `Houses` ADD `MinerSlot_10` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_9`;
ALTER TABLE `Houses` ADD `MinerSlot_11` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_10`;
ALTER TABLE `Houses` ADD `MinerSlot_12` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_11`;
ALTER TABLE `Houses` ADD `MinerSlot_13` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_12`;
ALTER TABLE `Houses` ADD `MinerSlot_14` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_13`;
ALTER TABLE `Houses` ADD `MinerSlot_15` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_14`;
ALTER TABLE `Houses` ADD `MinerSlot_16` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_15`;
ALTER TABLE `Houses` ADD `MinerSlot_17` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_16`;
ALTER TABLE `Houses` ADD `MinerSlot_18` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_17`;
ALTER TABLE `Houses` ADD `MinerSlot_19` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_18`;
ALTER TABLE `Houses` ADD `MinerSlot_20` VARCHAR(20) NOT NULL DEFAULT '0,0,0,0' AFTER `MinerSlot_19`;

// OrgsInfo
ALTER TABLE `OrgsInfo` ADD `oGangRespect` INT(11) NOT NULL DEFAULT '0' AFTER `oHeal`;

// Ownable
ALTER TABLE `Ownable` ADD `firstLoadVehicle` INT(11) NOT NULL DEFAULT '0' AFTER `PurchasePriceGos`;

// ZonesInfo
ALTER TABLE `ZonesInfo` ADD `Money` INT(11) NOT NULL DEFAULT '0' AFTER `Max_Y`;
ALTER TABLE `ZonesInfo` ADD `GangRespect` INT(11) NOT NULL DEFAULT '0' AFTER `Money`;


// Businesses
INSERT INTO Businesses (ID,State,Name,Owner,Enter_X,Enter_Y,Enter_Z,Exit_X,Exit_Y,Exit_Z,Cost,`Level`,Interior,`Lock`,Money,EnterPrice,Products,ProdPrice,Krasher,BuyCost,NeedItem,CostItem,Zam,Pribel,`Close`,EnterBarPrice,Enter_A,OrelLevel,bUniqName,InsuranceDischargeTerm,InsuranceDischargePercent,PurchasePriceGos,DiscountFamily_1,DiscountFamily_2,DiscountFamily_3) VALUES
     (269,11,'Отель','The State',13.7703,1229.32,19.3415,0.0,0.0,0.0,17000000,0,0,0,0,30,0,300,0,0,0,' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0','The State',' 0 0 0 0 0 0 0','',0,0.0,1,'',0,0,0,',0',',0',',0'),
     (270,11,'Отель','The State',-2193.34,-2254.05,33.3203,0.0,0.0,0.0,17000000,0,0,0,0,30,0,300,0,0,0,' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0','The State',' 0 0 0 0 0 0 0','',0,0.0,1,'',0,0,0,',0',',0',',0'),
     (271,7,'Закусочная','The State',-53.8409,1189.04,19.3594,1085.98,1004.95,1601.0,6000000,0,10,0,0,30,0,300,0,0,0,' 990 1500 2000 2500 3000 3500 4000 0 0 0 0 0 0 0 0 0 0 0 0 0','The State',' 0 0 0 0 0 0 0','',0,0.0,1,'',0,0,0,',0',',0',',0'),
     (272,7,'Закусочная','The State',-1912.17,827.954,35.2088,1085.98,1004.95,1601.0,6000000,0,10,0,0,30,0,300,0,0,0,' 990 1500 2000 2500 3000 3500 4000 0 0 0 0 0 0 0 0 0 0 0 0 0','The State',' 0 0 0 0 0 0 0','',0,0.0,1,'',0,0,0,',0',',0',',0'),
     (273,7,'Закусочная','The State',-144.085,1224.66,19.8992,1085.98,1004.95,1601.0,6000000,0,10,0,0,30,0,300,0,0,0,' 990 1500 2000 2500 3000 3500 4000 0 0 0 0 0 0 0 0 0 0 0 0 0','The State',' 0 0 0 0 0 0 0','',0,0.0,1,'',0,0,0,',0',',0',',0'),
     (274,3,'Магазин одежды','The State',-1882.53,866.198,35.1719,207.011,-140.115,1003.51,8500000,0,3,0,0,30,0,300,0,0,0,' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0','The State',' 0 0 0 0 0 0 0','',0,0.0,1,'',0,0,0,',0',',0',',0'),
     (275,17,'Спортивная площадка','The State',674.577,-1864.8,5.4609,0.0,0.0,0.0,90000000,0,0,0,0,30,0,300,0,0,0,' 30000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0','The State',' 0 0 0 0 0 0 0','',0,0.0,1,'',0,0,0,',0',',0',',0'),
     (276,14,'Автосалон Luxe','The State',-553.49,2593.82,53.9348,0.0,0.0,0.0,600000,0,0,0,0,30,0,300,0,0,0,' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0','The State',' 0 0 0 0 0 0 0','',0,0.0,1,'',0,0,0,',0',',0',',0'),
     (277,23,'Магазин видеокарт','The State',1081.24,-1696.78,13.5469,1393.25,-21.9096,1000.92,30000000,0,12,0,0,30,150,300,0,0,0,' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0','The State',' 0 0 0 0 0 0 0','',0,0.0,1,'',0,0,0,',0',',0',',0'),
     (278,23,'Магазин видеокарт','The State',-2717.86,195.217,4.3418,1393.25,-21.9096,1000.92,30000000,0,12,0,0,30,150,300,0,0,0,' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0','The State',' 0 0 0 0 0 0 0','',0,0.0,1,'',0,0,0,',0',',0',',0'),
     (279,23,'Магазин видеокарт','The State',2546.51,1972.67,10.8203,1393.25,-21.9096,1000.92,30000000,0,12,0,0,30,150,300,0,0,0,' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0','The State',' 0 0 0 0 0 0 0','',0,0.0,1,'',0,0,0,',0',',0',',0');

// Hotels
INSERT INTO `Hotels` (`ID`, `Hotel`, `HotelID`, `Pos_X`, `Pos_Y`, `Pos_Z`, `Pos_A`, `World`, `Exit_X`, `Exit_Y`, `Exit_Z`, `Exit_A`, `Owner`, `Interior`, `Lock`, `Balance`, `Products`, `htPrice`) VALUES
(421, 22, 421, 2026.06, 2682.84, 1500.96, 277.999, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(422, 22, 422, 2026.06, 2687.65, 1500.96, 269.539, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(423, 22, 423, 2026.06, 2692.8, 1500.96, 272.672, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(424, 22, 424, 2026.06, 2697.75, 1500.96, 267.346, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(425, 22, 425, 2026.06, 2702.77, 1500.96, 266.406, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(426, 22, 426, 2019.67, 2689.44, 1500.96, 176.188, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(427, 22, 427, 2014.67, 2689.44, 1500.96, 184.022, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(428, 22, 428, 2009.55, 2689.44, 1500.96, 186.842, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(429, 22, 429, 2004.59, 2689.44, 1500.96, 181.828, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(430, 22, 430, 2004.58, 2693.15, 1500.96, 4.8165, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(431, 22, 431, 2009.6, 2693.15, 1500.96, 4.8165, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(432, 22, 432, 2014.45, 2693.15, 1500.96, 356.043, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(433, 22, 433, 2019.72, 2693.15, 1500.96, 359.49, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(434, 22, 434, 2028.42, 2670.03, 1506.27, 271.419, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(435, 22, 435, 2028.4, 2676.03, 1506.27, 270.166, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(436, 22, 436, 2026.45, 2678.94, 1506.27, 8.553, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(437, 22, 437, 2021.82, 2678.95, 1506.27, 1.0331, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(438, 22, 438, 2028.43, 2670.04, 1510.79, 269.226, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(439, 22, 439, 2028.39, 2675.92, 1510.79, 275.806, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(440, 22, 440, 2026.5, 2678.94, 1510.79, 4.1665, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(441, 22, 441, 2022.01, 2678.95, 1510.79, 1.3464, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(442, 23, 442, 2026.06, 2682.84, 1500.96, 277.999, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(443, 23, 443, 2026.06, 2687.65, 1500.96, 269.539, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(444, 23, 444, 2026.06, 2692.8, 1500.96, 272.672, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(445, 23, 445, 2026.06, 2697.75, 1500.96, 267.346, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(446, 23, 446, 2026.06, 2702.77, 1500.96, 266.406, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(447, 23, 447, 2019.67, 2689.44, 1500.96, 176.188, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(448, 23, 448, 2014.67, 2689.44, 1500.96, 184.022, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(449, 23, 449, 2009.55, 2689.44, 1500.96, 186.842, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(450, 23, 450, 2004.59, 2689.44, 1500.96, 181.828, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500),
(451, 23, 451, 2004.58, 2693.15, 1500.96, 4.8165, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(452, 23, 452, 2009.6, 2693.15, 1500.96, 4.8165, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(453, 23, 453, 2014.45, 2693.15, 1500.96, 356.043, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(454, 23, 454, 2019.72, 2693.15, 1500.96, 359.49, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(455, 23, 455, 2028.42, 2670.03, 1506.27, 271.419, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(456, 23, 456, 2028.4, 2676.03, 1506.27, 270.166, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(457, 23, 457, 2026.45, 2678.94, 1506.27, 8.553, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(458, 23, 458, 2021.82, 2678.95, 1506.27, 1.0331, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(459, 23, 459, 2028.43, 2670.04, 1510.79, 269.226, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(460, 23, 460, 2028.39, 2675.92, 1510.79, 275.806, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(461, 23, 461, 2026.5, 2678.94, 1510.79, 4.1665, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 300),
(462, 23, 462, 2022.01, 2678.95, 1510.79, 1.3464, 21, 2201.08, 2737.79, 1500.97, 359.209, 'The State', 1, 0, 0, 0, 500);

// PlayerBinder
CREATE TABLE IF NOT EXISTS `PlayerBinder` (
`pb_uid` int(11) NOT NULL,
  `pb_puid` int(11) NOT NULL,
  `pb_slot` int(11) NOT NULL,
  `pb_type` int(11) NOT NULL,
  `pb_buttonName` varchar(20) CHARACTER SET cp1251 NOT NULL,
  `pb_cmd` varchar(20) CHARACTER SET cp1251 NOT NULL,
  `pb_cmdtext` varchar(120) CHARACTER SET cp1251 NOT NULL,
  `pb_arguments` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`pb_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

// PlayerFarm
CREATE TABLE IF NOT EXISTS `PlayerFarm` (
`pf_uid` int(11) NOT NULL,
  `pf_farm_uid` int(11) NOT NULL,
  `pf_player_uid` int(11) NOT NULL,
  `pf_player_name` varchar(24) NOT NULL DEFAULT '0',
  `pf_work_1` int(11) NOT NULL,
  `pf_work_2` int(11) NOT NULL,
  `pf_work_3` int(11) NOT NULL,
  `pf_work_4` int(11) NOT NULL,
  `pf_work_5` int(11) NOT NULL,
  `pf_day` int(11) NOT NULL,
  `pf_work_all` int(11) NOT NULL,
  ADD PRIMARY KEY (`pf_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;