/apps/timeline/sql/start.sql

http://zoop.googlecode.com/ · SQL · 12 lines · 10 code · 2 blank · 0 comment · 0 complexity · 97e5309865c8d95141b6102ed3bac6cb MD5 · raw file 

    

  1. begin;
    2. 

  2. 

  3. create table entry
    4. 

  4. (
    5. 

  5.     "id" serial primary key,
    6. 

  6.     "start" timestamp with time zone,
    7. 

  7.     "end" timestamp with time zone,
    8. 

  8.     "is_duration" boolean,
    9. 

  9.     "title" text
    10. 

  10. );
    11. 

  11. 

  12. commit;
    13.