-
Notifications
You must be signed in to change notification settings - Fork 28
Closed
Description
I have a table:
CREATE TABLE `test` (
`id` bigint NOT NULL AUTO_INCREMENT,
`name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`phone_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`linked_customer_id` bigint DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_linked_customer` (`linked_customer_id`),
KEY `IDX_phone` (`phone_number`),
FULLTEXT KEY `IDX_customer_name` (`name`),
CONSTRAINT `fk_end_customers_link` FOREIGN KEY (`linked_customer_id`) REFERENCES `linked_end_customers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB;
which raises an error:
Exception: unknown mysql type "key"
bakwc
Metadata
Metadata
Assignees
Labels
No labels