1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| -- phpMyAdmin SQL Dump
-- version OVH
-- http://www.phpmyadmin.net
--
-- Serveur: mysqlxxx
-- Généré le : Dim 19 Avril 2009 à 12:17
-- Version du serveur: 5.0.68
-- Version de PHP: 4.4.9
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Base de données: `xxxxxxx`
--
-- --------------------------------------------------------
--
-- Structure de la table `xxx_logs`
--
CREATE TABLE IF NOT EXISTS `xxx_test` (
`c_id` smallint(5) NOT NULL auto_increment,
`c_pseudo` varchar(50) collate utf8_unicode_ci NOT NULL,
`c_dtConnect` datetime NOT NULL,
`c_pgCode` varchar(100) collate utf8_unicode_ci default NULL,
`c_ip` varchar(20) collate utf8_unicode_ci default NULL,
`c_client` varchar(50) collate utf8_unicode_ci default NULL,
`c_url` varchar(150) collate utf8_unicode_ci default NULL,
`c_urlParent` varchar(150) collate utf8_unicode_ci default NULL,
`c_sessid` varchar(50) collate utf8_unicode_ci default NULL,
`c_nav` text collate utf8_unicode_ci,
PRIMARY KEY (`c_id`),
KEY `c_pseudo` (`c_pseudo`),
KEY `c_dtConnect` (`c_dtConnect`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Contenu de la table `xxx_test`
--
INSERT INTO `xxx_test` (`c_pseudo`, `c_dtConnect`, `c_pgCode`, `c_ip`, `c_client`, `c_url`, `c_urlParent`, `c_sessid`, `c_nav`) VALUES
('wally', '2009-04-07 19:48:50', 'Boutique', '90.33.169.94', 'ANancy-256-1-130-94.w90-33.abo.wanadoo.fr', '/boutique/pgBoutique01.php', 'http://www.vieuxchateaudevolkrange.com/index.php', '5e18e05220e30976bf9cfb710bc80e4b', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Orange 7.4 ; NaviWoo1.1; AntivirXP08; i-NavFourF; .NET CLR 1.1.4322; .NET CLR 2.0.50727)'),
('d', '2009-03-29 11:36:17', 'Scolaire', '92.138.199.150', 'ANancy-552-1-32-150.w92-138.abo.wanadoo.fr', '/scolaires/pgNature01.php', 'page nav', 'b5dd1bd1d55500f135cc193a94ea3895', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Orange 8.0; GTB5; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)'),
('d', '2009-03-29 11:34:42', 'page de garde', '92.138.199.150', 'ANancy-552-1-32-150.w92-138.abo.wanadoo.fr', '/index.php?$choix_col3=4&$code_aff=4', 'http://www.vieuxchateaudevolkrange.com/index.php?$choix_col3=2&$code_aff=2', 'b5dd1bd1d55500f135cc193a94ea3895', 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; Orange 8.0; GTB5; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)'),
('invit', '2009-04-19 11:59:59', 'Index', '80.185.73.82', '82.73.185-80.rev.gaoland.net', '/', 'http://www.google.fr/search?source=ig&hl=fr&rlz=1G1GGLQ_FRFR255&=&q=chateau+de+volkrange&btnG=Recherche+Google&meta=lr%3D&aq=0&oq=chateau+de+vol', '96755f508c3d87190d305b18488d41bf', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.0.8) Gecko/2009032609 Firefox/3.0.8 (.NET CLR 3.5.30729)'); |
Partager