SQLite format 3@    )20090307211956)20090121125841)20081009223404)20081009223323)20080918210237)20080718205908)20080718205616 {{)20090307211956)20090121125841)20081009223404)20081009223323)20080918210237)20080718205908)20080718205616 8#33ryan's proj2009-08-06 04:24:432009-08-06 04:24:43  tasks projects authors 333task12009-08-06 04:24:432009-08-06 04:24:43 /33ryan2009-08-06 04:24:432009-08-06 04:24:43  6x9x4>OtableprojectsprojectsCREATE TABLE "projects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "author_id" integer)q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")%tableprojectsprojectsCREATE TABLE "projects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)IqtabletaskstasksCREATE TABLE "tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer, "name" varchar(255), "due_at" datetime, "created_at" datetime, "updated_at" datetime) |`b5|6 GtablecolorscolorsCREATE TABLE "colors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "task_id" integer, "created_at" datetime, "updated_at" datetime)& #tableauthorsauthorsCREATE TABLE "authors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime) G'!indexindex_projects_tags_on_tag_idprojects_tagsCREATE INDEX "index_projects_tags_on_tag_id" ON "projects_tags" ("tag_id") O'1indexindex_projects_tags_on_project_idprojects_tags CREATE INDEX "index_projects_tags_on_project_id" ON "projects_tags" ("project_id")l ''tableprojects_tagsprojects_tags CREATE TABLE "projects_tags" ("project_id" integer, "tag_id" integer)tabletagstags CREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)