API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 19th, 2015
228
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.29 KB | None | 0 0
raw download clone embed print report
  1. -- Структура таблицы `gangzone`
  2. --
  3.  
  4. CREATE TABLE IF NOT EXISTS `gangzone` (
  5. `gID` int(4) NOT NULL AUTO_INCREMENT,
  6. `id_frac` int(3) NOT NULL,
  7. `gCoords1` varchar(12) NOT NULL,
  8. `gCoords2` varchar(12) NOT NULL,
  9. `gCoords3` varchar(12) NOT NULL,
  10. `gCoords4` varchar(12) NOT NULL,
  11. `gRespa` int(2) NOT NULL DEFAULT '0',
  12. PRIMARY KEY (`gID`)
  13. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=130 ;
  14.  
  15. --
  16. -- Дамп данных таблицы `gangzone`
  17. --
  18.  
  19. INSERT INTO `gangzone` (`gID`, `id_frac`, `gCoords1`, `gCoords2`, `gCoords3`, `gCoords4`, `gRespa`) VALUES
  20. (0, 17, '1642.710571', '-2174.567871', '1770.710571', '-2073.567871', 0),
  21. (1, 17, '1770.710571', '-2174.567871', '1898.710571', '-2073.567871', 0),
  22. (2, 17, '1898.710571', '-2174.567871', '2026.710571', '-2073.567871', 0),
  23. (3, 18, '2026.710571', '-2174.567871', '2154.710449', '-2073.567871', 0),
  24. (4, 18, '2154.710449', '-2174.567871', '2282.710449', '-2073.567871', 0),
  25. (5, 18, '2282.710449', '-2174.567871', '2410.710449', '-2073.567871', 0),
  26. (6, 18, '2410.710449', '-2174.567871', '2538.710449', '-2073.567871', 0),
  27. (7, 18, '2538.710449', '-2174.567871', '2666.710449', '-2073.567871', 0),
  28. (8, 18, '2666.710449', '-2174.567871', '2794.710449', '-2073.567871', 0),
  29. (9, 18, '2794.710449', '-2174.567871', '2922.710449', '-2073.567871', 0),
  30. (10, 17, '1642.710571', '-2073.567871', '1770.710571', '-1972.567749', 0),
  31. (11, 17, '1770.710571', '-2073.567871', '1898.710571', '-1972.567749', 0),
  32. (12, 17, '1898.710571', '-2073.567871', '2026.710571', '-1972.567749', 0),
  33. (13, 17, '2026.710571', '-2073.567871', '2154.710449', '-1972.567749', 0),
  34. (14, 18, '2154.710449', '-2073.567871', '2282.710449', '-1972.567749', 0),
  35. (15, 18, '2282.710449', '-2073.567871', '2410.710449', '-1972.567749', 0),
  36. (16, 18, '2410.710449', '-2073.567871', '2538.710449', '-1972.567749', 0),
  37. (17, 18, '2538.710449', '-2073.567871', '2666.710449', '-1972.567749', 0),
  38. (18, 18, '2666.710449', '-2073.567871', '2794.710449', '-1972.567749', 0),
  39. (19, 18, '2794.710449', '-2073.567871', '2922.710449', '-1972.567749', 0),
  40. (20, 17, '1642.710571', '-1972.567871', '1770.710571', '-1871.567749', 0),
  41. (21, 17, '1770.710571', '-1972.567871', '1898.710571', '-1871.567749', 0),
  42. (22, 17, '1898.710571', '-1972.567871', '2026.710571', '-1871.567749', 0),
  43. (23, 17, '2026.710571', '-1972.567871', '2154.710449', '-1871.567749', 0),
  44. (24, 17, '2154.710449', '-1972.567871', '2282.710449', '-1871.567749', 0),
  45. (25, 18, '2282.710449', '-1972.567871', '2410.710449', '-1871.567749', 0),
  46. (26, 18, '2410.710449', '-1972.567871', '2538.710449', '-1871.567749', 0),
  47. (27, 18, '2538.710449', '-1972.567871', '2666.710449', '-1871.567749', 0),
  48. (28, 18, '2666.710449', '-1972.567871', '2794.710449', '-1871.567749', 0),
  49. (29, 18, '2794.710449', '-1972.567871', '2922.710449', '-1871.567749', 0),
  50. (30, 17, '1642.710571', '-1871.567871', '1770.710571', '-1770.567749', 0),
  51. (31, 17, '1770.710571', '-1871.567871', '1898.710571', '-1770.567749', 0),
  52. (32, 17, '1898.710571', '-1871.567871', '2026.710571', '-1770.567749', 0),
  53. (33, 17, '2026.710571', '-1871.567871', '2154.710449', '-1770.567749', 0),
  54. (34, 17, '2154.710449', '-1871.567871', '2282.710449', '-1770.567749', 0),
  55. (35, 17, '2282.710449', '-1871.567871', '2410.710449', '-1770.567749', 0),
  56. (36, 15, '2410.710449', '-1871.567871', '2538.710449', '-1770.567749', 0),
  57. (37, 18, '2538.710449', '-1871.567871', '2666.710449', '-1770.567749', 0),
  58. (38, 18, '2666.710449', '-1871.567871', '2794.710449', '-1770.567749', 0),
  59. (39, 18, '2794.710449', '-1871.567871', '2922.710449', '-1770.567749', 0),
  60. (40, 17, '1642.710571', '-1770.567871', '1770.710571', '-1669.567749', 0),
  61. (41, 17, '1770.710571', '-1770.567871', '1898.710571', '-1669.567749', 0),
  62. (42, 17, '1898.710571', '-1770.567871', '2026.710571', '-1669.567749', 0),
  63. (43, 17, '2026.710571', '-1770.567871', '2154.710449', '-1669.567749', 0),
  64. (44, 17, '2154.710449', '-1770.567871', '2282.710449', '-1669.567749', 0),
  65. (45, 17, '2282.710449', '-1770.567871', '2410.710449', '-1669.567749', 0),
  66. (46, 15, '2410.710449', '-1770.567871', '2538.710449', '-1669.567749', 0),
  67. (47, 18, '2538.710449', '-1770.567871', '2666.710449', '-1669.567749', 0),
  68. (48, 18, '2666.710449', '-1770.567871', '2794.710449', '-1669.567749', 0),
  69. (49, 18, '2794.710449', '-1770.567871', '2922.710449', '-1669.567749', 0),
  70. (50, 17, '1642.710571', '-1669.567871', '1770.710571', '-1568.567749', 0),
  71. (51, 17, '1770.710571', '-1669.567871', '1898.710571', '-1568.567749', 0),
  72. (52, 17, '1898.710571', '-1669.567871', '2026.710571', '-1568.567749', 0),
  73. (53, 17, '2026.710571', '-1669.567871', '2154.710449', '-1568.567749', 0),
  74. (54, 17, '2154.710449', '-1669.567871', '2282.710449', '-1568.567749', 0),
  75. (55, 17, '2282.710449', '-1669.567871', '2410.710449', '-1568.567749', 0),
  76. (56, 15, '2410.710449', '-1669.567871', '2538.710449', '-1568.567749', 0),
  77. (57, 15, '2538.710449', '-1669.567871', '2666.710449', '-1568.567749', 0),
  78. (58, 18, '2666.710449', '-1669.567871', '2794.710449', '-1568.567749', 0),
  79. (59, 18, '2794.710449', '-1669.567871', '2922.710449', '-1568.567749', 0),
  80. (60, 17, '1642.710571', '-1568.567871', '1770.710571', '-1467.567749', 0),
  81. (61, 17, '1770.710571', '-1568.567871', '1898.710571', '-1467.567749', 0),
  82. (62, 17, '1898.710571', '-1568.567871', '2026.710571', '-1467.567749', 0),
  83. (63, 17, '2026.710571', '-1568.567871', '2154.710449', '-1467.567749', 0),
  84. (64, 15, '2154.710449', '-1568.567871', '2282.710449', '-1467.567749', 0),
  85. (65, 17, '2282.710449', '-1568.567871', '2410.710449', '-1467.567749', 0),
  86. (66, 17, '2410.710449', '-1568.567871', '2538.710449', '-1467.567749', 0),
  87. (67, 15, '2538.710449', '-1568.567871', '2666.710449', '-1467.567749', 0),
  88. (68, 13, '2666.710449', '-1568.567871', '2794.710449', '-1467.567749', 0),
  89. (69, 18, '2794.710449', '-1568.567871', '2922.710449', '-1467.567749', 0),
  90. (70, 12, '1642.710571', '-1467.567871', '1770.710571', '-1366.567749', 0),
  91. (71, 12, '1770.710571', '-1467.567871', '1898.710571', '-1366.567749', 0),
  92. (72, 12, '1898.710571', '-1467.567871', '2026.710571', '-1366.567749', 0),
  93. (73, 17, '2026.710571', '-1467.567871', '2154.710449', '-1366.567749', 0),
  94. (74, 12, '2154.710449', '-1467.567871', '2282.710449', '-1366.567749', 0),
  95. (75, 13, '2282.710449', '-1467.567871', '2410.710449', '-1366.567749', 0),
  96. (76, 13, '2410.710449', '-1467.567871', '2538.710449', '-1366.567749', 0),
  97. (77, 13, '2538.710449', '-1467.567871', '2666.710449', '-1366.567749', 0),
  98. (78, 13, '2666.710449', '-1467.567871', '2794.710449', '-1366.567749', 0),
  99. (79, 13, '2794.710449', '-1467.567871', '2922.710449', '-1366.567749', 0),
  100. (80, 12, '1642.710571', '-1366.567871', '1770.710571', '-1265.567749', 0),
  101. (81, 12, '1770.710571', '-1366.567871', '1898.710571', '-1265.567749', 0),
  102. (82, 12, '1898.710571', '-1366.567871', '2026.710571', '-1265.567749', 0),
  103. (83, 12, '2026.710571', '-1366.567871', '2154.710449', '-1265.567749', 0),
  104. (84, 12, '2154.710449', '-1366.567871', '2282.710449', '-1265.567749', 0),
  105. (85, 13, '2282.710449', '-1366.567871', '2410.710449', '-1265.567749', 0),
  106. (86, 13, '2410.710449', '-1366.567871', '2538.710449', '-1265.567749', 0),
  107. (87, 13, '2538.710449', '-1366.567871', '2666.710449', '-1265.567749', 0),
  108. (88, 13, '2666.710449', '-1366.567871', '2794.710449', '-1265.567749', 0),
  109. (89, 13, '2794.710449', '-1366.567871', '2922.710449', '-1265.567749', 0),
  110. (90, 12, '1642.710571', '-1265.567871', '1770.710571', '-1164.567749', 0),
  111. (91, 12, '1770.710571', '-1265.567871', '1898.710571', '-1164.567749', 0),
  112. (92, 12, '1898.710571', '-1265.567871', '2026.710571', '-1164.567749', 0),
  113. (93, 12, '2026.710571', '-1265.567871', '2154.710449', '-1164.567749', 0),
  114. (94, 12, '2154.710449', '-1265.567871', '2282.710449', '-1164.567749', 0),
  115. (95, 13, '2282.710449', '-1265.567871', '2410.710449', '-1164.567749', 0),
  116. (96, 13, '2410.710449', '-1265.567871', '2538.710449', '-1164.567749', 0),
  117. (97, 13, '2538.710449', '-1265.567871', '2666.710449', '-1164.567749', 0),
  118. (98, 13, '2666.710449', '-1265.567871', '2794.710449', '-1164.567749', 0),
  119. (99, 13, '2794.710449', '-1265.567871', '2922.710449', '-1164.567749', 0),
  120. (100, 12, '1642.710571', '-1164.567871', '1770.710571', '-1063.567749', 0),
  121. (101, 12, '1770.710571', '-1164.567871', '1898.710571', '-1063.567749', 0),
  122. (102, 12, '1898.710571', '-1164.567871', '2026.710571', '-1063.567749', 0),
  123. (103, 12, '2026.710571', '-1164.567871', '2154.710449', '-1063.567749', 0),
  124. (104, 12, '2154.710449', '-1164.567871', '2282.710449', '-1063.567749', 0),
  125. (105, 13, '2282.710449', '-1164.567871', '2410.710449', '-1063.567749', 0),
  126. (106, 13, '2410.710449', '-1164.567871', '2538.710449', '-1063.567749', 0),
  127. (107, 13, '2538.710449', '-1164.567871', '2666.710449', '-1063.567749', 0),
  128. (108, 13, '2666.710449', '-1164.567871', '2794.710449', '-1063.567749', 0),
  129. (109, 13, '2794.710449', '-1164.567871', '2922.710449', '-1063.567749', 0),
  130. (110, 13, '1642.710571', '-1063.567871', '1770.710571', '-962.567871', 0),
  131. (111, 12, '1770.710571', '-1063.567871', '1898.710571', '-962.567871', 0),
  132. (112, 12, '1898.710571', '-1063.567871', '2026.710571', '-962.567871', 0),
  133. (113, 12, '2026.710571', '-1063.567871', '2154.710449', '-962.567871', 0),
  134. (114, 13, '2154.710449', '-1063.567871', '2282.710449', '-962.567871', 0),
  135. (115, 13, '2282.710449', '-1063.567871', '2410.710449', '-962.567871', 0),
  136. (116, 13, '2410.710449', '-1063.567871', '2538.710449', '-962.567871', 0),
  137. (117, 13, '2538.710449', '-1063.567871', '2666.710449', '-962.567871', 0),
  138. (118, 13, '2666.710449', '-1063.567871', '2794.710449', '-962.567871', 0),
  139. (119, 13, '2794.710449', '-1063.567871', '2922.710449', '-962.567871', 0),
  140. (120, 12, '1642.710571', '-962.567871', '1770.710571', '-861.567871', 0),
  141. (121, 12, '1770.710571', '-962.567871', '1898.710571', '-861.567871', 0),
  142. (122, 12, '1898.710571', '-962.567871', '2026.710571', '-861.567871', 0),
  143. (123, 12, '2026.710571', '-962.56787', '2154.710449', '-861.567871', 0),
  144. (124, 12, '2154.710449', '-962.567871', '2282.710449', '-861.567871', 0),
  145. (125, 13, '2282.710449', '-962.567871', '2410.710449', '-861.567871', 0),
  146. (126, 13, '2410.710449', '-962.567871', '2538.710449', '-861.567871', 0),
  147. (127, 13, '2538.710449', '-962.567871', '2666.710449', '-861.567871', 0),
  148. (128, 13, '2666.710449', '-962.567871', '2794.710449', '-861.567871', 0),
  149. (129, 13, '2794.710449', '-962.567871', '2922.710449', '-861.567871', 0);
  150.  
  151. -- --------------------------------------------------------
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!