Re: index not being pick up
Posted by:
Raf Mahn
Date: January 17, 2018 01:19AM
SHOW CREATE TABLE for both tables is listed below. TIA.
CREATE TABLE `flag` (
`scope_id` int(11) NOT NULL,
`override_enabled` tinyint(4) NOT NULL,
KEY `scopeid_idx` (`scope_id`),
KEY `override_enabled_idx` (`override_enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `property` (
`property_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`reference` varchar(15) NOT NULL,
`display_name` varchar(200) NOT NULL,
`bed_count` mediumint(3) unsigned DEFAULT NULL,
`bath_count` mediumint(3) unsigned DEFAULT NULL,
`car_space_count` mediumint(3) unsigned DEFAULT NULL,
`land_area` bigint(20) unsigned DEFAULT NULL,
`building_area` mediumint(8) unsigned DEFAULT NULL,
`property_type` varchar(32) NOT NULL,
`property_use` enum('RESIDENTIAL','COMMERCIAL','HOLIDAY_RENTAL','VACANT_LAND','RURAL') NOT NULL,
`scope_id` int(10) unsigned DEFAULT NULL,
`created_utc` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
`updated_utc` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
`notes` mediumtext,
`status` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
`inactive_by_user_id` int(10) unsigned DEFAULT NULL,
`inactive_utc` datetime(3) DEFAULT NULL,
PRIMARY KEY (`property_id`),
UNIQUE KEY `uq_reference_idx` (`scope_id`,`reference`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8