gLafay

-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Ven 11 Septembre 2009 à 17:23
-- Version du serveur: 5.1.36
-- Version de PHP: 5.3.0
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
--
-- Base de données: `glafay`
--
 
-- --------------------------------------------------------
 
--
-- Structure de la table `mensurations`
--
 
CREATE TABLE IF NOT EXISTS `mensurations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `cou` smallint(6) NOT NULL,
  `epaules` smallint(6) NOT NULL,
  `poitrine` smallint(6) NOT NULL,
  `taille` smallint(6) NOT NULL,
  `avantbrasg` smallint(6) NOT NULL,
  `avantbrasd` smallint(6) NOT NULL,
  `cuisseg` smallint(6) NOT NULL,
  `cuissed` smallint(6) NOT NULL,
  `molletg` smallint(6) NOT NULL,
  `molletd` smallint(6) NOT NULL,
  `brasg` smallint(6) NOT NULL,
  `brasd` smallint(6) NOT NULL,
  `uid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Contenu de la table `mensurations`
--
 
 
-- --------------------------------------------------------
 
--
-- Structure de la table `seances`
--
 
CREATE TABLE IF NOT EXISTS `seances` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `niv` tinyint(4) NOT NULL,
  `remarques` text NOT NULL,
  `exo1` text NOT NULL,
  `exo2` text NOT NULL,
  `exo3` text NOT NULL,
  `exo4` text NOT NULL,
  `exo5` text NOT NULL,
  `exo6` text NOT NULL,
  `exo7` text NOT NULL,
  `exo8` text NOT NULL,
  `exo9` text NOT NULL,
  `exo10` text NOT NULL,
  `exo11` text NOT NULL,
  `seance` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Contenu de la table `seances`
--
 
 
-- --------------------------------------------------------
 
--
-- Structure de la table `users`
--
 
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pseudo` text NOT NULL,
  `mail` text NOT NULL,
  `password` text NOT NULL,
  `date` date NOT NULL,
  `stat` int(11) NOT NULL,
  `stat_meth` tinyint(1) NOT NULL,
  `avatar` text NOT NULL,
  `sig` text NOT NULL,
  `nb_seances` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
--
-- Contenu de la table `users`
--