INSERT INTO `pocitadlo` VALUES (12974,'68.180.230.101','2016-02-09 17:56:03','2016-02-09','02',1455036963,'06'),(12975,'140.117.150.103','2016-02-09 19:34:00','2016-02-09','02',1455042840,'06'),(12976,'89.239.24.160','2016-02-09 19:38:45','2016-02-09','02',1455043125,'06'),(12977,'51.255.65.3','2016-02-09 19:42:26','2016-02-09','02',1455043346,'06'),(12978,'81.30.243.170','2016-02-09 20:06:54','2016-02-09','02',1455044814,'06'),(12979,'2a02:598:7000:116::1','2016-02-09 22:51:12','2016-02-09','02',1455054672,'06'),(12980,'68.180.230.101','2016-02-09 23:11:00','2016-02-09','02',1455055860,'06'),(12981,'133.130.58.190','2016-02-10 01:37:47','2016-02-10','02',1455064834,'06'),(12982,'104.238.180.234','2016-02-10 01:38:22','2016-02-10','02',1455064702,'06'),(12983,'199.58.86.211','2016-02-10 01:43:45','2016-02-10','02',1455065025,'06'),(12984,'66.249.69.236','2016-02-10 01:58:21','2016-02-10','02',1455065901,'06'),(12985,'149.202.54.5','2016-02-10 03:53:51','2016-02-10','02',1455072831,'06'),(12986,'66.249.69.141','2016-02-10 04:05:05','2016-02-10','02',1455073505,'06'),(12987,'68.180.230.101','2016-02-10 04:09:21','2016-02-10','02',1455080737,'06'),(12988,'68.180.230.101','2016-02-10 05:37:38','2016-02-10','02',1455080737,'06'),(12989,'82.79.179.72','2016-02-10 05:39:08','2016-02-10','02',1455079148,'06'),(12990,'51.255.162.167','2016-02-10 05:52:54','2016-02-10','02',1455080195,'06'),(12991,'62.210.148.246','2016-02-10 07:14:15','2016-02-10','02',1455084862,'06'),(12992,'194.213.41.2','2016-02-10 07:27:11','2016-02-10','02',1455085631,'06'),(12993,'2620:101:4035:324:15','2016-02-10 07:29:34','2016-02-10','02',1455085774,'06'),(12994,'68.180.230.101','2016-02-10 07:50:12','2016-02-10','02',1455087012,'06'),(12995,'66.249.69.231','2016-02-10 08:40:38','2016-02-10','02',1455090038,'06'),(12996,'81.30.243.170','2016-02-10 08:48:12','2016-02-10','02',1455090492,'06'),(12997,'157.55.39.17','2016-02-10 11:09:26','2016-02-10','02',1455098966,'06'),(12998,'157.55.39.8','2016-02-10 11:12:43','2016-02-10','02',1455099163,'06'),(12999,'2a00:1028:8d1c:e16a:','2016-02-10 11:50:16','2016-02-10','02',1455101416,'06'),(13000,'66.249.69.147','2016-02-10 13:48:35','2016-02-10','02',1455108515,'06'),(13001,'85.207.10.74','2016-02-10 14:16:54','2016-02-10','02',1455110214,'06'),(13002,'68.180.230.101','2016-02-10 15:42:14','2016-02-10','02',1455115334,'06'),(13003,'66.249.69.236','2016-02-10 17:06:43','2016-02-10','02',1455120403,'06'),(13004,'46.135.238.251','2016-02-10 17:56:39','2016-02-10','02',1455123399,'06'),(13005,'88.100.243.239','2016-02-10 18:30:55','2016-02-10','02',1455125455,'06'),(13006,'66.249.66.67','2016-02-10 18:39:26','2016-02-10','02',1455125966,'06'),(13007,'37.221.241.241','2016-02-10 18:39:42','2016-02-10','02',1455125982,'06'),(13008,'89.239.24.160','2016-02-10 18:41:14','2016-02-10','02',1455126074,'06'),(13009,'188.166.28.116','2016-02-10 20:17:06','2016-02-10','02',1455131826,'06'),(13010,'37.221.241.241','2016-02-10 20:22:01','2016-02-10','02',1455132121,'06'),(13011,'108.196.244.17','2016-02-10 22:08:48','2016-02-10','02',1455138656,'06'),(13012,'68.180.230.101','2016-02-10 23:01:27','2016-02-10','02',1455141687,'06'),(13013,'68.180.230.101','2016-02-11 00:49:38','2016-02-11','02',1455191628,'06'),(13014,'91.194.84.106','2016-02-11 01:12:27','2016-02-11','02',1455149547,'06'),(13015,'66.249.66.109','2016-02-11 03:11:55','2016-02-11','02',1455156715,'06'),(13016,'62.210.148.246','2016-02-11 03:21:39','2016-02-11','02',1455157646,'06'),(13017,'188.244.47.194','2016-02-11 03:59:55','2016-02-11','02',1455159595,'06'),(13018,'2a02:598:a::79:11','2016-02-11 04:02:45','2016-02-11','02',1455159765,'06'),(13019,'174.34.135.242','2016-02-11 04:10:47','2016-02-11','02',1455160247,'06'),(13020,'2a02:598:a::78:165','2016-02-11 05:06:21','2016-02-11','02',1455163581,'06'),(13021,'68.180.230.101','2016-02-11 07:07:53','2016-02-11','02',1455191628,'06'),(13022,'194.213.41.2','2016-02-11 07:28:38','2016-02-11','02',1455172118,'06'),(13023,'2620:101:4036:321:15','2016-02-11 07:30:25','2016-02-11','02',1455172225,'06'),(13024,'81.30.243.170','2016-02-11 09:30:27','2016-02-11','02',1455179427,'06'),(13025,'2a02:598:a::78:166','2016-02-11 11:01:43','2016-02-11','02',1455184903,'06'),(13026,'68.180.230.101','2016-02-11 12:06:49','2016-02-11','02',1455191628,'06'),(13027,'136.243.103.165','2016-02-11 13:12:12','2016-02-11','02',1455192748,'06'),(13028,'213.180.45.254','2016-02-11 13:40:16','2016-02-11','02',1455194416,'06'),(13029,'62.77.65.64','2016-02-11 13:42:16','2016-02-11','02',1455194536,'06'),(13030,'193.179.220.250','2016-02-11 14:18:11','2016-02-11','02',1455196691,'06'),(13031,'69.58.178.59','2016-02-11 14:31:27','2016-02-11','02',1455197487,'06'),(13032,'62.210.97.48','2016-02-11 15:43:38','2016-02-11','02',1455201862,'06'),(13033,'37.188.135.72','2016-02-11 16:06:23','2016-02-11','02',1455203183,'06'),(13034,'66.249.66.70','2016-02-11 16:32:42','2016-02-11','02',1455204762,'06'),(13035,'5.9.94.207','2016-02-11 18:11:23','2016-02-11','02',1455210683,'06'),(13036,'69.30.218.190','2016-02-11 18:14:54','2016-02-11','02',1455210903,'06'),(13037,'90.182.206.228','2016-02-11 18:20:13','2016-02-11','02',1455211213,'06'),(13038,'89.239.24.160','2016-02-11 18:39:42','2016-02-11','02',1455212382,'06'),(13039,'37.221.241.241','2016-02-11 19:04:26','2016-02-11','02',1455213866,'06'),(13040,'69.30.198.186','2016-02-11 19:04:27','2016-02-11','02',1455213967,'06'),(13041,'109.81.211.44','2016-02-11 19:44:16','2016-02-11','02',1455216256,'06'),(13042,'68.180.230.101','2016-02-11 20:23:16','2016-02-11','02',1455218596,'06'),(13043,'195.154.187.115','2016-02-11 20:25:53','2016-02-11','02',1455218777,'06'),(13044,'180.76.15.155','2016-02-11 20:44:27','2016-02-11','02',1455219867,'06'),(13045,'46.227.171.253','2016-02-11 21:37:18','2016-02-11','02',1455223038,'06'),(13046,'199.19.249.196','2016-02-11 21:45:26','2016-02-11','02',1455223526,'06'),(13047,'62.200.229.135','2016-02-11 21:45:26','2016-02-11','02',1455223528,'06'),(13048,'94.23.19.178','2016-02-11 22:25:43','2016-02-11','02',1455226072,'06'),(13049,'192.99.107.230','2016-02-11 22:28:04','2016-02-11','02',1455226084,'06'),(13050,'180.76.15.20','2016-02-11 22:40:48','2016-02-11','02',1455226848,'06'),(13051,'68.180.230.101','2016-02-11 23:35:17','2016-02-11','02',1455230117,'06'),(13052,'46.229.170.197','2016-02-12 02:17:05','2016-02-12','02',1455239825,'06'),(13053,'68.180.230.101','2016-02-12 03:04:00','2016-02-12','02',1455242640,'06'),(13054,'157.55.39.191','2016-02-12 04:05:51','2016-02-12','02',1455246352,'06'),(13055,'66.249.66.70','2016-02-12 05:27:20','2016-02-12','02',1455251240,'06'),(13056,'91.121.211.59','2016-02-12 05:28:59','2016-02-12','02',1455251529,'06'),(13057,'5.9.111.70','2016-02-12 05:38:56','2016-02-12','02',1455252015,'06'),(13058,'37.221.241.241','2016-02-12 06:11:19','2016-02-12','02',1455253879,'06'),(13059,'194.213.41.2','2016-02-12 06:53:42','2016-02-12','02',1455256422,'06'),(13060,'2620:101:4035:324:15','2016-02-12 06:55:32','2016-02-12','02',1455256532,'06'),(13061,'17.138.55.217','2016-02-12 07:36:45','2016-02-12','02',1455259822,'06'),(13062,'62.77.65.64','2016-02-12 07:39:26','2016-02-12','02',1455259166,'06'),(13063,'79.250.22.92','2016-02-12 08:39:42','2016-02-12','02',1455262843,'06'),(13064,'68.180.230.101','2016-02-12 12:18:51','2016-02-12','02',1455275931,'06'),(13065,'91.121.112.142','2016-02-12 12:33:32','2016-02-12','02',1455276812,'06'),(13066,'37.188.129.126','2016-02-12 12:54:28','2016-02-12','02',1455278068,'06'),(13067,'94.112.186.63','2016-02-12 13:04:54','2016-02-12','02',1455278694,'06'),(13068,'68.180.230.101','2016-02-12 14:33:02','2016-02-12','02',1455283982,'06'),(13069,'90.182.124.72','2016-02-12 15:10:23','2016-02-12','02',1455286223,'06'),(13070,'68.180.230.101','2016-02-12 16:12:58','2016-02-12','02',1455289978,'06'),(13071,'192.88.212.69','2016-02-12 16:22:54','2016-02-12','02',1455290574,'06'),(13072,'90.177.195.3','2016-02-12 17:24:22','2016-02-12','02',1455294262,'06'),(13073,'89.239.24.160','2016-02-12 18:37:07','2016-02-12','02',1455298627,'06'),(13074,'136.243.5.215','2016-02-12 19:22:59','2016-02-12','02',1455301443,'06'),(13075,'89.163.148.58','2016-02-12 19:57:46','2016-02-12','02',1455303536,'06'),(13076,'2620:101:2005:10d4:1','2016-02-12 20:32:40','2016-02-12','02',1455305560,'06'),(13077,'188.165.200.217','2016-02-12 21:46:11','2016-02-12','02',1455309971,'06'),(13078,'180.76.15.145','2016-02-13 04:06:44','2016-02-13','02',1455332804,'06'),(13079,'180.76.15.7','2016-02-13 06:38:31','2016-02-13','02',1455341911,'06'),(13080,'136.243.152.18','2016-02-13 10:56:25','2016-02-13','02',1455357397,'06'),(13081,'51.254.131.246','2016-02-13 11:04:35','2016-02-13','02',1455357914,'06'),(13082,'68.180.230.101','2016-02-13 11:27:52','2016-02-13','02',1455359272,'06'),(13083,'213.192.19.42','2016-02-13 11:38:52','2016-02-13','02',1455359932,'06'),(13084,'81.30.243.170','2016-02-13 14:31:35','2016-02-13','02',1455370295,'06'),(13085,'46.118.155.216','2016-02-13 15:27:23','2016-02-13','02',1455373643,'06'),(13086,'144.76.7.107','2016-02-13 15:59:58','2016-02-13','02',1455375598,'06'),(13087,'37.221.241.241','2016-02-13 16:34:50','2016-02-13','02',1455377690,'06'),(13088,'212.83.177.193','2016-02-13 17:24:04','2016-02-13','02',1455380671,'06'),(13089,'89.239.24.160','2016-02-13 17:48:55','2016-02-13','02',1455382135,'06'),(13090,'51.255.162.165','2016-02-13 19:26:56','2016-02-13','02',1455388020,'06'),(13091,'149.202.54.5','2016-02-13 19:38:53','2016-02-13','02',1455388865,'06'),(13092,'37.48.42.74','2016-02-13 20:12:37','2016-02-13','02',1455390757,'06'),(13093,'78.156.49.6','2016-02-13 21:03:25','2016-02-13','02',1455393805,'06'),(13094,'163.172.13.244','2016-02-13 22:18:10','2016-02-13','02',1455398290,'06'),(13095,'45.32.131.61','2016-02-13 23:31:24','2016-02-13','02',1455402684,'06'),(13096,'188.75.140.38','2016-02-13 23:33:15','2016-02-13','02',1455402795,'06'),(13097,'94.22.47.242','2016-02-14 04:23:45','2016-02-14','02',1455420225,'06'),(13098,'92.236.71.145','2016-02-14 04:30:13','2016-02-14','02',1455420628,'06'),(13099,'140.117.150.103','2016-02-14 04:58:21','2016-02-14','02',1455422301,'06'),(13100,'82.76.87.154','2016-02-14 05:40:12','2016-02-14','02',1455431189,'06'),(13101,'207.46.13.123','2016-02-14 05:56:07','2016-02-14','02',1455425767,'06'),(13102,'82.76.87.154','2016-02-14 07:26:07','2016-02-14','02',1455431189,'06'),(13103,'31.30.32.93','2016-02-14 10:46:20','2016-02-14','02',1455443180,'06'),(13104,'2a03:2880:3010:6ff5:','2016-02-14 10:56:13','2016-02-14','02',1455443773,'06'),(13105,'37.221.241.241','2016-02-14 10:59:06','2016-02-14','02',1455443946,'06'),(13106,'46.227.171.253','2016-02-14 11:26:13','2016-02-14','02',1455445573,'06'),(13107,'207.46.13.123','2016-02-14 13:10:44','2016-02-14','02',1455451844,'06'),(13108,'68.180.230.101','2016-02-14 15:00:27','2016-02-14','02',1455458427,'06'),(13109,'85.216.133.77','2016-02-14 16:23:25','2016-02-14','02',1455463405,'06'),(13110,'89.239.24.160','2016-02-14 16:54:00','2016-02-14','02',1455465240,'06'),(13111,'68.180.230.101','2016-02-14 17:14:05','2016-02-14','02',1455466445,'06'),(13112,'69.30.213.18','2016-02-14 17:27:06','2016-02-14','02',1455467226,'06'),(13113,'213.192.12.20','2016-02-14 18:24:19','2016-02-14','02',1455470659,'06'),(13114,'81.30.243.170','2016-02-14 19:32:51','2016-02-14','02',1455474771,'06'),(13115,'136.243.103.165','2016-02-14 20:23:47','2016-02-14','02',1455478029,'06'),(13116,'37.221.241.241','2016-02-14 20:44:27','2016-02-14','02',1455479067,'06'),(13117,'68.180.230.101','2016-02-14 21:25:39','2016-02-14','02',1455481539,'06'),(13118,'81.30.243.170','2016-02-14 22:15:30','2016-02-14','02',1455484530,'06'),(13119,'68.180.230.101','2016-02-15 00:32:51','2016-02-15','02',1455564703,'06'),(13120,'68.180.230.101','2016-02-15 05:11:56','2016-02-15','02',1455564703,'07'),(13121,'46.118.155.216','2016-02-15 05:18:31','2016-02-15','02',1455509911,'07'),(13122,'92.236.71.145','2016-02-15 05:22:00','2016-02-15','02',1455510120,'07'),(13123,'69.197.177.50','2016-02-15 06:21:35','2016-02-15','02',1455513695,'07'),(13124,'194.213.41.2','2016-02-15 07:13:24','2016-02-15','02',1455554679,'07'),(13125,'2620:101:4035:325:15','2016-02-15 07:15:10','2016-02-15','02',1455516910,'07'),(13126,'37.188.224.65','2016-02-15 11:03:09','2016-02-15','02',1455530589,'07'),(13127,'81.30.243.170','2016-02-15 11:22:34','2016-02-15','02',1455531754,'07'),(13128,'83.69.45.34','2016-02-15 12:17:34','2016-02-15','02',1455535054,'07'),(13129,'37.188.137.153','2016-02-15 12:36:30','2016-02-15','02',1455536190,'07'),(13130,'68.180.230.101','2016-02-15 13:27:53','2016-02-15','02',1455564703,'07'),(13131,'162.210.196.130','2016-02-15 13:31:09','2016-02-15','02',1455539476,'07'),(13132,'178.255.215.82','2016-02-15 14:20:33','2016-02-15','02',1455542433,'07'),(13133,'194.213.41.2','2016-02-15 14:34:31','2016-02-15','02',1455554679,'07'),(13134,'2620:101:4035:325:15','2016-02-15 14:36:46','2016-02-15','02',1455543406,'07'),(13135,'157.55.39.172','2016-02-15 14:36:54','2016-02-15','02',1455543414,'07'),(13136,'2620:101:4036:321:15','2016-02-15 14:46:37','2016-02-15','02',1455543997,'07'),(13137,'78.250.94.69','2016-02-15 15:08:14','2016-02-15','02',1455545294,'07'),(13138,'194.213.41.2','2016-02-15 15:49:15','2016-02-15','02',1455554679,'07'),(13139,'77.234.45.149','2016-02-15 15:49:16','2016-02-15','02',1455547756,'07'),(13140,'2620:101:4036:321:15','2016-02-15 15:51:22','2016-02-15','02',1455547882,'07'),(13141,'2620:101:4036:321:15','2016-02-15 16:18:24','2016-02-15','02',1455549504,'07'),(13142,'180.76.15.145','2016-02-15 16:18:40','2016-02-15','02',1455549520,'07'),(13143,'2620:101:4037:3a03:1','2016-02-15 16:30:23','2016-02-15','02',1455550223,'07'),(13144,'51.254.121.184','2016-02-15 16:32:39','2016-02-15','02',1455550359,'07'),(13145,'194.213.41.2','2016-02-15 16:52:55','2016-02-15','02',1455554679,'07'),(13146,'2620:101:4036:321:15','2016-02-15 16:54:17','2016-02-15','02',1455551657,'07'),(13147,'2620:101:4035:325:15','2016-02-15 17:46:35','2016-02-15','02',1455554795,'07'),(13148,'89.239.24.160','2016-02-15 18:48:50','2016-02-15','02',1455558530,'07'),(13149,'88.86.108.64','2016-02-15 18:51:49','2016-02-15','02',1455558709,'07'),(13150,'194.213.41.2','2016-02-15 18:52:18','2016-02-15','02',1455558738,'07'),(13151,'2620:101:4036:321:15','2016-02-15 18:53:12','2016-02-15','02',1455558792,'07'),(13152,'2a00:1028:8d1d:a77a:','2016-02-15 19:04:23','2016-02-15','02',1455559463,'07'),(13153,'68.180.230.101','2016-02-15 20:20:50','2016-02-15','02',1455564703,'07'),(13154,'194.213.41.2','2016-02-15 20:23:50','2016-02-15','02',1455564230,'07'),(13155,'2620:101:4035:325:15','2016-02-15 20:25:23','2016-02-15','02',1455564323,'07'),(13156,'37.221.241.241','2016-02-15 20:46:00','2016-02-15','02',1455565560,'07'),(13157,'66.249.69.153','2016-02-15 21:24:18','2016-02-15','02',1455567858,'07'),(13158,'85.71.172.106','2016-02-15 21:47:07','2016-02-15','02',1455569227,'07'),(13159,'78.250.94.69','2016-02-15 22:21:41','2016-02-15','02',1455571301,'07'),(13160,'194.213.41.2','2016-02-15 22:27:12','2016-02-15','02',1455571632,'07'),(13161,'68.180.230.101','2016-02-15 22:47:24','2016-02-15','02',1455572844,'07'),(13162,'180.76.15.148','2016-02-15 22:48:30','2016-02-15','02',1455572910,'07'),(13163,'62.210.97.48','2016-02-15 23:24:19','2016-02-15','02',1455575059,'07'),(13164,'192.99.107.200','2016-02-16 00:06:16','2016-02-16','02',1455577576,'07'),(13165,'78.46.156.169','2016-02-16 00:06:45','2016-02-16','02',1455577605,'07'),(13166,'194.213.41.2','2016-02-16 01:10:21','2016-02-16','02',1455581421,'07'),(13167,'2620:101:4035:324:15','2016-02-16 01:11:36','2016-02-16','02',1455581496,'07'),(13168,'2a03:2880:2030:6ff7:','2016-02-16 01:29:41','2016-02-16','02',1455582581,'07'),(13169,'209.126.105.204','2016-02-16 02:05:06','2016-02-16','02',1455584706,'07'),(13170,'46.129.85.54','2016-02-16 03:02:11','2016-02-16','02',1455588131,'07'),(13171,'194.213.41.2','2016-02-16 04:49:12','2016-02-16','02',1455594552,'07'),(13172,'2620:101:4035:324:15','2016-02-16 04:50:25','2016-02-16','02',1455594625,'07'),(13173,'68.180.230.101','2016-02-16 05:01:03','2016-02-16','02',1455595263,'07'),(13174,'194.213.41.2','2016-02-16 07:00:54','2016-02-16','02',1455602454,'07'),(13175,'2620:101:4036:321:15','2016-02-16 07:02:23','2016-02-16','02',1455602543,'07'),(13176,'165.225.72.94','2016-02-16 07:03:59','2016-02-16','02',1455602639,'07'),(13177,'46.118.155.216','2016-02-16 07:39:16','2016-02-16','02',1455604756,'07'),(13178,'223.74.128.75','2016-02-16 08:21:35','2016-02-16','02',1455607296,'07'),(13179,'194.213.41.2','2016-02-16 08:44:00','2016-02-16','02',1455608640,'07'),(13180,'2620:101:4036:321:15','2016-02-16 08:45:26','2016-02-16','02',1455608726,'07'),(13181,'46.227.171.253','2016-02-16 09:24:19','2016-02-16','02',1455611059,'07'),(13182,'81.30.243.170','2016-02-16 10:20:56','2016-02-16','02',1455614456,'07'),(13183,'136.243.5.215','2016-02-16 10:33:04','2016-02-16','02',1455615184,'07'),(13184,'66.249.69.141','2016-02-16 11:12:43','2016-02-16','02',1455617563,'07'),(13185,'68.180.230.101','2016-02-16 11:20:54','2016-02-16','02',1455618054,'07'),(13186,'194.213.41.2','2016-02-16 11:41:12','2016-02-16','02',1455619272,'07'),(13187,'2620:101:4036:321:15','2016-02-16 11:42:11','2016-02-16','02',1455619331,'07'),(13188,'90.182.124.72','2016-02-16 11:55:03','2016-02-16','02',1455620103,'07'),(13189,'151.80.44.115','2016-02-16 11:58:10','2016-02-16','02',1455620290,'07'),(13190,'81.30.243.170','2016-02-16 13:31:54','2016-02-16','02',1455625914,'07'),(13191,'165.225.80.66','2016-02-16 14:53:30','2016-02-16','02',1455630810,'07'),(13192,'81.30.243.170','2016-02-16 16:55:10','2016-02-16','02',1455638110,'07'),(13193,'77.248.252.113','2016-02-16 18:12:26','2016-02-16','02',1455642758,'07'),(13194,'68.180.230.101','2016-02-16 18:21:59','2016-02-16','02',1455643319,'07'),(13195,'109.81.210.139','2016-02-16 19:20:11','2016-02-16','02',1455646829,'07'),(13196,'88.86.108.64','2016-02-16 19:21:39','2016-02-16','02',1455646899,'07'),(13197,'127.0.0.1','2016-02-16 19:25:36','2016-02-16','02',1455648612,'07'),(13198,'127.0.0.1','2016-03-21 19:58:44','2016-03-21','03',1458586724,'12'),(13199,'66.249.78.110','2016-03-31 22:00:34','2016-03-31','03',1459454434,'13'),(13200,'66.249.69.192','2016-04-12 20:32:28','2016-04-12','04',1460488048,'15'),(13201,'66.249.79.107','2016-04-12 21:07:16','2016-04-12','04',1460488036,'15'),(13202,'66.249.69.192','2016-04-13 17:32:33','2016-04-13','04',1460561553,'15'),(13203,'66.249.69.197','2016-04-13 17:41:44','2016-04-13','04',1460582353,'15'),(13204,'66.249.69.202','2016-04-13 18:55:54','2016-04-13','04',1460567474,'15'),(13205,'66.249.69.197','2016-04-13 19:48:24','2016-04-13','04',1460582353,'15'),(13206,'66.249.69.197','2016-04-13 22:23:11','2016-04-13','04',1460582353,'15'),(13207,'66.249.69.197','2016-04-13 23:25:25','2016-04-13','04',1460582725,'15'),(13208,'66.249.69.192','2016-04-13 23:50:24','2016-04-13','04',1460584224,'15'),(13209,'66.249.65.16','2016-04-14 23:25:26','2016-04-14','04',1460669126,'15'),(13210,'66.249.69.197','2016-04-15 16:44:41','2016-04-15','04',1460731481,'15'),(13211,'66.249.69.202','2016-04-15 17:23:20','2016-04-15','04',1460755918,'15'),(13212,'66.249.69.192','2016-04-15 18:06:57','2016-04-15','04',1460736797,'15'),(13213,'66.249.69.202','2016-04-15 22:36:26','2016-04-15','04',1460755918,'15'),(13214,'66.249.69.202','2016-04-15 23:50:28','2016-04-15','04',1460757028,'15'),(13215,'66.249.69.192','2016-04-15 23:56:38','2016-04-15','04',1460757398,'15'),(13216,'66.249.69.202','2016-04-16 09:23:04','2016-04-16','04',1460794894,'15'),(13217,'66.249.69.197','2016-04-16 10:00:05','2016-04-16','04',1460793605,'15'),(13218,'66.249.69.192','2016-04-16 10:16:04','2016-04-16','04',1460795084,'15'),(13219,'66.249.69.197','2016-04-16 12:13:10','2016-04-16','04',1460801590,'15'),(13220,'66.249.69.192','2016-04-16 12:25:26','2016-04-16','04',1460802326,'15'),(13221,'66.249.69.192','2016-04-17 10:41:36','2016-04-17','04',1460883662,'15'),(13222,'66.249.69.197','2016-04-17 12:10:23','2016-04-17','04',1460887823,'15'),(13223,'66.249.64.197','2016-04-17 20:53:34','2016-04-17','04',1460919214,'15'),(13224,'66.249.64.192','2016-04-17 21:18:15','2016-04-17','04',1460920695,'15'),(13225,'66.249.64.197','2016-04-17 22:41:55','2016-04-17','04',1460925715,'15'),(13226,'66.249.69.100','2016-04-19 22:49:35','2016-04-19','04',1461098975,'16'),(13227,'66.249.69.92','2016-04-19 23:22:57','2016-04-19','04',1461102966,'16'),(13228,'66.249.69.108','2016-04-20 18:54:15','2016-04-20','04',1461171255,'16'),(13229,'66.249.69.100','2016-04-20 19:38:03','2016-04-20','04',1461173883,'16'),(13230,'66.249.69.92','2016-04-20 21:06:13','2016-04-20','04',1461179173,'16'),(13231,'66.249.69.100','2016-04-20 21:49:57','2016-04-20','04',1461181797,'16'),(13232,'66.249.69.108','2016-04-20 22:33:42','2016-04-20','04',1461184422,'16'),(13233,'66.249.69.100','2016-04-20 23:03:10','2016-04-20','04',1461186190,'16'),(13234,'66.249.69.92','2016-04-22 19:29:37','2016-04-22','04',1461346556,'16'),(13235,'66.249.69.108','2016-04-22 19:32:44','2016-04-22','04',1461346364,'16'),(13236,'66.249.69.100','2016-04-22 23:38:04','2016-04-22','04',1461361084,'16'),(13237,'66.249.66.17','2016-04-24 00:05:57','2016-04-24','04',1461449157,'16'),(13238,'66.249.66.14','2016-04-24 13:30:02','2016-04-24','04',1461497402,'16'),(13239,'66.249.65.20','2016-05-01 01:59:50','2016-05-01','04',1462060790,'17'),(13240,'66.249.65.16','2016-05-12 19:42:42','2016-05-12','05',1463074962,'19'),(13241,'66.249.75.227','2016-05-19 17:30:57','2016-05-19','05',1463671857,'20'),(13242,'66.249.66.14','2016-05-24 23:39:14','2016-05-24','05',1464126017,'21'),(13243,'66.249.66.14','2016-05-25 23:16:31','2016-05-25','05',1464211223,'21'),(13244,'66.249.65.20','2016-05-26 17:32:52','2016-05-26','05',1464282041,'21'),(13245,'66.249.65.20','2016-05-26 18:43:07','2016-05-26','05',1464282041,'21'),(13246,'66.249.65.16','2016-05-26 21:56:17','2016-05-26','05',1464299476,'21'),(13247,'66.249.65.24','2016-05-26 22:13:50','2016-05-26','05',1464293630,'21'),(13248,'66.249.65.16','2016-05-26 23:41:52','2016-05-26','05',1464299476,'21'),(13249,'66.249.66.17','2016-05-28 09:56:27','2016-05-28','05',1464422193,'21'),(13250,'66.249.66.14','2016-05-28 09:56:39','2016-05-28','05',1464424524,'21'),(13251,'66.249.66.20','2016-05-28 10:32:25','2016-05-28','05',1464424345,'21'),(13252,'66.249.66.151','2016-06-01 18:18:36','2016-06-01','06',1464797916,'22');

