{"action":"created","issue":{"url":"https://api.github.com/repos/Cockatrice/Cockatrice/issues/865","repository_url":"https://api.github.com/repos/Cockatrice/Cockatrice","labels_url":"https://api.github.com/repos/Cockatrice/Cockatrice/issues/865/labels{/name}","comments_url":"https://api.github.com/repos/Cockatrice/Cockatrice/issues/865/comments","events_url":"https://api.github.com/repos/Cockatrice/Cockatrice/issues/865/events","html_url":"https://github.com/Cockatrice/Cockatrice/issues/865","id":63420291,"number":865,"title":"Server db schema is broken in mysql strict mode","user":{"login":"Daenyth","id":14644,"avatar_url":"https://avatars.githubusercontent.com/u/14644?v=3","gravatar_id":"","url":"https://api.github.com/users/Daenyth","html_url":"https://github.com/Daenyth","followers_url":"https://api.github.com/users/Daenyth/followers","following_url":"https://api.github.com/users/Daenyth/following{/other_user}","gists_url":"https://api.github.com/users/Daenyth/gists{/gist_id}","starred_url":"https://api.github.com/users/Daenyth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Daenyth/subscriptions","organizations_url":"https://api.github.com/users/Daenyth/orgs","repos_url":"https://api.github.com/users/Daenyth/repos","events_url":"https://api.github.com/users/Daenyth/events{/privacy}","received_events_url":"https://api.github.com/users/Daenyth/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Cockatrice/Cockatrice/labels/App%20-%20Servatrice","name":"App - Servatrice","color":"009800"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":11,"created_at":"2015-03-21T15:51:29Z","updated_at":"2016-02-20T13:13:13Z","closed_at":null,"body":"http://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_strict_trans_tables\r\n\r\nLots of non-null columns treated as if they have a default value. We'll have to add a default or make them non-null and make sure the server handles it appropriately"},"comment":{"url":"https://api.github.com/repos/Cockatrice/Cockatrice/issues/comments/186592664","html_url":"https://github.com/Cockatrice/Cockatrice/issues/865#issuecomment-186592664","issue_url":"https://api.github.com/repos/Cockatrice/Cockatrice/issues/865","id":186592664,"user":{"login":"Daenyth","id":14644,"avatar_url":"https://avatars.githubusercontent.com/u/14644?v=3","gravatar_id":"","url":"https://api.github.com/users/Daenyth","html_url":"https://github.com/Daenyth","followers_url":"https://api.github.com/users/Daenyth/followers","following_url":"https://api.github.com/users/Daenyth/following{/other_user}","gists_url":"https://api.github.com/users/Daenyth/gists{/gist_id}","starred_url":"https://api.github.com/users/Daenyth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Daenyth/subscriptions","organizations_url":"https://api.github.com/users/Daenyth/orgs","repos_url":"https://api.github.com/users/Daenyth/repos","events_url":"https://api.github.com/users/Daenyth/events{/privacy}","received_events_url":"https://api.github.com/users/Daenyth/received_events","type":"User","site_admin":false},"created_at":"2016-02-20T13:13:13Z","updated_at":"2016-02-20T13:13:13Z","body":"Noting this from the docker setup instructions;\r\n\r\n```\r\nmysql> insert into servatrice.cockatrice_users (admin,name,password_sha512,active) values (1,'servatrice','jbB4kSWDmjaVzMNdU13n73SpdBCJTCJ/JYm5ZBZvfxlzbISbXir+e/aSvMz86KzOoaBfidxO0s6GVd8t00qC0TNPl+udHfECaF7MsA==',1);\r\nQuery OK, 1 row affected, 7 warnings (0.00 sec)\r\n\r\nmysql> show warnings\r\n    -> ;\r\n+---------+------+-------------------------------------------------------+\r\n| Level   | Code | Message                                               |\r\n+---------+------+-------------------------------------------------------+\r\n| Warning | 1364 | Field 'realname' doesn't have a default value         |\r\n| Warning | 1364 | Field 'gender' doesn't have a default value           |\r\n| Warning | 1364 | Field 'email' doesn't have a default value            |\r\n| Warning | 1364 | Field 'country' doesn't have a default value          |\r\n| Warning | 1364 | Field 'avatar_bmp' doesn't have a default value       |\r\n| Warning | 1364 | Field 'registrationDate' doesn't have a default value |\r\n| Warning | 1364 | Field 'clientid' doesn't have a default value         |\r\n+---------+------+-------------------------------------------------------+\r\n7 rows in set (0.00 sec)\r\n```"}}