-- phpMyAdmin SQL Dump -- version 2.11.11.3 -- http://www.phpmyadmin.net -- -- Serveur: dev-sympa.cru.fr -- Généré le : Ven 31 Mai 2013 à 16:48 -- Version du serveur: 5.5.30 -- Version de PHP: 5.3.18 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Base de données: `sympa_dv` -- -- -------------------------------------------------------- -- -- Structure de la table `dummy_families` -- CREATE TABLE `dummy_families` ( `email` varchar(100) NOT NULL, `nature` enum('chercheurscnrs','itacnrs','chercheursnoncnrs','itanoncnrs') DEFAULT NULL, `localisation` enum('dr1','dr2','dr3','dr4') DEFAULT NULL, `grade` enum('dr','cr','ige','sc') DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Contenu de la table `dummy_families` -- INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr1', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr1', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr1', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr1', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr1', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr1', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr1', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr1', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr1', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr1', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr1', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr1', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr1', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr1', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr1', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr1', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr1', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr2', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr2', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr2', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr2', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr2', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr2', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr2', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr2', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr2', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr2', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr2', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr2', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr2', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr2', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr2', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr2', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr3', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr3', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr3', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr3', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr3', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr3', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr3', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr3', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr3', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr3', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr3', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr3', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr3', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr3', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr3', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr3', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr4', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr4', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr4', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr4', 'dr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr4', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr4', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr4', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr4', 'cr'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr4', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr4', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr4', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr4', 'ige'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheurscnrs', 'dr4', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itacnrs', 'dr4', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'chercheursnoncnrs', 'dr4', 'sc'); INSERT INTO `dummy_families` VALUES('toto@pipo.pipo', 'itanoncnrs', 'dr4', 'sc');