SQLite format 3@  S+9indexindex_email_addresses_on_created_atemail_addressesCREATE INDEX "index_email_addresses_on_created_at" ON "email_addresses" ("created_at")._+_indexindex_email_addresses_on_activation_tokenemail_addressesCREATE UNIQUE INDEX "index_email_addresses_on_activation_token" ON "email_addresses" ("activation_token")W+Aindexindex_email_addresses_on_activated_atemail_addressesCREATE INDEX "index_email_addresses_on_activated_at" ON "email_addresses" ("activated_at")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)++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,   /email_credentialsk3open_id_credentials&?j usersU/     hS+9indexindex_email_addresses_on_create++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") jZ^//ktableemail_credentialsemail_credentials CREATE TABLE "email_credentials" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL0a+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.jpf13db801:f8a8d730f333b0f57f97268236a919d81ab11b371923068fc5373e69f63296132009-01-01 00:00:006 351332009-01-01 00:00:0011111111111111111111! yuyakato@gmail.com768812b6:78b1ea85c13c6887d9fd1731915c2965d8e93763aea69a952e48d427778d73e52009-01-01 00:00:002009-01-01 00:00:00V 3532009-01-01 00:00:0022222222222222222222! yuya@nayutaya.co.jpbfceda73:6c1f734893eec0afcd5ee0f56f0eb4a7fdb361cde0df1105a8457d0a2f65726f 32009-01-01 00:00:001O32009-01-01 00:00:00kV 5333333333333333333331O511111111111111111111k522222222222222222222V DD5@6 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   a2_3_indexindex_open_id_credentials_on_identity_urlopen_id_credentialsCREATE UNIQUE INDEX "index_open_id_credentials_on_identity_url" ON "o|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'%5t?indexindex_users_on_user_tokenusersVtablesessionssessionsCREATE 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+indexiVtablesessionssessionsCREATE 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")