1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101
| -- phpMyAdmin SQL Dump
-- version 2.10.3deb1ubuntu0.1
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Mer 30 Janvier 2008 à 15:21
-- Version du serveur: 5.0.45
-- Version de PHP: 5.2.3-1ubuntu6.2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Base de données: `agendaor`
--
-- --------------------------------------------------------
--
-- Structure de la table `admin`
--
CREATE TABLE IF NOT EXISTS `admin` (
`pseudo` varchar(100) collate latin1_general_ci NOT NULL default '',
`passe` varchar(20) collate latin1_general_ci NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--
-- Contenu de la table `admin`
--
INSERT INTO `admin` (`pseudo`, `passe`) VALUES
('jackyPseudo', 'jackyPasse'),
('xav', 'xav'),
('jacky', 'etoile');
-- --------------------------------------------------------
--
-- Structure de la table `personne`
--
CREATE TABLE IF NOT EXISTS `personne` (
`idPersonne` tinyint(11) NOT NULL auto_increment,
`mailF` varchar(250) collate latin1_general_ci NOT NULL default '',
`mailH` varchar(250) collate latin1_general_ci NOT NULL default '',
`nomEntreprise` varchar(250) collate latin1_general_ci NOT NULL default '',
`nomF` varchar(100) collate latin1_general_ci NOT NULL default '',
`nomH` varchar(100) collate latin1_general_ci NOT NULL default '',
`prenomF` varchar(100) collate latin1_general_ci NOT NULL default '',
`prenomH` varchar(100) collate latin1_general_ci NOT NULL default '',
`marie` varchar(3) collate latin1_general_ci NOT NULL,
`commentaire` text collate latin1_general_ci NOT NULL,
`adresse` varchar(250) collate latin1_general_ci NOT NULL default '',
`codePostal` varchar(20) collate latin1_general_ci NOT NULL,
`ville` varchar(200) collate latin1_general_ci NOT NULL,
`telDomicile` varchar(20) collate latin1_general_ci NOT NULL default '',
`telPortable` varchar(20) collate latin1_general_ci NOT NULL default '',
`telBureau` varchar(20) collate latin1_general_ci NOT NULL default '',
`gardeF` varchar(3) collate latin1_general_ci NOT NULL,
`gardeH` varchar(3) collate latin1_general_ci NOT NULL,
`dateNaissanceF` varchar(20) collate latin1_general_ci NOT NULL default '',
`dateNaissanceH` varchar(20) collate latin1_general_ci NOT NULL default '',
`nombreEnfantH` varchar(30) collate latin1_general_ci NOT NULL,
`nombreEnfantF` varchar(30) collate latin1_general_ci NOT NULL,
`proffessionF` varchar(100) collate latin1_general_ci NOT NULL default '',
`proffessionH` varchar(100) collate latin1_general_ci NOT NULL default '',
`anglais` varchar(100) collate latin1_general_ci NOT NULL,
`espagnol` varchar(100) collate latin1_general_ci NOT NULL,
`allemand` varchar(100) collate latin1_general_ci NOT NULL,
`chinois` varchar(100) collate latin1_general_ci NOT NULL,
`italien` varchar(100) collate latin1_general_ci NOT NULL,
`autres` varchar(100) collate latin1_general_ci NOT NULL,
`niveauEtudeF` varchar(100) collate latin1_general_ci NOT NULL default '',
`niveauEtudeH` varchar(100) collate latin1_general_ci NOT NULL default '',
`auteur` varchar(100) collate latin1_general_ci NOT NULL default '',
`compositeur` varchar(100) collate latin1_general_ci NOT NULL default '',
`chanteur` varchar(100) collate latin1_general_ci NOT NULL default '',
`arrangeur` varchar(100) collate latin1_general_ci NOT NULL default '',
`batteur` varchar(100) collate latin1_general_ci NOT NULL default '',
`guitariste` varchar(100) collate latin1_general_ci NOT NULL default '',
`bassiste` varchar(100) collate latin1_general_ci NOT NULL,
`pianniste` varchar(100) collate latin1_general_ci NOT NULL default '',
`violoniste` varchar(100) collate latin1_general_ci NOT NULL default '',
`trombonne` varchar(100) collate latin1_general_ci NOT NULL default '',
`saxophoniste` varchar(100) collate latin1_general_ci NOT NULL,
`trompette` varchar(100) collate latin1_general_ci NOT NULL default '',
`dateInsertion` varchar(250) collate latin1_general_ci NOT NULL default '',
`modifier` varchar(250) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`idPersonne`),
KEY `nomH` (`nomH`),
KEY `nomF` (`nomF`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;
--
-- Contenu de la table `personne`
--
INSERT INTO `personne` (`idPersonne`, `mailF`, `mailH`, `nomEntreprise`, `nomF`, `nomH`, `prenomF`, `prenomH`, `marie`, `commentaire`, `adresse`, `codePostal`, `ville`, `telDomicile`, `telPortable`, `telBureau`, `gardeF`, `gardeH`, `dateNaissanceF`, `dateNaissanceH`, `nombreEnfantH`, `nombreEnfantF`, `proffessionF`, `proffessionH`, `anglais`, `espagnol`, `allemand`, `chinois`, `italien`, `autres`, `niveauEtudeF`, `niveauEtudeH`, `auteur`, `compositeur`, `chanteur`, `arrangeur`, `batteur`, `guitariste`, `bassiste`, `pianniste`, `violoniste`, `trombonne`, `saxophoniste`, `trompette`, `dateInsertion`, `modifier`) VALUES
(1, 'sqdfgdsfdgdshf', 'kjnhbgvfcxvbhn', 'pppppppp', 'ppppppppp', 'ppppppppppp', 'ppppppppppp', 'pppppppppp', 'oui', 'ppppppppppppppp', 'pppppppppppp', '0', 'pppppppp', 'pppppppppp', 'ppppppppppp', 'pppppp', 'on', 'on', 'ppppppppp', 'ppppppppp', '2', '3', 'pppppppppp', 'ppppppppppp', '', '', '', '', '', '', 'pppppppppppppp', 'ppppppppp', '', '', '', '', '', '', '', '', '', '', '', '', '1201473314', '0'),
(2, 'mmmmm', '', 'sdqfgds', 'mmmmmm', 'mmmmmmmm', 'mmmmm', 'mmmmmmmm', 'oui', 'mmmmmmmmmmmmm', 'mmmmm', '0', 'mmmmmm', 'mmmmmm', 'mmmmmmmm', 'mmmmmm', 'on', 'on', 'mmmmmmm', 'mm', '1', '3', 'mmmm', 'mmmmmmmm', 'mmmmm', 'mmmmmm', 'mmmmmm', 'mmmmmmmm', 'mmmmmm', 'mmmmmm', 'mmm', 'mmmm', 'on', '', 'on', '', 'on', '', '', 'on', '', 'on', '', '', '1201475288', '1201475288'),
(3, 'uuuuuuuuuuuu', 'uuuuuuuuuu', 'uuuuuuu ', 'uuuuuuuuuu', 'uuuuuuuuuu', ' uuuuuu', 'uuuuuuuu', '', 'uuuuuuuuuu uuuuuuuuuu uuuuuuuuu u', 'uuuuuuuu', '0', 'uuuuuuuuu', 'uuuuuuu', 'uuuuuuuu', 'uuuuuuuuu', '', '', '', 'uuuuuuuuu', '1', '1', 'uuuuuu', 'uuuuuuu', '', '', '', '', '', '', 'uuuuuuuuuu', 'uuuuuuuuuu', '', '', '', '', '', '', '', '', '', '', '', '', '1201702841', '1201702841'); |
Partager