spec/dummy/db/test.sqlite3 in gamification-1.0.0 vs spec/dummy/db/test.sqlite3 in gamification-1.0.1
- old
+ new
@@ -1,10 +1,11 @@
-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)
-
-
+SQLite format 3 @ 1 -
+^
79 s
+i
W5Aindexindex_gamification_rewards_on_seen_atgamification_rewards
CREATE INDEX "index_gamification_rewards_on_seen_at" ON "gamification_rewards" ("seen_at")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)Ca5}indexindex_gamification_scorings_on_subjectablegamification_rewards CREATE INDEX "index_gamification_scorings_on_subjectable" ON "gamification_rewards" ("rewardable_id", "rewardable_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)
+{tablearticlesarticlesCREATE 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) l ka5 W5Aindexindex_gamification_rewards_on_task_idgamification_rewardsCREATE INDEX "indexl W5Aindexindex_gamification_rewards_on_goal_idgamification_rewardsCREATE INDEX "index_gamification_rewards_on_goal_id" ON "gamification_rewards" ("goal_id") U3=indexindex_gamification_medals_on_task_idgamification_medals
CREATE INDEX "index_gamification_medals_on_task_id" ON "gamification55Stablegamification_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")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) 1 33
tablegami`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")=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
^ p^ )20140318220723)20140315142524)20140314132611)20140313134259)20140310081749)20140309200453)20140309200402)20140309175957)20140309173049
+ V |iV )20140318220723 )20140315142524)20140314132611)20140313134259)20140310081749)20140309200453)20140309200402)20140309175957) 20140309173049
+
+
+
-
-
^ 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