desc 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    |                |
+---------------+------------------+------+-----+---------+----------------+

SELECT * FROM Users;
+---------+----------------+----------------------+---------------+------------+
| user_id | user_uname     | user_email           | user_password | user_fname |
+---------+----------------+----------------------+---------------+------------+
|       1 | eddie          | eddie@email.com      | password      | Eddie      |
|       2 | test           | test@test.com        | testpassword  | testfname  |
|       5 | kaeli1         | kaeli@email.com      | pass          | kaeli      |
|       6 | morty1         | morty@email.com      | pass          | morty      |
|       7 | snoop1         | snoopdizzy@email.com | pass          | Snoop Dogg |
|       8 | ricklovesmorty | rick@email.com       | pass          | Rick       |
|       9 | ed2            | ed@email.com         | password      | ed         |
+---------+----------------+----------------------+---------------+------------+

desc Gear;
+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| gear_id          | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| gear_name        | varchar(127)        | YES  |     | NULL    |                |
| gear_img         | varchar(127)        | YES  |     | NULL    |                |
| gear_description | varchar(511)        | YES  |     | NULL    |                |
| gear_price       | decimal(10,2)       | YES  |     | NULL    |                |
| gear_rating      | tinyint(3) unsigned | YES  |     | NULL    |                |
| gear_sku         | char(32)            | YES  |     | NULL    |                |
| gear_stock       | int(10) unsigned    | YES  |     | NULL    |                |
| gear_sport       | varchar(127)        | YES  |     | NULL    |                |
+------------------+---------------------+------+-----+---------+----------------+

SELECT * FROM Gear;
+---------+--------------------------+----------------+----------------------------------------+------------+-------------+----------+------------+------------+
| gear_id | gear_name                | gear_img       | gear_description                       | gear_price | gear_rating | gear_sku | gear_stock | gear_sport |
+---------+--------------------------+----------------+----------------------------------------+------------+-------------+----------+------------+------------+
|       1 | Steph Curry Jersey       | curry.jpeg     | Golden State Warriors Curry Jersey     |      74.99 |           5 | 112230   |         20 | NBA        |
|       2 | LeBron James Jersey      | james.jpeg     | Clevland Cavaliers James Jersey        |      84.99 |           5 | 112333   |         10 | NBA        |
|       3 | Kevin Durant Jersey      | durant.jpeg    | Golden State Durant Jersey             |      84.99 |           4 | 112430   |         10 | NBA        |
|       4 | Russell Westbrook Jersey | westbrook.jpeg | Oklahoma City Thunder Westbrook Jersey |      69.99 |           4 | 112433   |          5 | NBA        |
|       5 | Kyrie Irving Jersey      | irving.jpeg    | Boston Celtics Irving Jersey           |      79.99 |           4 | 112435   |          2 | NBA        |
|       6 | James Harden Jersey      | harden.jpeg    | Houston Rockets Harden Jersey          |      79.99 |           5 | 122433   |          8 | NBA        |
|       7 | Mike Trout Jersey        | trout.jpeg     | Los Angeles Angels Trout Jersey        |      99.99 |           5 | 122434   |         15 | MLB        |
|       8 | Shohei Ohtani Jersey     | ohtani.jpeg    | Los Angeles Angels Ohtani Jersey       |      99.99 |           5 | 122417   |         10 | MLB        |
|       9 | Jose Altuve Jersey       | altuve.jpeg    | Houston Astros Altuve Jersey           |      79.99 |           4 | 122439   |         10 | MLB        |
|      10 | Clayton Kershaw Jersey   | kershaw.jpeg   | Los Angeles Dodgers Kershaw Jersey     |      69.99 |           4 | 124230   |          5 | MLB        |
|      11 | Mookie Betts Jersey      | betts.jpeg     | Boston Red Sox Betts Jersey            |      89.99 |           5 | 124250   |          0 | MLB        |
|      12 | Giancarlo Stanton Jersey | stanton.jpeg   | New York Yankees Stanton Jersey        |      79.99 |           4 | 124200   |          5 | MLB        |
|      13 | Tom Brady Jersey         | brady.jpeg     | New England Patriots Brady Jersey      |     109.99 |           5 | 144204   |         20 | NFL        |
|      14 | Antonio Brown Jersey     | brown.jpeg     | Pittsburgh Steelers Brown Jersey       |      99.99 |           4 | 144505   |         10 | NFL        |
|      15 | Odell Beckham Jersey     | beckham.jpeg   | New York Giants Beckham Jersey         |      99.99 |           5 | 144303   |         15 | NFL        |
|      16 | Ezekiel Elliott Jersey   | elliott.jpeg   | Dallas Cowboys Elliott Jersey          |      89.99 |           4 | 145553   |         10 | NFL        |
|      17 | Aaron Rodgers Jersey     | rodgers.jpeg   | Green Bay Packers Jersey               |      89.99 |           4 | 164454   |         10 | NFL        |
|      18 | Von Miller Jersey        | miller.jpeg    | Denver Broncos Miller Jersey           |      79.99 |           4 | 166444   |          5 | NFL        |
|      19 | Lionel Messi Jersey      | messi.jpeg     | Barcelona Messi Jersey                 |     109.99 |           5 | 188444   |         10 | Soccer     |
|      20 | Andres Iniesta Jersey    | iniesta.jpeg   | Barcelona Iniesta Jersey               |      99.99 |           4 | 188544   |         10 | Soccer     |
|      21 | Cristiano Ronaldo Jersey | ronaldo.jpeg   | Real Madrid Ronaldo Jersey             |     109.99 |           5 | 188555   |         10 | Soccer     |
|      22 | Marcelo Vieira Jersey    | marcelo.jpeg   | Real Madrid Marcelo Jersey             |      99.99 |           4 | 188544   |          5 | Soccer     |
|      23 | Luis Suarez Jersey       | suarez.jpeg    | Barcelona Suarez Jersey                |      99.99 |           4 | 188568   |          5 | Soccer     |
|      24 | Saul Niguez Jersey       | niguez.jpg     | Atletico Madrid Niguez Jersey          |      99.99 |           4 | 188568   |          5 | Soccer     |
+---------+--------------------------+----------------+----------------------------------------+------------+-------------+----------+------------+-----------