Spaces:
Sleeping
Sleeping
File size: 11,522 Bytes
7cc8e29 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 | 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);
|