-- Create the todos database
CREATE DATABASE todos;
USE todos;

-- create a todos table in the todos database
CREATE TABLE todos(
   task_num INT,
   task_name VARCHAR(255),
   due_date DATETIME,
   task_type VARCHAR(255),
   PRIMARY KEY(task_num)
);

-- Insert two values into the todos database
INSERT INTO todos (task_num, task_name, due_date, task_type) 
  VALUES (1,
    "post creative homework on course page",
    DATE_ADD(NOW(), INTERVAL 1 HOUR),
    "CSE154");
    
INSERT INTO todos (task_num, task_name, due_date, task_type) 
  VALUES (2,
    "prepare the final exam",
    DATE_ADD(NOW(), INTERVAL 14 DAY),
    "CSE154");