# phpMyAdmin MySQL-Dump
# version 2.2.2
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# --------------------------------------------------------

#
# Table structure for table `v2_archives`
#

CREATE TABLE v2_archives (
  code int(11) NOT NULL auto_increment,
  annee int(11) NOT NULL default '0',
  mois int(11) NOT NULL default '0',
  vpm int(11) NOT NULL default '0',
  topVis blob NOT NULL,
  topNavOS blob NOT NULL,
  topOS blob NOT NULL,
  topNav blob NOT NULL,
  vph blob NOT NULL,
  topRef blob NOT NULL,
  topDom blob NOT NULL,
  vpj blob NOT NULL,
  PRIMARY KEY  (code),
  KEY annee (annee),
  KEY mois (mois)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `v2_domains`
#

CREATE TABLE v2_domains (
  code int(11) NOT NULL auto_increment,
  domaine char(20) NOT NULL default '',
  description char(50) NOT NULL default '',
  PRIMARY KEY  (code)
) TYPE=MyISAM;
# --------------------------------------------------------

INSERT INTO v2_domains VALUES (1, 'ac', 'Ascension Island');
INSERT INTO v2_domains VALUES (2, 'ad', 'Andorra');
INSERT INTO v2_domains VALUES (3, 'ae', 'United Arab Emirates');
INSERT INTO v2_domains VALUES (4, 'af', 'Afghanistan');
INSERT INTO v2_domains VALUES (5, 'ag', 'Antigua and Barbuda');
INSERT INTO v2_domains VALUES (6, 'ai', 'Anguilla');
INSERT INTO v2_domains VALUES (7, 'al', 'Albania');
INSERT INTO v2_domains VALUES (8, 'am', 'Armenia');
INSERT INTO v2_domains VALUES (9, 'an', 'Netherlands Antilles');
INSERT INTO v2_domains VALUES (10, 'ao', 'Angola');
INSERT INTO v2_domains VALUES (11, 'aq', 'Antartica');
INSERT INTO v2_domains VALUES (12, 'ar', 'Argentina');
INSERT INTO v2_domains VALUES (13, 'as', 'American Samoa');
INSERT INTO v2_domains VALUES (14, 'au', 'Australia');
INSERT INTO v2_domains VALUES (15, 'aw', 'Aruba');
INSERT INTO v2_domains VALUES (16, 'az', 'Azerbaijan');
INSERT INTO v2_domains VALUES (17, 'ba', 'Bosnia and Herzegovina');
INSERT INTO v2_domains VALUES (18, 'bb', 'Barbados');
INSERT INTO v2_domains VALUES (19, 'bd', 'Bangladesh');
INSERT INTO v2_domains VALUES (20, 'be', 'Belgium');
INSERT INTO v2_domains VALUES (21, 'bf', 'Burkina Faso');
INSERT INTO v2_domains VALUES (22, 'bg', 'Bulgaria');
INSERT INTO v2_domains VALUES (23, 'bh', 'Bahrain');
INSERT INTO v2_domains VALUES (24, 'bi', 'Burundi');
INSERT INTO v2_domains VALUES (25, 'bj', 'Benin');
INSERT INTO v2_domains VALUES (26, 'bm', 'Bermuda');
INSERT INTO v2_domains VALUES (27, 'bn', 'Brunei Darussalam');
INSERT INTO v2_domains VALUES (28, 'bo', 'Bolivia');
INSERT INTO v2_domains VALUES (29, 'br', 'Brazil');
INSERT INTO v2_domains VALUES (30, 'bs', 'Bahamas');
INSERT INTO v2_domains VALUES (31, 'bt', 'Bhutan');
INSERT INTO v2_domains VALUES (32, 'bv', 'Bouvet Island');
INSERT INTO v2_domains VALUES (33, 'bw', 'Botswana');
INSERT INTO v2_domains VALUES (34, 'by', 'Belarus');
INSERT INTO v2_domains VALUES (35, 'bz', 'Belize');
INSERT INTO v2_domains VALUES (36, 'ca', 'Canada');
INSERT INTO v2_domains VALUES (37, 'cc', 'Cocos (Keeling) Islands');
INSERT INTO v2_domains VALUES (38, 'cd', 'Congo, Democratic People\'s Republic');
INSERT INTO v2_domains VALUES (39, 'cf', 'Central African Republic');
INSERT INTO v2_domains VALUES (40, 'cg', 'Congo, Republic of');
INSERT INTO v2_domains VALUES (41, 'ch', 'Switzerland');
INSERT INTO v2_domains VALUES (42, 'ci', 'Cote d\'Ivoire');
INSERT INTO v2_domains VALUES (43, 'ck', 'Cook Islands');
INSERT INTO v2_domains VALUES (44, 'cl', 'Chile');
INSERT INTO v2_domains VALUES (45, 'cm', 'Cameroon');
INSERT INTO v2_domains VALUES (46, 'cn', 'China');
INSERT INTO v2_domains VALUES (47, 'co', 'Colombia');
INSERT INTO v2_domains VALUES (48, 'cr', 'Costa Rica');
INSERT INTO v2_domains VALUES (49, 'cu', 'Cuba');
INSERT INTO v2_domains VALUES (50, 'cv', 'Cap Verde');
INSERT INTO v2_domains VALUES (51, 'cx', 'Christmas Island');
INSERT INTO v2_domains VALUES (52, 'cy', 'Cyprus');
INSERT INTO v2_domains VALUES (53, 'cz', 'Czech Republic');
INSERT INTO v2_domains VALUES (54, 'de', 'Germany');
INSERT INTO v2_domains VALUES (55, 'dj', 'Djibouti');
INSERT INTO v2_domains VALUES (56, 'dk', 'Denmark');
INSERT INTO v2_domains VALUES (57, 'dm', 'Dominica');
INSERT INTO v2_domains VALUES (58, 'do', 'Dominican Republic');
INSERT INTO v2_domains VALUES (59, 'dz', 'Algeria');
INSERT INTO v2_domains VALUES (60, 'ec', 'Ecuador');
INSERT INTO v2_domains VALUES (61, 'ee', 'Estonia');
INSERT INTO v2_domains VALUES (62, 'eg', 'Egypt');
INSERT INTO v2_domains VALUES (63, 'eh', 'Western Sahara');
INSERT INTO v2_domains VALUES (64, 'er', 'Eritrea');
INSERT INTO v2_domains VALUES (65, 'es', 'Spain');
INSERT INTO v2_domains VALUES (66, 'et', 'Ethiopia');
INSERT INTO v2_domains VALUES (67, 'fi', 'Finland');
INSERT INTO v2_domains VALUES (68, 'fj', 'Fiji');
INSERT INTO v2_domains VALUES (69, 'fk', 'Falkland Islands (Malvina)');
INSERT INTO v2_domains VALUES (70, 'fm', 'Micronesia, Federal State of');
INSERT INTO v2_domains VALUES (71, 'fo', 'Faroe Islands');
INSERT INTO v2_domains VALUES (72, 'fr', 'France');
INSERT INTO v2_domains VALUES (73, 'ga', 'Gabon');
INSERT INTO v2_domains VALUES (74, 'gd', 'Grenada');
INSERT INTO v2_domains VALUES (75, 'ge', 'Georgia');
INSERT INTO v2_domains VALUES (76, 'gf', 'French Guiana');
INSERT INTO v2_domains VALUES (77, 'gg', 'Guernsey');
INSERT INTO v2_domains VALUES (78, 'gh', 'Ghana');
INSERT INTO v2_domains VALUES (79, 'gi', 'Gibraltar');
INSERT INTO v2_domains VALUES (80, 'gl', 'Greenland');
INSERT INTO v2_domains VALUES (81, 'gm', 'Gambia');
INSERT INTO v2_domains VALUES (82, 'gn', 'Guinea');
INSERT INTO v2_domains VALUES (83, 'gp', 'Guadeloupe');
INSERT INTO v2_domains VALUES (84, 'gq', 'Equatorial Guinea');
INSERT INTO v2_domains VALUES (85, 'gr', 'Greece');
INSERT INTO v2_domains VALUES (86, 'gs', 'South Georgia and the South Sandwich Islands');
INSERT INTO v2_domains VALUES (87, 'gt', 'Guatemala');
INSERT INTO v2_domains VALUES (88, 'gu', 'Guam');
INSERT INTO v2_domains VALUES (89, 'gw', 'Guinea-Bissau');
INSERT INTO v2_domains VALUES (90, 'gy', 'Guyana');
INSERT INTO v2_domains VALUES (91, 'hk', 'Hong Kong');
INSERT INTO v2_domains VALUES (92, 'hm', 'Heard and McDonald Islands');
INSERT INTO v2_domains VALUES (93, 'hn', 'Honduras');
INSERT INTO v2_domains VALUES (94, 'hr', 'Croatia/Hrvatska');
INSERT INTO v2_domains VALUES (95, 'ht', 'Haiti');
INSERT INTO v2_domains VALUES (96, 'hu', 'Hungary');
INSERT INTO v2_domains VALUES (97, 'id', 'Indonesia');
INSERT INTO v2_domains VALUES (98, 'ie', 'Ireland');
INSERT INTO v2_domains VALUES (99, 'il', 'Israel');
INSERT INTO v2_domains VALUES (100, 'im', 'Isle of Man');
INSERT INTO v2_domains VALUES (101, 'in', 'India');
INSERT INTO v2_domains VALUES (102, 'io', 'British Indian Ocean Territory');
INSERT INTO v2_domains VALUES (103, 'iq', 'Iraq');
INSERT INTO v2_domains VALUES (104, 'ir', 'Iran (Islamic Republic of)');
INSERT INTO v2_domains VALUES (105, 'is', 'Iceland');
INSERT INTO v2_domains VALUES (106, 'it', 'Italy');
INSERT INTO v2_domains VALUES (107, 'je', 'Jersey');
INSERT INTO v2_domains VALUES (108, 'jm', 'Jamaica');
INSERT INTO v2_domains VALUES (109, 'jo', 'Jordan');
INSERT INTO v2_domains VALUES (110, 'jp', 'Japan');
INSERT INTO v2_domains VALUES (111, 'ke', 'Kenya');
INSERT INTO v2_domains VALUES (112, 'kg', 'Kyrgyzstan');
INSERT INTO v2_domains VALUES (113, 'kh', 'Cambodia');
INSERT INTO v2_domains VALUES (114, 'ki', 'Kiribati');
INSERT INTO v2_domains VALUES (115, 'km', 'Comoros');
INSERT INTO v2_domains VALUES (116, 'kn', 'Saint Kitts and Nevis');
INSERT INTO v2_domains VALUES (117, 'kp', 'Korea, Democratic People\'s Republic');
INSERT INTO v2_domains VALUES (118, 'kr', 'Korea, Republic of');
INSERT INTO v2_domains VALUES (119, 'kw', 'Kuwait');
INSERT INTO v2_domains VALUES (120, 'ky', 'Cayman Islands');
INSERT INTO v2_domains VALUES (121, 'kz', 'Kazakhstan');
INSERT INTO v2_domains VALUES (122, 'la', 'Lao, People\'s Democratic Republic');
INSERT INTO v2_domains VALUES (123, 'lb', 'Lebanon');
INSERT INTO v2_domains VALUES (124, 'lc', 'Saint Lucia');
INSERT INTO v2_domains VALUES (125, 'li', 'Liechtenstein');
INSERT INTO v2_domains VALUES (126, 'lk', 'Sri Lanka');
INSERT INTO v2_domains VALUES (127, 'lr', 'Liberia');
INSERT INTO v2_domains VALUES (128, 'ls', 'Lesotho');
INSERT INTO v2_domains VALUES (129, 'lt', 'Lithuania');
INSERT INTO v2_domains VALUES (130, 'lu', 'Luxembourg');
INSERT INTO v2_domains VALUES (131, 'lv', 'Latvia');
INSERT INTO v2_domains VALUES (132, 'ly', 'Libyan Arab Jamahiriya');
INSERT INTO v2_domains VALUES (133, 'ma', 'Morocco');
INSERT INTO v2_domains VALUES (134, 'mc', 'Monaco');
INSERT INTO v2_domains VALUES (135, 'md', 'Moldova, Republic of');
INSERT INTO v2_domains VALUES (136, 'mg', 'Madagascar');
INSERT INTO v2_domains VALUES (137, 'mh', 'Marshall Islands');
INSERT INTO v2_domains VALUES (138, 'mk', 'Macedonia, Former Yugoslav Republic');
INSERT INTO v2_domains VALUES (139, 'ml', 'Mali');
INSERT INTO v2_domains VALUES (140, 'mm', 'Myanmar');
INSERT INTO v2_domains VALUES (141, 'mn', 'Mongolia');
INSERT INTO v2_domains VALUES (142, 'mo', 'Macau');
INSERT INTO v2_domains VALUES (143, 'mp', 'Northern Mariana Islands');
INSERT INTO v2_domains VALUES (144, 'mq', 'Martinique');
INSERT INTO v2_domains VALUES (145, 'mr', 'Mauritania');
INSERT INTO v2_domains VALUES (146, 'ms', 'Montserrat');
INSERT INTO v2_domains VALUES (147, 'mt', 'Malta');
INSERT INTO v2_domains VALUES (148, 'mu', 'Mauritius');
INSERT INTO v2_domains VALUES (149, 'mv', 'Maldives');
INSERT INTO v2_domains VALUES (150, 'mw', 'Malawi');
INSERT INTO v2_domains VALUES (151, 'mx', 'Mexico');
INSERT INTO v2_domains VALUES (152, 'my', 'Malaysia');
INSERT INTO v2_domains VALUES (153, 'mz', 'Mozambique');
INSERT INTO v2_domains VALUES (154, 'na', 'Namibia');
INSERT INTO v2_domains VALUES (155, 'nc', 'New Caledonia');
INSERT INTO v2_domains VALUES (156, 'ne', 'Niger');
INSERT INTO v2_domains VALUES (157, 'nf', 'Norfolk Island');
INSERT INTO v2_domains VALUES (158, 'ng', 'Nigeria');
INSERT INTO v2_domains VALUES (159, 'ni', 'Nicaragua');
INSERT INTO v2_domains VALUES (160, 'nl', 'Netherlands');
INSERT INTO v2_domains VALUES (161, 'no', 'Norway');
INSERT INTO v2_domains VALUES (162, 'np', 'Nepal');
INSERT INTO v2_domains VALUES (163, 'nr', 'Nauru');
INSERT INTO v2_domains VALUES (164, 'nu', 'Niue');
INSERT INTO v2_domains VALUES (165, 'nz', 'New Zealand');
INSERT INTO v2_domains VALUES (166, 'om', 'Oman');
INSERT INTO v2_domains VALUES (167, 'pa', 'Panama');
INSERT INTO v2_domains VALUES (168, 'pe', 'Peru');
INSERT INTO v2_domains VALUES (169, 'pf', 'French Polynesia');
INSERT INTO v2_domains VALUES (170, 'pg', 'Papua New Guinea');
INSERT INTO v2_domains VALUES (171, 'ph', 'Philippines');
INSERT INTO v2_domains VALUES (172, 'pk', 'Pakistan');
INSERT INTO v2_domains VALUES (173, 'pl', 'Poland');
INSERT INTO v2_domains VALUES (174, 'pm', 'St. Pierre and Miquelon');
INSERT INTO v2_domains VALUES (175, 'pn', 'Pitcairn Island');
INSERT INTO v2_domains VALUES (176, 'pr', 'Puerto Rico');
INSERT INTO v2_domains VALUES (177, 'pt', 'Portugal');
INSERT INTO v2_domains VALUES (178, 'pw', 'Palau');
INSERT INTO v2_domains VALUES (179, 'py', 'Paraguay');
INSERT INTO v2_domains VALUES (180, 'qa', 'Qatar');
INSERT INTO v2_domains VALUES (181, 're', 'Reunion Island');
INSERT INTO v2_domains VALUES (182, 'ro', 'Romania');
INSERT INTO v2_domains VALUES (183, 'ru', 'Russian Federation');
INSERT INTO v2_domains VALUES (184, 'rw', 'Rwanda');
INSERT INTO v2_domains VALUES (185, 'sa', 'Saudi Arabia');
INSERT INTO v2_domains VALUES (186, 'sb', 'Solomon Islands');
INSERT INTO v2_domains VALUES (187, 'sc', 'Seychelles');
INSERT INTO v2_domains VALUES (188, 'sd', 'Sudan');
INSERT INTO v2_domains VALUES (189, 'se', 'Sweden');
INSERT INTO v2_domains VALUES (190, 'sg', 'Singapore');
INSERT INTO v2_domains VALUES (191, 'sh', 'St. Helena');
INSERT INTO v2_domains VALUES (192, 'si', 'Slovenia');
INSERT INTO v2_domains VALUES (193, 'sj', 'Svalbard and Jan Mayen Islands');
INSERT INTO v2_domains VALUES (194, 'sk', 'Slovak Republic');
INSERT INTO v2_domains VALUES (195, 'sl', 'Sierra Leone');
INSERT INTO v2_domains VALUES (196, 'sm', 'San Marino');
INSERT INTO v2_domains VALUES (197, 'sn', 'Senegal');
INSERT INTO v2_domains VALUES (198, 'so', 'Somalia');
INSERT INTO v2_domains VALUES (199, 'sr', 'Suriname');
INSERT INTO v2_domains VALUES (200, 'st', 'Sao Tome and Principe');
INSERT INTO v2_domains VALUES (201, 'sv', 'El Salvador');
INSERT INTO v2_domains VALUES (202, 'sy', 'Syrian Arab Republic');
INSERT INTO v2_domains VALUES (203, 'sz', 'Swaziland');
INSERT INTO v2_domains VALUES (204, 'tc', 'Turks and Ciacos Islands');
INSERT INTO v2_domains VALUES (205, 'td', 'Chad');
INSERT INTO v2_domains VALUES (206, 'tf', 'French Southern Territories');
INSERT INTO v2_domains VALUES (207, 'tg', 'Togo');
INSERT INTO v2_domains VALUES (208, 'th', 'Thailand');
INSERT INTO v2_domains VALUES (209, 'tj', 'Tajikistan');
INSERT INTO v2_domains VALUES (210, 'tk', 'Tokelau');
INSERT INTO v2_domains VALUES (211, 'tm', 'Turkmenistan');
INSERT INTO v2_domains VALUES (212, 'tn', 'Tunisia');
INSERT INTO v2_domains VALUES (213, 'to', 'Tonga');
INSERT INTO v2_domains VALUES (214, 'tp', 'East Timor');
INSERT INTO v2_domains VALUES (215, 'tr', 'Turkey');
INSERT INTO v2_domains VALUES (216, 'tt', 'Trinidad and Tobago');
INSERT INTO v2_domains VALUES (217, 'tv', 'Tuvalu');
INSERT INTO v2_domains VALUES (218, 'tw', 'Taiwan');
INSERT INTO v2_domains VALUES (219, 'tz', 'Tanzania');
INSERT INTO v2_domains VALUES (220, 'ua', 'Ukraine');
INSERT INTO v2_domains VALUES (221, 'ug', 'Uganda');
INSERT INTO v2_domains VALUES (222, 'uk', 'United Kingdom');
INSERT INTO v2_domains VALUES (223, 'gb', 'United Kingdom');
INSERT INTO v2_domains VALUES (224, 'um', 'US Minor Outlying Islands');
INSERT INTO v2_domains VALUES (225, 'us', 'United States');
INSERT INTO v2_domains VALUES (226, 'uy', 'Uruguay');
INSERT INTO v2_domains VALUES (227, 'uz', 'Uzbekistan');
INSERT INTO v2_domains VALUES (228, 'va', 'Holy See (City Vatican State)');
INSERT INTO v2_domains VALUES (229, 'vc', 'Saint Vincent and the Grenadines');
INSERT INTO v2_domains VALUES (230, 've', 'Venezuela');
INSERT INTO v2_domains VALUES (231, 'vg', 'Virgin Islands (British)');
INSERT INTO v2_domains VALUES (232, 'vi', 'Virgin Islands (USA)');
INSERT INTO v2_domains VALUES (233, 'vn', 'Vietnam');
INSERT INTO v2_domains VALUES (234, 'vu', 'Vanuatu');
INSERT INTO v2_domains VALUES (235, 'wf', 'Wallis and Futuna Islands');
INSERT INTO v2_domains VALUES (236, 'ws', 'Western Samoa');
INSERT INTO v2_domains VALUES (237, 'ye', 'Yemen');
INSERT INTO v2_domains VALUES (238, 'yt', 'Mayotte');
INSERT INTO v2_domains VALUES (239, 'yu', 'Yugoslavia');
INSERT INTO v2_domains VALUES (240, 'za', 'South Africa');
INSERT INTO v2_domains VALUES (241, 'zm', 'Zambia');
INSERT INTO v2_domains VALUES (242, 'zr', 'Zaire');
INSERT INTO v2_domains VALUES (243, 'zw', 'Zimbabwe');
INSERT INTO v2_domains VALUES (244, 'com', '-');
INSERT INTO v2_domains VALUES (245, 'net', '-');
INSERT INTO v2_domains VALUES (246, 'org', '-');
INSERT INTO v2_domains VALUES (247, 'edu', '-');
INSERT INTO v2_domains VALUES (248, 'int', '-');
INSERT INTO v2_domains VALUES (249, 'arpa', '-');
INSERT INTO v2_domains VALUES (250, 'at', 'Austria');
INSERT INTO v2_domains VALUES (251, 'gov', 'Governement');
INSERT INTO v2_domains VALUES (252, 'mil', 'Miltary');
INSERT INTO v2_domains VALUES (253, 'su', 'Ex U.S.R.R.');
INSERT INTO v2_domains VALUES (254, 'reverse', '-');


#
# Table structure for table `v2_visitors`
#

CREATE TABLE v2_visitors (
  AGENT char(100) default NULL,
  REFERER char(200) default NULL,
  ADDR char(50) NOT NULL default '',
  DATE char(20) default NULL,
  HOST char(100) default NULL,
  CODE int(11) NOT NULL auto_increment,
  REF_HOST char(100) default NULL,
  PRIMARY KEY  (CODE),
  KEY ADDR (ADDR)
) TYPE=MyISAM;