Re: Invisible UNIQUE index

[Martin Lechner]

Sorry, mistake - the unique index exists, but it cannot be deleted.

(1.)

DROP TABLE IF EXISTS `terminalconfiguration_crypto_configuration`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `terminalconfiguration_crypto_configuration` (
`tconfiguration_id` bigint(20) NOT NULL,
`cc_id` bigint(20) NOT NULL,
UNIQUE KEY `UK_oux3v44rv2m0rtmgkrsknlv10` (`cc_id`),
KEY `FK_ji1ps60hrpy7gy24frq6rv092` (`tconfiguration_id`),
CONSTRAINT `FK70pc36pkrt9x7lwvdf8796bcb` FOREIGN KEY (`tconfiguration_id`) REFERENCES `terminalconfiguration` (`id`),
CONSTRAINT `FK_ji1ps60hrpy7gy24frq6rv092` FOREIGN KEY (`tconfiguration_id`) REFERENCES `terminalconfiguration` (`id`),
CONSTRAINT `FK_oux3v44rv2m0rtmgkrsknlv10` FOREIGN KEY (`cc_id`) REFERENCES `tcryptoconfiguration` (`id`),
CONSTRAINT `FKm8d00sxnh9g09wqb05goi1dk2` FOREIGN KEY (`cc_id`) REFERENCES `tcryptoconfiguration` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;