{"action":"created","issue":{"url":"https://api.github.com/repos/Cacti/cacti/issues/631","repository_url":"https://api.github.com/repos/Cacti/cacti","labels_url":"https://api.github.com/repos/Cacti/cacti/issues/631/labels{/name}","comments_url":"https://api.github.com/repos/Cacti/cacti/issues/631/comments","events_url":"https://api.github.com/repos/Cacti/cacti/issues/631/events","html_url":"https://github.com/Cacti/cacti/pull/631","id":224898586,"number":631,"title":"Import and Export cacti.sql in order to clean up SQL formating issues.","user":{"login":"dsclassen","id":8882563,"avatar_url":"https://avatars2.githubusercontent.com/u/8882563?v=3","gravatar_id":"","url":"https://api.github.com/users/dsclassen","html_url":"https://github.com/dsclassen","followers_url":"https://api.github.com/users/dsclassen/followers","following_url":"https://api.github.com/users/dsclassen/following{/other_user}","gists_url":"https://api.github.com/users/dsclassen/gists{/gist_id}","starred_url":"https://api.github.com/users/dsclassen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dsclassen/subscriptions","organizations_url":"https://api.github.com/users/dsclassen/orgs","repos_url":"https://api.github.com/users/dsclassen/repos","events_url":"https://api.github.com/users/dsclassen/events{/privacy}","received_events_url":"https://api.github.com/users/dsclassen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2017-04-27T20:08:50Z","updated_at":"2017-05-04T00:03:05Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/Cacti/cacti/pulls/631","html_url":"https://github.com/Cacti/cacti/pull/631","diff_url":"https://github.com/Cacti/cacti/pull/631.diff","patch_url":"https://github.com/Cacti/cacti/pull/631.patch"},"body":"Perhaps these types of formatting changes aren't appropriate, but I thought I'd \"sanitize\" the cacti.sql by importing into mysql and exporting it back out.\r\n\r\n1. This resulted in the CREATE tables statements being reordered alphabetically.\r\n2. Table indexes are now all at the very bottom of the sql file.\r\n3. All table and column names and now enclosed in backquotes (Protects column and table names formed with special characters or keywords). This may also allow easier comparison of cacti.sql file changes in the future."},"comment":{"url":"https://api.github.com/repos/Cacti/cacti/issues/comments/299068553","html_url":"https://github.com/Cacti/cacti/pull/631#issuecomment-299068553","issue_url":"https://api.github.com/repos/Cacti/cacti/issues/631","id":299068553,"user":{"login":"dsclassen","id":8882563,"avatar_url":"https://avatars2.githubusercontent.com/u/8882563?v=3","gravatar_id":"","url":"https://api.github.com/users/dsclassen","html_url":"https://github.com/dsclassen","followers_url":"https://api.github.com/users/dsclassen/followers","following_url":"https://api.github.com/users/dsclassen/following{/other_user}","gists_url":"https://api.github.com/users/dsclassen/gists{/gist_id}","starred_url":"https://api.github.com/users/dsclassen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dsclassen/subscriptions","organizations_url":"https://api.github.com/users/dsclassen/orgs","repos_url":"https://api.github.com/users/dsclassen/repos","events_url":"https://api.github.com/users/dsclassen/events{/privacy}","received_events_url":"https://api.github.com/users/dsclassen/received_events","type":"User","site_admin":false},"created_at":"2017-05-04T00:03:05Z","updated_at":"2017-05-04T00:03:05Z","body":"I'd be happy to add a Contribution guide to the wiki, but I don't have permission, and it's not clear to me exactly how to clone/fork it."}}
{"actor":{"display_login":"dsclassen"}}