Create a MySQL table for users

[calstatelaacm]

Make a MySQL script for a Human Users Table that does the following

Table name: users

Columns:

• userid (unique; autoincremented when inserted to database; is a number)
• firstname (string)
• lastname (string)
• username (string)
• pswd (string)
• cin (string)
• phonenumber (string)
• emailaddress (string)
• birthday (sql date)
• secretcode (string)

Insert a few dummy users.

Document the table details in the database wiki page. Document the dummy accounts in the wiki page as well.

append the sql script inside the sql folder in backend->src->main->resources->setup_db

[PranilDahal]

Finished.