{"action":"created","issue":{"url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/109","labels_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/109/labels{/name}","comments_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/109/comments","events_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/109/events","html_url":"https://github.com/JSQLParser/JSqlParser/issues/109","id":58342218,"number":109,"title":"MySQL Unique Keys","user":{"login":"azapps","id":485429,"avatar_url":"https://avatars.githubusercontent.com/u/485429?v=3","gravatar_id":"","url":"https://api.github.com/users/azapps","html_url":"https://github.com/azapps","followers_url":"https://api.github.com/users/azapps/followers","following_url":"https://api.github.com/users/azapps/following{/other_user}","gists_url":"https://api.github.com/users/azapps/gists{/gist_id}","starred_url":"https://api.github.com/users/azapps/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/azapps/subscriptions","organizations_url":"https://api.github.com/users/azapps/orgs","repos_url":"https://api.github.com/users/azapps/repos","events_url":"https://api.github.com/users/azapps/events{/privacy}","received_events_url":"https://api.github.com/users/azapps/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-02-20T11:51:32Z","updated_at":"2015-04-02T07:42:14Z","closed_at":null,"body":"```SQL\r\nCREATE TABLE animals (\r\nid INT NOT NULL,\r\nname VARCHAR(100)\r\nUNIQUE KEY (id));\r\n```\r\nunique is not supported"},"comment":{"url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/comments/88797731","html_url":"https://github.com/JSQLParser/JSqlParser/issues/109#issuecomment-88797731","issue_url":"https://api.github.com/repos/JSQLParser/JSqlParser/issues/109","id":88797731,"user":{"login":"frankred","id":1528623,"avatar_url":"https://avatars.githubusercontent.com/u/1528623?v=3","gravatar_id":"","url":"https://api.github.com/users/frankred","html_url":"https://github.com/frankred","followers_url":"https://api.github.com/users/frankred/followers","following_url":"https://api.github.com/users/frankred/following{/other_user}","gists_url":"https://api.github.com/users/frankred/gists{/gist_id}","starred_url":"https://api.github.com/users/frankred/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/frankred/subscriptions","organizations_url":"https://api.github.com/users/frankred/orgs","repos_url":"https://api.github.com/users/frankred/repos","events_url":"https://api.github.com/users/frankred/events{/privacy}","received_events_url":"https://api.github.com/users/frankred/received_events","type":"User","site_admin":false},"created_at":"2015-04-02T07:42:14Z","updated_at":"2015-04-02T07:42:14Z","body":"I'm Using 0.9.3 Snapshot but it seems like UNIQUE is not working.\r\n\r\nThe quotation mark ``` ` ``` is not working too\r\n\r\n```sql\r\nCREATE TABLE `wp_commentmeta` (\\n  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\\n  `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',\\n  `meta_key` varchar(255) DEFAULT NULL,\\n  `meta_value` longtext,\\n  PRIMARY KEY (`meta_id`),\\n  KEY `comment_id` (`comment_id`),\\n  KEY `meta_key` (`meta_key`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE TABLE `wp_comments` (\\n  `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\\n  `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',\\n  `comment_author` tinytext NOT NULL,\\n  `comment_author_email` varchar(100) NOT NULL DEFAULT '',\\n  `comment_author_url` varchar(200) NOT NULL DEFAULT '',\\n  `comment_author_IP` varchar(100) NOT NULL DEFAULT '',\\n  `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `comment_content` text NOT NULL,\\n  `comment_karma` int(11) NOT NULL DEFAULT '0',\\n  `comment_approved` varchar(20) NOT NULL DEFAULT '1',\\n  `comment_agent` varchar(255) NOT NULL DEFAULT '',\\n  `comment_type` varchar(20) NOT NULL DEFAULT '',\\n  `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',\\n  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`comment_ID`),\\n  KEY `comment_post_ID` (`comment_post_ID`),\\n  KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),\\n  KEY `comment_date_gmt` (`comment_date_gmt`),\\n  KEY `comment_parent` (`comment_parent`)\\n) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;CREATE TABLE `wp_links` (\\n  `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\\n  `link_url` varchar(255) NOT NULL DEFAULT '',\\n  `link_name` varchar(255) NOT NULL DEFAULT '',\\n  `link_image` varchar(255) NOT NULL DEFAULT '',\\n  `link_target` varchar(25) NOT NULL DEFAULT '',\\n  `link_description` varchar(255) NOT NULL DEFAULT '',\\n  `link_visible` varchar(20) NOT NULL DEFAULT 'Y',\\n  `link_owner` bigint(20) unsigned NOT NULL DEFAULT '1',\\n  `link_rating` int(11) NOT NULL DEFAULT '0',\\n  `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `link_rel` varchar(255) NOT NULL DEFAULT '',\\n  `link_notes` mediumtext NOT NULL,\\n  `link_rss` varchar(255) NOT NULL DEFAULT '',\\n  PRIMARY KEY (`link_id`),\\n  KEY `link_visible` (`link_visible`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE TABLE `wp_options` (\\n  `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\\n  `option_name` varchar(64) NOT NULL DEFAULT '',\\n  `option_value` longtext NOT NULL,\\n  `autoload` varchar(20) NOT NULL DEFAULT 'yes',\\n  PRIMARY KEY (`option_id`),\\n  UNIQUE KEY `option_name` (`option_name`)\\n) ENGINE=InnoDB AUTO_INCREMENT=402 DEFAULT CHARSET=utf8;CREATE TABLE `wp_postmeta` (\\n  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\\n  `post_id` bigint(20) unsigned NOT NULL DEFAULT '0',\\n  `meta_key` varchar(255) DEFAULT NULL,\\n  `meta_value` longtext,\\n  PRIMARY KEY (`meta_id`),\\n  KEY `post_id` (`post_id`),\\n  KEY `meta_key` (`meta_key`)\\n) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;CREATE TABLE `wp_posts` (\\n  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\\n  `post_author` bigint(20) unsigned NOT NULL DEFAULT '0',\\n  `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `post_content` longtext NOT NULL,\\n  `post_title` text NOT NULL,\\n  `post_excerpt` text NOT NULL,\\n  `post_status` varchar(20) NOT NULL DEFAULT 'publish',\\n  `comment_status` varchar(20) NOT NULL DEFAULT 'open',\\n  `ping_status` varchar(20) NOT NULL DEFAULT 'open',\\n  `post_password` varchar(20) NOT NULL DEFAULT '',\\n  `post_name` varchar(200) NOT NULL DEFAULT '',\\n  `to_ping` text NOT NULL,\\n  `pinged` text NOT NULL,\\n  `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `post_content_filtered` longtext NOT NULL,\\n  `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',\\n  `guid` varchar(255) NOT NULL DEFAULT '',\\n  `menu_order` int(11) NOT NULL DEFAULT '0',\\n  `post_type` varchar(20) NOT NULL DEFAULT 'post',\\n  `post_mime_type` varchar(100) NOT NULL DEFAULT '',\\n  `comment_count` bigint(20) NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`ID`),\\n  KEY `post_name` (`post_name`),\\n  KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),\\n  KEY `post_parent` (`post_parent`),\\n  KEY `post_author` (`post_author`)\\n) ENGINE=InnoDB AUTO_INCREMENT=55004 DEFAULT CHARSET=utf8;CREATE TABLE `wp_term_relationships` (\\n  `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',\\n  `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',\\n  `term_order` int(11) NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`object_id`,`term_taxonomy_id`),\\n  KEY `term_taxonomy_id` (`term_taxonomy_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE TABLE `wp_term_taxonomy` (\\n  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\\n  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',\\n  `taxonomy` varchar(32) NOT NULL DEFAULT '',\\n  `description` longtext NOT NULL,\\n  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',\\n  `count` bigint(20) NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`term_taxonomy_id`),\\n  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),\\n  KEY `taxonomy` (`taxonomy`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;CREATE TABLE `wp_terms` (\\n  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(200) NOT NULL DEFAULT '',\\n  `slug` varchar(200) NOT NULL DEFAULT '',\\n  `term_group` bigint(10) NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`term_id`),\\n  UNIQUE KEY `slug` (`slug`),\\n  KEY `name` (`name`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;CREATE TABLE `wp_usermeta` (\\n  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',\\n  `meta_key` varchar(255) DEFAULT NULL,\\n  `meta_value` longtext,\\n  PRIMARY KEY (`umeta_id`),\\n  KEY `user_id` (`user_id`),\\n  KEY `meta_key` (`meta_key`)\\n) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;CREATE TABLE `wp_users` (\\n  `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\\n  `user_login` varchar(60) NOT NULL DEFAULT '',\\n  `user_pass` varchar(64) NOT NULL DEFAULT '',\\n  `user_nicename` varchar(50) NOT NULL DEFAULT '',\\n  `user_email` varchar(100) NOT NULL DEFAULT '',\\n  `user_url` varchar(100) NOT NULL DEFAULT '',\\n  `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `user_activation_key` varchar(60) NOT NULL DEFAULT '',\\n  `user_status` int(11) NOT NULL DEFAULT '0',\\n  `display_name` varchar(250) NOT NULL DEFAULT '',\\n  PRIMARY KEY (`ID`),\\n  KEY `user_login_key` (`user_login`),\\n  KEY `user_nicename` (`user_nicename`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;\r\n```\r\n\r\nAfter I remove all  ``` ` ``` I got the following exception:\r\n\r\n```\r\nException in thread \"main\" net.sf.jsqlparser.JSQLParserException\r\n\tat net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:111)\r\n\tat sanbox.BUDataColumnsFinder.main(BUDataColumnsFinder.java:14)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:606)\r\n\tat com.intellij.rt.execution.application.AppMain.main(AppMain.java:134)\r\nCaused by: net.sf.jsqlparser.parser.ParseException: Encountered \" \"UNIQUE\" \"UNIQUE \"\" at line 52, column 3.\r\n```\r\n\r\n\r\nHere is my pom\r\n\r\n```\r\n        <dependency>\r\n            <groupId>com.github.jsqlparser</groupId>\r\n            <artifactId>jsqlparser</artifactId>\r\n            <version>0.9.3-SNAPSHOT</version>\r\n        </dependency>\r\n```"}}