MLD

-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- https://www.phpmyadmin.net/
--
-- Serveur: localhost
-- Généré le : Lundi 02 Juin 2008 à 09:48
-- Version du serveur: 5.0.27
-- Version de PHP: 5.2.0
--
-- Base de données: `informatika_db`
--

-- --------------------------------------------------------

--
-- Structure de la table `adresses`
--

CREATE TABLE `adresses` (
`ID` int(10) unsigned NOT NULL auto_increment,
`RUE` varchar(50) collate latin1_general_ci default NULL,
`NUMERO` varchar(10) collate latin1_general_ci default NULL,
`BOITE` varchar(5) collate latin1_general_ci default NULL,
`CODE_POSTAL` varchar(10) collate latin1_general_ci default NULL,
`LOCALITE` varchar(50) collate latin1_general_ci default NULL,
`PAYS` varchar(50) collate latin1_general_ci default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Contenu de la table `adresses`
--


-- --------------------------------------------------------

--
-- Structure de la table `articles`
--

CREATE TABLE `articles` (
`ID` int(10) unsigned NOT NULL auto_increment,
`LIBELLE` varchar(50) collate latin1_general_ci NOT NULL,
`MARQUE_ID` int(10) unsigned NOT NULL,
`CATEGORIE_ID` int(10) unsigned NOT NULL,
`PRIX` float unsigned NOT NULL,
`QUANTITE` tinyint(3) unsigned default '0',
`SEUIL` tinyint(3) unsigned default '0',
`DESCRIPTION` text collate latin1_general_ci,
`LIEN` text collate latin1_general_ci,
PRIMARY KEY (`ID`),
UNIQUE KEY `LIBELLE_MARQUE_CATEGORIE_UNIQUE` (`LIBELLE`,`MARQUE_ID`,`CATEGORIE_ID`),
KEY `ARTICLE_MARQUE_FK` (`MARQUE_ID`),
KEY `ARTICLE_CATEGORIE_FK` (`CATEGORIE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Contenu de la table `articles`
--


-- --------------------------------------------------------

--
-- Structure de la table `categories`
--

CREATE TABLE `categories` (
`ID` int(10) unsigned NOT NULL auto_increment,
`LIBELLE` varchar(30) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `LIBELLE_UNIQUE` (`LIBELLE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=17 ;

--
-- Contenu de la table `categories`
--

INSERT INTO `categories` (`ID`, `LIBELLE`) VALUES
(1, '8800 GT 512'),
(11, 'Carte graphique ATI'),
(12, 'Carte graphique nVidia'),
(2, 'Carte mère INTEL'),
(5, 'Disque dur PATA'),
(6, 'Disque dur SATA'),
(7, 'Disque dur SCSI'),
(13, 'Graveur DVD'),
(16, 'Lecteur Blue Ray'),
(15, 'Lecteur disquette'),
(14, 'Lecteur DVD ROM'),
(8, 'Mémoire DDR1'),
(9, 'Mémoire DDR2'),
(10, 'Mémoire DDR3'),
(3, 'Processeur AMD'),
(4, 'Processeur INTEL');

-- --------------------------------------------------------

--
-- Structure de la table `clients`
--

CREATE TABLE `clients` (
`CLIENT_ID` int(10) unsigned NOT NULL,
`NUMERO_TVA` varchar(15) collate latin1_general_ci default NULL,
PRIMARY KEY (`CLIENT_ID`),
UNIQUE KEY `NUMERO_TVA_UNIQUE` (`NUMERO_TVA`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `clients`
--


-- --------------------------------------------------------

--
-- Structure de la table `commandes`
--

CREATE TABLE `commandes` (
`ID` int(10) unsigned NOT NULL auto_increment,
`DATE_COMMANDE` timestamp NOT NULL default CURRENT_TIMESTAMP,
`DATE_LIVRAISON` date default NULL,
`STATUT` enum('COMMANDE','PREPARATION','LIVRAISON','LIVRE','ANNULE') collate latin1_general_ci NOT NULL default 'COMMANDE',
`CLIENT_ID` int(10) unsigned NOT NULL,
PRIMARY KEY (`ID`),
KEY `COMMANDE_CLIENT_FK` (`CLIENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Contenu de la table `commandes`
--


-- --------------------------------------------------------

--
-- Structure de la table `detail_commandes`
--

CREATE TABLE `detail_commandes` (
`ID` int(10) unsigned NOT NULL auto_increment,
`COMMANDE_ID` int(10) unsigned NOT NULL,
`ARTICLE_ID` int(10) unsigned NOT NULL,
`QUANTITE` tinyint(3) unsigned NOT NULL,
`PRIX` float unsigned NOT NULL,
PRIMARY KEY (`ID`),
KEY `DETAIL_CMD_COMMANDE_FK` (`COMMANDE_ID`),
KEY `DETAIL_CMD_ARTICLE_FK` (`ARTICLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Contenu de la table `detail_commandes`
--


-- --------------------------------------------------------

--
-- Structure de la table `employes`
--

CREATE TABLE `employes` (
`EMPLOYE_ID` int(10) unsigned NOT NULL,
PRIMARY KEY (`EMPLOYE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Contenu de la table `employes`
--


-- --------------------------------------------------------

--
-- Structure de la table `marques`
--

CREATE TABLE `marques` (
`ID` int(10) unsigned NOT NULL auto_increment,
`LIBELLE` varchar(30) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `LIBELLE_UNIQUE` (`LIBELLE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=24 ;

--
-- Contenu de la table `marques`
--

INSERT INTO `marques` (`ID`, `LIBELLE`) VALUES
(1, 'ABIT'),
(2, 'ACER'),
(3, 'AMD'),
(4, 'ANTEC'),
(5, 'AOPEN'),
(6, 'ASROCK'),
(7, 'ASUS'),
(8, 'CORSAIR'),
(9, 'CREATIVE'),
(10, 'HITACHI'),
(11, 'INTEL'),
(12, 'KINGSTON'),
(13, 'LG'),
(14, 'LITEON'),
(15, 'LOGITECH'),
(16, 'MAXTOR'),
(17, 'PIONEER'),
(18, 'PLEXTOR'),
(19, 'POWERCOLOR'),
(20, 'SAMSUNG'),
(21, 'SAPPHIRE'),
(22, 'SEAGATE'),
(23, 'XFX');

-- --------------------------------------------------------

--
-- Structure de la table `membres`
--

CREATE TABLE `membres` (
`ID` int(10) unsigned NOT NULL auto_increment,
`LOGIN` varchar(15) collate latin1_general_ci NOT NULL,
`PASSWORD` varchar(50) collate latin1_general_ci NOT NULL,
`EMAIL` varchar(50) collate latin1_general_ci NOT NULL,
`NOM` varchar(30) collate latin1_general_ci NOT NULL,
`PRENOM` varchar(30) collate latin1_general_ci default NULL,
`ADRESSE_ID` int(10) unsigned default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `LOGIN_UNIQUE` (`LOGIN`),
KEY `MEMBRE_ADRESSE_FK` (`ADRESSE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Contenu de la table `membres`
--


--
-- Contraintes pour les tables exportées
--

--
-- Contraintes pour la table `articles`
--
ALTER TABLE `articles`
ADD CONSTRAINT `ARTICLE_CATEGORIE_FK` FOREIGN KEY (`CATEGORIE_ID`) REFERENCES `categories` (`ID`) ON DELETE CASCADE,
ADD CONSTRAINT `ARTICLE_MARQUE_FK` FOREIGN KEY (`MARQUE_ID`) REFERENCES `marques` (`ID`) ON DELETE CASCADE;

--
-- Contraintes pour la table `clients`
--
ALTER TABLE `clients`
ADD CONSTRAINT `CLIENT_MEMBRE_FK` FOREIGN KEY (`CLIENT_ID`) REFERENCES `membres` (`ID`) ON DELETE CASCADE;

--
-- Contraintes pour la table `commandes`
--
ALTER TABLE `commandes`
ADD CONSTRAINT `COMMANDE_CLIENT_FK` FOREIGN KEY (`CLIENT_ID`) REFERENCES `clients` (`CLIENT_ID`);

--
-- Contraintes pour la table `detail_commandes`
--
ALTER TABLE `detail_commandes`
ADD CONSTRAINT `DETAIL_CMD_ARTICLE_FK` FOREIGN KEY (`ARTICLE_ID`) REFERENCES `articles` (`ID`),
ADD CONSTRAINT `DETAIL_CMD_COMMANDE_FK` FOREIGN KEY (`COMMANDE_ID`) REFERENCES `commandes` (`ID`) ON DELETE CASCADE;

--
-- Contraintes pour la table `employes`
--
ALTER TABLE `employes`
ADD CONSTRAINT `EMPLOYE_MEMBRE_FK` FOREIGN KEY (`EMPLOYE_ID`) REFERENCES `membres` (`ID`) ON DELETE CASCADE;

--
-- Contraintes pour la table `membres`
--
ALTER TABLE `membres`
ADD CONSTRAINT `MEMBRE_ADRESSE_FK` FOREIGN KEY (`ADRESSE_ID`) REFERENCES `adresses` (`ID`);