SQLite format 3@ .C;f))tablefeatured_worksfeatured_worksCREATE TABLE "featured_works" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order" integer DEFAULT 5, "work_id" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)@gEaindexindex_curation_concerns_operations_on_user_idcuration_concerns_operationsCREATE INDEX "index_curation_concerns_operations_on_user_id" ON "curation_concerns_operations" ("user_id")4_EQindexindex_curation_concerns_operations_on_rgtcuration_concerns_operationsCREATE INDEX "index_curation_concerns_operations_on_rgt" ON "curation_concerns_operations" ("rgt")FkEiindexindex_curation_concerns_operations_on_parent_idcuration_concerns_operationsCREATE INDEX "index_curation_concerns_operations_on_parent_id" ON "curation_concerns_operations" ("parent_id")4 _EQindexindex_curation_concerns_operations_on_lftcuration_concerns_operationsCREATE INDEX "index_curation_concerns_operations_on_lft" ON "curation_concerns_operations" ("lft")~ EEtablecuration_concerns_operationscuration_concerns_operations CREATE TABLE "curation_concerns_operations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "status" varchar, "operation_type" varchar, "job_class" varchar, "job_id" varchar, "type" varchar, "message" text, "user_id" integer, "parent_id" integer, "lft" integer NOT NULL, "rgt" integer NOT NULL, "depth" integer DEFAULT 0 NOT NULL, "children_count" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)n ))tablecontent_blockscontent_blocks CREATE TABLE "content_blocks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "value" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "external_key" varchar)' =EYindexhyrax_collection_type_idcollection_type_participants CREATE INDEX "hyrax_collection_type_id" ON "collection_type_participants" ("hyrax_collection_type_id")B EEtablecollection_type_participantscollection_type_participants CREATE TABLE "collection_type_participants" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "hyrax_collection_type_id" integer, "agent_type" varchar, "agent_id" varchar, "access" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)e??Ytablecollection_branding_infoscollection_branding_infos CREATE TABLE "collection_branding_infos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "collection_id" varchar, "role" varchar, "local_path" varchar, "alt_text" varchar, "target_url" varchar, "height" integer, "width" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)A3Gindexby_file_set_id_and_file_idchecksum_audit_logsCREATE INDEX "by_file_set_id_and_file_id" ON "checksum_audit_logs" ("file_set_id", "file_id")(]3Mindexindex_checksum_audit_logs_on_checked_urichecksum_audit_logsCREATE INDEX "index_checksum_audit_logs_on_checked_uri" ON "checksum_audit_logs" ("checked_uri")N33Ctablechecksum_audit_logschecksum_audit_logsCREATE TABLE "checksum_audit_logs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file_set_id" varchar, "file_id" varchar, "checked_uri" varchar, "expected_result" varchar, "actual_result" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "passed" boolean)tAindexindex_bookmarks_on_user_idbookmarksCREATE INDEX "index_bookmarks_on_user_id" ON "bookmarks" ("user_id")I%indexindex_bookmarks_on_document_idbookmarksCREATE INDEX "index_bookmarks_on_document_id" ON "bookmarks" ("document_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)tablebookmarksbookmarksCREATE TABLE "bookmarks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "user_type" varchar, "document_id" varchar, "document_type" varchar, "title" blob, "created_at" datetime or^bLS7@'/!  %sipity_roles                  I  W;SG)!indexindex_featured_works_on_orderfeatured_worksCREATE INDEX "index_featured_works_on_order" ON "featured_works" ("order")f))tablefeatured_worksfeatured_worksCREATE TABLE "featured_works" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order" integer DEFAULT 5, "work_id" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)@gEaindexindex_curation_concerns_operations_on_user_idcuration_concerns_operationsCREATE INDEX "index_curation_concerns_operations_on_user_id" ON "curation_concerns_operations" ("user_id")4_EQindexindex_curation_concerns_operations_on_rgtcuration_concerns_operationsCREATE INDEX "index_curation_concerns_operations_on_rgt" ON "curation_concerns_operations" ("rgt")FkEiindexindex_curation_concerns_operations_on_parent_idcuration_concerns_operationsCREATE INDEX "index_curation_concerns_operations_on_parent_id" ON "curation_concerns_operations" ("parent_id")4 _EQindexindex_curation_concerns_operations_on_lftcuration_concerns_operationsCREATE INDEX "index_curation_concerns_operations_on_lft" ON "curation_concerns_operations" ("lft")~ EEtablecuration_concerns_operationscuration_concerns_operations CREATE TABLE "curation_concerns_operations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "status" varchar, "operation_type" varchar, "job_class" varchar, "job_id" varchar, "type" varchar, "message" text, "user_id" integer, "parent_id" integer, "lft" integer NOT NULL, "rgt" integer NOT NULL, "depth" integer DEFAULT 0 NOT NULL, "children_count" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)n ))tablecontent_blockscontent_blocks CREATE TABLE "content_blocks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "value" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "external_key" varchar)' =EYindexhyrax_collection_type_idcollection_type_participants CREATE INDEX "hyrax_collection_type_id" ON "collection_type_participants" ("hyrax_collection_type_id")B EEtablecollection_type_participantscollection_type_participants CREATE TABLE "collection_type_participants" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "hyrax_collection_type_id" integer, "agent_type" varchar, "agent_id" varchar, "access" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)e??Ytablecollection_branding_infoscollection_branding_infos CREATE TABLE "collection_branding_infos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "collection_id" varchar, "role" varchar, "local_path" varchar, "alt_text" varchar, "target_url" varchar, "height" integer, "width" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)A3Gindexby_file_set_id_and_file_idchecksum_audit_logsCREATE INDEX "by_file_set_id_and_file_id" ON "checksum_audit_logs" ("file_set_id", "file_id")(]3Mindexindex_checksum_audit_logs_on_checked_urichecksum_audit_logsCREATE INDEX "index_checksum_audit_logs_on_checked_uri" ON "checksum_audit_logs" ("checked_uri")N33Ctablechecksum_audit_logschecksum_audit_logsCREATE TABLE "checksum_audit_logs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file_set_id" varchar, "file_id" varchar, "checked_uri" varchar, "expected_result" varchar, "actual_result" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "passed" boolean)tAindexindex_bookmarks_on_user_idbookmarksCREATE INDEX "index_bookmarks_on_user_id" ON "bookmarks" ("user_id")I%indexindex_bookmarks_on_document_idbookmarksCREATE INDEX "index_bookmarks_on_document_id" ON "bookmarks" ("document_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)tablebookmarksbookmarksCREATE TABLE "bookmarks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "user_type" varchar, "document_id" varchar, "document_type" varchar, "title" blob, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  < f2<  v u  8a9cindexindex_hyrax_collection_types_on_machine_idhyrax_collection_typesCREATE UNIQUE INDEX "index_hyrax_collection_types_on_machine_id" ON "hyrax_collection_types" ("machine_id"))99mtablehyrax_collection_typeshyrax_collection_typesCREATE TABLE "hyrax_collection_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "description" text, "machine_id" varchar, "nestable" boolean DEFAULT 't' NOT NULL, "discoverable" boolean DEFAULT 't' NOT NULL, "sharable" boolean DEFAULT 't' NOT NULL, "allow_multiple_membership" boolean DEFAULT 't' NOT NULL, "require_membership" boolean DEFAULT 'f' NOT NULL, "assigns_workflow" boolean DEFAULT 'f' NOT NULL, "assigns_visibility" boolean DEFAULT 'f' NOT NULL, "share_applies_to_new_works" boolean DEFAULT 't' NOT NULL, "brandable" boolean DEFAULT 't' NOT NULL, "badge_color" varchar DEFAULT '#663333') M+-indexindex_file_view_stats_on_user_idfile_view_statsCREATE INDEX "index_file_view_stats_on_user_id" ON "file_view_stats" ("user_id") M+-indexindex_file_view_stats_on_file_idfile_view_statsCREATE INDEX "index_file_view_stats_on_file_id" ON "file_view_stats" ("file_id")++=tablefile_view_statsfile_view_statsCREATE TABLE "file_view_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "date" datetime, "views" integer, "file_id" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "user_id" integer)U3=indexindex_file_download_stats_on_user_idfile_download_statsCREATE INDEX "index_file_download_stats_on_user_id" ON "file_download_stats" ("user_id")U3=indexindex_file_download_stats_on_file_idfile_download_statsCREATE INDEX "index_file_download_stats_on_file_id" ON "file_download_stats" ("file_id")33Mtablefile_download_statsfile_download_statsCREATE TABLE "file_download_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "date" datetime, "downloads" integer, "file_id" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "user_id" integer)K))indexindex_featured_works_on_work_idfeatured_worksCREATE INDEX "index_featured_works_on_work_id" ON "featured_works" ("work_id")cG)!indexindex_featured_works_on_orderfeatured_worksCREATE INDEX "index_featured_work"KAindexindex_mailboxer_conversation_opt_outs_on_unsubscriber_id_typemailboxer_conversation_opt_outs%CREATE INDEX "index_mailboxer_conversation_opt_outs_on_unsubscriber_id_type" ON "mailboxer_conversation_opt_outs" ("unsubscriber_id", "unsubscriber_type")d!}K indexindex_mailboxer_conversation_opt_outs_on_conversation_idmailboxer_conversation_opt_outs$CREATE INDEX "index_mailboxer_conversation_opt_outs_on_conversation_id" ON "mailboxer_conversation_opt_outs" ("conversation_id")G)!indexindex_featured_works_on_orderfeatured_worksCREATE INDEX "index_featured_works_on_order" ON "featured_works" ("order")~ KKstablemailboxer_conversation_opt_outsmailboxer_conversation_opt_outs#CREATE TABLE "mailboxer_conversation_opt_outs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "unsubscriber_type" varchar, "unsubscriber_id" integer, "conversation_id" integer) M+-indexindex_job_io_wrappers_on_user_idjob_io_wrappers"CREATE INDEX "index_job_io_wrappers_on_user_id" ON "job_io_wrappers" ("user_id")'_+Qindexindex_job_io_wrappers_on_uploaded_file_idjob_io_wrappers!CREATE INDEX "index_job_io_wrappers_on_uploaded_file_id" ON "job_io_wrappers" ("uploaded_file_id")S++]tablejob_io_wrappersjob_io_wrappers CREATE TABLE "job_io_wrappers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "uploaded_file_id" integer, "file_set_id" varchar, "mime_type" varchar, "original_name" varchar, "path" varchar, "relation" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)x))+tablehyrax_featureshyrax_featuresCREATE TABLE "hyrax_features" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar NOT NULL, "enabled" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)                 B - 2 b };_ Ba CEKE9indexuk_permission_template_accessespermission_template_accesses4CREATE UNIQUE INDEX "uk_permission_template_accesses" ON "permission_template_accesses" ("permission_template_id", "agent_id", "agent_type", "access")@/EEtablepermission_template_accessespermission_template_accesses3CREATE TABLE "permission_template_accesses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permission_template_id" integer, "agent_type" varchar, "agent_id" varchar, "access" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)"KAindexindex_mailboxer_conversation_opt_outs_on_unsubscriber_id_typemailboxer_conversation_opt_outs%CREATE INDEX "index_mailboxer_conversation_opt_outs_on_unsubscriber_id_type" ON "mailboxer_conversation_opt_outs" ("unsubscriber_id", "unsubscriber_type").M';indexindex_minter_states_on_namespaceminter_states2CREATE UNIQUE INDEX "index_minter_states_on_namespace" ON "minter_states" ("namespace")<-''7tableminter_statesminter_states1CREATE TABLE "minter_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "namespace" varchar DEFAULT 'default' NOT NULL, "template" varchar NOT NULL, "counters" text, "seq" integer(8) DEFAULT 0, "rand" blob, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Y,1indexindex_mailboxer_receipts_on_receiver_id_and_receiver_typemailboxer_receipts0CREATE INDEX "index_mailboxer_receipts_on_receiver_id_and_receiver_type" ON "mailboxer_receipts" ("receiver_id", "receiver_type")0+c1Yindexindex_mailboxer_receipts_on_notification_idmailboxer_receipts/CREATE INDEX "index_mailboxer_receipts_on_notification_id" ON "mailboxer_receipts" ("notification_id")f*11wtablemailboxer_receiptsmailboxer_receipts.CREATE TABLE "mailboxer_receipts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "receiver_type" varchar, "receiver_id" integer, "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, "is_delivered" boolean DEFAULT 'f', "delivery_method" varchar, "message_id" varchar)#)W;Aindexindex_mailboxer_notifications_on_typemailboxer_notifications-CREATE INDEX "index_mailboxer_notifications_on_type" ON "mailboxer_notifications" ("type")b(;indexindex_mailboxer_notifications_on_sender_id_and_sender_typemailboxer_notifications,CREATE INDEX "index_mailboxer_notifications_on_sender_id_and_sender_type" ON "mailboxer_notifications" ("sender_id", "sender_type")M'[;indexmailboxer_notifications_notified_objectmailboxer_notifications+CREATE INDEX "mailboxer_notifications_notified_object" ON "mailboxer_notifications" ("notified_object_type", "notified_object_id")x&;;indexindex_mailboxer_notifications_on_notified_object_id_and_typemailboxer_notifications*CREATE INDEX "index_mailboxer_notifications_on_notified_object_id_and_type" ON "mailboxer_notifications" ("notified_object_id", "notified_object_type")D%m;mindexindex_mailboxer_notifications_on_conversation_idmailboxer_notifications)CREATE INDEX "index_mailboxer_notifications_on_conversation_id" ON "mailboxer_notifications" ("conversation_id")$;;Atablemailboxer_notificationsmailboxer_notifications(CREATE TABLE "mailboxer_notifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "body" text, "subject" varchar DEFAULT '', "sender_type" varchar, "sender_id" integer, "conversation_id" integer, "draft" boolean DEFAULT 'f', "notification_code" varchar, "notified_object_type" varchar, "notified_object_id" integer, "attachment" varchar, "updated_at" datetime NOT NULL, "created_at" datetime NOT NULL, "global" boolean DEFAULT 'f', "expires" datetime)q#;;ytablemailboxer_conversationsmailboxer_conversations&CREATE TABLE "mailboxer_conversations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "subject" varchar DEFAULT '', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)                ;i d%, J - QJ qp ; E#indexindex_roles_users_on_role_idroles_usersGCREATE INDEX "index_roles_users_on_role_id" ON "roles_users" ("role_id")A]#Kindexindex_roles_users_on_role_id_and_user_idroles_usersFCREATE INDEX "index_roles_users_on_role_id_and_user_id" ON "roles_users" ("role_id", "user_id")d@##tableroles_usersroles_usersECREATE TABLE "roles_users" ("role_id" integer, "user_id" integer)Z:55Wtableqa_local_authoritiesqa_local_authorities?CREATE TABLE "qa_local_authorities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL))9]5Mindexindex_proxy_deposit_rights_on_grantor_idproxy_deposit_rights>CREATE INDEX "index_proxy_deposit_rights_on_grantor_id" ON "proxy_deposit_rights" ("grantor_id"))8]5Mindexindex_proxy_deposit_rights_on_grantee_idproxy_deposit_rights=CREATE INDEX "index_proxy_deposit_rights_on_grantee_id" ON "proxy_deposit_rights" ("grantee_id")v755tableproxy_deposit_rightsproxy_deposit_rights[AWindexindex_qa_local_authority_entries_on_uriqa_local_authority_entriesCCREATE UNIQUE INDEX "index_qa_local_authority_entries_on_uri" ON "qa_local_authority_entries" ("uri")                     ^ z ~ LT  xi[}indexsipity_entity_specific_responsibilities_entitysipity_entity_specific_responsibilitiesZCi[}indexsipity_entity_specific_responsibilities_entitysipity_entity_specific_responsibilitiesZCREATE INDEX "sipity_entity_specific_responsibilities_entity" ON "sipity_entity_specific_responsibilities" ("entity_id")WSg[yindexsipity_entity_specific_responsibilities_agentsipity_entity_specific_responsibilitiesYCREATE INDEX "sipity_entity_specific_responsibilities_agent" ON "sipity_entity_specific_responsibilities" ("agent_id")|BE#indexindex_roles_users_on_role_idroles_usersGCREATE INDEX "index_roles_users_on_role_id" ON "roles_users" ("role_id")A]#Kindexindex_roles_users_on_role_id_and_user_idroles_usersFCREATE INDEX "index_roles_users_on_role_id_and_user_id" ON "roles_users" ("role_id", "user_id")cR[[tablesipity_entity_specific_responsibilitiessipity_entity_specific_responsibilitiesXCREATE TABLE "sipity_entity_specific_responsibilities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "workflow_role_id" integer NOT NULL, "entity_id" varchar NOT NULL, "agent_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)*Qa+Uindexindex_sipity_entities_on_workflow_state_idsipity_entitiesWCREATE INDEX "index_sipity_entities_on_workflow_state_id" ON "sipity_entities" ("workflow_state_id")PU+=indexindex_sipity_entities_on_workflow_idsipity_entitiesVCREATE INDEX "index_sipity_entities_on_workflow_id" ON "sipity_entities" ("workflow_id")%OS+Yindexsipity_entities_proxy_for_global_idsipity_entitiesUCREATE UNIQUE INDEX "sipity_entities_proxy_for_global_id" ON "sipity_entities" ("proxy_for_global_id") N++wtablesipity_entitiessipity_entitiesTCREATE TABLE "sipity_entities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "proxy_for_global_id" varchar NOT NULL, "workflow_id" integer NOT NULL, "workflow_state_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)MQ+5indexindex_sipity_comments_on_entity_idsipity_commentsSCREATE INDEX "index_sipity_comments_on_entity_id" ON "sipity_comments" ("entity_id")LS+9indexindex_sipity_comments_on_created_atsipity_commentsRCREATE INDEX "index_sipity_comments_on_created_at" ON "sipity_comments" ("created_at")KO+1indexindex_sipity_comments_on_agent_idsipity_commentsQCREATE INDEX "index_sipity_comments_on_agent_id" ON "sipity_comments" ("agent_id")J++Ctablesipity_commentssipity_commentsPCREATE TABLE "sipity_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "entity_id" integer NOT NULL, "agent_id" integer NOT NULL, "comment" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)I;'Sindexsipity_agents_proxy_forsipity_agentsOCREATE UNIQUE INDEX "sipity_agents_proxy_for" ON "sipity_agents" ("proxy_for_id", "proxy_for_type")yH''1tablesipity_agentssipity_agentsNCREATE TABLE "sipity_agents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "proxy_for_id" varchar NOT NULL, "proxy_for_type" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) G--Itablesingle_use_linkssingle_use_linksMCREATE TABLE "single_use_links" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "downloadKey" varchar, "path" varchar, "itemId" varchar, "expires" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)pF?indexindex_searches_on_user_idsearchesKCREATE INDEX "index_searches_on_user_id" ON "searches" ("user_id")cEtablesearchessearchesJCREATE TABLE "searches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "query_params" blob, "user_id" integer, "user_type" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)|DE#indexindex_roles_users_on_user_idroles_usersICREATE INDEX "index_roles_users_on_user_id" ON "roles_users" ("user_id")C]#Kindexindex_roles_users_on_user_id_and_role_idroles_usersHCREATE INDEX "index_roles_users_on_user_id_and_role_id" ON "roles_users" ("user_id", "role_id")                  K t4(d };;}tablesipity_workflow_actionssipityA%#indexindex_sipity_roles_on_namesipity_roleslCREATE UNIQUE INDEX "index_sipity_roles_on_name" ON "sipity_roles" ("name")_dk5iindexindex_sipity_notifications_on_notification_typesipity_notificationsjCREATE INDEX "index_sipity_notifications_on_notification_type" ON "sipity_notifications" ("notification_type")bQ5Cindexindex_sipity_notifications_on_namesipity_notificationsiCREATE UNIQUE INDEX "index_sipity_notifications_on_name" ON "sipity_notifications" ("name")ZTi[}indexsipity_entity_specific_responsibilities_entitysipity_entity_specific_responsibilitiesZCREATE INDEX "sipity_entity_specific_responsibilities_entity" ON "sipity_entity_specific_responsibilities" ("entity_id") a555tablesipity_notificationssipity_notificationshCREATE TABLE "sipity_notifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "notification_type" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)0`SIQindexsipity_notification_recipients_rolesipity_notification_recipientsgCREATE INDEX "sipity_notification_recipients_role" ON "sipity_notification_recipients" ("role_id")W_oIindexsipity_notification_recipients_recipient_strategysipity_notification_recipientsfCREATE INDEX "sipity_notification_recipients_recipient_strategy" ON "sipity_notification_recipients" ("recipient_strategy")H^cIqindexsipity_notification_recipients_notificationsipity_notification_recipientseCREATE INDEX "sipity_notification_recipients_notification" ON "sipity_notification_recipients" ("notification_id")e]_I/indexsipity_notifications_recipients_surrogatesipity_notification_recipientsdCREATE INDEX "sipity_notifications_recipients_surrogate" ON "sipity_notification_recipients" ("notification_id", "role_id", "recipient_strategy")O\IItablesipity_notification_recipientssipity_notification_recipientscCREATE TABLE "sipity_notification_recipients" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "notification_id" integer NOT NULL, "role_id" integer NOT NULL, "recipient_strategy" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)W[QA)indexsipity_notifiable_contexts_concernsipity_notifiable_contextsbCREATE INDEX "sipity_notifiable_contexts_concern" ON "sipity_notifiable_contexts" ("scope_for_notification_id", "scope_for_notification_type")ZaAoindexsipity_notifiable_contexts_concern_contextsipity_notifiable_contextsaCREATE INDEX "sipity_notifiable_contexts_concern_context" ON "sipity_notifiable_contexts" ("scope_for_notification_id", "scope_for_notification_type", "reason_for_notification") YeA'indexsipity_notifiable_contexts_concern_surrogatesipity_notifiable_contexts`CREATE UNIQUE INDEX "sipity_notifiable_contexts_concern_surrogate" ON "sipity_notifiable_contexts" ("scope_for_notification_id", "scope_for_notification_type", "reason_for_notification", "notification_id")>XaAgindexsipity_notifiable_contexts_notification_idsipity_notifiable_contexts_CREATE INDEX "sipity_notifiable_contexts_notification_id" ON "sipity_notifiable_contexts" ("notification_id") WAAtablesipity_notifiable_contextssipity_notifiable_contexts]CREATE TABLE "sipity_notifiable_contexts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "scope_for_notification_id" integer NOT NULL, "scope_for_notification_type" varchar NOT NULL, "reason_for_notification" varchar NOT NULL, "notification_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)]Ve[indexsipity_entity_specific_responsibilities_rolesipity_entity_specific_responsibilities\CREATE INDEX "sipity_entity_specific_responsibilities_role" ON "sipity_entity_specific_responsibilities" ("workflow_role_id")Uo[Qindexsipity_entity_specific_responsibilities_aggregatesipity_entity_specific_responsibilities[CREATE UNIQUE INDEX "sipity_entity_specific_responsibilities_aggregate" ON "sipity_entity_specific_responsibilities" ("workflow_role_id", "entity_id", "agent_id")             7e!OAAdepositingGrants access to depositing tasks2020-08-04 20:31:14.3666892020-08-04 20:31:14.368220bKAAapprovingGrants access to approval tasks2020-08-04 20:31:14.3637242020-08-04 20:31:14.365072cOAAmanagingGrants access to management tasks2020-08-04 20:31:14.3591232020-08-04 20:31:14.361638 !depositing approving  managing   9 h >  5!f U9=indexindex_sipity_workflow_states_on_namesipity_workflow_states}CR-[G=indexsipity_workflow_state_action>rGG{tablesipity_workflow_state_actionssipity_workflow_state_actionszCREATE TABLE "sipity_workflow_state_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "originating_workflow_state_id" integer NOT NULL, "workflow_action_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)>ck5iindexindex_sipity_notifications_on_notification_typesipity_notificationsjCREATE INDEX "index_sipity_notifications_on_notification_type" ON "sipity_notifications" ("notification_type")qq][indexsipity_workflow_state_action_permissions_aggregatesipity_workflow_state_action_permissionsyCREATE UNIQUE INDEX "sipity_workflow_state_action_permissions_aggregate" ON "sipity_workflow_state_action_permissions" ("workflow_role_id", "workflow_state_action_id")Xp]]tablesipity_workflow_state_action_permissionssipity_workflow_state_action_permissionsxCREATE TABLE "sipity_workflow_state_action_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "workflow_role_id" integer NOT NULL, "workflow_state_action_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL),oK7cindexsipity_workflow_roles_aggregatesipity_workflow_roleswCREATE UNIQUE INDEX "sipity_workflow_roles_aggregate" ON "sipity_workflow_roles" ("workflow_id", "role_id") n771tablesipity_workflow_rolessipity_workflow_rolesvCREATE TABLE "sipity_workflow_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "workflow_id" integer NOT NULL, "role_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)^maMindexsipity_workflow_responsibilities_aggregatesipity_workflow_responsibilitiesuCREATE UNIQUE INDEX "sipity_workflow_responsibilities_aggregate" ON "sipity_workflow_responsibilities" ("agent_id", "workflow_role_id")0lMMStablesipity_workflow_responsibilitiessipity_workflow_responsibilitiestCREATE TABLE "sipity_workflow_responsibilities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "workflow_role_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Mks;yindexindex_sipity_workflow_methods_on_workflow_action_idsipity_workflow_methodssCREATE INDEX "index_sipity_workflow_methods_on_workflow_action_id" ON "sipity_workflow_methods" ("workflow_action_id")6j;;tablesipity_workflow_methodssipity_workflow_methodsrCREATE TABLE "sipity_workflow_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "service_name" varchar NOT NULL, "weight" integer NOT NULL, "workflow_action_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) iM;Eindexsipity_workflow_actions_workflowsipity_workflow_actionsqCREATE INDEX "sipity_workflow_actions_workflow" ON "sipity_workflow_actions" ("workflow_id")1hO;eindexsipity_workflow_actions_aggregatesipity_workflow_actionspCREATE UNIQUE INDEX "sipity_workflow_actions_aggregate" ON "sipity_workflow_actions" ("workflow_id", "name")Pgm;indexsipity_workflow_actions_resulting_workflow_statesipity_workflow_actionsnCREATE INDEX "sipity_workflow_actions_resulting_workflow_state" ON "sipity_workflow_actions" ("resulting_workflow_state_id")3f;;}tablesipity_workflow_actionssipity_workflow_actionsmCREATE TABLE "sipity_workflow_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "workflow_id" integer NOT NULL, "resulting_workflow_state_id" integer, "name" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)~eA%#indexindex_sipity_roles_on_namesipity_roleslCREATE UNIQUE INDEX "index_sipity_roles_on_name" ON "sipity_roles" ("name")_d%%tablesipity_rolessipity_roleskCREATE TABLE "sipity_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "description" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)                 f m cB GPG G11ktableversion_committersversion_committersCREATE TABLE "version_committers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "obj_id" varchar, "datastream_id" varchar, "version_id" varchar, "committer_login" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) G{C!indexindex_5GtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "guest" boolean DEFAULT 'f', "facebook_handle" varchar, "twitter_handle" varchar, "googleplus_handle" varchar, "display_name" varchar, "address" varchar, "admin_area" varchar, "department" varchar, "title" varchar, "office" varchar, "chat_id" varchar, "website" varchar, "affiliation" varchar, "telephone" varchar, "avatar_file_name" varchar, "avatar_content_type" varchar, "avatar_file_size" integer, "avatar_updated_at" datetime, "linkedin_handle" varchar, "orcid" varchar, "arkivo_token" varchar, "arkivo_subscription" varchar, "zotero_token" blob, "zotero_userid" varchar, "preferred_locale" varchar)yC!indexindex_user_stats_on_user_iduser_statsCREATE INDEX "index_user_stats_on_user_id" ON "user_stats" ("user_id")~!!wtableuser_statsuser_statsCREATE TABLE "user_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "date" datetime, "file_views" integer, "file_downloads" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "work_views" integer) }K))indexindex_uploaded_files_on_user_iduploaded_filesCREATE INDEX "index_uploaded_files_on_user_id" ON "uploaded_files" ("user_id")|U)=indexindex_uploaded_files_on_file_set_uriuploaded_filesCREATE INDEX "index_uploaded_files_on_file_set_uri" ON "uploaded_files" ("file_set_uri")t{))!tableuploaded_filesuploaded_filesCREATE TABLE "uploaded_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file" varchar, "user_id" integer, "file_set_uri" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)MzktabletrophiestrophiesCREATE TABLE "trophies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "work_id" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Iy))Ktabletinymce_assetstinymce_assetsCREATE TABLE "tinymce_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "file" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Yxy-indexindex_sipity_workflows_on_permission_template_and_namesipity_workflowsCREATE UNIQUE INDEX "index_sipity_workflows_on_permission_template_and_name" ON "sipity_workflows" ("permission_template_id", "name")Pw--Qtablesipity_workflowssipity_workflowsCREATE TABLE "sipity_workflows" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "label" varchar, "description" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "permission_template_id" integer, "active" boolean, "allows_access_grant" boolean)#vC9Windexsipity_type_state_aggregatesipity_workflow_states~CREATE UNIQUE INDEX "sipity_type_state_aggregate" ON "sipity_workflow_states" ("workflow_id", "name")uU9=indexindex_sipity_workflow_states_on_namesipity_workflow_states}CREATE INDEX "index_sipity_workflow_states_on_name" ON "sipity_workflow_states" ("name") t99-tablesipity_workflow_statessipity_workflow_states|CREATE TABLE "sipity_workflow_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "workflow_id" integer NOT NULL, "name" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)is[G=indexsipity_workflow_state_actions_aggregatesipity_workflow_state_actions{CREATE UNIQUE INDEX "sipity_workflow_state_actions_aggregate" ON "sipity_workflow_state_actions" ("originating_workflow_state_id", "workflow_action_id")               3 c  x3  F 3 O55?tablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)J q9uindexindex_zizia_pre_ingest_files_on_pre_ingest_work_idzizia_pre_ingest_filesCREATE INDEX "index_zizia_pre_ingest_files_on_pre_ingest_work_id" ON "zizia_pre_ingest_files" ("pre_ingest_work_id")[ 99Otablezizia_pre_ingest_fileszizia_pre_ingest_filesCREATE TABLE "zizia_pre_ingest_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "size" integer, "row" text, "row_number" integer, "filename" varchar, "pre_ingest_work_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "status" varchar DEFAULT 'preingest') Q/5indexindex_zizia_csv_imports_on_user_idzizia_csv_importsCREATE INDEX "index_zizia_csv_imports_on_user_id" ON "zizia_csv_imports" ("user_id")' //{tablezizia_csv_importszizia_csv_importsCREATE TABLE "zizia_csv_imports" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "manifest" varchar, "fedora_collection_id" varchar, "update_actor_stack" varchar)Ck=iindexindex_zizia_csv_import_details_on_csv_import_idzizia_csv_import_detailsCREATE INDEX "index_zizia_csv_import_details_on_csv_import_id" ON "zizia_csv_import_details" ("csv_import_id")6==}tablezizia_csv_import_detailszizia_csv_import_detailsCREATE TABLE "zizia_csv_import_details" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "csv_import_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "depositor_id" varchar, "collection_id" varchar, "batch_id" varchar, "success_count" integer, "failure_count" integer, "deduplication_field" varchar, "update_actor_stack" varchar, "status" varchar) M+-indexindex_work_view_stats_on_work_idwork_view_statsCREATE INDEX "index_work_view_stats_on_work_id" ON "work_view_stats" ("work_id") M+-indexindex_work_view_stats_on_user_idwork_view_statsCREATE INDEX "index_work_view_stats_on_user_id" ON "work_view_stats" ("user_id") ++Gtablework_view_statswork_view_statsCREATE TABLE "work_view_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "date" datetime, "work_views" integer, "work_id" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "user_id" integer)!11ktableversion_committersversion_committersCREATE TABLE "version_committers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "obj_id" varchar, "datastream_id" varchar, "version_id" varchar, "committer_login" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")f5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email") =&GtableusersusersCREATE TABH[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadata  y//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)BU/indexsqlite_autoindex_schema_migrations_1schema_migrations Go9qindexindex_zizia_pre_ingest_works_on_deduplication_keyzizia_pre_ingest_worksCREATE INDEX "index_zizia_pre_ingest_works_on_deduplication_key" ON "zizia_pre_ingest_works" ("deduplication_key")Pu9}indexindex_zizia_pre_ingest_works_on_csv_import_detail_idzizia_pre_ingest_worksCREATE INDEX "index_zizia_pre_ingest_works_on_csv_import_detail_id" ON "zizia_pre_ingest_works" ("csv_import_detail_id")M 993tablezizia_pre_ingest_workszizia_pre_ingest_worksCREATE TABLE "zizia_pre_ingest_works" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_object" integer, "csv_import_detail_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deduplication_key" varchar, "status" varchar DEFAULT 'preingest')            U o]K9'saO=+ w e S A /  { i W E 3 !   m [ I 6 #  n \ J 8 &  U)20190923182946T)20190921154221S)20190921153802R)20190911134002Q)20190921153933P)20191114021032O+201901162203121N)20190918214137M)20191210223833L)20190919145012K)20190911142616J)20191105165518I)20190921153851H)20190921154009G)20190911133657F)20191029162902E+201901162141281D+201901241536541C)20190921154038B)20191031131041A)20191105211127@)20190918192857?)20190918192870>)20190918192886=)20190918192842<)20190918192843;)20190918193046:)201909181928679)201909181928538)201909181929157)201909181929146)201909181928775)201909181928724)201909181928413)201909181928822)201909181929171)201909181928400)20190918192884/)20190918192844.)20190918193045-)20190918192715,)20190918192888+)20190918192869*)20190918192881))20190918192848()20190918192883')20190918192885&)20190918192887%)20190918192852$)20190918192864#)20190918192851")20190918192850!)20190918192948 )20190918192862)20190918192627)20190918192889)20190918192849)20190918192875)20190918192871)20190918192863)20190918192866)20190918192879)20190918192861)20190918192628)20190918192873)20190918192880)20190918192868)20190918192937)20190918192855)20190918192704)20190918192874)20190918192876 )20190918192858 )20190918192626 )20190918192856 )20190918192878 )20190918192847)20190918192865)20190918192854)20190918192846)20190918192860)20190918192916)20190918192845)20190918192859+201901241536542 U  m ^ ] $ y U z g A {/ @ K  Th%  S q  B8 7  p  f .  J 4 Z   - G)20190923182946U)20190921154221T)20190921153802S)20190911134002R)20190921153933Q)20191114021032P+201901162203121O)20190918214137N)20191210223833M)20190919145012L)20190911142616K)20191105165518J)20190921153851I)20190921154009H)20190911133657G)20191029162902F+201901162141281E+201901241536541D)20190921154038C)20191031131041B)20191105211127A)20190918192857@)20190918192870?)20190918192886>)20190918192842=)20190918192843<)20190918193046;)20190918192867:)201909181928539)201909181929158)201909181929147)201909181928776)201909181928725)201909181928414)201909181928823)201909181929172)201909181928401)201909181928840)20190918192844/)20190918193045.)20190918192715-)20190918192888,)20190918192869+)20190918192881*)20190918192848))20190918192883()20190918192885')20190918192887&)20190918192852%)20190918192864$)20190918192851#)20190918192850")20190918192948!)20190918192862 )20190918192627)20190918192889)20190918192849)20190918192875)20190918192871)20190918192863)20190918192866)20190918192879)20190918192861)20190918192628)20190918192873)20190918192880)20190918192868)20190918192937)20190918192855)20190918192704)20190918192874)20190918192876)20190918192858 )20190918192626 )20190918192856 )20190918192878 )20190918192847 )20190918192865)20190918192854)20190918192846)20190918192860)20190918192916)20190918192845)20190918192859+ 201901241536542 H#AAenvironmenttest2020-08-04 20:31:00.1273342020-08-04 20:31:00.127334 # environment