-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Ven 24 Juin 2011 à 17:02
-- Version du serveur: 5.1.36
-- Version de PHP: 5.2.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Base de données: `portfolio`
--

-- --------------------------------------------------------

--
-- Structure de la table `categorie`
--

CREATE TABLE IF NOT EXISTS `categorie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Contenu de la table `categorie`
--

INSERT INTO `categorie` (`id`, `nom`) VALUES
(1, 'webdesign'),
(2, 'print'),
(3, 'logo'),
(4, 'graphisme'),
(5, 'illustration'),
(6, 'stuff');

-- --------------------------------------------------------

--
-- Structure de la table `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `competence` varchar(250) NOT NULL,
  `experience` varchar(250) NOT NULL,
  `formation` varchar(250) NOT NULL,
  `interets` varchar(250) NOT NULL,
  `photo` varchar(30) NOT NULL,
  `mail` varchar(30) NOT NULL,
  `facebook` varchar(30) NOT NULL,
  `linkedin` varchar(30) NOT NULL,
  `viadeo` varchar(30) NOT NULL,
  `presentation` varchar(1500) NOT NULL,
  `coordonnées` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `contact`
--

INSERT INTO `contact` (`id`, `competence`, `experience`, `formation`, `interets`, `photo`, `mail`, `facebook`, `linkedin`, `viadeo`, `presentation`, `coordonnées`) VALUES
(1, 'TEST COMPETENCES', 'TEST EXPERIENCE', 'TEST FORMATION', 'TEST INTERETS', '', 'pierrefrank.seguineau@gmail.co', 'facebook.com/pierrefrank', '', '', 'TEST PRESENTATIONManhattan est l''un des cinq arrondissements (en anglais borouzzadagiug zcaTEST PRESENTATIONManhattan est l''un des cinq arrondissements (en anglais borouzzadagiug zcaTEST PRESENTATIONManhattan est l''un des cinq arrondissemdea', '');

-- --------------------------------------------------------

--
-- Structure de la table `images`
--

CREATE TABLE IF NOT EXISTS `images` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `item` varchar(50) NOT NULL,
  `extension` varchar(5) NOT NULL,
  `id_categorie` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Contenu de la table `images`
--


-- --------------------------------------------------------

--
-- Structure de la table `items`
--

CREATE TABLE IF NOT EXISTS `items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_modification` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `id_categorie` int(5) NOT NULL,
  `titre` varchar(50) NOT NULL,
  `client` varchar(50) NOT NULL,
  `brief` varchar(500) NOT NULL,
  `description` varchar(1500) NOT NULL,
  `thumb` varchar(50) NOT NULL,
  `image` varchar(50) NOT NULL,
  `audio` varchar(50) NOT NULL,
  `video` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;

--
-- Contenu de la table `items`
--

INSERT INTO `items` (`id`, `date_modification`, `id_categorie`, `titre`, `client`, `brief`, `description`, `thumb`, `image`, `audio`, `video`) VALUES
(2, '0000-00-00 00:00:00', 2, 'titre2', 'client2', 'breif2', 'desc2', 'thumb2', 'image2', 'audio2', 'video2'),
(3, '0000-00-00 00:00:00', 3, 'TITRE 3', 'client 3', 'brief 3', 'desc3', 'thumb3', 'image3', 'audio3', 'video3'),
(4, '0000-00-00 00:00:00', 4, 'titre 4', 'client4', 'breif4', 'desc4', 'thumb4', 'image5', 'audio5', 'video5'),
(5, '0000-00-00 00:00:00', 6, 'titre6', 'client', 'breief6', 'desc6', 'thumb6', 'image6', 'audio6', 'video6'),
(14, '2011-06-24 11:17:46', 4, 'greagera', 'geragh', 'tatrtr', 'thrzt', '', '', '', ''),
(7, '0000-00-00 00:00:00', 5, 'titre5', 'clienT5', 'brief5', 'desc5', 'thumb5', 'images5', 'audio5', 'video5'),
(10, '2011-06-24 09:31:25', 5, 'illustration', 'ME ', 'ah mais ouais', 'au mais ouais', '', '', '', ''),
(15, '2011-06-24 11:17:59', 6, 'rztrh', 'hhhhhht', 'trhhttrh', 'htrtrhtrhtr', '', '', '', ''),
(30, '2011-06-24 13:08:21', 1, '13h', '13kk', 'LOHI', 'lkh', '', '', '', ''),
(31, '2011-06-24 13:37:35', 1, '13h40', 'moi', 'moi', 'moi', '', '', '', '');