/samples/blog/blog_schema.sql

http://github.com/keplerproject/orbit · SQL · 20 lines · 18 code · 2 blank · 0 comment · 0 complexity · db296e57675bdb575f98cc5627e482c6 MD5 · raw file 

    

  1. CREATE TABLE blog_post
    2. 

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

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

  4.        "body" TEXT DEFAULT NULL,
    5. 

  5.        "n_comments" INTEGER DEFAULT NULL,
    6. 

  6.        "published_at" DATETIME DEFAULT NULL);
    7. 

  7. 

  8. CREATE TABLE blog_comment
    9. 

  9.        ("id" INTEGER PRIMARY KEY NOT NULL,
    10. 

  10.        "post_id" INTEGER DEFAULT NULL,
    11. 

  11.        "author" VARCHAR(255) DEFAULT NULL,
    12. 

  12.        "email" VARCHAR(255) DEFAULT NULL,
    13. 

  13.        "url" VARCHAR(255) DEFAULT NULL,
    14. 

  14.        "body" TEXT DEFAULT NULL,
    15. 

  15.        "created_at" DATETIME DEFAULT NULL);
    16. 

  16. 

  17. CREATE TABLE blog_page
    18. 

  18.        ("id" INTEGER PRIMARY KEY NOT NULL,
    19. 

  19.        "title" VARCHAR(30) DEFAULT NULL,
    20. 

  20.        "body" TEXT DEFAULT NULL);
    21.