Подключение базы данных для гангзон

Создание таблицу в базе данных

• Название таблицы для учётных записей должна быть gangzones

Поле	Тип
ID	SERIAL
MinX	FLOAT
MinY	FLOAT
MaxX	FLOAT
MaxY	FLOAT
Team	TINYINT

--
-- Структура таблицы `gangzone`
--

CREATE TABLE `gangzone` (
  `ID` bigint(20) UNSIGNED NOT NULL,
  `MinX` float NOT NULL,
  `MinY` float NOT NULL,
  `MaxX` float NOT NULL,
  `MaxY` float NOT NULL,
  `Team` tinyint(4) NOT NULL DEFAULT '-1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `gangzone`
--

INSERT INTO `gangzone` (`ID`, `MinX`, `MinY`, `MaxX`, `MaxY`, `Team`) VALUES
(1, 2632.8, -1852.8, 2959.3, -1668.1, -1),
(2, 2632.8, -1668.1, 2747.7, -1393.4, -1),
(3, 2747.7, -1668.1, 2959.3, -1498.6, -1),
(4, 2747.7, -1498.6, 2959.3, -1120, -1),
(5, 2421, -1628.5, 2632.8, -1454.3, -1),
(6, 2222.5, -1628.5, 2421, -1494, -1),
(7, 2266.2, -1494, 2381.6, -1372, -1),
(8, 2281.4, -1372, 2381.6, -1135, -1),
(9, 2381.6, -1454.3, 2462.1, -1135, -1),
(10, 2462.1, -1454.3, 2581.7, -1135, -1),
(11, 1812.6, -2179.2, 1970.6, -1852.8, -1),
(12, 1692.6, -2179.2, 1812.6, -1842.2, -1),
(13, 2222.5, -1852.8, 2632.8, -1722.3, -1),
(14, 2222.5, -1722.3, 2632.8, -1628.5, -1),
(15, 1812.6, -1449.6, 1996.9, -1350.7, -1),
(16, 1812.6, -1350.7, 2056.8, -1100.8, -1),
(17, 1812.6, -1852.8, 1971.6, -1742.3, -1),
(18, 1812.6, -1742.3, 1951.6, -1602.3, -1),
(19, 1951.6, -1742.3, 2124.6, -1602.3, -1),
(20, 1812.6, -1602.3, 2124.6, -1449.6, -1),
(21, 2124.6, -1742.3, 2222.5, -1494, -1),
(22, 1971.6, -1852.8, 2222.5, -1742.3, -1),
(23, 2124.6, -1494, 2266.2, -1449.6, -1),
(24, 2056.8, -1372, 2281.4, -1210.7, -1),
(25, 2056.8, -1210.7, 2185.3, -1126.3, -1),
(26, 2185.3, -1210.7, 2281.4, -1154.5, -1),
(27, 2056.8, -1449.6, 2266.2, -1372, -1),
(28, 1994.3, -1100.8, 2056.8, -920.8, -1),
(29, 2056.8, -1126.3, 2126.8, -920.8, -1),
(30, 2185.3, -1154.5, 2281.4, -934.4, -1),
(31, 2126.8, -1126.3, 2185.3, -934.4, -1),
(32, 2747.7, -1120, 2959.3, -945, -1),
(33, 2632.7, -1135, 2747.7, -945, -1),
(34, 2281.4, -1135, 2632.7, -945, -1),
(35, 1701.9, -1842.2, 1812.6, -1722.2, -1),
(36, 1758.9, -1722.2, 1812.6, -1577.5, -1),
(37, 2581.7, -1454.3, 2632.8, -1393.4, -1),
(38, 2581.7, -1393.4, 2747.7, -1135, -1),
(39, 2703.5, -2126.9, 2959.3, -1852.8, -1),
(40, 342.6, -2173.2, 647.7, -1684.6, -1),
(41, 72.6, -2173.2, 342.6, -1684.6, -1),
(42, 1252.3, -1130.8, 1378.3, -1026.3, -1),
(43, 1252.3, -1026.3, 1391, -926.9, -1),
(44, 1252.3, -926.9, 1357, -910.1, -1),
(45, 952.6, -1130.8, 1096.4, -937.1, -1),
(46, 1096.4, -1130.8, 1252.3, -1026.3, -1),
(47, 1692.6, -1971.8, 1812.6, -1932.8, -1),
(48, 647.7, -2173.2, 930.2, -1804.2, -1),
(49, 930.2, -2006.7, 1073.2, -1804.2, -1),
(50, 851.4, -1804.2, 1046.1, -1577.5, -1),
(51, 1161.5, -1722.2, 1323.9, -1577.5, -1),
(52, 1046.1, -1722.2, 1161.5, -1577.5, -1),
(53, 787.4, -1130.8, 952.6, -954.6, -1),
(54, 1970.6, -2179.2, 2089, -1852.8, -1),
(55, 2089, -2235.8, 2201.8, -1989.9, -1),
(56, 2089, -1989.9, 2324, -1852.8, -1),
(57, 2201.8, -2095, 2324, -1989.9, -1),
(58, 2324, -2059.2, 2541.7, -1852.8, -1);

--
-- Индексы таблицы `gangzone`
--
ALTER TABLE `gangzone`
  ADD UNIQUE KEY `ID` (`ID`);

--
-- AUTO_INCREMENT для таблицы `gangzone`
--

ALTER TABLE `gangzone`
  MODIFY `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;
COMMIT;