mirror of
https://github.com/librenms/librenms.git
synced 2024-09-21 10:28:13 +00:00
6 lines
224 B
MySQL
6 lines
224 B
MySQL
|
CREATE TABLE tmp_table LIKE config;
|
||
|
|
ALTER IGNORE TABLE tmp_table ADD UNIQUE INDEX uniqueindex_configname (config_name);
|
||
|
|
INSERT IGNORE INTO tmp_table SELECT * FROM config;
|
||
|
|
DROP TABLE config;
|
||
|
|
RENAME TABLE tmp_table TO config;
|