Файл: ewar/ewar.sql
Строк: 647
-- phpMyAdmin SQL Dump
-- version 4.0.10.6
--
http://www.phpmyadmin.net
--
-- Host: 127.0.0.1:3306
-- Generation Time:
Mar 15, 2016 at 06:41 PM
-- Server version: 5.6.22-log
-- PHP Version:
5.6.3
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone =
"+00:00";
/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8 */;
--
-- Database: `ewar`
--
--
--------------------------------------------------------
--
-- Table
structure for table `2pay_data`
--
CREATE TABLE IF NOT EXISTS `2pay_data`
(
`id_shop` int(11) NOT NULL AUTO_INCREMENT,
`id` bigint(20) DEFAULT
NULL,
`v1` int(11) DEFAULT NULL,
`sum` float DEFAULT NULL,
`dat`
varchar(20) DEFAULT NULL,
PRIMARY KEY (`id_shop`)
) ENGINE=InnoDB DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `arena`
--
CREATE TABLE IF NOT EXISTS `arena` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`opponent` int(11) NOT NULL DEFAULT '0',
`opponent2` int(11) NOT NULL,
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `atsiliepimai`
--
CREATE TABLE IF NOT EXISTS
`atsiliepimai` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kieno` int(11)
NOT NULL,
`kas` int(11) NOT NULL,
`atsiliepimas` varchar(10000)
CHARACTER SET utf8 NOT NULL,
`kada` varchar(20) CHARACTER SET utf8 NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `auksiniu_log`
--
CREATE TABLE IF NOT EXISTS
`auksiniu_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nick_id`
int(11) NOT NULL,
`txt` varchar(1000) CHARACTER SET utf8 NOT NULL,
`data` varchar(20) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `blacklist`
--
CREATE TABLE IF NOT EXISTS `blacklist`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`blacklist_user_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `block`
--
CREATE TABLE IF NOT EXISTS `block` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`nick_id` int(11) NOT NULL,
`kas`
int(11) NOT NULL,
`priezastis` varchar(1500) CHARACTER SET utf8 NOT
NULL,
`laikas` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `cave`
--
CREATE TABLE IF NOT EXISTS `cave` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`dawn` enum('0','1') NOT NULL DEFAULT '0',
`res_1` int(11) NOT NULL
DEFAULT '0',
`res_1_chanse` int(11) NOT NULL DEFAULT '0',
`res_2`
int(11) NOT NULL DEFAULT '0',
`res_2_chanse` int(11) NOT NULL DEFAULT
'0',
`res_3` int(11) NOT NULL DEFAULT '0',
`res_3_chanse` int(11) NOT
NULL DEFAULT '0',
`gather` int(11) NOT NULL DEFAULT '0',
`time` int(11)
NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `chat`
--
CREATE TABLE IF NOT EXISTS `chat` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`nick_id` int(11) NOT NULL,
`zinute`
varchar(300) CHARACTER SET utf8 NOT NULL,
`kada` varchar(20) CHARACTER
SET utf8 NOT NULL,
`kalba` varchar(2) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `chat_online`
--
CREATE TABLE IF NOT EXISTS
`chat_online` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nick_id` int(11)
NOT NULL,
`laikas` int(11) NOT NULL,
`kalba` varchar(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
-- Table
structure for table `clans`
--
CREATE TABLE IF NOT EXISTS `clans` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`gerb` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT
'1',
`exp` int(11) NOT NULL DEFAULT '0',
`g` bigint(20) NOT NULL
DEFAULT '0',
`s` bigint(20) NOT NULL DEFAULT '0',
`rank_for_invite`
enum('0','1','2','3','4') NOT NULL DEFAULT '0',
`rank_for_delete`
enum('0','1','2','3','4') NOT NULL DEFAULT '0',
`built_1` int(11) NOT
NULL DEFAULT '0',
`built_2` int(11) NOT NULL DEFAULT '0',
`built_2_time` int(11) NOT NULL DEFAULT '0',
`built_3` int(11) NOT NULL
DEFAULT '0',
`built_3_time` int(11) NOT NULL DEFAULT '0',
`date`
varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `clan_chat`
--
CREATE TABLE IF NOT EXISTS `clan_chat`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`clan` int(11) NOT NULL,
`nick_id` int(11) NOT NULL,
`zinute` varchar(300) CHARACTER SET utf8 NOT
NULL,
`kada` varchar(20) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `clan_chat_online`
--
CREATE TABLE IF NOT EXISTS
`clan_chat_online` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`clan`
int(11) NOT NULL,
`nick_id` int(11) NOT NULL,
`laikas` int(11) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `clan_invite`
--
CREATE TABLE IF NOT EXISTS
`clan_invite` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`clan` int(11)
NOT NULL DEFAULT '0',
`user` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `clan_journal`
--
CREATE TABLE IF NOT EXISTS
`clan_journal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`clan` int(11)
NOT NULL,
`text` varchar(200) CHARACTER SET utf8 NOT NULL,
`kada`
varchar(20) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `clan_memb`
--
CREATE TABLE IF NOT EXISTS `clan_memb`
(
`id` int(11) NOT NULL AUTO_INCREMENT,
`clan` int(11) NOT NULL DEFAULT
'0',
`user` int(11) NOT NULL DEFAULT '0',
`rank`
enum('0','1','2','3','4') NOT NULL DEFAULT '0',
`g` bigint(20) NOT NULL
DEFAULT '0',
`s` bigint(20) NOT NULL DEFAULT '0',
`exp` int(11) NOT
NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
`last_update`
int(11) NOT NULL,
`v` int(3) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `clan_msg`
--
CREATE TABLE IF NOT EXISTS `clan_msg` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`clan` int(11) NOT NULL DEFAULT
'0',
`user` int(11) NOT NULL DEFAULT '0',
`text` text CHARACTER SET
utf8,
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `clan_msg_read`
--
CREATE TABLE IF NOT EXISTS
`clan_msg_read` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`msg` int(11)
NOT NULL DEFAULT '0',
`user` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `clan_search`
--
CREATE TABLE IF NOT EXISTS
`clan_search` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11)
NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `coliseum`
--
CREATE TABLE IF NOT EXISTS `coliseum` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`uid` int(10) NOT NULL,
`star`
float NOT NULL DEFAULT '1.5',
`rang` int(3) NOT NULL DEFAULT '20',
`playGame` int(5) NOT NULL,
`minRang` int(5) NOT NULL DEFAULT '20',
PRIMARY KEY (`id`),
UNIQUE KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `duel`
--
CREATE TABLE IF NOT EXISTS `duel` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`opponent` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `exchange`
--
CREATE TABLE IF NOT EXISTS `exchange` (
`user_id` int(11) NOT NULL,
`time` int(11) DEFAULT NULL,
`count`
int(11) DEFAULT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `nick`
(`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
--
--------------------------------------------------------
--
-- Table
structure for table `farm`
--
CREATE TABLE IF NOT EXISTS `farm` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`h` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
-- Table
structure for table `forumas`
--
CREATE TABLE IF NOT EXISTS `forumas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sub` int(2) NOT NULL,
`kas`
int(11) NOT NULL,
`tema` varchar(200) CHARACTER SET utf8 NOT NULL,
`time` int(20) NOT NULL,
`kada` varchar(20) CHARACTER SET utf8 NOT NULL,
`kalba` varchar(2) COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `forumo_online`
--
CREATE TABLE IF NOT EXISTS
`forumo_online` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nick_id`
int(11) NOT NULL,
`laikas` int(20) NOT NULL,
`kalba` varchar(2) COLLATE
latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `forumo_zinutes`
--
CREATE TABLE IF NOT EXISTS
`forumo_zinutes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sub` int(2)
NOT NULL,
`kas` int(11) NOT NULL,
`temos_id` int(10) NOT NULL,
`zinute` longtext CHARACTER SET utf8 NOT NULL,
`time` int(20) NOT NULL,
`kada` varchar(20) CHARACTER SET utf8 NOT NULL,
`kalba` varchar(2)
COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `inbox`
--
CREATE TABLE IF NOT EXISTS `inbox` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`kieno` int(11) NOT NULL,
`busena`
varchar(1) CHARACTER SET utf8 NOT NULL,
`nuo_ko_ar_kam` int(11) NOT
NULL,
`zinute` varchar(10000) CHARACTER SET utf8 NOT NULL,
`kada`
varchar(20) CHARACTER SET utf8 NOT NULL,
`type` int(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `kieno` (`kieno`,`nuo_ko_ar_kam`)
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `inv`
--
CREATE TABLE IF NOT EXISTS `inv` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`item` int(11) NOT NULL DEFAULT '0',
`quality`
enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
`bonus` int(11)
NOT NULL DEFAULT '0',
`smith` int(11) NOT NULL DEFAULT '0',
`equip`
enum('0','1') NOT NULL DEFAULT '0',
`new` enum('0','1') NOT NULL DEFAULT
'0',
`rune` enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
`_str` int(11) NOT NULL DEFAULT '0',
`_vit` int(11) NOT NULL DEFAULT
'0',
`_agi` int(11) NOT NULL DEFAULT '0',
`_def` int(11) NOT NULL
DEFAULT '0',
`place` enum('0','1') NOT NULL DEFAULT '0',
`e` int(11)
NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `items`
--
CREATE TABLE IF NOT EXISTS `items` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`w`
enum('1','2','3','4','5','6','7','8') NOT NULL DEFAULT '1',
`quality`
enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
`skill` int(11)
NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=314 ;
--
-- Dumping data for table
`items`
--
INSERT INTO `items` (`id`, `w`, `quality`, `skill`) VALUES
(9,
'1', '1', 1),
(10, '2', '1', 1),
(11, '3', '1', 1),
(12, '4', '1', 1),
(13,
'5', '1', 1),
(14, '6', '1', 1),
(15, '7', '1', 1),
(16, '8', '1', 1),
(17,
'1', '1', 1),
(18, '2', '1', 1),
(19, '3', '1', 1),
(20, '4', '1', 1),
(21,
'5', '1', 1),
(22, '6', '1', 1),
(23, '7', '1', 1),
(24, '8', '1', 1),
(25,
'1', '1', 1),
(26, '2', '1', 1),
(27, '3', '1', 1),
(28, '4', '1', 1),
(29,
'5', '1', 1),
(30, '6', '1', 1),
(31, '7', '1', 1),
(32, '8', '1', 1),
(33,
'1', '2', 10),
(34, '2', '2', 10),
(35, '3', '2', 10),
(36, '4', '2',
10),
(37, '5', '2', 10),
(38, '6', '2', 10),
(39, '7', '2', 10),
(40, '8',
'2', 10),
(41, '1', '3', 24),
(42, '2', '3', 24),
(43, '3', '3', 24),
(44,
'4', '3', 24),
(45, '5', '3', 24),
(46, '6', '3', 24),
(47, '7', '3',
24),
(48, '8', '3', 24),
(49, '1', '3', 24),
(50, '2', '3', 24),
(51, '3',
'3', 24),
(52, '4', '3', 24),
(53, '5', '3', 24),
(54, '6', '3', 24),
(55,
'7', '3', 24),
(56, '8', '3', 24),
(57, '1', '3', 24),
(58, '2', '3',
24),
(59, '3', '3', 24),
(60, '4', '3', 24),
(61, '5', '3', 24),
(62, '6',
'3', 24),
(63, '7', '3', 24),
(64, '8', '3', 24),
(65, '1', '2', 10),
(66,
'2', '2', 10),
(67, '3', '2', 10),
(68, '4', '2', 10),
(69, '5', '2',
10),
(70, '6', '2', 10),
(71, '7', '2', 10),
(72, '8', '2', 10),
(73, '1',
'2', 10),
(74, '2', '2', 10),
(75, '3', '2', 10),
(76, '4', '2', 10),
(77,
'5', '2', 10),
(78, '6', '2', 10),
(79, '7', '2', 10),
(80, '8', '2',
10),
(81, '1', '3', 24),
(82, '2', '3', 24),
(83, '3', '3', 24),
(84, '4',
'3', 24),
(85, '5', '3', 24),
(86, '6', '3', 24),
(87, '7', '3', 24),
(88,
'8', '3', 24),
(89, '1', '4', 48),
(90, '2', '4', 48),
(91, '3', '4',
48),
(92, '4', '4', 48),
(93, '5', '4', 48),
(94, '6', '4', 48),
(95, '7',
'4', 48),
(96, '8', '4', 48),
(97, '1', '4', 48),
(98, '2', '4', 48),
(99,
'3', '4', 48),
(100, '4', '4', 48),
(101, '5', '4', 48),
(102, '6', '4',
48),
(103, '7', '4', 48),
(104, '8', '4', 48),
(105, '1', '3', 24),
(106,
'2', '3', 24),
(107, '3', '3', 24),
(108, '4', '3', 24),
(109, '5', '3',
24),
(110, '6', '3', 24),
(111, '7', '3', 24),
(112, '8', '3', 24),
(113,
'1', '3', 24),
(114, '2', '3', 24),
(115, '3', '3', 24),
(116, '4', '3',
24),
(117, '5', '3', 24),
(118, '6', '3', 24),
(119, '7', '3', 24),
(120,
'8', '3', 24),
(121, '1', '4', 48),
(122, '2', '4', 48),
(123, '3', '4',
48),
(124, '4', '4', 48),
(125, '5', '4', 48),
(126, '6', '4', 48),
(127,
'7', '4', 48),
(128, '8', '4', 48),
(129, '1', '4', 48),
(130, '2', '4',
48),
(131, '3', '4', 48),
(132, '4', '4', 48),
(133, '5', '4', 48),
(134,
'6', '4', 48),
(135, '7', '4', 48),
(136, '8', '4', 48),
(137, '1', '4',
48),
(138, '2', '4', 48),
(139, '3', '4', 48),
(140, '4', '4', 48),
(141,
'5', '4', 48),
(142, '6', '4', 48),
(143, '7', '4', 48),
(144, '8', '4',
48),
(145, '1', '4', 48),
(146, '2', '4', 48),
(147, '3', '4', 48),
(148,
'4', '4', 48),
(149, '5', '4', 48),
(150, '6', '4', 48),
(151, '7', '4',
48),
(152, '8', '4', 48),
(161, '1', '4', 48),
(162, '2', '4', 48),
(163,
'3', '4', 48),
(164, '4', '4', 48),
(165, '5', '4', 48),
(166, '6', '4',
48),
(167, '7', '4', 48),
(168, '8', '4', 48),
(169, '1', '4', 48),
(170,
'2', '4', 48),
(171, '3', '4', 48),
(172, '4', '4', 48),
(173, '5', '4',
48),
(174, '6', '4', 48),
(175, '7', '4', 48),
(176, '8', '4', 48),
(178,
'1', '5', 200),
(179, '2', '5', 200),
(180, '3', '5', 200),
(181, '4', '5',
200),
(182, '5', '5', 200),
(183, '6', '5', 200),
(184, '7', '5',
200),
(185, '8', '5', 200),
(186, '1', '5', 200),
(187, '2', '5',
200),
(188, '3', '5', 200),
(189, '4', '5', 200),
(190, '5', '5',
200),
(191, '6', '5', 200),
(192, '7', '5', 200),
(193, '8', '5',
200),
(194, '1', '5', 200),
(195, '2', '5', 200),
(196, '3', '5',
200),
(197, '4', '5', 200),
(198, '5', '5', 200),
(199, '6', '5',
200),
(200, '7', '5', 200),
(201, '8', '5', 200),
(202, '1', '5',
200),
(203, '2', '5', 200),
(204, '3', '5', 200),
(205, '4', '5',
200),
(206, '5', '5', 200),
(207, '6', '5', 200),
(208, '7', '5',
200),
(209, '8', '5', 200),
(210, '1', '5', 200),
(211, '2', '5',
200),
(212, '3', '5', 200),
(213, '4', '5', 200),
(214, '5', '5',
200),
(215, '6', '5', 200),
(216, '7', '5', 200),
(217, '8', '5',
200),
(218, '1', '6', 200),
(219, '2', '6', 200),
(220, '3', '6',
200),
(221, '4', '6', 200),
(222, '5', '6', 200),
(223, '6', '6',
200),
(224, '7', '6', 200),
(225, '8', '6', 200),
(226, '1', '6',
200),
(227, '2', '6', 200),
(228, '3', '6', 200),
(229, '4', '6',
200),
(230, '5', '6', 200),
(231, '6', '6', 200),
(232, '7', '6',
200),
(233, '8', '6', 200),
(234, '1', '6', 200),
(235, '2', '6',
200),
(236, '3', '6', 200),
(237, '4', '6', 200),
(238, '5', '6',
200),
(239, '6', '6', 200),
(240, '7', '6', 200),
(241, '8', '6',
200),
(242, '1', '6', 200),
(243, '2', '6', 200),
(244, '3', '6',
200),
(245, '4', '6', 200),
(246, '5', '6', 200),
(247, '6', '6',
200),
(248, '7', '6', 200),
(249, '8', '6', 200),
(250, '1', '6',
200),
(251, '2', '6', 200),
(252, '3', '6', 200),
(253, '4', '6',
200),
(254, '5', '6', 200),
(255, '6', '6', 200),
(256, '7', '6',
200),
(257, '8', '6', 200),
(258, '1', '6', 200),
(259, '2', '6',
200),
(260, '3', '6', 200),
(261, '4', '6', 200),
(262, '5', '6',
200),
(263, '6', '6', 200),
(264, '7', '6', 200),
(265, '8', '6',
200),
(266, '1', '6', 200),
(267, '2', '6', 200),
(268, '3', '6',
200),
(269, '4', '6', 200),
(270, '5', '6', 200),
(271, '6', '6',
200),
(272, '7', '6', 200),
(273, '8', '6', 200),
(274, '1', '6',
200),
(275, '2', '6', 200),
(276, '3', '6', 200),
(277, '4', '6',
200),
(278, '5', '6', 200),
(279, '6', '6', 200),
(280, '7', '6',
200),
(281, '8', '6', 200),
(282, '1', '6', 200),
(283, '2', '6',
200),
(284, '3', '6', 200),
(285, '4', '6', 200),
(286, '5', '6',
200),
(287, '6', '6', 200),
(288, '7', '6', 200),
(289, '8', '6',
200),
(290, '1', '6', 200),
(291, '2', '6', 200),
(292, '3', '6',
200),
(293, '4', '6', 200),
(294, '5', '6', 200),
(295, '6', '6',
200),
(296, '7', '6', 200),
(297, '8', '6', 200),
(298, '1', '5',
200),
(299, '2', '5', 200),
(300, '3', '5', 200),
(301, '4', '5',
200),
(302, '5', '5', 200),
(303, '6', '5', 200),
(304, '7', '5',
200),
(305, '8', '5', 200),
(306, '1', '5', 200),
(307, '2', '5',
200),
(308, '3', '5', 200),
(309, '4', '5', 200),
(310, '5', '5',
200),
(311, '6', '5', 200),
(312, '7', '5', 200),
(313, '8', '5', 200);
--
--------------------------------------------------------
--
-- Table
structure for table `loterija`
--
CREATE TABLE IF NOT EXISTS `loterija` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nick_id` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `loterijos_laimetojas`
--
CREATE TABLE IF NOT EXISTS
`loterijos_laimetojas` (
`nick_id` int(10) NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
--------------------------------------------------------
--
-- Table
structure for table `news`
--
CREATE TABLE IF NOT EXISTS `news` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`naujiena` text CHARACTER SET utf8 NOT
NULL,
`naujiena2` text CHARACTER SET utf8 NOT NULL,
`data` varchar(20)
CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `news_vertinimai`
--
CREATE TABLE IF NOT EXISTS
`news_vertinimai` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`news_id`
int(11) NOT NULL,
`nick_id` int(11) NOT NULL,
`vertinimas` int(1) NOT
NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `online`
--
CREATE TABLE IF NOT EXISTS `online` (
`nick_id` int(11) NOT NULL,
`laikas` int(11) NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
--------------------------------------------------------
--
-- Table
structure for table `pets`
--
CREATE TABLE IF NOT EXISTS `pets` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL,
`use` int(1)
NOT NULL,
`pet_id` int(1) NOT NULL,
`level` int(3) NOT NULL,
`params`
int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=latin1 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `premijos`
--
CREATE TABLE IF NOT EXISTS `premijos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`kieno` int(11) NOT NULL,
`nick_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `priminimai`
--
CREATE TABLE IF NOT EXISTS
`priminimai` (
`nick_id` int(11) NOT NULL,
`id` varchar(15) CHARACTER
SET utf8 NOT NULL,
`pass` varchar(20) CHARACTER SET utf8 NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
--------------------------------------------------------
--
-- Table
structure for table `referers`
--
CREATE TABLE IF NOT EXISTS `referers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`referer` varchar(500) CHARACTER
SET utf8 NOT NULL,
`data` varchar(20) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
;
-- --------------------------------------------------------
--
-- Table
structure for table `sack`
--
CREATE TABLE IF NOT EXISTS `sack` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT '0',
`1` int(11) NOT NULL DEFAULT '0',
`2` int(11) NOT NULL DEFAULT '0',
`3`
int(11) NOT NULL DEFAULT '0',
`4` int(11) NOT NULL DEFAULT '0',
`5`
int(11) NOT NULL DEFAULT '0',
`6` int(11) NOT NULL DEFAULT '0',
`7`
int(11) NOT NULL DEFAULT '0',
`8` int(11) NOT NULL DEFAULT '0',
`9`
int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `settings`
--
CREATE TABLE IF NOT EXISTS `settings` (
`game_on` int(11) NOT NULL,
`reg_antiflood_time` int(11) NOT NULL,
`write_from` int(5) NOT NULL,
`reg_antiflood` int(10) NOT NULL,
`forum_antiflood` int(10) NOT NULL,
`last_reg` int(10) NOT NULL,
`last_reg_sk` int(3) NOT NULL,
`quests` int(2) NOT NULL,
`complects`
int(2) NOT NULL,
`day_from` int(5) NOT NULL,
`day_to` int(5) NOT NULL,
`night_from` int(5) NOT NULL,
`night_to` int(5) NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=latin1;
--
-- Dumping data for table `settings`
--
INSERT
INTO `settings` (`game_on`, `reg_antiflood_time`, `write_from`,
`reg_antiflood`, `forum_antiflood`, `last_reg`, `last_reg_sk`, `quests`,
`complects`, `day_from`, `day_to`, `night_from`, `night_to`) VALUES
(1, 0,
5, 1441620896, 1432057655, 1441620896, 0, 8, 37, 1, 1, 1, 1);
--
--------------------------------------------------------
--
-- Table
structure for table `shop`
--
CREATE TABLE IF NOT EXISTS `shop` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`quality`
enum('0','1','2','3','4','5','6') NOT NULL DEFAULT '0',
`bonus` int(11)
NOT NULL DEFAULT '0',
`cost` int(11) NOT NULL DEFAULT '0',
`_str`
int(11) NOT NULL DEFAULT '0',
`_vit` int(11) NOT NULL DEFAULT '0',
`_agi` int(11) NOT NULL DEFAULT '0',
`_def` int(11) NOT NULL DEFAULT
'0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251
AUTO_INCREMENT=314 ;
--
-- Dumping data for table `shop`
--
INSERT INTO
`shop` (`id`, `quality`, `bonus`, `cost`, `_str`, `_vit`, `_agi`, `_def`)
VALUES
(9, '1', 5, 10, 31, 31, 31, 31),
(10, '1', 5, 10, 31, 31, 31,
31),
(11, '1', 5, 10, 31, 31, 31, 31),
(12, '1', 5, 10, 31, 31, 31,
31),
(13, '1', 5, 10, 31, 31, 31, 31),
(14, '1', 5, 10, 31, 31, 31,
31),
(15, '1', 5, 10, 31, 31, 31, 31),
(16, '1', 5, 10, 31, 31, 31,
31),
(17, '1', 5, 10, 31, 31, 31, 31),
(18, '1', 5, 10, 31, 31, 31,
31),
(19, '1', 5, 10, 31, 31, 31, 31),
(20, '1', 5, 10, 31, 31, 31,
31),
(21, '1', 5, 10, 31, 31, 31, 31),
(22, '1', 5, 10, 31, 31, 31,
31),
(23, '1', 5, 10, 31, 31, 31, 31),
(24, '1', 5, 10, 31, 31, 31,
31),
(25, '1', 5, 10, 31, 31, 31, 31),
(26, '1', 5, 10, 31, 31, 31,
31),
(27, '1', 5, 10, 31, 31, 31, 31),
(28, '1', 5, 10, 31, 31, 31,
31),
(29, '1', 5, 10, 31, 31, 31, 31),
(30, '1', 5, 10, 31, 31, 31,
31),
(31, '1', 5, 10, 31, 31, 31, 31),
(32, '1', 5, 10, 31, 31, 31,
31),
(33, '2', 10, 30, 45, 45, 45, 45),
(34, '2', 10, 30, 45, 45, 45,
45),
(35, '2', 10, 30, 45, 45, 45, 45),
(36, '2', 10, 30, 45, 45, 45,
45),
(37, '2', 10, 30, 45, 45, 45, 45),
(38, '2', 10, 30, 45, 45, 45,
45),
(39, '2', 10, 30, 45, 45, 45, 45),
(40, '2', 10, 30, 45, 45, 45,
45),
(41, '3', 10, 60, 52, 52, 52, 52),
(42, '3', 10, 60, 52, 52, 52,
52),
(43, '3', 10, 60, 52, 52, 52, 52),
(44, '3', 10, 60, 52, 52, 52,
52),
(45, '3', 10, 60, 52, 52, 52, 52),
(46, '3', 10, 60, 52, 52, 52,
52),
(47, '3', 10, 60, 52, 52, 52, 52),
(48, '3', 10, 60, 52, 52, 52,
52),
(49, '3', 10, 60, 52, 52, 52, 52),
(50, '3', 10, 60, 52, 52, 52,
52),
(51, '3', 10, 60, 52, 52, 52, 52),
(52, '3', 10, 60, 52, 52, 52,
52),
(53, '3', 10, 60, 52, 52, 52, 52),
(54, '3', 10, 60, 52, 52, 52,
52),
(55, '3', 10, 60, 52, 52, 52, 52),
(56, '3', 10, 60, 52, 52, 52,
52),
(57, '3', 10, 60, 52, 52, 52, 52),
(58, '3', 10, 60, 52, 52, 52,
52),
(59, '3', 10, 60, 52, 52, 52, 52),
(60, '3', 10, 60, 52, 52, 52,
52),
(61, '3', 10, 60, 52, 52, 52, 52),
(62, '3', 10, 60, 52, 52, 52,
52),
(63, '3', 10, 60, 52, 52, 52, 52),
(64, '3', 10, 60, 52, 52, 52,
52),
(65, '2', 10, 30, 45, 45, 45, 45),
(66, '2', 10, 30, 45, 45, 45,
45),
(67, '2', 10, 30, 45, 45, 45, 45),
(68, '2', 10, 30, 45, 45, 45,
45),
(69, '2', 10, 30, 45, 45, 45, 45),
(70, '2', 10, 30, 45, 45, 45,
45),
(71, '2', 10, 30, 45, 45, 45, 45),
(72, '2', 10, 30, 45, 45, 45,
45),
(73, '2', 10, 30, 45, 45, 45, 45),
(74, '2', 10, 30, 45, 45, 45,
45),
(75, '2', 10, 30, 45, 45, 45, 45),
(76, '2', 10, 30, 45, 45, 45,
45),
(77, '2', 10, 30, 45, 45, 45, 45),
(78, '2', 10, 30, 45, 45, 45,
45),
(79, '2', 10, 30, 45, 45, 45, 45),
(80, '2', 10, 30, 45, 45, 45,
45),
(81, '3', 10, 60, 52, 52, 52, 52),
(82, '3', 10, 60, 52, 52, 52,
52),
(83, '3', 10, 60, 52, 52, 52, 52),
(84, '3', 10, 60, 52, 52, 52,
52),
(85, '3', 10, 60, 52, 52, 52, 52),
(86, '3', 10, 60, 52, 52, 52,
52),
(87, '3', 10, 60, 52, 52, 52, 52),
(88, '3', 10, 60, 52, 52, 52,
52),
(89, '4', 10, 200, 60, 60, 60, 60),
(90, '4', 10, 200, 60, 60, 60,
60),
(91, '4', 10, 200, 60, 60, 60, 60),
(92, '4', 10, 200, 60, 60, 60,
60),
(93, '4', 10, 200, 60, 60, 60, 60),
(94, '4', 10, 200, 60, 60, 60,
60),
(95, '4', 10, 200, 60, 60, 60, 60),
(96, '4', 10, 200, 60, 60, 60,
60),
(97, '4', 10, 200, 60, 60, 60, 60),
(98, '4', 10, 200, 60, 60, 60,
60),
(99, '4', 10, 200, 60, 60, 60, 60),
(100, '4', 10, 200, 60, 60, 60,
60),
(101, '4', 10, 200, 60, 60, 60, 60),
(102, '4', 10, 200, 60, 60, 60,
60),
(103, '4', 10, 200, 60, 60, 60, 60),
(104, '4', 10, 200, 60, 60, 60,
60),
(105, '3', 10, 60, 52, 52, 52, 52),
(106, '3', 10, 60, 52, 52, 52,
52),
(107, '3', 10, 60, 52, 52, 52, 52),
(108, '3', 10, 60, 52, 52, 52,
52),
(109, '3', 10, 60, 52, 52, 52, 52),
(110, '3', 10, 60, 52, 52, 52,
52),
(111, '3', 10, 60, 52, 52, 52, 52),
(112, '3', 10, 60, 52, 52, 52,
52),
(113, '3', 10, 60, 52, 52, 52, 52),
(114, '3', 10, 60, 52, 52, 52,
52),
(115, '3', 10, 60, 52, 52, 52, 52),
(116, '3', 10, 60, 52, 52, 52,
52),
(117, '3', 10, 60, 52, 52, 52, 52),
(118, '3', 10, 60, 52, 52, 52,
52),
(119, '3', 10, 60, 52, 52, 52, 52),
(120, '3', 10, 60, 52, 52, 52,
52),
(121, '4', 10, 200, 60, 60, 60, 60),
(122, '4', 10, 200, 60, 60, 60,
60),
(123, '4', 10, 200, 60, 60, 60, 60),
(124, '4', 10, 200, 60, 60, 60,
60),
(125, '4', 10, 200, 60, 60, 60, 60),
(126, '4', 10, 200, 60, 60, 60,
60),
(127, '4', 10, 200, 60, 60, 60, 60),
(128, '4', 10, 200, 60, 60, 60,
60),
(129, '4', 10, 200, 60, 60, 60, 60),
(130, '4', 10, 200, 60, 60, 60,
60),
(131, '4', 10, 200, 60, 60, 60, 60),
(132, '4', 10, 200, 60, 60, 60,
60),
(133, '4', 10, 200, 60, 60, 60, 60),
(134, '4', 10, 200, 60, 60, 60,
60),
(135, '4', 10, 200, 60, 60, 60, 60),
(136, '4', 10, 200, 60, 60, 60,
60),
(137, '4', 10, 200, 60, 60, 60, 60),
(138, '4', 10, 200, 60, 60, 60,
60),
(139, '4', 10, 200, 60, 60, 60, 60),
(140, '4', 10, 200, 60, 60, 60,
60),
(141, '4', 10, 200, 60, 60, 60, 60),
(142, '4', 10, 200, 60, 60, 60,
60),
(143, '4', 10, 200, 60, 60, 60, 60),
(144, '4', 10, 200, 60, 60, 60,
60),
(145, '4', 10, 200, 60, 60, 60, 60),
(146, '4', 10, 200, 60, 60, 60,
60),
(147, '4', 10, 200, 60, 60, 60, 60),
(148, '4', 10, 200, 60, 60, 60,
60),
(149, '4', 10, 200, 60, 60, 60, 60),
(150, '4', 10, 200, 60, 60, 60,
60),
(151, '4', 10, 200, 60, 60, 60, 60),
(152, '4', 10, 200, 60, 60, 60,
60),
(161, '4', 10, 200, 60, 60, 60, 60),
(162, '4', 10, 200, 60, 60, 60,
60),
(163, '4', 10, 200, 60, 60, 60, 60),
(164, '4', 10, 200, 60, 60, 60,
60),
(165, '4', 10, 200, 60, 60, 60, 60),
(166, '4', 10, 200, 60, 60, 60,
60),
(167, '4', 10, 200, 60, 60, 60, 60),
(168, '4', 10, 200, 60, 60, 60,
60),
(169, '4', 10, 200, 60, 60, 60, 60),
(170, '4', 10, 200, 60, 60, 60,
60),
(171, '4', 10, 200, 60, 60, 60, 60),
(172, '4', 10, 200, 60, 60, 60,
60),
(173, '4', 10, 200, 60, 60, 60, 60),
(174, '4', 10, 200, 60, 60, 60,
60),
(175, '4', 10, 200, 60, 60, 60, 60),
(176, '4', 10, 200, 60, 60, 60,
60),
(178, '5', 10, 2000, 120, 120, 120, 120),
(179, '5', 10, 2000, 120,
120, 120, 120),
(180, '5', 10, 2000, 120, 120, 120, 120),
(181, '5', 10,
2000, 120, 120, 120, 120),
(182, '5', 10, 2000, 120, 120, 120, 120),
(183,
'5', 10, 2000, 120, 120, 120, 120),
(184, '5', 10, 2000, 120, 120, 120,
120),
(185, '5', 10, 2000, 120, 120, 120, 120),
(186, '5', 10, 2000, 120,
120, 120, 120),
(187, '5', 10, 2000, 120, 120, 120, 120),
(188, '5', 10,
2000, 120, 120, 120, 120),
(189, '5', 10, 2000, 120, 120, 120, 120),
(190,
'5', 10, 2000, 120, 120, 120, 120),
(191, '5', 10, 2000, 120, 120, 120,
120),
(192, '5', 10, 2000, 120, 120, 120, 120),
(193, '5', 10, 2000, 120,
120, 120, 120),
(194, '5', 10, 2000, 120, 120, 120, 120),
(195, '5', 10,
2000, 120, 120, 120, 120),
(196, '5', 10, 2000, 120, 120, 120, 120),
(197,
'5', 10, 2000, 120, 120, 120, 120),
(198, '5', 10, 2000, 120, 120, 120,
120),
(199, '5', 10, 2000, 120, 120, 120, 120),
(200, '5', 10, 2000, 120,
120, 120, 120),
(201, '5', 10, 2000, 120, 120, 120, 120),
(202, '5', 10,
2000, 120, 120, 120, 120),
(203, '5', 10, 2000, 120, 120, 120, 120),
(204,
'5', 10, 2000, 120, 120, 120, 120),
(205, '5', 10, 2000, 120, 120, 120,
120),
(206, '5', 10, 2000, 120, 120, 120, 120),
(207, '5', 10, 2000, 120,
120, 120, 120),
(208, '5', 10, 2000, 120, 120, 120, 120),
(209, '5', 10,
2000, 120, 120, 120, 120),
(210, '5', 10, 2000, 120, 120, 120, 120),
(211,
'5', 10, 2000, 120, 120, 120, 120),
(212, '5', 10, 2000, 120, 120, 120,
120),
(213, '5', 10, 2000, 120, 120, 120, 120),
(214, '5', 10, 2000, 120,
120, 120, 120),
(215, '5', 10, 2000, 120, 120, 120, 120),
(216, '5', 10,
2000, 120, 120, 120, 120),
(217, '5', 10, 2000, 120, 120, 120, 120),
(218,
'6', 10, 4000, 170, 170, 170, 170),
(219, '6', 10, 4000, 170, 170, 170,
170),
(220, '6', 10, 4000, 170, 170, 170, 170),
(221, '6', 10, 4000, 170,
170, 170, 170),
(222, '6', 10, 4000, 170, 170, 170, 170),
(223, '6', 10,
4000, 170, 170, 170, 170),
(224, '6', 10, 4000, 170, 170, 170, 170),
(225,
'6', 10, 4000, 170, 170, 170, 170),
(226, '6', 10, 4000, 170, 170, 170,
170),
(227, '6', 10, 4000, 170, 170, 170, 170),
(228, '6', 10, 4000, 170,
170, 170, 170),
(229, '6', 10, 4000, 170, 170, 170, 170),
(230, '6', 10,
4000, 170, 170, 170, 170),
(231, '6', 10, 4000, 170, 170, 170, 170),
(232,
'6', 10, 4000, 170, 170, 170, 170),
(233, '6', 10, 4000, 170, 170, 170,
170),
(234, '6', 10, 4000, 170, 170, 170, 170),
(235, '6', 10, 4000, 170,
170, 170, 170),
(236, '6', 10, 4000, 170, 170, 170, 170),
(237, '6', 10,
4000, 170, 170, 170, 170),
(238, '6', 10, 4000, 170, 170, 170, 170),
(239,
'6', 10, 4000, 170, 170, 170, 170),
(240, '6', 10, 4000, 170, 170, 170,
170),
(241, '6', 10, 4000, 170, 170, 170, 170),
(242, '6', 10, 4000, 170,
170, 170, 170),
(243, '6', 10, 4000, 170, 170, 170, 170),
(244, '6', 10,
4000, 170, 170, 170, 170),
(245, '6', 10, 4000, 170, 170, 170, 170),
(246,
'6', 10, 4000, 170, 170, 170, 170),
(247, '6', 10, 4000, 170, 170, 170,
170),
(248, '6', 10, 4000, 170, 170, 170, 170),
(249, '6', 10, 4000, 170,
170, 170, 170),
(250, '6', 10, 4000, 170, 170, 170, 170),
(251, '6', 10,
4000, 170, 170, 170, 170),
(252, '6', 10, 4000, 170, 170, 170, 170),
(253,
'6', 10, 4000, 170, 170, 170, 170),
(254, '6', 10, 4000, 170, 170, 170,
170),
(255, '6', 10, 4000, 170, 170, 170, 170),
(256, '6', 10, 4000, 170,
170, 170, 170),
(257, '6', 10, 4000, 170, 170, 170, 170),
(258, '6', 10,
4000, 170, 170, 170, 170),
(259, '6', 10, 4000, 170, 170, 170, 170),
(260,
'6', 10, 4000, 170, 170, 170, 170),
(261, '6', 10, 4000, 170, 170, 170,
170),
(262, '6', 10, 4000, 170, 170, 170, 170),
(263, '6', 10, 4000, 170,
170, 170, 170),
(264, '6', 10, 4000, 170, 170, 170, 170),
(265, '6', 10,
4000, 170, 170, 170, 170),
(266, '6', 10, 4000, 170, 170, 170, 170),
(267,
'6', 10, 4000, 170, 170, 170, 170),
(268, '6', 10, 4000, 170, 170, 170,
170),
(269, '6', 10, 4000, 170, 170, 170, 170),
(270, '6', 10, 4000, 170,
170, 170, 170),
(271, '6', 10, 4000, 170, 170, 170, 170),
(272, '6', 10,
4000, 170, 170, 170, 170),
(273, '6', 10, 4000, 170, 170, 170, 170),
(274,
'6', 10, 4000, 170, 170, 170, 170),
(275, '6', 10, 4000, 170, 170, 170,
170),
(276, '6', 10, 4000, 170, 170, 170, 170),
(277, '6', 10, 4000, 170,
170, 170, 170),
(278, '6', 10, 4000, 170, 170, 170, 170),
(279, '6', 10,
4000, 170, 170, 170, 170),
(280, '6', 10, 4000, 170, 170, 170, 170),
(281,
'6', 10, 4000, 170, 170, 170, 170),
(282, '6', 10, 4000, 170, 170, 170,
170),
(283, '6', 10, 4000, 170, 170, 170, 170),
(284, '6', 10, 4000, 170,
170, 170, 170),
(285, '6', 10, 4000, 170, 170, 170, 170),
(286, '6', 10,
4000, 170, 170, 170, 170),
(287, '6', 10, 4000, 170, 170, 170, 170),
(288,
'6', 10, 4000, 170, 170, 170, 170),
(289, '6', 10, 4000, 170, 170, 170,
170),
(290, '6', 10, 4000, 170, 170, 170, 170),
(291, '6', 10, 4000, 170,
170, 170, 170),
(292, '6', 10, 4000, 170, 170, 170, 170),
(293, '6', 10,
4000, 170, 170, 170, 170),
(294, '6', 10, 4000, 170, 170, 170, 170),
(295,
'6', 10, 4000, 170, 170, 170, 170),
(296, '6', 10, 4000, 170, 170, 170,
170),
(297, '6', 10, 4000, 170, 170, 170, 170),
(298, '5', 10, 2000, 120,
120, 120, 120),
(299, '5', 10, 2000, 120, 120, 120, 120),
(300, '5', 10,
2000, 120, 120, 120, 120),
(301, '5', 10, 2000, 120, 120, 120, 120),
(302,
'5', 10, 2000, 120, 120, 120, 120),
(303, '5', 10, 2000, 120, 120, 120,
120),
(304, '5', 10, 2000, 120, 120, 120, 120),
(305, '5', 10, 2000, 120,
120, 120, 120),
(306, '5', 10, 2000, 120, 120, 120, 120),
(307, '5', 10,
2000, 120, 120, 120, 120),
(308, '5', 10, 2000, 120, 120, 120, 120),
(309,
'5', 10, 2000, 120, 120, 120, 120),
(310, '5', 10, 2000, 120, 120, 120,
120),
(311, '5', 10, 2000, 120, 120, 120, 120),
(312, '5', 10, 2000, 120,
120, 120, 120),
(313, '5', 10, 2000, 120, 120, 120, 120);
--
--------------------------------------------------------
--
-- Table
structure for table `strides`
--
CREATE TABLE IF NOT EXISTS `strides` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT
'0',
`s` int(2) NOT NULL DEFAULT '0',
`c` int(11) NOT NULL DEFAULT
'0',
`complete` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `support`
--
CREATE TABLE IF NOT EXISTS `support` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`user`
int(5) NOT NULL,
`time` varchar(50) NOT NULL,
`close` int(1) NOT NULL,
`type` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `support_comment`
--
CREATE TABLE IF NOT EXISTS
`support_comment` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`ticket`
int(5) NOT NULL,
`user` int(5) NOT NULL,
`text` text NOT NULL,
`time`
varchar(50) NOT NULL,
`support` int(1) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `user_q`
--
CREATE TABLE IF NOT EXISTS `user_q` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` int(11) NOT NULL DEFAULT
'0',
`q` int(11) NOT NULL DEFAULT '0',
`c` int(11) NOT NULL DEFAULT
'0',
`complete` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL
DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;
--
--------------------------------------------------------
--
-- Table
structure for table `vartotojai`
--
CREATE TABLE IF NOT EXISTS
`vartotojai` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nick` varchar(20)
CHARACTER SET utf8 NOT NULL,
`pass` varchar(32) CHARACTER SET utf8 NOT
NULL,
`iki_pm` int(11) NOT NULL,
`inputas` varchar(10) CHARACTER SET
utf8 NOT NULL,
`paskutinis_prisijungimas` varchar(20) CHARACTER SET utf8
NOT NULL,
`registracijos_data` varchar(20) CHARACTER SET utf8 NOT NULL,
`diena` int(2) NOT NULL,
`menuo` int(2) NOT NULL,
`metai` int(4) NOT
NULL,
`lytis` int(1) NOT NULL,
`email` varchar(100) CHARACTER SET utf8
NOT NULL,
`uzrasai` varchar(10000) CHARACTER SET utf8 NOT NULL,
`statusas` varchar(20) CHARACTER SET utf8 NOT NULL,
`forum` int(20) NOT
NULL,
`ip` varchar(20) COLLATE latin1_general_ci NOT NULL,
`narsykle`
varchar(200) COLLATE latin1_general_ci NOT NULL,
`self` text COLLATE
latin1_general_ci NOT NULL,
`antispam` int(2) NOT NULL,
`js1` int(1)
NOT NULL,
`js2` int(1) NOT NULL,
`js3` int(1) NOT NULL,
`silence`
int(11) NOT NULL,
`level` int(11) NOT NULL DEFAULT '1',
`hp` int(11)
NOT NULL,
`mp` int(11) NOT NULL,
`exp` int(11) NOT NULL DEFAULT '1',
`g` bigint(20) NOT NULL,
`s` bigint(20) NOT NULL,
`online` int(11) NOT
NULL,
`last_update` int(11) NOT NULL,
`vit` int(11) NOT NULL DEFAULT
'10',
`_vit` int(11) NOT NULL,
`mana` int(11) NOT NULL DEFAULT '1015',
`_mana` int(11) NOT NULL,
`duel_last_update` int(11) NOT NULL,
`duel_fights` int(11) NOT NULL,
`duel_changes` int(11) NOT NULL,
`duel_rating` int(11) NOT NULL,
`duel_trophy` int(11) NOT NULL,
`duel_nagrada` int(1) NOT NULL,
`news` int(1) NOT NULL,
`str` int(11)
NOT NULL DEFAULT '10',
`_str` int(11) NOT NULL,
`agi` int(11) NOT NULL
DEFAULT '10',
`_agi` int(11) NOT NULL,
`def` int(11) NOT NULL DEFAULT
'10',
`_def` int(11) NOT NULL,
`ability_1` int(11) NOT NULL,
`ability_1_quality` enum('0','1','2','3','4','5','6') COLLATE
latin1_general_ci NOT NULL,
`ability_2` int(11) NOT NULL,
`ability_2_quality` enum('0','1','2','3','4','5','6') COLLATE
latin1_general_ci NOT NULL,
`ability_3` int(11) NOT NULL,
`ability_3_quality` enum('0','1','2','3','4','5','6') COLLATE
latin1_general_ci NOT NULL,
`ability_4` int(11) NOT NULL,
`ability_4_quality` enum('0','1','2','3','4','5','6') COLLATE
latin1_general_ci NOT NULL,
`ability_5` int(11) NOT NULL,
`ability_5_quality` enum('0','1','2','3','4','5','6') COLLATE
latin1_general_ci NOT NULL,
`eq` int(1) NOT NULL,
`w_1` int(11) NOT
NULL,
`w_2` int(11) NOT NULL,
`w_3` int(11) NOT NULL,
`w_4` int(11)
NOT NULL,
`w_5` int(11) NOT NULL,
`w_6` int(11) NOT NULL,
`w_7`
int(11) NOT NULL,
`w_8` int(11) NOT NULL,
`skill` int(11) NOT NULL,
`premium` int(11) NOT NULL,
`premium_true` int(1) NOT NULL,
`effect1`
int(11) NOT NULL,
`effect1_true` int(1) NOT NULL,
`effect2` int(11) NOT
NULL,
`effect2_true` int(1) NOT NULL,
`effect3` int(11) NOT NULL,
`effect3_true` int(1) NOT NULL,
`chest` enum('0','1') COLLATE
latin1_general_ci NOT NULL,
`akmuo` int(11) NOT NULL,
`zole` int(11)
NOT NULL,
`akmuo_next` int(11) NOT NULL,
`zole_next` int(11) NOT NULL,
`akmuo_time` int(11) NOT NULL,
`zole_time` int(11) NOT NULL,
`e1`
int(11) NOT NULL,
`e1_time` int(11) NOT NULL,
`e2` int(11) NOT NULL,
`e2_time` int(11) NOT NULL,
`e3` int(11) NOT NULL,
`e3_time` int(11)
NOT NULL,
`e4` int(11) NOT NULL,
`e4_time` int(11) NOT NULL,
`standart` int(1) NOT NULL,
`standart_time` int(11) NOT NULL,
`dovana`
int(1) NOT NULL,
`tasks` int(2) NOT NULL,
`tasks2` int(2) NOT NULL,
`saved` int(1) NOT NULL,
`kalba` varchar(2) COLLATE latin1_general_ci NOT
NULL,
`kalbu_perjungimas` int(1) NOT NULL,
`clan_buff` int(3) NOT
NULL,
`sell_items` int(1) NOT NULL,
`free_energy` int(1) NOT NULL,
`dungChapter` int(3) NOT NULL DEFAULT '1',
`dungTask` int(3) NOT NULL
DEFAULT '0',
`force` int(1) NOT NULL DEFAULT '1',
`force_updated`
int(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `str`
(`str`,`vit`,`agi`,`def`),
KEY `duel_rating` (`duel_rating`),
KEY
`ability_1` (`ability_1`,`ability_2`,`ability_3`,`ability_4`,`ability_5`),
KEY `level` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
/*!40101 SET
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;