CREATE INDEX "idx_a4_entry_id" ON "a4_derivatives" (entry_id);
CREATE INDEX "idx_a4_entry_link" ON "a4_derivatives" (entry_id, link_type);
CREATE INDEX idx_a5_from_bitig ON a5_cross_refs(from_bitig_id);
CREATE INDEX idx_a5_from_entry ON a5_cross_refs(from_entry_id);
CREATE INDEX "idx_a5_from_id" ON "a5_cross_refs" (from_id);
CREATE INDEX idx_a5_to_bitig ON a5_cross_refs(to_bitig_id);
CREATE INDEX idx_a5_to_entry ON a5_cross_refs(to_entry_id);
CREATE INDEX "idx_a5_to_id" ON "a5_cross_refs" (to_id);
CREATE INDEX idx_allah_root ON names_of_allah(root_id);
CREATE INDEX "idx_bitig_orig2_term" ON "bitig_a1_entries" (orig2_term);
CREATE INDEX "idx_bitig_root_id" ON "bitig_a1_entries" (root_id);
CREATE INDEX "idx_bitig_root_letters" ON "bitig_a1_entries" (root_letters);
CREATE INDEX idx_body_data_aa_root ON body_data(aa_root_id);
CREATE INDEX idx_body_data_status ON body_data(status);
CREATE INDEX idx_body_data_subsystem ON body_data(subsystem);
CREATE INDEX idx_body_data_subtable ON body_data(subtable);
CREATE INDEX idx_body_prayer_state ON body_prayer_map_unified(prayer_state);
CREATE INDEX idx_body_prayer_subsystem ON body_prayer_map_unified(subsystem);
CREATE INDEX idx_body_xref_source ON body_cross_refs_unified(source_table, source_id);
CREATE INDEX idx_body_xref_subsystem ON body_cross_refs_unified(subsystem);
CREATE INDEX idx_body_xref_target ON body_cross_refs_unified(target_table, target_id);
CREATE INDEX idx_child_nt ON child_entries(nt_code);
CREATE INDEX idx_child_op ON child_entries(parent_op);
CREATE INDEX idx_child_pattern ON child_entries(pattern);
CREATE INDEX idx_country_names_root ON country_names(root_id);
CREATE INDEX "idx_entries_ar_word" ON "entries" (ar_word);
CREATE INDEX "idx_entries_en_term" ON "entries" (en_term);
CREATE INDEX "idx_entries_fa_term" ON "entries" (fa_term);
CREATE INDEX "idx_entries_network_id" ON "entries" (network_id);
CREATE INDEX "idx_entries_root_id" ON "entries" (root_id);
CREATE INDEX "idx_entries_root_quf" ON "entries" (root_id, quf_pass);
CREATE INDEX "idx_entries_ru_term" ON "entries" (ru_term);
CREATE INDEX "idx_entries_score" ON "entries" (score);
CREATE INDEX "idx_eu_lang" ON "european_a1_entries" (lang);
CREATE INDEX "idx_eu_root_id" ON "european_a1_entries" (root_id);
CREATE INDEX "idx_eu_root_lang" ON "european_a1_entries" (root_id, lang);
CREATE INDEX "idx_eu_term" ON "european_a1_entries" (term);
CREATE INDEX idx_foundation_lang ON foundation_data(lang);
CREATE INDEX idx_foundation_layer ON foundation_data(layer);
CREATE INDEX idx_foundation_subtable ON foundation_data(subtable);
CREATE INDEX "idx_lat_root_id" ON "latin_a1_entries" (root_id);
CREATE INDEX "idx_lat_term" ON "latin_a1_entries" (lat_term);
CREATE INDEX idx_mechanism_lang ON mechanism_data(lang);
CREATE INDEX idx_mechanism_layer ON mechanism_data(layer);
CREATE INDEX idx_mechanism_subtable ON mechanism_data(subtable);
CREATE INDEX "idx_quf_pass_a4_derivatives" ON "a4_derivatives" (quf_pass);
CREATE INDEX "idx_quf_pass_a5_cross_refs" ON "a5_cross_refs" (quf_pass);
CREATE INDEX "idx_quf_pass_aa_morpheme_map" ON "aa_morpheme_map" (quf_pass);
CREATE INDEX "idx_quf_pass_agent_domains" ON "agent_domains" (quf_pass);
CREATE INDEX "idx_quf_pass_agricultural_system" ON "agricultural_system" (quf_pass);
CREATE INDEX "idx_quf_pass_att_terms" ON "att_terms" (quf_pass);
CREATE INDEX "idx_quf_pass_bitig_a1_entries" ON "bitig_a1_entries" (quf_pass);
CREATE INDEX "idx_quf_pass_bitig_convergence_register" ON "bitig_convergence_register" (quf_pass);
CREATE INDEX "idx_quf_pass_bitig_corrections" ON "bitig_corrections" (quf_pass);
CREATE INDEX "idx_quf_pass_bitig_degradation_register" ON "bitig_degradation_register" (quf_pass);
CREATE INDEX "idx_quf_pass_bitig_dispersal_map" ON "bitig_dispersal_map" (quf_pass);
CREATE INDEX "idx_quf_pass_bitig_heptad_manifest" ON "bitig_heptad_manifest" (quf_pass);
CREATE INDEX "idx_quf_pass_bitig_intelligence_summary" ON "bitig_intelligence_summary" (quf_pass);
CREATE INDEX "idx_quf_pass_bitig_orig2_sources" ON "bitig_orig2_sources" (quf_pass);
CREATE INDEX "idx_quf_pass_bitig_protocol" ON "bitig_protocol" (quf_pass);
CREATE INDEX "idx_quf_pass_bitig_semantic_fields" ON "bitig_semantic_fields" (quf_pass);
CREATE INDEX "idx_quf_pass_bitig_shift_register" ON "bitig_shift_register" (quf_pass);
CREATE INDEX idx_quf_pass_body_data ON body_data(quf_pass);
CREATE INDEX "idx_quf_pass_body_extraction_intel" ON "body_extraction_intel" (quf_pass);
CREATE INDEX "idx_quf_pass_body_heptad_meta" ON "body_heptad_meta" (quf_pass);
CREATE INDEX idx_quf_pass_body_prayer ON body_prayer_map_unified(quf_pass);
CREATE INDEX idx_quf_pass_body_xref ON body_cross_refs_unified(quf_pass);
CREATE INDEX "idx_quf_pass_category_summary" ON "category_summary" (quf_pass);
CREATE INDEX "idx_quf_pass_child_entries" ON "child_entries" (quf_pass);
CREATE INDEX "idx_quf_pass_chronology" ON "chronology" (quf_pass);
CREATE INDEX "idx_quf_pass_compute_protocol" ON "compute_protocol" (quf_pass);
CREATE INDEX "idx_quf_pass_contamination_blacklist" ON "contamination_blacklist" (quf_pass);
CREATE INDEX "idx_quf_pass_country_names" ON "country_names" (quf_pass);
CREATE INDEX "idx_quf_pass_db_integrity_log" ON "db_integrity_log" (quf_pass);
CREATE INDEX "idx_quf_pass_decay_levels" ON "decay_levels" (quf_pass);
CREATE INDEX "idx_quf_pass_disputed_words" ON "disputed_words" (quf_pass);
CREATE INDEX "idx_quf_pass_document_content" ON "document_content" (quf_pass);
CREATE INDEX "idx_quf_pass_dp_entry_map" ON "dp_entry_map" (quf_pass);
CREATE INDEX "idx_quf_pass_dp_register" ON "dp_register" (quf_pass);
CREATE INDEX "idx_quf_pass_entries" ON "entries" (quf_pass);
CREATE INDEX "idx_quf_pass_european_a1_entries" ON "european_a1_entries" (quf_pass);
CREATE INDEX "idx_quf_pass_excel_data_consolidated" ON "excel_data_consolidated" (quf_pass);
CREATE INDEX "idx_quf_pass_financial_extraction_cycles" ON "financial_extraction_cycles" (quf_pass);
CREATE INDEX "idx_quf_pass_formula_concealment" ON "formula_concealment" (quf_pass);
CREATE INDEX "idx_quf_pass_formula_cross_refs" ON "formula_cross_refs" (quf_pass);
CREATE INDEX "idx_quf_pass_formula_ratios" ON "formula_ratios" (quf_pass);
CREATE INDEX "idx_quf_pass_formula_restoration" ON "formula_restoration" (quf_pass);
CREATE INDEX "idx_quf_pass_formula_scholars" ON "formula_scholars" (quf_pass);
CREATE INDEX "idx_quf_pass_formula_undiscovered" ON "formula_undiscovered" (quf_pass);
CREATE INDEX idx_quf_pass_foundation ON foundation_data(quf_pass);
CREATE INDEX "idx_quf_pass_h7_seal_record" ON "h7_seal_record" (quf_pass);
CREATE INDEX "idx_quf_pass_id_sequences" ON "id_sequences" (quf_pass);
CREATE INDEX "idx_quf_pass_institutional_confession_register" ON "institutional_confession_register" (quf_pass);
CREATE INDEX "idx_quf_pass_intel_file_index" ON "intel_file_index" (quf_pass);
CREATE INDEX "idx_quf_pass_isnad" ON "isnad" (quf_pass);
CREATE INDEX "idx_quf_pass_kashgari_concealment_audit" ON "kashgari_concealment_audit" (quf_pass);
CREATE INDEX "idx_quf_pass_languages" ON "languages" (quf_pass);
CREATE INDEX "idx_quf_pass_latin_a1_entries" ON "latin_a1_entries" (quf_pass);
CREATE INDEX "idx_quf_pass_lattice_manifest" ON "lattice_manifest" (quf_pass);
CREATE INDEX "idx_quf_pass_main_heptad_manifest" ON "main_heptad_manifest" (quf_pass);
CREATE INDEX idx_quf_pass_mechanism ON mechanism_data(quf_pass);
CREATE INDEX "idx_quf_pass_name_root_hub" ON "name_root_hub" (quf_pass);
CREATE INDEX "idx_quf_pass_names_of_allah" ON "names_of_allah" (quf_pass);
CREATE INDEX "idx_quf_pass_nt_codes" ON "nt_codes" (quf_pass);
CREATE INDEX "idx_quf_pass_op_codes" ON "op_codes" (quf_pass);
CREATE INDEX "idx_quf_pass_operation_codes" ON "operation_codes" (quf_pass);
CREATE INDEX "idx_quf_pass_output_templates" ON "output_templates" (quf_pass);
CREATE INDEX "idx_quf_pass_permitted_labels" ON "permitted_labels" (quf_pass);
CREATE INDEX "idx_quf_pass_phonetic_reversal" ON "phonetic_reversal" (quf_pass);
CREATE INDEX "idx_quf_pass_protocol_corrections" ON "protocol_corrections" (quf_pass);
CREATE INDEX "idx_quf_pass_protocol_immutable" ON "protocol_immutable" (quf_pass);
CREATE INDEX "idx_quf_pass_protocol_preamble" ON "protocol_preamble" (quf_pass);
CREATE INDEX "idx_quf_pass_quf_tokens" ON "quf_tokens" (quf_pass);
CREATE INDEX "idx_quf_pass_quran_ayat" ON "quran_ayat" (quf_pass);
CREATE INDEX "idx_quf_pass_quran_known_forms" ON "quran_known_forms" (quf_pass);
CREATE INDEX "idx_quf_pass_quran_refs" ON "quran_refs" (quf_pass);
CREATE INDEX "idx_quf_pass_quran_word_roots" ON "quran_word_roots" (quf_pass);
CREATE INDEX "idx_quf_pass_qv_contamination_scan" ON "qv_contamination_scan" (quf_pass);
CREATE INDEX "idx_quf_pass_qv_translation_register" ON "qv_translation_register" (quf_pass);
CREATE INDEX "idx_quf_pass_root_explosion_manifest" ON "root_explosion_manifest" (quf_pass);
CREATE INDEX "idx_quf_pass_roots" ON "roots" (quf_pass);
CREATE INDEX "idx_quf_pass_schema_version" ON "schema_version" (quf_pass);
CREATE INDEX "idx_quf_pass_scholar_warnings" ON "scholar_warnings" (quf_pass);
CREATE INDEX "idx_quf_pass_score_review_candidates" ON "score_review_candidates" (quf_pass);
CREATE INDEX "idx_quf_pass_swot_analysis" ON "swot_analysis" (quf_pass);
CREATE INDEX "idx_quf_pass_swot_h7" ON "swot_h7" (quf_pass);
CREATE INDEX "idx_quf_pass_table_ownership" ON "table_ownership" (quf_pass);
CREATE INDEX "idx_quf_pass_term_dimensions" ON "term_dimensions" (quf_pass);
CREATE INDEX "idx_quf_pass_term_nodes" ON "term_nodes" (quf_pass);
CREATE INDEX "idx_quf_pass_umd_operations" ON "umd_operations" (quf_pass);
CREATE INDEX "idx_quf_pass_utul_register" ON "utul_register" (quf_pass);
CREATE INDEX "idx_quf_pass_uzbek_vocabulary" ON "uzbek_vocabulary" (quf_pass);
CREATE INDEX "idx_quf_pass_word_deployment_map" ON "word_deployment_map" (quf_pass);
CREATE INDEX "idx_quf_pass_write_gate" ON "write_gate" (quf_pass);
CREATE INDEX "idx_quf_pass_write_locks" ON "write_locks" (quf_pass);
CREATE INDEX idx_quran_refs_network ON quran_refs(network_id);
CREATE INDEX idx_quran_refs_surah ON quran_refs(surah, ayah);
CREATE INDEX "idx_qv_root" ON "qv_translation_register" (ROOT);
CREATE INDEX "idx_qwr_root" ON "quran_word_roots" (root);
CREATE INDEX "idx_qwr_root_surah" ON "quran_word_roots" (root, surah);
CREATE INDEX "idx_qwr_surah_ayah" ON "quran_word_roots" (surah, ayah);
CREATE INDEX idx_roots_bare ON roots(root_bare);
CREATE INDEX "idx_roots_letters" ON "roots" (root_letters);
CREATE INDEX idx_roots_quran ON roots(quran_tokens DESC);
CREATE INDEX idx_roots_type ON roots(root_type);
CREATE INDEX "idx_roots_type_quf" ON "roots" (root_type, quf_pass);
CREATE INDEX idx_session_status ON session_index(status);
CREATE INDEX idx_session_time ON session_index(start_time);
CREATE INDEX idx_uz_aa_root ON uzbek_vocabulary(aa_root);
CREATE INDEX idx_uz_bitig_root ON uzbek_vocabulary(bitig_root);
CREATE INDEX idx_uz_cyrillic ON uzbek_vocabulary(uz_cyrillic);
CREATE INDEX idx_uz_latin ON uzbek_vocabulary(uz_latin);
CREATE INDEX "idx_uz_orig_root" ON "uzbek_vocabulary" (orig_type, aa_root_id);
CREATE UNIQUE INDEX uq_bitig_orig2 ON bitig_a1_entries(orig2_term, root_letters) WHERE orig2_term IS NOT NULL;
CREATE UNIQUE INDEX uq_entries_en_root ON entries(en_term, root_id) WHERE en_term IS NOT NULL AND en_term != '';
CREATE UNIQUE INDEX uq_eu_lang_term ON european_a1_entries(lang, term) WHERE term IS NOT NULL;
CREATE UNIQUE INDEX uq_lat_term ON latin_a1_entries(lat_term) WHERE lat_term IS NOT NULL;
CREATE UNIQUE INDEX uq_roots_letters ON roots(root_letters);
