DROP  database IF EXISTS best;

CREATE database best;

USE best;

CREATE TABLE inventory (
  number int(11) NOT NULL default '0',
  description varchar(30) default NULL,
  category varchar(10) default NULL,
  price double default NULL,
  quantity int(11) default NULL
);

--
-- Dumping data for table `inventory`
--

INSERT INTO inventory VALUES (431,'Sony VAIO PCV-MSX30','computers',2499.99,4);
INSERT INTO inventory VALUES (236,'Compaq Presario CP-1100','computers',1299,29);
INSERT INTO inventory VALUES (421,'IBM ThinkPad 3200X','computers',1750,4);
INSERT INTO inventory VALUES (422,'IBM ThinkPad 3200XS','computers',1890,0);
INSERT INTO inventory VALUES (949,'U2 - Greatest Hits','music',14.95,200);
INSERT INTO inventory VALUES (766,'The Beatles - White Album','music',19.5,43);
INSERT INTO inventory VALUES (804,'Elvis Presley - The Golden Yea','music',9.9,152);
INSERT INTO inventory VALUES (892,'Tom Petty - Wildflowers','music',12.99,8);
INSERT INTO inventory VALUES (6587,'GE Cordless phone','telephones',45,28);
INSERT INTO inventory VALUES (6588,'GE Cordless phone w/ headset','telephones',59,15);
INSERT INTO inventory VALUES (6590,'Sony HL-50 desktop','telephones',79.95,21);
INSERT INTO inventory VALUES (6591,'Sony HL-50S 90MHz desktop','telephones',89.95,30);