CREATE TABLE documents (
d_id int(4) NOT NULL auto_increment,
name varchar(25) NOT NULL default '',
type varchar(25) NOT NULL default '',
category varchar(25) NOT NULL default '',
price int(11) NOT NULL default '0',
stock int(11) NOT NULL default '0',
PRIMARY KEY (d_id)
) TYPE=MyISAM;

#
# Dumping data for table `documents`
#

INSERT INTO documents VALUES (1, 'Book1', 'Book', 'Management', 220, 10);
INSERT INTO documents VALUES (2, 'Book2', 'CD', 'Management', 120, 8);
INSERT INTO documents VALUES (3, 'Book3', 'Report', 'Management', 25, 4);
INSERT INTO documents VALUES (4, 'Book4', 'Book', 'Management', 55, 8);
INSERT INTO documents VALUES (5, 'Document1', 'Book', 'Management', 15, 23);
INSERT INTO documents VALUES (6, 'Document2', 'CD', 'Computers', 80, 45);
INSERT INTO documents VALUES (7, 'Document3', 'Report', 'Computers', 55, 65);
INSERT INTO documents VALUES (8, 'Book5', 'Report', 'Management', 80, 10);
INSERT INTO documents VALUES (9, 'Document4', 'CD', 'Management', 72, 5);
INSERT INTO documents VALUES (10, 'Book 8', 'Book', 'Computers', 88, 6);
INSERT INTO documents VALUES (11, 'Book 9', 'CD', 'Computers', 100, 5);
INSERT INTO documents VALUES (12, 'Document5', 'Report', 'Computers', 85, 8);
INSERT INTO documents VALUES (13, 'Book 10', 'Book', 'Computers', 150, 5);