#   createindexes-stateCA-mysql.sql
#   mysql script to create the indexes (helps with JOIN's and searches)
#   n6lhv@arrl.net (Wayne Smith)
#   created:  8-August-2004
#   updated:  17-June-2005



#   Display the MySQL version
SELECT version();



#   Manage the database
USE uls



#   Create all of indexes for the master table ("view")
ALTER TABLE tblGeoStateCA
      ADD INDEX (frequency_assigned),
      ADD INDEX (call_sign),
      ADD INDEX (radio_service_code),
      ADD INDEX (class_station_code),
      ADD INDEX (location_county),
      ADD INDEX (location_city),
      ADD INDEX (location_address),
      ADD INDEX (entity_name),
      ADD INDEX (control_county);

#   Can be used for Full Text Searching (experimental)
#ALTER TABLE tblGeoStateCA
#      ADD FULLTEXT INDEX (entity_name);