SQLite format 3@   i O 35+32009-01-01 00:00:0033333333333333333333<`risa@example.jpf57023f9:00ccea75ccf06cce155579b2282d2682d16940e783380aaba64648195d106c472009-01-01 00:00:006 351332009-01-01 00:00:0011111111111111111111! yuyakato@gmail.comdf5f76d1:884a09aa823dfd3154703ab76ca7f217d0e5559c410eeff93f0f7c9ebf95af062009-01-01 00:00:002009-01-01 00:00:00V 3532009-01-01 00:00:0022222222222222222222! yuya@nayutaya.co.jpbb21706f:e8fb8b9d041c2c1fddb215d42b665461d93180fe2650171cee8c21aa1b7c954b /email_credentialsk usersU/3open_id_credentials&?j 32009-01-01 00:00:001O32009-01-01 00:00:00kV 5333333333333333333331O511111111111111111111k522222222222222222222V 32009-01-01 00:00:001O32009-01-01 00:00:00k32009-01-01 00:00:00V NN`^//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)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)#[/Iindexindex_email_credentials_on_activated_atemail_credentialsCREATE INDEX "index_email_credentials_on_activated_at" ON "email_credentials" ("activated_at")6c/gindexindex_email_credentials_on_activation_tokenemail_credentialsCREATE UNIQUE INDEX "index_email_credentials_on_activation_token" ON "email_credentials" ("activation_token")W/Aindexindex_email_credentials_on_created_atemail_credentialsCREATE INDEX "index_email_credentials_on_created_at" ON "email_credentials" ("created_at") +risa@example.jp1O1yuyakato@gmail.comk3yuya@nayutaya.co.jpV 6M/;indexindex_email_credentials_on_emailemail_credentialsCREATE UNIQUE INDEX "index_email_credentials_on_email" ON "email_credentials" ("email")Q/5indexindex_email_credentials_on_user_idemail_credentials CREATE INDEX "index_email_credentials_on_user_id" ON "email_credentials" ("user_id")1SSItableopen_id_authentication_associationsopen_id_authentication_associations CREATE 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)  <`1O ! k ! V   jH:3=32009-01-01 00:00:00! https://id.mixi.jp/858772009-01-01 00:00:005t3=2009-01-01 00:00:00U/http://example.jp/shinyaU3W32009-01-01 00:00:00! http://profile.livedoor.com/yuyakato/2009-01-01 00:00:00 LLP} 33)tableopen_id_credentialsopen_id_credentials CREATE 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)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") U3=indexindex_open_id_credentials_on_user_idopen_id_credentialsCREATE INDEX "index_open_id_credentials_on_user_id" ON "open_id_credentials" ("user_id")V tablesessionssessionsCREATE 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)E+indexindex_sessions_on_session_idsessionsCREATE UNIQUE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id") =https://id.mixi.jp/85877`=http://example.jp/shinyaޓ,Whttp://profile.livedoor.com/yuyakato/&?j  ! ` U/ޓ ! &?j    77vyEindexindex_sessions_on_updated_atsessionsCREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")XtableusersusersCREATE 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_tokenusersCREATE UNIQUE INDEX "index_users_on_user_token" ON "users" ("user_token")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") ((n@`3352009-01-01 00:00:002009-01-01 00:00:0033333333333333333333@3352009-01-01 00:00:002009-01-01 00:00:0022222222222222222222FA3352009-01-01 00:00:002009-01-01 00:00:0011111111111111111111yu-yan 533333333333333333333<`522222222222222222222U/511111111111111111111! )20090415160755)20090415155717)20090415151937)20090415155330)20090415163347 )20090415160755)20090415155717)20090415151937)20090415155330)20090415163347