Field	Type	Null	Key	Default	Extra
user_id	int(10) unsigned	NO	PRI	NULL	auto_increment
user_uname	varchar(127)	YES		NULL	
user_email	varchar(127)	YES		NULL	
user_password	varchar(127)	YES		NULL	
user_fname	varchar(127)	YES		NULL	
user_id	user_uname	user_email	user_password	user_fname
1	test	test@test.com	testpassword	testfname
2	tredden	tredden@csub.edu	password	Taylor
Field	Type	Null	Key	Default	Extra
prod_id	int(10) unsigned	NO	PRI	NULL	auto_increment
prod_name	varchar(127)	YES		NULL	
prod_img	varchar(127)	YES		NULL	
prod_description	varchar(511)	YES		NULL	
prod_price	decimal(10,2)	YES		NULL	
prod_rating	tinyint(3) unsigned	YES		NULL	
prod_sku	char(32)	YES		NULL	
prod_stock	int(10) unsigned	YES		NULL	
prod_id	prod_name	prod_img	prod_description	prod_price	prod_rating	prod_sku	prod_stock
1	Pet Rock	rock.jpeg	Rocky!	35.69	10	ROcKy!526zs	10
2	$50 Build-a-Bear Gift Card	buildbear.jpeg	Build your own bear! No alchemy required!	40.00	5	384lkjh767i6f	10
3	Black Sharpies	sharpie.jpg	Permanently mark your territory.	5.49	2	23qozxf87gka	100
4	Spacesaver Bags	spacebag.jpg	Store your things in freeze-dried bags.	9.99	0	6294jsdt754u	40
5	Umbrella	umbrella.jpg	Ella Ella. Ey Ey. Under my umbrella.	14.98	1	s84jwer023isb0	1
6	Walkie Talkies	walkie.jpeg	Coordinate your next bank heist.	48.99	4	723sdfpaepza34r78	0
7	Shiny Watch	watch.jpg	Look at how nice this watch looks.	500.00	3	61skzpwmfusm74s	0