MySQL Forums
Forum List  »  Quality Assurance

Re: Invisible UNIQUE index
Posted by: Martin Lechner
Date: February 14, 2018 09:54AM

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 */;

Options: ReplyQuote


Subject
Views
Written By
Posted
1149
February 14, 2018 07:07AM
Re: Invisible UNIQUE index
764
February 14, 2018 09:54AM
627
February 14, 2018 10:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.