MariaDB [aaldana]> describe Portfolio;
+---------+------------------+------+-----+---------+----------------+
| Field   | Type             | Null | Key | Default | Extra          |
+---------+------------------+------+-----+---------+----------------+
| p_id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| p_name  | varchar(150)     | NO   |     | NULL    |                |
| p_image | varchar(150)     | NO   |     | NULL    |                |
| p_link  | varchar(150)     | NO   |     | NULL    |                |
+---------+------------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)



MariaDB [aaldana]> SELECT * FROM Portfolio;
+------+-------------------------+---------------+-------------------------------------------------------------------------+
| p_id | p_name                  | p_image       | p_link                                                                  |
+------+-------------------------+---------------+-------------------------------------------------------------------------+
|    1 | Apple Store Lab         | project1m.png | http://odin.cs.csubak.edu/~aaldana/cs3680/lab10/lab10.php               |
|    2 | C&A Home Improvement    | project2m.png | https://www.cahomeimp.com                                               |
|    3 | All Premium Contractors | project4m.png | http://www.cs.csubak.edu/~aaldana/cs2680/FinalProject/finalProject.html |
|    4 | All Premium Solar       | project3m.png | http://www.cs.csubak.edu/~aaldana/cs2680/FinalProject/finalProject.html |
+------+-------------------------+---------------+-------------------------------------------------------------------------+
4 rows in set (0.00 sec)



MariaDB [aaldana]> describe 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    |                |
+---------------+------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)



MariaDB [aaldana]> SELECT * FROM Users;
+---------+------------+-------------------+---------------+------------+
| user_id | user_uname | user_email        | user_password | user_fname |
+---------+------------+-------------------+---------------+------------+
|       1 | test       | test@test.com     | testpassword  | testfname  |
|       2 | aaldana    | aaldana2@csub.edu | password      | Abraham    |
+---------+------------+-------------------+---------------+------------+
2 rows in set (0.00 sec)