CREATE TABLE IF NOT EXIST list {
    id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(30) NOT NULL
     
};
 
--INSERT INTO list VALUES(1, MY List);
INSERT INTO list(name) VALUES("My List"), ("Another List");

CREATE TABLE IF NOT EXIST task {
    id INTEGER NOT NULL AUTO_INCREMENT,
    list_id INTEGER NOT NULL,
    description VARCHAR(255) NOT NULL,
    deadline DATETIME DEFAULT NULL,
    status TINYINT NOT NULL DEFAULT 0,

    PRIMARY KEY (id),
    FOREIGN KEY (list_id) REFERENCE list(id)
}
--SELECT * FROM task,
--SELECT * FROM task,
--SELECT * description FROM task;
--SELECT description, deadline FROM task WHERE list_id =