Advertisement
Guest User

Untitled

a guest
Oct 23rd, 2019
240
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 48.83 KB | None | 0 0
  1. --
  2. -- Table structure for table `apsaugos_kodas`
  3. --
  4.  
  5. CREATE TABLE IF NOT EXISTS `apsaugos_kodas` (
  6. `ID` int(11) NOT NULL,
  7. `kodas` varchar(4) COLLATE utf8_lithuanian_ci NOT NULL,
  8. `dienos_laikas` int(11) NOT NULL,
  9. `dienos_laikas2` int(11) NOT NULL,
  10. `prizas` int(11) NOT NULL,
  11. `vakar_laimejo_1` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  12. `vakar_laimejo_2` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  13. `vakar_laimejo_3` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  14. `reg` int(11) NOT NULL,
  15. `raw_at` int(11) NOT NULL,
  16. `smack_at` int(11) NOT NULL,
  17. `nxt_at` int(11) NOT NULL,
  18. `max_on` int(11) NOT NULL,
  19. `max_on_siandien` int(11) NOT NULL,
  20. `diena` varchar(11) COLLATE utf8_lithuanian_ci NOT NULL,
  21. `daugiausiai_veiksmu` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  22. `daugiausiai_veiksmu_1` int(11) NOT NULL
  23. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  24.  
  25. --
  26. -- Dumping data for table `apsaugos_kodas`
  27. --
  28.  
  29. INSERT INTO `apsaugos_kodas` (`ID`, `kodas`, `dienos_laikas`, `dienos_laikas2`, `prizas`, `vakar_laimejo_1`, `vakar_laimejo_2`, `vakar_laimejo_3`, `reg`, `raw_at`, `smack_at`, `nxt_at`, `max_on`, `max_on_siandien`, `diena`, `daugiausiai_veiksmu`, `daugiausiai_veiksmu_1`) VALUES
  30. ('Admin',1234,500,100,300,'Admin','Admin','Admin',1,1,1,1,1,24,15,1,1);
  31. -- --------------------------------------------------------
  32.  
  33. --
  34. -- Table structure for table `balsavimas`
  35. --
  36.  
  37. CREATE TABLE IF NOT EXISTS `balsavimas` (
  38. `ID` int(11) NOT NULL,
  39. `autorius` varchar(30) NOT NULL,
  40. `data` varchar(20) NOT NULL,
  41. `klausimas` varchar(300) NOT NULL,
  42. `atsakymas_1` varchar(200) NOT NULL,
  43. `atsakymas_2` varchar(200) NOT NULL,
  44. `atsakymas_3` varchar(200) NOT NULL
  45. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  46.  
  47. --
  48. -- Dumping data for table `balsavimas`
  49. --
  50.  
  51. INSERT INTO `balsavimas` (`ID`, `autorius`, `data`, `klausimas`, `atsakymas_1`, `atsakymas_2`, `atsakymas_3`) VALUES
  52. (1,'Admin','2019.10.22','arba','labas','labas1','labas2');
  53. -- --------------------------------------------------------
  54.  
  55. --
  56. -- Table structure for table `balsavimo_rezultatai`
  57. --
  58.  
  59. CREATE TABLE IF NOT EXISTS `balsavimo_rezultatai` (
  60. `laikas` int(11) NOT NULL,
  61. `nick` varchar(50) NOT NULL,
  62. `atsakymas` int(11) NOT NULL
  63. ) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;
  64.  
  65. --
  66. -- Dumping data for table `balsavimo_rezultatai`
  67. --
  68.  
  69. INSERT INTO `balsavimo_rezultatai` (`laikas`, `nick`, `atsakymas`) VALUES
  70. ('22:04','Admin','labas1');
  71. -- --------------------------------------------------------
  72.  
  73. --
  74. -- Table structure for table `drabuzine`
  75. --
  76.  
  77. CREATE TABLE IF NOT EXISTS `drabuzine` (
  78. `ID` int(11) NOT NULL,
  79. `kovotojas` varchar(50) NOT NULL,
  80. `kaina` int(11) NOT NULL,
  81. `nr` int(11) NOT NULL
  82. ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8;
  83.  
  84. --
  85. -- Dumping data for table `drabuzine`
  86. --
  87.  
  88. INSERT INTO `drabuzine` (`ID`, `kovotojas`, `kaina`, `nr`) VALUES
  89. (1, 'Seth Rollins', 2, 1),
  90. (2, 'Seth Rollins', 4, 2),
  91. (4, 'Triple H', 2, 1),
  92. (7, 'Seth Rollins', 6, 3),
  93. (8, 'Brock Lesnar', 2, 1),
  94. (9, 'Brock Lesnar', 4, 2),
  95. (10, 'Brock Lesnar', 6, 3),
  96. (11, 'Dolph Ziggler', 2, 1),
  97. (12, 'Dolph Ziggler', 4, 2),
  98. (13, 'Dolph Ziggler', 6, 3),
  99. (14, 'Big Show', 2, 1),
  100. (15, 'Big Show', 4, 2),
  101. (16, 'Big Show', 6, 3),
  102. (17, 'John Cena', 2, 1),
  103. (18, 'Paige', 2, 1),
  104. (19, 'Paige', 4, 2),
  105. (20, 'Paige', 6, 3),
  106. (21, 'Maryse', 2, 1),
  107. (22, 'Maryse', 4, 2),
  108. (23, 'Maryse', 6, 3),
  109. (24, 'Lana', 2, 1),
  110. (25, 'Lana', 4, 2),
  111. (26, 'Lana', 6, 3),
  112. (27, 'Nikki Bella', 2, 1),
  113. (28, 'Nikki Bella', 4, 2),
  114. (29, 'Nikki Bella', 6, 3),
  115. (30, 'Kelly Kelly', 2, 1),
  116. (31, 'Kelly Kelly', 4, 2),
  117. (32, 'Kelly Kelly', 6, 3),
  118. (33, 'Trish Stratus', 2, 1),
  119. (34, 'Trish Stratus', 4, 2),
  120. (35, 'Trish Stratus', 6, 3),
  121. (36, 'John Cena', 2, 2),
  122. (37, 'John Cena', 4, 3),
  123. (38, 'Randy Orton', 2, 1),
  124. (39, 'Randy Orton', 4, 2),
  125. (40, 'Randy Orton', 6, 3),
  126. (41, 'Daniel Bryan', 2, 1),
  127. (42, 'Daniel Bryan', 4, 2),
  128. (43, 'Daniel Bryan', 6, 3),
  129. (47, 'Roman Reigns', 2, 1),
  130. (48, 'Roman Reigns', 4, 2),
  131. (49, 'Roman Reigns', 6, 3),
  132. (50, 'Kofi Kingston', 2, 1),
  133. (51, 'Kofi Kingston', 4, 2),
  134. (52, 'Kofi Kingston', 6, 3),
  135. (53, 'Finn Balor', 2, 1),
  136. (54, 'Finn Balor', 4, 2),
  137. (55, 'Finn Balor', 6, 3),
  138. (59, 'Triple H', 4, 2),
  139. (60, 'Triple H', 6, 3),
  140. (61, 'AJ Styles', 2, 1),
  141. (62, 'AJ Styles', 4, 2),
  142. (63, 'AJ Styles', 6, 3),
  143. (64, 'The Miz', 2, 1),
  144. (65, 'The Miz', 4, 2),
  145. (66, 'The Miz', 6, 3),
  146. (67, 'Jeff Hardy', 2, 1),
  147. (68, 'Jeff Hardy', 4, 2),
  148. (69, 'Jeff Hardy', 6, 3),
  149. (70, 'Dean Ambrose', 2, 1),
  150. (71, 'Dean Ambrose', 4, 2),
  151. (72, 'Dean Ambrose', 6, 3),
  152. (74, 'Torrie Wilson', 2, 1),
  153. (75, 'Torrie Wilson', 4, 2),
  154. (76, 'Torrie Wilson', 6, 3),
  155. (77, 'The Undertaker', 2, 1),
  156. (78, 'The Undertaker', 4, 2),
  157. (79, 'The Undertaker', 6, 3),
  158. (80, 'Zack Ryder', 2, 1),
  159. (81, 'Zack Ryder', 4, 2),
  160. (82, 'Zack Ryder', 6, 3),
  161. (83, 'DDP', 2, 2),
  162. (84, 'Dean Ambrose', 50000, 4),
  163. (85, 'Seth Rollins', 10000, 4),
  164. (86, 'Alexa Bliss ', 2, 1),
  165. (87, 'Alexa Bliss ', 4, 2),
  166. (88, 'Sasha Banks', 10000000, 1),
  167. (89, 'Randy Orton', 1000000, 4),
  168. (90, 'Batista', 1, 1),
  169. (91, 'Eddie Guerrero', 1, 1),
  170. (92, 'Becky Lynch', 50000000, 5);
  171.  
  172. -- --------------------------------------------------------
  173.  
  174. --
  175. -- Table structure for table `duk`
  176. --
  177.  
  178. CREATE TABLE IF NOT EXISTS `duk` (
  179. `ID` int(11) NOT NULL,
  180. `nick` varchar(20) NOT NULL,
  181. `klausimas` text NOT NULL,
  182. `atsakymas` text NOT NULL
  183. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  184.  
  185. --
  186. -- Dumping data for table `duk`
  187. --
  188.  
  189. INSERT INTO `duk` (`ID`, `nick`, `klausimas`, `atsakymas`) VALUES
  190. (1, 'Admin', 'Kas yra Level?', 'Level, kitaip tariant, jūsų pagrindinis lygis. Turint didesni lygį, atsiveria didesnės galimybės žaidime.'),
  191. (2, 'Admin', 'Kas yra Energy?', 'Kuo didesnis jūsų Energy tuo didesnė galimybė padaryti didesnė žalą varžovui ringe.');
  192.  
  193. -- --------------------------------------------------------
  194.  
  195. --
  196. -- Table structure for table `komandos`
  197. --
  198.  
  199. CREATE TABLE IF NOT EXISTS `komandos` (
  200. `ID` int(11) NOT NULL,
  201. `vadas` varchar(50) NOT NULL,
  202. `pavadinimas` varchar(50) NOT NULL,
  203. `veiksmai` int(11) NOT NULL,
  204. `kreditai` varchar(5) NOT NULL DEFAULT '0.0',
  205. `pinigai` int(11) NOT NULL,
  206. `viso_veiksmu` int(11) NOT NULL,
  207. `alga` int(11) NOT NULL
  208. ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
  209.  
  210. --
  211. -- Table structure for table `komentarai`
  212. --
  213.  
  214. CREATE TABLE IF NOT EXISTS `komentarai` (
  215. `ID` int(11) NOT NULL,
  216. `nick` varchar(50) NOT NULL,
  217. `kam` varchar(50) NOT NULL,
  218. `zinute` text NOT NULL,
  219. `data` varchar(50) NOT NULL
  220. ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
  221.  
  222.  
  223. -- --------------------------------------------------------
  224.  
  225. --
  226. -- Table structure for table `kovos`
  227. --
  228.  
  229. CREATE TABLE IF NOT EXISTS `kovos` (
  230. `ID` int(11) NOT NULL,
  231. `pavadinimas` varchar(50) NOT NULL,
  232. `lygis` int(11) NOT NULL,
  233. `duos_lygio` varchar(10) NOT NULL,
  234. `duos_jegos` varchar(10) NOT NULL,
  235. `duos_vikrumo` varchar(10) NOT NULL,
  236. `duos_pinigu` varchar(10) NOT NULL,
  237. `duos_points` varchar(10) NOT NULL,
  238. `foto` varchar(50) NOT NULL
  239. ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
  240.  
  241. --
  242. -- Dumping data for table `kovos`
  243. --
  244.  
  245. INSERT INTO `kovos` (`ID`, `pavadinimas`, `lygis`, `duos_lygio`, `duos_jegos`, `duos_vikrumo`, `duos_pinigu`, `duos_points`, `foto`) VALUES
  246. (1, 'Adam Cole', 1, '0.2', '0.1', '0.1', '10', '0.2', '1.gif'),
  247. (2, 'Aleister Black', 100, '0.3', '0.1', '0.2', '12', '0.2', '2.gif'),
  248. (3, 'Angelo Dawkins', 300, '0.3', '0.2', '0.2', '14', '0.3', '3.gif'),
  249. (4, 'Bobby Fish', 800, '0.4', '0.2', '0.3', '16', '0.3', '4.gif'),
  250. (5, 'Johnny Gargano', 1000, '0.4', '0.3', '0.3', '18', '0.4', '5.gif'),
  251. (6, 'Akam', 2000, '0.5', '0.3', '0.4', '20', '0.4', '6.gif'),
  252. (7, 'Apollo Crews', 3000, '0.5', '0.4', '0.4', '22', '0.5', '7.gif'),
  253. (8, 'Baron Corbin', 4000, '0.6', '0.4', '0.5', '24', '0.5', '8.gif'),
  254. (9, 'Bo Dallas', 5000, '0.6', '0.5', '0.5', '26', '0.6', '9.gif'),
  255. (10, 'Bobby Roode', 6000, '0.7', '0.5', '0.6', '28', '0.6', ''),
  256. (11, 'Curt Hawkins', 7000, '0.7', '0.6', '0.6', '30', '0.7', ''),
  257. (12, 'Big Show', 9000, '0.7', '0.6', '0.7', '35', '0.7', '12.gif'),
  258. (13, 'Braun Strowman', 11000, '0.7', '0.7', '0.7', '38', '0.7', '13.gif'),
  259. (14, 'Brock Lesnar', 13000, '0.8', '0.7', '0.7', '39', '0.7', '14.gif'),
  260. (15, 'Bray Wyatt', 20000, '0.8', '0.7', '0.8', '41', '0.7', '15.gif'),
  261. (16, 'Dean Ambrose', 30000, '0.8', '0.8', '0.8', '41', '0.7', '16.gif'),
  262. (17, 'Goldust', 40000, '0.8', '0.8', '0.9', '41', '0.8', '17.gif'),
  263. (18, 'Dolph Ziggler', 50000, '0.8', '0.9', '0.9', '42', '0.8', '18.gif'),
  264. (19, 'John Cena', 70000, '0.8', '0.9', '1', '44', '0.9', '19.gif');
  265.  
  266. -- --------------------------------------------------------
  267.  
  268. --
  269. -- Table structure for table `kovotojai`
  270. --
  271.  
  272. CREATE TABLE IF NOT EXISTS `kovotojai` (
  273. `ID` int(11) NOT NULL,
  274. `pavadinimas` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  275. `lytis` varchar(10) COLLATE utf8_lithuanian_ci NOT NULL
  276. ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  277.  
  278. --
  279. -- Dumping data for table `kovotojai`
  280. --
  281.  
  282. INSERT INTO `kovotojai` (`ID`, `pavadinimas`, `lytis`) VALUES
  283. (1, 'The Miz', 'Vyras'),
  284. (2, 'John Cena', 'Vyras'),
  285. (4, 'Dolph Ziggler', 'Vyras'),
  286. (5, 'Seth Rollins', 'Vyras'),
  287. (6, 'Triple H', 'Vyras'),
  288. (7, 'Kelly Kelly', 'Moteris'),
  289. (8, 'Nikki Bella', 'Moteris'),
  290. (9, 'Lana', 'Moteris'),
  291. (10, 'Maryse', 'Moteris'),
  292. (11, 'Paige', 'Moteris'),
  293. (12, 'Trish Stratus', 'Moteris'),
  294. (13, 'Roman Reigns', 'Vyras'),
  295. (14, 'Kofi Kingston', 'Vyras'),
  296. (15, 'Fin Balor', 'Vyras'),
  297. (16, 'AJ Styles', 'Vyras'),
  298. (17, 'Dean Ambrose', 'Vyras'),
  299. (18, 'Jeff Hardy', 'Vyras'),
  300. (19, 'Randy Orton', 'Vyras'),
  301. (20, 'Daniel Bryan', 'Vyras'),
  302. (21, 'Brock Lesnar', 'Vyras'),
  303. (22, 'Torrie Wilson', 'Moteris'),
  304. (23, 'The Undertaker', 'Vyras'),
  305. (24, 'Zack Ryder', 'Vyras'),
  306. (25, 'Rusev', 'Vyras'),
  307. (26, 'Kewin Owens', 'Vyras'),
  308. (27, 'Rhyno', 'Vyras'),
  309. (28, 'Braun Strowman', 'Vyras'),
  310. (29, 'Becky Lynch', 'Moteris');
  311.  
  312. -- --------------------------------------------------------
  313.  
  314. --
  315. -- Table structure for table `lygos`
  316. --
  317.  
  318. CREATE TABLE IF NOT EXISTS `lygos` (
  319. `ID` int(11) NOT NULL,
  320. `pavadinimas` varchar(50) NOT NULL,
  321. `gm` varchar(50) NOT NULL
  322. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  323.  
  324. --
  325. -- Dumping data for table `lygos`
  326. --
  327.  
  328. INSERT INTO `lygos` (`ID`, `pavadinimas`, `gm`) VALUES
  329. (1, 'Raw', 'kingofdeath'),
  330. (2, 'Smackdown', 'lunatic'),
  331. (5, 'Nxt', '');
  332.  
  333. -- --------------------------------------------------------
  334.  
  335. --
  336. -- Table structure for table `naujienos`
  337. --
  338.  
  339. CREATE TABLE IF NOT EXISTS `naujienos` (
  340. `ID` int(11) NOT NULL,
  341. `naujiena` text NOT NULL,
  342. `nick` varchar(20) NOT NULL,
  343. `data` varchar(20) NOT NULL
  344. ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
  345.  
  346. --
  347. -- Dumping data for table `naujienos`
  348. --
  349.  
  350. INSERT INTO `naujienos` (`ID`, `naujiena`, `nick`, `data`) VALUES
  351. (4, 'Pagražintas startui online, ideti superstar foto kovose.', 'Winston', '2019-08-08 / 22:28'),
  352. (5, 'Sukurtas auto kovu pirkimas. Zaideju prasymu padariau. Aptvarkytos kelios klaidos zaidime.', 'Winston', '2019-08-10 / 14:52'),
  353. (6, 'Kredituose įdėta nuovargio limito didinimas.', 'Winston', '2019-08-10 / 18:38'),
  354. (7, 'Patobulintas dienos konkursas. Dabar žinosite 3 vakarykčius buvusius laimėtojus, bei daugiausiai atlikusi žaidėja veiksmų per dieną.', 'Winston', '2019-08-10 / 22:59'),
  355. (8, 'Lygose įdėta papildoma informacija apie kovas ir kaip pasirašyti kontrakta su lyga. Einam paskaityt.', 'Winston', '2019-08-10 / 23:31'),
  356. (9, 'Yra labai aktyvių kovotojų žaidime. Tai pridėjau kovotojų daugiau kovojimo lauke. Taip pat, ir kai kuriuos pasiekimius.', 'Winston', '2019-08-11 / 18:55'),
  357. (10, 'Sukurti kontraktai. Gauti galima kovose. Gave siunciam generaliniui direktoriui. Ir galite registruotis del titulu.', 'Winston', '2019-08-12 / 22:18'),
  358. (11, 'Pagražintas stilius.', 'Winston', '2019-08-13 / 16:11'),
  359. (12, 'Šiandien 20:00 val, dalybos!! Kviečiu visus WWE fanus susirinkti šia valanda.', 'Winston', '2019-08-14 / 14:58'),
  360. (13, 'Nuo šiol matysite žaidejo informacijoje kokioje lygoje priklauso žaidėjas.', 'Winston', '2019-08-15 / 22:07'),
  361. (14, 'Patobulintos komandos, atnaujinimas padarytas vakar, tik šiandien ji rašau. Taip pat eina daryti pervedimus žaidėjams.', 'Winston', '2019-08-16 / 16:11'),
  362. (15, 'Online rekordas 10! Visi gavote kurie buvo po kreditą dovanos iš manęs.', 'Winston', '2019-08-16 / 16:26'),
  363. (16, 'Nuo šiol nuovargi atskaičiuos po -0,5 o nebe -1. Kadangi per dažnai gal kiek tekdavo miegučio eit. Primenu, šiandien 22:00 Lunatic Vs Vipepipe didysis show dėl IC titulo! Prisijunge, gaus visi po 500 points!', 'Winston', '2019-08-16 / 19:52'),
  364. (18, 'Sukurtas sporto klubas. Dabar turėsite kur išleidinėti Money. ;)', 'Winston', '2019-08-18 / 13:01'),
  365. (19, 'Dabar žaidimo topuose, rasite ir lygių topus.', 'Winston', '2019-08-18 / 19:23'),
  366. (20, 'Papildytos komandu funkcijos.', 'Winston', '2019-08-19 / 06:06'),
  367. (21, 'Lygose sudėti mandresni photo titulų užrašams. Ačiū mūsų žaidėjui Hariok!', 'Winston', '2019-08-19 / 20:40'),
  368. (22, 'Sukurta reputacijos davimas zaidejams.', 'Winston', '2019-08-20 / 06:13'),
  369. (23, 'Sutvarkyti pervedimai, buvo pora bugeriu kurie pasinaudojo. Dabar bus ok.', 'Winston', '2019-08-20 / 22:12'),
  370. (24, 'Sukurta balsavimo sistema', 'Winston', '2019-08-21 / 16:58'),
  371. (25, 'Nuo dabar galesite iseiti is komandos', 'Winston', '2019-08-21 / 18:06'),
  372. (26, 'Sukurtas nuovargio limito didinimas. Rasite kovose.', 'Winston', '2019-08-22 / 15:52'),
  373. (27, 'Sukurta žaidimo valdžia. Mieste galėsite peržiurėti.', 'Winston', '2019-08-22 / 17:50'),
  374. (28, 'Online padaryta naujovė. Paspaudus ant šiandien daugiausiai prisijungusiu skaičiaus, jums išmes visa istorija visu dienu kiek ta diena buvo daugiausiai prisijungusiu.', 'Winston', '2019-08-22 / 18:10'),
  375. (29, 'Sukurtas normalus DUK. Kas neaišku, galėsite paklausti administracija padės.', 'Winston', '2019-08-23 / 15:47'),
  376. (30, 'Sutvarkyti pretedentai del titulu.', 'Winston', '2019-09-17 / 20:54'),
  377. (31, 'Padidinti prizai dienos konkurse', 'Winston', '2019-09-17 / 20:55'),
  378. (32, 'Ragistracija išjungta, naujas Savininkas naujos įdėjos naujos mintis greitu metu bus svetainės restartas viskas nuo 0. Prašom grįšti kas pabėgot pagarbiai Naujas Savininkas.', 'Winston', '2019-10-22 / 17:53');
  379.  
  380. -- --------------------------------------------------------
  381.  
  382. --
  383. -- Table structure for table `naujienu_reputacija`
  384. --
  385.  
  386. CREATE TABLE IF NOT EXISTS `naujienu_reputacija` (
  387. `ID` int(11) NOT NULL,
  388. `nick` varchar(20) NOT NULL,
  389. `vertinimas` int(11) NOT NULL,
  390. `kam` int(11) NOT NULL
  391. ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
  392.  
  393.  
  394. -- --------------------------------------------------------
  395.  
  396. --
  397. -- Table structure for table `online`
  398. --
  399.  
  400. CREATE TABLE IF NOT EXISTS `online` (
  401. `ID` int(11) NOT NULL,
  402. `nick` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  403. `vieta` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  404. `laikas` int(11) NOT NULL,
  405. `online` int(11) NOT NULL,
  406. `narsykle` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  407. `statusas` int(11) NOT NULL
  408. ) ENGINE=InnoDB AUTO_INCREMENT=5168 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  409.  
  410. --
  411. -- Dumping data for table `online`
  412. --
  413.  
  414. INSERT INTO `online` (`ID`, `nick`, `vieta`, `laikas`, `online`, `narsykle`, `statusas`) VALUES
  415. (5165, 'Winston', 'Administratoriaus meniu', 1571762724, 1571762424, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWeb', 2),
  416. (5167, 'Admin', 'Žaidime', 1571762807, 1571762507, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWeb', 0);
  417.  
  418. -- --------------------------------------------------------
  419.  
  420. --
  421. -- Table structure for table `online_list`
  422. --
  423.  
  424. CREATE TABLE IF NOT EXISTS `online_list` (
  425. `ID` int(11) NOT NULL,
  426. `online` int(11) NOT NULL,
  427. `data` varchar(20) NOT NULL
  428. ) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8;
  429.  
  430. -- --------------------------------------------------------
  431.  
  432. --
  433. -- Table structure for table `parduotuve`
  434. --
  435.  
  436. CREATE TABLE IF NOT EXISTS `parduotuve` (
  437. `ID` int(11) NOT NULL,
  438. `pavadinimas` varchar(50) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
  439. `kaina` int(11) NOT NULL
  440. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  441.  
  442. --
  443. -- Dumping data for table `parduotuve`
  444. --
  445.  
  446. INSERT INTO `parduotuve` (`ID`, `pavadinimas`, `kaina`) VALUES
  447. (1, 'Mikrafonas', 1),
  448. (4, 'Kede', 4),
  449. (5, 'Kujis', 8);
  450.  
  451. -- --------------------------------------------------------
  452.  
  453. --
  454. -- Table structure for table `pasiekimai`
  455. --
  456.  
  457. CREATE TABLE IF NOT EXISTS `pasiekimai` (
  458. `ID` int(11) NOT NULL,
  459. `reikia` int(11) NOT NULL,
  460. `atlygis` int(11) NOT NULL,
  461. `pasiekimas` int(11) NOT NULL,
  462. `pasiekimo_nr` int(11) NOT NULL
  463. ) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8;
  464.  
  465. --
  466. -- Dumping data for table `pasiekimai`
  467. --
  468.  
  469. INSERT INTO `pasiekimai` (`ID`, `reikia`, `atlygis`, `pasiekimas`, `pasiekimo_nr`) VALUES
  470. (1, 150, 150, 1, 1),
  471. (2, 500, 500, 1, 2),
  472. (3, 1000, 1000, 1, 3),
  473. (4, 2000, 2000, 1, 4),
  474. (5, 3000, 3000, 1, 5),
  475. (6, 4000, 4000, 1, 6),
  476. (7, 5000, 5000, 1, 7),
  477. (8, 6000, 6000, 1, 8),
  478. (14, 7000, 7000, 1, 9),
  479. (15, 150, 150, 2, 1),
  480. (16, 500, 500, 2, 2),
  481. (17, 1000, 1000, 2, 3),
  482. (18, 2000, 2000, 2, 4),
  483. (19, 3000, 3000, 2, 5),
  484. (20, 4000, 4000, 2, 6),
  485. (21, 5000, 5000, 2, 7),
  486. (22, 6000, 6000, 2, 8),
  487. (23, 7000, 7000, 2, 9),
  488. (24, 150, 150, 3, 1),
  489. (25, 500, 500, 3, 2),
  490. (26, 1000, 1000, 3, 3),
  491. (27, 2000, 2000, 3, 4),
  492. (30, 3000, 3000, 3, 5),
  493. (31, 4000, 4000, 3, 6),
  494. (32, 5000, 5000, 3, 7),
  495. (33, 6000, 6000, 3, 8),
  496. (34, 7000, 7000, 3, 9),
  497. (35, 150, 150, 4, 1),
  498. (36, 500, 500, 4, 2),
  499. (37, 1000, 1000, 4, 3),
  500. (38, 2000, 2000, 4, 4),
  501. (39, 3000, 3000, 4, 5),
  502. (40, 4000, 4000, 4, 6),
  503. (41, 5000, 5000, 4, 7),
  504. (42, 6000, 6000, 4, 8),
  505. (43, 7000, 7000, 4, 9),
  506. (44, 8500, 1000, 1, 9),
  507. (45, 10000, 1000, 4, 10),
  508. (46, 15000, 2000, 4, 11),
  509. (47, 25000, 3000, 4, 12),
  510. (48, 40000, 4000, 4, 13),
  511. (49, 60000, 5000, 4, 14),
  512. (50, 15000, 1000, 1, 10),
  513. (51, 20000, 1000, 1, 11),
  514. (52, 40000, 1000, 1, 12),
  515. (53, 60000, 1000, 1, 13),
  516. (54, 80000, 1000, 1, 14),
  517. (55, 100000, 1000, 1, 15);
  518.  
  519. -- --------------------------------------------------------
  520.  
  521. --
  522. -- Table structure for table `pasiulymai`
  523. --
  524.  
  525. CREATE TABLE IF NOT EXISTS `pasiulymai` (
  526. `ID` int(11) NOT NULL,
  527. `nick` varchar(50) NOT NULL,
  528. `zinute` text NOT NULL,
  529. `data` varchar(50) NOT NULL,
  530. `laikas` int(11) NOT NULL,
  531. `busena` varchar(50) NOT NULL
  532. ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
  533.  
  534. --
  535. -- Table structure for table `pasiulymu_vertinimas`
  536. --
  537.  
  538. CREATE TABLE IF NOT EXISTS `pasiulymu_vertinimas` (
  539. `ID` int(11) NOT NULL,
  540. `nr` int(11) NOT NULL,
  541. `nick` varchar(50) NOT NULL,
  542. `vertinimas` int(11) NOT NULL
  543. ) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8;
  544.  
  545.  
  546. --
  547. -- Table structure for table `pokalbiai`
  548. --
  549.  
  550. CREATE TABLE IF NOT EXISTS `pokalbiai` (
  551. `ID` int(11) NOT NULL,
  552. `nick` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  553. `zinute` text COLLATE utf8_lithuanian_ci NOT NULL,
  554. `data` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  555. `laikas` int(11) NOT NULL
  556. ) ENGINE=InnoDB AUTO_INCREMENT=450 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  557.  
  558. --
  559. -- Table structure for table `reputacija`
  560. --
  561.  
  562. CREATE TABLE IF NOT EXISTS `reputacija` (
  563. `ID` int(11) NOT NULL,
  564. `nick` varchar(50) NOT NULL,
  565. `vertinimas` int(11) NOT NULL,
  566. `kam` varchar(50) NOT NULL
  567. ) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8;
  568.  
  569. --
  570. -- Table structure for table `ringas`
  571. --
  572.  
  573. CREATE TABLE IF NOT EXISTS `ringas` (
  574. `ID` int(11) NOT NULL,
  575. `nick` varchar(50) NOT NULL,
  576. `cempionas` varchar(50) NOT NULL,
  577. `galiojimas` int(11) NOT NULL,
  578. `veiksmas` int(11) NOT NULL
  579. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  580.  
  581. -- --------------------------------------------------------
  582.  
  583. --
  584. -- Table structure for table `ringo_israsas`
  585. --
  586.  
  587. CREATE TABLE IF NOT EXISTS `ringo_israsas` (
  588. `ID` int(11) NOT NULL,
  589. `nr` int(11) NOT NULL,
  590. `veiksmas` text NOT NULL
  591. ) ENGINE=InnoDB AUTO_INCREMENT=676 DEFAULT CHARSET=utf8;
  592.  
  593. --
  594. -- Table structure for table `titulai`
  595. --
  596.  
  597. CREATE TABLE IF NOT EXISTS `titulai` (
  598. `ID` int(11) NOT NULL,
  599. `nick` varchar(50) NOT NULL,
  600. `veiksmai` int(11) NOT NULL,
  601. `titulas` int(11) NOT NULL
  602. ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;
  603.  
  604. -- --------------------------------------------------------
  605.  
  606. --
  607. -- Table structure for table `titulo_cempionai`
  608. --
  609.  
  610. CREATE TABLE IF NOT EXISTS `titulo_cempionai` (
  611. `ID` int(11) NOT NULL,
  612. `nick` varchar(50) NOT NULL,
  613. `titulas` int(11) NOT NULL,
  614. `data` varchar(20) NOT NULL
  615. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
  616.  
  617. --
  618. -- Table structure for table `titulo_cempionai_istorija`
  619. --
  620.  
  621. CREATE TABLE IF NOT EXISTS `titulo_cempionai_istorija` (
  622. `ID` int(11) NOT NULL,
  623. `nick` varchar(50) NOT NULL,
  624. `titulas` int(11) NOT NULL,
  625. `data` varchar(50) NOT NULL,
  626. `ateme_is` varchar(50) NOT NULL,
  627. `islaike_dienu` int(11) NOT NULL
  628. ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
  629.  
  630. --
  631. -- Table structure for table `titulo_laimetojai`
  632. --
  633.  
  634. CREATE TABLE IF NOT EXISTS `titulo_laimetojai` (
  635. `ID` int(11) NOT NULL,
  636. `titulas` int(11) NOT NULL,
  637. `laimetojas` varchar(50) NOT NULL,
  638. `veiksmai` int(11) NOT NULL
  639. ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;
  640.  
  641. --
  642. -- Table structure for table `topic`
  643. --
  644.  
  645. CREATE TABLE IF NOT EXISTS `topic` (
  646. `ID` int(11) NOT NULL,
  647. `topic` int(11) NOT NULL,
  648. `nick` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  649. `zinute` text COLLATE utf8_lithuanian_ci NOT NULL,
  650. `data` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL
  651. ) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  652.  
  653. --
  654. -- Table structure for table `uzbaninti`
  655. --
  656.  
  657. CREATE TABLE IF NOT EXISTS `uzbaninti` (
  658. `ID` int(50) NOT NULL,
  659. `nick` varchar(50) NOT NULL,
  660. `laikas` int(11) NOT NULL,
  661. `priezastis` varchar(90) NOT NULL
  662. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
  663.  
  664. --
  665. -- Table structure for table `uzkulsiai`
  666. --
  667.  
  668. CREATE TABLE IF NOT EXISTS `uzkulsiai` (
  669. `ID` int(11) NOT NULL,
  670. `pavadinimas` varchar(50) NOT NULL,
  671. `lygis` int(11) NOT NULL
  672. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  673.  
  674. --
  675. -- Dumping data for table `uzkulsiai`
  676. --
  677.  
  678. INSERT INTO `uzkulsiai` (`ID`, `pavadinimas`, `lygis`) VALUES
  679. (1, 'Pamestas D-Generation komandos daiktas', 150),
  680. (2, 'Velveteen Dream pasiklydo uzkulsiuose', 300),
  681. (3, 'Isgelbek Nikki Bella nuo uzpuoliku', 700),
  682. (4, 'Hardy Boyz panikoje', 1500),
  683. (5, 'Xavier Woods uzsirove', 3000);
  684.  
  685. -- --------------------------------------------------------
  686.  
  687. --
  688. -- Table structure for table `uzkulsiai_isgavimai`
  689. --
  690.  
  691. CREATE TABLE IF NOT EXISTS `uzkulsiai_isgavimai` (
  692. `ID` int(11) NOT NULL,
  693. `nick` varchar(50) NOT NULL,
  694. `nr` int(11) NOT NULL,
  695. `laikas` int(11) NOT NULL
  696. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  697.  
  698. -- --------------------------------------------------------
  699.  
  700. --
  701. -- Table structure for table `veidukai`
  702. --
  703.  
  704. CREATE TABLE IF NOT EXISTS `veidukai` (
  705. `ID` int(10) NOT NULL,
  706. `kodas` text NOT NULL,
  707. `adresas` text NOT NULL
  708. ) ENGINE=InnoDB AUTO_INCREMENT=337 DEFAULT CHARSET=latin1;
  709.  
  710. --
  711. -- Dumping data for table `veidukai`
  712. --
  713.  
  714. INSERT INTO `veidukai` (`ID`, `kodas`, `adresas`) VALUES
  715. (1, ';)', '/snukiai/29445.gif'),
  716. (2, ':)', '/snukiai/28738.gif'),
  717. (3, ':(', '/snukiai/28737.gif'),
  718. (4, ':]', '/snukiai/28739.gif'),
  719. (5, ' ;D', '/snukiai/28751.gif'),
  720. (6, ':*', '/snukiai/29440.gif'),
  721. (7, ':aciu:', '/snukiai/28897.gif'),
  722. (8, ':acute:', '/snukiai/28834.gif'),
  723. (9, ':alive:', '/snukiai/30830.gif'),
  724. (10, ':ax:', '/snukiai/28879.gif'),
  725. (11, ':behappy:', '/snukiai/28901.gif'),
  726. (12, ':bye:', '/snukiai/28837.gif'),
  727. (13, ':bye2:', '/snukiai/30837.gif'),
  728. (14, ':bye3:', '/snukiai/30838.gif'),
  729. (15, ':bo:', '/snukiai/28838.gif'),
  730. (16, ':boredom:', '/snukiai/28839.gif'),
  731. (17, ':cha:', '/snukiai/29434.gif'),
  732. (18, ':cry2:', '/snukiai/28842.gif'),
  733. (19, ' :D', '/snukiai/28745.gif'),
  734. (20, ':fuck:', '/snukiai/29449.gif'),
  735. (21, ':G', '/snukiai/29450.gif'),
  736. (22, ':galvoja:', '/snukiai/28867.gif'),
  737. (23, ':ha:', '/snukiai/28747.gif'),
  738. (24, ':hey:', '/snukiai/29419.gif'),
  739. (25, ':hello:', '/snukiai/29432.gif'),
  740. (26, ':hi:', '/snukiai/28851.gif'),
  741. (27, ':hi2:', '/snukiai/29424.gif'),
  742. (28, ':hihi:', '/snukiai/28924.gif'),
  743. (29, ':hm2:', '/snukiai/30970.gif'),
  744. (30, ':holle:', '/snukiai/31557.gif'),
  745. (31, ':iki:', '/snukiai/29670.gif'),
  746. (32, ':kadaryt:', '/snukiai/28919.gif'),
  747. (33, ':la:', '/snukiai/29435.gif'),
  748. (34, ':labas:', '/snukiai/28782.gif'),
  749. (35, ':lazy:', '/snukiai/29727.gif'),
  750. (36, ':lazy2:', '/snukiai/29820.gif'),
  751. (37, ':lol:', '/snukiai/28752.gif'),
  752. (38, ':lol2:', '/snukiai/28886.gif'),
  753. (39, ':maldauja:', '/snukiai/28785.gif'),
  754. (40, ':memba:', '/snukiai/28859.gif'),
  755. (41, ':nea:', '/snukiai/28862.gif'),
  756. (42, ':no:', '/snukiai/28894.gif'),
  757. (43, ':O', '/snukiai/28890.gif'),
  758. (44, ':ok:', '/snukiai/28864.gif'),
  759. (45, ':P', '/snukiai/31500.gif'),
  760. (46, ':pff:', '/snukiai/29822.gif'),
  761. (47, ':photo:', '/snukiai/28932.gif'),
  762. (48, ':ploja:', '/snukiai/28948.gif'),
  763. (49, ':rofl:', '/snukiai/28757.gif'),
  764. (50, ':rose:', '/snukiai/28866.gif'),
  765. (51, ':S', '/snukiai/31494.gif'),
  766. (52, ':secret:', '/snukiai/28868.gif'),
  767. (53, ':seilius:', '/snukiai/29471.gif'),
  768. (54, ':shy2:', '/snukiai/31547.gif'),
  769. (55, ':sleep:', '/snukiai/28792.gif'),
  770. (56, ':sleepy:', '/snukiai/31571.gif'),
  771. (57, ':smoke:', '/snukiai/28793.gif'),
  772. (58, ':stop:', '/snukiai/28869.gif'),
  773. (59, ':stop2:', '/snukiai/30996.gif'),
  774. (60, ':swoon:', '/snukiai/29478.gif'),
  775. (61, ':taip:', '/snukiai/28798.gif'),
  776. (63, ':unsure:', '/snukiai/28871.gif'),
  777. (64, ':vava:', '/snukiai/28872.gif'),
  778. (65, ':victory:', '/snukiai/28800.gif'),
  779. (66, ':wacko:', '/snukiai/28873.gif'),
  780. (67, ':wait:', '/snukiai/28941.gif'),
  781. (68, ':wall:', '/snukiai/28925.gif'),
  782. (69, ':what:', '/snukiai/28780.gif'),
  783. (70, ':wink:', '/snukiai/28760.gif'),
  784. (71, ':wow:', '/snukiai/28889.gif'),
  785. (72, ':write:', '/snukiai/28858.gif'),
  786. (73, ':xe:', '/snukiai/28801.gif'),
  787. (74, ':xe2:', '/snukiai/28802.gif'),
  788. (75, ':xe3:', '/snukiai/29436.gif'),
  789. (76, ':xi:', '/snukiai/28860.gif'),
  790. (77, ':zzz:', '/snukiai/28909.gif'),
  791. (78, '=)', '/snukiai/28746.gif'),
  792. (79, '=D', '/snukiai/28933.gif'),
  793. (80, '=Q', '/snukiai/30824.gif'),
  794. (81, 'xD', '/snukiai/29839.gif'),
  795. (82, 'xP', '/snukiai/29711.gif'),
  796. (83, ':airkiss:', '/snukiai/28836.gif'),
  797. (84, ':amuras:', '/snukiai/28934.gif'),
  798. (85, ':angel:', '/snukiai/28833.gif'),
  799. (86, ':antranku:', '/snukiai/29683.gif'),
  800. (87, ':balade:', '/snukiai/28936.gif'),
  801. (88, ':blush:', '/snukiai/28742.gif'),
  802. (89, ':buckis:', '/snukiai/30843.gif'),
  803. (90, ':catlove:', '/snukiai/29767.gif'),
  804. (91, ':cute:', '/snukiai/30940.gif'),
  805. (92, ':drovil:', '/snukiai/29677.gif'),
  806. (93, ':drovisi:', '/snukiai/29676.gif'),
  807. (94, ':dukra:', '/snukiai/30976.gif'),
  808. (95, ':eiks:', '/snukiai/29678.gif'),
  809. (96, ':fyfius:', '/snukiai/30931.gif'),
  810. (97, ':flirt:', '/snukiai/29723.gif'),
  811. (98, ':flirt2:', '/snukiai/29791.gif'),
  812. (99, ':flower:', '/snukiai/28904.gif'),
  813. (100, ':gele:', '/snukiai/29844.gif'),
  814. (101, ':getlost:', '/snukiai/29444.gif'),
  815. (102, ':girllove:', '/snukiai/29458.gif'),
  816. (103, ':givekiss:', '/snukiai/29732.gif'),
  817. (104, ':heart:', '/snukiai/28852.gif'),
  818. (105, ':heart2:', '/snukiai/28906.gif'),
  819. (106, ':hug:', '/snukiai/28884.gif'),
  820. (107, ':hug2:', '/snukiai/30946.gif'),
  821. (108, ':inlove:', '/snukiai/28749.gif'),
  822. (109, ':inlove2:', '/snukiai/30870.gif'),
  823. (110, ':inlove3:', '/snukiai/30982.gif'),
  824. (111, ':kiss:', '/snukiai/28854.gif'),
  825. (112, ':kiss2:', '/snukiai/28855.gif'),
  826. (113, ':kiss3:', '/snukiai/29425.gif'),
  827. (114, ':laizekas:', '/snukiai/31562.gif'),
  828. (115, ':love:', '/snukiai/28911.gif'),
  829. (116, ':loveinair:', '/snukiai/29843.gif'),
  830. (117, ':loveyou:', '/snukiai/31501.gif'),
  831. (118, ':lovenot:', '/snukiai/28899.gif'),
  832. (119, ':luw:', '/snukiai/30880.gif'),
  833. (120, ':luw2:', '/snukiai/30958.gif'),
  834. (121, ':mylinemyli:', '/snukiai/28912.gif'),
  835. (122, ':myliu:', '/snukiai/29679.gif'),
  836. (123, ':myliukas:', '/snukiai/29430.gif'),
  837. (124, ':mua:', '/snukiai/29439.gif'),
  838. (125, ':pa:', '/snukiai/29693.gif'),
  839. (126, ':pm2:', '/snukiai/29441.gif'),
  840. (127, ':ponas:', '/snukiai/29465.gif'),
  841. (128, ':pora:', '/snukiai/29466.gif'),
  842. (129, ':porele:', '/snukiai/29467.gif'),
  843. (130, ':puokste:', '/snukiai/30955.gif'),
  844. (131, ':ramune:', '/snukiai/29469.gif'),
  845. (132, ':raustu:', '/snukiai/30899.gif'),
  846. (133, ':roze:', '/snukiai/28913.gif'),
  847. (134, ':shy:', '/snukiai/28758.gif'),
  848. (135, ':sunus:', '/snukiai/30975.gif'),
  849. (136, ':svaja:', '/snukiai/29477.gif'),
  850. (137, ':svaja2:', '/snukiai/30968.gif'),
  851. (138, ':svajoja:', '/snukiai/28896.gif'),
  852. (139, ':tau:', '/snukiai/30916.gif'),
  853. (140, ':ups:', '/snukiai/29482.gif'),
  854. (141, ':utiutiu:', '/snukiai/30887.gif'),
  855. (142, ':vestuves:', '/snukiai/30985.gif'),
  856. (143, ':wub:', '/snukiai/29483.gif'),
  857. (144, ':xmeile:', '/snukiai/29698.gif'),
  858. (145, ':aa:', '/snukiai/29737.gif'),
  859. (146, ':ablom:', '/snukiai/30924.gif'),
  860. (147, ':aciu2:', '/snukiai/29738.gif'),
  861. (148, ':anciukusokis:', '/snukiai/31502.gif'),
  862. (149, ':angel2:', '/snukiai/29743.gif'),
  863. (150, ':apalpo:', '/snukiai/28892.gif'),
  864. (151, ':apkalbos:', '/snukiai/31504.gif'),
  865. (152, ':ass:', '/snukiai/29746.gif'),
  866. (153, ':baby:', '/snukiai/28898.gif'),
  867. (154, ':bai:', '/snukiai/29720.gif'),
  868. (155, ':be:', '/snukiai/30841.gif'),
  869. (156, ':beach:', '/snukiai/29751.gif'),
  870. (157, ':bebe:', '/snukiai/28877.gif'),
  871. (158, ':bebe2:', '/snukiai/30898.gif'),
  872. (159, ':bedantis:', '/snukiai/29447.gif'),
  873. (160, ':bee:', '/snukiai/28741.gif'),
  874. (161, ':biggrin:', '/snukiai/30833.gif'),
  875. (162, ':bigsmile:', '/snukiai/30834.gif'),
  876. (163, ':byta2:', '/snukiai/30954.gif'),
  877. (164, ':bla:', '/snukiai/30867.gif'),
  878. (165, ':blum:', '/snukiai/30901.gif'),
  879. (166, ':boksas:', '/snukiai/29761.gif'),
  880. (167, ':botagas:', '/snukiai/28893.gif'),
  881. (168, ':broken2:', '/snukiai/30993.gif'),
  882. (169, ':burbulai:', '/snukiai/30844.gif'),
  883. (170, ':cirkas:', '/snukiai/31683.gif'),
  884. (171, ':clap:', '/snukiai/28743.gif'),
  885. (172, ':come:', '/snukiai/31000.gif'),
  886. (173, ':coolboy:', '/snukiai/30847.gif'),
  887. (174, ':coolgirl:', '/snukiai/30859.gif'),
  888. (175, ':crazy:', '/snukiai/28744.gif'),
  889. (176, ':dance:', '/snukiai/28843.gif'),
  890. (177, ':dance2:', '/snukiai/29776.gif'),
  891. (178, ':dance3:', '/snukiai/30849.gif'),
  892. (179, ':dancer:', '/snukiai/28910.gif'),
  893. (180, ':dancing:', '/snukiai/29686.gif'),
  894. (181, ':debilas:', '/snukiai/29488.gif'),
  895. (182, ':dink:', '/snukiai/30850.gif'),
  896. (183, ':dirol:', '/snukiai/28846.gif'),
  897. (184, ':doubleup:', '/snukiai/29779.gif'),
  898. (185, ':download:', '/snukiai/31575.gif'),
  899. (186, ':drive:', '/snukiai/30851.gif'),
  900. (187, ':durnas:', '/snukiai/28903.gif'),
  901. (188, ':duxas:', '/snukiai/29487.gif'),
  902. (189, ':fau:', '/snukiai/29840.gif'),
  903. (190, ':fenas:', '/snukiai/29688.gif'),
  904. (191, ':fyfa:', '/snukiai/29719.gif'),
  905. (192, ':fyfa2:', '/snukiai/29789.gif'),
  906. (193, ':fyfuke:', '/snukiai/30862.gif'),
  907. (194, ':five:', '/snukiai/29675.gif'),
  908. (195, ':flirtas:', '/snukiai/31552.gif'),
  909. (196, ':flower2:', '/snukiai/31495.gif'),
  910. (197, ':freddy:', '/snukiai/31553.gif'),
  911. (198, ':friends:', '/snukiai/28881.gif'),
  912. (199, ':girl:', '/snukiai/28942.gif'),
  913. (200, ':girtas2:', '/snukiai/31497.gif'),
  914. (201, ':gogo:', '/snukiai/29691.gif'),
  915. (202, ':good:', '/snukiai/30863.gif'),
  916. (203, ':greiciau:', '/snukiai/30943.gif'),
  917. (204, ':haba:', '/snukiai/29674.gif'),
  918. (205, ':haha:', '/snukiai/28775.gif'),
  919. (206, ':happy:', '/snukiai/28748.gif'),
  920. (207, ':happy2:', '/snukiai/28883.gif'),
  921. (208, ':hehe:', '/snukiai/29805.gif'),
  922. (209, ':help:', '/snukiai/30854.gif'),
  923. (210, ':hide:', '/snukiai/30984.gif'),
  924. (211, ':hmz:', '/snukiai/29806.gif'),
  925. (212, ':horse:', '/snukiai/31558.gif'),
  926. (213, ':huh:', '/snukiai/29807.gif'),
  927. (214, ':yahoo:', '/snukiai/28750.gif'),
  928. (215, ':yaya:', '/snukiai/30857.gif'),
  929. (216, ':yatta:', '/snukiai/31498.gif'),
  930. (217, ':ideja:', '/snukiai/29808.gif'),
  931. (218, ':yea:', '/snukiai/28778.gif'),
  932. (219, ':yeah:', '/snukiai/28863.gif'),
  933. (220, ':juokas:', '/snukiai/28761.gif'),
  934. (221, ':kaitina:', '/snukiai/31572.gif'),
  935. (222, ':kalbu:', '/snukiai/29453.gif'),
  936. (223, ':kapish:', '/snukiai/30974.gif'),
  937. (224, ':karate:', '/snukiai/31560.gif'),
  938. (225, ':kaveikt:', '/snukiai/29454.gif'),
  939. (226, ':king:', '/snukiai/28781.gif'),
  940. (227, ':kuku:', '/snukiai/29673.gif'),
  941. (228, ':kulverstis:', '/snukiai/30876.gif'),
  942. (229, ':kuti:', '/snukiai/30959.gif'),
  943. (230, ':lab:', '/snukiai/31561.gif'),
  944. (231, ':laistau:', '/snukiai/29455.gif'),
  945. (232, ':lankas:', '/snukiai/29457.gif'),
  946. (233, ':laugh:', '/snukiai/30878.gif'),
  947. (234, ':laught:', '/snukiai/31563.gif'),
  948. (235, ':lauzas:', '/snukiai/31681.gif'),
  949. (236, ':lazda:', '/snukiai/31564.gif'),
  950. (237, ':lbx:', '/snukiai/31685.gif'),
  951. (238, ':lenk:', '/snukiai/30879.gif'),
  952. (239, ':lyzt:', '/snukiai/31565.gif'),
  953. (240, ':look:', '/snukiai/30989.gif'),
  954. (241, ':maco:', '/snukiai/31576.gif'),
  955. (242, ':meistras:', '/snukiai/30991.gif'),
  956. (243, ':mezgu:', '/snukiai/30885.gif'),
  957. (244, ':miega:', '/snukiai/31001.gif'),
  958. (245, ':yes:', '/snukiai/yes.gif'),
  959. (246, ':25', '/snukiai/25.gif'),
  960. (247, ':Q', '/snukiai/Q.gif'),
  961. (248, ':broken:', '/snukiai/broken.gif'),
  962. (249, ':byta', '/snukiai/byta.gif'),
  963. (250, ':dry:', '/snukiai/dry.gif'),
  964. (251, ':rock:', '/snukiai/rock.gif'),
  965. (252, ':sun:', '/snukiai/sun.gif'),
  966. (253, ':TPP:', '/snukiai/P.gif'),
  967. (254, ':TOO:', '/snukiai/O.gif'),
  968. (255, ':HH:', '/snukiai/H.gif'),
  969. (256, ':taskas:', '/snukiai/taskas.gif'),
  970. (257, ':LL:', '/snukiai/L.gif'),
  971. (258, ':TT:', '/snukiai/T.gif'),
  972. (279, '(y)', '/snukiai/(y).gif'),
  973. (280, '(n)', '/snukiai/(n).gif'),
  974. (281, ':A', '/snukiai/A.gif'),
  975. (282, ':fp', '/snukiai/fp.gif'),
  976. (283, ':dull:', '/snukiai/dull.gif'),
  977. (284, ':giggle:', '/snukiai/giggle.gif'),
  978. (285, ':fubar:', '/snukiai/fubar.gif'),
  979. (286, ':dx:', '/snukiai/dx.gif'),
  980. (287, ':zvengiu:', '/snukiai/zvengiu.gif'),
  981. (288, ':evil:', '/snukiai/evil.gif'),
  982. (289, ':kiss4:', '/snukiai/kiss4.gif'),
  983. (290, ':finger:', '/snukiai/finger.gif'),
  984. (291, ':trenktas', '/snukiai/trenktas.gif'),
  985. (292, ':kede:', '/snukiai/kede.gif'),
  986. (293, ':bakst:', '/snukiai/bakst.gif'),
  987. (294, ':saudau:', '/snukiai/saudau.gif'),
  988. (295, ':dziaga:', '/snukiai/dziaga.gif'),
  989. (296, ':juokiuos:', '/snukiai/juokiuos.gif'),
  990. (297, ':B', '/snukiai/B.gif'),
  991. (298, ':oops:', '/snukiai/oops.gif'),
  992. (299, ':nosis:', '/snukiai/nosis.gif'),
  993. (300, ':valio:', '/snukiai/valio.gif'),
  994. (301, ':rock2:', '/snukiai/rock2.gif'),
  995. (302, ':omg:', '/snukiai/omg.gif'),
  996. (303, ':bado:', '/snukiai/bado.gif'),
  997. (304, ':heh:', '/snukiai/heh.gif'),
  998. (305, ':alus:', '/snukiai/alus.gif'),
  999. (306, ':dj:', '/snukiai/dj.gif'),
  1000. (307, ':karys:', '/snukiai/karys.gif'),
  1001. (308, ':karys2:', '/snukiai/karys2.gif'),
  1002. (309, ':ne:', '/snukiai/ne.gif'),
  1003. (310, ':teleskopas:', '/snukiai/teleskopas.gif'),
  1004. (311, ':beta:', '/snukiai/beta.gif'),
  1005. (313, ':W', '/snukiai/W.gif'),
  1006. (334, ':N', '/snukiai/N.gif'),
  1007. (335, ':-)', '/snukiai/747.gif'),
  1008. (336, ':labas2:', '/snukiai/labas.gif');
  1009.  
  1010. -- --------------------------------------------------------
  1011.  
  1012. --
  1013. -- Table structure for table `viesbuciai`
  1014. --
  1015.  
  1016. CREATE TABLE IF NOT EXISTS `viesbuciai` (
  1017. `ID` int(11) NOT NULL,
  1018. `nick` varchar(50) NOT NULL,
  1019. `pavadinimas` varchar(50) NOT NULL,
  1020. `kaina` int(11) NOT NULL,
  1021. `lygis` int(11) NOT NULL DEFAULT '1',
  1022. `pinigai` int(11) NOT NULL
  1023. ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
  1024.  
  1025. --
  1026. -- Table structure for table `zaidejai`
  1027. --
  1028.  
  1029. CREATE TABLE IF NOT EXISTS `zaidejai` (
  1030. `ID` int(11) NOT NULL,
  1031. `nick` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1032. `pass` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1033. `lytis` varchar(20) COLLATE utf8_lithuanian_ci NOT NULL,
  1034. `kovotojas` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1035. `statusas` int(11) NOT NULL,
  1036. `lygis` varchar(10) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT '1',
  1037. `jega` varchar(10) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT '10',
  1038. `vikrumas` varchar(10) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT '15',
  1039. `gyvybe` int(11) NOT NULL DEFAULT '100',
  1040. `energija` varchar(5) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT '100',
  1041. `max_energija` int(11) NOT NULL DEFAULT '100',
  1042. `kreditai` varchar(10) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT '0.0',
  1043. `pinigai` int(11) NOT NULL,
  1044. `uzdirbti_eurai` int(11) NOT NULL,
  1045. `registracija` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1046. `aktyvumas` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1047. `ip` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1048. `narsykle` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1049. `nuotrauka` varchar(100) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT 'img/nera_nuotraukos.png',
  1050. `apranga` int(11) NOT NULL,
  1051. `nuotaika` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT 'Neutrali',
  1052. `topic` varchar(250) COLLATE utf8_lithuanian_ci NOT NULL DEFAULT 'Topic nenustatytas.',
  1053. `pokalbiai` int(11) NOT NULL,
  1054. `veiksmai` int(11) NOT NULL DEFAULT '20',
  1055. `visi_veiksmai` int(11) NOT NULL,
  1056. `siandien_veiksmai` int(11) NOT NULL,
  1057. `dienos_veiksmai` int(11) NOT NULL,
  1058. `padusimai` int(11) NOT NULL,
  1059. `puolimai` int(11) NOT NULL DEFAULT '20',
  1060. `lygio_pasiekimas` int(11) NOT NULL DEFAULT '1',
  1061. `nepatvirtinta_nuotrauka` varchar(100) COLLATE utf8_lithuanian_ci NOT NULL,
  1062. `lyga` int(11) NOT NULL,
  1063. `lygos_kvietimas` int(11) NOT NULL,
  1064. `points` varchar(5) COLLATE utf8_lithuanian_ci NOT NULL,
  1065. `laimetu_kovu_ringe` int(11) NOT NULL,
  1066. `pralaimetu_kovu_ringe` int(11) NOT NULL,
  1067. `kodas` int(11) NOT NULL,
  1068. `pora` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1069. `pora_pasiulymas` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1070. `tag` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1071. `tag_pasiulymas` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1072. `online` int(11) NOT NULL,
  1073. `daiktas_1` int(11) NOT NULL,
  1074. `ringo_leidimas` int(11) NOT NULL,
  1075. `miega` int(11) NOT NULL,
  1076. `komanda` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1077. `komanda_kvietimas` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1078. `pasiekimas_1` int(11) NOT NULL DEFAULT '1',
  1079. `pasiekimas_2` int(11) NOT NULL DEFAULT '1',
  1080. `pasiekimas_3` int(11) NOT NULL DEFAULT '1',
  1081. `pasiekimas_4` int(11) NOT NULL DEFAULT '1',
  1082. `misija` int(11) NOT NULL DEFAULT '1',
  1083. `vince_mcmahon` int(11) NOT NULL,
  1084. `zack_ryder` int(11) NOT NULL,
  1085. `drake_maverick` int(11) NOT NULL,
  1086. `auto` int(11) NOT NULL,
  1087. `refresh_en` int(11) NOT NULL,
  1088. `komandos_veiksmai` int(11) NOT NULL,
  1089. `algos_veiksmai` int(11) NOT NULL
  1090. ) ENGINE=InnoDB AUTO_INCREMENT=213 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  1091.  
  1092. --
  1093. -- Dumping data for table `zaidejai`
  1094. --
  1095.  
  1096. INSERT INTO `zaidejai` (`ID`, `nick`, `pass`, `lytis`, `kovotojas`, `statusas`, `lygis`, `jega`, `vikrumas`, `gyvybe`, `energija`, `max_energija`, `kreditai`, `pinigai`, `uzdirbti_eurai`, `registracija`, `aktyvumas`, `ip`, `narsykle`, `nuotrauka`, `apranga`, `nuotaika`, `topic`, `pokalbiai`, `veiksmai`, `visi_veiksmai`, `siandien_veiksmai`, `dienos_veiksmai`, `padusimai`, `puolimai`, `lygio_pasiekimas`, `nepatvirtinta_nuotrauka`, `lyga`, `lygos_kvietimas`, `points`, `laimetu_kovu_ringe`, `pralaimetu_kovu_ringe`, `kodas`, `pora`, `pora_pasiulymas`, `tag`, `tag_pasiulymas`, `online`, `daiktas_1`, `ringo_leidimas`, `miega`, `komanda`, `komanda_kvietimas`, `pasiekimas_1`, `pasiekimas_2`, `pasiekimas_3`, `pasiekimas_4`, `misija`, `vince_mcmahon`, `zack_ryder`, `drake_maverick`, `auto`, `refresh_en`, `komandos_veiksmai`, `algos_veiksmai`) VALUES
  1097. (212, 'Admin', 'lopas123321', 'Vyras', 'Roman Reigns', 2, '10000', '10000', '10000', 1000, '1000', 100, '10000', 10000, 10000, '2019-08-22 / 19:40', '2019-10-22 19:41', '92.220.1.47', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWeb', 'img/nera_nuotraukos.png', 3, 'Neutrali', '@Admin', 0, 10000, 10000, 500, 500, 1, 200, 1, '', 2, 0, '', 0, 0, 0, '', '', '', '', 37, 0, 0, 0, '', '', 1, 1, 1, 1, 1, 0, 0, 0, 1, 0, 0, 1000);
  1098.  
  1099. -- --------------------------------------------------------
  1100.  
  1101. --
  1102. -- Table structure for table `zaidejai_daiktai`
  1103. --
  1104.  
  1105. CREATE TABLE IF NOT EXISTS `zaidejai_daiktai` (
  1106. `ID` int(11) NOT NULL,
  1107. `nick` varchar(50) NOT NULL,
  1108. `pavadinimas` varchar(50) NOT NULL,
  1109. `kiekis` int(11) NOT NULL,
  1110. `lygis` int(11) NOT NULL DEFAULT '1'
  1111. ) ENGINE=InnoDB AUTO_INCREMENT=327 DEFAULT CHARSET=utf8;
  1112.  
  1113. --
  1114. -- Table structure for table `zaidejai_drabuziai`
  1115. --
  1116.  
  1117. CREATE TABLE IF NOT EXISTS `zaidejai_drabuziai` (
  1118. `ID` int(11) NOT NULL,
  1119. `nick` varchar(50) NOT NULL,
  1120. `nr` int(11) NOT NULL
  1121. ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8;
  1122.  
  1123. --
  1124. -- Table structure for table `zinutes`
  1125. --
  1126.  
  1127. CREATE TABLE IF NOT EXISTS `zinutes` (
  1128. `ID` int(11) NOT NULL,
  1129. `nick` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1130. `kam` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1131. `zinute` text COLLATE utf8_lithuanian_ci NOT NULL,
  1132. `data` varchar(50) COLLATE utf8_lithuanian_ci NOT NULL,
  1133. `busena` int(11) NOT NULL,
  1134. `laikas` int(11) NOT NULL
  1135. ) ENGINE=InnoDB AUTO_INCREMENT=4546 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  1136.  
  1137. --
  1138. -- Indexes for dumped tables
  1139. --
  1140.  
  1141. --
  1142. -- Indexes for table `apsaugos_kodas`
  1143. --
  1144. ALTER TABLE `apsaugos_kodas`
  1145. ADD PRIMARY KEY (`ID`);
  1146.  
  1147. --
  1148. -- Indexes for table `balsavimas`
  1149. --
  1150. ALTER TABLE `balsavimas`
  1151. ADD PRIMARY KEY (`ID`);
  1152.  
  1153. --
  1154. -- Indexes for table `balsavimo_rezultatai`
  1155. --
  1156. ALTER TABLE `balsavimo_rezultatai`
  1157. ADD PRIMARY KEY (`laikas`);
  1158.  
  1159. --
  1160. -- Indexes for table `drabuzine`
  1161. --
  1162. ALTER TABLE `drabuzine`
  1163. ADD PRIMARY KEY (`ID`);
  1164.  
  1165. --
  1166. -- Indexes for table `duk`
  1167. --
  1168. ALTER TABLE `duk`
  1169. ADD PRIMARY KEY (`ID`);
  1170.  
  1171. --
  1172. -- Indexes for table `komandos`
  1173. --
  1174. ALTER TABLE `komandos`
  1175. ADD PRIMARY KEY (`ID`);
  1176.  
  1177. --
  1178. -- Indexes for table `komentarai`
  1179. --
  1180. ALTER TABLE `komentarai`
  1181. ADD PRIMARY KEY (`ID`);
  1182.  
  1183. --
  1184. -- Indexes for table `kovos`
  1185. --
  1186. ALTER TABLE `kovos`
  1187. ADD PRIMARY KEY (`ID`);
  1188.  
  1189. --
  1190. -- Indexes for table `kovotojai`
  1191. --
  1192. ALTER TABLE `kovotojai`
  1193. ADD PRIMARY KEY (`ID`);
  1194.  
  1195. --
  1196. -- Indexes for table `lygos`
  1197. --
  1198. ALTER TABLE `lygos`
  1199. ADD PRIMARY KEY (`ID`);
  1200.  
  1201. --
  1202. -- Indexes for table `naujienos`
  1203. --
  1204. ALTER TABLE `naujienos`
  1205. ADD PRIMARY KEY (`ID`);
  1206.  
  1207. --
  1208. -- Indexes for table `naujienu_reputacija`
  1209. --
  1210. ALTER TABLE `naujienu_reputacija`
  1211. ADD PRIMARY KEY (`ID`);
  1212.  
  1213. --
  1214. -- Indexes for table `online`
  1215. --
  1216. ALTER TABLE `online`
  1217. ADD PRIMARY KEY (`ID`);
  1218.  
  1219. --
  1220. -- Indexes for table `online_list`
  1221. --
  1222. ALTER TABLE `online_list`
  1223. ADD PRIMARY KEY (`ID`);
  1224.  
  1225. --
  1226. -- Indexes for table `parduotuve`
  1227. --
  1228. ALTER TABLE `parduotuve`
  1229. ADD PRIMARY KEY (`ID`);
  1230.  
  1231. --
  1232. -- Indexes for table `pasiekimai`
  1233. --
  1234. ALTER TABLE `pasiekimai`
  1235. ADD PRIMARY KEY (`ID`);
  1236.  
  1237. --
  1238. -- Indexes for table `pasiulymai`
  1239. --
  1240. ALTER TABLE `pasiulymai`
  1241. ADD PRIMARY KEY (`ID`);
  1242.  
  1243. --
  1244. -- Indexes for table `pasiulymu_vertinimas`
  1245. --
  1246. ALTER TABLE `pasiulymu_vertinimas`
  1247. ADD PRIMARY KEY (`ID`);
  1248.  
  1249. --
  1250. -- Indexes for table `pokalbiai`
  1251. --
  1252. ALTER TABLE `pokalbiai`
  1253. ADD PRIMARY KEY (`ID`);
  1254.  
  1255. --
  1256. -- Indexes for table `reputacija`
  1257. --
  1258. ALTER TABLE `reputacija`
  1259. ADD PRIMARY KEY (`ID`);
  1260.  
  1261. --
  1262. -- Indexes for table `ringas`
  1263. --
  1264. ALTER TABLE `ringas`
  1265. ADD PRIMARY KEY (`ID`);
  1266.  
  1267. --
  1268. -- Indexes for table `ringo_israsas`
  1269. --
  1270. ALTER TABLE `ringo_israsas`
  1271. ADD PRIMARY KEY (`ID`);
  1272.  
  1273. --
  1274. -- Indexes for table `titulai`
  1275. --
  1276. ALTER TABLE `titulai`
  1277. ADD PRIMARY KEY (`ID`);
  1278.  
  1279. --
  1280. -- Indexes for table `titulo_cempionai`
  1281. --
  1282. ALTER TABLE `titulo_cempionai`
  1283. ADD PRIMARY KEY (`ID`);
  1284.  
  1285. --
  1286. -- Indexes for table `titulo_cempionai_istorija`
  1287. --
  1288. ALTER TABLE `titulo_cempionai_istorija`
  1289. ADD PRIMARY KEY (`ID`);
  1290.  
  1291. --
  1292. -- Indexes for table `titulo_laimetojai`
  1293. --
  1294. ALTER TABLE `titulo_laimetojai`
  1295. ADD PRIMARY KEY (`ID`);
  1296.  
  1297. --
  1298. -- Indexes for table `topic`
  1299. --
  1300. ALTER TABLE `topic`
  1301. ADD PRIMARY KEY (`ID`);
  1302.  
  1303. --
  1304. -- Indexes for table `uzbaninti`
  1305. --
  1306. ALTER TABLE `uzbaninti`
  1307. ADD PRIMARY KEY (`ID`);
  1308.  
  1309. --
  1310. -- Indexes for table `uzkulsiai`
  1311. --
  1312. ALTER TABLE `uzkulsiai`
  1313. ADD PRIMARY KEY (`ID`);
  1314.  
  1315. --
  1316. -- Indexes for table `uzkulsiai_isgavimai`
  1317. --
  1318. ALTER TABLE `uzkulsiai_isgavimai`
  1319. ADD PRIMARY KEY (`ID`);
  1320.  
  1321. --
  1322. -- Indexes for table `veidukai`
  1323. --
  1324. ALTER TABLE `veidukai`
  1325. ADD PRIMARY KEY (`ID`);
  1326.  
  1327. --
  1328. -- Indexes for table `viesbuciai`
  1329. --
  1330. ALTER TABLE `viesbuciai`
  1331. ADD PRIMARY KEY (`ID`);
  1332.  
  1333. --
  1334. -- Indexes for table `zaidejai`
  1335. --
  1336. ALTER TABLE `zaidejai`
  1337. ADD PRIMARY KEY (`ID`);
  1338.  
  1339. --
  1340. -- Indexes for table `zaidejai_daiktai`
  1341. --
  1342. ALTER TABLE `zaidejai_daiktai`
  1343. ADD PRIMARY KEY (`ID`);
  1344.  
  1345. --
  1346. -- Indexes for table `zaidejai_drabuziai`
  1347. --
  1348. ALTER TABLE `zaidejai_drabuziai`
  1349. ADD PRIMARY KEY (`ID`);
  1350.  
  1351. --
  1352. -- Indexes for table `zinutes`
  1353. --
  1354. ALTER TABLE `zinutes`
  1355. ADD PRIMARY KEY (`ID`);
  1356.  
  1357. --
  1358. -- AUTO_INCREMENT for dumped tables
  1359. --
  1360.  
  1361. --
  1362. -- AUTO_INCREMENT for table `apsaugos_kodas`
  1363. --
  1364. ALTER TABLE `apsaugos_kodas`
  1365. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  1366. --
  1367. -- AUTO_INCREMENT for table `balsavimas`
  1368. --
  1369. ALTER TABLE `balsavimas`
  1370. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
  1371. --
  1372. -- AUTO_INCREMENT for table `balsavimo_rezultatai`
  1373. --
  1374. ALTER TABLE `balsavimo_rezultatai`
  1375. MODIFY `laikas` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=81;
  1376. --
  1377. -- AUTO_INCREMENT for table `drabuzine`
  1378. --
  1379. ALTER TABLE `drabuzine`
  1380. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=93;
  1381. --
  1382. -- AUTO_INCREMENT for table `duk`
  1383. --
  1384. ALTER TABLE `duk`
  1385. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
  1386. --
  1387. -- AUTO_INCREMENT for table `komandos`
  1388. --
  1389. ALTER TABLE `komandos`
  1390. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
  1391. --
  1392. -- AUTO_INCREMENT for table `komentarai`
  1393. --
  1394. ALTER TABLE `komentarai`
  1395. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33;
  1396. --
  1397. -- AUTO_INCREMENT for table `kovos`
  1398. --
  1399. ALTER TABLE `kovos`
  1400. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
  1401. --
  1402. -- AUTO_INCREMENT for table `kovotojai`
  1403. --
  1404. ALTER TABLE `kovotojai`
  1405. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=30;
  1406. --
  1407. -- AUTO_INCREMENT for table `lygos`
  1408. --
  1409. ALTER TABLE `lygos`
  1410. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
  1411. --
  1412. -- AUTO_INCREMENT for table `naujienos`
  1413. --
  1414. ALTER TABLE `naujienos`
  1415. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=33;
  1416. --
  1417. -- AUTO_INCREMENT for table `naujienu_reputacija`
  1418. --
  1419. ALTER TABLE `naujienu_reputacija`
  1420. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
  1421. --
  1422. -- AUTO_INCREMENT for table `online`
  1423. --
  1424. ALTER TABLE `online`
  1425. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5168;
  1426. --
  1427. -- AUTO_INCREMENT for table `online_list`
  1428. --
  1429. ALTER TABLE `online_list`
  1430. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=63;
  1431. --
  1432. -- AUTO_INCREMENT for table `parduotuve`
  1433. --
  1434. ALTER TABLE `parduotuve`
  1435. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
  1436. --
  1437. -- AUTO_INCREMENT for table `pasiekimai`
  1438. --
  1439. ALTER TABLE `pasiekimai`
  1440. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=56;
  1441. --
  1442. -- AUTO_INCREMENT for table `pasiulymai`
  1443. --
  1444. ALTER TABLE `pasiulymai`
  1445. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=51;
  1446. --
  1447. -- AUTO_INCREMENT for table `pasiulymu_vertinimas`
  1448. --
  1449. ALTER TABLE `pasiulymu_vertinimas`
  1450. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=150;
  1451. --
  1452. -- AUTO_INCREMENT for table `pokalbiai`
  1453. --
  1454. ALTER TABLE `pokalbiai`
  1455. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=450;
  1456. --
  1457. -- AUTO_INCREMENT for table `reputacija`
  1458. --
  1459. ALTER TABLE `reputacija`
  1460. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=138;
  1461. --
  1462. -- AUTO_INCREMENT for table `ringas`
  1463. --
  1464. ALTER TABLE `ringas`
  1465. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  1466. --
  1467. -- AUTO_INCREMENT for table `ringo_israsas`
  1468. --
  1469. ALTER TABLE `ringo_israsas`
  1470. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=676;
  1471. --
  1472. -- AUTO_INCREMENT for table `titulai`
  1473. --
  1474. ALTER TABLE `titulai`
  1475. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=67;
  1476. --
  1477. -- AUTO_INCREMENT for table `titulo_cempionai`
  1478. --
  1479. ALTER TABLE `titulo_cempionai`
  1480. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
  1481. --
  1482. -- AUTO_INCREMENT for table `titulo_cempionai_istorija`
  1483. --
  1484. ALTER TABLE `titulo_cempionai_istorija`
  1485. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=28;
  1486. --
  1487. -- AUTO_INCREMENT for table `titulo_laimetojai`
  1488. --
  1489. ALTER TABLE `titulo_laimetojai`
  1490. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=43;
  1491. --
  1492. -- AUTO_INCREMENT for table `topic`
  1493. --
  1494. ALTER TABLE `topic`
  1495. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=82;
  1496. --
  1497. -- AUTO_INCREMENT for table `uzbaninti`
  1498. --
  1499. ALTER TABLE `uzbaninti`
  1500. MODIFY `ID` int(50) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
  1501. --
  1502. -- AUTO_INCREMENT for table `uzkulsiai`
  1503. --
  1504. ALTER TABLE `uzkulsiai`
  1505. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
  1506. --
  1507. -- AUTO_INCREMENT for table `uzkulsiai_isgavimai`
  1508. --
  1509. ALTER TABLE `uzkulsiai_isgavimai`
  1510. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  1511. --
  1512. -- AUTO_INCREMENT for table `veidukai`
  1513. --
  1514. ALTER TABLE `veidukai`
  1515. MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=337;
  1516. --
  1517. -- AUTO_INCREMENT for table `viesbuciai`
  1518. --
  1519. ALTER TABLE `viesbuciai`
  1520. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
  1521. --
  1522. -- AUTO_INCREMENT for table `zaidejai`
  1523. --
  1524. ALTER TABLE `zaidejai`
  1525. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=213;
  1526. --
  1527. -- AUTO_INCREMENT for table `zaidejai_daiktai`
  1528. --
  1529. ALTER TABLE `zaidejai_daiktai`
  1530. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=327;
  1531. --
  1532. -- AUTO_INCREMENT for table `zaidejai_drabuziai`
  1533. --
  1534. ALTER TABLE `zaidejai_drabuziai`
  1535. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=127;
  1536. --
  1537. -- AUTO_INCREMENT for table `zinutes`
  1538. --
  1539. ALTER TABLE `zinutes`
  1540. MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4546;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement