test/dummy/db/test.sqlite3 in contour-1.1.3.pre2 vs test/dummy/db/test.sqlite3 in contour-1.1.3
- old
+ new
@@ -1,6 +1,6 @@
-SQLite format 3 @ ~ ~ -$
+SQLite format 3 @ -$
j
{++-tableauthenticationsauthenticationsCREATE TABLE "authentications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "provider" varchar(255), "uid" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)tableusersusersCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)=//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)
)20111203203307)20111203203123
- )20111203203307)20111203203123
$ &
$
.< 3)!!!33MyStringMyStringpendingfpending@example.comMyStringResetTokenFourMyDate2011-02-23 2011-02-232011-02-23MyStringMyString2013-02-05 18:15:452013-02-05 18:15:45(6 3)!!!33DeletedUseractivetdeleted@example.comMyStringResetTokenFiveMyDate2011-02-23 2011-02-232011-02-23MyStringMyString2013-02-05 18:15:452013-02-05 18:15:45 '33MyStringMyStringinactivefEmailTwoMyStringResetTokenTwoMyDateMyDate MyDateMyDateMyStringMyString2013-02-05 18:15:452013-02-05 18:15:45T /'33FirstNameLastNameactivefvalid@example.com$2a$10$ZgXIxDCn.TjuCgsnS9iEp.Z1LlmQ71FGKgZe/kdCaVvgvnAAcUaz2ResetTokenOneMyDateMyDate MyDateMyDateMyStringMyString2013-02-05 18:15:452013-02-05 18:15:45
users;z+authentications8
+ )20111203203307)20111203203123
$ &
$
.< 3)!!!33MyStringMyStringpendingfpending@example.comMyStringResetTokenFourMyDate2011-02-23 2011-02-232011-02-23MyStringMyString2013-02-11 13:44:302013-02-11 13:44:30(6 3)!!!33DeletedUseractivetdeleted@example.comMyStringResetTokenFiveMyDate2011-02-23 2011-02-232011-02-23MyStringMyString2013-02-11 13:44:302013-02-11 13:44:30 '33MyStringMyStringinactivefEmailTwoMyStringResetTokenTwoMyDateMyDate MyDateMyDateMyStringMyString2013-02-11 13:44:302013-02-11 13:44:30T /'33FirstNameLastNameactivefvalid@example.com$2a$10$ZgXIxDCn.TjuCgsnS9iEp.Z1LlmQ71FGKgZe/kdCaVvgvnAAcUaz2ResetTokenOneMyDateMyDate MyDateMyDateMyStringMyString2013-02-11 13:44:302013-02-11 13:44:30
users;z+authentications8
3pending@example.comz3deleted@example.com+;N6EmailTwo;z/valid@example.com6
- )ResetTokenFourz)ResetTokenFive+;N6'ResetTokenTwo;z'ResetTokenOne6
_ Y U336ldapCN=ldapid,CN=Users,DC=example,DC=com2013-02-05 18:15:452013-02-05 18:15:45J\ #)336google_appstest@gmail.com2013-02-05 18:15:452013-02-05 18:15:45K 3336open_idopen_id@open_id.com2013-02-05 18:15:452013-02-05 18:15:45
+ )ResetTokenFourz)ResetTokenFive+;N6'ResetTokenTwo;z'ResetTokenOne6
_ Y U336ldapCN=ldapid,CN=Users,DC=example,DC=com2013-02-11 13:44:302013-02-11 13:44:30J\ #)336google_appstest@gmail.com2013-02-11 13:44:302013-02-11 13:44:30K 3336open_idopen_id@open_id.com2013-02-11 13:44:302013-02-11 13:44:30
\ No newline at end of file