- [FAIL] Database: incorrect column (sensors/sensor_id)
- [FAIL] Database: incorrect column (sensors_to_state_indexes/sensor_id)
- [FAIL] Database: incorrect column (sensors_to_state_indexes/state_index_id)
- [FAIL] Database: missing index (sensors_to_state_indexes/state_index_id)
- [FAIL] Database: extra index (sensors_to_state_indexes/sensors_to_state_indexes_ibfk_1)
- [FAIL] Database: extra constraint (sensors_to_state_indexes/sensors_to_state_indexes_ibfk_10)
- [FAIL] Database: extra constraint (sensors_to_state_indexes/sensors_to_state_indexes_ibfk_6)
- [FAIL] Database: extra constraint (sensors_to_state_indexes/sensors_to_state_indexes_ibfk_7)
- [FAIL] Database: extra constraint (sensors_to_state_indexes/sensors_to_state_indexes_ibfk_8)
- [FAIL] Database: extra constraint (sensors_to_state_indexes/sensors_to_state_indexes_ibfk_9)
- [FAIL] Database: incorrect column (state_indexes/state_index_id)
- [FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
- [FIX]:
- Run the following SQL statements to fix.
- SQL Statements:
- ALTER TABLE `sensors` CHANGE `sensor_id` `sensor_id` int(10) unsigned NOT NULL auto_increment;
- ALTER TABLE `sensors_to_state_indexes` CHANGE `sensor_id` `sensor_id` int(10) unsigned NOT NULL ;
- ALTER TABLE `sensors_to_state_indexes` CHANGE `state_index_id` `state_index_id` int(10) unsigned NOT NULL ;
- ALTER TABLE `sensors_to_state_indexes` DROP INDEX `sensors_to_state_indexes_ibfk_1`;
- ALTER TABLE `sensors_to_state_indexes` ADD INDEX `state_index_id` (`state_index_id`);
- ALTER TABLE `sensors_to_state_indexes` DROP FOREIGN KEY `sensors_to_state_indexes_ibfk_10`;
- ALTER TABLE `sensors_to_state_indexes` DROP FOREIGN KEY `sensors_to_state_indexes_ibfk_6`;
- ALTER TABLE `sensors_to_state_indexes` DROP FOREIGN KEY `sensors_to_state_indexes_ibfk_7`;
- ALTER TABLE `sensors_to_state_indexes` DROP FOREIGN KEY `sensors_to_state_indexes_ibfk_8`;
- ALTER TABLE `sensors_to_state_indexes` DROP FOREIGN KEY `sensors_to_state_indexes_ibfk_9`;
- ALTER TABLE `state_indexes` CHANGE `state_index_id` `state_index_id` int(10) unsigned NOT NULL auto_increment;