SQLite format 3@   )20090415163347)20090415160755)20090415155717)20090415155330)20090415151937 )20090415163347)20090415160755)20090415155717)20090415155330)20090415151937      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") ||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")     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+ZW/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")