'On delete cascade on foreign key not working [duplicate]

I am doing a TODO list app and I'm trying to delete a list and every task which has the referencing listID.The problem is that on delete cascade is not working and when I delete the list the tasks are still there. This is my code:

CREATE TABLE IF NOT EXISTS Lists(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT
)

CREATE TABLE IF NOT EXISTS Tasks(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    txt TEXT,
    listID INTEGER,
    completed BOOLEAN NOT NULL DEFAULT 0,
    FOREIGN KEY (listID) REFERENCES Lists(id) ON DELETE CASCADE
)

INSERT INTO Lists (name)
VALUES("TEST1")

INSERT INTO Tasks(txt,listID)
VALUES("test1",1)

INSERT INTO Tasks(txt,listID)
VALUES("test2",1)

DELETE FROM Lists 
WHERE id = 1 


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source