-- phpMyAdmin SQL Dump -- version 2.8.2.4 -- http://www.phpmyadmin.net -- -- Serveur: localhost:3306 -- Généré le : Mardi 24 Mars 2009 à 21:30 -- Version du serveur: 4.1.21 -- Version de PHP: 5.0.5 -- -- Base de données: `pedigree_utf` -- -- -------------------------------------------------------- -- -- Structure de la table `chiens` -- CREATE TABLE `chiens` ( `Nom` varchar(66) NOT NULL default '', `Pere` varchar(66) default NULL, `Mere` varchar(66) default NULL, `Date` varchar(12) default NULL, `Couleur` varchar(15) default NULL, `Image` varchar(60) default NULL, `Image1` varchar(60) default NULL, `Champion` int(1) default NULL, `Commentaire` varchar(160) default NULL, `Sexe` varchar(8) default NULL, PRIMARY KEY (`Nom`), FULLTEXT KEY `Nom` (`Nom`,`Pere`,`Mere`,`Date`,`Couleur`,`Image`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Structure de la table `avk` -- CREATE TABLE `avk` ( `id` int(11) NOT NULL auto_increment, `reponses` varchar(10) NOT NULL default '0', `smooth` varchar(10) NOT NULL default '0', `annee` int(4) NOT NULL default '0', `value` text NOT NULL, `pourcent` text NOT NULL, `pere` varchar(10) NOT NULL default '0', `mere` varchar(10) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=234 DEFAULT CHARSET=utf8 AUTO_INCREMENT=234 ; -- -------------------------------------------------------- -- -- Structure de la table `lof` -- CREATE TABLE `lof` ( `id` int(11) NOT NULL auto_increment, `smooth` varchar(10) NOT NULL default '0', `rough` varchar(10) NOT NULL default '0', `annee` int(4) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=utf8 AUTO_INCREMENT=58 ; -- -------------------------------------------------------- -- -- Structure de la table `photos` -- CREATE TABLE `photos` ( `total` int(12) NOT NULL default '0', `mdr1` int(12) NOT NULL default '0', `cea` int(12) NOT NULL default '0', `hd` int(12) NOT NULL default '0', `smooth` int(12) NOT NULL default '0', `sw` int(12) NOT NULL default '0', `tri` int(12) NOT NULL default '0', `bm` int(12) NOT NULL default '0', `dark` int(12) NOT NULL default '0', `blan` int(12) NOT NULL default '0', `sm` int(12) NOT NULL default '0', `nb` varchar(2) NOT NULL default '', PRIMARY KEY (`total`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Structure de la table `admin_pedigree` -- CREATE TABLE `admin_pedigree` ( `login` varchar(30) NOT NULL default '', `PASSWORD` varchar(30) NOT NULL default '', PRIMARY KEY (`login`), FULLTEXT KEY `login` (`login`,`PASSWORD`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Structure de la table `redacteurs` -- CREATE TABLE `redacteurs` ( `login` varchar(30) NOT NULL default '', `PASSWORD` varchar(30) NOT NULL default '', PRIMARY KEY (`login`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;