{"action":"created","issue":{"url":"https://api.github.com/repos/saltstack/salt/issues/24603","labels_url":"https://api.github.com/repos/saltstack/salt/issues/24603/labels{/name}","comments_url":"https://api.github.com/repos/saltstack/salt/issues/24603/comments","events_url":"https://api.github.com/repos/saltstack/salt/issues/24603/events","html_url":"https://github.com/saltstack/salt/issues/24603","id":87442966,"number":24603,"title":"Feedback request on changes to mysql returner","user":{"login":"kaithar","id":76736,"avatar_url":"https://avatars.githubusercontent.com/u/76736?v=3","gravatar_id":"","url":"https://api.github.com/users/kaithar","html_url":"https://github.com/kaithar","followers_url":"https://api.github.com/users/kaithar/followers","following_url":"https://api.github.com/users/kaithar/following{/other_user}","gists_url":"https://api.github.com/users/kaithar/gists{/gist_id}","starred_url":"https://api.github.com/users/kaithar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kaithar/subscriptions","organizations_url":"https://api.github.com/users/kaithar/orgs","repos_url":"https://api.github.com/users/kaithar/repos","events_url":"https://api.github.com/users/kaithar/events{/privacy}","received_events_url":"https://api.github.com/users/kaithar/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-06-11T18:40:01Z","updated_at":"2015-06-11T23:16:30Z","closed_at":null,"body":"I'm tweaking the mysql returner to be more searchable when integrating and I need to make a change to the schema to do that.  So two questions...\r\n\r\nFirstly should this be put in as a second mysql returner or as a non-default option to the current one?  I don't want to break anyone's tables by making this a default behaviour.\r\n\r\nSecondly, does salt have any constraints that should influence this?  Do any of these columns need to be bigger, can any be smaller?\r\n\r\nThis is the schema I'm looking at for jid:\r\n```sql\r\nCREATE TABLE `jids` (\r\n  `jid` varchar(255) NOT NULL,\r\n  `load` mediumtext NOT NULL,\r\n  `tgt_type` varchar(255) DEFAULT NULL,\r\n  `cmd` varchar(255) DEFAULT NULL,\r\n  `tgt` varchar(255) DEFAULT NULL,\r\n  `user` varchar(255) DEFAULT NULL,\r\n  `fun` varchar(255) DEFAULT NULL,\r\n  UNIQUE KEY `jid` (`jid`),\r\n  KEY `tgt_type` (`tgt_type`), \r\n  KEY `cmd` (`cmd`), \r\n  KEY `tgt` (`tgt`), \r\n  KEY `user` (`user`), \r\n  KEY `fun` (`fun`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n```"},"comment":{"url":"https://api.github.com/repos/saltstack/salt/issues/comments/111304336","html_url":"https://github.com/saltstack/salt/issues/24603#issuecomment-111304336","issue_url":"https://api.github.com/repos/saltstack/salt/issues/24603","id":111304336,"user":{"login":"cachedout","id":111616,"avatar_url":"https://avatars.githubusercontent.com/u/111616?v=3","gravatar_id":"","url":"https://api.github.com/users/cachedout","html_url":"https://github.com/cachedout","followers_url":"https://api.github.com/users/cachedout/followers","following_url":"https://api.github.com/users/cachedout/following{/other_user}","gists_url":"https://api.github.com/users/cachedout/gists{/gist_id}","starred_url":"https://api.github.com/users/cachedout/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cachedout/subscriptions","organizations_url":"https://api.github.com/users/cachedout/orgs","repos_url":"https://api.github.com/users/cachedout/repos","events_url":"https://api.github.com/users/cachedout/events{/privacy}","received_events_url":"https://api.github.com/users/cachedout/received_events","type":"User","site_admin":false},"created_at":"2015-06-11T23:16:30Z","updated_at":"2015-06-11T23:16:30Z","body":"I'm going to route this request over to @ckochenower who has been doing a lot of returner schema work lately and might have good insights."}}