--
-- Table structure for table `prihlaseni`
--

CREATE TABLE `prihlaseni` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) COLLATE utf8_czech_ci NOT NULL,
  `jmeno` varchar(32) COLLATE utf8_czech_ci NOT NULL,
  `heslo` varchar(32) COLLATE utf8_czech_ci NOT NULL,
  `datum_a_cas` datetime NOT NULL,
  `datum` date NOT NULL,
  `mesic` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  `cas` int(10) NOT NULL,
  `tyden` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=123 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `prihlaseni`
--

INSERT INTO `prihlaseni` VALUES (4,'37.188.130.190','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-06 10:48:12','2015-08-06','08',1438850892,'32'),(3,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-06 10:09:53','2015-08-06','08',1438848593,'32'),(5,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-06 14:21:03','2015-08-06','08',1438863663,'32'),(6,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-06 21:39:01','2015-08-06','08',1438889941,'32'),(7,'83.69.45.34','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-07 08:22:59','2015-08-07','08',1438928579,'32'),(8,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-07 10:31:32','2015-08-07','08',1438936292,'32'),(9,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-07 13:59:56','2015-08-07','08',1438948796,'32'),(10,'37.188.129.130','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-07 14:08:27','2015-08-07','08',1438949307,'32'),(11,'83.69.45.34','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-11 09:47:14','2015-08-11','08',1439279234,'33'),(12,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-15 18:43:52','2015-08-15','08',1439657032,'33'),(13,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-15 18:57:57','2015-08-15','08',1439657877,'33'),(14,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-15 21:08:42','2015-08-15','08',1439665722,'33'),(15,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-16 06:33:33','2015-08-16','08',1439699613,'33'),(16,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-16 07:48:09','2015-08-16','08',1439704089,'33'),(17,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-08-17 11:01:07','2015-08-17','08',1439802067,'34'),(18,'37.188.237.97','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-04 08:34:15','2015-09-04','09',1441348455,'36'),(19,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-04 13:04:25','2015-09-04','09',1441364665,'36'),(20,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-08 09:50:10','2015-09-08','09',1441698610,'37'),(21,'37.188.235.58','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-09 08:37:07','2015-09-09','09',1441780627,'37'),(22,'37.188.235.58','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-09 09:29:19','2015-09-09','09',1441783759,'37'),(23,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-10 21:09:52','2015-09-10','09',1441912192,'37'),(24,'64.79.75.50','7c2272859b0b5b1d02a0c3681062b080','c0e23fe04c67159021ed74af1c7153d8','2015-09-17 05:40:15','2015-09-17','09',1442461215,'38'),(25,'37.188.133.138','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-18 10:47:28','2015-09-18','09',1442566048,'38'),(26,'37.188.133.138','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-18 11:10:58','2015-09-18','09',1442567458,'38'),(27,'37.188.133.138','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-18 11:21:52','2015-09-18','09',1442568112,'38'),(28,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-18 14:03:44','2015-09-18','09',1442577824,'38'),(29,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-20 14:31:12','2015-09-20','09',1442752272,'38'),(30,'212.47.27.108','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-21 13:55:24','2015-09-21','09',1442836524,'39'),(31,'37.188.232.57','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-09-22 09:43:37','2015-09-22','09',1442907817,'39'),(32,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-07 22:11:05','2015-10-07','10',1444248665,'41'),(33,'83.69.45.34','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-08 14:21:53','2015-10-08','10',1444306913,'41'),(34,'37.188.135.200','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-09 12:29:39','2015-10-09','10',1444386579,'41'),(35,'212.47.27.108','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-12 10:21:30','2015-10-12','10',1444638090,'42'),(36,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-12 20:31:07','2015-10-12','10',1444674667,'42'),(37,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-17 12:30:28','2015-10-17','10',1445077828,'42'),(38,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-17 12:55:44','2015-10-17','10',1445079344,'42'),(39,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-17 13:31:14','2015-10-17','10',1445081474,'42'),(40,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-17 13:43:47','2015-10-17','10',1445082227,'42'),(41,'37.188.236.85','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-22 08:44:11','2015-10-22','10',1445496251,'43'),(42,'37.188.236.85','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-22 08:59:39','2015-10-22','10',1445497179,'43'),(43,'37.188.233.102','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-22 11:58:25','2015-10-22','10',1445507905,'43'),(44,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-25 21:30:13','2015-10-25','10',1445805013,'43'),(45,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-25 22:01:42','2015-10-25','10',1445806902,'43'),(46,'212.47.27.108','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-26 07:29:15','2015-10-26','10',1445840955,'44'),(47,'88.86.108.13','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-26 21:51:24','2015-10-26','10',1445892684,'44'),(48,'88.86.108.13','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-26 22:26:58','2015-10-26','10',1445894818,'44'),(49,'88.86.108.13','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-26 22:47:00','2015-10-26','10',1445896020,'44'),(50,'88.86.108.13','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-26 22:52:51','2015-10-26','10',1445896371,'44'),(51,'88.86.108.13','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-26 23:05:16','2015-10-26','10',1445897116,'44'),(52,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-27 15:21:34','2015-10-27','10',1445955694,'44'),(53,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-10-29 14:24:52','2015-10-29','10',1446125092,'44'),(54,'83.69.45.34','b52731d678f390e0323d1db83537164c','16274fb662691cb033a26ed19a5075f8','2015-11-05 13:23:42','2015-11-05','11',1446726222,'45'),(55,'83.69.45.34','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-11-05 13:24:14','2015-11-05','11',1446726254,'45'),(56,'83.69.45.34','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-11-05 13:42:48','2015-11-05','11',1446727368,'45'),(57,'2a00:1028:83c0:2d3a:','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-11-06 19:15:15','2015-11-06','11',1446833715,'45'),(58,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-11-14 18:01:53','2015-11-14','11',1447520513,'46'),(59,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-11-14 18:21:32','2015-11-14','11',1447521692,'46'),(60,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-11-14 18:45:35','2015-11-14','11',1447523135,'46'),(61,'84.3.7.235','7c2272859b0b5b1d02a0c3681062b080','c0e23fe04c67159021ed74af1c7153d8','2015-11-19 09:28:55','2015-11-19','11',1447921735,'47'),(62,'84.3.7.235','7c2272859b0b5b1d02a0c3681062b080','c0e23fe04c67159021ed74af1c7153d8','2015-11-19 09:30:03','2015-11-19','11',1447921803,'47'),(63,'84.3.7.235','7c2272859b0b5b1d02a0c3681062b080','c0e23fe04c67159021ed74af1c7153d8','2015-11-19 10:33:17','2015-11-19','11',1447925597,'47'),(64,'84.3.7.235','7c2272859b0b5b1d02a0c3681062b080','c0e23fe04c67159021ed74af1c7153d8','2015-11-19 10:34:20','2015-11-19','11',1447925660,'47'),(65,'83.69.45.34','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-11-23 07:54:04','2015-11-23','11',1448261644,'48'),(66,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-11-24 07:11:49','2015-11-24','11',1448345509,'48'),(67,'212.47.27.106','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-11-24 11:00:41','2015-11-24','11',1448359241,'48'),(68,'109.81.210.183','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-11-24 23:15:31','2015-11-24','11',1448403331,'48'),(69,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-11-28 21:16:59','2015-11-28','11',1448741819,'48'),(70,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-06 22:02:07','2015-12-06','12',1449435727,'49'),(71,'37.188.237.122','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-09 14:54:22','2015-12-09','12',1449669262,'50'),(72,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-17 14:55:16','2015-12-17','12',1450360516,'51'),(73,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-17 15:09:59','2015-12-17','12',1450361399,'51'),(74,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-17 16:33:15','2015-12-17','12',1450366395,'51'),(75,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-17 16:42:30','2015-12-17','12',1450366950,'51'),(76,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-17 16:55:23','2015-12-17','12',1450367723,'51'),(77,'88.86.108.13','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-17 17:41:23','2015-12-17','12',1450370483,'51'),(78,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-21 13:08:40','2015-12-21','12',1450699720,'52'),(79,'88.86.108.13','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-23 15:07:05','2015-12-23','12',1450879625,'52'),(80,'88.86.108.13','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-23 15:19:59','2015-12-23','12',1450880399,'52'),(81,'88.86.108.13','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-23 15:40:31','2015-12-23','12',1450881631,'52'),(82,'88.86.108.13','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-23 15:47:15','2015-12-23','12',1450882035,'52'),(83,'88.86.108.13','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-23 16:50:24','2015-12-23','12',1450885824,'52'),(84,'89.203.212.246','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-24 13:01:14','2015-12-24','12',1450958474,'52'),(85,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-24 15:34:52','2015-12-24','12',1450967692,'52'),(86,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-24 15:53:47','2015-12-24','12',1450968827,'52'),(87,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-26 07:49:26','2015-12-26','12',1451112566,'52'),(88,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-26 09:08:41','2015-12-26','12',1451117321,'52'),(89,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-26 09:18:15','2015-12-26','12',1451117895,'52'),(90,'88.86.108.64','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-26 16:12:19','2015-12-26','12',1451142739,'52'),(91,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-30 12:00:16','2015-12-30','12',1451473216,'53'),(92,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-30 12:04:25','2015-12-30','12',1451473465,'53'),(93,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2015-12-30 13:03:38','2015-12-30','12',1451477018,'53'),(94,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-10 19:37:37','2016-01-10','01',1452451057,'01'),(95,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-10 21:25:58','2016-01-10','01',1452457558,'01'),(96,'37.188.137.148','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-13 07:41:44','2016-01-13','01',1452667304,'02'),(97,'37.188.137.148','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-13 07:49:37','2016-01-13','01',1452667777,'02'),(98,'84.3.7.235','7c2272859b0b5b1d02a0c3681062b080','c0e23fe04c67159021ed74af1c7153d8','2016-01-15 05:12:38','2016-01-15','01',1452831158,'02'),(99,'84.3.7.235','7c2272859b0b5b1d02a0c3681062b080','c0e23fe04c67159021ed74af1c7153d8','2016-01-15 05:13:33','2016-01-15','01',1452831213,'02'),(100,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-16 08:36:41','2016-01-16','01',1452929801,'02'),(101,'84.3.7.235','7c2272859b0b5b1d02a0c3681062b080','c0e23fe04c67159021ed74af1c7153d8','2016-01-17 20:35:09','2016-01-17','01',1453059309,'02'),(102,'84.3.7.235','7c2272859b0b5b1d02a0c3681062b080','c0e23fe04c67159021ed74af1c7153d8','2016-01-17 20:36:21','2016-01-17','01',1453059381,'02'),(103,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-24 16:29:14','2016-01-24','01',1453649354,'03'),(104,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-24 17:10:16','2016-01-24','01',1453651816,'03'),(105,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-24 18:04:39','2016-01-24','01',1453655079,'03'),(106,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-24 18:37:57','2016-01-24','01',1453657077,'03'),(107,'37.188.136.246','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-25 13:01:04','2016-01-25','01',1453723264,'04'),(108,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-27 20:48:12','2016-01-27','01',1453924092,'04'),(109,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-27 21:28:23','2016-01-27','01',1453926503,'04'),(110,'37.188.141.245','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-28 08:03:34','2016-01-28','01',1453964614,'04'),(111,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-30 05:54:56','2016-01-30','01',1454129696,'04'),(112,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-01-30 19:24:13','2016-01-30','01',1454178253,'04'),(113,'37.221.241.241','7c2272859b0b5b1d02a0c3681062b080','c0e23fe04c67159021ed74af1c7153d8','2016-01-30 19:32:51','2016-01-30','01',1454178771,'04'),(114,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-02-02 20:39:26','2016-02-02','02',1454441966,'05'),(115,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-02-02 20:57:23','2016-02-02','02',1454443043,'05'),(116,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-02-03 21:08:18','2016-02-03','02',1454530098,'05'),(117,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-02-07 11:33:20','2016-02-07','02',1454841200,'05'),(118,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-02-08 18:43:45','2016-02-08','02',1454953425,'06'),(119,'83.69.45.34','b52731d678f390e0323d1db83537164c','16274fb662691cb033a26ed19a5075f8','2016-02-09 12:00:36','2016-02-09','02',1455015636,'06'),(120,'83.69.45.34','b52731d678f390e0323d1db83537164c','16274fb662691cb033a26ed19a5075f8','2016-02-09 12:01:02','2016-02-09','02',1455015662,'06'),(121,'83.69.45.34','494070c4e97dadfc2415f1f85df9d1b0','16274fb662691cb033a26ed19a5075f8','2016-02-09 12:01:16','2016-02-09','02',1455015676,'06'),(122,'37.221.241.241','14c3abf59b94d7a97205742c1c71ec0e','16274fb662691cb033a26ed19a5075f8','2016-02-10 20:22:40','2016-02-10','02',1455132160,'06');

