spec/dummy/db/test.sqlite3 in gamification-0.0.2 vs spec/dummy/db/test.sqlite3 in gamification-1.0.0
- old
+ new
@@ -1,10 +1,10 @@
-SQLite format 3 @
-%
- 7 i
A
-
-4 7
-=//indexunique_schema_migrationsschema_migrationsCREATE 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)Y1indexindex_gamification_tasks_on_taskable_id_and_taskable_typegamification_tasksCREATE INDEX "index_gamification_tasks_on_taskable_id_and_taskable_type" ON "gamification_tasks" ("taskable_id", "taskable_type")y11tablegamification_tasksgamification_tasksCREATE TABLE "gamification_tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "taskable_id" integer, "taskable_type" varchar(255), "points" integer, "created_at" datetime, "updated_at" datetime)$Y7Eindexindex_gamification_scorings_on_task_idgamification_scoringsCREATE INDEX "index_gamification_scorings_on_task_id" ON "gamification_scorings" ("task_id")Ga7indexindex_gamification_scorings_on_subjectablegamification_scoringsCREATE INDEX "index_gamification_scorings_on_subjectable" ON "gamification_scorings" ("subjectable_id", "subjectable_type") 771tablegamification_scoringsgamification_scoringsCREATE TABLE "gamification_scorings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "task_id" integer, "subjectable_id" integer, "subjectable_type" varchar(255), "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq){tablearticlesarticlesCREATE TABLE "articles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)
-
+SQLite format 3 @ -%
i
6,
+r fe
=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrations
CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)utableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)
+W5Aindexindex_gamification_rewards_on_seen_atgamification_rewardsCREATE INDEX "index_gamification_rewards_on_seen_at" ON "gamification_rewards" ("seen_at")C a5}indexindex_gamification_scorings_on_subjectablegamification_rewards
+CREATE INDEX "index_gamification_scorings_on_subjectable" ON "gamification_rewards" ("rewardable_id", "rewardable_type") W5Aindexindex_gamification_rewards_on_goal_idgamification_rewards CREATE INDEX "index_gamification_rewards_on_goal_id" ON "gamification_rewards" ("goal_id")55Stablegamification_rewardsgamification_rewardsCREATE TABLE "gamification_rewards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "goal_id" integer, "rewardable_id" integer, "rewardable_type" varchar(255), "created_at" datetime, "updated_at" datetime, "seen_at" datetime)U3=indexindex_gamification_medals_on_goal_idgamification_medalsCREATE INDEX "index_gamification_medals_on_goal_id" ON "gamification_medals" ("goal_id")335tablegamification_medalsgamification_medalsCREATE TABLE "gamification_medals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "goal_id" integer, "name" varchar(255), "image" varchar(255), "created_at" datetime, "updated_at" datetime, "description" text)`1indexindex_gamification_goals_on_rewarding_id_and_rewarding_typegamification_goalsCREATE INDEX "index_gamification_goals_on_rewarding_id_and_rewarding_type" ON "gamification_goals" ("rewarding_id", "rewarding_type"){11!tablegamification_goalsgamification_goalsCREATE TABLE "gamification_goals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "rewarding_id" integer, "rewarding_type" varchar(255), "points" integer, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq){tablearticlesarticlesCREATE TABLE "articles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime, "updated_at" datetime)
-
)20140309175957)20140309173049)20140309200402)20140309200453
- )20140309175957)20140309173049)20140309200402) 20140309200453
+
+
+
+
^ p^ )20140315142524)20140314132611)20140313134259)20140310081749)20140309175957)20140309173049)20140309200453)20140309200402)20140318220723
+ V |iV )20140315142524 )20140314132611)20140313134259)20140310081749)20140309175957)20140309173049)20140309200453)20140309200402) 20140318220723
\ No newline at end of file