spec/dummy/db/development.sqlite3 in gamification-0.0.2 vs spec/dummy/db/development.sqlite3 in gamification-1.0.0
- old
+ new
@@ -1,9 +1,11 @@
-SQLite format 3 @ -%
- 7
&
-\ 7
+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)
{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)Ga7indexindex_gamification_scorings_on_subjectablegamification_scorings CREATE INDEX "index_gamification_scorings_on_subjectable" ON "gamification_scorings" ("subjectable_id", "subjectable_type")$Y7Eindexindex_gamification_scorings_on_task_idgamification_scoringsCREATE INDEX "index_gamification_scorings_on_task_id" ON "gamification_scorings" ("task_id") 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)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")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)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)=//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)
)20140309200453)20140309200402)20140309175957)20140309173049
- )20140309200453)20140309200402)20140309175957) 20140309173049
+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
-
-
+
+
+
+
\ No newline at end of file