spec/test_app/db/test.sqlite3 in mtdevise-1.8.6 vs spec/test_app/db/test.sqlite3 in mtdevise-2.0.0b

- old
+ new

@@ -1,13 +1,12 @@ -SQLite format 3@ "-  :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>)   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") +SQLite format 3@ HH-  +Lp^L +)20151231043439 )20150719125100)20150504181830)20150428110406)20150427200506)20150426143800)20150426115910)20150426115631)20150426071228)20140428155742 + +C|iVC)20151231043439 +)20150719125100 )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) aa))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)   -  ? 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)   - - f!f/e)]indexindex_mtdevise_users_on_authentication_tokenmtdevise_usersCREATE INDEX "index_mtdevise_users_on_authentication_token" ON "mtdevise_users" ("authentication_token")hGindexindex_mtdevise_users_mtdevise_roles_on_user_id_and_role_idmtdevise_users_mtdevise_rolesCREATE INDEX "index_mtdevise_users_mtdevise_roles_on_user_id_and_role_id" ON "mtdevise_users_mtdevise_roles" ("user_id", "role_id") GG3tablemtdevise_users_mtdevise_rolesmtdevise_users_mtdevise_rolesCREATE TABLE "mtdevise_users_mtdevise_roles" ("user_id" integer, "role_id" integer) E)indexindex_mtdevise_roles_on_namemtdevise_rolesCREATE INDEX "index_mtdevise_roles_on_name" ON "mtdevise_roles" ("name")\)indexindex_mtdevise_roles_on_name_and_resource_type_and_resourcmtdevise_rolesCREATE INDEX "index_mtdevise_roles_on_name_and_resource_type_and_resourc" ON "mtdevise_roles" ("name", "resource_type", "resource_id") - +  _B/ e)]indexindex_mtdevise_users_on_authentication_tokenmtdevise_usersCREATE INDEX "index_mtdevise_users_on_authentication_token" ON "mtdevise_users" ("authentication_token")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) 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")  \ No newline at end of file