CREATE TABLE IF NOT EXISTS `properties` (
  `id` bigint(13) unsigned NOT NULL COMMENT,
  `No` int(11) unsigned NOT NULL,
  `PropertyID` int(11) unsigned NOT NULL,
  `Sorting` int(5) unsigned NOT NULL DEFAULT '0',
  `Value` text NOT NULL
) ENGINE=innoDB DEFAULT CHARSET=utf8;

ALTER TABLE `properties`
 ADD UNIQUE KEY `id` (`id`), ADD KEY `PropertyID` (`PropertyID`), ADD KEY `PropertyID_2` (`PropertyID`,`No`);

CREATE TABLE IF NOT EXISTS `properties_name` (
  `id` int(11) unsigned NOT NULL,
  `name` varchar(255) NOT NULL DEFAULT '0'
) ENGINE=innoDB DEFAULT CHARSET=utf8;

ALTER TABLE `properties_name`
 ADD PRIMARY KEY (`id`), ADD KEY `name` (`name`), ADD KEY `name_id` (`name`,`id`);

UPDATE properties as p SET p.PropertyID = (SELECT MIN(id) FROM properties_name WHERE name LIKE (SELECT name FROM properties_name WHERE id=p.PropertyID)) WHERE p.PropertyID IN(SELECT id FROM properties_name WHERE id NOT IN(SELECT min(id) FROM properties_name GROUP BY name HAVING count(*)>1))

UPDATE 
	properties as p,
	(select t1.id as required_id, t2.id as replace_id from properties_name as t1, ( select min(id) id, name from properties_name group by name HAVING count(*)>1) as t2 where t1.name=t2.name) as pid
SET
	p.PropertyID = pid.replace_id
WHERE
	p.PropertyID = pid.required_id;

DELETE
	del.*
FROM
	properties_name as del,
	(SELECT id FROM properties_name, (SELECT min(id) as i, name as n FROM properties_name GROUP BY name HAVING count(*)>1) as t where id != t.i AND t.n=name) as iid
WHERE
	del.id = iid.id