Heres what shows up…
Altering tables, creating new indexes if necessary
Failed to run query: ALTER TABLE #__jomres_guest_profile
ADD INDEX cms_user_id ( cms_user_id )
Failed to run query: ALTER TABLE #__jomres_custom_text
ADD INDEX property_uid ( property_uid )
Failed to run query: ALTER TABLE #__jomres_custom_text
ADD INDEX language
( language
)
Failed to run query: ALTER TABLE #__jomresportal_invoices
ADD INDEX property_uid ( property_uid )
Failed to run query: ALTER TABLE #__jomresportal_lineitems
ADD INDEX inv_id ( inv_id )
Failed to run query: ALTER TABLE #__jomres_booking_data_archive
ADD INDEX contract_uid ( contract_uid )
Failed to run query: ALTER TABLE #__jomcomp_notes
ADD INDEX property_uid ( property_uid )
Failed to run query: ALTER TABLE #__jomcomp_notes
ADD INDEX contract_uid ( contract_uid )
Failed to run query: ALTER TABLE #__jomres_pluginsettings
ADD INDEX prid ( prid )
Failed to run query: ALTER TABLE #__jomres_regions
ADD INDEX countrycode
( countrycode
)
Failed to run query: ALTER TABLE #__jomres_extras
ADD INDEX property_uid ( property_uid )
Failed to run query: ALTER TABLE #__jomres_guests
ADD INDEX mos_userid ( mos_userid )
Failed to run query: ALTER TABLE #__jomres_guests
ADD INDEX property_uid ( property_uid )
Failed to run query: ALTER TABLE #__jomres_pcounter
ADD INDEX p_uid ( p_uid )
Failed to run query: ALTER TABLE #__jomres_propertys
ADD INDEX property_town
( property_town
)
Failed to run query: ALTER TABLE #__jomres_propertys
ADD INDEX property_region
( property_region
)
Failed to run query: ALTER TABLE #__jomres_propertys
ADD INDEX property_country
( property_country
)
Failed to run query: ALTER TABLE #__jomres_propertys
ADD INDEX published ( published )
Failed to run query: ALTER TABLE #__jomres_propertys
ADD INDEX ptype_id ( ptype_id )
Failed to run query: ALTER TABLE #__jomres_rates
ADD INDEX roomclass_uid ( roomclass_uid )
Failed to run query: ALTER TABLE #__jomres_rates
ADD INDEX property_uid ( property_uid )
Failed to run query: ALTER TABLE #__jomres_rooms
ADD INDEX room_classes_uid ( room_classes_uid )
Failed to run query: ALTER TABLE #__jomres_rooms
ADD INDEX propertys_uid ( propertys_uid )
Failed to run query: ALTER TABLE #__jomres_room_bookings
ADD INDEX room_uid ( room_uid )
Failed to run query: ALTER TABLE #__jomres_room_bookings
ADD INDEX date
( date
)
Failed to run query: ALTER TABLE #__jomres_room_bookings
ADD INDEX property_uid ( property_uid )
Failed to run query: ALTER TABLE #__jomres_settings
ADD INDEX property_uid ( property_uid )
Number of tables 11
Number of tables that could not be identified 11