You can download the completed changes here:
You will find a file called necessaryAlterations.sql
They are absolutely necessary in order to meet the requirements in your part of this project. The in no way alter the way that this other individual's site works. It is simply that we must have keys on the fields so that we know which to delete or accept.
We also need to be able to tell if an offer or request belongs to the logged in user. To do that, we need correctly set up foreign keys in order to assure referential integrity.
And, of course, we need the sentEmail table.
I've added comments to all of it. It is very easy to understand. Without these changes, your part really will not work.
So, with these changes, your part is completely done. I used the same style as the individual who made this site, so your instructor should be happy. I had to add email to the registration because the email requirements involve associating an email address to a user, not just a request or offer. The email must be on the registraiton record in order to meet that requirement. The sql file alters the registration table in order to add teh registration field. To continue using any existing accounts, you will need to update them to have an actual email. So, for instance, if you have an account called Milt, you would want to do something like:
With the changes, you can now delete a offer or request record if it was entered by the user who is logged in. So if you are logged in as the user who entered the request, you will see a delete option. If you are not the user that logged in, you will see an accept option.
Clicking delete simply deletes the record.
Clicking accept generates an "email" to both the logged in user and to the email address on the offer or request.
And by "email" I mean entries are made into the sentEmail table, as per the instructions.
So that's it. That meets the requirements of your part to the exactly, to the letter. I did everything in the same style as the individual who created the site. To accomplish this, I altered or added:
Let me know if you have any questions. I'm here to help.
Please remember to rate my answer. Thank you so much!