dbv
.php
Check for updates
Database schema
Schema object
In DB
On disk
abstract_idea_economic_entity
YES
YES
abstract_idea_entity
YES
YES
abstract_idea_political_conflict
YES
YES
abstract_idea_political_entity
YES
YES
abstract_idea_scientific_entity
YES
YES
abstract_idea_social_entity
YES
YES
abstract_idea_theological_entity
YES
YES
academic_institution
YES
YES
academic_organization
NO
YES
academic_organizations_palestine
YES
NO
acceptance_negative
NO
YES
acceptance_positive
NO
YES
account_type
YES
YES
action
YES
YES
ad_hoc_event
YES
NO
additionalcontext
YES
NO
administrative_facilities_palestine
YES
NO
adornment_object
NO
YES
advertising_expression
YES
YES
affection_positive
NO
YES
afterlife_expression
YES
YES
age_identity
YES
NO
air_military_object
NO
YES
air_military_object_type
YES
NO
airports_palestine
YES
NO
alertness_negative
NO
YES
alertness_positive
NO
YES
alerts
YES
NO
alerts_settings
YES
NO
allah_participation_jihad
NO
YES
allconceptsarr
YES
NO
allconceptscaptions
YES
NO
altruism_selflessness_negative
NO
YES
altruism_selflessness_positive
NO
YES
ambition_negative
NO
YES
ambition_positive
NO
YES
american_anti_black_expression
NO
YES
american_anti_conservative_expression
NO
YES
american_anti_democratic_party_expression
NO
YES
american_anti_left_wing_republican_expression
NO
YES
american_anti_liberal_expression
NO
YES
american_anti_republican_party_expression
NO
YES
american_anti_tea_party_expression
NO
YES
american_anti_white_expression
NO
YES
american_energy_issue
YES
YES
american_political_issue
NO
YES
american_political_person
YES
NO
american_radical_political_slogan
YES
NO
american_us_radical_person
YES
NO
american_us_radical_right_wing_person
YES
NO
american_voting_election_slogan
YES
NO
ammunition_code_words
YES
YES
amusement_negative
NO
YES
amusement_positive
NO
YES
analyst_estimate_calendar
YES
YES
antagonistic_interaction_action
YES
YES
anti
YES
YES
anti_algerian_expression
NO
YES
anti_america_expression
NO
YES
anti_american_expression
NO
YES
anti_christian_expression
NO
YES
anti_concept
YES
YES
anti_egyptian_military_regime_expression
NO
YES
anti_egyptian_mursi_regime_expression
NO
YES
anti_fatah_expression
NO
YES
anti_gay_homophobic_expression
NO
YES
anti_hamas_expression
NO
YES
anti_hindi_buddhist_expression
NO
YES
anti_hizballah_expression
NO
YES
anti_instance
YES
YES
anti_iranian_expression
YES
YES
anti_iraqi_government_expression
NO
YES
anti_isis_expression
NO
YES
anti_israel_expression
YES
YES
anti_israeli_expression
NO
YES
anti_jewish_expression
NO
YES
anti_jordan_expression
NO
YES
anti_maghreb_government_expression
NO
YES
anti_moroccan_expression
NO
YES
anti_muslim_brotherhood_expression
NO
YES
anti_muslim_expression
NO
YES
anti_non_muslim_general_expression
NO
YES
anti_object_indicator
YES
YES
anti_qatar_expression
NO
YES
anti_radical_expression
NO
YES
anti_russian_expression
NO
YES
anti_saudi_expression
NO
YES
anti_shiite_expression
NO
YES
anti_sunni_expression
NO
YES
anti_syrian_expression
NO
YES
anti_tank_weapon_type
YES
NO
anti_the_shahs_regime_expression
NO
YES
anti_turkish_expression
NO
YES
anti_western_expression
NO
YES
anticipation_negative
NO
YES
anticipation_positive
NO
YES
apocalyptic_expression
YES
YES
apostasy_trait
NO
YES
appelative_of_islam
YES
YES
appreciation_negative
NO
YES
appreciation_positive
NO
YES
approval_negative
NO
YES
approval_positive
NO
YES
archeological_sites_palestine
YES
NO
army_rank
YES
NO
art_pieces_isl
YES
NO
artillery_weapon_type
YES
NO
assets_isl
YES
NO
astronomic_place_object
YES
YES
attack_code_words
YES
YES
attention_negative
NO
YES
autonomous_vehicle_technology
YES
NO
aya
YES
YES
balance_of_payments
YES
YES
bank_account_number
YES
YES
bank_transaction
YES
YES
banking_financial_expression
YES
YES
banking_rates
YES
YES
banking_supervision_oversight
YES
YES
banking_topic
YES
NO
banks_palestine
YES
NO
basis_for_legal_ruling
YES
YES
bcc_field
YES
YES
beauty_negative
NO
YES
beauty_positive
NO
YES
belief_credence_positive
NO
YES
belongingness
YES
NO
belongingness_negative
NO
YES
belongingness_positive
NO
YES
belovedness_negative
NO
YES
belovedness_positive
NO
YES
biological_object
NO
YES
blessed_vs_cursed_negative
NO
YES
blessed_vs_cursed_positive
NO
YES
bonds_expression
YES
YES
border_checkpoints_pa
YES
NO
bravery_negative
NO
YES
bravery_positive
NO
YES
bridge
YES
YES
bridges_palestine
YES
NO
buildings_palestine
YES
NO
bus_stations_pa
YES
NO
business_model
YES
YES
business_person
YES
NO
cacheeng
YES
YES
capability_negative
NO
YES
capability_positive
NO
YES
capital_investment_national_output_ratio
YES
YES
career_promotion
YES
NO
cash_expression
YES
YES
cash_transaction_expression
YES
YES
causation
YES
NO
cc_field
YES
YES
cellular_service
YES
NO
cemeteries_palestine
YES
NO
centralist_israeli_political_party
YES
NO
certainty_negative
NO
YES
certainty_positive
NO
YES
check_transaction_expression
YES
YES
chemical_non_product
NO
YES
chemical_state
YES
NO
chemical_weapon_material
YES
NO
churches_palestine
YES
NO
cinemas_palestine
YES
NO
city
YES
YES
classification
YES
NO
cleanliness_negative
NO
YES
cleanliness_positive
NO
YES
clothing_object
NO
YES
coherence_negative
NO
YES
coherence_positive
NO
YES
collective_identity
NO
YES
collective_identity_group
YES
NO
collective_sentiment_indicator
NO
YES
color
YES
NO
color_attribute
YES
NO
combatant_sentiment_reference_negative
NO
YES
combatant_sentiment_reference_positive
NO
YES
command_quality
YES
NO
commentators
YES
NO
comments_amount
YES
NO
commerce_expression
YES
YES
commercial_activity_domain_expression
NO
YES
commercial_cyber_organisation
YES
NO
commercial_cyber_target_object
YES
NO
commercial_entity
NO
YES
commercial_event_type
YES
NO
commercial_facilities_pa
YES
NO
commercial_organization_expression
NO
YES
commercial_organization_type
YES
YES
commercial_product
YES
YES
commercial_sector
NO
YES
comminity_centers_palestine
YES
NO
common_chemical_substance
YES
NO
communication_technological_object
NO
YES
communications_cyber_target_object
YES
NO
community_centers_palestine
YES
NO
companies_isl
YES
NO
company_expression
NO
YES
comparative_negative
NO
YES
comparative_positive
NO
YES
compensation_in_employment
YES
NO
compensation_negative
NO
YES
compensation_positive
NO
YES
competitiveness
YES
YES
complex_measure_indicator
YES
YES
component
YES
NO
compromising_negative
NO
YES
compromising_positive
NO
YES
computer_constant
YES
YES
computer_expression
YES
YES
computer_hardware
YES
NO
computer_path
YES
YES
concept
YES
YES
concepts_indexes
YES
NO
configurationmanage
YES
YES
consideration_negative
NO
YES
consideration_positive
NO
YES
consistency_negative
NO
YES
consistency_positive
NO
YES
contemporary_person
NO
YES
contract_renewal
YES
NO
cooperative_interaction_action
YES
YES
cooperativeness_negative
NO
YES
cooperativeness_positive
NO
YES
coordinates_table
YES
NO
counted_theatre
YES
YES
courtesy_negative
NO
YES
courtesy_positive
NO
YES
courthouses_palestine
YES
NO
crawler_settings
YES
NO
creativity_negative
NO
YES
creativity_positive
NO
YES
credit_card_expression
YES
YES
credit_card_number
YES
NO
credit_expression
YES
YES
credulousness_negative
NO
YES
credulousness_positive
NO
YES
crime_police_topic
YES
YES
criminal_police_event_type
YES
NO
crossentities
YES
NO
currency
YES
YES
currency_amount_object
YES
YES
currency_purchasing_power
YES
YES
customer_type
YES
YES
cyber_action
YES
YES
cyber_action_attribute
YES
NO
cyber_active_defense
YES
NO
cyber_attack_attribute
YES
NO
cyber_attack_campaign
YES
NO
cyber_attack_motivation
YES
NO
cyber_attack_type
YES
YES
cyber_defense
YES
NO
cyber_defense_attribute
YES
NO
cyber_defense_authentification_method
YES
NO
cyber_defense_method
YES
YES
cyber_defense_strategy
YES
NO
cyber_defense_tool
YES
NO
cyber_defense_tool_checking_data
YES
NO
cyber_destruction
YES
NO
cyber_disruption
YES
NO
cyber_entity_type
YES
NO
cyber_event
YES
NO
cyber_expression
YES
YES
cyber_object
YES
NO
cyber_objective
YES
YES
cyber_offense
YES
NO
cyber_organisation
YES
NO
cyber_organisation_type
YES
YES
cyber_pre_emption
YES
NO
cyber_profession_type
YES
NO
cyber_target_attribute
YES
NO
cyber_target_object
YES
NO
cyber_target_type
YES
NO
cyber_topic
YES
YES
dashboard
YES
YES
dashboard_panels
YES
NO
date
YES
YES
date_entity
YES
YES
date_field
YES
YES
debt_financial_instrument
YES
YES
decisiveness_negative
NO
YES
decisiveness_positive
NO
YES
democracy_expression
YES
YES
determination_negative
NO
YES
determination_positive
NO
YES
digital_currency
YES
NO
dimension
YES
NO
diplomatic_facilities_pa
YES
NO
disgusting_pleasing_negative
NO
YES
disgusting_pleasing_positive
NO
YES
distance
YES
NO
distancing_from_infidels
NO
YES
document
NO
YES
document_topic
YES
YES
domain
YES
YES
drug_abuse_expression
NO
YES
drug_abuse_object
NO
YES
dune
YES
NO
duplicate_files
YES
YES
e_banking
YES
YES
economic_assessment_expression
NO
YES
economic_convergence
YES
YES
economic_crisis_type
YES
NO
economic_factors_for_assessment
YES
YES
economic_financial_event_type
YES
NO
economic_guideline_agreement
YES
YES
economic_object
YES
YES
economic_risk_attribute
YES
YES
economic_sector
YES
YES
economic_system_general_attribute
YES
YES
economic_trade_action
YES
YES
economy_expression
YES
YES
economy_finance_topic
YES
YES
economy_structure_system
YES
YES
education_event_type
YES
NO
education_expression
YES
YES
education_topic
YES
NO
efficacy_negative
NO
YES
efficacy_positive
NO
YES
electro_optic_system
YES
NO
eloquence_negative
NO
YES
eloquence_positive
NO
YES
email
YES
YES
emailid
YES
YES
emergency_response
YES
NO
emoji_emoticon
YES
NO
emotion
YES
YES
empathy_negative
NO
YES
empathy_positive
NO
YES
employer_misconduct_type
YES
YES
employment
YES
YES
employment_condition_change
YES
YES
employment_expression
YES
NO
employment_termination_cause
YES
NO
encouragement_deterrence_negative
NO
YES
encouragement_deterrence_positive
NO
YES
energy_issue
NO
YES
energy_object
NO
YES
energy_source
YES
YES
energy_topic
YES
YES
engineering_object_type
YES
NO
enhancement_of_economic_efficiency
YES
YES
entelligence_security_topic
YES
NO
entertainment_event_type
YES
NO
entertainment_organization_type
YES
YES
entertainment_sport_expression
YES
YES
entertainment_topic
YES
YES
enthusiasm_negative
NO
YES
enthusiasm_positive
NO
YES
entitiesmanage
YES
YES
entity
YES
NO
environment_expression
YES
YES
environment_topic
YES
NO
estate_residence
YES
YES
ethnicity
YES
YES
european_central_bank_ecb_organisation
YES
YES
european_central_bank_ecb_program
YES
YES
european_central_bank_governors
NO
YES
european_economic_organisation
YES
YES
european_organisation
YES
YES
european_system_of_central_banks
YES
YES
event
YES
YES
event_type
NO
YES
event_type_negative
NO
YES
event_type_positive
NO
YES
explosive_bomb_type
YES
YES
explosive_component_object
YES
YES
explosive_detonation_method
YES
YES
explosive_ied_topic
YES
YES
explosive_object
NO
YES
explosive_possible_identification
NO
YES
explosive_related_object
YES
NO
explosive_terrorist_related_weapon
YES
NO
exposure_expression
YES
YES
expression
NO
YES
facilitation_negative
NO
YES
facilitation_positive
NO
YES
facilities_palestine
YES
NO
family_tribe_relationship
YES
YES
famous_well_known_negative
NO
YES
famous_well_known_positive
NO
YES
fate_in_afterlife_negative
NO
YES
fate_in_afterlife_positive
NO
YES
favorite_count
YES
YES
fb_angry
YES
NO
fb_happy
YES
NO
fb_like
YES
NO
fb_love
YES
NO
fb_no_comment
YES
NO
fb_page
YES
NO
fb_sad
YES
NO
fb_shared
YES
NO
fb_wow
YES
NO
file_author
YES
YES
file_format
YES
YES
file_report_settings
YES
NO
file_type
YES
YES
files
YES
YES
filetags
YES
YES
filter_passed_rule_country_code
YES
YES
filter_passed_rule_egyptian_twitter
NO
YES
filter_passed_rule_location
YES
YES
filter_passed_rule_time_zone
YES
YES
filter_settings
YES
NO
financial_corruption_expression
YES
YES
financial_crisis
YES
NO
financial_evaluation_expression
NO
YES
financial_expression
YES
YES
financial_legal_expression
YES
YES
financial_market_negative_sentiment_indicator
YES
YES
financial_market_positive_sentiment_indicator
YES
YES
financial_object
NO
YES
financial_ontology_action
NO
YES
financial_ontology_concept
NO
YES
financial_sector_indicator
YES
YES
financial_status_expression
YES
YES
financial_time_frame_expression
YES
YES
finchpageid
YES
NO
fiscal_policy
YES
YES
flexibility_negative
YES
YES
flexibility_positive
NO
YES
focusness_negative
NO
YES
focusness_positive
NO
YES
foldertree
YES
YES
food_culinary_topic
YES
NO
food_object
YES
YES
foreign_debt
YES
YES
foreign_exchange_forex
YES
YES
forex
YES
YES
forgiveness_negative
NO
YES
forgiveness_positive
NO
YES
form
YES
NO
frankness_negative
NO
YES
frankness_positive
NO
YES
freedom_negative
NO
YES
freedom_positive
NO
YES
friendliness_negative
NO
YES
friendliness_positive
NO
YES
friendship_acquaintance
YES
YES
from_field
YES
YES
frugality_negative
NO
YES
frugality_positive
NO
YES
full_address
YES
NO
functional_location
YES
NO
future_time_duration
YES
YES
games_and_simulation
YES
NO
gardens_palestine
YES
NO
gasoline_prices
YES
YES
gaza_hamas_israel_cease_fire
YES
NO
gaza_metro
YES
NO
gaza_topic
YES
NO
gender_equality
YES
NO
general_event_type
YES
NO
general_mod_words
YES
NO
generic_anti_object_indicator
NO
YES
generic_goodness_negative
NO
YES
generic_goodness_positive
NO
YES
generic_organizational_object
YES
YES
generic_positive_object_indicator
NO
YES
generic_religious_expression
YES
YES
generic_sentiment_indicator_type
YES
YES
generosity_negative
NO
YES
generosity_positive
NO
YES
geographic_sub_region
YES
YES
geographical_sub_region
NO
YES
governance_expression
YES
YES
government_cyber_organisation
YES
NO
government_ministries_palestine
YES
NO
governmental_organization
NO
YES
grandparent_id
YES
YES
gratefulness_negative
NO
YES
gratefulness_positive
NO
YES
ground_force_military_object_type
YES
YES
group_cyber_type
YES
NO
groups_table
YES
NO
hadith
YES
YES
hadith_collection
YES
NO
hadith_verse
YES
YES
hamas_military_units
YES
NO
hamdillah_component
YES
YES
happiness_negative
NO
YES
happiness_positive
NO
YES
haredi_israeli_political_party
YES
NO
harvesting_task_id
YES
NO
harvesting_time
YES
NO
harvesting_type
YES
NO
health_facilities_palestine
YES
NO
healthy_negative
NO
YES
healthy_positive
NO
YES
hide_entities
YES
NO
highest_position_tier
YES
YES
hill
YES
NO
hills_palestine
YES
NO
historic_group
YES
YES
historic_military_event
YES
YES
historical_sites_palestine
YES
NO
holy_place
YES
YES
honesty_negative
NO
YES
honesty_positive
NO
YES
hospitals_palestine
YES
NO
hostage_taking
YES
NO
hotels_palestine
YES
NO
housing_developments_palestine
YES
NO
human_body_part
NO
YES
human_convention_event_type
YES
NO
human_life_event_type
YES
NO
human_life_support_action
YES
YES
human_nature_expression
YES
YES
humanitarian_aid_expression
YES
NO
humanitarian_organization
NO
YES
humility_negative
NO
YES
humility_positive
NO
YES
humour_negative
NO
YES
humour_positive
NO
YES
iban_account
YES
NO
icl_component
YES
NO
ict_services
YES
NO
ideological_stream
YES
YES
idf_air_defense_system
YES
NO
idf_air_force_acquisition_unit
YES
NO
idf_air_force_drone_type
YES
NO
idf_air_force_drone_unit
YES
NO
idf_air_force_unit
YES
NO
idf_air_force_unit_air_control
YES
NO
idf_air_force_unit_air_control_unit
YES
NO
idf_air_force_unit_air_defense
YES
NO
idf_air_force_unit_attack_helicopter
YES
NO
idf_air_force_units_air_control_units
YES
NO
idf_air_force_units_hq_technological_unit
YES
NO
idf_army_acquisiton_body
YES
NO
idf_army_acquisiton_body_personal_supplies
YES
NO
idf_army_ground_forces_unit
YES
NO
idf_cyber_unit
YES
NO
idf_general_acronym
YES
NO
idf_ground_force_unit
YES
NO
idf_ground_forces_units
YES
NO
idf_imod_acquisition_body
YES
NO
idf_intelligence_unit
YES
NO
idf_intelligence_units
YES
NO
idf_naval_vessel_landing_craft
YES
NO
idf_naval_vessel_missile_boat_model
YES
NO
idf_naval_vessel_submarine
YES
NO
idf_navy_acquistion_body
YES
NO
idf_navy_base
YES
NO
idf_navy_coast_guard_unit
YES
NO
idf_navy_coast_guard_vessel_model
YES
NO
idf_navy_headquarters_unit
YES
NO
idf_navy_logistic_unit
YES
NO
idf_navy_submarine_unit
YES
NO
idf_navy_surface_vessel_unit
YES
NO
idf_navy_underwater_operations_unit
YES
NO
idf_navy_unit
YES
NO
idf_purchasing_body_army
YES
NO
idf_purchasing_body_body_personal_supplies
YES
NO
idf_purchasing_body_intelligence
YES
NO
idf_purchasing_body_medical
YES
NO
idf_purchasing_body_mod
YES
NO
idf_purchasing_body_signal
YES
NO
idf_signal_units
YES
NO
idf_units
YES
NO
idf_units_ground_forces_technological_development
YES
NO
impartiality_negative
NO
YES
impartiality_positive
NO
YES
importance_negative
NO
YES
importance_positive
NO
YES
impression_negative
NO
YES
impression_positive
NO
YES
improvement_degrading_negative
NO
YES
improvement_degrading_positive
NO
YES
improvement_expectation_expression
NO
YES
incomprehensible
NO
YES
independence_negative
NO
YES
independence_positive
NO
YES
individual_cyber_type
YES
NO
industriousness_negative
NO
YES
industriousness_positive
NO
YES
inflation
YES
YES
information_and_communication_technology
YES
NO
information_support_and_services_networking
YES
NO
information_transfer_action
YES
YES
infrastructure_palestine
YES
NO
inheritance_expression
YES
YES
innocence_negative
NO
YES
innocence_positive
NO
YES
insurance_expression
YES
YES
integer_quantity_number_object
YES
YES
integrity_wholeness_negative
NO
YES
integrity_wholeness_positive
NO
YES
intelligence_malaysia_expression
YES
NO
intelligence_negative
NO
YES
intelligence_positive
NO
YES
intelligence_security_expression
YES
YES
intelligence_security_topic
YES
YES
intelligence_usa_expression
YES
NO
inter_entity_relationship
YES
YES
inter_personal_affection_action
YES
YES
inter_personal_traits
YES
YES
interest_expression
YES
YES
interestedness_negative
NO
YES
interestedness_positive
NO
YES
international_economic_guideline_agreement
YES
YES
international_organisation
NO
YES
international_organization
YES
YES
international_person_involved_in_lebanon
YES
NO
international_relations_expression
YES
YES
international_relations_topic
YES
YES
internet_technology_action
YES
YES
investment
NO
YES
investments_expression
YES
YES
involvement_negative
NO
YES
involvement_positive
NO
YES
iranian_proxy
YES
NO
islam_topic
YES
YES
islamic_expression
NO
YES
islamic_finance_expression
YES
YES
islamic_government
YES
YES
islamic_historic_battle
YES
YES
islamic_holiday
YES
YES
islamic_human_honorific
YES
YES
islamic_legendary_historic_event
YES
YES
islamic_moderate_stream
YES
YES
islamic_principle_belief
YES
YES
islamic_punishment
YES
YES
islamic_radical_stream
YES
YES
islamic_religious_action
YES
YES
islamic_sect
YES
YES
islamic_source_object
YES
YES
islamic_theological_expression
YES
YES
israel_defense_industry
YES
NO
israel_military_expression
YES
NO
israel_military_industry
YES
NO
israel_mod_mafat_unit
YES
NO
israel_mod_strategic_division
YES
NO
israel_mod_unit
YES
NO
israel_negative_reference_opposition
YES
NO
israel_negative_sentiment_netanyahu_coalition
YES
NO
israel_teleprocessing_corps
YES
NO
israeli_air_force
YES
NO
israeli_anti_legal_reform_slogan
YES
NO
israeli_arab_political_party
YES
NO
israeli_arab_political_person
YES
NO
israeli_coalition_2023
YES
NO
israeli_contemporary_political_person
YES
NO
israeli_domestic_political_expression
YES
NO
israeli_domestic_politics_topic
YES
NO
israeli_government_organization
YES
NO
israeli_ground_forces
YES
NO
israeli_haredi_political_person
YES
NO
israeli_ideological_stream
YES
NO
israeli_intelligence_community
YES
NO
israeli_internal_security_expression
YES
NO
israeli_left_center_wing_political_expression
YES
NO
israeli_legal_establishment_person
YES
NO
israeli_legal_reform_expression
YES
NO
israeli_legal_reform_revolution_negative_expression
YES
NO
israeli_legal_reform_revolution_positive_expression
YES
NO
israeli_military_intelligence_aman
YES
NO
israeli_ministry_of_defense_imod
YES
NO
israeli_ministry_of_defense_sibat_unit
YES
NO
israeli_mod_units
YES
NO
israeli_national_economy
YES
NO
israeli_national_security
YES
NO
israeli_navy
YES
NO
israeli_negative_sentiment_specific_entity
YES
NO
israeli_political_organization
YES
NO
israeli_politics_applications
YES
NO
israeli_positive_reference_specific_entity
YES
NO
israeli_right_wing_political_expression
YES
NO
israeli_wars
YES
NO
israels_ministry_of_defense
YES
NO
it_consulting
YES
NO
jealousy_negative
NO
YES
jealousy_positive
NO
YES
jihad
YES
YES
jihad_action
YES
YES
jihad_exhortation_expression
NO
YES
jihad_type
NO
YES
jihadi_media_producer
YES
YES
jurisprudence_action
YES
YES
jurisprudence_attitude
YES
YES
jurisprudence_expression
YES
YES
just_negative
NO
YES
just_positive
NO
YES
justification_for_jihad
NO
YES
kbs_sector
YES
NO
khomeinist_expression
NO
YES
kindness_negative
NO
YES
kindness_positive
NO
YES
koran
YES
YES
lang
YES
YES
language_object
YES
YES
languages
YES
YES
law_abiding_negative
NO
YES
law_abiding_positive
NO
YES
law_court_person_type
YES
YES
law_enforcement_expression
NO
YES
law_enforcement_topic
YES
YES
leadership_negative
NO
YES
leadership_positive
NO
YES
lebanese_bank_leadership_topic
YES
NO
lebanese_black_market_topic
YES
NO
lebanese_central_bank_topic
YES
NO
lebanese_christian_community_topic
YES
NO
lebanese_civil_war_topic
YES
NO
lebanese_contemporary_political_person
YES
NO
lebanese_currency_devaluation_topic
YES
NO
lebanese_domestic_political_expression
YES
NO
lebanese_domestic_politics_topic
YES
NO
lebanese_economic_crisis_topic
YES
NO
lebanese_gas_topic
YES
NO
lebanese_international_aid_topic
YES
NO
lebanese_international_relations_topic
YES
NO
lebanese_international_relations_topic_concept
YES
NO
lebanese_iranian_relations_topic
YES
NO
lebanese_political_organization
YES
NO
lebanese_political_vacuum_presidency_topic
YES
NO
lebanese_refugee_topic
YES
NO
lebanese_sectarianism_issue_topic
YES
NO
lebanese_shiite_community_topic
YES
NO
lebanese_social_unrest_lebanon
YES
NO
lebanese_social_unrest_topic
YES
NO
lebanese_syrian_relations_topic
YES
NO
lebanon_israel_cease_fire
YES
NO
left_wing_israeli_political_party
YES
NO
left_wing_israeli_political_person
YES
NO
left_wing_radical_western_organization
YES
NO
left_wing_western_radical_ideology
YES
NO
legal_action
YES
YES
legal_document
YES
YES
legal_event
YES
YES
legal_expression
YES
YES
legal_object
YES
YES
legal_offence
YES
YES
legal_organisation_type
YES
YES
legal_ruling
YES
YES
legal_school
YES
YES
legal_topic
YES
NO
legendary_historic_event
NO
YES
legendary_person
YES
YES
level
YES
NO
levelheadness_negative
NO
YES
levelheadness_positive
NO
YES
liberal_dictatorial_negative
NO
YES
liberal_dictatorial_positive
NO
YES
liquidity
YES
YES
living_non_human_animal
YES
YES
loans_expression
YES
YES
lockedfiles
YES
YES
logistic_military_object_type
YES
NO
lowest_position_tier
YES
YES
loyalty_negative
NO
YES
loyalty_positive
NO
YES
luck_negative
NO
YES
luck_positive
NO
YES
macroeconomic_country_economy_classification
YES
YES
macroeconomic_indicator
YES
YES
macroeconomic_lever
YES
YES
macroeconomic_measuring_tool
YES
YES
macroeconomic_national_economy_characterisation
NO
YES
macroeconomic_policy_strategy
YES
YES
macroeconomic_transparency
YES
YES
main_work_number
YES
NO
major_radical_literature
YES
YES
malaysian_political_party
YES
NO
malaysian_political_person
YES
NO
marketing_expression
YES
YES
markets_palestine
YES
NO
mashov_miluli
YES
NO
mass_violence_event_type
YES
NO
mathematics_logic_topic
YES
NO
maturity_negative
NO
YES
maturity_positive
NO
YES
measurement
YES
YES
media_object
YES
YES
media_sites_palestine
YES
NO
medical_action
YES
YES
medical_domain
YES
YES
medical_expression
YES
YES
medical_object
NO
YES
medical_organisation_type
YES
YES
medical_organization
YES
NO
medical_topic
YES
YES
medical_treatment_object
YES
YES
medium_position_tier
YES
YES
mental_intellectual_trait
YES
YES
metadata
YES
YES
meticulousness_negative
NO
YES
meticulousness_positive
NO
YES
middle_eastern_islamic_political_party
NO
YES
military_action
YES
YES
military_balance_negative
NO
YES
military_balance_positive
NO
YES
military_event_type
YES
NO
military_intelligence_equipment_type
YES
NO
military_ordnance
YES
NO
military_ordnance_object
YES
YES
military_ordnance_type
NO
YES
military_organization
NO
YES
military_organization_type
YES
YES
military_person_type
YES
NO
military_strategic_expression
YES
YES
military_topic
YES
YES
military_unit
YES
NO
military_vehicle_type
YES
NO
missile_military_object
NO
YES
missile_military_object_type
YES
NO
mod_purchasing_body_medical
YES
NO
moderate_duty
NO
YES
moderate_expression
YES
YES
moderate_jihad_expression
NO
YES
moderate_name_of_prophet
NO
YES
moderate_term_for_non_muslims
NO
YES
modernity_progressiveness_negative
NO
YES
modernity_progressiveness_positive
NO
YES
modesty_negative
NO
YES
modesty_positive
NO
YES
monasteries_palestine
YES
NO
monetary_policy
YES
YES
moral_traits
YES
YES
morality_negative
NO
YES
morality_positive
NO
YES
mortgage_expression
YES
YES
mosques_palestine
YES
NO
motion
YES
NO
motivation_positive
YES
NO
movement_pace_speed_expression
YES
NO
muhammad_as_strong
NO
YES
muhammad_as_wise
NO
YES
museums_palestine
YES
NO
muslim_collective_self_definition
YES
YES
muslim_convert_expression
YES
YES
muslim_land_definition
YES
YES
mutex
NO
YES
myguests
NO
YES
mythical_place_object
YES
YES
name_alternatives
YES
YES
name_of_allah
YES
YES
name_of_prophet
YES
YES
named_entity_document
YES
YES
named_entity_group
YES
YES
named_entity_organization
NO
YES
named_entity_place
NO
YES
narcotics_topic
YES
NO
narcotics_trade_action
YES
YES
national_debt_income_ratio
YES
YES
national_economy_expression
YES
YES
national_identity
YES
YES
national_market_type
NO
YES
nationality_citizenship
YES
NO
natural_disaster_event_type
YES
NO
natural_terrain_place_object
YES
YES
nature_of_islam_expression
YES
YES
nature_of_koran_expression
YES
YES
naval_military_object
YES
YES
naval_military_object_type
YES
NO
nc_additional_info
YES
YES
necessity_negative
NO
YES
necessity_positive
NO
YES
negative_collective_sentiment_indicator
NO
YES
negative_personal_character_expression
NO
YES
negative_sentiment_indicator
NO
YES
negative_superlative
NO
YES
negative_transitive_sentiment
NO
YES
negative_volition_act
NO
YES
neighborhood_quarter
YES
YES
neighborhoods_palestine
YES
NO
netanyahu_trial_case_issue
YES
NO
network
YES
NO
noise
YES
NO
non_animated_object
YES
YES
non_islamic_historic_reference
YES
YES
non_national_economy_influencing_factor
YES
YES
non_person_sentiment_indicator
YES
YES
normality_negative
NO
YES
normality_positive
NO
YES
notice_number
YES
NO
obedience_negative
NO
YES
obedience_positive
NO
YES
object
NO
YES
online_commerce_expression
YES
YES
operation_type
YES
NO
opposition_party_2023
YES
NO
optimism_negative
NO
YES
optimism_positive
NO
YES
order_number
YES
NO
organised_chaotic_negative
NO
YES
organised_chaotic_positive
NO
YES
organization_type
YES
NO
organizational_culture
YES
NO
organizational_identity
YES
YES
organizational_positive_object_indicator
NO
YES
organizational_unit
YES
YES
orig_key
YES
NO
outside_opportunity
YES
NO
parent_tables
YES
YES
parking_lots_palestine
YES
NO
parks_palestine
YES
NO
passive_attack
YES
NO
passive_cyber_defense
YES
NO
passive_intrusion_detection_system
YES
NO
past_duration
YES
YES
patriotism_positive
YES
NO
peaceful_vs_violent_negative
NO
YES
percentage_amount_object
YES
YES
perfection_negative
NO
YES
perfection_positive
NO
YES
permissivity_negative
NO
YES
permissivity_positive
NO
YES
persistence_negative
NO
YES
persistence_positive
NO
YES
person_object
YES
YES
personal_affairs_care
YES
NO
personality_traits
YES
YES
personnel_management
YES
NO
persons_isl
YES
NO
photos
YES
NO
phrases
YES
YES
physical_address
NO
YES
physical_attribute
YES
NO
physical_attribute_expression
YES
YES
physical_procedure_action
YES
YES
physical_science_expression
YES
YES
physical_science_topic
YES
NO
physical_state_attribute
YES
NO
physical_traits
YES
YES
piety_expression
YES
YES
place_country
YES
YES
place_country_code
YES
YES
place_full_name
YES
YES
place_object
YES
YES
pleasure_negative
NO
YES
police_stations_palestine
YES
NO
political_event_type
YES
NO
political_expression
YES
YES
political_organisation_type
YES
YES
political_trait
YES
YES
political_trait_negative
NO
YES
political_trait_positive
NO
YES
political_traits
NO
YES
politics_topic
YES
YES
pools_palestine
YES
NO
population_centers_palestine
YES
NO
port_of_beirut_explosion
YES
NO
positive_collective_sentiment_indicator
NO
YES
positive_object_indicator
YES
YES
positive_or_negative_event_type
YES
YES
positive_personal_affection_action
NO
YES
positive_personal_efficacy_indicator
NO
YES
positive_personal_intelligence_expression
NO
YES
positive_reference_netanyahu
YES
NO
positive_reference_specific_entity
NO
YES
positive_sentiment_indicator
NO
YES
positivity_negative
NO
YES
positivity_positive
NO
YES
post_attachments
YES
NO
post_creation_time
YES
NO
post_id
YES
NO
post_office_pa
YES
NO
post_url
YES
NO
power_stations_pa
YES
NO
practicality_negative
NO
YES
practicality_positive
NO
YES
pragmatism_negative
NO
YES
pragmatism_positive
NO
YES
praise_denounce_negative
NO
YES
praise_denounce_positive
NO
YES
praiseworthy_negative
NO
YES
praiseworthy_positive
NO
YES
predmodel
YES
NO
present_time_duration
YES
YES
pretensiosity_negative
NO
YES
pretensiosity_positive
NO
YES
prevalence
YES
NO
price
YES
YES
pride_negative
NO
YES
pride_positive
NO
YES
priority
YES
NO
prison
YES
NO
pro
YES
YES
pro_concept
YES
YES
pro_instance
YES
YES
pro_person_nickname
NO
YES
pro_specific_collective_indicator
NO
YES
proactive_vs_reactive_negative
NO
YES
proactive_vs_reactive_positive
NO
YES
productivity
YES
YES
professional_person_type
YES
YES
professional_rank
YES
NO
professionalism_negative
YES
NO
proportionate_negative
NO
YES
proportionate_positive
NO
YES
proselytization_dawah_expression
YES
YES
province
YES
YES
psychological_influence_operations
YES
NO
public_safety_topic
YES
NO
publisher_id
YES
NO
punctuality_negative
NO
YES
punctuality_positive
NO
YES
purchase_repurchase_lever
YES
YES
qualifier_intensifier
YES
YES
qualifier_moderater
YES
YES
quantity
YES
NO
quanttity_negative
NO
YES
quote_count
YES
YES
radical_attitude_legal_status_non_muslim_in_dar_islam
NO
YES
radical_expression_non_muslim_land
NO
YES
radical_expression_re_non_muslim
YES
YES
radical_islam_topic
YES
NO
radical_islamic_expression
YES
YES
radical_islamic_slogan
YES
NO
radical_name_of_allah
YES
YES
radical_name_of_prophet
YES
YES
radical_non_muslim_trait
NO
YES
radical_permitted_action_expression
YES
YES
radical_self_image_expression
YES
YES
radical_slogan
YES
YES
radical_term_for_non_muslim
NO
YES
railroads_palestine
YES
NO
rama_irgunit
YES
NO
rationality_negative
NO
YES
rationality_positive
NO
YES
reactions_count
YES
NO
reactors
YES
NO
realism_negative
NO
YES
realism_positive
NO
YES
rebellion_against_allah
NO
YES
recruitment
YES
NO
reformist_expression
NO
YES
refugee_camp
YES
NO
refugee_camps_pa
YES
NO
refugee_camps_palestine
YES
NO
refugee_person_type
YES
NO
regex
YES
YES
regime_legitimacy_negative
NO
YES
region
YES
YES
regulatory_precondition
YES
YES
relation
NO
YES
relation_id
YES
NO
relation_type
YES
NO
relationship_type
YES
YES
reliability_negative
NO
YES
reliability_positive
NO
YES
religion_and_state
YES
NO
religion_topic
YES
YES
religious_ethnic_identity
YES
YES
religious_event_type
YES
NO
religiously_orthodox_negative
NO
YES
religiously_orthodox_positive
NO
YES
repentance_expression
YES
YES
reply_count
YES
YES
report_settings
YES
NO
reporter
YES
NO
reshares
YES
NO
resorts_palestine
YES
NO
respect_dead_person_honorific
NO
YES
respectfulness_negative
NO
YES
respectfulness_positive
NO
YES
respectibility_negative
NO
YES
respectibility_positive
NO
YES
responsibility_negative
NO
YES
responsibility_positive
NO
YES
responsiveness_negative
NO
YES
responsiveness_positive
NO
YES
result_of_cyber_attack
YES
NO
retweet_count
YES
YES
retweeted_favorite_count
YES
YES
retweeted_id
YES
YES
retweeted_quote_count
YES
YES
retweeted_reply_count
YES
YES
retweeted_retweet_count
YES
YES
retweeted_user_screen_name
YES
YES
richness_negative
NO
YES
richness_positive
NO
YES
right_wing_israeli_political_party
YES
NO
right_wing_israeli_political_person
YES
NO
right_wing_radical_western_organization
YES
NO
right_wing_western_radical_ideology
YES
NO
right_wrong_negative
NO
YES
right_wrong_positive
NO
YES
ritual_expression
YES
YES
road
YES
YES
road_junctions_palestine
YES
NO
roads_palestine
YES
NO
ruin
YES
YES
ruins_palestine
YES
NO
safety_negative
NO
YES
safety_positive
NO
YES
sanity_negative
NO
YES
sanity_positive
NO
YES
satisfaction_negative
NO
YES
satisfaction_positive
NO
YES
saudi_civil_rights_expression
NO
YES
saudi_economic_expression
YES
YES
saudi_expression
YES
YES
saudi_political_expression
YES
YES
saudi_religious_expression
YES
YES
saudi_royal_person
YES
YES
saudi_social_expression
NO
YES
saudi_sports_expression
YES
YES
saudi_women_rights_expression
NO
YES
savedsearch
YES
YES
savedsearchid
YES
YES
savings
YES
YES
search
YES
YES
season_event_type
YES
NO
secular_ideological_stream
YES
YES
securities_expression
YES
YES
securities_leverage
YES
YES
self_confidence_negative
NO
YES
self_confidence_positive
NO
YES
self_identification_negative
NO
YES
self_identification_positive
NO
YES
selflessness_negative
NO
YES
selflessness_positive
NO
YES
semantic_indicator
NO
YES
senddoc_file_id
YES
YES
sensitivity_negative
NO
YES
sensitivity_positive
NO
YES
sentiment_indicator_type
YES
YES
separation_of_clients
YES
YES
seriousness_negative
NO
YES
seriousness_positive
NO
YES
service_conditions
YES
NO
service_shortfalls
YES
NO
settlement_lever
YES
YES
sewage_treatment_plant
YES
NO
sexual_reference_negative
NO
YES
sexual_reference_positive
NO
YES
share_count
YES
NO
sheela
YES
NO
sheela_num
YES
NO
shiite_expression
YES
YES
shiite_sacred_text
YES
YES
shiite_theological_expression
YES
YES
simple_action
YES
YES
sin
YES
YES
sincerity_negative
NO
YES
sincerity_positive
NO
YES
site
NO
YES
size
YES
YES
slotdata
YES
YES
small_arm_weapon_type
YES
NO
social_framework_organization_type
YES
YES
social_issues_topic
YES
YES
social_media_applications
YES
YES
social_network
YES
NO
social_networking_capability_negative
NO
YES
social_networking_capability_positive
NO
YES
social_political_event_type
YES
NO
social_political_phenomenon_negative
NO
YES
social_political_phenomenon_positive
NO
YES
social_status_traits
YES
YES
social_unrest_topic
YES
YES
software_and_systems_development
YES
NO
sophistication_vs_naivite_negative
NO
YES
sophistication_vs_naivite_positive
NO
YES
space_expression
YES
NO
special_koran_verse_allusion
YES
NO
specific_disincentivizing_factor
YES
NO
specific_entity_oriented_sentiment
YES
YES
specific_incentivizing_factor
YES
NO
speed_fast_slow_negative
NO
YES
speed_fast_slow_positive
NO
YES
sport_event_type
YES
YES
sport_organisation_type
YES
YES
sport_topic
YES
YES
sports_person
YES
YES
sports_place
YES
YES
sports_title
YES
YES
squares_palestine
YES
NO
stability_negative
NO
YES
stability_positive
NO
YES
stadiums_palestine
YES
NO
startdatetime
YES
NO
state_entity_proxy_cyber_group
YES
NO
stock_exchange_analyst_expression
YES
YES
stock_exchange_expression
YES
YES
stock_prognosis_positive
NO
YES
strength_negative
NO
YES
strength_of_legal_claim_expression
YES
YES
strength_positive
NO
YES
sub_relations
YES
NO
sub_tables
YES
YES
subject_field
YES
YES
subject_title
YES
NO
successfullness_negative
NO
YES
successfullness_positive
NO
YES
sug_sotz
YES
NO
suitability_negative
NO
YES
suitability_positive
NO
YES
sunni_idiom
YES
YES
sunni_sacred_text
YES
YES
supervision_action
YES
NO
supply_and_demand
YES
YES
support_negative
NO
YES
support_positive
NO
YES
sura
YES
NO
surprise_negative
NO
YES
surprise_positive
NO
YES
swift_code
YES
NO
system_settings
YES
NO
t_age
YES
YES
t_author_id
YES
YES
t_author_tags
YES
YES
t_city
YES
YES
t_conversation
YES
YES
t_country
YES
YES
t_ethnicities
YES
YES
t_gender
YES
YES
t_hashtag
YES
YES
t_id
YES
YES
t_language
YES
YES
t_members
YES
YES
t_mention
YES
YES
t_network
YES
YES
t_parent_id
YES
YES
t_post_interactions
YES
YES
t_publish_date
YES
YES
t_relevancy_reason
YES
YES
t_score
YES
YES
t_sentiment
YES
YES
t_state
YES
YES
t_tags
YES
YES
t_total_interactions
YES
YES
t_type
YES
YES
t_username
YES
NO
t_workflow_stage
YES
YES
tact_negative
NO
YES
tact_positive
NO
YES
takfir
YES
YES
tasty_negative
NO
YES
tasty_positive
NO
YES
taxes_expression
YES
YES
technological_domains
YES
NO
technology_it_topic
YES
YES
telephone_number
YES
YES
temperature
YES
NO
terrorism_topic
YES
YES
terrorist_cyber_organisation
YES
NO
terrorist_organization
NO
YES
test
NO
YES
teur_sheela
YES
NO
threat_rating
YES
YES
thriftiness_negative
NO
YES
thriftiness_positive
NO
YES
time
YES
NO
time_entity
YES
YES
time_number_object
YES
YES
time_pace
YES
YES
title
YES
YES
to_field
YES
YES
tolerance_negative
NO
YES
tolerance_positive
NO
YES
tombs_palestine
YES
NO
topic
YES
YES
tourism_topic
YES
NO
trade_balance
YES
YES
trade_deficit
NO
YES
tradeable_market_instrument_expression
YES
YES
training_and_enrichment
YES
NO
transportation_actors
YES
NO
transportation_carriers
YES
NO
transportation_freight
YES
NO
transportation_legislation
YES
NO
transportation_means
YES
NO
transportation_parking
YES
NO
transportation_problems
YES
NO
transportation_public
YES
NO
transportation_road_elements
YES
NO
transportation_route
YES
NO
transportation_safety_measures
YES
NO
transportation_solutions
YES
NO
transportation_traffic_topic
YES
NO
tribal_areas_palestine
YES
NO
trusting_negative
NO
YES
trusting_positive
NO
YES
truthfulness_negative
NO
YES
truthfulness_positive
NO
YES
tv_parent_author
NO
YES
tweet_likes
YES
NO
tweet_shares
YES
NO
tweet_user_url
YES
NO
twitter_hashtag
YES
YES
twitter_place
YES
NO
twitter_user_name
YES
YES
un_resolution_1701
YES
NO
unique_files
YES
YES
unity_vs_factionism_negative
NO
YES
unknowing
NO
YES
upgrade_downgrade_negative
NO
YES
upgrade_downgrade_positive
NO
YES
url
YES
YES
us_political_organization
YES
NO
userCake_Users
YES
NO
user_created_at
YES
YES
user_description
YES
YES
user_favourites_count
YES
YES
user_followers_count
YES
YES
user_friends_count
YES
YES
user_geo_enabled
YES
YES
user_id_str
YES
YES
user_lang
YES
YES
user_listed_count
YES
YES
user_location
YES
YES
user_location_ont
YES
NO
user_screen_name
YES
YES
user_settings
YES
NO
user_status
YES
YES
user_statuses_count
YES
YES
user_time_zone
YES
YES
user_translator_type
YES
YES
user_url
YES
YES
user_utc_offset
YES
YES
usercake_users
NO
YES
users_time_log
NO
YES
utensil_object
NO
YES
validity_negative
NO
YES
validity_positive
NO
YES
vehicle_object
NO
YES
violence_proneness_positive
NO
YES
violence_topic
YES
NO
violent_action
YES
YES
virtuous_trait_honorific
NO
YES
vitality_negative
NO
YES
vitality_positive
NO
YES
volition_expression
YES
YES
vulnerability_exploited_in_cyber_attack
YES
NO
wadi_palestine
YES
NO
water_pumping_stations_pa
YES
NO
wealth_gap
YES
YES
weapons_mass_destruction
NO
YES
weather_topic
YES
NO
website
YES
YES
website_attachments
YES
NO
weight_amount_object
YES
YES
wells_palestine
YES
NO
western_ideological_streams
YES
YES
wireless_technology
YES
NO
work_environment
YES
NO
work_place_relationship_type
YES
YES
yearning_missing_vs_no_missing_negative
NO
YES
yearning_missing_vs_no_missing_positive
NO
YES
zealotry_negative
NO
YES
zealotry_positive
NO
YES
zoomorphic_comparison_negative
NO
YES
Push to database
Export to disk
Revisions
Revision ID
3
Save file
8_2_21_crossentities.sql
CREATE TABLE IF NOT EXISTS crossentities( entity varchar(150), orgConcept varchar(150), destConcept varchar(150), PRIMARY KEY (entity,orgConcept));
2
Save file
4_1_21_add_topic_tables.sql
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ /** * Author: gal */ RENAME TABLE physical_address TO full_address; ALTER TABLE concepts_indexes DROP PRIMARY KEY, ADD PRIMARY KEY(id, concept); INSERT INTO `concepts_indexes` (concept) VALUES('tourism_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `tourism_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='tourism_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('social_unrest_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `social_unrest_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='social_unrest_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('transportation_traffic_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `transportation_traffic_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='transportation_traffic_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('weather_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `weather_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='weather_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('social_issues_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `social_issues_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='social_issues_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('social_unrest_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `social_unrest_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='social_unrest_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('sport_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `sport_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='sport_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('technology_it_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `technology_it_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='technology_it_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('terrorism_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `terrorism_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='terrorism_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('physical_science_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `physical_science_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='physical_science_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('politics_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `politics_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='politics_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('public_safety_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `public_safety_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='public_safety_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('radical_islam_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `radical_islam_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='radical_islam_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('religion_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `religion_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='religion_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('islam_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `islam_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='islam_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('legal_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `legal_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='legal_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('mathematics_logic_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `mathematics_logic_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='mathematics_logic_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('medical_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `medical_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='medical_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('military_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `military_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='military_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('entertainment_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `entertainment_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='entertainment_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('environment_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `environment_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='environment_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('explosive_ied_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `explosive_ied_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='explosive_ied_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('food_culinary_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `food_culinary_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='food_culinary_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('intelligence_security_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `intelligence_security_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='intelligence_security_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('banking_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `banking_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='banking_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('crime_police_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `crime_police_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='crime_police_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('cyber_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `cyber_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='cyber_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('economy_finance_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `economy_finance_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='economy_finance_topic'))); INSERT INTO `concepts_indexes` (concept) VALUES('energy_topic'); CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `energy_topic` AS ( SELECT `all_concepts_table`.`id` AS `id`, `all_concepts_table`.`docId` AS `docId`, `all_concepts_table`.`name_version` AS `name_version`, `all_concepts_table`.`names_agg` AS `names_agg`, `all_concepts_table`.`clean_name` AS `clean_name`, `all_concepts_table`.`ontName` AS `ontName`, `all_concepts_table`.`ontUrl` AS `ontUrl`, `all_concepts_table`.`docKey` AS `docKey`, `all_concepts_table`.`date` AS `date`, `all_concepts_table`.`modifier` AS `modifier`, `all_concepts_table`.`country` AS `country`, `all_concepts_table`.`province` AS `province`, `all_concepts_table`.`city` AS `city`, `all_concepts_table`.`anti` AS `anti`, `all_concepts_table`.`pro` AS `pro`, `all_concepts_table`.`username` AS `username`, `all_concepts_table`.`occurrences` AS `occurrences`, `all_concepts_table`.`positive` AS `positive`, `all_concepts_table`.`negative` AS `negative`, `all_concepts_table`.`orgText_version` AS `orgText_version`, `all_concepts_table`.`type` AS `type`, `all_concepts_table`.`concept_type` AS `concept_type`, `all_concepts_table`.`concept_type_source` AS `concept_type_source`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`name_version`) AS `name`, COALESCE(`all_concepts_table`.`names_agg`,`all_concepts_table`.`orgText_version`) AS `orgText` FROM `all_concepts_table` WHERE (`all_concepts_table`.`concept_type` = (SELECT id FROM concepts_indexes WHERE concept='energy_topic')));
1
Save file
231220_groups_table_add_col.sql
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ /** * Author: gal */ ALTER TABLE groups ADD COLUMN group_id int AFTER name; UPDATE `groups` SET group_id=0 WHERE NAME="admin"; UPDATE `groups` SET group_id=1 WHERE NAME="private"; UPDATE `groups` SET group_id=2 WHERE NAME="viewer"; UPDATE `groups` SET group_id=3 WHERE NAME="contributor";