-- phpMyAdmin SQL Dump
-- version 2.11.3deb1ubuntu1.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Jeu 14 Mai 2009 à 12:05
-- Version du serveur: 5.0.51
-- Version de PHP: 5.2.4-2ubuntu5.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

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

--
-- Structure de la table `categoriesPresta`
--

CREATE TABLE IF NOT EXISTS `categoriesPresta` (
  `idCategorie` smallint(5) unsigned NOT NULL,
  `description` varchar(50) NOT NULL,
  PRIMARY KEY  (`idCategorie`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `groupesPresta`
--

CREATE TABLE IF NOT EXISTS `groupesPresta` (
  `idGroupe` smallint(5) unsigned NOT NULL,
  `description` varchar(50) NOT NULL,
  PRIMARY KEY  (`idGroupe`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `prestaDisponibilite`
--

CREATE TABLE IF NOT EXISTS `prestaDisponibilite` (
  `idPrestation` int(10) unsigned NOT NULL,
  `numJour` smallint(5) unsigned NOT NULL,
  `etat` tinyint(3) unsigned NOT NULL,
  KEY `idPrestation` (`idPrestation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `prestaOuverture`
--

CREATE TABLE IF NOT EXISTS `prestaOuverture` (
  `idPrestation` int(10) unsigned NOT NULL,
  `numJour` smallint(5) unsigned NOT NULL,
  `etat` tinyint(3) unsigned NOT NULL,
  KEY `idPrestation` (`idPrestation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `prestataires`
--

CREATE TABLE IF NOT EXISTS `prestataires` (
  `idPrestataire` int(10) unsigned NOT NULL,
  `enseigne` varchar(50) default NULL,
  `raisonSociale` varchar(50) default NULL,
  `siret` varchar(14) default NULL,
  `prestaAdrRueNom` varchar(20) default NULL,
  `prestaAdrRueNum` varchar(5) default NULL,
  `prestaAdrLieuDit` varchar(20) default NULL,
  `prestaAdrVille` smallint(5) unsigned default NULL,
  `prestaTel` varchar(10) default NULL,
  `prestaPort` varchar(10) default NULL,
  `prestaFax` varchar(10) default NULL,
  `prestaMail` varchar(150) default NULL,
  `prestaSite` varchar(150) default NULL,
  `gerantAdrRueNom` varchar(20) default NULL,
  `gerantAdrRueNum` varchar(5) default NULL,
  `gerantAdrLieuDit` varchar(20) default NULL,
  `gerantAdrVille` smallint(5) unsigned default NULL,
  `gerantTel` varchar(10) default NULL,
  `gerantPort` varchar(10) default NULL,
  `gerantFax` varchar(10) default NULL,
  `gerantMail` varchar(150) default NULL,
  `gerantSite` varchar(150) default NULL,
  KEY `idPrestataire` (`idPrestataire`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `prestation2pictos`
--

CREATE TABLE IF NOT EXISTS `prestation2pictos` (
  `idPrestation` int(10) unsigned NOT NULL,
  `idPicto` smallint(5) unsigned NOT NULL,
  KEY `idPrestation` (`idPrestation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `prestation2sousCategories`
--

CREATE TABLE IF NOT EXISTS `prestation2sousCategories` (
  `idPrestation` int(10) unsigned NOT NULL,
  `idSCat` smallint(5) unsigned NOT NULL,
  KEY `idPrestation` (`idPrestation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `prestations`
--

CREATE TABLE IF NOT EXISTS `prestations` (
  `idPrestation` int(10) unsigned NOT NULL,
  `lastupdate` datetime NOT NULL,
  `categorie` smallint(5) unsigned NOT NULL,
  `groupe` smallint(5) unsigned NOT NULL,
  `idPrestataire` int(10) unsigned default NULL,
  `nom` varchar(150) NOT NULL,
  `adrRueNom` varchar(20) default NULL,
  `adrRueNum` varchar(5) default NULL,
  `adrLieuDit` varchar(20) default NULL,
  `adrVille` smallint(6) default NULL,
  `tel` varchar(10) default NULL,
  `port` varchar(10) default NULL,
  `fax` varchar(10) default NULL,
  `mail` varchar(50) default NULL,
  `site` varchar(50) default NULL,
  `comment` text,
  `nbchambres` smallint(6) default NULL,
  `nbemplacements` smallint(6) default NULL,
  `piscinechauffee` tinyint(1) default NULL,
  `xml` text,
  KEY `idPrestation` (`idPrestation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `sousCategoriesPresta`
--

CREATE TABLE IF NOT EXISTS `sousCategoriesPresta` (
  `idSousCategorie` smallint(5) unsigned NOT NULL,
  `idMere` smallint(5) NOT NULL,
  `description` varchar(50) NOT NULL,
  PRIMARY KEY  (`idSousCategorie`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `villes`
--

CREATE TABLE IF NOT EXISTS `villes` (
  `idVille` tinyint(3) unsigned NOT NULL auto_increment,
  `idVilleACVS` int(10) unsigned default NULL,
  `cp` varchar(5) default NULL,
  `insee` varchar(5) default NULL,
  `nom` varchar(20) NOT NULL,
  `pays` varchar(10) default NULL,
  PRIMARY KEY  (`idVille`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;