spec/dummy/db/test.sqlite3 in quizzes-0.1.0 vs spec/dummy/db/test.sqlite3 in quizzes-0.1.1
- old
+ new
@@ -1,5 +1,5 @@
-SQLite format 3 @ : : -
+SQLite format 3 @ ] ] -
)20160816213825)20160816213545)20160816212850)20160816211838)20160816211615)20160816202207
)20160816213825)20160816213545)20160816212850)20160816211838)20160816211615) 20160816202207
Wk x//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/ indexsqlite_autoindex_schema_migrations_1schema_migrationsN55?tablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G[5 indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataw)))tablequizzes_levelsquizzes_levelsCREATE TABLE "quizzes_levels" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number_of_questions" integer, "name" varchar, "code" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)
me e//ytablequizzes_questionsquizzes_questionsCREATE TABLE "quizzes_questions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" varchar, "level_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)S/9indexindex_quizzes_questions_on_level_idquizzes_questionsCREATE INDEX "index_quizzes_questions_on_level_id" ON "quizzes_questions" ("level_id")u ++!tablequizzes_answersquizzes_answersCREATE TABLE "quizzes_answers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "text" varchar, "question_id" integer, "correct" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
U+=indexindex_quizzes_answers_on_question_idquizzes_answers
CREATE INDEX "index_quizzes_answers_on_question_id" ON "quizzes_answers" ("question_id")
\ No newline at end of file