--
-- Table structure for table `rap`
--

CREATE TABLE `rap` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nadpis` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `datum` varchar(75) COLLATE utf8_czech_ci NOT NULL,
  `obrazek` varchar(75) COLLATE utf8_czech_ci DEFAULT NULL,
  `zarovnani` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `sirka` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `vyska` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `odkaz` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `vypis` varchar(5) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `rap`
--

INSERT INTO `rap` VALUES (1,'2011','07.06.2011','logo_oficial_zaklad.jpg','vlevo','60','34','rok_2011','1'),(2,'2012','07.06.2012','logo_oficial_zaklad.jpg','vlevo','60','34','rok_2012','1'),(3,'2013','16.01.2013','logo_oficial_zaklad.jpg','vlevo','60','34','rok_2013','1'),(4,'2014','16.01.2015','logo_oficial_zaklad.jpg','vlevo','60','34','rok_2014','1');

--
-- Table structure for table `rozhovory`
--

CREATE TABLE `rozhovory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nadpis` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `datum` varchar(75) COLLATE utf8_czech_ci NOT NULL,
  `obrazek` varchar(75) COLLATE utf8_czech_ci DEFAULT NULL,
  `zarovnani` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `sirka` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `vyska` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `text` text COLLATE utf8_czech_ci,
  `obrazek2` varchar(75) COLLATE utf8_czech_ci DEFAULT NULL,
  `zarovnani2` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `sirka2` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `vyska2` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `text2` text COLLATE utf8_czech_ci,
  `odkaz` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `vypis` varchar(5) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `rozhovory`
--

INSERT INTO `rozhovory` VALUES (1,'Rozhovor s Jack Daniel','05.05.2012','','','','','','','','','','','Rozhovor_s_Jack_Daniel','1'),(2,'Rozhovor s Milanem Milatou, kapelníkem The Cell','18.03.2013','the-cell_15.jpg','center','510','337','','','','','','','Rozhovor_s_Milanem_Milatou,_kapelnikem_The_Cell','1'),(3,'Rozhovor s Thierry a Emmanuelem z Natchez','16.06.2013','01-rozhovor3.jpg','vpravo','257','176','Přinášíme vám rozhovor s bratry Thierry a Emmanuelem (řečený Manu) Aeschbachovými z francouzské kapely NATCHEZ, která o víkendu 17.-19.5.2013 odehrála u nás 3 koncerty. 17.5. V Praze v Baráčnické Rychtě společně s The Cell. 18.5. v Kolíně na festivalu Southern Rock &amp; Blues Kolín a 19.5. opět v Praze v klubu Vagón s mladoboleslavskými Full House. (píšeme o tom jinde). Starší z bratrů Thierry je hlavním zpěvákem Natchez a hraje na kytaru, Manu hraje sólovou kytaru a zpívá vokály. Dalšími členy kapely, kteří se však rozhovoru nezúčastnili jsou basák André Dufour a bubeník Benjamin Proy.\r\n\n\r\n\n<br><br>Rozhovor vedl Dališ za pomoci překladatelky Zuzky.\r\n\n','','','','','','Rozhovor_s_Thierry_a_Emmanuelem_z_Natchez','1');

--
-- Table structure for table `stanovy`
--

CREATE TABLE `stanovy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nadpis` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `datum` varchar(75) COLLATE utf8_czech_ci NOT NULL,
  `obrazek` varchar(75) COLLATE utf8_czech_ci DEFAULT NULL,
  `zarovnani` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `sirka` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `vyska` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `text` text COLLATE utf8_czech_ci,
  `obrazek2` varchar(75) COLLATE utf8_czech_ci DEFAULT NULL,
  `zarovnani2` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `sirka2` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `vyska2` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `text2` text COLLATE utf8_czech_ci,
  `odkaz` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `vypis` varchar(5) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `stanovy`
--

INSERT INTO `stanovy` VALUES (1,'Stanovy Dixie Spolku přátel jižanského rocku Bruntál','15.02.2013','pavel-hartl.jpg','center','90','95','Na to, jaké to bylo v dřevních dobách, které vedly k založení DIXIE Spolku přátel jižanského rocku Bruntál - tedy prvnímu oficiálnímu sdružení, které se systematicky zaměřilo na propagaci a podporu southern rocku a blízkých hudebních stylů - vzpomíná Pavel Hartl:','','','','','','Stanovy_Dixie_Spolku_pratel_jizanskeho_rocku_Bruntal','2');

--
-- Table structure for table `story`
--

CREATE TABLE `story` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nadpis` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `datum` varchar(75) COLLATE utf8_czech_ci NOT NULL,
  `obrazek` varchar(75) COLLATE utf8_czech_ci DEFAULT NULL,
  `zarovnani` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `sirka` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `vyska` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `text` text COLLATE utf8_czech_ci,
  `odkaz` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `vypis` varchar(5) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `story`
