Next, let$$s create a second table to store information about our employees. Note that to create a foreign key, we need to use the MySQL syntax meaning you will have to declare the foreign key constraint on its own line. Create a table with the following fields with the listed constraints: $$ employee$\_$id is our key field for this table. It should be an integer and auto increment. $$ employee$\_$name is a required field to store names. $$ job$\_$id is an integer that refers to the job$\_$id field in the jobs table. It is also required. $($This will require an additional $$ hire$\_$date is a date. It should default to the day we create the record.

CREATE TABLE employees $($

employee$\_$id INT AUTO$\_$INCREMENT PRIMARY KEY,

employee$\_$name VARCHAR$(255)$ NOT NULL,

job$\_$id INT NOT NULL,

hire$\_$date DATE DEFAULT CURRENT$\_$DATE,

FOREIGN KEY $($job$\_$id$)$ REFERENCES job$\_$titles$($job$\_$id$)$

$)$;

I keep getting an error message with the current date next to hire date. I do not know how to fix that problem.