SQLite format 3@ 55'-)1v+3indexby_pid_and_dsidchecksum_audit_logsCREATE INDEX "by_pid_and_dsid" ON "checksum_audit_logs" ("pid", "dsid")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)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)MtablebookmarksbookmarksCREATE 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*$$   checksum searches! vers searches users Is] + AAsufia:3t94hd565contentcontent.02013-11-07 15:08:36.5217312013-11-07 15:08:36.521731c +!% AAsufia:3t94hd565propertiesproperties.02013-11-07 15:08:36.3167012013-11-07 15:08:36.316701g +%) AAsufia:3t94hd565descMetadatadescMetadata.12013-11-07 15:08:35.8573002013-11-07 15:08:35.857300k +)- AAsufia:3t94hd565rightsMetadatarightsMetadata.02013-11-07 15:08:35.6541472013-11-07 15:08:35.654147_ +! AAsufia:3t94hd565RELS-EXTRELS-EXT.02013-11-07 15:08:35.4273072013-11-07 15:08:35.427307T + AAsufia:3t94hd565DCDC1.02013-11-07 15:08:34.9788692013-11-07 15:08:34.978869 Nj+sufia:3t94hd565content+!sufia:3t94hd565properties +%sufia:3t94hd565descMetadata"+)sufia:3t94hd565rightsMetadata+sufia:3t94hd565RELS-EXT+ sufia:3t94hd565DC  f%MtablebookmarksbookmarksCREATE 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))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)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")X''otableconversationsconversationsCREATE TABLE "conversations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "subject" varchar(255) DEFAULT '', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   ^ %I]indexdtla_by_ids2domain_terms_local_authorities CREATE INDEX "dtla_by_ids2" ON "domain_terms_local_authorities" ("domain_term_id", "local_authority_id")/IIYtable%%}tabledomain_termsdomain_termsCREATE TABLE "domain_terms" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "model" varchar(255), "term" varchar(255))z;%!indexterms_by_model_and_termdomain_terms CREATE INDEX "terms_by_model_and_term" ON "domain_terms" ("model", "term")/IIYtabledomain_terms_local_authoritiesdomain_terms_local_authorities CREATE TABLE "domain_terms_local_authorities" ("domain_term_id" integer, "local_authority_id" integer) %I]indexdtla_by_ids2domain_terms_local_authorities CREATE INDEX "dtla_by_ids2" ON "domain_terms_local_authorities" ("domain_term_id", "local_authority_id") %I]indexdtla_by_ids1domain_terms_local_authorities CREATE INDEX "dtla_by_ids1" ON "domain_terms_local_authorities" ("local_authority_id", "domain_term_id")      aa"2K mtablefollowsfollowsCREATE 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)q )+indexfk_followablesfollowsCREATE INDEX "fk_followables" ON "follows" ("followable_id", "followable_type")e !indexfk_followsfollowsCREATE INDEX "fk_follows" ON "follows" ("follower_id", "follower_type")t'''tablehelp_requestshelp_requestsCREATE 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)   { ] 3AAI'm trapped in a fortune cookie factory!2013-11-07 10:02:372013-11-07 15:12:18.4552032013-11-07 15:12:18.455203 A 2013-11-07 15:12:18.455203 ..Ea* O'1indexindex_help_requests_on_created_athelp_requestsCREATE INDEX "index_help_requests_on_created_at" ON "help_requests" ("created_at")I'%indexindex_help_requests_on_user_idhelp_requestsCREATE INDEX "index_help_requests_on_user_id" ON "help_requests" ("user_id")//[tablelocal_authoritieslocal_authoritiesCREATE TABLE "local_authorities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))[;;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))"?;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")       bbz''itablenotificationsnotificationsCREATE 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)Y'Eindexindex_notifications_on_conversation_idnotificationsCREATE INDEX "index_notifications_on_conversation_id" ON "notifications" ("conversation_id")d55ktableproxy_deposit_rightsproxy_deposit_rightsCREATE TABLE "proxy_deposit_rights" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "grantor_id" integer, "grantee_id" integer, "created_at" datetime, "updated_at" datetime)  <AA2013-11-14 15:26:34.9506362013-11-14 15:26:34.950636; AA2013-11-14 15:26:57.2181522013-11-14 15:26:57.218152   NuxCtablereceiptsreceipts!CREATE TABLE "receipts" ("id" INTEGER PRIMARY KEY AUTOIN)]5Mindexindex_proxy_deposit_rights_on_grantee_idproxy_deposit_rightsCREATE INDEX "index_proxy_deposit_rights_on_grantee_id" ON "proxy_deposit_rights" ("grantee_id"))]5Mindexindex_proxy_deposit_rights_on_grantor_idproxy_deposit_rights CREATE INDEX "index_proxy_deposit_rights_on_grantor_id" ON "proxy_deposit_rights" ("grantor_id")xCtablereceiptsreceipts!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")    U jQ7AA--- !ruby/hash:ActionController::Parameters utf8: ✓ works: mine q: '"2013-11-14-08-50-34-732 Another Not Quite"' action: index controller: catalog 2013-11-14 13:50:40.4626952013-11-14 13:50:40.462695 UAA--- !ruby/hash:ActionController::Parameters utf8: ✓ works: mine controller: catalog action: index 2013-11-14 13:50:40.4083822013-11-14 13:50:40.408382(eAA--- !ruby/hash:ActionController::Parameters f: !ruby/hash:ActiveSupport::HashWithIndifferentAccess human_readable_type_sim: - Generic Work q: '"2013-11-14-08-50-34-732 Another Not Quite"' utf8: ✓ controller: catalog action: index 2013-11-14 13:50:39.9684702013-ZIAA--- !rIEAA--- !ruby/hash:Act(eAA--- !ruby/hash:ActionController::Parameters utf8: ✓ q: skateboard Cosby action: index controller: catalog 2013-11-07 15:29:45.1302922013-11-07 15:29:45.130292  bVtablesearchessearches#CREATE TABLE "searches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "query_params" text, "user_id" integer, "created_at"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")--Ctablesingle_use_linkssingle_use_links&CREATE 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)pKKWtablesubject_local_authority_entriessubject_local_authority_entries'CREATE TABLE "subject_local_authority_entries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "label" varchar(255), "lowerLabel" varchar(255), "url" varchar(255))      dgc%SGindexindex_users_on_reset_password_tokenusers/CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") 9K?indexentries_by_lower_labelsubject_local_authority_entries(CREATE INDEX "entries_by_lower_label" ON "subject_local_authority_entries" ("lowerLabel")G!atabletrophiestrophies)CREATE TABLE "trophies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "generic_file_id" varchar(255), "created_at" datetime, "updated_at" datetime)+"5tableusersusers+CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAU,e#5 indexindex_users_on_emailusers-CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")}$E+indexindex_users_on_repository_idusers.CREATE UNIQUE INDEX "index_users_on_repository_id" ON "users" ("repository_id") !Ba^]&w[&wAA%email-13514467802386058915066255394238701717@test.com$2a$04$7fGV0PZRlPIOnDWpCtWjhuFhRwluMFOja4eS05zI20uLch/hS8vdu2013-11-07 15:29:43.2200722013-11-07 15:29:43.220072fUser Name]&yAA'email-219041119925457594337334986957609934229@test.com$2a$04$t2mMfY7B5wiauw7nioel3OlebdMwfpK6707DsynhTC4KmWhA91RFm2013-11-07 15:47:11.3954862013-11-07 15:47:11.395486fUser Named 11t]\&yAA%email-330173584494715495994642503715342138956@test.com$2a$04$aMZ1GBadPl.k/PxDIKhop.bfJ1hbDxoCGQYLVwmpDv1R7jn2gwaeu2013-11-07 15:51:12.9500102013-11-07 15:51:12.950010fUser Named 2tt\&yAA%email-169903581322084982085492955407182066698@test.com$2a$04$BeUGzMdtz5WXKH4mWJJoaukSgmnf.8nFwR98dcSpeosMh3qEaURGu2013-11-07 15:51:12.8274832013-11-07 15:51:12.827483fUser Named 1ttLT '' 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)) ::yemail-209736895552317454299600684655236630781@test.com:yemail-210242976058924079317595195795415401330@test.com99wemail-13514467802386058915066255394238701717@test.co:yemail-219041119925457594337334986957609934229@test.com:yemail-330173584494715495994642503715342138956@test.com9y email-169903581322084982085492955407182066698@test.com +sufia:3t94h  nD+yAAsufia:3t94hb414contentcontent.1email-164594360573973488708550724236084491263@test.com2013-11-07 15:05:22.8094332013-11-07 15:05:22.809433+wAAsufia:3t94hh02gcontentcontent.0email-20907067213672355044440454476890265749@test.com2013-11-14 15:25:58.4343152013-11-14 15:25:58.43431+uAAsufia:3t94hj54fcontentcontent.0email-7843087589862932389447240360925187519@test.com2013-11-07 15:28:50.0686632013-11-07 15:28:50.068663 IFI(=//indexunique_schema_migrationsschema_migrations3CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q'//tableschema_migrationsschema_migrations2CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)%SGindexindex_users_on_reset_password_tokenusers/CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")"&11otableversion_committersversion_committers0CREATE 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) p^L:(tbP>,)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)20131106182814 |iVC0 r_L9&)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) 20131106182814 >>]|^&yAA)email-266627485855381732957301300584533878819@test.com$2a$04$5pogJ8SPJ30FJR8LlVQkX.nUPymiZsnIm5G6RebgeFw1uLIMJ416a2013-11-14 15:26:11.1654692013-11-14 15:26:11.165469fUser Named 582tt^&yAA)email-132967640666344181778248727896383850170@test.com$2a$04$2trgQLIxh7Goy9OLeVvfU.2H7hv8FpS1maGZ4FWj/xklppveZxKEi2013-11-14 15:26:11.1554992013-11-14 15:26:11.155499fUser Named 581tt^&yAA)email-209736895552317454299600684655236630781@test.com$2a$04$7spg69yFK56zPcyAM7JJ7OQ4DH4yIT8Owzi5hR6WwRZ7eIfescv6m2013-11-14 15:27:07.7559752013-11-14 15:27:07.755975fUser Named 670tt^&yAA)email-210242976058924079317595195795415401330@test.com$2a$04$RdcfRj5y91DxU3SIMhIC8eWvYswz0PakChm65hLoNHnpeW8qLh8F.2013-11-14 15:27:05.9729122013-11-14 15:27:05.972912fUser Named 669tt4^~]&wAA)email-40579453828665358368556134182530549379@test.com$2a$04$LDe7WXbkLnrTRLcPy62AO.48aQFNd3smSiGHrNTaRcHsawpbHNbTq2013-11-14 15:27:05.1306512013-11-14 15:27:05.130651fUser Named 668tt]&wAA)email-26159232253446762897023644604562687884@test.com$2a$04$GllPn5FC3VJU/9brP.vXf.1N8foQHEH.vQa35u3Zc/6onp6MKbKuS2013-11-14 15:27:05.1142282013-11-14 15:27:05.114228fUser Named 667tt^&yAA)email-317925268737155274089912317791943655917@test.com$2a$04$1uoWg2B1RETbSyjqNN/nGeb0PbCI2sHYHVUeJp08k0xCFMljZZLFO2013-11-14 15:27:03.1105242013-11-14 15:27:03.110524fUser Named 666tt^&yAA)email-218377686297915877759891300580545167519@test.com$2a$04$M.4mzibWxMDSQ/PQOQ3Iveb.eUUpwETA6UP8vM/21vYAgvJGqar762013-11-14 15:27:03.0991892013-11-14 15:27:03.099189fUser Named 665tt