--

INSERT INTO `story` VALUES (1,'Příběh Lynyrd Skynyrd','16.02.2013','20051128-skynyrd.gif','center','401','254','Zde najdete příběh největší a nejzásadnější jižanské kapely všech dob - LYNYRD SKYNYRD','Pribeh_Lynyrd_Skynyrd','2'),(2,'Příběh Blackfoot','16.02.2013','blackfoot-logo.jpg','center','400','119','','Pribeh_Blackfoot','1'),(3,'Příběh Georgia Sattelites','17.02.2013','hippymaxi.jpg','center','464','458','','Pribeh_Georgia_Sattelites','1'),(4,'Omar &amp; The Howlers','17.02.2013','omar---the-howlers_053.jpg','center','427','282','','Omar_A;_The_Howlers','1');

--
-- Table structure for table `testing`
--

CREATE TABLE `testing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `odkaz01` varchar(125) COLLATE utf8_czech_ci DEFAULT NULL,
  `odkaz02` varchar(125) COLLATE utf8_czech_ci DEFAULT NULL,
  `odkaz03` varchar(125) COLLATE utf8_czech_ci DEFAULT NULL,
  `odkaz04` varchar(125) COLLATE utf8_czech_ci DEFAULT NULL,
  `odkaz05` varchar(125) COLLATE utf8_czech_ci DEFAULT NULL,
  `odkaz06` varchar(125) COLLATE utf8_czech_ci DEFAULT NULL,
  `odkaz07` varchar(125) COLLATE utf8_czech_ci DEFAULT NULL,
  `odkaz08` varchar(125) COLLATE utf8_czech_ci DEFAULT NULL,
  `odkaz09` varchar(125) COLLATE utf8_czech_ci DEFAULT NULL,
  `odkaz10` varchar(125) COLLATE utf8_czech_ci DEFAULT NULL,
  `odkaz11` varchar(125) COLLATE utf8_czech_ci DEFAULT NULL,
  `ulozto` varchar(3) COLLATE utf8_czech_ci DEFAULT NULL,
  `hellshare` varchar(3) COLLATE utf8_czech_ci DEFAULT NULL,
  `sdilej` varchar(3) COLLATE utf8_czech_ci DEFAULT NULL,
  `megarapid` varchar(3) COLLATE utf8_czech_ci DEFAULT NULL,
  `fastshare` varchar(3) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `testing`
--


--
-- Table structure for table `tiskoviny`
--

CREATE TABLE `tiskoviny` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nadpis` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `datum` varchar(75) COLLATE utf8_czech_ci NOT NULL,
  `obrazek` varchar(75) COLLATE utf8_czech_ci DEFAULT NULL,
  `zarovnani` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `sirka` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `vyska` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `text` text COLLATE utf8_czech_ci,
  `odkaz` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `vypis` varchar(5) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `tiskoviny`
