db/test.sqlite3 in daily-0.0.3 vs db/test.sqlite3 in daily-0.0.4
- old
+ new
@@ -1,12 +1,13 @@
-SQLite format 3 @ ?
- ? -
Q >
8
-SJNQ =//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) SGindexindex_users_on_reset_password_tokenusers
-CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5indexindex_users_on_emailusers CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")ktableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(128) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime, "admin" boolean)Y
tabletablestablesCREATE TABLE "tables" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "data" text, "data_type" varchar(255), "created_at" datetime, "updated_at" datetime, "name" varchar(255), "guid" varchar(255), "fetch_time_in_seconds" integer, "column_names" text, "transform" varchar(255), "transform_data" text)ctablereportsreportsCREATE TABLE "reports" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "filename" varchar(255), "table_id" integer, "user_id" integer, "formatter" varchar(255), "created_at" datetime, "updated_at" datetime, "generate_started_at" datetime, "generate_ended_at" datetime, "transform" varchar(255), "transform_data" text, "formatter_data" text)K%)indexindex_delayed_jobs_on_report_iddelayed_jobsCREATE INDEX "index_delayed_jobs_on_report_id" ON "delayed_jobs" ("report_id"){7%'indexdelayed_jobs_prioritydelayed_jobsCREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)m%%tabledelayed_jobsdelayed_jobsCREATE TABLE "delayed_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "priority" integer DEFAULT 0, "attempts" integer DEFAULT 0, "handler" text, "last_error" text, "run_at" datetime, "locked_at" datetime, "failed_at" datetime, "locked_by" varchar(255), "created_at" datetime, "updated_at" datetime, "report_id" integer)
+SQLite format 3 @ z
+ z -
e
+
+ ros =//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) K%)indexindex_delayed_jobs_on_report_iddelayed_jobs
+CREATE INDEX "index_delayed_jobs_on_report_id" ON "delayed_jobs" ("report_id"){7%'indexdelayed_jobs_prioritydelayed_jobs CREATE INDEX "delayed_jobs_priority" ON "delayed_jobs" ("priority", "run_at")%%Itabledelayed_jobsdelayed_jobsCREATE TABLE "delayed_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "priority" integer DEFAULT 0, "attempts" integer DEFAULT 0, "handler" text, "last_error" text, "run_at" datetime, "locked_at" datetime, "failed_at" datetime, "locked_by" varchar(255), "created_at" datetime, "updated_at" datetime, "report_id" integer, "queue" varchar(255))S#Sindexindex_users_on_reset_password_tokendaily_usersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "daily_users" ("reset_password_token")q5#indexindex_users_on_emaildaily_usersCREATE UNIQUE INDEX "index_users_on_email" ON "daily_users" ("email")##wtabledaily_usersdaily_usersCREATE TABLE "daily_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(128) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime, "admin" boolean)o%%!tabledaily_tablesdaily_tablesCREATE TABLE "daily_tables" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "metric_data" text, "metric" varchar(255), "created_at" datetime, "updated_at" datetime, "name" varchar(255), "guid" varchar(255), "fetch_time_in_seconds" integer, "column_names" text, "transform" varchar(255), "transform_data" text)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)''otabledaily_reportsdaily_reportsCREATE TABLE "daily_reports" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "filename" varchar(255), "table_id" integer, "user_id" integer, "formatter" varchar(255), "created_at" datetime, "updated_at" datetime, "generate_started_at" datetime, "generate_ended_at" datetime, "transform" varchar(255), "transform_data" text, "formatter_data" text)
-
+
-
p^L:(
)20111203020425)20111127065357)20111115014959
-)20111114053016 )20111114041729)20111113075747)20111113073326)20111113000026)20111112170802)20111112022333)20111111165640)20111109081414)20111214020029
-
{hUB/ )20111203020425
)20111127065357)20111115014959)20111114053016
-)20111114041729 )20111113075747)20111113073326)20111113000026)20111112170802)20111112022333)20111111165640)20111109081414)20111214020029
+
p^L:( )20120111054115)20120110075743)20111214020029
)20111203020425)20111127065357)20111115014959
+)20111114053016 )20111114041729)20111113075747)20111113073326)20111113000026)20111112170802)20111112022333)20111111165640)20111109081414)20120111081745
+ {hUB/ )20120111054115)20120110075743)20111214020029)20111203020425
)20111127065357)20111115014959)20111114053016
+)20111114041729 )20111113075747)20111113073326)20111113000026)20111112170802)20111112022333)20111111165640)20111109081414)20120111081745
\ No newline at end of file