DW

Users Table

USER ID Username Password firstname lastname userIMG
6 sharky@ocean.com ocean shark bait Default.jpg
7 ruby@rubyd.net *AA401FAAD43938E4E4AF20DA7D5F9 Ruby Davily Default.jpg
4 Mitch@mac.com *2470C0C06DEE42FD1618BB99005AD Mitchell Gohman
3 BlueMatt@yahoo.com *2470C0C06DEE42FD1618BB99005AD Matt Hunt
5 punkrocker23@yahoo.com password Jesse James Default.jpg
1 Justj02@aol.com *2470C0C06DEE42FD1618BB99005AD Jesse Jimenez
2 caesar@vargas.com *2470C0C06DEE42FD1618BB99005AD Caesar Vargas

Company Table

CompID Comp Name CompBio CompLogoIMG
1 Pepsi This is hard.
2 Mountain Dew ROCK ON!

User Phone ( I combined both together.. I was falling behind in the exercise)

UserID Phone Phone Type
shark 543-333-3443 mobile
shark 123-554-3344 work
shark 123-456-7890 primary
shark 456-769-4954 mobile
Ruby 123-456-7890 primary
Ruby 456-769-4954 mobile
Ruby 543-333-3443 mobile
Ruby 123-554-3344 work
Mitchell 543-333-3443 mobile
Mitchell 123-554-3344 work
Mitchell 123-456-7890 primary
Mitchell 456-769-4954 mobile
Matt 123-456-7890 primary
Matt 456-769-4954 mobile
Matt 543-333-3443 mobile
Matt 123-554-3344 work
Jesse 123-456-7890 primary
Jesse 456-769-4954 mobile
Jesse 543-333-3443 mobile
Jesse 123-554-3344 work
Jesse 123-456-7890 primary
Jesse 456-769-4954 mobile
Jesse 543-333-3443 mobile
Jesse 123-554-3344 work
Caesar 543-333-3443 mobile
Caesar 123-554-3344 work
Caesar 123-456-7890 primary
Caesar 456-769-4954 mobile