spec/test_app/db/test.sqlite3 in mtdevise-1.7.1 vs spec/test_app/db/test.sqlite3 in mtdevise-1.7.5
- old
+ new
@@ -1,8 +1,8 @@
-SQLite format 3 @ " -
: p^L: )20151231043439
+SQLite format 3 @ y " y -
: p^L: )20151231043439
)20150719125100 )20150604101617)20150504181830)20150428110406)20150427200506)20150426143800)20150426115910)20150426115631)20150426071228)20140428155742
0 |iVC0 )20151231043439 )20150719125100
-)20150604101617 )20150504181830)20150428110406)20150427200506)20150426143800)20150426115910)20150426115631)20150426071228) 20140428155742
% > )
Q %//ytablemtdevise_accountsmtdevise_accountsCREATE TABLE "mtdevise_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime, "updated_at" datetime, "owner_id" integer, "subdomain" varchar, "firstname" varchar, "lastname" varchar, "username" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)4CtablethingsthingsCREATE TABLE "things" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "account_id" integer, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)
G ))stablemtdevise_usersmtdevise_usersCREATE TABLE "mtdevise_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar, "password_digest" varchar, "created_at" datetime, "updated_at" datetime, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "confirmed_at" datetime, "confirmation_token" varchar, "confirmation_sent_at" datetime, "unconfirmed_email" varchar, "authentication_token" varchar) G)/indexindex_mtdevise_users_on_emailmtdevise_users
+)20150604101617 )20150504181830)20150428110406)20150427200506)20150426143800)20150426115910)20150426115631)20150426071228) 20140428155742
S <
Q %//ytablemtdevise_accountsmtdevise_accountsCREATE TABLE "mtdevise_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime, "updated_at" datetime, "owner_id" integer, "subdomain" varchar, "firstname" varchar, "lastname" varchar, "username" varchar)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)4CtablethingsthingsCREATE TABLE "things" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "account_id" integer, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)
G ))stablemtdevise_usersmtdevise_usersCREATE TABLE "mtdevise_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar, "password_digest" varchar, "created_at" datetime, "updated_at" datetime, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "confirmed_at" datetime, "confirmation_token" varchar, "confirmation_sent_at" datetime, "unconfirmed_email" varchar, "authentication_token" varchar) G)/indexindex_mtdevise_users_on_emailmtdevise_users
CREATE UNIQUE INDEX "index_mtdevise_users_on_email" ON "mtdevise_users" ("email")6e)kindexindex_mtdevise_users_on_reset_password_tokenmtdevise_users CREATE UNIQUE INDEX "index_mtdevise_users_on_reset_password_token" ON "mtdevise_users" ("reset_password_token")
? U/=indexindex_mtdevise_accounts_on_subdomainmtdevise_accounts CREATE INDEX "index_mtdevise_accounts_on_subdomain" ON "mtdevise_accounts" ("subdomain")U
--]tablemtdevise_membersmtdevise_members
CREATE TABLE "mtdevise_members" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "user_id" integer, "created_at" datetime, "updated_at" datetime)f ))tablemtdevise_rolesmtdevise_rolesCREATE TABLE "mtdevise_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "resource_id" integer, "resource_type" varchar, "created_at" datetime, "updated_at" datetime)
\ No newline at end of file