SQLite format 3@ D4(D-â)Ø2ûöñìçâÝØv+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*$$       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¯"‰2‚K „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)     ..¾EÞ¼a* 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")d55‚ktableproxy_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)    ¢¢Núuž‚x…Ctablereceiptsreceipts!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")‚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")     ·· bV‚tablesearchessearches#CREATE TABLE "searches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "query_params" text, "user_id" integer, "created_at"V‚tablesearchessearches#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)pKK‚Wtablesubject_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))      ''Å=¤k­}%EG!‚atabletrophiestrophies)CREATE TABLE "trophies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" in 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)‰#"’%tableusersusers+CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(25,e#5 indexindex_users_on_emailusers-CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")Z$3yindexindex_users_on_nameusers.CREATE INDEX "index_users_on_name" ON "users" ("name") 5) 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), "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))      ÊÇFÛTÊ)=//indexunique_schema_migrationsschema_migrations4CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q(//tableschema_migrationsschema_migrations3CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)}%E+indexindex_users_on_repository_idusers/CREATE UNIQUE INDEX "index_users_on_repository_id" ON "users" ("repository_id")&SGindexindex_users_on_reset_password_tokenusers0CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")‚"'11ƒotableversion_committersversion_committers1CREATE 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>,)20140131175549)20140131175548)20140131175547)20140131175546)20140131175545)20140131175541)20140131175540)20140131175539)20140131175538)20140131175537)20140131175536)20140131175514)20140131175513)20140131175512)20140131175511 )20140131175510 )20140131175509 )20140131175508 )20140131175507 )20140131175506)20140131175505)20140131175504)20140131175503)20140131175502)20140131175501)20140131175500)20140131175455)20140131175550 íÛȵ¢|iVC0 ÷äѾ«˜…r_L9&íî)20140131175549)20140131175548)20140131175547)20140131175546)20140131175545)20140131175541)20140131175540)20140131175539)20140131175538)20140131175537)20140131175536)20140131175514)20140131175513)20140131175512)20140131175511)20140131175510 )20140131175509 )20140131175508 )20140131175507 )20140131175506 )20140131175505)20140131175504)20140131175503)20140131175502)20140131175501)20140131175500)20140131175455) 20140131175550