API tools faq
paste
Advertisement
ykos

Untitled

ykos
Feb 12th, 2021
134
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.08 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM `property_objects` WHERE `po_item`='1470' OR `po_item`='1546' OR `po_item`='1608' OR `po_item`='1368';
  2. DELETE FROM `inventory_data` WHERE `item_id`='1470' OR `item_id`='1546' OR `item_id`='1608' OR `item_id`='1368';
  3.  
  4.  
  5. -- Family
  6. ALTER TABLE `Familys` ADD `fTabDay` INT NOT NULL DEFAULT '0' COMMENT 'последний день изменения' AFTER `fSinisterReputation`;
  7. ALTER TABLE `Familys` ADD `fTabAttacks` INT NOT NULL DEFAULT '0' COMMENT 'кол-во прошедших нападений за день' AFTER `fTabDay`;
  8. ALTER TABLE `Familys` ADD `fTabDefenses` INT NOT NULL DEFAULT '0' COMMENT 'кол-во прошедших защит за день' AFTER `fTabAttacks`;
  9. ALTER TABLE `Familys` ADD `fFamilyMoneta` INT NOT NULL DEFAULT '0' COMMENT 'количество семейных монет в семье' AFTER `fTabDefenses`;
  10. ALTER TABLE `Familys` ADD `fCarBuyed` INT NOT NULL DEFAULT '0' COMMENT 'кол-во купленых слотов для авто' AFTER `fFamilyMoneta`;
  11. ALTER TABLE `Familys` ADD `Zam3` VARCHAR(30) NOT NULL DEFAULT 'The State' COMMENT 'улучшение - третий зам' AFTER `fCarBuyed`;
  12. ALTER TABLE `Familys` ADD `FlatTax` INT NOT NULL DEFAULT '0' COMMENT 'налог на семейную квартиру' AFTER `Zam3`;
  13.  
  14.  
  15.  
  16. -- Accounts
  17. ALTER TABLE `nNHVrlXYmR` CHANGE `PlayerNYWaitPrizeTime` `PlayerVDayWaitCar` INT(11) NOT NULL DEFAULT '0' COMMENT 'время ожидания авто в порту';
  18. UPDATE `nNHVrlXYmR` SET `PlayerVDayWaitCar`='0';
  19.  
  20. ALTER TABLE `nNHVrlXYmR` CHANGE `NewYearRaceLimit` `PlayerVDayEventLimit` INT(11) NOT NULL DEFAULT '0' COMMENT 'время ожидания авто в порту';
  21. UPDATE `nNHVrlXYmR` SET `PlayerVDayEventLimit`='0';
  22.  
  23. ALTER TABLE `nNHVrlXYmR` ADD `PlayerOpenCinemaBox` VARCHAR(25) NOT NULL DEFAULT '0|0|0|0|0' COMMENT 'количество открытий ящиков киношных' AFTER `OnlineShopUpgrade`;
  24. ALTER TABLE `nNHVrlXYmR` ADD `ValentinDayTypeQuest1` INT(2) NOT NULL DEFAULT '0' COMMENT '14 февраля - тип 1 квеста' AFTER `PlayerOpenCinemaBox`;
  25. ALTER TABLE `nNHVrlXYmR` ADD `ValentinDayTextValentine` VARCHAR(250) NOT NULL DEFAULT '' COMMENT 'текст валентинки' AFTER `ValentinDayTypeQuest1`;
  26. ALTER TABLE `nNHVrlXYmR` ADD `ValentinDayPavilionID` INT(2) NOT NULL DEFAULT '0' COMMENT 'текст валентинки' AFTER `ValentinDayTextValentine`;
  27. ALTER TABLE `nNHVrlXYmR` ADD `BoxValentineTime` INT(11) NOT NULL DEFAULT '0' COMMENT 'текст валентинки' AFTER `ValentinDayPavilionID`;
  28.  
  29.  
  30.  
  31. -- Businesses
  32. ALTER TABLE `Businesses` ADD `DiscountFamily_1` VARCHAR(30) NOT NULL DEFAULT ',0' AFTER `PurchasePriceGos` ;
  33. ALTER TABLE `Businesses` ADD `DiscountFamily_2` VARCHAR(30) NOT NULL DEFAULT ',0' AFTER `DiscountFamily_1` ;
  34. ALTER TABLE `Businesses` ADD `DiscountFamily_3` VARCHAR(30) NOT NULL DEFAULT ',0' AFTER `DiscountFamily_2` ;
  35.  
  36. 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`) VALUES(258, 2, 'Магазин 24/7', 'Farmer', -1531.05, 2591.72, 55.8359, 2586.03, 1437.58, 1800.97, 20000000, 0, 5, 0, 0, 1, 0, 0, 0, 0, 0, ' 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 15000 10000 5000', 'The State', '', '', 0, 0.4723, 1, '', 0, 0, 0);
  37. 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`) VALUES(259, 2, 'Магазин 24/7', 'Farmer', -2479.24, 2317.84, 4.9844, 2586.03, 1437.58, 1800.97, 20000000, 0, 5, 0, 0, 1, 0, 0, 0, 0, 0, ' 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 15000 10000 5000', 'The State', '', '', 0, 312.883, 1, '', 0, 0, 0);
  38. 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`) VALUES(260, 7, 'Закусочная', 'Farmer', 1404.09, 51.2512, 32.4298, 1085.98, 1004.95, 1601, 20000000, 0, 10, 0, 0, 1, 0, 0, 0, 0, 0, ' 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 15000 10000 5000', 'The State', '', '', 0, 220.407, 1, '', 0, 0, 0);
  39. 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`) VALUES(261, 7, 'Закусочная', 'Farmer', 1020.4, -1844.78, 13.634, 1085.98, 1004.95, 1601, 20000000, 0, 10, 0, 0, 1, 0, 0, 0, 0, 0, ' 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 10000 15000 10000 5000', 'The State', '', '', 0, 214.665, 1, '', 0, 0, 0);
  40. 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`) VALUES(262, 6, 'АЗС/Магазин механики', 'Farmer', 1381.58, 40.6967, 33.1313, 671.689, -579.067, 1700.74, 20000000, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, ' 11111 11111 11111 11111 11111 11111 11111 10000 0 0 0 0 0 0 0 0 0 0 0 0', 'The State', ' 0 0 0 0 0 0 0', '', 0, 221.347, 1, ' ', 0, 0, 0);
  41. 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`) VALUES(263, 6, 'АЗС/Магазин механики', 'Farmer', 58.9409, 1221.86, 18.8677, 671.689, -579.067, 1700.74, 20000000, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, ' 11111 11111 11111 11111 11111 11111 11111 10000 0 0 0 0 0 0 0 0 0 0 0 0', 'The State', ' 0 0 0 0 0 0 0', '', 0, 273.114, 1, ' ', 0, 0, 0);
  42. 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`) VALUES(264, 6, 'АЗС/Магазин механики', 'Farmer', -2572.55, 2391.86, 14.8525, 671.689, -579.067, 1700.74, 20000000, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, ' 11111 11111 11111 11111 11111 11111 11111 10000 0 0 0 0 0 0 0 0 0 0 0 0', 'The State', ' 0 0 0 0 0 0 0', '', 0, 323.163, 1, ' ', 0, 0, 0);
  43. 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`) VALUES(265, 6, 'АЗС/Магазин механики', 'Farmer', -109.1, -1521.69, 3.1305, 671.689, -579.067, 1700.74, 20000000, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, ' 11111 11111 11111 11111 11111 11111 11111 10000 0 0 0 0 0 0 0 0 0 0 0 0', 'The State', ' 0 0 0 0 0 0 0', '', 0, 242.294, 1, ' ', 0, 0, 0);
  44. 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`) VALUES(266, 6, 'АЗС/Магазин механики', 'Farmer', 1019.18, -1871.74, 13.5658, 671.689, -579.067, 1700.74, 20000000, 0, 3, 0, 0, 0, 0, 1, 0, 0, 0, ' 11111 11111 11111 11111 11111 11111 11111 10000 0 0 0 0 0 0 0 0 0 0 0 0', 'The State', ' 0 0 0 0 0 0 0', '', 0, 271.065, 1, ' ', 0, 0, 0);
  45. 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`) VALUES(267, 12, 'Ларек с уличной едой', 'The State', 947.9209,1719.1630,8.8516, 0, 0, 0, 5000000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ' 2000 2000 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, 272.6520, 1, ' ', 0, 0, 0);
  46. 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`) VALUES(268, 12, 'Ларек с уличной едой', 'The State', 1460.3319,2784.8049,10.8125, 0, 0, 0, 5000000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ' 2000 2000 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, 258.7888, 1, ' ', 0, 0, 0);
  47.  
  48.  
  49.  
  50. -- FamilyGangZones добавить
  51. CREATE TABLE FamilyGangZones (
  52. id int(11) NOT NULL,
  53. family_id int(11) NOT NULL DEFAULT '-1',
  54. date_capture datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  55. attack_family_id int(11) NOT NULL DEFAULT '-1',
  56. attack_leader_name varchar(24) NOT NULL DEFAULT '',
  57. attack_month int(11) NOT NULL DEFAULT '0',
  58. attack_day int(11) NOT NULL DEFAULT '0',
  59. attack_hour int(11) NOT NULL DEFAULT '0',
  60. attack_minute int(11) NOT NULL DEFAULT '0',
  61. family_moneta int(11) NOT NULL DEFAULT '0',
  62. family_money int(11) NOT NULL DEFAULT '0',
  63. date_attack_unix int(11) NOT NULL DEFAULT '0'
  64. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  65.  
  66.  
  67. INSERT INTO FamilyGangZones VALUES(0, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  68. INSERT INTO FamilyGangZones VALUES(1, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  69. INSERT INTO FamilyGangZones VALUES(2, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  70. INSERT INTO FamilyGangZones VALUES(3, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  71. INSERT INTO FamilyGangZones VALUES(4, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  72. INSERT INTO FamilyGangZones VALUES(5, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  73. INSERT INTO FamilyGangZones VALUES(6, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  74. INSERT INTO FamilyGangZones VALUES(7, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  75. INSERT INTO FamilyGangZones VALUES(8, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  76. INSERT INTO FamilyGangZones VALUES(9, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  77. INSERT INTO FamilyGangZones VALUES(10, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  78. INSERT INTO FamilyGangZones VALUES(11, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  79. INSERT INTO FamilyGangZones VALUES(12, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  80. INSERT INTO FamilyGangZones VALUES(13, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  81. INSERT INTO FamilyGangZones VALUES(14, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  82. INSERT INTO FamilyGangZones VALUES(15, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  83. INSERT INTO FamilyGangZones VALUES(16, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  84. INSERT INTO FamilyGangZones VALUES(17, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  85. INSERT INTO FamilyGangZones VALUES(18, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  86. INSERT INTO FamilyGangZones VALUES(19, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  87. INSERT INTO FamilyGangZones VALUES(20, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  88. INSERT INTO FamilyGangZones VALUES(21, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  89. INSERT INTO FamilyGangZones VALUES(22, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  90. INSERT INTO FamilyGangZones VALUES(23, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  91. INSERT INTO FamilyGangZones VALUES(24, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  92. INSERT INTO FamilyGangZones VALUES(25, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  93. INSERT INTO FamilyGangZones VALUES(26, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  94. INSERT INTO FamilyGangZones VALUES(27, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  95. INSERT INTO FamilyGangZones VALUES(28, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  96. INSERT INTO FamilyGangZones VALUES(29, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  97. INSERT INTO FamilyGangZones VALUES(30, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  98. INSERT INTO FamilyGangZones VALUES(31, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  99. INSERT INTO FamilyGangZones VALUES(32, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  100. INSERT INTO FamilyGangZones VALUES(33, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  101. INSERT INTO FamilyGangZones VALUES(34, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  102. INSERT INTO FamilyGangZones VALUES(35, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  103. INSERT INTO FamilyGangZones VALUES(36, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  104. INSERT INTO FamilyGangZones VALUES(37, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  105. INSERT INTO FamilyGangZones VALUES(38, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  106. INSERT INTO FamilyGangZones VALUES(39, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  107. INSERT INTO FamilyGangZones VALUES(40, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  108. INSERT INTO FamilyGangZones VALUES(41, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  109. INSERT INTO FamilyGangZones VALUES(42, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  110. INSERT INTO FamilyGangZones VALUES(43, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  111. INSERT INTO FamilyGangZones VALUES(44, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  112. INSERT INTO FamilyGangZones VALUES(45, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  113. INSERT INTO FamilyGangZones VALUES(46, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  114. INSERT INTO FamilyGangZones VALUES(47, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  115. INSERT INTO FamilyGangZones VALUES(48, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  116. INSERT INTO FamilyGangZones VALUES(49, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  117. INSERT INTO FamilyGangZones VALUES(50, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  118. INSERT INTO FamilyGangZones VALUES(51, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  119. INSERT INTO FamilyGangZones VALUES(52, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  120. INSERT INTO FamilyGangZones VALUES(53, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  121. INSERT INTO FamilyGangZones VALUES(54, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  122. INSERT INTO FamilyGangZones VALUES(55, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  123. INSERT INTO FamilyGangZones VALUES(56, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  124. INSERT INTO FamilyGangZones VALUES(57, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  125. INSERT INTO FamilyGangZones VALUES(58, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  126. INSERT INTO FamilyGangZones VALUES(59, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  127. INSERT INTO FamilyGangZones VALUES(60, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  128. INSERT INTO FamilyGangZones VALUES(61, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  129. INSERT INTO FamilyGangZones VALUES(62, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  130. INSERT INTO FamilyGangZones VALUES(63, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  131. INSERT INTO FamilyGangZones VALUES(64, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  132. INSERT INTO FamilyGangZones VALUES(65, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  133. INSERT INTO FamilyGangZones VALUES(66, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  134. INSERT INTO FamilyGangZones VALUES(67, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  135. INSERT INTO FamilyGangZones VALUES(68, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  136. INSERT INTO FamilyGangZones VALUES(69, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  137. INSERT INTO FamilyGangZones VALUES(70, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  138. INSERT INTO FamilyGangZones VALUES(71, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  139. INSERT INTO FamilyGangZones VALUES(72, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  140. INSERT INTO FamilyGangZones VALUES(73, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  141. INSERT INTO FamilyGangZones VALUES(74, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  142. INSERT INTO FamilyGangZones VALUES(75, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  143. INSERT INTO FamilyGangZones VALUES(76, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  144. INSERT INTO FamilyGangZones VALUES(77, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  145. INSERT INTO FamilyGangZones VALUES(78, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  146. INSERT INTO FamilyGangZones VALUES(79, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  147. INSERT INTO FamilyGangZones VALUES(80, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  148. INSERT INTO FamilyGangZones VALUES(81, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  149. INSERT INTO FamilyGangZones VALUES(82, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  150. INSERT INTO FamilyGangZones VALUES(83, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  151. INSERT INTO FamilyGangZones VALUES(84, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  152. INSERT INTO FamilyGangZones VALUES(85, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  153. INSERT INTO FamilyGangZones VALUES(86, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  154. INSERT INTO FamilyGangZones VALUES(87, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  155. INSERT INTO FamilyGangZones VALUES(88, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  156. INSERT INTO FamilyGangZones VALUES(89, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  157. INSERT INTO FamilyGangZones VALUES(90, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  158. INSERT INTO FamilyGangZones VALUES(91, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  159. INSERT INTO FamilyGangZones VALUES(92, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  160. INSERT INTO FamilyGangZones VALUES(93, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  161. INSERT INTO FamilyGangZones VALUES(94, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  162. INSERT INTO FamilyGangZones VALUES(95, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  163. INSERT INTO FamilyGangZones VALUES(96, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  164. INSERT INTO FamilyGangZones VALUES(97, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  165. INSERT INTO FamilyGangZones VALUES(98, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  166. INSERT INTO FamilyGangZones VALUES(99, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  167. INSERT INTO FamilyGangZones VALUES(100, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  168. INSERT INTO FamilyGangZones VALUES(101, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  169. INSERT INTO FamilyGangZones VALUES(102, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  170. INSERT INTO FamilyGangZones VALUES(103, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  171. INSERT INTO FamilyGangZones VALUES(104, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  172. INSERT INTO FamilyGangZones VALUES(105, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  173. INSERT INTO FamilyGangZones VALUES(106, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  174. INSERT INTO FamilyGangZones VALUES(107, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  175. INSERT INTO FamilyGangZones VALUES(108, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  176. INSERT INTO FamilyGangZones VALUES(109, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  177. INSERT INTO FamilyGangZones VALUES(110, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  178. INSERT INTO FamilyGangZones VALUES(111, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  179. INSERT INTO FamilyGangZones VALUES(112, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  180. INSERT INTO FamilyGangZones VALUES(113, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  181. INSERT INTO FamilyGangZones VALUES(114, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  182. INSERT INTO FamilyGangZones VALUES(115, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  183. INSERT INTO FamilyGangZones VALUES(116, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  184. INSERT INTO FamilyGangZones VALUES(117, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  185. INSERT INTO FamilyGangZones VALUES(118, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  186. INSERT INTO FamilyGangZones VALUES(119, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  187. INSERT INTO FamilyGangZones VALUES(120, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  188. INSERT INTO FamilyGangZones VALUES(121, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  189. INSERT INTO FamilyGangZones VALUES(122, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  190. INSERT INTO FamilyGangZones VALUES(123, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  191. INSERT INTO FamilyGangZones VALUES(124, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  192. INSERT INTO FamilyGangZones VALUES(125, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  193. INSERT INTO FamilyGangZones VALUES(126, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  194. INSERT INTO FamilyGangZones VALUES(127, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  195. INSERT INTO FamilyGangZones VALUES(128, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  196. INSERT INTO FamilyGangZones VALUES(129, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  197. INSERT INTO FamilyGangZones VALUES(130, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  198. INSERT INTO FamilyGangZones VALUES(131, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  199. INSERT INTO FamilyGangZones VALUES(132, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  200. INSERT INTO FamilyGangZones VALUES(133, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  201. INSERT INTO FamilyGangZones VALUES(134, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  202. INSERT INTO FamilyGangZones VALUES(135, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  203. INSERT INTO FamilyGangZones VALUES(136, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  204. INSERT INTO FamilyGangZones VALUES(137, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  205. INSERT INTO FamilyGangZones VALUES(138, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  206. INSERT INTO FamilyGangZones VALUES(139, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  207. INSERT INTO FamilyGangZones VALUES(140, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  208. INSERT INTO FamilyGangZones VALUES(141, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  209. INSERT INTO FamilyGangZones VALUES(142, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  210. INSERT INTO FamilyGangZones VALUES(143, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  211. INSERT INTO FamilyGangZones VALUES(144, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  212. INSERT INTO FamilyGangZones VALUES(145, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  213. INSERT INTO FamilyGangZones VALUES(146, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  214. INSERT INTO FamilyGangZones VALUES(147, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  215. INSERT INTO FamilyGangZones VALUES(148, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  216. INSERT INTO FamilyGangZones VALUES(149, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  217. INSERT INTO FamilyGangZones VALUES(150, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  218. INSERT INTO FamilyGangZones VALUES(151, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  219. INSERT INTO FamilyGangZones VALUES(152, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  220. INSERT INTO FamilyGangZones VALUES(153, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  221. INSERT INTO FamilyGangZones VALUES(154, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  222. INSERT INTO FamilyGangZones VALUES(155, -1, '0000-00-00 00:00:00', -1, '', 0, 0, 0, 0, 0, 0, 0);
  223.  
  224.  
  225. ALTER TABLE FamilyGangZones
  226. ADD UNIQUE KEY id (id);
  227.  
  228. ALTER TABLE FamilyGangZones
  229. MODIFY id int(11) NOT NULL AUTO_INCREMENT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!