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

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`;

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);

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

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`;

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

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

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`;


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');

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);

CREATE TABLE IF NOT EXISTS `PlayerBinder` (
`pb_uid` int(11) NOT NULL AUTO_INCREMENT,
  `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;

CREATE TABLE IF NOT EXISTS `PlayerFarm` (
`pf_uid` int(11) NOT NULL AUTO_INCREMENT,
  `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;