SQLite format 3@ 1%  Musers4(Q?tasks91projects tasks projects users  1 332008-10-16 14:15:462008-10-16 14:15:460 332008-10-16 14:12:052008-10-16 14:12:05 5 332008-10-16 14:16:022008-10-16 14:16:025 332008-10-16 14:12:202008-10-16 14:12:20 **|yIP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)q//tableschema_migrationsschema_migrations CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrations CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")MitablelocationslocationsCREATE TABLE "locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "notes" text, "user_id" integer, "created_at" datetime, "updated_at" datetime).;tablenotesnotesCREATE TABLE "notes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" text, "user_id" integer, "created_at" datetime, "updated_at" datetime)YtableprojectsprojectsCREATE TABLE "projects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "notes" text, "start_date" date, "end_date" date, "completed" boolean, "user_id" integer, "created_at" datetime, "updated_at" datetime) FktabletaskstasksCREATE TABLE "tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "notes" text, "start_time" datetime, "end_time" datetime, "completed" boolean, "next_action" boolean, "project_id" integer, "location_id" integer, "user_id" integer, "created_at" datetime, "updated_at" datetime)l7tableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "email" varchar(255), "created_at" datetime, "updated_at" datetime) 533spatten2008-10-16 14:11:562008-10-16 14:11:56 )20080729045550 )20080729045550