Skip to content

Instantly share code, notes, and snippets.

@mnathani
Created August 7, 2017 03:30
Show Gist options
  • Save mnathani/38cb3c917d04171fdef925be8362f93f to your computer and use it in GitHub Desktop.
Save mnathani/38cb3c917d04171fdef925be8362f93f to your computer and use it in GitHub Desktop.
CREATE TABLE `gmf_commentmeta` (
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`comment_id` bigint(20) unsigned NOT NULL,
`meta_key` varchar(600) DEFAULT NULL,
`meta_value` longtext DEFAULT NULL,
PRIMARY KEY `PRIMARY` (`meta_id`) USING BTREE,
KEY `comment_id` (`comment_id`) USING BTREE,
KEY `meta_key` (`meta_key`) USING BTREE
) ENGINE=InnoDB ROW_FORMAT = COMPACT
MySQL said: Documentation
#1709 - Index column size too large. The maximum column size is 767 bytes.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment