Users Table Structure

final_users.sql

CREATE TABLE'users' (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'password' text COLLATE utf8_unicode_ci NOT NULL,
'email' varchar(45) COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY ('id')
)

location.sql

CREATE TABLE 'location' (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'city' varchar(100) COLLATE utf8_unicode_ci NOT NULL,
'state' varchar(100) COLLATE utf8_unicode_ci NOT NULL,
'zip' varchar(100) COLLATE utf8_unicode_ci NOT NULL,
'users_id' int(10) unsigned NOT NULL,

 PRIMARY KEY ('id')
)

original_users_table.sql

CREATE TABLE'users' (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'firstname' varchar(45) COLLATE utf8_unicode_ci NOT NULL,
'lastname' varchar(45) COLLATE utf8_unicode_ci NOT NULL,
'password' text COLLATE utf8_unicode_ci NOT NULL,
'email' varchar(45) COLLATE utf8_unicode_ci NOT NULL,
'city' varchar(100) COLLATE utf8_unicode_ci NOT NULL,
'state' varchar(100) COLLATE utf8_unicode_ci NOT NULL,
'zip' varchar(100) COLLATE utf8_unicode_ci NOT NULL,
'phonenumber' varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
'role' enum('normal','administrator') COLLATE utf8_unicode_ci DEFAULT NULL,
'verified' tinyint(1) DEFAULT NULL,
'verification_link' varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
'remember_token' varchar(100) COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY ('id')
)

personal_info.sql

CREATE TABLE'personal_info' (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'firstname' varchar(45) COLLATE utf8_unicode_ci NOT NULL,
'lastname' varchar(45) COLLATE utf8_unicode_ci NOT NULL,
'users_id' int(10) unsigned NOT NULL,

 PRIMARY KEY ('id')
)

roles.sql

CREATE TABLE 'roles' (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'role' enum('normal','administrator') COLLATE utf8_unicode_ci DEFAULT NULL,
'users_id' int(10) unsigned NOT NULL,
 PRIMARY KEY ('id')
)