2 lines
129 B
SQL

ALTER TABLE `devices_locations` DROP INDEX `device_id`;
ALTER TABLE `devices_locations` ADD UNIQUE KEY `device_id` (`device_id`);