test/dummy/db/test.sqlite3 in contour-2.6.0.beta2 vs test/dummy/db/test.sqlite3 in contour-2.6.0.beta3
- old
+ new
@@ -1,6 +1,6 @@
-SQLite format 3 @ U
- U -%
)20111203203307)20111203203123
- )20111203203307) 20111203203123
( '( -< 3)!!!33MyStringMyStringpendingfpending@example.comMyStringResetTokenFourMyDate2011-02-232011-02-232011-02-23MyStringMyString2014-08-19 20:06:562014-08-19 20:06:56'6 3)!!!33DeletedUseractivetdeleted@example.comMyStringResetTokenFiveMyDate2011-02-232011-02-232011-02-23MyStringMyString2014-08-19 20:06:562014-08-19 20:06:56 '33MyStringMyStringinactivefEmailTwoMyStringResetTokenTwoMyDateMyDateMyDateMyDateMyStringMyString2014-08-19 20:06:562014-08-19 20:06:56S /'33FirstNameLastNameactivefvalid@example.com$2a$10$ZgXIxDCn.TjuCgsnS9iEp.Z1LlmQ71FGKgZe/kdCaVvgvnAAcUaz2ResetTokenOneMyDateMyDateMyDateMyDateMyStringMyString2014-08-19 20:06:562014-08-19 20:06:56
users;z+authentications8
| | y q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")gtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "status" varchar(255) DEFAULT 'pending' NOT NULL, "deleted" boolean DEFAULT 'f' NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) 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)
+SQLite format 3 @ [
+ [ -%
)20111203203307)20111203203123
+ )20111203203307) 20111203203123
( '( -< 3)!!!33MyStringMyStringpendingfpending@example.comMyStringResetTokenFourMyDate2011-02-232011-02-232011-02-23MyStringMyString2014-08-20 18:24:452014-08-20 18:24:45'6 3)!!!33DeletedUseractivetdeleted@example.comMyStringResetTokenFiveMyDate2011-02-232011-02-232011-02-23MyStringMyString2014-08-20 18:24:452014-08-20 18:24:45 '33MyStringMyStringinactivefEmailTwoMyStringResetTokenTwoMyDateMyDateMyDateMyDateMyStringMyString2014-08-20 18:24:452014-08-20 18:24:45S /'33FirstNameLastNameactivefvalid@example.com$2a$10$ZgXIxDCn.TjuCgsnS9iEp.Z1LlmQ71FGKgZe/kdCaVvgvnAAcUaz2ResetTokenOneMyDateMyDateMyDateMyDateMyStringMyString2014-08-20 18:24:452014-08-20 18:24:45
users;z+authentications8
| | y q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")gtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "status" varchar(255) DEFAULT 'pending' NOT NULL, "deleted" boolean DEFAULT 'f' NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) 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)
3pending@example.comz3deleted@example.com+;N6EmailTwo;z/valid@example.com6
G i++ tableauthenticationsauthentications
CREATE TABLE "authentications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "provider" varchar(255), "uid" varchar(255), "created_at" datetime, "updated_at" datetime)SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)e5indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")
- )ResetTokenFourz)ResetTokenFive+;N6'ResetTokenTwo;z'ResetTokenOne6
_ Y U336ldapCN=ldapid,CN=Users,DC=example,DC=com2014-08-19 20:06:562014-08-19 20:06:56J\ #)336google_appstest@gmail.com2014-08-19 20:06:562014-08-19 20:06:56K 3336open_idopen_id@open_id.com2014-08-19 20:06:562014-08-19 20:06:56
+ )ResetTokenFourz)ResetTokenFive+;N6'ResetTokenTwo;z'ResetTokenOne6
_ Y U336ldapCN=ldapid,CN=Users,DC=example,DC=com2014-08-20 18:24:452014-08-20 18:24:45J\ #)336google_appstest@gmail.com2014-08-20 18:24:452014-08-20 18:24:45K 3336open_idopen_id@open_id.com2014-08-20 18:24:452014-08-20 18:24:45
\ No newline at end of file