--

INSERT INTO `tiskoviny` VALUES (1,'Koncert pro Salvátor','02.03.2013','','','','','Ve dnech 26. - 28.3.1993 uspořádal Joe \"Buxom\" Odstrčil, alias \"Kulatý\", nebo též \"Kulač\", pod hlavičkou vlastní agentury \"Southern Music Centrum\" a ve spolupráci s Městským kulturním a informačním centrem v Krnově, na svou dobu nevídaný koncert jižanských kapel ...<br><br>\r\n\nDetaily viz níže ...','Koncert_pro_Salvator','2');

--
-- Table structure for table `videa`
--

CREATE TABLE `videa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nazev` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `datum` varchar(75) COLLATE utf8_czech_ci NOT NULL,
  `info` text COLLATE utf8_czech_ci,
  `odkaz` varchar(75) COLLATE utf8_czech_ci DEFAULT NULL,
  `video01` varchar(45) COLLATE utf8_czech_ci DEFAULT NULL,
  `video02` varchar(45) COLLATE utf8_czech_ci DEFAULT NULL,
  `video03` varchar(45) COLLATE utf8_czech_ci DEFAULT NULL,
  `video04` varchar(45) COLLATE utf8_czech_ci DEFAULT NULL,
  `video05` varchar(45) COLLATE utf8_czech_ci DEFAULT NULL,
  `video06` varchar(45) COLLATE utf8_czech_ci DEFAULT NULL,
  `video07` varchar(45) COLLATE utf8_czech_ci DEFAULT NULL,
  `video08` varchar(45) COLLATE utf8_czech_ci DEFAULT NULL,
  `video09` varchar(45) COLLATE utf8_czech_ci DEFAULT NULL,
  `video10` varchar(45) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `videa`
--

INSERT INTO `videa` VALUES (1,'Hogjaw','06.05.2012','','Hogjaw','[youtube luv_Ei8waE8]','[youtube 82h2hyM4DTM]','[youtube wfAdqbO-L6k]','[youtube xz5su3nzLvU]','[youtube VfPAIpiWeBg]','','','','',''),(2,'Lynyrd Skynyrd','06.05.2012','','Lynyrd_Skynyrd','[youtube n-GapEyDFkA]','[youtube 5jHSUtThmcs]','[youtube abDFdnknGYs]','[youtube JzkHH3se7eQ]','','','','','',''),(3,'The Four Horsemen','06.05.2012','','The_Four_Horsemen','[youtube iKv_YYzdI2w]','[youtube eFtKFhUlpww]','[youtube ra84vHSj-ZM]','','','','','','',''),(4,'Gregg Allman','06.05.2012','','Gregg_Allman','[youtube BEP_dPN3Haw]','[youtube zCUxJFtTFNk]','[youtube yojZ-Ksr8AE]','[youtube VpNOoq0kFds]','','','','','',''),(6,'Dixie Hustler','06.05.2012','','Dixie_Hustler','[youtube dK8DzXMjqPA]','[youtube xfAsd-hA7jU]','[youtube 1zrOpGXTMJo]','','','','','','',''),(7,'Smokey Fingers','06.05.2012','','Smokey_Fingers','[youtube nAVdE5PLmbw]','[youtube iAfA1xEnG8w]','[youtube Uwv-q2lG22Y]','[youtube oWCN4GP2T40]','','','','','',''),(8,'Dirty York','06.05.2012','','Dirty_York','[youtube x4w0GYA0m_A]','[youtube p5aksj5tGVg]','[youtube QkVpM9rNhI]','[youtube Pagfi7mYG2M]','[youtube TSZ8w5CZvIw]','[youtube Z_WG0W535AI]','','','',''),(9,'Blue Rocket','07.05.2012','','Blue_Rocket','[youtube GIUqDW8B1os]','[youtube Dwq3igd0zd4]','[youtube 30adFkYqC-0]','[youtube Rw7LXRE5Z9g]','[youtube i61Wol8CCbM]','','','','',''),(10,'Black Berry Smoke ','08.05.2012','','Black_Berry_Smoke_','[youtube Tel7yXwtXI8]','[youtube YeFaX6lOGGk]','','','','','','','',''),(11,'NATCHEZ','15.10.2014','<div align=\"center\">NATCHEZ - jedna z předních jižanských kapel ve Francii.\r\n\n\r\n\n<br><br>Historicky první koncert v České republice odehrají na festivalu\r\n\n\r\n\n<br><br><a href=\"http://www.rockblueskolin.cz/\"><b>SOUTHERN ROCK &amp; BLUES KOLÍN 2013</b>\r\n\n\r\n\n<br></a><br>kam jste srdečně zváni.<br></div>','NATCHEZ','[youtube VLuKJ_gdsSg]','[youtube 2g74vkUa6NY]','[youtube OFq9lBHBs8s]','[youtube IZLK-pyPMg4]','','','','','','');

