/samples/todo/todo.sql

http://github.com/keplerproject/orbit · SQL · 5 lines · 5 code · 0 blank · 0 comment · 0 complexity · e30410906537c8348b7f86542f3a7cd8 MD5 · raw file 

    

  1. CREATE TABLE todo_list
    2. 

  2.        ("id" INTEGER PRIMARY KEY NOT NULL,
    3. 

  3.        "title" VARCHAR(255) DEFAULT "",
    4. 

  4.        "done" BOOLEAN DEFAULT "f",
    5. 

  5.        "created_at" DATETIME);
    6.