#   qryTimeSeries6.sql
#   SQL
#   n6lhv@arrl.net (Wayne Smith)
#   created:  8-August-2004
#   updated:  10-August-2004



#   Display the MySQL version
SELECT version();



#   Manage the database
USE uls



# create indexes as appropriate
ALTER TABLE tblTimeSeries3
      ADD INDEX(frequency_assigned),
      ADD INDEX(call_sign),
      ADD INDEX(radio_service_code),
      ADD INDEX(class_station_code),
      ADD INDEX(location_state),
      ADD INDEX(location_county),
      ADD INDEX(location_city),

      ADD INDEX(code),
      ADD INDEX(DateDate),
      ADD INDEX(YearText),

      ADD INDEX(frequency_assignedNumber)
;