-- phpMyAdmin SQL Dump -- version 3.2.0.1 -- http://www.phpmyadmin.net -- -- Serveur: localhost -- Généré le : Dim 15 Novembre 2009 à 23:12 -- Version du serveur: 5.1.30 -- Version de PHP: 5.2.8 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Base de données: `test` -- -- -------------------------------------------------------- -- -- Structure de la table `admin` -- CREATE TABLE IF NOT EXISTS `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user` int(11) NOT NULL, `droit` tinytext NOT NULL, `acces` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `user` (`user`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Contenu de la table `admin` -- INSERT INTO `admin` (`id`, `user`, `droit`, `acces`) VALUES (1, 1, '/admin', 2), (5, 1, '/user', 2), (6, 2, '/admin', 1); -- -------------------------------------------------------- -- -- Structure de la table `config` -- CREATE TABLE IF NOT EXISTS `config` ( `key` varchar(100) NOT NULL, `value` tinytext NOT NULL, `description` text NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Contenu de la table `config` -- -- -------------------------------------------------------- -- -- Structure de la table `installed` -- CREATE TABLE IF NOT EXISTS `installed` ( `name` varchar(40) NOT NULL, `type` set('mod','widget','core') NOT NULL, `depends` text NOT NULL, `parent` varchar(40) NOT NULL, `descript` text NOT NULL, `name_clean` varchar(40) NOT NULL, `author` varchar(40) NOT NULL, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Contenu de la table `installed` -- INSERT INTO `installed` (`name`, `type`, `depends`, `parent`, `descript`, `name_clean`, `author`) VALUES ('admin', 'mod', 'user', 'admin', '', '', ''), ('alert', 'core', '', '', 'Gestion des alertes', 'core_alert', 'bontiv'), ('mod1', 'mod', 'mod2', '', '', '', ''), ('mod2', 'mod', 'mod3, mod5', '', '', '', ''), ('mod4', 'mod', '', '', '', '', ''), ('mod5', 'mod', '', '', '', '', ''), ('module', 'core', '', '', 'Gestion des modules', 'core_module', 'Bontiv'), ('session', 'core', '', '', 'Gestion des sessions utilisateur', 'core_session', 'Bontiv'), ('sql', 'core', '', '', 'DB Driver', 'core_sql', 'Bontiv'), ('template', 'core', '', '', 'Gestion des templates.', 'core_template', 'Bontiv'), ('UrlAnalyse', 'core', '', '', 'Decryptage d''url', 'core_url', 'Bontiv'), ('user', 'mod', '', '', '', '', ''); -- -------------------------------------------------------- -- -- Structure de la table `session` -- CREATE TABLE IF NOT EXISTS `session` ( `sessid` varchar(64) NOT NULL, `date` int(11) NOT NULL, `ip` varchar(15) NOT NULL, `useragent` tinytext NOT NULL, `user` int(11) NOT NULL, `var` text NOT NULL, `request` tinytext NOT NULL, PRIMARY KEY (`sessid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Contenu de la table `session` -- INSERT INTO `session` (`sessid`, `date`, `ip`, `useragent`, `user`, `var`, `request`) VALUES ('051e30c7a9e87c75560e5be5ad9f9e30dcbfca89adcf73c7b842645bdda42cb2', 1256219316, '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729)', 0, '/', ''), ('26789a2e8a81c7b0a5d82918b2c0e0ebebf725cf6bda94f0736598f4865d4ade', 1255333389, '163.5.255.62', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9) Gecko/2008052906 Firefox/3.0', 0, '/', '/user'), ('36cc0c737b99bfd66866532b5a7489772d659a2fb2df741aa32c186cfff95118', 1258323073, '192.168.1.4', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5 (.NET CLR 3.5.30729)', 2, ';tentative;captcha/;0;9990B', '/'), ('3aa08c54271a64aaee50fa8ef75603fbb78b218fad815a1f74228567824347b1', 1258282471, '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5 (.NET CLR 3.5.30729)', 0, '/', ''), ('70a8a0dce4f24f3532dca755271c5bc3d15abc56c6974505a97b6a0d173e1178', 1256228303, '192.168.1.4', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729)', 1, ';tentative/;0', '/admin/admin/'), ('8a5a3006e0c23010ced8d04d11d08f96738d49ed81eff60de02e4e7ceeb29c73', 1255190194, '192.168.1.3', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; fr; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729)', 1, ';tentative;captcha/;0;570AB', '/mod1/'); -- -------------------------------------------------------- -- -- Structure de la table `user` -- CREATE TABLE IF NOT EXISTS `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pseudo` varchar(30) NOT NULL, `login` varchar(30) NOT NULL, `tentative` int(11) NOT NULL DEFAULT '0', `cookie_pwd` varchar(64) NOT NULL, `pwd` varchar(64) NOT NULL, `email` varchar(50) NOT NULL, `MSN` varchar(50) NOT NULL DEFAULT '', `Skype` varchar(30) NOT NULL DEFAULT '', `inscript` datetime NOT NULL, `last` datetime NOT NULL, `useragent` tinytext NOT NULL, `naissance` date NOT NULL, `activate` varchar(32) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Contenu de la table `user` -- INSERT INTO `user` (`id`, `pseudo`, `login`, `tentative`, `cookie_pwd`, `pwd`, `email`, `MSN`, `Skype`, `inscript`, `last`, `useragent`, `naissance`, `activate`) VALUES (1, 'bontiv', 'bontiv', 0, '', '0511abcb24917aec1ef5f0469c3017a6010036ef8237372d3ec75c83f27b91bb', 'prog.bontiv@gmail.com', 'remibonnet@msn.com', 'bontiv', '2009-10-10 15:06:54', '0000-00-00 00:00:00', 'Mozilla/5.0 (Windows; U; Windows NT 6.0; fr; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729)', '1999-07-30', 'c6c3ea1738eeb9bd02bf9c0c1cf548b8'), (2, 'testimon', 'test', 0, '', '5bd03dbf8b02d1a33056e07d33ba4ef08eacd7776f2d6c05b73ec4f3725c1527', 'prog.bontiv2@gmail.com', '', '', '2009-11-15 16:51:59', '0000-00-00 00:00:00', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5 (.NET CLR 3.5.30729)', '1841-06-30', 'db168a79cdea5ca5038ae5b2b7cf05bc');