-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb5+lenny9
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Sam 26 Mai 2018 à 08:35
-- Version du serveur: 5.0.51
-- Version de PHP: 5.2.6-1+lenny16

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: `annuairedansec`
--

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

--
-- Structure de la table `2agenda`
--

CREATE TABLE IF NOT EXISTS `2agenda` (
  `id` int(11) NOT NULL auto_increment,
  `nom` text NOT NULL,
  `date_debut` date NOT NULL default '0000-00-00',
  `date_fin` date NOT NULL default '0000-00-00',
  `heure_debut` time NOT NULL default '00:00:00',
  `heure_fin` time NOT NULL default '00:00:00',
  `description` text NOT NULL,
  `lieu` text NOT NULL,
  `categorie` int(11) NOT NULL default '0',
  `contact` text NOT NULL,
  `adresse` text NOT NULL,
  `email` text NOT NULL,
  `telephone` text NOT NULL,
  `fax` text NOT NULL,
  `lien` text NOT NULL,
  `url` text NOT NULL,
  `id_user` int(11) NOT NULL default '0',
  `actif` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='XLAgenda - Table principale' AUTO_INCREMENT=1 ;

--
-- Contenu de la table `2agenda`
--

