spec/dummy/db/test.sqlite3 in tasuku-0.0.1 vs spec/dummy/db/test.sqlite3 in tasuku-0.1.0

- old
+ new

@@ -1,28 +1,24 @@ -SQLite format 3@ 8"8-%  , - N,MJyl_2*IIOtabletasks_taskables_text_responsestasks_taskables_text_responsesCREATE TABLE "tasks_taskables_text_responses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "request_id" integer, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime) -GGtabletasks_taskables_text_requeststasks_taskables_text_requestsCREATE TABLE "tasks_taskables_text_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "description" text, "created_at" datetime, "updated_at" datetime, "image" varchar(255))9??tabletasks_taskables_questionstasks_taskables_questionsCREATE TABLE "tasks_taskables_questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "created_at" datetime, "updated_at" datetime, "description" text, "multiple" boolean, "show_statistics" boolean DEFAULT 't', "image" varchar(255))N oIqindexindex_tasks_taskables_question_votes_on_option_idtasks_taskables_question_votesCREATE INDEX "index_tasks_taskables_question_votes_on_option_id" ON "tasks_taskables_question_votes" ("option_id")N oIqindexindex_tasks_taskables_question_votes_on_answer_idtasks_taskables_question_votes CREATE INDEX "index_tasks_taskables_question_votes_on_answer_id" ON "tasks_taskables_question_votes" ("answer_id") II{tabletasks_taskables_question_votestasks_taskables_question_votes CREATE TABLE "tasks_taskables_question_votes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "answer_id" integer, "option_id" integer, "created_at" datetime, "updated_at" datetime)\ -wMindexindex_tasks_taskables_question_options_on_question_idtasks_taskables_question_options CREATE INDEX "index_tasks_taskables_question_options_on_question_id" ON "tasks_taskables_question_options" ("question_id") MM1tabletasks_taskables_question_optionstasks_taskables_question_options -CREATE TABLE "tasks_taskables_question_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "question_id" integer, "created_at" datetime, "updated_at" datetime, "correct" boolean DEFAULT 'f')KYM}indextasks_taskable_question_answers_authortasks_taskables_question_answers CREATE INDEX "tasks_taskable_question_answers_author" ON "tasks_taskables_question_answers" ("author_id", "author_type") MM tabletasks_taskables_question_answerstasks_taskables_question_answersCREATE TABLE "tasks_taskables_question_answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime)UsKyindexindex_tasks_taskables_image_responses_on_request_idtasks_taskables_image_responsesCREATE INDEX "index_tasks_taskables_image_responses_on_request_id" ON "tasks_taskables_image_responses" ("request_id")GWKyindextasks_taskable_image_responses_authortasks_taskables_image_responsesCREATE INDEX "tasks_taskable_image_responses_author" ON "tasks_taskables_image_responses" ("author_id", "author_type")6KKctabletasks_taskables_image_responsestasks_taskables_image_responsesCREATE TABLE "tasks_taskables_image_responses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image" varchar(255), "request_id" integer, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime) IItabletasks_taskables_image_requeststasks_taskables_image_requestsCREATE TABLE "tasks_taskables_image_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "created_at" datetime, "updated_at" datetime, "description" text, "image" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq){tablearticlesarticlesCREATE TABLE "articles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" date     - +SQLite format 3@ !$_!-%  ( _CYMKYM}indextasks_taskable_question_answers_authortasks_taskables_question_answersCREATE INDEX "tasks_taskable_question_answers_author" ON "tasks_taskables_question_answers" ("author_id", "author_type")VsMyindexindex_tasks_taskables_question_answers_on_option_idtasks_taskables_question_answersCREATE INDEX "index_tasks_taskables_question_answers_on_option_id" ON "tasks_taskables_question_answers" ("option_id")"MM7tabletasks_taskables_question_answerstasks_taskables_question_answersCREATE TABLE "tasks_taskables_question_answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "option_id" integer, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime)\wMindexindex_tasks_taskables_question_options_on_question_idtasks_taskables_question_optionsCREATE INDEX "index_tasks_taskables_question_options_on_question_id" ON "tasks_taskables_question_options" ("question_id")MMstabletasks_taskables_question_optionstasks_taskables_question_optionsCREATE TABLE "tasks_taskables_question_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "question_id" integer, "created_at" datetime, "updated_at" datetime)T ??7tabletasks_taskables_questionstasks_taskables_questionsCREATE TABLE "tasks_taskables_questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "created_at" datetime, "updated_at" datetime) {tablearticlesarticles CREATE TABLE "articles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime) utableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)qka#indextasks_taskable_verification_confirmation_authortasks_taskables_verification_confirmations CREATE INDEX "tasks_taskable_verification_confirmation_author" ON "tasks_taskables_verification_confirmations" ("author_id", "author_type")t waindextasks_taskable_verification_confirmation_verificationtasks_taskables_verification_confirmations +CREATE INDEX "tasks_taskable_verification_confirmation_verification" ON "tasks_taskables_verification_confirmations" ("verification_id")FaaWtabletasks_taskables_verification_confirmationstasks_taskables_verification_confirmations CREATE TABLE "tasks_taskables_verification_confirmations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "verification_id" integer, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime)bgG#indexindex_tasks_taskable_verifications_verifiabletasks_taskables_verificationsCREATE UNIQUE INDEX "index_tasks_taskable_verifications_verifiable" ON "tasks_taskables_verifications" ("verifiable_id", "verifiable_type") GGtabletasks_taskables_verificationstasks_taskables_verificationsCREATE TABLE "tasks_taskables_verifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "verifiable_id" integer, "verifiable_type" varchar(255), "created_at" datetime, "updated_at" datetime)=q#sindexindex_tasks_tasks_on_taskable_id_and_taskable_typetasks_tasksCREATE INDEX "index_tasks_tasks_on_taskable_id_and_taskable_type" ON "tasks_tasks" ("taskable_id", "taskable_type")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)R##ktabletasks_taskstasks_tasksCREATE TABLE "tasks_tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "taskable_id" integer, "taskable_type" varchar(255), "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT   p^L:(tbP>, )20140610121130)20140606112652)20140606072225)20140605124021)20140605095241)20140604075046)20140523091152)20140521134515)20140520122938)20140514082143)20140514082129)20140512131526)20140512121254)20140512120632)20140512074135)20140512072931)20140404130151)20140404113158 )20140403090537 )20140402135306 )20140402132837 +)20140320123047 )20140316221703)20140316204119)20140316203812)20140316203422)20140315185502)20140315162017)20140315153512)20140315152116)20140315151838 + |iVC0 +r_L9& )20140610121130)20140606112652)20140606072225)20140605124021)20140605095241)20140604075046)20140523091152)20140521134515)20140520122938)20140514082143)20140514082129)20140512131526)20140512121254)20140512120632)20140512074135)20140512072931)20140404130151)20140404113158)20140403090537 )20140402135306 )20140402132837 )20140320123047 +)20140316221703 )20140316204119)20140316203812)20140316203422)20140315185502)20140315162017)20140315153512)20140315152116) 20140315151838       + +       +   &&#&xd: _ +r  (q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "sq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")%%Ctabletasuku_taskstasuku_tasksCREATE TABLE "tasuku_tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "taskable_id" integer, "taskable_type" varchar(255), "created_at" datetime, "updated_at" datetime, "obligatory" boolean DEFAULT 'f' NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)IItabletasuku_taskables_verificationstasuku_taskables_verificationsCREATE TABLE "tasuku_taskables_verifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "verifiable_id" integer, "verifiable_type" varchar(255), "created_at" datetime, "updated_at" datetime)IccYtabletasuku_taskables_verification_confirmationstasuku_taskables_verification_confirmations CREATE TABLE "tasuku_taskables_verification_confirmations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "verification_id" integer, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime) utableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime) {tablearticlesarticles CREATE TABLE "articles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)< AAtabletasuku_taskables_questionstasuku_taskables_questionsCREATE TABLE "tasuku_taskables_questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "created_at" datetime, "updated_at" datetime, "description" text, "multiple" boolean, "show_statistics" boolean DEFAULT 't', "image" varchar(255))"OO3tabletasuku_taskables_question_optionstasuku_taskables_question_optionsCREATE TABLE "tasuku_taskables_question_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "question_id" integer, "created_at" datetime, "updated_at" datetime, "correct" boolean DEFAULT 'f')KKtabletasuku_taskables_image_requeststasuku_taskables_image_requestsCREATE TABLE "tasuku_taskables_image_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "created_at" datetime, "updated_at" datetime, "description" text, "image" varchar(255))9MMetabletasuku_taskables_image_responsestasuku_taskables_image_responsesCREATE TABLE "tasuku_taskables_image_responses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image" varchar(255), "request_id" integer, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime) +GGtabletasuku_taskables_url_requeststasuku_taskables_url_requestsCREATE TABLE "tasuku_taskables_url_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "description" text, "created_at" datetime, "updated_at" datetime, "image" varchar(255)))IIMtabletasuku_taskables_url_responsestasuku_taskables_url_responsesCREATE TABLE "tasuku_taskables_url_responses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "url" text, "request_id" integer, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime)KK}tabletasuku_taskables_question_votestasuku_taskables_question_votesCREATE TABLE "tasuku_taskables_question_votes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "answer_id" integer, "option_id" integer, "created_at" datetime, "updated_at" datetime)OOtabletasuku_taskables_question_answerstasuku_taskables_question_answersCREATE TABLE "tasuku_taskables_question_answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime)  __oe:  + y t]!A1s%windexindex_tasuku_tasks_on_taskable_id_and !IItabletasuku_taskables_text_requeststasuku_taskables_text_requestsCREATE TABLE "tasuku_taskables_text_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "description" text, "created_at" datetime, "updated_at" datetime, "image" varchar(255))-"KKQtabletasuku_taskables_text_responsestasuku_taskables_text_responses!CREATE TABLE "tasuku_taskables_text_responses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "request_id" integer, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime)d$SS/tabletasuku_taskables_taskable_responsestasuku_taskables_taskable_responses#CREATE TABLE "tasuku_taskables_taskable_responses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "submittable_id" integer, "submittable_type" varchar(255), "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime, "task_id" integer)K%YM}indextasuku_taskable_image_responses_authortasuku_taskables_image_responsesCREATE INDEX "tasuku_taskable_image_responses_author" ON "tasuku_taskables_image_responses" ("author_id", "author_type")Y&uM}indexindex_tasuku_taskables_image_responses_on_request_idtasuku_taskables_image_responsesCREATE INDEX "index_tasuku_taskables_image_responses_on_request_id" ON "tasuku_taskables_image_responses" ("request_id")O'[Oindextasuku_taskable_question_answers_authortasuku_taskables_question_answers +CREATE INDEX "tasuku_taskable_question_answers_author" ON "tasuku_taskables_question_answers" ("author_id", "author_type")`(yOindexindex_tasuku_taskables_question_options_on_question_idtasuku_taskables_question_options CREATE INDEX "index_tasuku_taskables_question_options_on_question_id" ON "tasuku_taskables_question_options" ("question_id")R)qKuindexindex_tasuku_taskables_question_votes_on_answer_idtasuku_taskables_question_votesCREATE INDEX "index_tasuku_taskables_question_votes_on_answer_id" ON "tasuku_taskables_question_votes" ("answer_id")R*qKuindexindex_tasuku_taskables_question_votes_on_option_idtasuku_taskables_question_votesCREATE INDEX "index_tasuku_taskables_question_votes_on_option_id" ON "tasuku_taskables_question_votes" ("option_id")N+WKindextasuku_taskable_text_responses_authortasuku_taskables_text_responsesCREATE UNIQUE INDEX "tasuku_taskable_text_responses_author" ON "tasuku_taskables_text_responses" ("author_id", "author_type")J,UIindextasuku_taskable_url_responses_authortasuku_taskables_url_responsesCREATE UNIQUE INDEX "tasuku_taskable_url_responses_author" ON "tasuku_taskables_url_responses" ("author_id", "author_type")Q-qIuindexindex_tasuku_taskables_url_responses_on_request_idtasuku_taskables_url_responsesCREATE INDEX "index_tasuku_taskables_url_responses_on_request_id" ON "tasuku_taskables_url_responses" ("request_id")u.mc'indextasuku_taskable_verification_confirmation_authortasuku_taskables_verification_confirmationsCREATE INDEX "tasuku_taskable_verification_confirmation_author" ON "tasuku_taskables_verification_confirmations" ("author_id", "author_type")x/yc!indextasuku_taskable_verification_confirmation_verificationtasuku_taskables_verification_confirmations CREATE INDEX "tasuku_taskable_verification_confirmation_verification" ON "tasuku_taskables_verification_confirmations" ("verification_id")f0iI'indexindex_tasuku_taskable_verifications_verifiabletasuku_taskables_verifications"CREATE UNIQUE INDEX "index_tasuku_taskable_verifications_verifiable" ON "tasuku_taskables_verifications" ("verifiable_id", "verifiable_type")A1s%windexindex_tasuku_tasks_on_taskable_id_and_taskable_typetasuku_tasks$CREATE INDEX "index_tasuku_tasks_on_taskable_id_and_taskable_type" ON "tasuku_tasks" ("taskable_id", "taskable_type")\2uS}indexindex_tasuku_taskables_taskable_responses_on_task_idtasuku_taskables_taskable_responsesCREATE INDEX "index_tasuku_taskables_taskable_responses_on_task_id" ON "tasuku_taskables_taskable_responses" ("task_id")  -    - llUeh@ P - @  "  3a{tablearticlesarticlesCREATE TABLE "articles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) IItabletasks_taskables_image_requeststasks_taskables_image_requestsCREATE TABLE "tasks_taskables_image_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "created_at" datetime, "updated_at" datetime, "description" text, "image" varchar(255))6KKctabletasks_taskables_image_responsestasks_taskables_image_responsesCREATE TABLE "tasks_taskables_image_responses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image" varchar(255), "request_id" integer, "author_id" integer, "author_type" varchar(255), "c{tablearticlesarticlesCREATE TABLE "articles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) IItabletasks_taskables_image_requeststasks_taskables_image_requestsCREATE TABLE "tasks_taskables_image_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "created_at" datetime, "updated_at" datetime, "description" text, "image" varchar(255))6KKctabletasks_taskables_image_responsestasks_taskables_image_responsesCREATE TABLE "tasks_taskables_image_responses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image" varchar(255), "request_id" integer, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime)GWKyindextasks_taskable_image_responses_authortasks_taskables_image_responsesCREATE INDEX "tasks_taskable_image_responses_author" ON "tasks_taskables_image_responses" ("author_id", "author_type")UsKyindexindex_tasks_taskables_image_responses_on_request_idtasks_taskables_image_responsesCREATE INDEX "index_tasks_taskables_image_responses_on_request_id" ON "tasks_taskables_image_responses" ("request_id") MM tabletasks_taskables_question_answerstasks_taskables_question_answersCREATE TABLE "tasks_taskables_question_answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime)KYM}indextasks_taskable_question_answers_authortasks_taskables_question_answers CREATE INDEX "tasks_taskable_question_answers_author" ON "tasks_taskables_question_answers" ("author_id", "author_type") MM1tabletasks_taskables_question_optionstasks_taskables_question_options -CREATE TABLE "tasks_taskables_question_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "question_id" integer, "created_at" datetime, "updated_at" datetime, "correct" boolean DEFAULT 'f')\ -wMindexindex_tasks_taskables_question_options_on_question_idtasks_taskables_question_options CREATE INDEX "index_tasks_taskables_question_options_on_question_id" ON "tasks_taskables_question_options" ("question_id") II{tabletasks_taskables_question_votestasks_taskables_question_votes CREATE TABLE "tasks_taskables_question_votes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "answer_id" integer, "option_id" integer, "created_at" datetime, "updated_at" datetime)N oIqindexindex_tasks_taskables_question_votes_on_answer_idtasks_taskables_question_votes CREATE INDEX "index_tasks_taskables_question_votes_on_answer_id" ON "tasks_taskables_question_votes" ("answer_id")N oIqindexindex_tasks_taskables_question_votes_on_option_idtasks_taskables_question_votesCREATE INDEX "index_tasks_taskables_question_votes_on_option_id" ON "tasks_taskables_question_votes" ("option_id")9??tabletasks_taskables_questionstasks_taskables_questionsCREATE TABLE "tasks_taskables_questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "created_at" datetime, "updated_at" datetime, "description" text, "multiple" boolean, "show_statistics" boolean DEFAULT 't', "image" varchar(255))  ?  ? - - !  ED=//indexunique_schema_migrationsschema_migrations"CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrations!CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) utableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)=q#sindexindex_tasks_tasks_on_taskable_id_and_taskable_typetasks_tasksCREATE INDEX "index_tasks_tasks_on_taskable_id_and_taskable_type" ON "tasks_tasks" ("taskable_id", "taskable_type")}##Atabletasks_taskstasks_tasksCREATE TABLE "tasks_tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "taskable_id" integer, "taskable_type" varchar(255), "created_at" datetime, "updated_at" datetime, "obligatory" boolean DEFAULT 'f' NOT NULL) -GGtabletasks_taskables_text_requeststasks_taskables_text_requestsCREATE TABLE "tasks_taskables_text_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "description" text, "created_at" datetime, "updated_at" datetime, "image" varchar(255))*IIOtabletasks_taskables_text_responsestasks_taskables_text_responsesCREATE TABLE "tasks_taskables_text_responses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "request_id" integer, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime)JUIindextasks_taskable_text_responses_authortasks_taskables_text_responsesCREATE UNIQUE INDEX "tasks_taskable_text_responses_author" ON "tasks_taskables_text_responses" ("author_id", "author_type")EEtabletasks_taskables_url_requeststasks_taskables_url_requestsCREATE TABLE "tasks_taskables_url_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" text, "description" text, "created_at" datetime, "updated_at" datetime, "image" varchar(255))&GGKtabletasks_taskables_url_responsestasks_taskables_url_responsesCREATE TABLE "tasks_taskables_url_responses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "url" text, "request_id" integer, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime)FSGindextasks_taskable_url_responses_authortasks_taskables_url_responsesCREATE UNIQUE INDEX "tasks_taskable_url_responses_author" ON "tasks_taskables_url_responses" ("author_id", "author_type")MoGqindexindex_tasks_taskables_url_responses_on_request_idtasks_taskables_url_responsesCREATE INDEX "index_tasks_taskables_url_responses_on_request_id" ON "tasks_taskables_url_responses" ("request_id")FaaWtabletasks_taskables_verification_confirmationstasks_taskables_verification_confirmationsCREATE TABLE "tasks_taskables_verification_confirmations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "verification_id" integer, "author_id" integer, "author_type" varchar(255), "created_at" datetime, "updated_at" datetime)qka#indextasks_taskable_verification_confirmation_authortasks_taskables_verification_confirmationsCREATE INDEX "tasks_taskable_verification_confirmation_author" ON "tasks_taskables_verification_confirmations" ("author_id", "author_type")twaindextasks_taskable_verification_confirmation_verificationtasks_taskables_verification_confirmationsCREATE INDEX "tasks_taskable_verification_confirmation_verification" ON "tasks_taskables_verification_confirmations" ("verification_id") GGtabletasks_taskables_verificationstasks_taskables_verificationsCREATE TABLE "tasks_taskables_verifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "verifiable_id" integer, "verifiable_type" varchar(255), "created_at" datetime, "updated_at" datetime)bgG#indexindex_tasks_taskable_verifications_verifiabletasks_taskables_verificationsCREATE UNIQUE INDEX "index_tasks_taskable_verifications_verifiable" ON "tasks_taskables_verifications" ("verifiable_id", "verifiable_type")  +$"$ "$$$$$           -  ,p^L:(tbP>,)20140523091152)20140521134515)20140520122938)20140514082143)20140514082129)20140512131526)20140512121254)20140512120632)20140512074135)20140512072931)20140404130151)20140404113158)20140403090537 )20140402135306 )20140402132837 )20140320123047 -)20140316221703 )20140316204119)20140316203812)20140316203422)20140315153512)20140315152116)20140315151838)20140315185502)20140315162017)20140604075046 -|iVC0 -r_L9&)20140523091152)20140521134515)20140520122938)20140514082143)20140514082129)20140512131526)20140512121254)20140512120632)20140512074135)20140512072931)20140404130151)20140404113158)20140403090537)20140402135306 )20140402132837 )20140320123047 )20140316221703 -)20140316204119 )20140316203812)20140316203422)20140315153512)20140315152116)20140315151838)20140315185502)20140315162017) 20140604075046 + \ No newline at end of file