﻿-- 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');
