# MySQL dump 8.14
#
# Host: localhost    Database: lyon
#--------------------------------------------------------
# Server version	3.23.41

#
# Table structure for table 'products'
#

CREATE TABLE products (
  uid int(11) NOT NULL auto_increment,
  name varchar(55) NOT NULL default '',
  description mediumblob,
  type tinyblob,
  price decimal(9,2) default NULL,
  picture tinyblob,
  thumbnail tinyblob,
  artist tinyblob,
  display enum('Y','N') default NULL,
  limited enum('Y','N') default NULL,
  instock int(5) default NULL,
  publicID int(8) unsigned zerofill default NULL,
  datetime datetime default NULL,
  PRIMARY KEY  (uid),
  UNIQUE KEY publicID (publicID)
) TYPE=MyISAM;

#
# Dumping data for table 'products'
#

INSERT INTO products (uid, name, description, type, price, picture, thumbnail, artist, display, limited, instock, publicID, datetime) VALUES (1,'Electroclash Makes You Stupid [Black]','Scientific testing backed up by reams and reams of anecdotal evidence supports our claim. Next time you walk around Williamsburg, you\'ll see what we\'re talking about.\r\n<br><br>\r\nWhite lettering on black t-shirt; 10 x 2 inch imprint.','t-shirt',20.00,'electroclash.jpg','electroclash.jpg','D. J. Waletzky','Y','',10,20041021,'2004-01-17 20:08:50');
INSERT INTO products (uid, name, description, type, price, picture, thumbnail, artist, display, limited, instock, publicID, datetime) VALUES (2,'Pro-Semite [White]','A deceptively simple anti-racist statement. Think about it.\r\n<br><br>\r\nBlack and grey lettering on white T-shirt. 10 x 1.5 inch imprint.','t-shirt',20.00,'pro-semite.jpg','pro-semite.jpg','D. J. Waletzky','Y','',-1,20041102,'2004-01-17 20:13:37');
INSERT INTO products (uid, name, description, type, price, picture, thumbnail, artist, display, limited, instock, publicID, datetime) VALUES (3,'Tom’s Restaurant','Get your memento from the venerable and delicious Prospect Heights landmark.','t-shirt',30.00,'toms.jpg','toms.jpg','D. J. Waletzky','N','',2,20040003,'2004-01-17 20:07:37');
INSERT INTO products (uid, name, description, type, price, picture, thumbnail, artist, display, limited, instock, publicID, datetime) VALUES (4,'DIBS','What does DIBS mean? Shhh! It\'s a secret! Help us keep it that way with this T-shirt.\r\n<p>\r\nBlack T-shirt, 8 x 1.5 inch imprint.','t-shirt',20.00,'dibs.jpg','dibs.jpg','D. J. Waletzky','Y','',-1,20043324,'2004-01-18 03:06:23');
INSERT INTO products (uid, name, description, type, price, picture, thumbnail, artist, display, limited, instock, publicID, datetime) VALUES (5,'Nouveau Screech','The day Nouveau Screech played their first show at Stevie\'s Tavern in Plainview, Montana was the day the ska had officially reached its high-water mark in terms of breaching the American mainstream. This six-piece outfit quickly became the house band at Stevie\'s, but then they got cocky and announced a whirlwind tour of the northeast in late 1996. Unfortunately, lead singer Jamie Meyers was accepted to law school that spring and the band fell soon fell apart. Now\'s your chance to own a piece of obscure American rock history--a very rare limited edition Nouveau Screech shirt!\r\n<p>\r\nWhite shirt with 6 inch circular imprint. ','t-shirt',35.00,'nouveau_screech.jpg','nouveau_screech.jpg','491 Vintage Shirts','Y','',6,20049005,'2004-01-18 04:20:48');
INSERT INTO products (uid, name, description, type, price, picture, thumbnail, artist, display, limited, instock, publicID, datetime) VALUES (6,'Electroclash Makes You Stupid [White]','Scientific testing backed up by reams and reams of anecdotal evidence supports our claim. Next time you walk around Williamsburg, you\'ll see what we\'re talking about.\r\n<br><br>\r\nBlack lettering on white t-shirt; 10 x 2 inch imprint.','t-shirt',20.00,'inv_electroclash.jpg','inv_electroclash.jpg','D. J. Waletzky','Y','',NULL,20041022,'2004-01-17 20:09:00');
INSERT INTO products (uid, name, description, type, price, picture, thumbnail, artist, display, limited, instock, publicID, datetime) VALUES (7,'Pro-Semite [Black]','A deceptively simple anti-racist statement. <br><br> White lettering on black t-shirt; imprint is 10 x 2 inches. ','t-shirt',20.00,'inv_pro-semite.jpg','inv_pro-semite.jpg','D. J. Waletzky','Y','',NULL,20041103,'2004-01-17 20:15:43');

#
# Table structure for table 'carts'
#

CREATE TABLE carts (
  uid int(11) NOT NULL auto_increment,
  cartID varchar(32) default NULL,
  productID int(8) default NULL,
  nb tinyblob,
  quantity int(2) default NULL,
  price decimal(10,2) default NULL,
  created_on timestamp(14) NOT NULL,
  PRIMARY KEY  (uid)
) TYPE=MyISAM;

#
# Dumping data for table 'carts'
#

INSERT INTO carts (uid, cartID, productID, nb, quantity, price, created_on) VALUES (21,'aa19cfb5911cf5f2ed2127232fd0ae2a',20041103,'sizeXS',1,20.00,20040118043859);
INSERT INTO carts (uid, cartID, productID, nb, quantity, price, created_on) VALUES (22,'aa19cfb5911cf5f2ed2127232fd0ae2a',20041021,'sizeM',1,20.00,20040118043920);
INSERT INTO carts (uid, cartID, productID, nb, quantity, price, created_on) VALUES (16,'cb6db68375f74d6bf3a190b50553de8f',20040005,'sizeXL',1,25.00,20040117185030);
INSERT INTO carts (uid, cartID, productID, nb, quantity, price, created_on) VALUES (18,'cb6db68375f74d6bf3a190b50553de8f',20041021,'sizeL',2,20.00,20040118030419);
INSERT INTO carts (uid, cartID, productID, nb, quantity, price, created_on) VALUES (11,'cb6db68375f74d6bf3a190b50553de8f',20041103,'sizeL',1,20.00,20040117050038);
INSERT INTO carts (uid, cartID, productID, nb, quantity, price, created_on) VALUES (24,'aa19cfb5911cf5f2ed2127232fd0ae2a',20049005,'sizeL',1,35.00,20040118044120);
INSERT INTO carts (uid, cartID, productID, nb, quantity, price, created_on) VALUES (26,'6f97c1134dbebc22676459873df6b3dd',20041021,'sizeM',1,20.00,20040119223737);

#
# Table structure for table 'types'
#

CREATE TABLE types (
  type varchar(50) default NULL
) TYPE=MyISAM;

#
# Dumping data for table 'types'
#

INSERT INTO types (type) VALUES ('t-shirt');
INSERT INTO types (type) VALUES ('painting');