SQLite format 3@ ,7S,-) 2P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)~[tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_-&)$%!  p^L:(tbP>,)20131106182814)20131106182813)20131106182812)20131106182811)20131106182810)20131106182807)20131106182806)20131106182805)20131106182804)20131106182803)20131106182802)20131106182755)20131106182754)20131106182753 )20131106182752 )20131106182751 )20131106182750 )20131106182749 )20131106182748)20131106182747)20131106182746)20131106182745)20131106182744)20131106182743)20131106182742)20131106182741)20131106182736 |iVC0 r_L9&)20131106182814)20131106182813)20131106182812)20131106182811)20131106182810)20131106182807)20131106182806)20131106182805)20131106182804)20131106182803)20131106182802)20131106182755)20131106182754)20131106182753)20131106182752 )20131106182751 )20131106182750 )20131106182749 )20131106182748 )20131106182747)20131106182746)20131106182745)20131106182744)20131106182743)20131106182742)20131106182741) 20131106182736 &A AAAA +jeremy.n.friesen@gmail.com$2a$10$vGacob7QWRZjiOZhZ0VNj./W82Ig/F/hnH2c/5I4P6fErwCOWGI.a2013-11-07 14:02:40.7977942013-11-07 14:02:40.797794127.0.0.1127.0.0.12013-11-07 14:02:39.0396162013-11-07 14:02:48.828376fttsufia:3t94h025p  searches  users A jeremy.n.friesen@gmail.com v-tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime, "guest" boolean DEFAULT 'f', "facebook_handle" varchar(255), "twitter_handle" varchar(255), "googleplus_handle" varchar(255), "display_name" varchar(255), "address" varchar(255), "admin_area" varchar(255), "department" varchar(255))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")  g tableusetableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "enc+5tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAU0P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)e5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")Vtablesearchessearches CREATE TABLE "searches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "query_params" text, "user_id" integer, "created_at" datetime, "updated_at" datetime, "user_type" varchar(255))p?indexindex_searches_on_user_idsearches CREATE INDEX "index_searches_on_user_id" ON "searches" ("user_id")7faAA--- !ruby/hash:ActionController::Parameters f: !ruby/hash:ActiveSupport::HashWithIndifferentAccess generic_type_sim: - Work q: asdf action: index controller: catalog 2013-11-07 14:03:39.7058872013-11-07 14:03:39.705887c[AA--- !ruby/hash:ActionController::Parameters f: !ruby/hash:ActiveSupport::HashWithIndifferentAccess generic_type_sim: - Work q: a action: index controller: catalog 2013-11-07 14:03:34.9376462013-11-07 14:03:34.937646c[AA--- !ruby/hash:ActionController::Parameters f: !ruby/hash:ActiveSupport::HashWithIndifferentAccess generic_type_sim: - Work q: p action: index controller: catalog 2013-11-07 14:03:33.9572212013-11-07 14:03:33.957221"YAA--- !ruby/hash:ActionController::Parameters q: Jeremy Friesen action: index controller: curate/people 2013-11-07 14:03:19.4107212013-11-07 14:0365     &P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)e5 indexindex_users_on_em Mtablebookmarksbookmarks CREATE TABLE "bookmarks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "document_id" varchar(255), "title" varchar(255), "created_at" datetime, "updated_at" datetime, "user_type" varchar(255))K mtablefollowsfollows CREATE TABLE "follows" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "followable_id" integer NOT NULL, "followable_type" varchar(255) NOT NULL, "follower_id" integer NOT NULL, "follower_type" varchar(255) NOT NULL, "blocked" boolean DEFAULT 'f' NOT NULL, "created_at" datetime, "updated_at" datetime)e !indexfk_followsfollowsCREATE INDEX "fk_follows" ON "follows" ("follower_id", "follower_type")q )+indexfk_followablesfollowsCREATE INDEX "fk_followables" ON "follows" ("followable_id", "followable_type")    c --Ctablesingle_use_linkssingle_use_linksCREATE TABLE "single_use_links" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "downloadKey" varchar(255), "path" varchar(255), "itemId" varchar(255), "expires" datetime, "created_at" datetime, "updated_at" datetime)D33/tablechecksum_audit_logschecksum_audit_logsCREATE TABLE "checksum_audit_logs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "pid" varchar(255), "dsid" varchar(255), "version" varchar(255), "pass" integer, "expected_result" varchar(255), "actual_result" varchar(255), "created_at" datetime, "updated_at" datetime)v+3indexby_pid_and_dsidchecksum_audit_logsCREATE INDEX "by_pid_and_dsid" ON "checksum_audit_logs" ("pid", "dsid")"11otableversion_committersversion_committersCREATE TABLE "version_committers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "obj_id" varchar(255), "datastream_id" varchar(255), "version_id" varchar(255), "committer_login" varchar(255), "created_at" datetime, "updated_at" datetime) word" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime, "guest" boolean DEFAULT 'f', "facebook_handle" varchar(255), "twitter_handle" varchar(255), "googleplus_handle" varchar(255), "display_name" varchar(255), "address" varchar(255), "admin_area" varchar(255), "department" varchar(255), "title" varchar(255), "office" varchar(255), "chat_id" varchar(255), "website" varchar(255), "affiliation" varchar(255), "telephone" varchar(255), "avatar_file_name" varchar(255), "avatar_content_type" varchar(255), "avatar_file_size" integer, "avatar_updated_at" datetime, "group_list" text, "groups_last_update" datetime, "agreed_to_terms_of_service" boolean, "user_does_not_require_profile_update" b+ sufia:3t94h025p    ar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime, "guest" boolean DEFAULT 'f', "facebook_handle" varchar(255), "twitter_handle" varchar(255), "googleplus_handle" varchar(255), "display_name" varchar(255), "address" varchar(255), "admin_area" varchar(255), "department" varchar(255), "title" varchar(255), "office" varchar(255), "chat_id" varchar(255), "website" varchar(255), "affiliation" varchar(255), "telephone" varchar(255), "avatar_file_name" varchar(255), "avatar_content_type" varchar(255), "avatar_file_size" integer, "avatar_updated_at" datetime, "group_list" text) DD"[ [;;Mtablelocal_authority_entrieslocal_authority_entriesCREATE TABLE "local_authority_entries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "local_authority_id" integer, "label" varchar(255), "uri" varchar(255))//[tablelocal_authoritieslocal_authoritiesCREATE TABLE "local_authorities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))%%}tabledomain_termsdomain_termsCREATE TABLE "domain_terms" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "model" varchar(255), "term" varchar(255))/IIYtabledomain_terms_local_authoritiesdomain_terms_local_authoritiesCREATE TABLE "domain_terms_local_authorities" ("domain_term_id" integer, "local_authority_id" integer)pKKWtablesubject_local_authority_entriessubject_local_authority_entriesCREATE TABLE "subject_local_authority_entries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar(255), "lowerLabel" varchar(255), "url" varchar(255))      ^^bZ"?;Windexentries_by_term_and_labellocal_authority_entriesCREATE INDEX "entries_by_term_and_label" ON "local_authority_entries" ("local_authority_id", "label");;Oindexentries_by_term_and_urilocal_authority_entriesCREATE INDEX "entries_by_term_and_uri" ON "local_authority_entries" ("local_authority_id", "uri")z;%!indexterms_by_model_and_termdomain_terms CREATE INDEX "terms_by_model_and_term" ON "domain_terms" ("model", "term")%I]indexdtla_by_ids1domain_terms_local_authorities!CREATE INDEX "dtla_by_ids1" ON "domain_terms_local_authorities" ("local_authority_id", "domain_term_id")%I]indexdtla_by_ids2domain_terms_local_authorities"CREATE INDEX "dtla_by_ids2" ON "domain_terms_local_authorities" ("domain_term_id", "local_authority_id")9K?indexentries_by_lower_labelsubject_local_authority_entries#CREATE INDEX "entries_by_lower_label" ON "subject_local_authority_entries" ("lowerLabel")       CC Gatabletrophiestrophies$CREATE TABLE "trophies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "generic_file_id" varchar(255), "created_at" datetime, "updated_at" datetime)X''otableconversationsconversations&CREATE TABLE "conversations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "subject" varchar(255) DEFAULT '', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)!''itablenotificationsnotifications(CREATE TABLE "notifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "body" text, "subject" varchar(255) DEFAULT '', "sender_id" integer, "sender_type" varchar(255), "conversation_id" integer, "draft" boolean DEFAULT 'f', "updated_at" datetime NOT NULL, "created_at" datetime NOT NULL, "notified_object_id" integer, "notified_object_type" varchar(255), "notification_code" varchar(255), "attachment" varchar(255), "global" boolean DEFAULT 'f', "expires" datetime)    [[uWc!''tablenotificationsnotifications(CREATE TABLE "notifications" ("id" INTEGER PRIMARY KEY AUTOIN"Y'Eindexindex_notifications_on_conversation_idnotifications+CREATE INDEX "index_notifications_on_conversation_id" ON "notifications" ("conversation_id")x#Ctablereceiptsreceipts'CREATE TABLE "receipts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "receiver_id" integer, "receiver_type" varchar(255), "notification_id" integer NOT NULL, "is_read" boolean DEFAULT 'f', "trashed" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "mailbox_type" varchar(25), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)$O1indexindex_receipts_on_notification_idreceipts*CREATE INDEX "index_receipts_on_notification_id" ON "receipts" ("notification_id") ' )("Y'Eindexindex_notifications_on_conversation_idnotifications)CREATE INDEX "index_notifications_on_conversation_id" ON "notifications" ("conversation_id") O1indexindex_receipts_on_notification_idreceipts*CREATE INDEX "index_receipts_on_notification_id" ON "receipts" ("notification_id")''Ctablenotificationsnotifications(CREATE TABLE "notifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "body" text,  O1indexindex_receipts_on_notification_idreceipts*CREATE INDEX "index_receipts_on_notification_id" ON "receipts" ("notification_id")Y'Eindexindex_notifications_on_conversation_idnotifications)CREATE INDEX "index_notifications_on_conversation_id" ON "notifications" ("conversation_id") ar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime, "guest" boolean DEFAULT 'f', "facebook_handle" varchar(255), "twitter_handle" varchar(255), "googleplus_handle" varchar(255), "display_name" varchar(255), "address" varchar(255), "admin_area" varchar(255), "department" varchar(255), "title" varchar(255), "office" varchar(255), "chat_id" varchar(255), "website" varchar(255), "affiliation" varchar(255), "telephone" varchar(255), "avatar_file_name" varchar(255), "avatar_content_type" varchar(255), "avatar_file_size" integer, "avatar_updated_at" datetime, "group_list" text, "groups_last_update" datetime, "agreed_to_terms_of_service" boolean) ywhd}(E+indexindex_users_on_repository_idusersCREATE UNIQUE INDEX "index_users_on_repository_id" ON "users" ("repository_id") 'O'1indexindex_help_requests_on_created_athelp_requests/CREATE INDEX "index_help_requests_on_created_at" ON "help_requests" ("created_at")&I'%indexindex_help_requests_on_user_idhelp_requests.CREATE INDEX "index_help_requests_on_user_id" ON "help_requests" ("user_id")$t%'''tablehelp_requestshelp_requests,CREATE TABLE "help_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "view_port" varchar(255), "current_url" text, "user_agent" varchar(255), "resolution" varchar(255), "how_can_we_help_you" text, "user_id" integer, "javascript_enabled" boolean, "release_version" varchar(255), "created_at" datetime, "updated_at" datetime)&I'%indexindex_help_requests_on_user_idhelp_requests.CREATE INDEX "index_help_requests_on_user_id" ON "help_requests" ("user_id")  LT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0 NOT NULL, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime, "updated_at" datetime, "guest" boolean DEFAULT 'f', "facebook_handle" varchar(255), "twitter_handle" varchar(255), "googleplus_handle" varchar(255), "display_name" varchar(255), "address" varchar(255), "admin_area" varchar(255), "department" varchar(255), "title" varchar(255), "office" varchar(255), "chat_id" varchar(255), "website" varchar(255), "affiliation" varchar(255), "telephone" varchar(255), "avatar_file_name" varchar(255), "avatar_content_type" varchar(255), "avatar_file_size" integer, "avatar_updated_at" datetime, "group_list" text, "groups_last_update" datetime, "agreed_to_terms_of_service" boolean, "user_does_not_require_profile_update" boolean DEFAULT 'f', "repository_id" varchar(255))   ^)+]5Mindexindex_proxy_deposit_rights_on_grantee_idproxy_deposit_rights4CREATE INDEX "index_proxy_deposit_rights_on_grantee_id" ON "proxy_deposit_rights" ("grantee_id"))*]5Mindexindex_proxy_deposit_rights_on_grantor_idproxy_deposit_rights3CREATE INDEX "index_proxy_deposit_rights_on_grantor_id" ON "proxy_deposit_rights" ("grantor_id") 'O'1indexindex_help_requests_on_created_athelp_requests/CREATE INDEX "index_help_requests_on_created_at" ON "help_requests" ("created_at")}(E+indexindex_users_on_repository_idusersCREATE UNIQUE INDEX "index_users_on_repository_id" ON "users" ("repository_id")d)55ktableproxy_deposit_rightsproxy_deposit_rights1CREATE TABLE "proxy_deposit_rights" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "grantor_id" integer, "grantee_id" integer, "created_at" datetime, "updated_at" datetime)   [ufaAA--- !ruby/hash:ActionController::Parameters f: !ruby/hash:ActiveSupport::HashWithIndifferentAccess generic_type_sim: - Work q: asdf action: index controller: catalog 2013-11-07 14:03:39.7058872013-11-07 14:03:39.705887c[AA--- !ruby/hash:ActionController::Parameters f: !ruby/hash:ActiveSupport::HashWithIndifferentAccess generic_type_sim: - Work q: a action: index controller: catalog 2013-11-07 14:03:34.9376462013-11-07 14:03:34.937646c[AA--- !ruby/hash:ActionController::Parameters f: !ruby/hash:ActiveSupport::HashWithIndifferentAccess generic_type_sim: - Work q: p action: index controller: catalog 2013-11-07 14:03:33.9572212013-11-07 14:03:33.957221"YAA--- !ruby/hash:ActionController::Parameters q: Jeremy Friesen action: index controller: curate/people 2013-11-07 14:03:19.4107212013-11-07 14:03:19.410721 P,@PmoAA--- !ruby/hash:ActionController::Parameters f: !ruby/hash:ActiveSupport::HashWithIndifferentAccess generic_type_sim: - Work q: spork-o-gee action: index controller: catalog 2013-11-07 14:05:13.1518142013-11-07 14:05:13.151814igAA--- !ruby/hash:ActionController::Parameters f: !ruby/hash:ActiveSupport::HashWithIndifferentAccess generic_type_sim: - Work q: spork-o action: index controller: catalog 2013-11-07 14:05:12.3395812013-11-07 14:05:12.339581gcAA--- !ruby/hash:ActionController::Parameters f: !ruby/hash:ActiveSupport::HashWithIndifferentAccess generic_type_sim: - Work q: spork action: index controller: catalog 2013-11-07 14:05:11.5526962013-11-07 14:05:11.552696gcAA--- !ruby/hash:ActionController::Parameters f: !ruby/hash:ActiveSupport::HashWithIndifferentAccess generic_type_sim: - Work q: Hello action: index controller: catalog 2013-11-07 14:04:36.7011872013-11-07 14:04:36.701187   p uAA--- !ruby/hash:ActionController::Parameters f: !ruby/hash:ActiveSupport::HashWithIndifferentAccess generic_type_sim: - Work q: spork-o-geddon action: index controller: catalog 2013-11-07 14:05:13.9056622013-11-07 14:05:13.905662