spec/dummy/db/development.sqlite3 in gamification-1.0.0 vs spec/dummy/db/development.sqlite3 in gamification-1.0.1
- old
+ new
@@ -1,11 +1,11 @@
-SQLite format 3 @ _ -%
L
N
79ii
Nsl
- #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)`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")
-^ 335tablegamificatis 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)C$a5}indexindex_gamification_scorings_on_subjectablegamification_rewardsCREATE 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)
+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) ka5 W5Aindexindex_gamification_rewards_on_task_idgamification_rewardsCREATE INDEX "index_gam &W5Aindexindex_gamification_rewards_on_seen_atgamification_rewards
CREATE INDEX "index_gamification_rewards_on_seen_at" ON "gamification_rewards" ("seen_at") %W5Aindexindex_gamification_rewards_on_goal_idgamification_rewards CREATE INDEX "index_gamification_rewards_on_goal_id" ON "gamification_rewards" ("goal_id")55+tablegamification_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)"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_tasks_on_rewarding_id_and_rewarding_typegamification_goals CREATE INDEX "index_gamification_tasks_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
-
-
-
-
+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
+
+
+
+
\ No newline at end of file