/Base de donnee/ecommerce.sql
SQL | 147 lines | 81 code | 24 blank | 42 comment | 0 complexity | 12d5e2a2d2191b57c5e0428ea54d5b4c MD5 | raw file
- -- phpMyAdmin SQL Dump
- -- version 4.1.14
- -- http://www.phpmyadmin.net
- --
- -- Client : 127.0.0.1
- -- Généré le : Mer 20 Mai 2015 à 02:07
- -- Version du serveur : 5.6.17
- -- Version de PHP : 5.5.12
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!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 : `ecommerce`
- --
- -- --------------------------------------------------------
- --
- -- Structure de la table `articles`
- --
- CREATE TABLE IF NOT EXISTS `articles` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `nom` varchar(90) NOT NULL,
- `prix` decimal(10,0) NOT NULL,
- `srcimg` varchar(300) NOT NULL,
- `description` varchar(300) NOT NULL,
- `vedette` tinyint(1) NOT NULL,
- `type` varchar(4) NOT NULL,
- `idcateg` int(11) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
- --
- -- Contenu de la table `articles`
- --
- INSERT INTO `articles` (`id`, `nom`, `prix`, `srcimg`, `description`, `vedette`, `type`, `idcateg`) VALUES
- (1, 'Radiohead Pocket', '99', '197762_mrp_in_l1.jpg', '', 1, 'h', 0),
- (2, 'Cafe Racer Jacket', '389', '340809_mrp_in_l.jpg', '', 1, 'h', 0),
- (3, 'Rough Sunset Jacket', '123', '196623_mrp_in_l.jpg', '', 1, '', 0),
- (4, 'Red Garage', '83', '340332_mrp_in_l.jpg', '', 1, '', 0),
- (5, 'Shirt With Attributes', '56', '328390_mrp_in_l.jpg', '', 1, '', 0),
- (6, 'Simple Kinky Shirt', '98', '194809_mrp_in_l.jpg', '', 1, '', 0),
- (7, 'Blues Denim', '10', '340333_mrp_in_l.jpg', '', 0, '', 0),
- (8, 'Cafe Racer Jacket', '300', '340809_mrp_in_l.jpg', '', 0, '', 0),
- (9, 'Leather Sling Track', '112', '311772_mrp_in_l.jpg', '', 0, '', 0),
- (10, 'Mahogany Footprint', '79', '328427_mrp_e1_l.jpg', '', 0, '', 0),
- (11, 'Moscot Crowbar', '259', '343841_mrp_in_l.jpg', '', 0, '', 0),
- (12, 'Radiohead Pocket', '99', '197762_mrp_in_l1.jpg', '', 0, '', 0),
- (13, 'Red Garage', '83', '340332_mrp_in_l.jpg', '', 0, '', 0),
- (14, 'Ripped Jeans', '169', '341243_mrp_in_l.jpg', '', 0, '', 0),
- (15, '196623_mrp_in_l.jpg', '123', 'Rough Sunset Jacket', '', 0, '', 0);
- -- --------------------------------------------------------
- --
- -- Structure de la table `categorie`
- --
- CREATE TABLE IF NOT EXISTS `categorie` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `libelle` varchar(11) NOT NULL,
- `idarticle` int(11) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `fk_arti` (`idarticle`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Structure de la table `couleurs`
- --
- CREATE TABLE IF NOT EXISTS `couleurs` (
- `idarticle` int(11) NOT NULL,
- `couleur` varchar(30) NOT NULL,
- `imgcouleur` varchar(60) NOT NULL,
- PRIMARY KEY (`idarticle`,`couleur`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Structure de la table `utilisateurs`
- --
- CREATE TABLE IF NOT EXISTS `utilisateurs` (
- `id` int(6) NOT NULL AUTO_INCREMENT,
- `username` varchar(30) NOT NULL,
- `nom` varchar(30) NOT NULL DEFAULT '',
- `prenom` varchar(30) DEFAULT NULL,
- `titre` varchar(30) NOT NULL,
- `email` varchar(50) NOT NULL,
- `password` varchar(30) NOT NULL,
- `tel` int(8) NOT NULL,
- `ville` varchar(20) NOT NULL,
- `codpost` int(6) NOT NULL,
- `codtel` int(3) NOT NULL,
- `adresse1` varchar(70) NOT NULL,
- `adresse2` varchar(60) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `id` (`id`),
- UNIQUE KEY `email` (`email`),
- UNIQUE KEY `email_2` (`email`),
- UNIQUE KEY `username` (`username`),
- UNIQUE KEY `email_3` (`email`),
- UNIQUE KEY `email_4` (`email`),
- UNIQUE KEY `email_5` (`email`),
- UNIQUE KEY `email_6` (`email`),
- UNIQUE KEY `email_7` (`email`),
- FULLTEXT KEY `password` (`password`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;
- --
- -- Contenu de la table `utilisateurs`
- --
- INSERT INTO `utilisateurs` (`id`, `username`, `nom`, `prenom`, `titre`, `email`, `password`, `tel`, `ville`, `codpost`, `codtel`, `adresse1`, `adresse2`) VALUES
- (37, 't.houssem', 'Trabelsi', 'Houssem', 'mr', 't.houssemg@gmail.com', '123456', 0, '', 0, 0, '', '');
- --
- -- Contraintes pour les tables exportées
- --
- --
- -- Contraintes pour la table `categorie`
- --
- ALTER TABLE `categorie`
- ADD CONSTRAINT `fk_arti` FOREIGN KEY (`idarticle`) REFERENCES `articles` (`id`);
- --
- -- Contraintes pour la table `couleurs`
- --
- ALTER TABLE `couleurs`
- ADD CONSTRAINT `fk_col_article` FOREIGN KEY (`idarticle`) REFERENCES `articles` (`id`);
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;