test/dummy/db/test.sqlite3 in contour-2.1.0.beta4 vs test/dummy/db/test.sqlite3 in contour-2.1.0.beta5
- 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-07-25 15:18:142013-07-25 15:18:14(6 3)!!!33DeletedUseractivetdeleted@example.comMyStringResetTokenFiveMyDate2011-02-23 2011-02-232011-02-23MyStringMyString2013-07-25 15:18:142013-07-25 15:18:14 '33MyStringMyStringinactivefEmailTwoMyStringResetTokenTwoMyDateMyDate MyDateMyDateMyStringMyString2013-07-25 15:18:142013-07-25 15:18:14T /'33FirstNameLastNameactivefvalid@example.com$2a$10$ZgXIxDCn.TjuCgsnS9iEp.Z1LlmQ71FGKgZe/kdCaVvgvnAAcUaz2ResetTokenOneMyDateMyDate MyDateMyDateMyStringMyString2013-07-25 15:18:142013-07-25 15:18:14
users;z+authentications8
+ )20111203203307)20111203203123
$ &
$
.< 3)!!!33MyStringMyStringpendingfpending@example.comMyStringResetTokenFourMyDate2011-02-23 2011-02-232011-02-23MyStringMyString2013-08-05 18:42:592013-08-05 18:42:59(6 3)!!!33DeletedUseractivetdeleted@example.comMyStringResetTokenFiveMyDate2011-02-23 2011-02-232011-02-23MyStringMyString2013-08-05 18:42:592013-08-05 18:42:59 '33MyStringMyStringinactivefEmailTwoMyStringResetTokenTwoMyDateMyDate MyDateMyDateMyStringMyString2013-08-05 18:42:592013-08-05 18:42:59T /'33FirstNameLastNameactivefvalid@example.com$2a$10$ZgXIxDCn.TjuCgsnS9iEp.Z1LlmQ71FGKgZe/kdCaVvgvnAAcUaz2ResetTokenOneMyDateMyDate MyDateMyDateMyStringMyString2013-08-05 18:42:592013-08-05 18:42:59
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-07-25 15:18:142013-07-25 15:18:14J\ #)336google_appstest@gmail.com2013-07-25 15:18:142013-07-25 15:18:14K 3336open_idopen_id@open_id.com2013-07-25 15:18:142013-07-25 15:18:14
+ )ResetTokenFourz)ResetTokenFive+;N6'ResetTokenTwo;z'ResetTokenOne6
_ Y U336ldapCN=ldapid,CN=Users,DC=example,DC=com2013-08-05 18:42:592013-08-05 18:42:59J\ #)336google_appstest@gmail.com2013-08-05 18:42:592013-08-05 18:42:59K 3336open_idopen_id@open_id.com2013-08-05 18:42:592013-08-05 18:42:59
\ No newline at end of file