Returning back to the owner and requester dropdowns
Finally, we can turn back to what we set out to do, which is to change the Owner and Requester fields to be dropdown choices of valid members of that project. In order to do this properly, we need to associate some users with a project. As user management is the focus of Chapter 7 and Chapter 8, we will do this quickly by adding the association directly to the database via SQL. We already added two new test users as part of our seed data in our earlier DDL statements. As a reminder, that insert statement was as follows:
INSERT INTO 'tbl_user'
('email', 'username', 'password')
VALUES
('test1@notanaddress.com','Test_User_One', MD5('test1')),
('test2@notanaddress.com','Test_User_Two', MD5('test2'))
;This created two new users in our system with ID's 1 and 2. Let's manually assign these two users to Project #1.
To do so, run the following insert statement against your trackstar_dev and trackstar_test databases:
INSERT INTO 'tbl_project_user_assignment...
