SELECT * FROM Checkout; | Field | Type | Null | Key | Default | Extra | +------------+------------------+------+-----+---------+----------------+ | cid | int(11) unsigned | NO | PRI | NULL | auto_increment | | custid | int(11) unsigned | NO | | NULL | | | firstname | varchar(50) | YES | | NULL | | | lastname | varchar(50) | YES | | NULL | | | cardnumber | int(11) unsigned | NO | | NULL | | | expire | int(11) unsigned | NO | | NULL | | | address | varchar(50) | YES | | NULL | | | city | varchar(50) | YES | | NULL | | | state | varchar(50) | YES | | NULL | | | ordertotal | int(11) unsigned | NO | | NULL | +-----+--------+-----------+----------+------------+--------+------------+-------------+-----------+------------+ | cid | custid | firstname | lastname | cardnumber | expire | address | city | state | ordertotal | +-----+--------+-----------+----------+------------+--------+------------+-------------+-----------+------------+ | 1 | 1 | Sukhmeni | Chauhan | 123456789 | 0 | 123 street | Bakersfield | CA | 50 | | 2 | 1 | John | Snow | 987654321 | 12 | the north | north | fairyland | 6 | +-----+--------+-----------+----------+------------+--------+------------+-------------+-----------+------------+ SELECT * FROM Products +------------------+---------------------+------+-----+---------+----------------+ | 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 | Cat ball | ball.jpeg | This is a ball specially designed for your cat to be able to run around like a crazy person only when you arent playing with them. As soon as you give them attention they will stop playing with said ball | 5.99 | 4 | wefe1312 | 4 | | 2 | Catnip | ghostcat.jpeg | Now this is the stuff your cats like. Im not sure why, but this is itttttt | 99.99 | 5 | pup1234 | 2 | | 3 | Fishies | fishies.jpeg | Since you cat has become a house cat they havent been able to test their skills out. These fishies are meant to help your cat develop their best jutsu. Might as well name them naruto as well. | 19.99 | 3 | min1234 | 0 | | 4 | Doggy Toy | carrot.jpeg | Chew toy, but only for dogs with the name kkingkkanga | 10.00 | 3 | snac1234 | 10 | | 5 | Grumpy Cat RIP | grumpy.jpeg | For those that have no heard. Grumpy cat has passed away. He will be missed dearly. Keep this im memorance | 49.99 | 4 | heel1234 | 2 | | 6 | Squirell | squirell.jpeg | If you think your cat is a dog.... this might be the toy for you | 15.99 | 5 | 123mark | 1 | +---------+----------------+---------------+------------------------------------------------------------------------------------------------------------------------------ SELECT * FROM Users +---------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+----------------+ | user_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_uname | varchar(255) | YES | | NULL | | | user_email | varchar(255) | YES | | NULL | | | user_password | varchar(255) | YES | | NULL | | | user_fname | varchar(255) | YES | | NULL | | +---------------+------------------+------+-----+---------+----------------+ +---------+------------+---------------------+---------------+------------+ | user_id | user_uname | user_email | user_password | user_fname | +---------+------------+---------------------+---------------+------------+ | 1 | test | test@test.com | testpassword | testfname | | 2 | yaboi | yaboi@gmail.com | sd | testfname | | 3 | Suki | suki@gmail.com | meep | testfname | | 4 | suki | suki1@gmail.com | suki | testfname | | 5 | suki | hello@gmail.com | hello | testfname | | 6 | Grumpy | grumpycat@gmail.com | grumpycat | testfname | | 7 | Alf | Alf@gmail.com | 1234 | testfname | +---------+------------+---------------------+---------------+------------+ SELECT * FROM Chatlog +--------+------+---------------------------------+-----------------+--------------+ | postid | id | message | sent_by | date_created | +--------+------+---------------------------------+-----------------+--------------+ | 1 | 1 | hellooo | test@test.com | NULL | | 2 | 1 | meowww | test@test.com | NULL | | 3 | 1 | yesssss | test@test.com | NULL | | 4 | 2 | This is a carrot meant for cats | test@test.com | NULL | | 5 | 2 | Yesss I can post on this | test@test.com | NULL | | 6 | 2 | They are here | hello@gmail.com | NULL | +--------+------+---------------------------------+-----------------+--------------+ +--------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+----------------+ | postid | int(11) unsigned | NO | PRI | NULL | auto_increment | | id | int(11) | YES | | NULL | | | message | text | YES | | NULL | | | sent_by | varchar(50) | YES | | NULL | | | date_created | int(11) | YES | | NULL | | +--------------+------------------+------+-----+---------+----------------+