Advertisement
Faguss

Custom Map List Forum Stajnia Ogarów - Tables

Jan 17th, 2016
249
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 9.42 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.5.8.2
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Czas wygenerowania: 15 Lut 2016, 04:09
  7. -- Wersja serwera: 5.0.91-log
  8. -- Wersja PHP: 5.3.28
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18.  
  19. --
  20. -- Baza danych: ``
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Struktura tabeli dla tabeli `StajniaCustom`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `StajniaCustom` (
  30.   `ID` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'Map num',
  31.   `Name` text NOT NULL COMMENT 'Map file name',
  32.   `Description` text NOT NULL COMMENT 'Map info',
  33.   `Sort` INT(11) NOT NULL DEFAULT '0' COMMENT 'Pos in the list',
  34.   PRIMARY KEY  (`ID`),
  35.   KEY `ID` (`ID`)
  36. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=54 ;
  37.  
  38. --
  39. -- Zrzut danych tabeli `StajniaCustom`
  40. --
  41.  
  42. INSERT INTO `StajniaCustom` (`ID`, `Name`, `Description`, `Sort`) VALUES
  43. (0, 'cp_croissant_rc11', '5 punktów; [url=https://youtu.be/ZUh9WpMxYtY]wymowa[/url]', 0),
  44. (1, 'cp_stoneyridge_rc1', 'atak / obrona, 2 punkty', 10),
  45. (2, 'cp_mudwater_b4', 'atak / obrona, 2 punkty', 20),
  46. (3, 'cp_gydan', 'atak / obrona, 4 punkty', 30),
  47. (4, 'cp_edifice_b4', 'atak / obrona, 3 punkty; Alkorn chwalił się, że 4 błędy znalazł', 40),
  48. (5, 'cp_biodome_b1', '5 punktów', 50),
  49. (6, 'cp_warpath_v3', '5 punktów', 60),
  50. (7, 'cp_collis_b3', '5 punktów', 70),
  51. (8, 'cp_stag', '5 punktów', 80),
  52. (9, 'cp_mojave_b2', '2 strefy po 2 punkty; [url=https://youtu.be/LHDwWq0K89c]wymowa[/url]', 90),
  53. (10, 'cp_glacier_rc6', 'atak / obrona, 3 punkty', 100),
  54. (11, 'cp_upland_rc4', 'atak / obrona, 5 punktów', 110),
  55. (12, 'cp_follower', '5 punktów', 120),
  56. (13, 'cp_waste', '5 punktów', 130),
  57. (14, 'cp_wetcoal_b1', '5 punktów', 140),
  58. (15, 'cp_metalworks_rc5', '5 punktów', 150),
  59. (16, 'cp_logjam_rc2a', '5 punktów', 160),
  60. (17, 'cp_antiquity_rc1', '5 punktów', 170),
  61. (18, 'cp_furnace_rc', 'atak / obrona, 3 punkty', 180),
  62. (19, 'pl_angkor_rc1', '3 strefy', 190),
  63. (20, 'pl_great_heights_b3', '3 strefy', 200),
  64. (21, 'pl_swiftwater_ugc', '', 210),
  65. (22, 'pl_halfacre', '', 220),
  66. (23, 'pl_boundary_final', '', 230),
  67. (24, 'pl_quagmire', '', 240),
  68. (25, 'pl_manngrove_rc5', '', 250),
  69. (26, 'pl_5curve', '', 260),
  70. (27, 'pl_deadwood', '', 270),
  71. (28, 'pl_mineshaft_rc1d', '', 280),
  72. (29, 'pl_rivercrossing_rc2a', '', 290),
  73. (30, 'pl_waste_v2', 'przeciąganie wózka', 300),
  74. (31, 'pl_auriferous_rc7', '', 310),
  75. (32, 'pl_cranetop_b8', '3 strefy', 320),
  76. (33, 'ctf_converge_b3', 'zanieść walizkę do bazy wroga', 330),
  77. (34, 'ctf_aurora_rc', 'zanieść walizkę do bazy wroga', 340),
  78. (35, 'ctf_hotspring_b4', '', 350),
  79. (36, 'ctf_vector_v1', 'zanieść walizkę do 2 punktów w 3 strefach', 360),
  80. (37, 'ctf_syphon_b3e', '', 370),
  81. (38, 'ctf_snowdrift_b2', 'zanieść walizkę do 4 punktów', 380),
  82. (39, 'ctf_powerhouse_jr_b7', '', 390),
  83. (40, 'ctf_cloudburst_b4', '', 400),
  84. (41, 'ctf_haarp', 'zanieść walizkę do 2 punktów w 3 strefach', 410),
  85. (42, 'koth_ramjam_b9', '', 420),
  86. (43, 'koth_garbage_day', '', 430),
  87. (44, 'koth_coalplant_b7', '', 440),
  88. (45, 'koth_brazil_rc1', '', 450),
  89. (46, 'koth_oilfield', '', 460),
  90. (47, 'dom_canalzone2_b4', '6 punktów', 470),
  91. (48, 'cp_warmerfront_rc1c', '5 punktów', 55),
  92. (49, 'pl_dbheights_v3', '3 strefy', 225),
  93. (50, 'pl_abandoned_upward_finalfix', '', 315),
  94. (51, 'cp_sunshine_rc9', '5 punktów', 25),
  95. (52, 'pl_millstone', '', 225),
  96. (53, 'cp_metalworks_rc7', '5 punktów', 150);
  97.  
  98. -- --------------------------------------------------------
  99.  
  100. --
  101. -- Struktura tabeli dla tabeli `StajniaLinks`
  102. --
  103.  
  104. CREATE TABLE IF NOT EXISTS `StajniaLinks` (
  105.   `Index` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'Img num',
  106.   `ID` INT(11) NOT NULL COMMENT 'Map num',
  107.   `Link` text NOT NULL COMMENT 'Imgur code',
  108.   `Include` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'in the forum post',
  109.   PRIMARY KEY  (`Index`),
  110.   KEY `ID` (`ID`)
  111. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=186 ;
  112.  
  113. --
  114. -- Zrzut danych tabeli `StajniaLinks`
  115. --
  116.  
  117. INSERT INTO `StajniaLinks` (`Index`, `ID`, `Link`, `Include`) VALUES
  118. (0, 0, 'oKi7TaV', 1),
  119. (1, 0, 'cxUY3WY', 1),
  120. (2, 0, 'tNHTOYD', 1),
  121. (3, 1, '5lSmrfE', 1),
  122. (4, 1, 'PqB6gVr', 1),
  123. (5, 2, '0G1mWV0', 1),
  124. (6, 2, 'xuy0WxF', 1),
  125. (7, 2, 'HdEaE6T', 1),
  126. (8, 3, 'fcaBZEk', 1),
  127. (9, 3, 'q11NJmY', 1),
  128. (10, 3, 'fOsvbWE', 1),
  129. (11, 4, '5W16SvH', 1),
  130. (12, 4, 'K5Bgfqy', 1),
  131. (13, 4, 'XWxQc2X', 1),
  132. (14, 5, 'pLNWdo1', 0),
  133. (15, 5, 'wurx2jW', 1),
  134. (16, 5, '2ttV0cb', 1),
  135. (17, 5, 'XQcgz0k', 1),
  136. (18, 6, 'o2JSsAJ', 1),
  137. (19, 6, 'pQoswkJ', 1),
  138. (20, 6, 'x3Lr31I', 1),
  139. (21, 7, '0H2dWHC', 0),
  140. (22, 7, 'v9b0Fif', 1),
  141. (23, 7, 'wz8Djoa', 1),
  142. (24, 8, 'mwYD1k3', 0),
  143. (25, 8, 'S9Uxn9W', 1),
  144. (26, 8, 'xEt222j', 1),
  145. (27, 9, 'FTpFwxR', 1),
  146. (28, 9, 'MTF3BXv', 1),
  147. (29, 9, 'xOnG0Xf', 1),
  148. (30, 9, 'WrApxUk', 1),
  149. (31, 10, 'BIp6Oqj', 1),
  150. (32, 10, 'VcIwcXt', 1),
  151. (33, 10, 'klqNmtI', 1),
  152. (34, 11, 'IoRc5Ow', 1),
  153. (35, 11, 'V68wLiR', 1),
  154. (36, 11, 'r0N8ZwN', 1),
  155. (37, 11, 'OXsVRyC', 1),
  156. (38, 11, 'QKnV2ky', 1),
  157. (39, 12, 'ZstxYW8', 0),
  158. (40, 12, 'omrVsDJ', 0),
  159. (41, 12, 'uLV3DkL', 1),
  160. (42, 12, 'bC2iF3u', 1),
  161. (43, 13, 'byy4nu3', 0),
  162. (44, 13, 'Q38dbV1', 1),
  163. (45, 13, '8Dn4HbS', 1),
  164. (46, 13, 'RjboAdv', 1),
  165. (47, 14, 'ThT9Yr8', 1),
  166. (48, 14, 'Eay8uhv', 1),
  167. (49, 14, '537Fmi8', 1),
  168. (50, 15, 'I4KEOwf', 0),
  169. (51, 15, 'kmhwk4l', 1),
  170. (52, 15, '4o9poSk', 1),
  171. (53, 16, 'MAAPrBi', 0),
  172. (54, 16, 'et7PF85', 1),
  173. (55, 16, 'CKyT1Rk', 1),
  174. (56, 17, 'OEtWPvQ', 0),
  175. (57, 17, 'GzQd6Ab', 1),
  176. (58, 17, 'Pdiz7Dy', 1),
  177. (59, 18, 'gHWMeOI', 1),
  178. (60, 18, 'UwtLRiB', 1),
  179. (61, 18, 'tH7BqyT', 1),
  180. (62, 19, 'M9Ecy3s', 1),
  181. (63, 19, 'lvWPJmu', 1),
  182. (64, 19, 'GmBnKiE', 1),
  183. (65, 19, 'mahgd1l', 1),
  184. (66, 20, 'fYqoYoc', 1),
  185. (67, 20, 'UYjOlk8', 1),
  186. (68, 20, '3rdzCuQ', 1),
  187. (69, 20, 'ETlzh3J', 1),
  188. (70, 20, 'qgxKtka', 1),
  189. (71, 20, 'Cr83mXC', 1),
  190. (72, 21, 'DpZ8YsC', 1),
  191. (73, 21, 'fYAMAdM', 0),
  192. (74, 21, 'g8LfLf8', 1),
  193. (75, 21, 'yNMyexT', 1),
  194. (76, 21, 'rzWWr8G', 1),
  195. (77, 22, 'Mi46mKY', 1),
  196. (78, 22, 'sAuBBkr', 1),
  197. (79, 22, 'FlrXUmx', 1),
  198. (80, 22, 'NvJnC1t', 1),
  199. (81, 22, '0gVskXZ', 1),
  200. (82, 22, '3w9XdUA', 1),
  201. (83, 23, 'hCydmEO', 1),
  202. (84, 23, '3OQLfro', 0),
  203. (85, 23, 'OImg0C6', 1),
  204. (86, 23, 'ABuvT3j', 1),
  205. (87, 24, 'Vl4fsdJ', 1),
  206. (88, 24, 'ZEmvY0V', 1),
  207. (89, 24, 'lIPCiSd', 1),
  208. (90, 25, '53husGP', 1),
  209. (91, 25, 'PlsQOu5', 1),
  210. (92, 25, 'hHqG50j', 1),
  211. (93, 25, 'fS1gE8H', 1),
  212. (94, 25, 'uC6cRG4', 1),
  213. (95, 26, 'SLzyuHm', 1),
  214. (96, 26, 'cJ4ui0O', 1),
  215. (97, 26, 'xw45udO', 1),
  216. (98, 26, 'eDwttJH', 1),
  217. (99, 26, 'uGiyKLA', 1),
  218. (100, 27, 'atylTMX', 1),
  219. (101, 27, 'R0lXXya', 1),
  220. (102, 27, 'iiX0lQq', 1),
  221. (103, 27, 'PYgfvoe', 1),
  222. (104, 28, '7mmvpKG', 1),
  223. (105, 28, 'xXQR6EH', 1),
  224. (106, 28, 'dqqr0nt', 1),
  225. (107, 29, 'uwj2pMO', 1),
  226. (108, 29, 'H3g4WZD', 1),
  227. (109, 29, 'wGuO89D', 1),
  228. (110, 29, '1zgwxbm', 1),
  229. (111, 29, 'jRj8mKm', 1),
  230. (112, 31, 'ulrRMqS', 1),
  231. (113, 31, 'id5gQIP', 1),
  232. (114, 31, 'jjSXNQX', 1),
  233. (115, 31, 'LpUtzBr', 1),
  234. (116, 31, '3kybnkp', 1),
  235. (117, 31, 'jhsTZIj', 1),
  236. (118, 33, 'jhsTZIj', 1),
  237. (119, 33, 'nXUgZh6', 1),
  238. (120, 34, 'qI5LGKF', 1),
  239. (121, 34, 'GQC7hW0', 1),
  240. (122, 35, '0t2ZhTN', 1),
  241. (123, 35, 'CMLozt5', 1),
  242. (124, 36, 'XLIdxZk', 1),
  243. (125, 36, 'HZisMxJ', 1),
  244. (126, 36, 'eFTNEae', 1),
  245. (127, 36, 'OLZD4yQ', 1),
  246. (128, 36, 'WylsDyE', 1),
  247. (129, 37, 'PWZbuBB', 1),
  248. (130, 37, 'LK0nBKn', 1),
  249. (131, 38, 'XGOgVuM', 1),
  250. (132, 38, 'R6aGLLP', 1),
  251. (133, 38, 'GG42q1n', 1),
  252. (134, 38, 'xVAL9J2', 1),
  253. (135, 39, '51ly5tu', 1),
  254. (136, 39, 'kgwVbNE', 1),
  255. (137, 39, '1Njd2qP', 1),
  256. (138, 40, 'cg2raIg', 1),
  257. (139, 40, 'sWeeI6C', 1),
  258. (140, 40, 'LPIy2du', 1),
  259. (141, 42, 'DRvMuqo', 1),
  260. (142, 43, '6pVg5VV', 1),
  261. (143, 44, '5waVFcT', 1),
  262. (144, 45, 'lWNSr6W', 1),
  263. (145, 46, 'uhZ5Zql', 1),
  264. (146, 47, 'C1hDm6C', 1),
  265. (147, 47, 'KlK1obo', 0),
  266. (148, 47, '5nFgzk3', 0),
  267. (149, 47, 'bVnsUWb', 0),
  268. (150, 30, 'fmGeL2V', 1),
  269. (151, 30, '7189JIH', 1),
  270. (152, 30, 'reXthH4', 1),
  271. (153, 32, 'rcuzpyN', 1),
  272. (154, 32, 'kXkmgf9', 1),
  273. (155, 32, 'aXt9le9', 1),
  274. (156, 32, 'ldA4xWU', 1),
  275. (157, 32, '1HwxQkk', 1),
  276. (158, 32, 'TKbTWCy', 1),
  277. (159, 32, '1G4TWFB', 1),
  278. (160, 41, '8MaA1Pf', 1),
  279. (161, 41, 'ehMCfPl', 1),
  280. (162, 41, 'ackm4MM', 1),
  281. (163, 41, '9IDKOP7', 1),
  282. (164, 41, '85gd3Fz', 1),
  283. (165, 41, 'rfOybTc', 1),
  284. (166, 48, 'GcOKTWu', 1),
  285. (167, 48, 'z6vwnlB', 1),
  286. (168, 48, 'RMYozvM', 1),
  287. (169, 49, 'HdeRdzf', 1),
  288. (170, 49, 'tkxCUAC', 1),
  289. (171, 49, '19MaLcY', 1),
  290. (172, 50, '1idtj8b', 1),
  291. (173, 50, '2JRJUG1', 1),
  292. (174, 50, '56awLpr', 1),
  293. (175, 47, 'BBOtlmM', 1),
  294. (176, 52, 'ty26Njv', 1),
  295. (177, 52, 'Zom30lA', 1),
  296. (178, 52, 'WUqjADY', 1),
  297. (179, 52, 'FvV4td1', 1),
  298. (180, 53, 'I4KEOwf', 0),
  299. (181, 53, 'k4goqxU', 1),
  300. (182, 53, '4o9poSk', 1),
  301. (183, 51, 'wPUuzrj', 0),
  302. (184, 51, 'yDmQ1mn', 1),
  303. (185, 51, 'qFLN6wR', 1);
  304.  
  305. -- --------------------------------------------------------
  306.  
  307. --
  308. -- Struktura tabeli dla tabeli `StajniaRemoved`
  309. --
  310.  
  311. CREATE TABLE IF NOT EXISTS `StajniaRemoved` (
  312.   `ID` INT(11) NOT NULL COMMENT 'Map num',
  313.   PRIMARY KEY  (`ID`),
  314.   KEY `ID` (`ID`)
  315. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  316.  
  317. --
  318. -- Zrzut danych tabeli `StajniaRemoved`
  319. --
  320.  
  321. INSERT INTO `StajniaRemoved` (`ID`) VALUES
  322. (15),
  323. (41),
  324. (48),
  325. (49),
  326. (50);
  327.  
  328. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  329. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  330. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement