add extjs 6.0.1 sources

[extjs.git] / extjs / examples / classic / simple-tasks / db / schema.sql

CREATE TABLE config (key VARCHAR(50) PRIMARY KEY, value VARCHAR(255));\r
CREATE TABLE task (id INTEGER PRIMARY KEY AUTOINCREMENT, title VARCHAR(255), list_id INTEGER, due DATE, reminder DATE, done INTEGER, note BLOB);\r
CREATE TABLE list (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(50), leaf INTEGER, lft INTEGER, rgt INTEGER);\r
\r
-- Since sqlite doesn't currently support foreign keys the following trigger is needed to make sqlite do the\r
-- equivalent of "ON DELETE CASCADE" on the task's "list_id" foreign key.\r
-- For more info see: http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers\r
CREATE TRIGGER fkd_task_list_id\r
    BEFORE DELETE ON list\r
    FOR EACH ROW BEGIN\r
        DELETE from task WHERE list_id = OLD.id;\r
    END;