--------------
SELECT version()
--------------

+------------------+
| version()        |
+------------------+
| 5.1.50-community |
+------------------+
1 row in set (0.00 sec)

--------------
ALTER TABLE PUBACC_CP


      ADD INDEX(call_sign),
      ADD INDEX(state_code),
      ADD INDEX(control_county),
      ADD INDEX(control_city)
--------------

Query OK, 61402 rows affected (0.77 sec)
Records: 61402  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE PUBACC_EM


      ADD INDEX(call_sign)
--------------

Query OK, 13699487 rows affected (2 min 15.22 sec)
Records: 13699487  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE PUBACC_EN


      ADD INDEX(call_sign),
      ADD INDEX(state),
      ADD INDEX(city),
      ADD INDEX(entity_type)
--------------

Query OK, 1679522 rows affected (1 min 4.19 sec)
Records: 1679522  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE PUBACC_FR


      ADD INDEX(call_sign)
--------------

Query OK, 6804663 rows affected (1 min 34.42 sec)
Records: 6804663  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE PUBACC_HD


      ADD INDEX(call_sign),
      ADD INDEX(grant_date),
      ADD INDEX(expired_date),
      ADD INDEX(cancellation_date),
      ADD INDEX(effective_date),
      ADD INDEX(last_action_date)
--------------

Query OK, 988541 rows affected (24.09 sec)
Records: 988541  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE PUBACC_LO


      ADD INDEX(call_sign),
      ADD INDEX(location_state),
      ADD INDEX(location_county),
      ADD INDEX(location_city)
--------------

Query OK, 889338 rows affected (27.67 sec)
Records: 889338  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE PUBACC_HS
      ADD INDEX(unique_system_identifier),
      ADD INDEX(ULS_File_Number),
      ADD INDEX(callsign)
--------------

Query OK, 8302857 rows affected (1 min 55.05 sec)
Records: 8302857  Duplicates: 0  Warnings: 0

Bye