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);