-- phpMyAdmin SQL Dump
-- version 3.1.3.1
--
http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Jeu 04 Juin 2009 à 01:05
-- Version du serveur: 5.1.33
-- Version de PHP: 5.2.9-2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Base de données: `manager`
--
-- --------------------------------------------------------
--
-- Structure de la table `clients`
--
CREATE TABLE IF NOT EXISTS `clients` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`nom` varchar(32) NOT NULL,
`prenom` varchar(32) NOT NULL,
`password` varchar(32) NOT NULL,
`carte_fidelite` int(32) NOT NULL,
`date_naissance` date NOT NULL,
`montant_achats` int(32) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
--
-- Contenu de la table `clients`
--
INSERT INTO `clients` (`id`, `nom`, `prenom`, `password`, `carte_fidelite`, `date_naissance`, `montant_achats`) VALUES
(2, 'Jones', 'Henry Jr', 'c82138c7e01ad922b0a58fdd33c3a91c', 1035741100, '1899-07-01', 155);
-- --------------------------------------------------------
--
-- Structure de la table `dossiers_clients`
--
CREATE TABLE IF NOT EXISTS `dossiers_clients` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_client` int(11) NOT NULL,
`id_employe` varchar(11) NOT NULL,
`client_appele` varchar(32) NOT NULL,
`employe_appel` varchar(32) NOT NULL,
`duree_appel` time NOT NULL,
`resume` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Contenu de la table `dossiers_clients`
--
-- --------------------------------------------------------
--
-- Structure de la table `employes`
--
CREATE TABLE IF NOT EXISTS `employes` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`nom` varchar(32) NOT NULL,
`prenom` varchar(32) NOT NULL,
`password` varchar(32) NOT NULL,
`profil` varchar(32) NOT NULL,
`date_naissance` date NOT NULL,
`photo` varchar(32) NOT NULL,
`entree_societe` datetime NOT NULL,
`poste` varchar(32) NOT NULL,
`salaire` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Contenu de la table `employes`
--
INSERT INTO `employes` (`id`, `nom`, `prenom`, `password`, `profil`, `date_naissance`, `photo`, `entree_societe`, `poste`, `salaire`) VALUES
(1, 'toto', 'tata', 'f4912f59b290ef2f561e5ca2c23e852c', '1', '1975-08-09', 'aucune', '2007-08-07 02:10:28', 'administrateur', '1555€');
Partager