-- 1.4.7

-- INDEXES

ALTER TABLE playsms_tblUser ADD INDEX username (username);
ALTER TABLE playsms_tblBilling ADD INDEX smslog_id (smslog_id);
ALTER TABLE playsms_tblBilling ADD INDEX uid (uid);
ALTER TABLE playsms_tblDLR ADD INDEX smslog_id (smslog_id);
ALTER TABLE playsms_tblDLR ADD INDEX uid (uid);
ALTER TABLE playsms_tblSMSOutgoing ADD INDEX queue_code (queue_code);
ALTER TABLE playsms_tblSMSOutgoing ADD INDEX p_datetime (p_datetime);
ALTER TABLE playsms_tblSMSOutgoing ADD INDEX p_smsc (p_smsc);
ALTER TABLE playsms_tblSMSOutgoing_queue ADD INDEX flag (flag);
ALTER TABLE playsms_tblSMSOutgoing_queue ADD INDEX uid (uid);
ALTER TABLE playsms_tblSMSOutgoing_queue_dst ADD INDEX queue_id (queue_id);
ALTER TABLE playsms_featureSendfromfile ADD INDEX sid (sid);

-- BELOW INDEXES MAY ALREADY EXISTS

ALTER TABLE playsms_tblSMSOutgoing ADD INDEX smslog_id (smslog_id);
ALTER TABLE playsms_tblSMSOutgoing ADD INDEX uid (uid);
ALTER TABLE playsms_tblSMSOutgoing_queue ADD INDEX queue_code (queue_code);