--
-- Table structure for table `zpravodaje`
--

CREATE TABLE `zpravodaje` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nadpis` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `datum` varchar(75) COLLATE utf8_czech_ci NOT NULL,
  `obrazek` varchar(75) COLLATE utf8_czech_ci DEFAULT NULL,
  `zarovnani` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `sirka` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `vyska` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `text` text COLLATE utf8_czech_ci,
  `odkaz` varchar(125) COLLATE utf8_czech_ci NOT NULL,
  `vypis` varchar(5) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Dumping data for table `zpravodaje`
--

INSERT INTO `zpravodaje` VALUES (1,'Informační zpravodaje','14.02.2013','','','','','&nbsp;&nbsp; V letech 1991 až 2003 vydal Dixie Spolek přátel jižanského rocku Bruntál, respektive jeho redakční rada, celkem 27 čísel \"zpravodajů\",nazvaných jednoduše \"Informace\" a doplněné pořadovým číslem. Od začátku byla snaha dát celému procesu jasnou strukturu, pravidla a periodicitu.\r\n\n V  podmínkách a v možnostech vydavatelů a redakční rady to byl téměř nadlidský a heroický výkon. Je pravda, že se zpočátku zapojilo i několik \"přespolních\" přispivatelů - hlavně těch anglicky hovořících, kteří pomáhali s překladem zahraničních textů. Postupem času ale příspěvků od externistů ubývalo a ubývalo taky času na přípravu, zpracování a vydávámí Informací. Doba mezi vydáním jednotlivých čísel se prodlužovala a z radosti se stala povinnost. S rozvojem techniky - hlavně internetu \r\n\npak nastala  doba, kdy si každý mohl sehnat jaké informace ze světa Southern rocku  chtěl a vydávání zpravodajů tak dospělo ke svému, trochu smutnému,  konci.<br><br>&nbsp;&nbsp;&nbsp;\r\n\nPřesto si dovolím touto formou všem, kteří se na vydávání Informaci podíleli moc a moc poděkovat za propagaci a podporu naší muziky. Věřím, že i díky tomu všemu je dnes český Jižanský rock tam, kde je a naše kapely se můžou směle poměřovat s ostatními v Evropě.','Informacni_zpravodaje','2');

--
-- Current Database: `mysql`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `mysql`;

--
-- Table structure for table `columns_priv`
--

CREATE TABLE `columns_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Column_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges';

--
-- Dumping data for table `columns_priv`
--


--
-- Table structure for table `db`
--

