# 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`
#

