{"action":"created","issue":{"url":"https://api.github.com/repos/inverse-inc/packetfence/issues/467","labels_url":"https://api.github.com/repos/inverse-inc/packetfence/issues/467/labels{/name}","comments_url":"https://api.github.com/repos/inverse-inc/packetfence/issues/467/comments","events_url":"https://api.github.com/repos/inverse-inc/packetfence/issues/467/events","html_url":"https://github.com/inverse-inc/packetfence/issues/467","id":68381908,"number":467,"title":"Better upgrade sql for iplog","user":{"login":"jrouzierinverse","id":2727473,"avatar_url":"https://avatars.githubusercontent.com/u/2727473?v=3","gravatar_id":"","url":"https://api.github.com/users/jrouzierinverse","html_url":"https://github.com/jrouzierinverse","followers_url":"https://api.github.com/users/jrouzierinverse/followers","following_url":"https://api.github.com/users/jrouzierinverse/following{/other_user}","gists_url":"https://api.github.com/users/jrouzierinverse/gists{/gist_id}","starred_url":"https://api.github.com/users/jrouzierinverse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jrouzierinverse/subscriptions","organizations_url":"https://api.github.com/users/jrouzierinverse/orgs","repos_url":"https://api.github.com/users/jrouzierinverse/repos","events_url":"https://api.github.com/users/jrouzierinverse/events{/privacy}","received_events_url":"https://api.github.com/users/jrouzierinverse/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"dwlfrth","id":633234,"avatar_url":"https://avatars.githubusercontent.com/u/633234?v=3","gravatar_id":"","url":"https://api.github.com/users/dwlfrth","html_url":"https://github.com/dwlfrth","followers_url":"https://api.github.com/users/dwlfrth/followers","following_url":"https://api.github.com/users/dwlfrth/following{/other_user}","gists_url":"https://api.github.com/users/dwlfrth/gists{/gist_id}","starred_url":"https://api.github.com/users/dwlfrth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dwlfrth/subscriptions","organizations_url":"https://api.github.com/users/dwlfrth/orgs","repos_url":"https://api.github.com/users/dwlfrth/repos","events_url":"https://api.github.com/users/dwlfrth/events{/privacy}","received_events_url":"https://api.github.com/users/dwlfrth/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-04-14T13:47:53Z","updated_at":"2015-04-14T13:57:23Z","closed_at":null,"body":"Remove duplicate iplog entries in upgrade script."},"comment":{"url":"https://api.github.com/repos/inverse-inc/packetfence/issues/comments/92860754","html_url":"https://github.com/inverse-inc/packetfence/issues/467#issuecomment-92860754","issue_url":"https://api.github.com/repos/inverse-inc/packetfence/issues/467","id":92860754,"user":{"login":"jrouzierinverse","id":2727473,"avatar_url":"https://avatars.githubusercontent.com/u/2727473?v=3","gravatar_id":"","url":"https://api.github.com/users/jrouzierinverse","html_url":"https://github.com/jrouzierinverse","followers_url":"https://api.github.com/users/jrouzierinverse/followers","following_url":"https://api.github.com/users/jrouzierinverse/following{/other_user}","gists_url":"https://api.github.com/users/jrouzierinverse/gists{/gist_id}","starred_url":"https://api.github.com/users/jrouzierinverse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jrouzierinverse/subscriptions","organizations_url":"https://api.github.com/users/jrouzierinverse/orgs","repos_url":"https://api.github.com/users/jrouzierinverse/repos","events_url":"https://api.github.com/users/jrouzierinverse/events{/privacy}","received_events_url":"https://api.github.com/users/jrouzierinverse/received_events","type":"User","site_admin":false},"created_at":"2015-04-14T13:57:23Z","updated_at":"2015-04-14T13:57:23Z","body":"Would it better to do a rename the old table create a new one.\r\nThe populate the new with the data from the old iplog.\r\n\r\nrename iplog to iplog_old;\r\ncreate iplog;\r\ninsert into iplog SELECT * FROM iplog_old GROUP BY iplog ORDER BY start_time DESC LIMIT 1;\r\n\r\n"}}