Expresso Employee Table

Hi, I just started the expresso project and I get a test fail on the employee table. I checked my answer with the solution code and the functionality should be the same but if I have any syntax errors or anything like that could someone tell me?

Thanks.

const sqlite3 = require('sqlite3'); const db = new sqlite3.Database(process.env.TEST_DATABASE || './database.sqlite') db.serialize(function() { db.run(`CREATE TABLE IF NOT EXISTS Employee ( id INTEGER NOT NULL, name TEXT NOT NULL, position TEXT NOT NULL, wage INTEGER NOT NULL, is_currently_employee INTEGER NOT NULL DEFAULT 1, PRIMARY KEY (id) )`); db.run(`CREATE TABLE IF NOT EXISTS Timesheet ( id INTEGER NOT NULL, hours INTERGER NOT NULL, rate INTEGER NOT NULL, date INTEGER NOT NULL, employee_id INTEGER NOT NULL, PRIMARY KEY (id), FOREIGN KEY (employee_id) REFERENCES Employee(id) )`); db.run(`CREATE TABLE IF NOT EXISTS Menu ( id INTEGER NOT NULL, title TEXT NOT NULL, PRIMARY KEY (id) )`); db.run(`CREATE TABLE IF NOT EXISTS MenuItem ( id INTEGER NOT NULL, name TEXT NOT NULL, description TEXT, inventory INTEGER NOT NULL, price INTEGER NOT NULL, menu_id INTEGER NOT NULL, PRIMARY KEY (id), FOREIGN KEY (menu_id) REFERENCES Menu(id) )`) });

Unfortunately, SQL code won’t work in the CodeByte option.

Can you provide a link to the lesson?

if you are still stuck on this… I think the column titled ‘is_currently_employee’ should actually be titled ‘is_current_employee’.