SQL Assignment 2- 330

DROP TABLE IF EXISTS employee ; CREATE TABLE IF NOT EXISTS employee ( idEmployee INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FirstName NULL DEFAULT NULL, LastName TEXT NULL DEFAULT NULL, Location TEXT NULL DEFAULT NULL); DROP TABLE IF EXISTS tickets ; CREATE TABLE IF NOT EXISTS tickets ( idTickets INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, Description TEXT NULL DEFAULT NULL, Duration INTEGER NULL DEFAULT NULL, Priority TEXT NULL DEFAULT NULL, Status TEXT NULL DEFAULT NULL, Employee_idEmployee INTEGER NULL DEFAULT NULL);