DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `text` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
);
INSERT INTO `category` VALUES (1,'Mobile phones','Reaching everyone'),(2,'Movies and DVDs','For long nights'),(3,'Music','Why to be loved by neighbors'),(4,'Car and motor','What has wheels');

DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `password` varchar(45) DEFAULT NULL,
  `phone` varchar(16) DEFAULT NULL,
  `address` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
);
INSERT INTO `customer` VALUES (1,'John Smith','john@example.com','j','555-3423','123 Park Ave'),(2,'Jane Smith','jane.smith@example.com','j','555-3173','125 Park Ave'),(3,'Jane Alexander','jane@example.com','j','555-6182','24 Oak Str'),(4,'Kim Alexander','kim@example.com','k','555-0180','2962 Dunedin Ave'),(5,'Shirley McArthur','shirley@example.com','s','555-0192','711 Charlotte Str'),(6,'Susan Doe','susan.doe@example.com','s','555-3797','1526 Vance Ave'),(7,'Susan Smith','susan.smith@example.com','s','555-3713','13 Wrong Lane'),(8,'Chris Carpenter','chris.carpenter@example.com','j','555-3191','77 Bourbon Str'),(9,'Jim Black','jim.black@example.com','j','555-1191','42 Oak Str'),(10,'Poppea Farewell','poppea@example.com','p','555-9999','454 Shirley Rd Apt 4F');

DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `adv_date` datetime DEFAULT NULL,
  `category_id` int(10) unsigned DEFAULT NULL,
  `customer_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `product` VALUES (1,'Nokia N97 White Cell Phone','446.00','2010-01-11 12:10:00',1,3),(2,'HTC Diamond II T5353 NEW','480.00','2010-01-10 12:10:00',1,5),(3,'SAMSUNG A867','140.00','2010-01-09 12:10:00',1,3),(4,'LED ZEPPELIN IV ZEPPELIN 4 REMASTER SEALED CD','7.00','2009-12-31 12:10:00',3,3),(5,'DELERIUM CHIMERA CD VG+ 2 DISC 2003','10.00','2010-01-14 19:30:00',3,1),(6,'Cocteau Twins Blue Bell Knoll CD','5.00','2010-12-30 16:10:00',3,1),(7,'WITHIN TEMPTATION - THE HEART OF EVERYTHING - CD','13.00','2010-01-20 12:10:00',3,1),(8,'2009 Mitsubishi Eclipse GS COUPE','15500.00','2010-01-07 12:44:00',4,4),(9,'1998 FORD ESCORT LX, ONE OWNER','6500.00','2010-01-03 12:00:00',4,5),(10,'2006 FORD ESCAPE XLT AWD/4X4','12500.00','2010-01-01 12:30:00',4,6),(11,'2006 VOLKSWAGEN PASSAT 2.0T TURBOCHARGED','12700.00','2010-01-09 19:19:00',4,7),(12,'The Fountain','5.00','2009-01-01 20:00:00',2,1),(13,'Paycheck','5.00','2009-01-11 04:00:00',2,2),(14,'Blade Runner','4.00','2009-01-01 13:00:00',2,4),(15,'La reine Margot','5.00','2009-01-01 03:00:00',2,1),(16,'The Butterfly Effect','5.00','2009-01-11 03:00:00',2,4),(17,'Much Ado About Nothing','5.00','2009-01-09 03:00:00',2,3),(18,'Romeo + Juliet - 1996','5.00','2009-01-10 21:00:00',2,6),(19,'Pan\'s Labyrinth - 2006','7.00','2009-01-01 03:00:00',2,1),(20,'Helen of Troy','6.00','2009-01-03 13:00:00',2,7),(21,'Stealing Beauty','6.00','2009-01-01 11:00:00',2,1),(22,'Cyrano de Bergerac','7.00','2009-01-01 03:00:00',2,1),(23,'Stardust','4.00','2009-01-03 13:00:00',2,7),(24,'Hamlet','5.00','2009-01-01 03:00:00',2,1);