Change field names in shortenedurl table

[emasters]

• created -> create_date
• creator -> creator_ip
• add last_use_date

shorten.php will need to be modified to reflect these changes.

[bdereta]

Nice code! I found a smaller issue in the shortenedurls.sql, LINE 25 reads: PRIMARY KEY (pkId). MySQL will throw an error: [Err] 1072 - Key column 'pkId' doesn't exist in table. It should read PRIMARY KEY (pkUserId).

One more thing: Your register method doesn't check if the user (email) already exists, which means a user can open multiple accounts with the same email address.