334jBm2E

1CREATE TABLE IF NOT EXISTS `dayz_iConomy` (
2`id` int(255) NOT NULL,
3  `username` varchar(32) NOT NULL,
4  `balance` double(64,2) NOT NULL,
5  `status` int(2) NOT NULL DEFAULT '0'
6) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=110 ;
7
8INSERT INTO `dayz_iConomy` (`id`, `username`, `balance`, `status`) VALUES
9(108, 'MrYarik666', 393.00, 1);
10
11CREATE TABLE IF NOT EXISTS `dle_users` (
12  `email` varchar(50) NOT NULL DEFAULT '',
13  `password` varchar(32) NOT NULL DEFAULT '',
14  `name` varchar(40) NOT NULL DEFAULT '',
15`user_id` int(11) NOT NULL,
16  `news_num` mediumint(8) NOT NULL DEFAULT '0',
17  `comm_num` mediumint(8) NOT NULL DEFAULT '0',
18  `user_group` smallint(5) NOT NULL DEFAULT '4',
19  `lastdate` varchar(20) DEFAULT NULL,
20  `reg_date` varchar(20) DEFAULT NULL,
21  `banned` varchar(5) NOT NULL DEFAULT '',
22  `allow_mail` tinyint(1) NOT NULL DEFAULT '1',
23  `info` text NOT NULL,
24  `signature` text NOT NULL,
25  `foto` varchar(50) NOT NULL DEFAULT '',
26  `fullname` varchar(100) NOT NULL DEFAULT '',
27  `land` varchar(100) NOT NULL DEFAULT '',
28  `favorites` text NOT NULL,
29  `pm_all` smallint(5) NOT NULL DEFAULT '0',
30  `pm_unread` smallint(5) NOT NULL DEFAULT '0',
31  `time_limit` varchar(20) NOT NULL DEFAULT '',
32  `xfields` text NOT NULL,
33  `allowed_ip` varchar(255) NOT NULL DEFAULT '',
34  `hash` varchar(32) NOT NULL DEFAULT '',
35  `logged_ip` varchar(40) NOT NULL DEFAULT '',
36  `restricted` tinyint(1) NOT NULL DEFAULT '0',
37  `restricted_days` smallint(4) NOT NULL DEFAULT '0',
38  `restricted_date` varchar(15) NOT NULL DEFAULT '',
39  `timezone` varchar(100) NOT NULL DEFAULT '',
40  `money` decimal(10,2) NOT NULL,
41  `uuid` char(36) DEFAULT NULL,
42  `accessToken` char(32) DEFAULT NULL,
43  `serverID` varchar(41) DEFAULT NULL,
44  `group` int(11) NOT NULL DEFAULT '0',
45  `duration` varchar(150) NOT NULL DEFAULT '0',
46  `ban_count` int(11) NOT NULL DEFAULT '0',
47  `sp` text NOT NULL,
48  `city` text NOT NULL,
49  `aboutMySelf` text NOT NULL,
50  `likes` int(11) NOT NULL DEFAULT '0',
51  `status` text NOT NULL
52) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=761 ;
53
54INSERT INTO `dle_users` (`email`, `password`, `name`, `user_id`, `news_num`, `comm_num`, `user_group`, `lastdate`, `reg_date`, `banned`, `allow_mail`, `info`, `signature`, `foto`, `fullname`, `land`, `favorites`, `pm_all`, `pm_unread`, `time_limit`, `xfields`, `allowed_ip`, `hash`, `logged_ip`, `restricted`, `restricted_days`, `restricted_date`, `timezone`, `money`, `uuid`, `accessToken`, `serverID`, `group`, `duration`, `ban_count`, `sp`, `city`, `aboutMySelf`, `likes`, `status`) VALUES
55('MrYarik666@MrYarik666.ru', '123', 'MrYarik666', 1, 1, 0, 1, '1475271163', '1474038455', '', 1, '', '', '', 'Ярослав', '', '', 0, 0, '', '', '', '', '77.120.42.123', 0, 0, '', '', '377.00', NULL, NULL, NULL, 0, '0', 1, 'влюблен в Свою Руку', 'Донецк', '', 12, ''),
56('MsKate666@MsKate666.ru', '123', 'MsKate666', 760, 1, 0, 1, '1475271163', '1474038455', '', 1, '', '', '', 'Катя', '', '', 0, 0, '', '', '', '', '77.120.42.123', 0, 0, '', '', '489.20', NULL, NULL, NULL, 0, '0', 1, 'влюблена', 'Донецк', 'Няшка', 105, '');
57
58CREATE TABLE IF NOT EXISTS `xmodblocker` (
59`id` int(255) NOT NULL,
60  `name` text NOT NULL,
61  `metadata` int(11) NOT NULL,
62  `cause` varchar(512) CHARACTER SET utf8 NOT NULL,
63  `server` text NOT NULL,
64  `group` varchar(64) NOT NULL DEFAULT 'oper'
65) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;
66
67INSERT INTO `xmodblocker` (`id`, `name`, `metadata`, `cause`, `server`, `group`) VALUES
68(10, 'minecraft#wool', 8, 'Лол кек лол', 'OstiumTech', 'oper'),
69(16, 'xmodpanel#hairBand', 5, 'Lol_kek_', 'OstiumTech', 'oper');
70
71ALTER TABLE `dayz_iConomy`
72 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`);
73
74ALTER TABLE `dle_users`
75 ADD PRIMARY KEY (`user_id`), ADD UNIQUE KEY `name` (`name`), ADD UNIQUE KEY `email` (`email`), ADD UNIQUE KEY `uuid` (`uuid`);
76
77ALTER TABLE `xmodblocker`
78 ADD PRIMARY KEY (`id`);
79
80ALTER TABLE `dayz_iConomy`
81MODIFY `id` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=110;
82
83ALTER TABLE `dle_users`
84MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=761;
85
86ALTER TABLE `xmodblocker`
87MODIFY `id` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=35;