SQLite format 3@     /email_credentialsk3open_id_credentials&?j usersU/     h++gtableemail_addressesemail_addressesCREATE TABLE "email_addresses" ("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, "activated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)W+Aindexindex_email_addresses_on_activated_atemail_addressesCREATE INDEX "index_email_addresses_on_activated_at" ON "email_addresses" ("activated_at")._+_indexindex_email_addresses_on_activation_tokenemail_addressesCREATE UNIQUE INDEX "index_email_addresses_on_activation_token" ON "email_addresses" ("activation_token")S+9indexindex_email_addresses_on_created_atemail_addressesCREATE INDEX "index_email_addresses_on_created_at" ON "email_addresses" ("created_at") jZ0a+aindexindex_email_addresses_on_email_and_user_idemail_addressesCREATE UNIQUE INDEX "index_email_addresses_on_email_and_user_id" ON "email_addresses" ("email", "user_id") M+-indexindex_email_addresses_on_user_idemail_addresses CREATE INDEX "index_email_addresses_on_user_id" ON "email_addresses" ("user_id")^//ktableemail_credentialsemail_credentials CREATE 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)# [/Iindexindex_email_credentials_on_activated_atemail_credentials CREATE INDEX "index_email_credentials_on_activated_at" ON "email_credentials" ("activated_at")  i O 35+32009-01-01 00:00:0033333333333333333333<`risa@example.jp2ba5380a:c10a07c9478310323051e926ac645c7747570ccb0a5676c851c3f58f01b279562009-01-01 00:00:006 351332009-01-01 00:00:0011111111111111111111! yuyakato@gmail.come37109f0:98e3d613f1d19f6ee707dfc3409f26ab22eaf9a312b1a1a3ffcb42ecc257c5b42009-01-01 00:00:002009-01-01 00:00:00V 3532009-01-01 00:00:0022222222222222222222! yuya@nayutaya.co.jpa4c2084d:f995af79f5fcc0728739b10de4d5badb17dc69d27869a0dd1387c20790766e52 32009-01-01 00:00:001O32009-01-01 00:00:00kV 5333333333333333333331O511111111111111111111k522222222222222222222V DD56 c/gindexindex_email_credentials_on_activation_tokenemail_credentials CREATE 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") M/;indexindex_email_credentials_on_emailemail_credentialsCREATE UNIQUE INDEX "index_email_credentials_on_email" ON "email_credentials" ("email") Q/5indexindex_email_credentials_on_user_idemail_credentialsCREATE INDEX "index_email_credentials_on_user_id" ON "email_credentials" ("user_id")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) 32009-01-01 00:00:001O32009-01-01 00:00:00k32009-01-01 00:00:00V +risa@example.jp1O1yuyakato@gmail.comk3yuya@nayutaya.co.jpV  <`1O ! k ! V   a|GGwtableopen_id_authentication_noncesopen_id_authentication_noncesCREATE 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)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)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") 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 =https://id.mixi.jp/85877`=http://example.jp/shinyaޓ,Whttp://profile.livedoor.com/yuyakato/&?j  ! ` U/ޓ ! &?j  NN'%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)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")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))   ((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! )20090415155717)20090415163347)20090415151937)20090415155330)20090415160755)20090420020617 )20090415155717)20090415163347)20090415151937)20090415155330)20090415160755)20090420020617 vt?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")