· 5 years ago · May 28, 2020, 05:46 PM
1-- Adminer 4.2.2 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `as_comments`;
9CREATE TABLE `as_comments` (
10 `comment_id` int(11) NOT NULL AUTO_INCREMENT,
11 `posted_by` int(11) NOT NULL,
12 `posted_by_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
13 `comment` text COLLATE utf8_unicode_ci NOT NULL,
14 `post_time` datetime NOT NULL,
15 PRIMARY KEY (`comment_id`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
17
18INSERT INTO `as_comments` (`comment_id`, `posted_by`, `posted_by_name`, `comment`, `post_time`) VALUES
19(21, 2, 'CaBomm', 'Testovací novinka', '0000-00-00 00:00:00'),
20(22, 2, 'CaBomm', 'sdf', '2015-03-12 22:39:25'),
21(23, 2, 'CaBomm', 'sdasd', '2015-03-12 22:39:44'),
22(24, 2, 'CaBomm', 'asdsd', '2015-03-12 22:45:17');
23
24DROP TABLE IF EXISTS `as_login_attempts`;
25CREATE TABLE `as_login_attempts` (
26 `id_login_attempts` int(11) NOT NULL AUTO_INCREMENT,
27 `ip_addr` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
28 `attempt_number` int(11) NOT NULL DEFAULT '1',
29 `date` date NOT NULL,
30 PRIMARY KEY (`id_login_attempts`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
32
33INSERT INTO `as_login_attempts` (`id_login_attempts`, `ip_addr`, `attempt_number`, `date`) VALUES
34(24, '90.180.251.124', 4, '2015-03-03'),
35(25, '90.180.251.124', 1, '2015-03-04'),
36(26, '80.188.122.182', 1, '2015-03-04'),
37(27, '90.180.251.124', 1, '2015-03-05'),
38(28, '81.90.168.137', 1, '2015-03-07'),
39(29, '178.255.168.44', 3, '2015-03-08'),
40(30, '78.102.165.158', 4, '2015-03-08'),
41(31, '81.90.168.137', 1, '2015-03-08'),
42(32, '92.62.228.76', 2, '2015-03-08'),
43(33, '85.70.235.72', 1, '2015-03-08'),
44(34, '92.62.228.76', 1, '2015-03-09'),
45(35, '92.62.228.76', 1, '2015-03-10'),
46(36, '77.48.112.249', 4, '2015-03-12'),
47(37, '194.213.220.137', 1, '2015-03-12'),
48(38, '78.102.165.158', 4, '2015-03-13'),
49(39, '91.245.29.158', 2, '2015-03-13'),
50(40, '80.188.122.182', 2, '2015-03-13'),
51(41, '81.90.168.137', 1, '2015-03-13'),
52(42, '78.102.165.158', 4, '2015-03-14'),
53(43, '78.156.141.32', 2, '2015-03-14'),
54(44, '85.70.235.72', 1, '2015-03-14'),
55(45, '81.90.168.137', 2, '2015-03-15'),
56(46, '78.102.165.158', 3, '2015-03-15'),
57(47, '81.90.168.137', 1, '2015-03-18'),
58(48, '85.70.235.72', 1, '2015-03-19'),
59(49, '81.90.168.137', 1, '2015-03-28'),
60(50, '85.70.235.72', 1, '2015-03-28'),
61(51, '77.48.112.249', 2, '2015-03-28');
62
63DROP TABLE IF EXISTS `as_social_logins`;
64CREATE TABLE `as_social_logins` (
65 `id` int(11) NOT NULL AUTO_INCREMENT,
66 `user_id` int(11) NOT NULL,
67 `provider` varchar(50) COLLATE utf8_unicode_ci DEFAULT 'email',
68 `provider_id` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
69 `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
70 PRIMARY KEY (`id`)
71) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
72
73
74DROP TABLE IF EXISTS `as_users`;
75CREATE TABLE `as_users` (
76 `user_id` int(11) NOT NULL AUTO_INCREMENT,
77 `email` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
78 `username` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
79 `credits` int(11) NOT NULL DEFAULT '120',
80 `password` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
81 `confirmation_key` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
82 `confirmed` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
83 `password_reset_key` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
84 `password_reset_confirmed` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
85 `password_reset_timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
86 `register_date` date NOT NULL,
87 `user_role` int(4) NOT NULL DEFAULT '1',
88 `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
89 `banned` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
90 PRIMARY KEY (`user_id`),
91 UNIQUE KEY `username` (`username`)
92) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
93
94INSERT INTO `as_users` (`user_id`, `email`, `username`, `credits`, `password`, `confirmation_key`, `confirmed`, `password_reset_key`, `password_reset_confirmed`, `password_reset_timestamp`, `register_date`, `user_role`, `last_login`, `banned`) VALUES
95(1, 'admin@217.16.179.150', 'admin', 3974, '$2a$13$8CHffXc/InyNucOIxRyKr.Nqgc2yv0kV3MAqUrPQoWqUexUxsWyFq', '', 'Y', '', 'N', '0000-00-00 00:00:00', '2015-02-09', 3, '2015-04-17 15:21:18', 'N'),
96(2, 'cabomm@seznam.cz', 'CaBomm', 100000333, '$2a$13$8CHffXc/InyNucOIxRyKr.uCRbw61lvT29qphfCeDu7MKRtCc7ntS', 'e59231a3b9fdcf8f1b2076ff7f18a1e8', 'Y', 'f84d132f46799e43a60238e392bd5f13', 'N', '2015-03-07 22:04:51', '2015-02-09', 3, '2020-05-28 15:00:16', 'N'),
97(37, 'teeeo123@seznam.cz', 'TeoCZ', 500, '$2a$13$8CHffXc/InyNucOIxRyKr.YxqBPMjbq.Z26voO4smZLFlL7DaCfve', 'cfa67d6c52c861c0c547474a4f5fa12d', 'Y', '', 'N', '0000-00-00 00:00:00', '2015-03-08', 1, '2015-03-08 14:11:18', 'Y'),
98(38, 'sendorcz@post.cz', 'Hellix', 0, '$2a$13$8CHffXc/InyNucOIxRyKr.N6tAd9ezE1yVC8mEfaOQWB1EorGpARi', 'fffdfef145496a2f8ca4a2121f0d18cd', 'Y', '111a50affa8f788d997d8686405121ce', 'N', '2015-03-12 08:05:23', '2015-03-11', 1, '2015-03-28 19:02:43', 'N'),
99(39, 'HoubickarCZ@gmail.com', 'HoubickarCZ', 120, '$2a$13$8CHffXc/InyNucOIxRyKr.vNMIpEC80xho7C4kyA4Q.QY.6KN10x.', '149ff3e40b49f7a2ccff6d0a952127cb', 'Y', '', 'N', '0000-00-00 00:00:00', '2015-03-11', 1, '2015-03-11 21:13:18', 'N'),
100(40, 'Robot@centrum.cz', 'Trio', 120, '$2a$13$8CHffXc/InyNucOIxRyKr.dHy2VTAeJZySBbZI0lTxAiXFltO1/1q', '787899d6f500c5982db7e457c1bb177e', 'Y', '', 'N', '0000-00-00 00:00:00', '2020-05-28', 1, '2020-05-28 11:51:48', 'N');
101
102DROP TABLE IF EXISTS `as_user_details`;
103CREATE TABLE `as_user_details` (
104 `id_user_details` int(11) NOT NULL AUTO_INCREMENT,
105 `user_id` int(11) NOT NULL,
106 `first_name` varchar(35) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
107 `last_name` varchar(35) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
108 `phone` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
109 `address` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
110 PRIMARY KEY (`id_user_details`)
111) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
112
113INSERT INTO `as_user_details` (`id_user_details`, `user_id`, `first_name`, `last_name`, `phone`, `address`) VALUES
114(1, 2, '', '', '', ''),
115(2, 3, '', '', '', ''),
116(3, 1, '', '', '774222161', ''),
117(4, 4, '', '', '', ''),
118(5, 5, 'Václav', 'Halík', '722087912', 'Masarykova '),
119(6, 6, '', '', '', ''),
120(7, 7, '', '', '', ''),
121(8, 8, '', '', '', ''),
122(9, 9, '', '', '', ''),
123(10, 10, '', '', '', ''),
124(11, 11, '', '', '', ''),
125(12, 12, '', '', '', ''),
126(13, 13, '', '', '', ''),
127(14, 14, '', '', '', ''),
128(15, 15, '', '', '', ''),
129(16, 16, '', '', '', ''),
130(17, 17, '', '', '', ''),
131(18, 18, '', '', '', ''),
132(19, 19, '', '', '', ''),
133(20, 20, '', '', '', ''),
134(21, 21, '', '', '', ''),
135(22, 22, '', '', '', ''),
136(23, 23, '', '', '', ''),
137(24, 24, '', '', '', ''),
138(25, 25, '', '', '', ''),
139(26, 26, '', '', '', ''),
140(27, 27, '', '', '', ''),
141(28, 28, '', '', '', ''),
142(29, 29, '', '', '', ''),
143(30, 30, '', '', '', ''),
144(31, 31, '', '', '', ''),
145(32, 32, '', '', '', ''),
146(33, 33, '', '', '', ''),
147(34, 34, '', '', '', ''),
148(35, 35, '', '', '', ''),
149(36, 36, '', '', '', ''),
150(37, 37, '', '', '', ''),
151(38, 38, '', '', '', ''),
152(39, 39, '', '', '', ''),
153(40, 40, '', '', '', ''),
154(41, 41, '', '', '', ''),
155(42, 42, '', '', '', ''),
156(43, 43, '', '', '', ''),
157(44, 44, '', '', '', ''),
158(45, 45, '', '', '', ''),
159(46, 46, '', '', '', ''),
160(47, 47, '', '', '', ''),
161(48, 48, '', '', '', ''),
162(49, 49, '', '', '', ''),
163(50, 50, '', '', '', ''),
164(51, 51, '', '', '', ''),
165(52, 52, '', '', '', ''),
166(53, 53, '', '', '', ''),
167(54, 54, '', '', '', ''),
168(55, 55, '', '', '', ''),
169(56, 56, '', '', '', ''),
170(57, 57, '', '', '', ''),
171(58, 58, '', '', '', ''),
172(59, 59, '', '', '', ''),
173(60, 60, '', '', '', ''),
174(61, 40, '', '', '', '');
175
176DROP TABLE IF EXISTS `as_user_roles`;
177CREATE TABLE `as_user_roles` (
178 `role_id` int(11) NOT NULL AUTO_INCREMENT,
179 `role` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
180 PRIMARY KEY (`role_id`)
181) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
182
183INSERT INTO `as_user_roles` (`role_id`, `role`) VALUES
184(1, 'user'),
185(2, 'editor'),
186(3, 'admin');
187
188DROP TABLE IF EXISTS `config`;
189CREATE TABLE `config` (
190 `id` int(11) NOT NULL AUTO_INCREMENT,
191 `key` varchar(255) DEFAULT NULL,
192 `value` varchar(255) DEFAULT NULL,
193 `date_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
194 PRIMARY KEY (`id`)
195) ENGINE=InnoDB DEFAULT CHARSET=latin1;
196
197INSERT INTO `config` (`id`, `key`, `value`, `date_created`) VALUES
198(1, 'paypal_environment', 'production', '2014-12-11 12:24:45'),
199(2, 'payment_type', 'input', '2014-12-03 22:13:59'),
200(3, 'https_redirect', '0', '2014-12-03 22:13:59'),
201(4, 'email', '', '2014-12-03 22:13:59'),
202(5, 'show_description', '1', '2014-12-03 22:13:59'),
203(6, 'page_title', 'PayPal Advanced Payment Terminal', '2014-12-03 22:13:59'),
204(7, 'show_billing_address', '0', '2014-12-03 22:13:59'),
205(8, 'name', '', '2014-12-04 09:49:55'),
206(9, 'enable_subscriptions', '1', '2014-12-04 14:03:15'),
207(10, 'paypal_email', '', '2014-12-04 15:59:49'),
208(11, 'subscription_length', '0', '2014-12-08 14:11:49'),
209(12, 'subscription_interval', '1', '2014-12-08 14:13:06'),
210(13, 'currency', 'USD', '2014-12-29 21:29:16'),
211(14, 'enable_trial', '0', '2014-12-31 10:48:23'),
212(15, 'trial_days', '7', '2014-12-31 11:03:34');
213
214DROP TABLE IF EXISTS `ftp_minecraft_servers`;
215CREATE TABLE `ftp_minecraft_servers` (
216 `id` int(11) NOT NULL AUTO_INCREMENT,
217 `id_serveru` int(11) NOT NULL,
218 `user_id` int(11) NOT NULL,
219 `login` varchar(300) NOT NULL,
220 `password` varchar(300) NOT NULL,
221 `dir` varchar(300) NOT NULL,
222 KEY `id` (`id`),
223 KEY `user_id` (`user_id`),
224 KEY `dir` (`dir`(255))
225) ENGINE=InnoDB DEFAULT CHARSET=utf8;
226
227INSERT INTO `ftp_minecraft_servers` (`id`, `id_serveru`, `user_id`, `login`, `password`, `dir`) VALUES
228(197, 44, 2, 'mc_24427', 'jtyk539lop', '/home/hosting/minecraft/mc_24427'),
229(198, 45, 2, 'mc_24917', 'u6g6d7xxo7', '/home/hosting/minecraft/mc_24917'),
230(199, 46, 2, 'mc_26716', 'f7pzlyrqes', '/home/hosting/minecraft/mc_26716'),
231(200, 47, 2, 'mc_29759', 't2i7xrkzjf', '/home/hosting/minecraft/mc_29759'),
232(201, 48, 38, 'mc_29414', 'n9n1c5guye', '/home/hosting/minecraft/mc_29414'),
233(202, 49, 1, 'mc_20409', 'icszha1eyo', '/home/hosting/minecraft/mc_20409'),
234(203, 50, 1, 'mc_20082', 'xgpjdujgic', '/home/hosting/minecraft/mc_20082'),
235(204, 51, 1, 'mc_28227', 'yhd18iehyg', '/home/hosting/minecraft/mc_28227'),
236(205, 52, 2, 'mc_24379', '2kq2uh4d9n', '/home/hosting/minecraft/mc_24379'),
237(206, 53, 2, 'mc_23321', 'hxve43hnmt', '/home/hosting/minecraft/mc_23321'),
238(207, 54, 1, 'mc_29902', '0ba4ren4pt', '/home/hosting/minecraft/mc_29902'),
239(208, 55, 2, 'mc_28417', 'szxztqibju', '/home/hosting/minecraft/mc_28417'),
240(209, 56, 2, 'mc_28362', 'eulgc7n6zm', '/home/hosting/minecraft/mc_28362'),
241(210, 57, 2, 'mc_28373', '9uwarib08p', '/home/hosting/minecraft/mc_28373'),
242(211, 58, 2, 'mc_23546', 'hj90nm6j96', '/home/hosting/minecraft/mc_23546'),
243(212, 59, 2, 'mc_21627', 'vg3gbj3ino', '/home/hosting/minecraft/mc_21627'),
244(213, 60, 2, 'mc_24252', 'tktrzhjb8l', '/home/hosting/minecraft/mc_24252'),
245(214, 61, 1, 'mc_29032', 'f8jwcozk7e', '/home/hosting/minecraft/mc_29032'),
246(215, 62, 1, 'mc_22425', '662af5jbqb', '/home/hosting/minecraft/mc_22425'),
247(216, 63, 1, 'mc_25430', 'fu1lsz8eeq', '/home/hosting/minecraft/mc_25430'),
248(217, 64, 1, 'mc_21360', '0e9oiu2xnv', '/home/hosting/minecraft/mc_21360'),
249(218, 65, 1, 'mc_22026', 'c50eznrn5f', '/home/hosting/minecraft/mc_22026'),
250(219, 66, 2, 'mc_29906', 'gfm629ikca', '/home/hosting/minecraft/mc_29906'),
251(220, 67, 1, 'mc_23983', '7jkmk7m5nk', '/home/hosting/minecraft/mc_23983'),
252(221, 68, 2, 'mc_23422', '9lvkdt8n1v', '/home/hosting/minecraft/servers//mc_23422'),
253(222, 69, 2, 'mc_20789', 'oc1fws0uzh', '/home/hosting/minecraft/servers//mc_20789'),
254(223, 70, 2, 'mc_27880', 'g0vuv4qt7y', '/home/hosting/minecraft/servers//mc_27880'),
255(224, 71, 2, 'mc_29135', 'xltymjb1fg', '/home/hosting/minecraft/servers//mc_29135');
256
257DROP TABLE IF EXISTS `ftp_webhosting`;
258CREATE TABLE `ftp_webhosting` (
259 `id` int(11) NOT NULL AUTO_INCREMENT,
260 `user_id` int(11) NOT NULL,
261 `login` varchar(300) NOT NULL,
262 `password` varchar(300) NOT NULL,
263 `dir` varchar(300) NOT NULL,
264 PRIMARY KEY (`id`)
265) ENGINE=InnoDB DEFAULT CHARSET=latin1;
266
267INSERT INTO `ftp_webhosting` (`id`, `user_id`, `login`, `password`, `dir`) VALUES
268(6, 2, 'wh_2', '85mhnemov3', '/home/hosting/webhosting/wh_2'),
269(7, 2, 'wh_2', '82qngloypi', '/home/hosting/webhosting/wh_2'),
270(8, 2, 'wh_05773', 'e05cs7wmeo', '/home/hosting/webhosting/wh_2'),
271(9, 2, 'wh_60584', 'q0j6hsydbs', '/home/hosting/webhosting/wh_60584'),
272(10, 2, 'wh_60790', 'll2oh654ai', '/home/hosting/webhosting/wh_60790'),
273(11, 2, 'wh_75143', 'bxmb0mqkso', '/home/hosting/webhosting/wh_75143'),
274(12, 2, 'wh_46918', 'sp8v3dgo9n', '/home/hosting/webhosting/wh_46918'),
275(13, 2, 'wh_56336', '4p67hxa87x', '/home/hosting/webhosting/wh_56336'),
276(14, 2, 'wh_51006', 'ib0rgu3b9d', '/home/hosting/webhosting/wh_51006'),
277(15, 2, 'wh_34063', '95d6lmasxi', '/home/hosting/webhosting/wh_34063'),
278(16, 2, 'wh_82860', 'zi7qzoufgr', '/home/hosting/webhosting/wh_82860'),
279(17, 2, 'wh_07219', 'lg3qx9bkx6', '/home/hosting/webhosting/wh_07219'),
280(18, 2, 'wh_39604', 'spncy25nc2', '/home/hosting/webhosting/wh_39604'),
281(19, 2, 'wh_09635', '7s14dm1r9a', '/home/hosting/webhosting/wh_09635'),
282(20, 2, 'wh_23235', 'jxh74bifpk', '/home/hosting/webhosting/wh_23235'),
283(21, 2, 'wh_03874', 'qkqn5dl1w6', '/home/hosting/webhosting/wh_03874'),
284(22, 2, 'wh_12205', 'ny6h93u5l4', '/home/hosting/webhosting/wh_12205'),
285(23, 2, 'wh_05088', 'sdf0z46l7s', '/home/hosting/webhosting/wh_05088'),
286(24, 2, 'wh_21383', 'rc7b3hg3dh', '/home/hosting/webhosting/wh_21383'),
287(25, 2, 'wh_92073', '9w3tihkpcv', '/home/hosting/webhosting/wh_92073'),
288(26, 2, 'wh_18800', '2cqo7p1oza', '/home/hosting/webhosting/wh_18800'),
289(27, 2, 'wh_20186', 'l2rx5mczui', '/home/hosting/webhosting/wh_20186'),
290(28, 2, 'wh_68811', 'w7eipahkyj', '/home/hosting/webhosting/wh_68811'),
291(29, 2, 'wh_25287', 'tsb2fxcfcb', '/home/hosting/webhosting/wh_25287'),
292(30, 2, 'wh_58304', 'fj59pqh66t', '/home/hosting/webhosting/wh_58304'),
293(31, 2, 'wh_30764', '3a438hky2s', '/home/hosting/webhosting/wh_30764'),
294(32, 2, 'wh_29681', 'u8xm4k4xrf', '/home/hosting/webhosting/wh_29681'),
295(33, 2, 'wh_81054', 'yzpysb4osa', '/home/hosting/webhosting/wh_81054'),
296(34, 2, 'wh_83838', 'xc1pswco0w', '/home/hosting/webhosting/wh_83838'),
297(35, 2, 'wh_45372', 'bv494xahxa', '/home/hosting/webhosting/wh_45372'),
298(36, 2, 'wh_40386', 'm7g1ipyiv0', '/home/hosting/webhosting/wh_40386'),
299(37, 2, 'wh_77305', '1akqz6jqd5', '/home/hosting/webhosting/wh_77305'),
300(38, 2, 'wh_65028', 'r6vtfczm9k', '/home/hosting/webhosting/wh_65028'),
301(39, 2, 'wh_28063', 'hlw7stevob', '/home/hosting/webhosting/wh_28063'),
302(40, 2, 'wh_78685', '9ebzlwmq0y', '/home/hosting/webhosting/wh_78685'),
303(41, 2, 'wh_62904', 'g6x3m4lkzb', '/home/hosting/webhosting/wh_62904'),
304(42, 2, 'wh_52434', 'c1l1iynhwj', '/home/hosting/webhosting/wh_52434'),
305(43, 2, 'wh_72580', 'xm9je6215l', '/home/hosting/webhosting/wh_72580'),
306(44, 2, 'wh_66992', '382rnpwhpo', '/home/hosting/webhosting/wh_66992'),
307(45, 2, 'wh_32155', 'a1fitzia3v', '/home/hosting/webhosting/wh_32155'),
308(46, 2, 'wh_92705', 'f04aprghj6', '/home/hosting/webhosting/wh_92705'),
309(47, 2, 'wh_74368', 'atou4yjgl4', '/home/hosting/webhosting/wh_74368'),
310(48, 2, 'wh_63648', '9j67gn37rg', '/home/hosting/webhosting/wh_63648'),
311(49, 2, 'wh_06683', '9vbx3sgzpz', '/home/hosting/webhosting/wh_06683'),
312(50, 2, 'wh_60936', 'g7c6amkit5', '/home/hosting/webhosting/wh_60936'),
313(51, 2, 'wh_92844', '12vehzereq', '/home/hosting/webhosting/wh_92844');
314
315DROP TABLE IF EXISTS `invoices`;
316CREATE TABLE `invoices` (
317 `id` int(11) NOT NULL AUTO_INCREMENT,
318 `unique_id` varchar(255) DEFAULT NULL,
319 `email` varchar(255) DEFAULT NULL,
320 `description` text,
321 `amount` decimal(8,2) DEFAULT NULL,
322 `number` varchar(255) DEFAULT NULL,
323 `status` varchar(255) DEFAULT NULL,
324 `date_due` date DEFAULT NULL,
325 `date_paid` datetime DEFAULT NULL,
326 `date_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
327 PRIMARY KEY (`id`)
328) ENGINE=InnoDB DEFAULT CHARSET=latin1;
329
330
331DROP TABLE IF EXISTS `items`;
332CREATE TABLE `items` (
333 `id` int(11) NOT NULL AUTO_INCREMENT,
334 `name` varchar(255) DEFAULT NULL,
335 `price` decimal(8,2) DEFAULT NULL,
336 `date_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
337 PRIMARY KEY (`id`)
338) ENGINE=InnoDB DEFAULT CHARSET=latin1;
339
340
341DROP TABLE IF EXISTS `minecraft_servers`;
342CREATE TABLE `minecraft_servers` (
343 `id` int(11) NOT NULL AUTO_INCREMENT,
344 `name` varchar(200) NOT NULL,
345 `user_id` int(11) NOT NULL,
346 `hash` text NOT NULL,
347 `ram` int(11) NOT NULL,
348 `price` text NOT NULL,
349 `cpu` int(11) NOT NULL DEFAULT '1',
350 `last_update` datetime DEFAULT NULL,
351 `date_expiration` datetime NOT NULL,
352 `version` text,
353 `motd` varchar(200) NOT NULL,
354 `port` int(5) NOT NULL,
355 `date_create` datetime NOT NULL,
356 `spawn_protection` int(11) NOT NULL,
357 `view_distance` varchar(200) NOT NULL,
358 `generate_structures` varchar(200) NOT NULL,
359 `spawn_monsters` varchar(200) NOT NULL DEFAULT '1',
360 `max_players` text NOT NULL,
361 `gamemode` varchar(200) NOT NULL DEFAULT '0',
362 `difficulty` varchar(200) NOT NULL,
363 `pvp` varchar(200) NOT NULL,
364 `online_mode` varchar(200) NOT NULL,
365 `texture_pack` varchar(200) NOT NULL,
366 `hardcore` varchar(200) NOT NULL,
367 `snooper_enabled` varchar(200) NOT NULL,
368 `spawn_animals` varchar(200) NOT NULL,
369 `white_list` varchar(200) NOT NULL,
370 `spawn_npcs` varchar(200) NOT NULL,
371 `max_build_height` tinyint(4) NOT NULL,
372 `server_ip` varchar(200) NOT NULL,
373 `level_seed` text NOT NULL,
374 `enable_rcon` varchar(200) NOT NULL,
375 `level_type` varchar(200) NOT NULL,
376 `allow_flight` varchar(200) NOT NULL,
377 `enable_query` varchar(200) NOT NULL,
378 `level_name` varchar(200) NOT NULL DEFAULT 'world',
379 `rcon_password` varchar(200) NOT NULL,
380 `rcon_port` int(11) NOT NULL,
381 `query_port` int(11) NOT NULL,
382 `allow_nether` varchar(200) NOT NULL,
383 `auto_starting` float NOT NULL,
384 `backup` float NOT NULL,
385 `sponsoring` float NOT NULL DEFAULT '1',
386 `freeze` float NOT NULL DEFAULT '0',
387 KEY `id` (`id`),
388 KEY `user_id` (`user_id`)
389) ENGINE=MyISAM DEFAULT CHARSET=utf8;
390
391INSERT INTO `minecraft_servers` (`id`, `name`, `user_id`, `hash`, `ram`, `price`, `cpu`, `last_update`, `date_expiration`, `version`, `motd`, `port`, `date_create`, `spawn_protection`, `view_distance`, `generate_structures`, `spawn_monsters`, `max_players`, `gamemode`, `difficulty`, `pvp`, `online_mode`, `texture_pack`, `hardcore`, `snooper_enabled`, `spawn_animals`, `white_list`, `spawn_npcs`, `max_build_height`, `server_ip`, `level_seed`, `enable_rcon`, `level_type`, `allow_flight`, `enable_query`, `level_name`, `rcon_password`, `rcon_port`, `query_port`, `allow_nether`, `auto_starting`, `backup`, `sponsoring`, `freeze`) VALUES
392(50, 'lukysek test', 1, 'nQ0D2jk0pH7UjYiLMT8G', 512, '70', 1, NULL, '2015-05-06 17:29:45', NULL, 'lukysek test', 20082, '2015-03-29 17:29:45', 16, '10', 'true', 'false', '1', 'Creative', 'Easy', 'true', 'false', '', 'false', 'false', 'true', 'false', 'true', 127, 'k1.czech-host.cz', '0', 'false', 'DEFAULT', 'false', 'false', 'world', '', 0, 0, 'false', 0, 0, 1, 0),
393(62, 'kkkojio', 1, 'SwjoAcehUlrGsqSenIcb', 1024, '120', 1, NULL, '2015-05-16 14:52:37', NULL, 'kkkojio', 22425, '2015-04-16 14:52:37', 16, '10', 'true', 'true', '10', 'Survival', 'Peaceful', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'true', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
394(48, 'HellixFans', 38, 'njJ6lzzNNVNpCswFpz0u', 1024, '120', 1, NULL, '2015-06-28 19:04:06', NULL, 'HellixFans', 29414, '2015-03-28 19:04:06', 16, '10', 'true', 'true', '10', 'Survival', 'Normal', 'true', 'false', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '0', 'false', 'DEFAULT', 'false', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
395(47, 'kundsa', 2, '2I9hJ3ptT3YldfSULqyK', 512, '70', 1, NULL, '2015-08-06 18:55:12', NULL, 'kobliha', 29759, '2015-03-28 18:55:12', 16, '10', 'true', 'true', '100', 'Creative', 'Normal', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '0', 'false', 'DEFAULT', 'true', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
396(46, 'cabommek', 2, 'Ie5leHOHSmACiSKE6U7W', 512, '70', 1, NULL, '2015-04-28 20:26:06', NULL, 'Lukyho spigot 1.8', 26716, '2015-03-28 18:39:57', 16, '10', 'true', 'true', '999', 'Survival', 'Hard', 'true', 'true', '', 'false', 'false', 'true', 'false', 'true', 127, 'k1.czech-host.cz', '-1480351183376464763', 'false', 'DEFAULT', 'false', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
397(51, 'CheekTest', 1, 'UAzkGLDWAsmpHgmIkH9l', 2048, '200', 1, NULL, '2015-04-30 00:11:31', NULL, 'CheekTest', 28227, '2015-03-30 00:11:31', 16, '10', 'true', 'false', '20', 'Creative', 'Peaceful', 'true', 'false', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'false', 'false', 'world', '', 0, 0, 'false', 0, 0, 1, 0),
398(52, 'testrR', 2, 'fnWaf5KjzS50teHxvn96', 512, '70', 1, NULL, '2015-04-30 17:10:40', NULL, 'testrR', 24379, '2015-03-30 17:06:43', 16, '10', 'true', 'true', '10', 'Survival', 'Peaceful', 'true', 'false', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'false', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
399(53, 'kokos', 2, 'hrqhE8ReTR1duxzmE4ot', 512, '70', 1, NULL, '2015-04-30 17:14:14', NULL, 'kokos', 23321, '2015-03-30 17:14:14', 16, '10', 'true', 'true', '30', 'Survival', 'Peaceful', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'true', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
400(54, 'trada', 1, 'Q8fTYFvSAVGIqyYU0Hnu', 2048, '200', 1, NULL, '2015-04-30 17:18:22', NULL, 'trada', 29902, '2015-03-30 17:18:22', 16, '10', 'true', 'true', '20', 'Survival', 'Hard', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'true', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
401(55, 'asdadssadsad', 2, 'gSk14OXIFh0HsJmuq7sT', 512, '70', 1, NULL, '2015-04-30 17:20:33', NULL, 'asdadssadsad', 28417, '2015-03-30 17:20:33', 16, '10', 'true', 'true', '20', 'Survival', 'Peaceful', 'true', 'false', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'false', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
402(56, 'dagsa', 2, '1zzhlcCkbVkSN5gxOQXB', 512, '70', 1, NULL, '2015-04-30 17:22:39', NULL, 'dagsa', 28362, '2015-03-30 17:22:39', 16, '10', 'true', 'true', '10', 'Survival', 'Peaceful', 'true', 'false', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'false', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
403(57, 'fsadsasc', 2, 'v8i8zzM4CVLhSoGRqUy6', 512, '70', 1, NULL, '2015-04-30 17:23:06', NULL, 'fsadsasc', 28373, '2015-03-30 17:23:06', 16, '10', 'true', 'true', '10', 'Survival', 'Peaceful', 'true', 'false', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'false', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
404(58, 'mrkdsakd', 2, 'rfARWn6VEhB5DbEt1CJi', 512, '70', 1, NULL, '2015-04-30 17:25:52', NULL, 'CaBommovo mrksací server', 23546, '2015-03-30 17:25:52', 16, '10', 'true', 'false', '10', 'Survival', 'Peaceful', 'false', 'false', '', 'false', 'false', 'false', 'false', 'false', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'false', 'false', 'world', '', 0, 0, 'false', 0, 0, 1, 0),
405(59, 'kgasd', 2, 'r45XMftyKbwSb65e1Mdd', 512, '70', 1, NULL, '2020-06-28 06:46:01', NULL, 'kgasd', 21627, '2015-04-08 19:35:11', 16, '10', 'true', 'true', '10', 'Survival', 'Peaceful', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'false', 'false', 'world', '', 0, 0, 'true', 0, 0, 0, 0),
406(60, 'pihxds', 2, 'kQaqflmJKkt2CbDeghvE', 512, '70', 1, NULL, '2015-05-09 14:08:21', NULL, 'pihxds', 24252, '2015-04-09 14:08:21', 16, '10', 'true', 'true', '10', 'Survival', 'Peaceful', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'true', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
407(61, 'testre', 1, 'waEGMcq4SwrWMHrERiSX', 1024, '120', 1, NULL, '2015-05-12 21:58:18', NULL, 'testre', 29032, '2015-04-12 21:58:18', 16, '10', 'true', 'true', '1000', 'Adventure', 'Peaceful', 'false', 'false', '', 'false', 'false', 'false', 'true', 'false', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'false', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
408(63, 'kiklop', 1, 'iyrx0mOF5nKGfSkJHOa4', 512, '70', 1, NULL, '2015-05-16 15:08:28', NULL, 'kiklop', 25430, '2015-04-16 15:08:28', 16, '10', 'true', 'true', '10', 'Survival', 'Peaceful', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'true', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
409(64, 'yep', 1, 'hnVBZbKQcou28hT9Yyt4', 512, '70', 1, NULL, '2015-05-16 15:28:48', NULL, 'yep', 21360, '2015-04-16 15:28:48', 16, '10', 'true', 'true', '10', 'Survival', 'Peaceful', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'true', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
410(65, 'noúe', 1, 'erBd6WkzZg0QZjFAm5A7', 512, '70', 1, '2015-04-17 15:11:39', '2015-06-07 15:30:10', NULL, 'noúe', 22026, '2015-04-16 15:30:10', 16, '10', 'true', 'true', '10', 'Survival', 'Peaceful', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'true', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
411(66, 'ftd', 2, '3GsmaqhPMXmJBYBtXxqW', 2048, '200', 1, '2020-05-27 21:56:23', '2020-09-05 07:09:04', NULL, 'ftd', 29906, '2020-05-28 07:09:04', 16, '10', 'true', 'true', '10', 'Survival', 'Peaceful', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'true', 'false', 'world', '', 0, 0, 'true', 1, 1, 1, 0),
412(67, 'prftpd res', 1, 'aM1yFruDsN7UjmSDcMix', 512, '70', 1, NULL, '2015-05-17 15:21:27', NULL, 'prftpd res', 23983, '2015-04-17 15:21:27', 16, '10', 'true', 'true', '10', 'Survival', 'Peaceful', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'false', 'DEFAULT', 'true', 'false', 'world', '', 0, 0, 'true', 0, 0, 1, 0),
413(68, 'sdsadasd', 2, 'lVzQrIsCrJZOTZ6pFotE', 512, '70', 1, NULL, '2020-06-28 15:17:15', 'craftbukkit_1.7.10', 'sdsadasd', 23422, '2020-05-28 15:17:15', 16, '10', 'true', 'true', '6', 'Survival', 'Peaceful', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'true', 'DEFAULT', 'true', 'true', 'world', '5fq9o', 23432, 23422, 'true', 0, 0, 0, 0),
414(69, 'KOKOTLE', 2, 'zzNUdK5FlKu8swZPIUUi', 1024, '120', 1, NULL, '2020-06-28 15:27:45', 'craftbukkit_1.7.10', 'KOKOTLE', 20789, '2020-05-28 15:27:45', 16, '10', 'true', 'true', '10', 'Survival', 'Peaceful', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'true', 'DEFAULT', 'true', 'true', 'world', 'xwr7w', 20799, 20789, 'true', 0, 0, 1, 0),
415(70, 'gtroup', 2, 's3frFBFtiGGPVNCVj1XB', 512, '70', 1, NULL, '2020-06-28 15:34:02', 'craftbukkit_1.7.10', 'gtroup', 27880, '2020-05-28 15:34:02', 16, '10', 'true', 'true', '20', 'Survival', 'Peaceful', 'true', 'true', '', 'false', 'false', 'true', 'true', 'true', 127, 'k1.czech-host.cz', '', 'true', 'DEFAULT', 'true', 'true', 'world', 'v8vda', 27890, 27880, 'true', 0, 0, 1, 0),
416(71, '111111', 2, '36lPIiIqzA4qua34xVv6', 512, '70', 1, '2020-05-28 16:06:11', '2020-10-28 15:48:56', 'cm_1.5.2', '111111', 29135, '2020-05-28 15:48:56', 16, '10', 'true', 'false', '11', 'Survival', 'Peaceful', 'true', 'false', '', 'false', 'false', 'false', 'false', 'false', 127, 'k1.czech-host.cz', '', 'true', 'DEFAULT', 'false', 'true', 'world', 'kqjmo', 29145, 29135, 'false', 0, 0, 1, 0);
417
418DROP TABLE IF EXISTS `news`;
419CREATE TABLE `news` (
420 `id` int(11) NOT NULL AUTO_INCREMENT,
421 `public` datetime NOT NULL,
422 `text` text NOT NULL,
423 `autor` text NOT NULL,
424 PRIMARY KEY (`id`)
425) ENGINE=InnoDB DEFAULT CHARSET=latin1;
426
427INSERT INTO `news` (`id`, `public`, `text`, `autor`) VALUES
428(23, '2015-04-15 21:55:20', 'pica', 'admin');
429
430DROP TABLE IF EXISTS `payments`;
431CREATE TABLE `payments` (
432 `id` int(11) NOT NULL AUTO_INCREMENT,
433 `invoice_id` int(11) DEFAULT NULL,
434 `name` varchar(255) DEFAULT NULL,
435 `email` varchar(255) DEFAULT NULL,
436 `address` varchar(255) DEFAULT NULL,
437 `city` varchar(255) DEFAULT NULL,
438 `state` varchar(255) DEFAULT NULL,
439 `zip` varchar(255) DEFAULT NULL,
440 `country` varchar(255) DEFAULT NULL,
441 `amount` decimal(8,2) DEFAULT NULL,
442 `description` varchar(255) DEFAULT NULL,
443 `type` varchar(255) DEFAULT NULL,
444 `paypal_transaction_id` varchar(255) DEFAULT NULL,
445 `date_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
446 PRIMARY KEY (`id`)
447) ENGINE=InnoDB DEFAULT CHARSET=latin1;
448
449
450DROP TABLE IF EXISTS `sections`;
451CREATE TABLE `sections` (
452 `id` int(11) NOT NULL AUTO_INCREMENT,
453 `name` text NOT NULL,
454 PRIMARY KEY (`id`)
455) ENGINE=InnoDB DEFAULT CHARSET=utf8;
456
457INSERT INTO `sections` (`id`, `name`) VALUES
458(1, 'Minecraft'),
459(2, 'SA:MP'),
460(3, 'CS 1.6'),
461(4, 'CS:GO');
462
463DROP TABLE IF EXISTS `subscriptions`;
464CREATE TABLE `subscriptions` (
465 `id` int(11) NOT NULL AUTO_INCREMENT,
466 `unique_id` varchar(255) DEFAULT NULL,
467 `paypal_subscription_id` varchar(255) DEFAULT NULL,
468 `name` varchar(255) DEFAULT NULL,
469 `email` varchar(255) DEFAULT NULL,
470 `address` varchar(255) DEFAULT NULL,
471 `city` varchar(255) DEFAULT NULL,
472 `state` varchar(255) DEFAULT NULL,
473 `zip` varchar(255) DEFAULT NULL,
474 `country` varchar(255) DEFAULT NULL,
475 `description` varchar(255) DEFAULT NULL,
476 `price` decimal(8,2) DEFAULT NULL,
477 `billing_day` int(2) DEFAULT NULL,
478 `length` int(4) DEFAULT NULL,
479 `interval` int(4) DEFAULT NULL,
480 `trial_days` int(4) DEFAULT NULL,
481 `status` varchar(255) DEFAULT NULL,
482 `date_trial_ends` date DEFAULT NULL,
483 `date_canceled` datetime DEFAULT NULL,
484 `date_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
485 PRIMARY KEY (`id`)
486) ENGINE=InnoDB DEFAULT CHARSET=latin1;
487
488
489DROP TABLE IF EXISTS `tickets`;
490CREATE TABLE `tickets` (
491 `id` int(11) NOT NULL AUTO_INCREMENT,
492 `user_id` text NOT NULL,
493 `user_email` text NOT NULL,
494 `date_create` datetime NOT NULL,
495 `section_id` float NOT NULL,
496 `helpdesk` text NOT NULL,
497 `status` float NOT NULL,
498 PRIMARY KEY (`id`)
499) ENGINE=InnoDB DEFAULT CHARSET=utf8;
500
501INSERT INTO `tickets` (`id`, `user_id`, `user_email`, `date_create`, `section_id`, `helpdesk`, `status`) VALUES
502(2, '2', 'asdasd@seznam.cz', '2020-05-28 06:00:09', 1, 'LuKyN94', 3),
503(3, '2', 'cabomm@seznam.cz', '2020-05-28 08:45:58', 1, 'admin', 3);
504
505DROP TABLE IF EXISTS `tickets_respond`;
506CREATE TABLE `tickets_respond` (
507 `id` int(11) NOT NULL AUTO_INCREMENT,
508 `user_id` int(11) NOT NULL,
509 `ticket_id` int(11) NOT NULL,
510 `date_create` datetime NOT NULL,
511 `comments` text NOT NULL,
512 PRIMARY KEY (`id`),
513 KEY `user_id` (`user_id`),
514 KEY `ticket_id` (`ticket_id`),
515 CONSTRAINT `tickets_respond_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `as_users` (`user_id`),
516 CONSTRAINT `tickets_respond_ibfk_2` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`id`)
517) ENGINE=InnoDB DEFAULT CHARSET=utf8;
518
519INSERT INTO `tickets_respond` (`id`, `user_id`, `ticket_id`, `date_create`, `comments`) VALUES
520(1, 2, 2, '2020-05-28 06:00:24', 'ccc'),
521(2, 2, 2, '2020-05-28 06:30:26', 'g'),
522(3, 2, 3, '2020-05-28 08:45:59', 'testicek\r\n');
523
524DROP TABLE IF EXISTS `webhosting`;
525CREATE TABLE `webhosting` (
526 `id` int(11) NOT NULL AUTO_INCREMENT,
527 `user_id` int(11) NOT NULL,
528 `price` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
529 `domain` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
530 `date_expiration` datetime NOT NULL,
531 `date_create` datetime NOT NULL,
532 PRIMARY KEY (`id`),
533 KEY `user_id` (`user_id`),
534 CONSTRAINT `webhosting_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `as_users` (`user_id`)
535) ENGINE=InnoDB DEFAULT CHARSET=latin1;
536
537INSERT INTO `webhosting` (`id`, `user_id`, `price`, `domain`, `date_expiration`, `date_create`) VALUES
538(21, 2, '100', 'cabomm.cz', '2015-04-13 20:28:42', '2015-03-13 20:28:42'),
539(22, 2, '100', 'mrkdak.cz', '2015-04-13 20:30:44', '2015-03-13 20:30:44'),
540(23, 2, '100', 'jajim.cz', '2015-04-13 20:31:59', '2015-03-13 20:31:59'),
541(24, 2, '100', 'mrkdop.cz', '2015-04-13 20:32:46', '2015-03-13 20:32:46'),
542(25, 2, '100', 'domena.czech-host.cz', '2015-04-13 20:33:48', '2015-03-13 20:33:48'),
543(26, 2, '100', 'test.cz', '2015-04-13 20:37:12', '2015-03-13 20:37:12'),
544(27, 2, '100', 'hovno.cz', '2015-04-13 20:39:17', '2015-03-13 20:39:17'),
545(28, 2, '100', 'hovno.cz', '2015-04-13 20:39:51', '2015-03-13 20:39:51'),
546(29, 2, '100', 'hovno.cz', '2015-04-13 20:40:39', '2015-03-13 20:40:39'),
547(30, 2, '100', 'kunda.cz', '2015-04-13 20:41:19', '2015-03-13 20:41:19'),
548(31, 2, '100', 'blee.cz', '2015-04-13 20:45:40', '2015-03-13 20:45:40'),
549(32, 2, '100', 'mrkda.cmt', '2015-04-13 20:47:38', '2015-03-13 20:47:38'),
550(33, 2, '100', 'aS', '2015-04-13 20:49:01', '2015-03-13 20:49:01'),
551(34, 2, '100', 'pickasdasdsad', '2015-04-13 20:49:50', '2015-03-13 20:49:50'),
552(35, 2, '100', 'more.ct', '2015-04-13 20:54:19', '2015-03-13 20:54:19'),
553(36, 2, '100', 'fsfsdf', '2015-04-13 21:00:33', '2015-03-13 21:00:33'),
554(37, 2, '100', 'fsfsdf', '2015-04-13 21:02:32', '2015-03-13 21:02:32'),
555(38, 2, '100', 'anddda', '2015-04-13 21:07:43', '2015-03-13 21:07:43'),
556(39, 2, '100', 'mrdksad.cz', '2015-04-13 21:09:45', '2015-03-13 21:09:45'),
557(40, 2, '100', 'lolk.cz', '2015-04-13 21:10:58', '2015-03-13 21:10:58'),
558(41, 2, '100', 'lolk.cz', '2015-04-13 21:13:27', '2015-03-13 21:13:27'),
559(42, 2, '100', 'cabommek.eu', '2015-04-13 21:15:07', '2015-03-13 21:15:07'),
560(43, 2, '100', 'gtrt.cz', '2015-04-13 21:18:28', '2015-03-13 21:18:28'),
561(44, 2, '100', 'sdsadsad.cz', '2015-04-13 21:18:54', '2015-03-13 21:18:54'),
562(45, 2, '100', 'cabommek.cz', '2015-04-13 21:20:17', '2015-03-13 21:20:17'),
563(46, 2, '100', 'pickraft.czu', '2015-04-13 21:22:09', '2015-03-13 21:22:09'),
564(47, 2, '100', 'kokotleo.cz', '2015-04-13 21:23:07', '2015-03-13 21:23:07'),
565(48, 2, '100', 'mrkd.acz', '2015-04-13 21:24:04', '2015-03-13 21:24:04'),
566(49, 2, '100', 'mrkasd.ct', '2015-04-13 21:27:41', '2015-03-13 21:27:41'),
567(50, 2, '100', 'pica.czsad', '2015-04-13 21:35:18', '2015-03-13 21:35:18'),
568(51, 2, '100', 'zemanjecurak..cz', '2015-04-13 21:43:32', '2015-03-13 21:43:32');
569
570-- 2020-05-28 17:41:26