db/development.sqlite3 in okkez-multi_auth-0.0.3 vs db/development.sqlite3 in okkez-multi_auth-0.0.4

- old
+ new

@@ -1,14 +1,14 @@ -SQLite format 3@ - E+indexindex_sessions_on_session_idsessionsCREATE UNIQUE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id")yEindexindex_sessions_on_updated_atsessionsCREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)VtablesessionssessionsCREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "session_id" varchar(64) NOT NULL, "data" text)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("versio +SQLite format 3@  E+indexindex_sessions_on_session_idsessionsCREATE UNIQUE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id")yEindexindex_sessions_on_updated_atsessionsCREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)VtablesessionssessionsCREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "session_id" varchar(64) NOT NULL, "data" text)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("versio  )20090420020617)20090415163347)20090415160755)20090415155717)20090415155330)20090415151937 )20090420020617)20090415163347)20090415160755)20090415155717)20090415155330)20090415151937 ZZ#33M92009-11-05 17:23:272009-11-05 17:23:33a607b1bca4eab853d9f00c57ded5ebb5BAh7BjoQX2NzcmZfdG9rZW4iMXNOQ3BhWVlneFhXOXpiTEpUL1hwbkd5SFYz VU5Yb29Tc2tRdzBzN1NRQWc9 -  sessions + !Gopen_id_authentication_nonces'Sopen_id_authentication_associations sessions 32009-11-05 17:23:33 -$Ma607b1bca4eab853d9f00c57ded5ebb5  M}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")VtablesessionssessionsCREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "session_id" varchar(64) NOT NULL, "data" text)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)yEindexindex_sessions_on_updated_atsessionsCREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")E+indexindex_sessions_on_session_idsessionsCREATE UNIQUE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id") ||xX 1SSItableopen_id_authentication_associationsopen_id_authentication_associationsCREATE TABLE "open_id_authentication_associations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "issued" integer, "lifetime" integer, "handle" varchar(255), "assoc_type" varchar(255), "server_url" blob, "secret" blob)|GGwtableopen_id_authentication_noncesopen_id_authentication_nonces CREATE TABLE "open_id_authentication_nonces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" integer NOT NULL, "server_url" varchar(255), "salt" varchar(255) NOT NULL)X tableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "user_token" varchar(40) NOT NULL, "nickname" varchar(40))t -?indexindex_users_on_user_tokenusers CREATE UNIQUE INDEX "index_users_on_user_token" ON "users" ("user_token")   +$Ma607b1bca4eab853d9f00c57ded5ebb5 }a[5K(t#1260942369:TdZgj2zDcYGhoajUfZaJ:c81f85ad29HMAC-SHA1https://auth.livedoor.com/openid/serverx]yy1i< + M}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")VtablesessionssessionsCREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "session_id" varchar(64) NOT NULL, "data" text)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)yEindexindex_sessions_on_updated_atsessionsCREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")E+indexindex_sessions_on_session_idsessionsCREATE UNIQUE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id") ||xX 1SSItableopen_id_authentication_associationsopen_id_authentication_associationsCREATE TABLE "open_id_authentication_associations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "issued" integer, "lifetime" integer, "handle" varchar(255), "assoc_type" varchar(255), "server_url" blob, "secret" blob)|GGwtableopen_id_authentication_noncesopen_id_authentication_nonces CREATE TABLE "open_id_authentication_nonces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" integer NOT NULL, "server_url" varchar(255), "salt" varchar(255) NOT NULL)X tableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "user_token" varchar(40) NOT NULL, "nickname" varchar(40))t +?indexindex_users_on_user_tokenusers CREATE UNIQUE INDEX "index_users_on_user_token" ON "users" ("user_token") 6[K(t$https://auth.livedoor.com/openid/serveroZwi34    GGK. 33)tableopen_id_credentialsopen_id_credentialsCREATE TABLE "open_id_credentials" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "user_id" integer NOT NULL, "identity_url" varchar(200) NOT NULL, "loggedin_at" datetime) U3=indexindex_open_id_credentials_on_user_idopen_id_credentialsCREATE INDEX "index_open_id_credentials_on_user_id" ON "open_id_credentials" ("user_id")2 _3_indexindex_open_id_credentials_on_identity_urlopen_id_credentialsCREATE UNIQUE INDEX "index_open_id_credentials_on_identity_url" ON "open_id_credentials" ("identity_url")^//ktableemail_credentialsemail_credentialsCREATE TABLE "email_credentials" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "activation_token" varchar(40) NOT NULL, "user_id" integer NOT NULL, "email" varchar(200) NOT NULL, "hashed_password" varchar(73) NOT NULL, "activated_at" datetime, "loggedin_at" datetime)     r+ZM/;indexindex_email_credentials_on_emailemail_credentialsCREATE UNIQUE INDEX "index_email_credentials_on_email" ON "email_credentials" ("email")Q/5indexindex_email_credW/Aindexindex_email_credentials_on_created_atemail_credentialsCREATE INDEX "index_email_credentials_on_created_at" ON "email_credentials" ("created_at")6c/gindexindex_email_credentials_on_activation_tokenemail_credentialsCREATE UNIQUE INDEX "index_email_credentials_on_activation_token" ON "email_credentials" ("activation_token")Q/5indexindex_email_credentials_on_user_idemail_credentialsCREATE INDEX "index_email_credentials_on_user_id" ON "email_credentials" ("user_id")M/;indexindex_email_credentials_on_emailemail_credentialsCREATE UNIQUE INDEX "index_email_credentials_on_email" ON "email_credentials" ("email")#[/Iindexindex_email_credentials_on_activated_atemail_credentialsCREATE INDEX "index_email_credentials_on_activated_at" ON "email_credentials" ("activated_at")  \ No newline at end of file