# phpMyAdmin MySQL-Dump
# version 2.2.5
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: Jul 26, 2004 at 11:59 PM
# Server version: 4.00.15
# PHP Version: 4.3.1
# Database : `stat`
# --------------------------------------------------------

#
# Table structure for table `access`
#

CREATE TABLE access (
  id int(11) NOT NULL auto_increment,
  access_date datetime NOT NULL default '0000-00-00 00:00:00',
  visit int(11) NOT NULL default '0',
  browser int(11) NOT NULL default '0',
  brow_add_on int(11) NOT NULL default '0',
  os int(11) NOT NULL default '0',
  resolution int(11) NOT NULL default '0',
  colordepth int(11) NOT NULL default '0',
  referer int(11) NOT NULL default '0',
  path int(11) NOT NULL default '0',
  area int(11) NOT NULL default '0',
  ip varchar(25) NOT NULL default '',
  ip_name varchar(60) NOT NULL default '',
  domain int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `access`
#

# --------------------------------------------------------

#
# Table structure for table `browser`
#

CREATE TABLE browser (
  id int(11) NOT NULL default '0',
  name varchar(50) NOT NULL default '',
  browser_regexp varchar(70) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `browser`
#

INSERT INTO browser VALUES (0, 'Jiný, nezjištěno', '');
INSERT INTO browser VALUES (1, 'Opera 2', 'opera.2');
INSERT INTO browser VALUES (2, 'Opera 3', 'opera.3');
INSERT INTO browser VALUES (3, 'Opera 4', 'opera.4');
INSERT INTO browser VALUES (4, 'Opera 5', 'opera.5');
INSERT INTO browser VALUES (5, 'Opera 6', 'opera.6');
INSERT INTO browser VALUES (52, 'IE 1', 'msie.1');
INSERT INTO browser VALUES (53, 'IE 2', 'msie.2');
INSERT INTO browser VALUES (54, 'IE 3', 'msie.3');
INSERT INTO browser VALUES (55, 'IE 4', 'msie.4');
INSERT INTO browser VALUES (56, 'IE 5', 'msie.5\\.0');
INSERT INTO browser VALUES (57, 'IE 5.5', 'msie.5\\.5');
INSERT INTO browser VALUES (58, 'IE 6', 'msie.6');
INSERT INTO browser VALUES (101, 'iCab', 'icab');
INSERT INTO browser VALUES (102, 'amaya', 'amaya');
INSERT INTO browser VALUES (103, 'Lynx', 'lynx');
INSERT INTO browser VALUES (104, 'Konqueror', 'konqueror');
INSERT INTO browser VALUES (105, 'Lotus', 'lotus');
INSERT INTO browser VALUES (106, 'Links', 'links .');
INSERT INTO browser VALUES (107, 'Mosaic', 'mosaic');
INSERT INTO browser VALUES (201, 'Netscape 1', 'mozilla/1.*;.(I|U)(;|\\))');
INSERT INTO browser VALUES (202, 'Netscape 2', 'mozilla/2.*;.(I|U)(;|\\))');
INSERT INTO browser VALUES (203, 'Netscape 3', 'mozilla/3.*;.(I|U)(;|\\))');
INSERT INTO browser VALUES (204, 'Netscape 4', 'mozilla/4.*;.(I|U)(;|\\))');
INSERT INTO browser VALUES (205, 'Netscape 6', 'netscape.?6');
INSERT INTO browser VALUES (231, 'Mozilla 0.9', 'mozilla/5.*rv:0.9');
INSERT INTO browser VALUES (6, 'Opera 7.0', 'opera.7\\.0');
INSERT INTO browser VALUES (51, 'IE PDA', 'ie.*windows.ce');
INSERT INTO browser VALUES (108, 'OmniWeb', 'omniweb');
INSERT INTO browser VALUES (111, 'Nautilus', 'nautilus');
INSERT INTO browser VALUES (112, 'Galeon', 'galeon');
INSERT INTO browser VALUES (7, 'Opera 7.1', 'opera.7\\.1');
INSERT INTO browser VALUES (110, 'AvantGo', 'avantgo');
INSERT INTO browser VALUES (206, 'Netscape 7', 'netscape.?7');
INSERT INTO browser VALUES (8, 'Opera 7.2', 'opera.7\\.2');
INSERT INTO browser VALUES (232, 'Mozilla 1.0', 'mozilla/5.*rv:1.0');
INSERT INTO browser VALUES (233, 'Mozilla 1.1', 'mozilla/5.*rv:1.1');
INSERT INTO browser VALUES (234, 'Mozilla 1.2', 'mozilla/5.*rv:1.2');
INSERT INTO browser VALUES (235, 'Mozilla 1.3', 'mozilla/5.*rv:1.3');
INSERT INTO browser VALUES (236, 'Mozilla 1.4', 'mozilla/5.*rv:1.4');
INSERT INTO browser VALUES (237, 'Mozilla 1.5', 'mozilla/5.*rv:1.5');
INSERT INTO browser VALUES (238, 'Mozilla 1.6', 'mozilla/5.*rv:1.6');
INSERT INTO browser VALUES (280, 'Mozilla (zbytek)', 'mozilla/5.*;.(I|U)(;|\\)).*gecko');
INSERT INTO browser VALUES (109, 'Safari', 'safari');
INSERT INTO browser VALUES (40, 'Opera (ostatní)', 'opera');
INSERT INTO browser VALUES (239, 'Mozilla 1.7', 'mozilla/5.*rv:1.7');
# --------------------------------------------------------

#
# Table structure for table `browser_add_on`
#

CREATE TABLE browser_add_on (
  id int(11) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  add_on_regexp varchar(30) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `browser_add_on`
#

INSERT INTO browser_add_on VALUES (1, 'NetCaptor', 'netcaptor');
INSERT INTO browser_add_on VALUES (2, 'HotBar', 'hotbar');
INSERT INTO browser_add_on VALUES (3, 'Crazy Browser', 'crazy.browser');
INSERT INTO browser_add_on VALUES (4, 'Net Manager', 'net.m@nager');
INSERT INTO browser_add_on VALUES (5, 'Girafa', 'girafabot');
INSERT INTO browser_add_on VALUES (6, 'MSN', 'msn');
INSERT INTO browser_add_on VALUES (7, 'AOL', 'aol');
INSERT INTO browser_add_on VALUES (8, 'NetComplete', 'netcomplete');
INSERT INTO browser_add_on VALUES (9, 'MyIE2', 'myie2');
INSERT INTO browser_add_on VALUES (10, 'Alexa Toolbar', 'alexa.toolbar');
INSERT INTO browser_add_on VALUES (11, 'Avant Browser', 'avant.browser');
INSERT INTO browser_add_on VALUES (12, 'Firebird', 'firebird');
INSERT INTO browser_add_on VALUES (13, 'Phoenix', 'phoenix');
INSERT INTO browser_add_on VALUES (14, 'Chimera', 'chimera');
INSERT INTO browser_add_on VALUES (15, 'Camino', 'camino');
INSERT INTO browser_add_on VALUES (16, 'K-Meleon', 'k-meleon');
INSERT INTO browser_add_on VALUES (17, 'Firefox', 'firefox');
# --------------------------------------------------------

#
# Table structure for table `colordepth`
#

CREATE TABLE colordepth (
  id int(11) NOT NULL default '0',
  depth int(11) NOT NULL default '0',
  description varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `colordepth`
#

INSERT INTO colordepth VALUES (1, 1, '16 barev');
INSERT INTO colordepth VALUES (2, 8, '256 barev');
INSERT INTO colordepth VALUES (3, 16, '16 bitů (High Color)');
INSERT INTO colordepth VALUES (4, 24, '24 bitů (True Color)');
INSERT INTO colordepth VALUES (5, 32, '32 bitů (True Color)');
INSERT INTO colordepth VALUES (0, 0, 'Jiná, nezjištěno');
# --------------------------------------------------------

#
# Table structure for table `domain`
#

CREATE TABLE domain (
  id int(11) NOT NULL default '0',
  code varchar(10) NOT NULL default '',
  description varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `domain`
#

INSERT INTO domain VALUES (0, '??', 'Nezjištěno');
INSERT INTO domain VALUES (1, 'ac', 'Ascension (ostrov)');
INSERT INTO domain VALUES (2, 'ad', 'Andorra');
INSERT INTO domain VALUES (3, 'ae', 'Spojené arabské emiráty');
INSERT INTO domain VALUES (4, 'af', 'Afghánistán');
INSERT INTO domain VALUES (5, 'ag', 'Antigua a Barbuda');
INSERT INTO domain VALUES (6, 'ai', 'Anguilla');
INSERT INTO domain VALUES (7, 'al', 'Albánie');
INSERT INTO domain VALUES (8, 'am', 'Arménie');
INSERT INTO domain VALUES (9, 'an', 'Nizozemské Antily');
INSERT INTO domain VALUES (10, 'ao', 'Angola');
INSERT INTO domain VALUES (11, 'aq', 'Antarktida');
INSERT INTO domain VALUES (12, 'ar', 'Argentina');
INSERT INTO domain VALUES (13, 'as', 'Americká Samoa');
INSERT INTO domain VALUES (14, 'at', 'Rakousko');
INSERT INTO domain VALUES (15, 'au', 'Austrálie');
INSERT INTO domain VALUES (16, 'aw', 'Aruba');
INSERT INTO domain VALUES (17, 'az', 'Ázerbájdžán');
INSERT INTO domain VALUES (18, 'ba', 'Bosna a Hercegovina');
INSERT INTO domain VALUES (19, 'bb', 'Barbados');
INSERT INTO domain VALUES (20, 'bd', 'Bangladéš');
INSERT INTO domain VALUES (21, 'be', 'Belgie');
INSERT INTO domain VALUES (22, 'bf', 'Burkina');
INSERT INTO domain VALUES (23, 'bg', 'Bulharsko');
INSERT INTO domain VALUES (24, 'bh', 'Bahrajn');
INSERT INTO domain VALUES (25, 'bi', 'Burundi');
INSERT INTO domain VALUES (26, 'bj', 'Benin');
INSERT INTO domain VALUES (27, 'bm', 'Bermudy');
INSERT INTO domain VALUES (28, 'bn', 'Brunej');
INSERT INTO domain VALUES (29, 'bo', 'Bolívie');
INSERT INTO domain VALUES (30, 'br', 'Brazílie');
INSERT INTO domain VALUES (31, 'bs', 'Bahamy');
INSERT INTO domain VALUES (32, 'bt', 'Bhútán');
INSERT INTO domain VALUES (33, 'bv', 'Bouvetův ostrov');
INSERT INTO domain VALUES (34, 'bw', 'Botswana');
INSERT INTO domain VALUES (35, 'by', 'Bělorusko');
INSERT INTO domain VALUES (36, 'bz', 'Belize');
INSERT INTO domain VALUES (37, 'ca', 'Kanada');
INSERT INTO domain VALUES (38, 'cc', 'Kokosové ostrovy');
INSERT INTO domain VALUES (39, 'cd', 'Kongo - dem. republika');
INSERT INTO domain VALUES (40, 'cf', 'Středoafrická republika');
INSERT INTO domain VALUES (41, 'cg', 'Kongo');
INSERT INTO domain VALUES (42, 'ch', 'Švýcarsko');
INSERT INTO domain VALUES (43, 'ci', 'Cote d\'Ivoire');
INSERT INTO domain VALUES (44, 'ck', 'Cookovy ostrovy');
INSERT INTO domain VALUES (45, 'cl', 'Chile');
INSERT INTO domain VALUES (46, 'cm', 'Kamerun');
INSERT INTO domain VALUES (47, 'cn', 'Čína');
INSERT INTO domain VALUES (48, 'co', 'Kolumbie');
INSERT INTO domain VALUES (49, 'cr', 'Kostarika');
INSERT INTO domain VALUES (50, 'cu', 'Kuba');
INSERT INTO domain VALUES (51, 'cv', 'Kapverdy');
INSERT INTO domain VALUES (52, 'cx', 'Vánoční ostrov');
INSERT INTO domain VALUES (53, 'cy', 'Kypr');
INSERT INTO domain VALUES (54, 'cz', 'Česko');
INSERT INTO domain VALUES (55, 'de', 'Německo');
INSERT INTO domain VALUES (56, 'dj', 'Džibutsko');
INSERT INTO domain VALUES (57, 'dk', 'Dánsko');
INSERT INTO domain VALUES (58, 'dm', 'Dominika');
INSERT INTO domain VALUES (59, 'do', 'Dominikánská republika');
INSERT INTO domain VALUES (60, 'dz', 'Alžírsko');
INSERT INTO domain VALUES (61, 'ec', 'Ekvádor');
INSERT INTO domain VALUES (62, 'ee', 'Estonsko');
INSERT INTO domain VALUES (63, 'eg', 'Egypt');
INSERT INTO domain VALUES (64, 'eh', 'Západní Sahara');
INSERT INTO domain VALUES (65, 'er', 'Eritrea');
INSERT INTO domain VALUES (66, 'es', 'Španělsko');
INSERT INTO domain VALUES (67, 'et', 'Etiopie');
INSERT INTO domain VALUES (68, 'fi', 'Finsko');
INSERT INTO domain VALUES (69, 'fj', 'Fidži');
INSERT INTO domain VALUES (70, 'fk', 'Falklandy (Malvíny)');
INSERT INTO domain VALUES (71, 'fm', 'Federativní státy Mikronésie');
INSERT INTO domain VALUES (72, 'fo', 'Faerské ostrovy');
INSERT INTO domain VALUES (73, 'fr', 'Francie');
INSERT INTO domain VALUES (74, 'ga', 'Gabon');
INSERT INTO domain VALUES (76, 'gd', 'Grenada');
INSERT INTO domain VALUES (77, 'ge', 'Gruzie');
INSERT INTO domain VALUES (78, 'gf', 'Francouzská Guyana');
INSERT INTO domain VALUES (79, 'gg', 'Guernsey');
INSERT INTO domain VALUES (80, 'gh', 'Ghana');
INSERT INTO domain VALUES (81, 'gi', 'Gibraltar');
INSERT INTO domain VALUES (82, 'gl', 'Grónsko');
INSERT INTO domain VALUES (83, 'gm', 'Gambie');
INSERT INTO domain VALUES (84, 'gn', 'Guinea');
INSERT INTO domain VALUES (85, 'gp', 'Guadeloupe');
INSERT INTO domain VALUES (86, 'gq', 'Rovníková Guinea');
INSERT INTO domain VALUES (87, 'gr', 'Řecko');
INSERT INTO domain VALUES (88, 'gs', 'Jižní Georgie a Jižní Sandwichovy ostrovy');
INSERT INTO domain VALUES (89, 'gt', 'Guatemala');
INSERT INTO domain VALUES (90, 'gu', 'Guam');
INSERT INTO domain VALUES (91, 'gw', 'Guinea-Bissau');
INSERT INTO domain VALUES (92, 'gy', 'Guyana');
INSERT INTO domain VALUES (93, 'hk', 'Hongkong');
INSERT INTO domain VALUES (94, 'hm', 'Heardův ostrov a McDonaldovy ostrovy');
INSERT INTO domain VALUES (95, 'hn', 'Honduras');
INSERT INTO domain VALUES (96, 'hr', 'Chorvatsko');
INSERT INTO domain VALUES (97, 'ht', 'Haiti');
INSERT INTO domain VALUES (98, 'hu', 'Maďarsko');
INSERT INTO domain VALUES (99, 'id', 'Indonésie');
INSERT INTO domain VALUES (100, 'ie', 'Irsko');
INSERT INTO domain VALUES (101, 'il', 'Izrael');
INSERT INTO domain VALUES (102, 'im', 'Man (ostrov)');
INSERT INTO domain VALUES (103, 'in', 'Indie');
INSERT INTO domain VALUES (104, 'io', 'Britské indickooceánské území');
INSERT INTO domain VALUES (105, 'iq', 'Irák');
INSERT INTO domain VALUES (106, 'ir', 'Írán');
INSERT INTO domain VALUES (107, 'is', 'Island');
INSERT INTO domain VALUES (108, 'it', 'Itálie');
INSERT INTO domain VALUES (109, 'je', 'Jersey');
INSERT INTO domain VALUES (110, 'jm', 'Jamajka');
INSERT INTO domain VALUES (111, 'jo', 'Jordánsko');
INSERT INTO domain VALUES (112, 'jp', 'Japonsko');
INSERT INTO domain VALUES (113, 'ke', 'Keňa');
INSERT INTO domain VALUES (114, 'kg', 'Kyrgyzstán');
INSERT INTO domain VALUES (115, 'kh', 'Kambodža');
INSERT INTO domain VALUES (116, 'ki', 'Kiribati');
INSERT INTO domain VALUES (117, 'km', 'Komory');
INSERT INTO domain VALUES (118, 'kn', 'Sv. Kryštof a Nevis');
INSERT INTO domain VALUES (119, 'kp', 'Korejská lidově dem. republika (KLDR)');
INSERT INTO domain VALUES (120, 'kr', 'Korejská republika');
INSERT INTO domain VALUES (121, 'kw', 'Kuvajt');
INSERT INTO domain VALUES (122, 'ky', 'Kajmanské ostrovy');
INSERT INTO domain VALUES (123, 'kz', 'Kazachstán');
INSERT INTO domain VALUES (124, 'la', 'Laos');
INSERT INTO domain VALUES (125, 'lb', 'Libanon');
INSERT INTO domain VALUES (126, 'lc', 'Sv. Lucie');
INSERT INTO domain VALUES (127, 'li', 'Lichtenštejnsko');
INSERT INTO domain VALUES (128, 'lk', 'Srí Lanka');
INSERT INTO domain VALUES (129, 'lr', 'Libérie');
INSERT INTO domain VALUES (130, 'ls', 'Lesotho');
INSERT INTO domain VALUES (131, 'lt', 'Litva');
INSERT INTO domain VALUES (132, 'lu', 'Lucembursko');
INSERT INTO domain VALUES (133, 'lv', 'Lotyšsko');
INSERT INTO domain VALUES (134, 'ly', 'Libye');
INSERT INTO domain VALUES (135, 'ma', 'Maroko');
INSERT INTO domain VALUES (136, 'mc', 'Monako');
INSERT INTO domain VALUES (137, 'md', 'Moldávie');
INSERT INTO domain VALUES (138, 'mg', 'Madagaskar');
INSERT INTO domain VALUES (139, 'mh', 'Marshallovy ostrovy');
INSERT INTO domain VALUES (140, 'mk', 'Makedonie');
INSERT INTO domain VALUES (141, 'ml', 'Mali');
INSERT INTO domain VALUES (142, 'mm', 'Myanmar');
INSERT INTO domain VALUES (143, 'mn', 'Mongolsko');
INSERT INTO domain VALUES (144, 'mo', 'Macao');
INSERT INTO domain VALUES (145, 'mp', 'Severní Mariany');
INSERT INTO domain VALUES (146, 'mq', 'Martinik');
INSERT INTO domain VALUES (147, 'mr', 'Mauritánie');
INSERT INTO domain VALUES (148, 'ms', 'Montserrat');
INSERT INTO domain VALUES (149, 'mt', 'Malta');
INSERT INTO domain VALUES (150, 'mu', 'Mauricius');
INSERT INTO domain VALUES (151, 'mv', 'Maledivy');
INSERT INTO domain VALUES (152, 'mw', 'Malawi');
INSERT INTO domain VALUES (153, 'mx', 'Mexiko');
INSERT INTO domain VALUES (154, 'my', 'Malajsie');
INSERT INTO domain VALUES (155, 'mz', 'Mosambik');
INSERT INTO domain VALUES (156, 'na', 'Namibie');
INSERT INTO domain VALUES (157, 'nc', 'Nová Kaledonie');
INSERT INTO domain VALUES (158, 'ne', 'Niger');
INSERT INTO domain VALUES (159, 'nf', 'Norfolk');
INSERT INTO domain VALUES (160, 'ng', 'Nigérie');
INSERT INTO domain VALUES (161, 'ni', 'Nikaragua');
INSERT INTO domain VALUES (162, 'nl', 'Nizozemsko');
INSERT INTO domain VALUES (163, 'no', 'Norsko');
INSERT INTO domain VALUES (164, 'np', 'Nepál');
INSERT INTO domain VALUES (165, 'nr', 'Nauru');
INSERT INTO domain VALUES (166, 'nu', 'Niue');
INSERT INTO domain VALUES (167, 'nz', 'Nový Zéland');
INSERT INTO domain VALUES (168, 'om', 'Omán');
INSERT INTO domain VALUES (169, 'pa', 'Panama');
INSERT INTO domain VALUES (170, 'pe', 'Peru');
INSERT INTO domain VALUES (171, 'pf', 'Francouzská Polynésie');
INSERT INTO domain VALUES (172, 'pg', 'Papua - Nová Guinea');
INSERT INTO domain VALUES (173, 'ph', 'Filipíny');
INSERT INTO domain VALUES (174, 'pk', 'Pákistán');
INSERT INTO domain VALUES (175, 'pl', 'Polsko');
INSERT INTO domain VALUES (176, 'pm', 'St. Pierre a Miquelon');
INSERT INTO domain VALUES (177, 'pn', 'Pitcairnovy ostrovy');
INSERT INTO domain VALUES (178, 'pr', 'Portoriko');
INSERT INTO domain VALUES (179, 'pt', 'Portugalsko');
INSERT INTO domain VALUES (180, 'pw', 'Palau');
INSERT INTO domain VALUES (181, 'py', 'Paraguay');
INSERT INTO domain VALUES (182, 'qa', 'Katar');
INSERT INTO domain VALUES (183, 're', 'Réunion');
INSERT INTO domain VALUES (184, 'ro', 'Rumunsko');
INSERT INTO domain VALUES (185, 'ru', 'Rusko');
INSERT INTO domain VALUES (186, 'rw', 'Rwanda');
INSERT INTO domain VALUES (187, 'sa', 'Saudská Arábie');
INSERT INTO domain VALUES (188, 'sb', 'Šalamounovy ostrovy');
INSERT INTO domain VALUES (189, 'sc', 'Seychely');
INSERT INTO domain VALUES (190, 'sd', 'Súdán');
INSERT INTO domain VALUES (191, 'se', 'Švédsko');
INSERT INTO domain VALUES (192, 'sg', 'Singapur');
INSERT INTO domain VALUES (193, 'sh', 'Sv. Helena');
INSERT INTO domain VALUES (194, 'si', 'Slovinsko');
INSERT INTO domain VALUES (195, 'sj', 'Svalbard');
INSERT INTO domain VALUES (196, 'sk', 'Slovensko');
INSERT INTO domain VALUES (197, 'sl', 'Sierra Leone');
INSERT INTO domain VALUES (198, 'sm', 'San Marino');
INSERT INTO domain VALUES (199, 'sn', 'Senegal');
INSERT INTO domain VALUES (200, 'so', 'Somálsko');
INSERT INTO domain VALUES (201, 'sr', 'Surinam');
INSERT INTO domain VALUES (202, 'st', 'Sv. Tomáš a Princův ostrov');
INSERT INTO domain VALUES (203, 'sv', 'Salvador');
INSERT INTO domain VALUES (204, 'sy', 'Sýrie');
INSERT INTO domain VALUES (205, 'sz', 'Svazijsko');
INSERT INTO domain VALUES (206, 'tc', 'Turks a Caicos');
INSERT INTO domain VALUES (207, 'td', 'Čad');
INSERT INTO domain VALUES (208, 'tf', 'Francouzská jižní území');
INSERT INTO domain VALUES (209, 'tg', 'Togo');
INSERT INTO domain VALUES (210, 'th', 'Thajsko');
INSERT INTO domain VALUES (211, 'tj', 'Tadžikistán');
INSERT INTO domain VALUES (212, 'tk', 'Tokelau');
INSERT INTO domain VALUES (213, 'tm', 'Turkmenistán');
INSERT INTO domain VALUES (214, 'tn', 'Tunisko');
INSERT INTO domain VALUES (215, 'to', 'Tonga');
INSERT INTO domain VALUES (216, 'tp', 'Východní Timor');
INSERT INTO domain VALUES (217, 'tr', 'Turecko');
INSERT INTO domain VALUES (218, 'tt', 'Trinidad a Tobago');
INSERT INTO domain VALUES (219, 'tv', 'Tuvalu');
INSERT INTO domain VALUES (220, 'tw', 'Taiwan');
INSERT INTO domain VALUES (221, 'tz', 'Tanzanie');
INSERT INTO domain VALUES (222, 'ua', 'Ukrajina');
INSERT INTO domain VALUES (223, 'ug', 'Uganda');
INSERT INTO domain VALUES (224, 'uk', 'Velká Británie');
INSERT INTO domain VALUES (225, 'um', 'Menší odlehlé ostrovy USA');
INSERT INTO domain VALUES (226, 'us', 'Spojené státy americké');
INSERT INTO domain VALUES (227, 'uy', 'Uruguay');
INSERT INTO domain VALUES (228, 'uz', 'Uzbekistán');
INSERT INTO domain VALUES (229, 'va', 'Vatikán');
INSERT INTO domain VALUES (230, 'vc', 'Sv. Vincenc a Grenadiny');
INSERT INTO domain VALUES (231, 've', 'Venezuela');
INSERT INTO domain VALUES (232, 'vg', 'Britské Panenské ostrovy');
INSERT INTO domain VALUES (233, 'vi', 'Americké Panenské ostrovy');
INSERT INTO domain VALUES (234, 'vn', 'Vietnam');
INSERT INTO domain VALUES (235, 'vu', 'Vanuatu');
INSERT INTO domain VALUES (236, 'wf', 'Wallis Futuna');
INSERT INTO domain VALUES (237, 'ws', 'Samoa');
INSERT INTO domain VALUES (238, 'ye', 'Jemen');
INSERT INTO domain VALUES (239, 'yt', 'Mayotte');
INSERT INTO domain VALUES (240, 'yu', 'Jugoslávie');
INSERT INTO domain VALUES (241, 'za', 'Jihoafrická republika');
INSERT INTO domain VALUES (242, 'zm', 'Zambie');
INSERT INTO domain VALUES (245, 'zw', 'Zimbabwe');
INSERT INTO domain VALUES (246, 'com', 'obchodní společnosti');
INSERT INTO domain VALUES (247, 'net', 'provoz intenetu, ISP');
INSERT INTO domain VALUES (248, 'org', 'neziskové organizace');
INSERT INTO domain VALUES (249, 'edu', 'výchovně-vzdělávací organizace');
INSERT INTO domain VALUES (250, 'int', 'mezinárodní organizace');
INSERT INTO domain VALUES (251, 'arpa', 'ARPAnet');
INSERT INTO domain VALUES (252, 'gov', 'vládní organizace');
INSERT INTO domain VALUES (253, 'mil', 'vojenské (obranné) organizace');
INSERT INTO domain VALUES (254, 'aero', 'letecká doprava');
INSERT INTO domain VALUES (255, 'biz', 'velké obchodní společnosti');
INSERT INTO domain VALUES (256, 'coop', 'družstevní společnosti');
INSERT INTO domain VALUES (257, 'info', 'obchodní společnosti');
INSERT INTO domain VALUES (258, 'museum', 'muzea, výstavy');
INSERT INTO domain VALUES (259, 'name', 'osobní stránky');
INSERT INTO domain VALUES (260, 'pro', 'profese');
INSERT INTO domain VALUES (261, 'su', 'SSSR');
INSERT INTO domain VALUES (262, 'ps', 'Okupované palestinské území');
# --------------------------------------------------------

#
# Table structure for table `os`
#

CREATE TABLE os (
  id int(11) NOT NULL default '0',
  name varchar(50) NOT NULL default '',
  os_regexp varchar(70) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `os`
#

INSERT INTO os VALUES (0, 'Jiný, nezjištěno', '');
INSERT INTO os VALUES (1, 'Windows ME', 'win.9x.4\\.90|windows.me');
INSERT INTO os VALUES (2, 'Windows 98', 'windows.98|win98|windows.4\\.10');
INSERT INTO os VALUES (3, 'Windows 95', 'windows.95|win95');
INSERT INTO os VALUES (4, 'Windows 2000', 'windows.nt.5\\.0|windows.2000');
INSERT INTO os VALUES (5, 'Windows XP', 'windows.xp|windows.nt.5\\.1');
INSERT INTO os VALUES (6, 'Windows 2003 Server', 'windows.2003|windows.nt.5\\.2');
INSERT INTO os VALUES (7, 'Windows Codename Longhorn', 'windows.2005|windows.nt.6\\.0');
INSERT INTO os VALUES (15, 'Windows NT', 'windows.nt|winnt');
INSERT INTO os VALUES (16, 'Windows 3.x', 'win16|win3\\.|windows.3\\.');
INSERT INTO os VALUES (17, 'Windows Smartphone 2002', 'msie 3.*windows.ce.*smartphone');
INSERT INTO os VALUES (18, 'Windows PocketPC 2002', 'msie.3.*windows.ce.*ppc');
INSERT INTO os VALUES (19, 'Windows PocketPC 2003', 'msie.4.*windows.ce.*ppc');
INSERT INTO os VALUES (30, 'Windows CE', 'windows.ce');
INSERT INTO os VALUES (40, 'Windows (ostatní)', 'win');
INSERT INTO os VALUES (51, 'Mac Os X', 'mac.os.x');
INSERT INTO os VALUES (52, 'Mac Os 8/9', 'mac.os');
INSERT INTO os VALUES (59, 'Macintosh', 'mac');
INSERT INTO os VALUES (61, 'Linux', 'linux');
INSERT INTO os VALUES (62, 'BeOS', 'beos');
INSERT INTO os VALUES (63, 'SunOS', 'sunos');
INSERT INTO os VALUES (64, 'HP-UX', 'hp-ux');
INSERT INTO os VALUES (65, 'OSF', 'osf');
INSERT INTO os VALUES (66, 'IRIX', 'irix');
INSERT INTO os VALUES (67, 'FreeBSD', 'freebsd');
INSERT INTO os VALUES (68, 'OpenBSD', 'openbsd');
INSERT INTO os VALUES (69, 'NetBSD', 'netbsd');
INSERT INTO os VALUES (70, 'BSDI', 'bsdi');
INSERT INTO os VALUES (71, 'AIX', 'aix');
INSERT INTO os VALUES (72, 'GNU', 'gnu');
INSERT INTO os VALUES (73, 'OS/2', 'os/2');
INSERT INTO os VALUES (74, 'CP/M', 'cp/m');
INSERT INTO os VALUES (75, 'Symbian', 'symbian');
INSERT INTO os VALUES (80, 'Mobilní telefon', 'alcatel|mot\\-|nokia|panasonic|philips|sonyericsson|ericsson|mmef|wapal');
INSERT INTO os VALUES (90, 'Unix', 'unix|x11');
# --------------------------------------------------------

#
# Table structure for table `path`
#

CREATE TABLE path (
  id int(11) NOT NULL auto_increment,
  page varchar(250) NOT NULL default '',
  title tinytext NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `path`
#

# --------------------------------------------------------

#
# Table structure for table `referer`
#

CREATE TABLE referer (
  id int(11) NOT NULL auto_increment,
  server varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `referer`
#

INSERT INTO referer VALUES (2, 'Přechod v rámci serveru');
INSERT INTO referer VALUES (1, 'Přímé volání');
# --------------------------------------------------------

#
# Table structure for table `region`
#

CREATE TABLE region (
  id int(11) NOT NULL default '0',
  name varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `region`
#

INSERT INTO region VALUES (1, 'Praha');
INSERT INTO region VALUES (2, 'Středočeský kraj');
INSERT INTO region VALUES (3, 'Jihočeský kraj');
INSERT INTO region VALUES (4, 'Plzeňský kraj');
INSERT INTO region VALUES (5, 'Karlovarský kraj');
INSERT INTO region VALUES (6, 'Ústecký kraj');
INSERT INTO region VALUES (7, 'Liberecký kraj');
INSERT INTO region VALUES (8, 'Královéhradecký kraj');
INSERT INTO region VALUES (9, 'Pardubický kraj');
INSERT INTO region VALUES (10, 'Vysočina');
INSERT INTO region VALUES (11, 'Jihomoravský kraj');
INSERT INTO region VALUES (12, 'Zlínský kraj');
INSERT INTO region VALUES (13, 'Olomoucký kraj');
INSERT INTO region VALUES (14, 'Moravskoslezský kraj');
INSERT INTO region VALUES (15, 'Vysoké školy');
INSERT INTO region VALUES (16, 'Slovensko');
INSERT INTO region VALUES (0, 'Ostatní');
# --------------------------------------------------------

#
# Table structure for table `resolution`
#

CREATE TABLE resolution (
  id int(11) NOT NULL default '0',
  screenres varchar(10) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `resolution`
#

INSERT INTO resolution VALUES (0, 'Jiné');
INSERT INTO resolution VALUES (1, '640x480');
INSERT INTO resolution VALUES (2, '790x566');
INSERT INTO resolution VALUES (3, '800x600');
INSERT INTO resolution VALUES (4, '832x624');
INSERT INTO resolution VALUES (5, '960x720');
INSERT INTO resolution VALUES (6, '1000x700');
INSERT INTO resolution VALUES (7, '1024x600');
INSERT INTO resolution VALUES (8, '1024x640');
INSERT INTO resolution VALUES (9, '1024x742');
INSERT INTO resolution VALUES (10, '1024x768');
INSERT INTO resolution VALUES (11, '1152x768');
INSERT INTO resolution VALUES (12, '1152x864');
INSERT INTO resolution VALUES (13, '1152x870');
INSERT INTO resolution VALUES (14, '1152x900');
INSERT INTO resolution VALUES (15, '1280x768');
INSERT INTO resolution VALUES (16, '1280x800');
INSERT INTO resolution VALUES (17, '1280x854');
INSERT INTO resolution VALUES (18, '1280x960');
INSERT INTO resolution VALUES (19, '1280x977');
INSERT INTO resolution VALUES (20, '1280x1024');
INSERT INTO resolution VALUES (21, '1360x1020');
INSERT INTO resolution VALUES (22, '1400x1050');
INSERT INTO resolution VALUES (23, '1440x900');
INSERT INTO resolution VALUES (24, '1600x600');
INSERT INTO resolution VALUES (25, '1600x998');
INSERT INTO resolution VALUES (26, '1600x1024');
INSERT INTO resolution VALUES (27, '1600x1200');
INSERT INTO resolution VALUES (28, '1600x1280');
INSERT INTO resolution VALUES (29, '1920x1200');
INSERT INTO resolution VALUES (30, '2048x1768');
INSERT INTO resolution VALUES (31, '2048x768');
INSERT INTO resolution VALUES (32, '2304x864');
INSERT INTO resolution VALUES (33, '2560x960');
INSERT INTO resolution VALUES (34, '2560x1024');
INSERT INTO resolution VALUES (35, '3840x1024');
# --------------------------------------------------------

#
# Table structure for table `searched`
#

CREATE TABLE searched (
  id int(11) NOT NULL auto_increment,
  search_date datetime NOT NULL default '0000-00-00 00:00:00',
  server int(11) NOT NULL default '0',
  query int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `searched`
#

# --------------------------------------------------------

#
# Table structure for table `searchengine`
#

CREATE TABLE searchengine (
  id int(11) NOT NULL auto_increment,
  server varchar(50) NOT NULL default '',
  variable varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `searchengine`
#

INSERT INTO searchengine VALUES (1, 'seznam.cz', 'w');
INSERT INTO searchengine VALUES (2, 'centrum.cz', 'q');
INSERT INTO searchengine VALUES (3, 'atlas.cz', 'q');
INSERT INTO searchengine VALUES (4, 'google.com', 'q');
INSERT INTO searchengine VALUES (5, 'jyxo.cz', 's');
INSERT INTO searchengine VALUES (6, 'idnes.cz', 'q');
INSERT INTO searchengine VALUES (7, 'redbox.cz', 'qs');
INSERT INTO searchengine VALUES (8, 'quick.cz', 'ftxt_query');
INSERT INTO searchengine VALUES (9, 'volny.cz', 'search');
INSERT INTO searchengine VALUES (10, 'tiscali.cz', 'query');
INSERT INTO searchengine VALUES (11, 'zoznam.sk', 's');
INSERT INTO searchengine VALUES (12, 'caramba.cz', 'Text');
INSERT INTO searchengine VALUES (13, 'altavista.com', 'q');
INSERT INTO searchengine VALUES (14, 'yahoo.com', 'p');
INSERT INTO searchengine VALUES (15, 'katedrala.cz', 'KeyWords');
INSERT INTO searchengine VALUES (16, 'toplist.cz', 'search');
INSERT INTO searchengine VALUES (17, 'zona.cz', 'TERMS');
INSERT INTO searchengine VALUES (18, 'dmoz.org', 'search');
INSERT INTO searchengine VALUES (19, 'msn.com', 'q');
INSERT INTO searchengine VALUES (20, 'zoohoo.cz', 'q');
INSERT INTO searchengine VALUES (21, 'icq.com', 'q');
INSERT INTO searchengine VALUES (22, 'yo.cz', 'q');
INSERT INTO searchengine VALUES (23, 'ask.com', 'query');
INSERT INTO searchengine VALUES (24, 'aol.com', 'query');
INSERT INTO searchengine VALUES (25, 'hotbot.com', 'query');
INSERT INTO searchengine VALUES (26, 'lycos.com', 'query');
INSERT INTO searchengine VALUES (27, 'overture.com', 'Keywords');
INSERT INTO searchengine VALUES (28, 'mamma.com', 'query');
# --------------------------------------------------------

#
# Table structure for table `searchtext`
#

CREATE TABLE searchtext (
  id int(11) NOT NULL auto_increment,
  query varchar(150) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `searchtext`
#

# --------------------------------------------------------

#
# Table structure for table `town`
#

CREATE TABLE town (
  id int(11) NOT NULL default '0',
  name varchar(70) NOT NULL default '',
  ip_regexp varchar(150) NOT NULL default '',
  region int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `town`
#

INSERT INTO town VALUES (1, 'Hradec Králové', 'hk\\.tiscali\\.cz|hradec|hrk.*nextra\\.cz|hk.*vol\\.cz', 8);
INSERT INTO town VALUES (2, 'Brno', 'brno|brn.*nextra\\.cz|bno.*karneval\\.cz|brn.*sky\\.cz|brn.*vol\\.cz', 11);
INSERT INTO town VALUES (3, 'Mladá Boleslav', 'mb\\.tiscali\\.cz|boleslav', 2);
INSERT INTO town VALUES (4, 'Praha', 'praha|pha\\.gts\\.cz|phu.*nextra\\.cz|pha.*sky\\.cz|prague|pra.*vol\\.cz|prg.*vol\\.cz|pha.*karneval\\.cz|pra.*dial-up\\.cz|prah.*ctt\\.cz', 1);
INSERT INTO town VALUES (5, 'Ostrava', 'ostrava|ova.*nextra\\.cz|ova.*sky\\.cz|ost.*vol\\.cz|ova.*karneval\\.cz|ova.*bluetone\\.cz', 14);
INSERT INTO town VALUES (6, 'Kladno', 'kladno', 2);
INSERT INTO town VALUES (7, 'Tábor', 'tabor', 3);
INSERT INTO town VALUES (8, 'Karlovy Vary', 'vary|kva.*nextra\\.cz', 5);
INSERT INTO town VALUES (9, 'Plzeň', 'plzen|plz.*nextra\\.cz', 4);
INSERT INTO town VALUES (10, 'Pardubice', 'pce\\.tiscali\\.cz|pardubice', 9);
INSERT INTO town VALUES (11, 'České Budějovice', 'cb\\.tiscali\\.cz|budejice', 3);
INSERT INTO town VALUES (12, 'Opava', 'opava', 14);
INSERT INTO town VALUES (13, 'Třinec', 'trinec', 14);
INSERT INTO town VALUES (14, 'Ústí nad Labem', 'usti.*vol\\.cz|ul\\.tiscali\\.cz|ul.*vol\\.cz', 6);
INSERT INTO town VALUES (15, 'Náchod', 'na\\.tiscali\\.cz', 8);
INSERT INTO town VALUES (16, 'Velké Meziříčí', 'velkemezirici', 10);
INSERT INTO town VALUES (17, 'Teplice', 'teplice', 6);
INSERT INTO town VALUES (18, 'Ústí nad Orlicí', 'uo\\.tiscali\\.cz', 9);
INSERT INTO town VALUES (19, 'Olomouc', 'olomouc|olc.*nextra\\.cz|olo.*vol\\.cz', 13);
INSERT INTO town VALUES (20, 'Rychnov nad Kněžnou', 'rychnov', 8);
INSERT INTO town VALUES (21, 'Znojmo', 'znojmo', 11);
INSERT INTO town VALUES (22, 'Děčín', 'decin', 6);
INSERT INTO town VALUES (23, 'Přerov', 'prerov', 13);
INSERT INTO town VALUES (24, 'Liberec', 'liberec|lbc.*nextra\\.cz', 7);
INSERT INTO town VALUES (25, 'Ždár nad Sázavou', 'zdar', 10);
INSERT INTO town VALUES (26, 'Příbram', 'pribram', 2);
INSERT INTO town VALUES (27, 'Chomutov', 'chomutov', 6);
INSERT INTO town VALUES (28, 'Písek', 'pisek', 3);
INSERT INTO town VALUES (29, 'Břeclav', 'breclav', 11);
INSERT INTO town VALUES (30, 'Kroměříž', 'kromeriz', 12);
INSERT INTO town VALUES (31, 'Zlín', 'zlin', 12);
INSERT INTO town VALUES (32, 'Polička', 'policka', 9);
INSERT INTO town VALUES (33, 'Sokolov', 'sokolov', 5);
INSERT INTO town VALUES (34, 'Havlíčkův Brod', 'hb\\.tiscali\\.cz', 10);
INSERT INTO town VALUES (35, 'Jablonec nad Nisou', 'jablonec', 7);
INSERT INTO town VALUES (36, 'Jihlava', 'jihlava', 10);
INSERT INTO town VALUES (37, 'Třebíč', 'trebic', 10);
INSERT INTO town VALUES (38, 'Kutná hora', 'kutnahora', 2);
INSERT INTO town VALUES (39, 'Trutnov', 'trutnov', 8);
INSERT INTO town VALUES (40, 'Chrudim', 'chrudim', 9);
INSERT INTO town VALUES (41, 'Šumperk', 'sumperk', 13);
INSERT INTO town VALUES (42, 'Krnov', 'krnov', 14);
INSERT INTO town VALUES (43, 'Cheb', 'cheb', 5);
INSERT INTO town VALUES (44, 'Kyjov', 'kyjov', 11);
INSERT INTO town VALUES (45, 'Brandýs nad Labem', 'brandys', 2);
INSERT INTO town VALUES (46, 'Prostějov', 'prostejov', 13);
INSERT INTO town VALUES (47, 'Sušice', 'susice', 4);
INSERT INTO town VALUES (48, 'Vsetín', 'vsetin', 12);
INSERT INTO town VALUES (49, 'VUT Brno', 'vutbr\\.cz', 15);
INSERT INTO town VALUES (50, 'UK Praha', 'cuni\\.cz', 15);
INSERT INTO town VALUES (51, 'ČVUT Praha', 'cvut\\.cz', 15);
INSERT INTO town VALUES (52, 'VŠE Praha', 'vse\\.cz', 15);
INSERT INTO town VALUES (53, 'VŠB TU Ostrava', 'vsb\\.cz', 15);
INSERT INTO town VALUES (54, 'ZČU Plzeň', 'zcu\\.cz', 15);
INSERT INTO town VALUES (55, 'MU Brno', 'muni\\.cz', 15);
INSERT INTO town VALUES (57, 'Mendelova uni. Brno', 'mendelu\\.cz', 15);
INSERT INTO town VALUES (58, 'JČU', 'jcu\\.cz', 15);
INSERT INTO town VALUES (59, 'TU Liberec', 'vslib\\.cz', 15);
INSERT INTO town VALUES (60, 'UHK', 'uhk\\.cz', 15);
INSERT INTO town VALUES (61, 'Univerzita Pardubice', 'upce\\.cz', 15);
INSERT INTO town VALUES (62, 'ČZU Praha', 'czu\\.cz', 15);
INSERT INTO town VALUES (63, 'Uni. Palackého - Olomouc', 'upol\\.cz', 15);
INSERT INTO town VALUES (64, 'Uni. J. E. Purkyně - UL', 'ujep\\.cz', 15);
INSERT INTO town VALUES (65, 'VŠCHT Praha', 'vscht\\.cz', 15);
INSERT INTO town VALUES (67, 'Ostravská univerzita', 'osu\\.cz', 15);
INSERT INTO town VALUES (68, 'VŠ vojenská Vyškov', 'vvs-pv\\.cz', 15);
INSERT INTO town VALUES (69, 'Vojenská akademie Brno', 'vabo\\.cz', 15);
INSERT INTO town VALUES (70, 'Vojenská lék. ak.  JEP - HK', 'pmfhk\\.cz', 15);
INSERT INTO town VALUES (71, 'Slezská u. Opava', 'slu\\.cz', 15);
INSERT INTO town VALUES (72, 'Košice', 'ke\\.nextra\\.sk', 16);
INSERT INTO town VALUES (73, 'Bratislava', 'ba\\.nextra\\.sk', 16);
INSERT INTO town VALUES (74, 'TU Košice', 'tuke\\.sk', 16);
INSERT INTO town VALUES (75, 'Most', 'most', 6);
INSERT INTO town VALUES (76, 'Česká Lípa', 'lipa', 7);
INSERT INTO town VALUES (77, 'Uni. P. J. Šafárika Košice', 'upjs\\.sk', 16);
INSERT INTO town VALUES (78, 'Uni. Komenského Bratislava', 'uniba\\.sk', 16);
INSERT INTO town VALUES (79, 'Zvolen', 'zv\\.nextra\\.sk', 16);
INSERT INTO town VALUES (80, 'Trnava', 'tt\\.nextra\\.sk', 16);
INSERT INTO town VALUES (81, 'Žilina', 'za\\.nextra\\.sk', 16);
INSERT INTO town VALUES (82, 'Nitra', 'nr\\.nextra\\.sk', 16);
INSERT INTO town VALUES (83, 'Prešov', 'po\\.nextra\\.sk', 16);
INSERT INTO town VALUES (84, 'Trenčín', 'tn\\.nextra\\.sk', 16);
INSERT INTO town VALUES (85, 'Martin', 'mt\\.nextra\\.sk', 16);
INSERT INTO town VALUES (201, 'Contactel (cz)', 'contactel\\.cz', 0);
INSERT INTO town VALUES (202, 'IOL (cz)', 'iol\\.cz', 0);
INSERT INTO town VALUES (203, 'PVT Net (cz)', 'pvtnet\\.cz', 0);
INSERT INTO town VALUES (204, 'CZ Com (cz)', 'czcom\\.cz', 0);
INSERT INTO town VALUES (205, 'TELE2 (cz)', 'tele2\\.cz', 0);
INSERT INTO town VALUES (206, 'Telecom (sk)', 'telecom\\.sk', 0);
INSERT INTO town VALUES (207, 'Globtelnet (sk)', 'globtelnet\\.sk', 0);
INSERT INTO town VALUES (208, 'PVT (sk)', 'pvt\\.sk', 0);
INSERT INTO town VALUES (209, 'Kiwwi (sk)', 'kiwwi\\.sk', 0);
INSERT INTO town VALUES (210, 'Mistral (UPC)', 'mistral\\.cz', 0);
INSERT INTO town VALUES (301, 'Ostatní CZ', '\\.cz', 0);
INSERT INTO town VALUES (302, 'Ostatní SK', '\\.sk', 0);
INSERT INTO town VALUES (303, 'Ostatní COM', '\\.com', 0);
INSERT INTO town VALUES (304, 'Ostatní NET', '\\.net', 0);
INSERT INTO town VALUES (0, 'Ostatní', '', 0);
INSERT INTO town VALUES (211, 'Eurotel (cz)', 'eurotel\\.cz', 0);
INSERT INTO town VALUES (212, 'T-Mobile (cz)', 't-mobile\\.cz', 0);
INSERT INTO town VALUES (213, 'Oskarmobil (cz)', 'oskarmobil\\.cz', 0);
INSERT INTO town VALUES (214, 'Eurotel (sk)', 'eurotel\\.sk', 0);
INSERT INTO town VALUES (215, 'Czech On Line', 'vol\\.cz|col\\.cz', 0);
INSERT INTO town VALUES (216, 'Orange (sk)', 'orange\\.sk', 0);
INSERT INTO town VALUES (217, 'EuroWeb (sk)', 'euroweb\\.sk', 0);
INSERT INTO town VALUES (218, 'Slovanet', 'slovanet\\.sk', 0);
INSERT INTO town VALUES (219, 'PSG net (sk)', 'psg\\.sk', 0);
INSERT INTO town VALUES (220, 'Chello (sk)', 'chello\\.sk', 0);
INSERT INTO town VALUES (221, 'Netbox (cz)', 'nbox\\.cz|netbox\\.cz', 0);
INSERT INTO town VALUES (222, 'Chello (cz)', 'chello\\.cz', 0);
INSERT INTO town VALUES (223, 'Nextra (sk)', 'nextra\\.sk', 0);
INSERT INTO town VALUES (224, 'Inernext', 'inext\\.cz', 0);
INSERT INTO town VALUES (86, 'Jičín', 'jicin\\.cz', 8);
INSERT INTO town VALUES (87, 'Kolín', 'kolin\\.cz', 2);
INSERT INTO town VALUES (88, 'Strakonice', 'strakonice', 3);
INSERT INTO town VALUES (89, 'Dobruška', 'dobruska', 8);
INSERT INTO town VALUES (90, 'Havířov', 'havirov', 14);
INSERT INTO town VALUES (91, 'Tachov', 'tachov', 4);
INSERT INTO town VALUES (92, 'Vítkovice', 'vitkovice', 14);
INSERT INTO town VALUES (93, 'Svitavy', 'svitavy', 9);
INSERT INTO town VALUES (94, 'Povážská Bystrica', 'pb.*nextra\\.sk', 16);
INSERT INTO town VALUES (95, 'Banská Bystrica', 'bb.*nextra\\.sk', 16);
INSERT INTO town VALUES (96, 'Humenné', 'hn.*nextra\\.sk', 16);
INSERT INTO town VALUES (97, 'Lučenec', 'lc.*nextra\\.sk', 16);
INSERT INTO town VALUES (98, 'Dunajská Streda', 'ds.*nextra\\.sk', 16);
INSERT INTO town VALUES (99, 'Michalovce', 'mi.*nextra\\.sk', 16);
INSERT INTO town VALUES (100, 'Poprad', 'pp.*nextra\\.sk', 16);
INSERT INTO town VALUES (101, 'Dolný Kubín', 'dk.*nextra\\.sk', 16);
INSERT INTO town VALUES (102, 'Topolčany', 'to.*nextra\\.sk', 16);
INSERT INTO town VALUES (103, 'Nové Zámky', 'nz.*nextra\\.sk', 16);
INSERT INTO town VALUES (104, 'Prievidza', 'pd.*nextra\\.sk', 16);
INSERT INTO town VALUES (105, 'Senica', 'se.*nextra\\.sk', 16);
INSERT INTO town VALUES (106, 'Spišská Nová Ves', 'sn.*nextra\\.sk', 16);
INSERT INTO town VALUES (225, 'GTS (cz)', 'gts.cz', 0);
INSERT INTO town VALUES (107, 'STU Bratislava', 'stuba.sk', 15);
INSERT INTO town VALUES (108, 'Klatovy', 'klatovy', 4);
INSERT INTO town VALUES (226, 'Karneval (cz)', 'karneval\\.cz', 0);
INSERT INTO town VALUES (109, 'Veterinární uni. Brno', 'vfu.cz', 15);
INSERT INTO town VALUES (227, 'Bluetone (cz)', 'bluetone\\.cz', 0);
INSERT INTO town VALUES (228, 'Skynet (cz)', 'skynet\\.cz', 0);