CREATE TABLE `db` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Host`,`Db`,`User`),
  KEY `User` (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges';

--
-- Dumping data for table `db`
--

INSERT INTO `db` VALUES ('localhost','phpmyadmin','phpmyadmin','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'),('localhost','dochazka','mikisek','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'),('localhost','herald-dixie','mikisek','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` char(64) NOT NULL DEFAULT '',
  `body` longblob NOT NULL,
  `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `execute_at` datetime DEFAULT NULL,
  `interval_value` int(11) DEFAULT NULL,
  `interval_field` enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','MICROSECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND','DAY_MICROSECOND','HOUR_MICROSECOND','MINUTE_MICROSECOND','SECOND_MICROSECOND') DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_executed` datetime DEFAULT NULL,
  `starts` datetime DEFAULT NULL,
  `ends` datetime DEFAULT NULL,
  `status` enum('ENABLED','DISABLED','SLAVESIDE_DISABLED') NOT NULL DEFAULT 'ENABLED',
  `on_completion` enum('DROP','PRESERVE') NOT NULL DEFAULT 'DROP',
  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
  `comment` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `originator` int(10) unsigned NOT NULL,
  `time_zone` char(64) CHARACTER SET latin1 NOT NULL DEFAULT 'SYSTEM',
  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `body_utf8` longblob,
  PRIMARY KEY (`db`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Events';

--
-- Table structure for table `func`
--

CREATE TABLE `func` (
  `name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `ret` tinyint(1) NOT NULL DEFAULT '0',
  `dl` char(128) COLLATE utf8_bin NOT NULL DEFAULT '',
  `type` enum('function','aggregate') CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions';

--
-- Dumping data for table `func`
--


--
-- Table structure for table `help_category`
--

CREATE TABLE `help_category` (
  `help_category_id` smallint(5) unsigned NOT NULL,
  `name` char(64) NOT NULL,
  `parent_category_id` smallint(5) unsigned DEFAULT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`help_category_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help categories';

--
-- Dumping data for table `help_category`
--

INSERT INTO `help_category` VALUES (1,'Geographic',0,''),(2,'Polygon properties',35,''),(3,'Numeric Functions',39,''),(4,'WKT',35,''),(5,'Plugins',36,''),(6,'Control flow functions',39,''),(7,'MBR',35,''),(8,'Transactions',36,''),(9,'Help Metadata',36,''),(10,'Account Management',36,''),(11,'Point properties',35,''),(12,'Encryption Functions',39,''),(13,'LineString properties',35,''),(14,'Miscellaneous Functions',39,''),(15,'Logical operators',39,''),(16,'Functions and Modifiers for Use with GROUP BY',36,''),(17,'Information Functions',39,''),(18,'Storage Engines',36,''),(19,'Bit Functions',39,''),(20,'Comparison operators',39,''),(21,'Table Maintenance',36,''),(22,'User-Defined Functions',36,''),(23,'Data Types',36,''),(24,'Compound Statements',36,''),(25,'Geometry constructors',35,''),(26,'GeometryCollection properties',1,''),(27,'Administration',36,''),(28,'Data Manipulation',36,''),(29,'Utility',36,''),(30,'Language Structure',36,''),(31,'Geometry relations',35,''),(32,'Date and Time Functions',39,''),(33,'WKB',35,''),(34,'Procedures',36,''),(35,'Geographic Features',36,''),(36,'Contents',0,''),(37,'Geometry properties',35,''),(38,'String Functions',39,''),(39,'Functions',36,''),(40,'Data Definition',36,'');

--
-- Table structure for table `help_keyword`
--

CREATE TABLE `help_keyword` (
  `help_keyword_id` int(10) unsigned NOT NULL,
  `name` char(64) NOT NULL,
  PRIMARY KEY (`help_keyword_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help keywords';

--
-- Dumping data for table `help_keyword`
--



--
-- Table structure for table `help_relation`
--

CREATE TABLE `help_relation` (
  `help_topic_id` int(10) unsigned NOT NULL,
  `help_keyword_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`help_keyword_id`,`help_topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='keyword-topic relation';

--
-- Dumping data for table `help_relation`
--

INSERT INTO `help_relation` VALUES (1,0),(356,0),(476,1),(450,2),(4,3),(5,4),(90,5),(90,6),(407,6),(98,7),(185,8),(431,9),(436,10),(146,11),(18,12),(107,12),(135,12),(346,12),(381,13),(123,14),(170,14),(425,14),(377,15),(83,16),(27,17),(105,18),(199,19),(37,20),(346,21),(471,21),(377,22),(32,23),(36,24),(238,24),(436,24),(37,25),(356,25),(471,26),(503,27),(41,28),(377,29),(361,30),(50,31),(471,31),(475,31),(1,32),(90,32),(407,32),(475,32),(176,33),(471,33),(53,34),(107,34),(1,35),(57,35),(194,35),(193,36),(199,36),(250,36),(210,37),(466,37),(356,38),(199,39),(194,40),(471,41),(450,42),(40,43),(230,43),(270,43),(90,44),(407,44),(377,45),(84,46),(105,46),(356,46),(475,46),(90,47),(407,47),(3,48),(105,48),(305,48),(356,48),(92,49),(130,50),(146,51),(436,51),(463,51),(100,52),(188,52),(422,53),(466,53),(402,54),(471,54),(29,55),(59,55),(86,55),(283,56),(346,56),(107,57),(314,57),(377,58),(110,59),(24,60),(89,60),(114,61),(174,61),(375,62),(462,62),(124,63),(125,64),(90,65),(126,65),(407,65),(499,65),(133,66),(230,66),(263,66),(377,66),(210,67),(466,67),(471,67),(90,68),(194,68),(210,68),(407,68),(471,68),(185,69),(185,70),(315,71),(199,72),(286,73),(199,74),(250,74),(466,75),(59,76),(86,76),(143,77),(144,78),(50,79),(123,79),(346,79),(356,79),(425,79),(458,79),(148,80),(1,81),(29,82),(471,83),(209,84),(180,85),(314,85),(346,85),(356,85),(421,85),(329,86),(346,86),(98,87),(180,88),(422,89),(98,90),(346,91),(422,91),(176,92),(177,93),(194,94),(416,94),(466,94),(481,94),(181,95),(131,96),(422,96),(187,97),(190,98),(50,99),(84,99),(356,99),(361,99),(466,99),(1,100),(50,100),(87,100),(253,101),(199,102),(250,102),(203,103),(213,104),(413,105),(466,106),(471,106),(475,106),(476,106),(102,107),(151,107),(305,107),(375,108),(462,108),(160,109),(346,109),(458,110),(375,111),(462,111),(230,112),(378,112),(471,113),(396,114),(240,115),(356,116),(422,117),(199,118),(245,119),(146,120),(250,121),(256,122),(422,123),(471,123),(356,124),(3,125),(37,125),(50,125),(84,125),(105,125),(131,125),(422,125),(199,126),(194,127),(155,128),(186,128),(212,128),(310,128),(346,128),(273,129),(280,130),(467,131),(426,132),(256,133),(469,133),(1,134),(7,135),(346,135),(259,136),(431,136),(49,137),(194,137),(226,137),(231,137),(356,137),(428,138),(287,139),(185,140),(293,141),(298,142),(476,143),(386,144),(131,145),(155,145),(212,145),(259,145),(332,145),(346,145),(356,145),(422,145),(431,145),(471,145),(375,146),(462,146),(65,147),(111,147),(116,147),(215,147),(277,147),(279,147),(321,147),(346,147),(402,147),(418,147),(466,147),(469,147),(471,147),(473,147),(31,148),(277,148),(471,148),(475,148),(185,149),(293,150),(311,151),(466,152),(89,153),(185,154),(356,155),(317,156),(421,157),(320,158),(247,159),(146,160),(151,161),(326,161),(17,162),(22,162),(49,162),(65,162),(78,162),(90,162),(98,162),(155,162),(194,162),(210,162),(211,162),(279,162),(303,162),(310,162),(346,162),(358,162),(394,162),(457,162),(471,162),(476,162),(256,163),(346,164),(454,164),(466,165),(379,166),(471,167),(108,168),(337,169),(418,170),(343,171),(259,172),(270,173),(39,174),(199,174),(250,174),(306,174),(356,174),(471,175),(326,176),(471,177),(29,178),(59,178),(86,178),(233,178),(327,178),(343,178),(436,178),(499,178),(377,179),(315,180),(107,181),(354,182),(359,183),(78,184),(131,184),(199,184),(362,185),(185,186),(182,187),(458,188),(377,189),(466,190),(25,191),(346,191),(375,192),(185,193),(377,194),(346,195),(379,195),(292,196),(346,196),(420,196),(382,197),(384,198),(387,199),(466,200),(199,201),(356,202),(89,203),(151,203),(176,203),(401,204),(131,205),(422,205),(54,206),(324,206),(404,207),(403,208),(199,209),(146,210),(450,210),(408,211),(24,212),(1,213),(471,214),(65,215),(159,215),(199,215),(212,215),(226,215),(234,215),(374,215),(407,215),(442,215),(466,215),(481,215),(1,216),(423,217),(346,218),(348,218),(422,219),(471,220),(426,221),(230,222),(468,222),(212,223),(418,223),(90,224),(377,224),(212,225),(199,226),(471,226),(475,226),(283,227),(450,228),(90,229),(129,230),(10,231),(346,231),(31,232),(277,232),(475,232),(450,233),(58,234),(85,235),(206,235),(369,235),(459,235),(85,236),(90,236),(155,236),(206,236),(313,236),(194,237),(481,237),(189,238),(326,239),(471,240),(146,241),(324,241),(436,241),(9,242),(29,242),(31,242),(90,242),(155,242),(186,242),(277,242),(301,242),(483,242),(131,243),(270,244),(78,245),(222,245),(330,245),(476,245),(314,246),(471,247),(356,248),(3,249),(105,249),(489,249),(37,250),(436,250),(155,251),(186,251),(212,251),(310,251),(346,251),(476,251),(85,252),(369,252),(475,252),(486,253),(485,254),(469,255),(422,256),(259,257),(494,258),(212,259),(471,259),(500,260),(504,261),(199,262),(375,263),(462,263),(209,264),(471,264),(201,265),(3,266),(131,266),(422,266),(233,267),(90,268),(90,269),(407,269),(21,270),(346,270),(422,270),(466,270),(471,270),(230,271),(89,272),(356,272),(98,273),(230,273),(503,273),(3,274),(105,274),(244,274),(375,274),(462,274),(178,275),(109,276),(9,277),(31,277),(35,277),(88,277),(186,277),(231,277),(238,277),(264,277),(277,277),(301,277),(330,277),(406,277),(416,277),(417,277),(466,277),(481,277),(356,278),(185,279),(199,280),(418,281),(466,281),(471,281),(21,282),(295,282),(346,282),(454,282),(471,282),(50,283),(78,283),(84,283),(131,283),(199,283),(356,283),(361,283),(422,283),(466,283),(471,283),(471,284),(475,284),(377,285),(212,286),(422,286),(471,286),(476,286),(466,287),(471,287),(98,288),(315,288),(356,289),(47,290),(185,291),(375,292),(462,292),(375,293),(462,293),(58,294),(199,295),(50,296),(84,296),(107,296),(375,297),(462,297),(90,298),(301,298),(358,298),(407,298),(1,299),(84,299),(105,299),(131,299),(356,299),(422,299),(466,299),(199,300),(68,301),(50,302),(418,302),(469,302),(230,303),(88,304),(210,304),(466,304),(386,305),(92,306),(1,307),(185,308),(466,308),(185,309),(270,309),(463,309),(79,310),(375,311),(462,311),(259,312),(471,313),(194,314),(377,315),(97,316),(17,317),(189,317),(303,317),(328,317),(346,317),(356,317),(417,317),(442,317),(491,317),(89,318),(103,319),(286,320),(105,321),(195,321),(302,321),(489,321),(71,322),(329,322),(434,322),(476,323),(108,324),(9,325),(31,325),(90,325),(155,325),(186,325),(277,325),(301,325),(346,326),(366,326),(146,327),(436,327),(463,327),(3,328),(105,328),(155,328),(200,328),(212,328),(244,328),(466,328),(471,328),(466,329),(116,330),(326,330),(469,330),(473,330),(116,331),(466,331),(375,332),(462,332),(39,333),(120,333),(151,333),(265,333),(420,334),(221,335),(3,336),(84,336),(105,336),(130,336),(131,336),(146,336),(155,336),(182,336),(212,336),(332,336),(346,336),(356,336),(375,336),(422,336),(462,336),(466,336),(471,336),(475,336),(480,336),(497,336),(199,337),(60,338),(138,338),(215,338),(223,338),(328,338),(335,338),(346,338),(366,338),(1,339),(425,340),(471,341),(54,342),(458,343),(256,344),(59,345),(86,345),(54,346),(324,346),(238,347),(199,348),(314,349),(37,350),(107,350),(436,350),(450,350),(377,351),(471,352),(35,353),(70,353),(98,353),(211,353),(234,353),(303,353),(335,353),(346,353),(394,353),(406,353),(417,353),(253,354),(65,355),(194,355),(466,355),(481,355),(466,356),(471,356),(471,357),(168,358),(178,359),(183,360),(31,361),(159,361),(457,361),(450,362),(198,363),(375,364),(462,364),(201,365),(24,366),(129,366),(168,366),(209,366),(230,366),(315,366),(503,366),(98,367),(156,367),(230,367),(346,368),(145,369),(346,369),(146,370),(436,370),(146,371),(436,371),(180,372),(200,372),(314,372),(421,372),(225,373),(305,374),(422,374),(356,375),(155,376),(212,376),(471,376),(468,377),(455,378),(130,379),(138,379),(182,379),(348,379),(450,379),(59,380),(86,380),(241,381),(1,382),(37,382),(356,382),(247,383),(192,384),(346,384),(1,385),(375,386),(462,386),(221,387),(89,388),(199,388),(210,388),(466,388),(471,388),(261,389),(466,390),(90,391),(407,391),(466,391),(292,392),(278,393),(98,394),(1,395),(65,395),(88,395),(102,395),(210,395),(305,395),(309,395),(346,395),(466,395),(471,395),(90,396),(407,396),(185,397),(466,398),(273,399),(88,400),(210,400),(466,400),(314,401),(24,402),(129,402),(168,402),(209,402),(315,402),(503,402),(199,403),(185,404),(185,405),(300,406),(185,407),(194,408),(346,408),(366,408),(416,408),(466,408),(471,408),(481,408),(471,409),(356,410),(306,411),(471,412),(256,413),(356,413),(361,413),(230,414),(316,414),(376,414),(89,415),(209,416),(70,417),(491,417),(325,418),(49,419),(194,419),(226,419),(231,419),(194,420),(235,421),(199,422),(90,423),(334,424),(436,425),(40,426),(270,426),(346,426),(471,427),(147,428),(466,429),(469,429),(340,430),(338,431),(3,432),(105,432),(321,433),(466,433),(7,434),(10,434),(17,434),(21,434),(25,434),(34,434),(40,434),(60,434),(70,434),(71,434),(83,434),(123,434),(135,434),(138,434),(145,434),(160,434),(170,434),(192,434),(193,434),(215,434),(223,434),(279,434),(283,434),(295,434),(309,434),(310,434),(328,434),(329,434),(332,434),(335,434),(346,434),(348,434),(358,434),(366,434),(394,434),(425,434),(454,434),(490,434),(491,434),(495,434),(123,435),(349,435),(147,436),(352,436),(377,437),(3,438),(105,438),(256,438),(302,438),(356,438),(160,439),(346,439),(476,440),(24,441),(112,441),(185,442),(131,443),(422,443),(119,444),(391,444),(374,445),(476,445),(199,446),(146,447),(436,447),(199,448),(89,449),(123,449),(356,449),(425,449),(356,450),(396,451),(87,452),(199,452),(398,453),(185,454),(9,455),(374,455),(476,455),(124,456),(185,457),(377,458),(377,459),(466,460),(144,461),(210,462),(466,462),(471,462),(111,463),(222,463),(407,463),(466,463),(413,464),(476,465),(1,466),(356,466),(428,467),(78,468),(199,468),(476,468),(480,468),(356,469),(107,470),(277,471),(497,472),(71,473),(346,473),(433,474),(356,475),(450,476),(437,477),(471,478),(146,479),(327,479),(436,479),(436,480),(490,481),(439,482),(418,483),(199,484),(377,485),(446,486),(109,487),(451,488),(455,489),(456,490),(462,491),(34,492),(463,493),(466,494),(107,495),(309,496),(346,496),(466,496),(467,497),(50,498),(84,498),(107,498),(123,498),(356,498),(425,498),(65,499),(105,499),(466,499),(471,499),(475,499),(233,500),(375,501),(462,501),(466,502),(473,502),(466,503),(471,503),(244,504),(471,504),(471,505),(475,505),(194,506),(481,506),(130,507),(138,507),(348,507),(450,507),(39,508),(54,508),(90,508),(145,508),(223,508),(324,508),(407,508),(356,509),(361,509),(90,510),(407,510),(466,510),(422,511),(0,512),(96,512),(289,512),(306,512),(356,512),(361,512),(385,512),(434,512),(37,513),(116,513),(131,513),(326,513),(422,513),(469,513),(473,513),(499,514),(199,515),(185,516),(199,517),(37,518),(135,518),(295,518),(346,518),(498,519),(28,520),(22,521),(264,521),(346,521),(105,522),(356,522),(346,523),(495,523),(210,524),(466,525),(107,526),(466,526),(471,526),(194,527),(481,527),(40,528),(60,528),(185,528),(265,528),(270,528),(471,529);

--
-- Table structure for table `help_topic`
--

CREATE TABLE `help_topic` (
  `help_topic_id` int(10) unsigned NOT NULL,
  `name` char(64) NOT NULL,
  `help_category_id` smallint(5) unsigned NOT NULL,
  `description` text NOT NULL,
  `example` text NOT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`help_topic_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help topics';

--
-- Dumping data for table `help_topic`
--



--
-- Table structure for table `host`
--

CREATE TABLE `host` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Host`,`Db`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Host privileges;  Merged with database privileges';

--
-- Dumping data for table `host`
--


--
-- Table structure for table `ndb_binlog_index`
--

CREATE TABLE `ndb_binlog_index` (
  `Position` bigint(20) unsigned NOT NULL,
  `File` varchar(255) NOT NULL,
  `epoch` bigint(20) unsigned NOT NULL,
  `inserts` bigint(20) unsigned NOT NULL,
  `updates` bigint(20) unsigned NOT NULL,
  `deletes` bigint(20) unsigned NOT NULL,
  `schemaops` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`epoch`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ndb_binlog_index`
--


--
-- Table structure for table `plugin`
--

CREATE TABLE `plugin` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `dl` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL plugins';

--
-- Dumping data for table `plugin`
--


--
-- Table structure for table `proc`
--

CREATE TABLE `proc` (
  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` char(64) NOT NULL DEFAULT '',
  `type` enum('FUNCTION','PROCEDURE') NOT NULL,
  `specific_name` char(64) NOT NULL DEFAULT '',
  `language` enum('SQL') NOT NULL DEFAULT 'SQL',
  `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
  `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
  `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
  `param_list` blob NOT NULL,
  `returns` longblob NOT NULL,
  `body` longblob NOT NULL,
  `definer` char(77) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH') NOT NULL DEFAULT '',
  `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `body_utf8` longblob,
  PRIMARY KEY (`db`,`name`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures';

--
-- Dumping data for table `proc`
--


--
-- Table structure for table `procs_priv`
--

CREATE TABLE `procs_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Routine_name` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges';

--
-- Dumping data for table `procs_priv`
--


--
-- Table structure for table `proxies_priv`
--

CREATE TABLE `proxies_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_user` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `With_grant` tinyint(1) NOT NULL DEFAULT '0',
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User proxy privileges';

--
-- Dumping data for table `proxies_priv`
--

INSERT INTO `proxies_priv` VALUES ('localhost','root','','',1,'','2016-02-08 21:40:25'),('zotac-zbox-id18','root','','',1,'','2016-02-08 21:40:25');

--
-- Table structure for table `servers`
--

CREATE TABLE `servers` (
  `Server_name` char(64) NOT NULL DEFAULT '',
  `Host` char(64) NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `Username` char(64) NOT NULL DEFAULT '',
  `Password` char(64) NOT NULL DEFAULT '',
  `Port` int(4) NOT NULL DEFAULT '0',
  `Socket` char(64) NOT NULL DEFAULT '',
  `Wrapper` char(64) NOT NULL DEFAULT '',
  `Owner` char(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';

--
-- Dumping data for table `servers`
--


--
-- Table structure for table `tables_priv`
--

CREATE TABLE `tables_priv` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Grantor` char(77) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
  KEY `Grantor` (`Grantor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges';

--
-- Dumping data for table `tables_priv`
--


--
-- Table structure for table `time_zone`
--

CREATE TABLE `time_zone` (
  `Time_zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Use_leap_seconds` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Time_zone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zones';

--
-- Dumping data for table `time_zone`
--


--
-- Table structure for table `time_zone_leap_second`
--

CREATE TABLE `time_zone_leap_second` (
  `Transition_time` bigint(20) NOT NULL,
  `Correction` int(11) NOT NULL,
  PRIMARY KEY (`Transition_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Leap seconds information for time zones';

--
-- Dumping data for table `time_zone_leap_second`
--


--
-- Table structure for table `time_zone_name`
--

CREATE TABLE `time_zone_name` (
  `Name` char(64) NOT NULL,
  `Time_zone_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone names';

--
-- Dumping data for table `time_zone_name`
--


--
-- Table structure for table `time_zone_transition`
--

CREATE TABLE `time_zone_transition` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_time` bigint(20) NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Time_zone_id`,`Transition_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transitions';

--
-- Dumping data for table `time_zone_transition`
--


--
-- Table structure for table `time_zone_transition_type`
--

CREATE TABLE `time_zone_transition_type` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  `Offset` int(11) NOT NULL DEFAULT '0',
  `Is_DST` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `Abbreviation` char(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transition types';

--
-- Dumping data for table `time_zone_transition_type`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Reload_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Process_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `File_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_db_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Super_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_user_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Event_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N',
  `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 NOT NULL DEFAULT '',
  `ssl_cipher` blob NOT NULL,
  `x509_issuer` blob NOT NULL,
  `x509_subject` blob NOT NULL,
  `max_questions` int(11) unsigned NOT NULL DEFAULT '0',
  `max_updates` int(11) unsigned NOT NULL DEFAULT '0',
  `max_connections` int(11) unsigned NOT NULL DEFAULT '0',
  `max_user_connections` int(11) unsigned NOT NULL DEFAULT '0',
  `plugin` char(64) COLLATE utf8_bin DEFAULT '',
  `authentication_string` text COLLATE utf8_bin,
  PRIMARY KEY (`Host`,`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges';

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES ('localhost','root','*C0AA6019626F5D0114AADB21B539BDC221F605CF','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''),('zotac-zbox-id18','root','*C0AA6019626F5D0114AADB21B539BDC221F605CF','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''),('127.0.0.1','root','*C0AA6019626F5D0114AADB21B539BDC221F605CF','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''),('::1','root','*C0AA6019626F5D0114AADB21B539BDC221F605CF','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',''),('localhost','debian-sys-maint','*883D0DDDACE354B476710CFD15E2D3601A003EFC','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'',NULL),('localhost','phpmyadmin','*8B9144F93E56DE210C8B8A216FEB36FA78FE84AF','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'',NULL),('localhost','mikisek','*C0AA6019626F5D0114AADB21B539BDC221F605CF','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'',NULL);

--
-- Table structure for table `general_log`
--

CREATE TABLE IF NOT EXISTS `general_log` (
  `event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_host` mediumtext NOT NULL,
  `thread_id` int(11) NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `command_type` varchar(64) NOT NULL,
  `argument` mediumtext NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log';

--
-- Table structure for table `slow_log`
--

CREATE TABLE IF NOT EXISTS `slow_log` (
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_host` mediumtext NOT NULL,
  `query_time` time NOT NULL,
  `lock_time` time NOT NULL,
  `rows_sent` int(11) NOT NULL,
  `rows_examined` int(11) NOT NULL,
  `db` varchar(512) NOT NULL,
  `last_insert_id` int(11) NOT NULL,
  `insert_id` int(11) NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `sql_text` mediumtext NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log';

--
-- Current Database: `phpmyadmin`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phpmyadmin` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `phpmyadmin`;

--
-- Table structure for table `pma_bookmark`
--

CREATE TABLE `pma_bookmark` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dbase` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `user` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `label` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `query` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Bookmarks';

--
-- Dumping data for table `pma_bookmark`
--


--
-- Table structure for table `pma_column_info`
--

CREATE TABLE `pma_column_info` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `column_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `comment` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `mimetype` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `transformation` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `transformation_options` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column information for phpMyAdmin';

--
-- Dumping data for table `pma_column_info`
--


--
-- Table structure for table `pma_designer_coords`
--

CREATE TABLE `pma_designer_coords` (
  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `x` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL,
  `v` tinyint(4) DEFAULT NULL,
  `h` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`db_name`,`table_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table coordinates for Designer';

--
-- Dumping data for table `pma_designer_coords`
--


--
-- Table structure for table `pma_history`
--

CREATE TABLE `pma_history` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `timevalue` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `sqlquery` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `username` (`username`,`db`,`table`,`timevalue`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='SQL history for phpMyAdmin';

--
-- Dumping data for table `pma_history`
--


--
-- Table structure for table `pma_pdf_pages`
--

CREATE TABLE `pma_pdf_pages` (
  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `page_nr` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `page_descr` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`page_nr`),
  KEY `db_name` (`db_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='PDF relation pages for phpMyAdmin';

--
-- Dumping data for table `pma_pdf_pages`
--


--
-- Table structure for table `pma_recent`
--

CREATE TABLE `pma_recent` (
  `username` varchar(64) COLLATE utf8_bin NOT NULL,
  `tables` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Recently accessed tables';

--
-- Dumping data for table `pma_recent`
--


--
-- Table structure for table `pma_relation`
--

CREATE TABLE `pma_relation` (
  `master_db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `master_table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `master_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `foreign_db` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `foreign_table` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `foreign_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`master_db`,`master_table`,`master_field`),
  KEY `foreign_field` (`foreign_db`,`foreign_table`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Relation table';

--
-- Dumping data for table `pma_relation`
--


--
-- Table structure for table `pma_table_coords`
--

CREATE TABLE `pma_table_coords` (
  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `pdf_page_number` int(11) NOT NULL DEFAULT '0',
  `x` float unsigned NOT NULL DEFAULT '0',
  `y` float unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table coordinates for phpMyAdmin PDF output';

--
-- Dumping data for table `pma_table_coords`
--


--
-- Table structure for table `pma_table_info`
--

CREATE TABLE `pma_table_info` (
  `db_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `table_name` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `display_field` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`db_name`,`table_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table information for phpMyAdmin';

--
-- Dumping data for table `pma_table_info`
--


--
-- Table structure for table `pma_table_uiprefs`
--

CREATE TABLE `pma_table_uiprefs` (
  `username` varchar(64) COLLATE utf8_bin NOT NULL,
  `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `prefs` text COLLATE utf8_bin NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`username`,`db_name`,`table_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Tables'' UI preferences';

--
-- Dumping data for table `pma_table_uiprefs`
--


--
-- Table structure for table `pma_tracking`
--

CREATE TABLE `pma_tracking` (
  `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
  `version` int(10) unsigned NOT NULL,
  `date_created` datetime NOT NULL,
  `date_updated` datetime NOT NULL,
  `schema_snapshot` text COLLATE utf8_bin NOT NULL,
  `schema_sql` text COLLATE utf8_bin,
  `data_sql` longtext COLLATE utf8_bin,
  `tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW') COLLATE utf8_bin DEFAULT NULL,
  `tracking_active` int(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`db_name`,`table_name`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT COMMENT='Database changes tracking for phpMyAdmin';

--
-- Dumping data for table `pma_tracking`
--


--
-- Table structure for table `pma_userconfig`
--

CREATE TABLE `pma_userconfig` (
  `username` varchar(64) COLLATE utf8_bin NOT NULL,
  `timevalue` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `config_data` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User preferences storage for phpMyAdmin';

--
-- Dumping data for table `pma_userconfig`
--



