# phpMyAdmin SQL Dump # version 2.5.3 # http://www.phpmyadmin.net # # # # Database: `shop_demo` # # -------------------------------------------------------- # # Structure of table `shirts` # CREATE TABLE shirts ( id int(9) NOT NULL default '0', size VARCHAR( 4 ) default NULL, color varchar(100) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; # # Content of table `shirts` # # -------------------------------------------------------- # # Structure of table `cart_products` # CREATE TABLE cart_products ( id_cart int(11) NOT NULL default '0', id_product int(11) NOT NULL default '0', KEY id_cart (id_cart,id_product) ) TYPE=MyISAM; # # Content of table `cart_products` # # -------------------------------------------------------- # # Structure of table `carts` # CREATE TABLE carts ( id int(9) NOT NULL auto_increment, date int(10) NOT NULL default '0', color varchar(100) default NULL, user int(9) NOT NULL default '0', PRIMARY KEY (id), KEY user (user) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Content of table `carts` # # -------------------------------------------------------- # # Structure of table `products` # CREATE TABLE products ( id int(11) NOT NULL auto_increment, name varchar(100) NOT NULL default '', description text, price float(7,2) NOT NULL default '0.00', PRIMARY KEY (id) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Content of table `products` # # -------------------------------------------------------- # # Structure of table `users` # CREATE TABLE users ( id int(9) NOT NULL auto_increment, firstname varchar(100) default NULL, name varchar(100) default NULL, mail varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM AUTO_INCREMENT=2 ; # # Content of table `users` # INSERT INTO users VALUES (1, 'Michael', 'Haussmann', 'michael@phpersistence.org'); # -------------------------------------------------------- # # Structure of table `users_telephones` # CREATE TABLE users_telephones ( id_user int(9) NOT NULL default '0', telephone varchar(30) NOT NULL default '', KEY id_user (id_user,telephone) ) TYPE=MyISAM; # # Content of table `users_telephones` # INSERT INTO users_telephones VALUES (1, '04 67 54 55 xx'); INSERT INTO users_telephones VALUES (1, '06 11 73 43 xx'); # -------------------------------------------------------- # # Structure of table `wines` # CREATE TABLE wines ( id int(9) NOT NULL default '0', millesime int(4) default NULL, aoc varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; # # Content of table `wines` #