Made database schema more organized and portable

Removed the database schema's reliance on the TEXT datatype, which is not part of the
SQL standard and might not be reliable across implementations. Also cleaned up some of
the fields and added a UserType field.

Signed-off-by: Sebastian Lenartowicz <slenarto@uoguelph.ca>