create table store_categories (
    id int not null primary key auto_increment,
    cat_title varchar (50) unique,
    cat_desc text
    );
	
create table store_items (
     id int not null primary key auto_increment,
     cat_id int not null,
     item_title varchar (75),
     item_price float (8,2),
     item_desc text,
     item_image varchar (50)
     );

	create table store_item_size (
     item_id int not null,
     item_size varchar (25)
     );

	create table store_item_color (
     item_id int not null,
     item_color varchar (25)
     );


	 insert into store_categories values
     ('1', 'Hats', 'Funky hats in all shapes and sizes!');


 insert into store_categories values ('2', 'Shirts', 'From t-shirts to
 sweatshirts to polo shirts and beyond.');


 insert into store_categories values ('3', 'Books', 'Paperback, hardback,
 books for school or play.');

	
 insert into store_items values ('1', '1', 'Baseball Hat', '12.00',
 'Fancy, low-profile baseball hat.', 'baseballhat.gif');

 insert into store_items values ('2', '1', 'Cowboy Hat', '52.00',
 '10 gallon variety', 'cowboyhat.gif');


insert into store_items values ('3', '1', 'Top Hat', '102.00',
 'Good for costumes.', 'tophat.gif');


insert into store_items values ('4', '2', 'Short-Sleeved T-Shirt',
 '12.00', '100% cotton, pre-shrunk.', 'sstshirt.gif');


insert into store_items values ('5', '2', 'Long-Sleeved T-Shirt',
 '15.00', 'Just like the short-sleeved shirt, with longer sleeves.',
 'lstshirt.gif');


insert into store_items values ('6', '2', 'Sweatshirt', '22.00',
 'Heavy and warm.', 'sweatshirt.gif');

insert into store_items values ('7', '3', 'Jane\'s Self-Help Book',
 '12.00', 'Jane gives advice.', 'selfhelpbook.gif');


 insert into store_items values ('8', '3', 'Generic Academic Book',
 '35.00', 'Some required reading for school, will put you to sleep.',
'boringbook.gif');


 insert into store_items values ('9', '3', 'Chicago Manual of Style',
 '9.99', 'Good for copywriters.', 'chicagostyle.gif');



insert into store_item_size values (1, 'One Size Fits All');


insert into store_item_size values (2, 'One Size Fits All');

insert into store_item_size values (3, 'One Size Fits All');


insert into store_item_size values (4, 'S');


insert into store_item_size values (4, 'M');


insert into store_item_size values (4, 'L');


insert into store_item_size values (4, 'XL');

insert into store_item_color values (1, 'red');

insert into store_item_color values (1, 'black');

insert into store_item_color values (1, 'blue');