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

+-------------------------+
| version()               |
+-------------------------+
| 5.0.45-community-nt-log | 
+-------------------------+
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, 55815 rows affected (6.26 sec)
Records: 55815  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE PUBACC_EM
      ADD INDEX(call_sign)
--------------

Query OK, 17189503 rows affected (33 min 38.62 sec)
Records: 17189503  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE PUBACC_EN
      ADD INDEX(call_sign),
      ADD INDEX(state),
      ADD INDEX(city),
      ADD INDEX(entity_type)
--------------

Query OK, 1427086 rows affected (9 min 32.58 sec)
Records: 1427086  Duplicates: 0  Warnings: 0

--------------
ALTER TABLE PUBACC_FR
      ADD INDEX(call_sign)
--------------

Query OK, 8000100 rows affected (24 min 11.86 sec)
Records: 8000100  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, 898138 rows affected (4 min 8.23 sec)
Records: 898138  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, 775465 rows affected (3 min 35.07 sec)
Records: 775465  Duplicates: 0  Warnings: 0

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

Query OK, 6492380 rows affected (12 min 22.88 sec)
Records: 6492380  Duplicates: 0  Warnings: 0

Bye