{"action":"created","issue":{"url":"https://api.github.com/repos/southern-wind/wind/issues/49","repository_url":"https://api.github.com/repos/southern-wind/wind","labels_url":"https://api.github.com/repos/southern-wind/wind/issues/49/labels{/name}","comments_url":"https://api.github.com/repos/southern-wind/wind/issues/49/comments","events_url":"https://api.github.com/repos/southern-wind/wind/issues/49/events","html_url":"https://github.com/southern-wind/wind/issues/49","id":130487577,"number":49,"title":"Sort out DB Scheme mess","user":{"login":"spinza","id":3501598,"avatar_url":"https://avatars.githubusercontent.com/u/3501598?v=3","gravatar_id":"","url":"https://api.github.com/users/spinza","html_url":"https://github.com/spinza","followers_url":"https://api.github.com/users/spinza/followers","following_url":"https://api.github.com/users/spinza/following{/other_user}","gists_url":"https://api.github.com/users/spinza/gists{/gist_id}","starred_url":"https://api.github.com/users/spinza/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spinza/subscriptions","organizations_url":"https://api.github.com/users/spinza/orgs","repos_url":"https://api.github.com/users/spinza/repos","events_url":"https://api.github.com/users/spinza/events{/privacy}","received_events_url":"https://api.github.com/users/spinza/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-02-01T21:19:21Z","updated_at":"2016-02-03T03:51:33Z","closed_at":null,"body":"I've reverted 1.2 and my fix for ip unsigned columns.\r\n\r\nWant to do the new fix but before I have to revert something again we need to clarify a couple of things:\r\n\r\n1. I see in your PR you update the scheme.sql?  Does that need to be updated to be the newest scheme?  Or the starting version?  I assumed the install script updates the db also.\r\n2. I have no idea how to write the update table in the scheme 1.2 to change those ip columns to unsigned int?  I can add a column, not sure how to change one.\r\n3. In your PR you also update the previous schema 's in 1.3 but you only need list the schema's in all.inc and just update the schema version (not list more) in update.php: https://github.com/southern-wind/wind/blob/master/tools/update.php#L22 \r\n\r\nPoint 3 is my understanding and that is how I tested 1.2.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/southern-wind/wind/issues/comments/178986954","html_url":"https://github.com/southern-wind/wind/issues/49#issuecomment-178986954","issue_url":"https://api.github.com/repos/southern-wind/wind/issues/49","id":178986954,"user":{"login":"jammin84","id":6802951,"avatar_url":"https://avatars.githubusercontent.com/u/6802951?v=3","gravatar_id":"","url":"https://api.github.com/users/jammin84","html_url":"https://github.com/jammin84","followers_url":"https://api.github.com/users/jammin84/followers","following_url":"https://api.github.com/users/jammin84/following{/other_user}","gists_url":"https://api.github.com/users/jammin84/gists{/gist_id}","starred_url":"https://api.github.com/users/jammin84/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jammin84/subscriptions","organizations_url":"https://api.github.com/users/jammin84/orgs","repos_url":"https://api.github.com/users/jammin84/repos","events_url":"https://api.github.com/users/jammin84/events{/privacy}","received_events_url":"https://api.github.com/users/jammin84/received_events","type":"User","site_admin":false},"created_at":"2016-02-03T03:51:33Z","updated_at":"2016-02-03T03:51:33Z","body":"@spinza now that it is \"Defined\", I take it that you will be performing the required update / amalgamation to 1.2?"}}