{"action":"created","issue":{"url":"https://api.github.com/repos/directus/directus/issues/1191","repository_url":"https://api.github.com/repos/directus/directus","labels_url":"https://api.github.com/repos/directus/directus/issues/1191/labels{/name}","comments_url":"https://api.github.com/repos/directus/directus/issues/1191/comments","events_url":"https://api.github.com/repos/directus/directus/issues/1191/events","html_url":"https://github.com/directus/directus/issues/1191","id":161075232,"number":1191,"title":"consistent schema (ids, unsigned)","user":{"login":"laszlokorte","id":26493,"avatar_url":"https://avatars.githubusercontent.com/u/26493?v=3","gravatar_id":"","url":"https://api.github.com/users/laszlokorte","html_url":"https://github.com/laszlokorte","followers_url":"https://api.github.com/users/laszlokorte/followers","following_url":"https://api.github.com/users/laszlokorte/following{/other_user}","gists_url":"https://api.github.com/users/laszlokorte/gists{/gist_id}","starred_url":"https://api.github.com/users/laszlokorte/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laszlokorte/subscriptions","organizations_url":"https://api.github.com/users/laszlokorte/orgs","repos_url":"https://api.github.com/users/laszlokorte/repos","events_url":"https://api.github.com/users/laszlokorte/events{/privacy}","received_events_url":"https://api.github.com/users/laszlokorte/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/directus/directus/labels/4.%20Minor","name":"4. Minor","color":"FFCC00"},{"url":"https://api.github.com/repos/directus/directus/labels/Beginner","name":"Beginner","color":"fef2c0"},{"url":"https://api.github.com/repos/directus/directus/labels/Schema-Change","name":"Schema-Change","color":"551A8B"}],"state":"closed","locked":false,"assignee":{"login":"WellingGuzman","id":1531291,"avatar_url":"https://avatars.githubusercontent.com/u/1531291?v=3","gravatar_id":"","url":"https://api.github.com/users/WellingGuzman","html_url":"https://github.com/WellingGuzman","followers_url":"https://api.github.com/users/WellingGuzman/followers","following_url":"https://api.github.com/users/WellingGuzman/following{/other_user}","gists_url":"https://api.github.com/users/WellingGuzman/gists{/gist_id}","starred_url":"https://api.github.com/users/WellingGuzman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WellingGuzman/subscriptions","organizations_url":"https://api.github.com/users/WellingGuzman/orgs","repos_url":"https://api.github.com/users/WellingGuzman/repos","events_url":"https://api.github.com/users/WellingGuzman/events{/privacy}","received_events_url":"https://api.github.com/users/WellingGuzman/received_events","type":"User","site_admin":false},"assignees":[{"login":"WellingGuzman","id":1531291,"avatar_url":"https://avatars.githubusercontent.com/u/1531291?v=3","gravatar_id":"","url":"https://api.github.com/users/WellingGuzman","html_url":"https://github.com/WellingGuzman","followers_url":"https://api.github.com/users/WellingGuzman/followers","following_url":"https://api.github.com/users/WellingGuzman/following{/other_user}","gists_url":"https://api.github.com/users/WellingGuzman/gists{/gist_id}","starred_url":"https://api.github.com/users/WellingGuzman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WellingGuzman/subscriptions","organizations_url":"https://api.github.com/users/WellingGuzman/orgs","repos_url":"https://api.github.com/users/WellingGuzman/repos","events_url":"https://api.github.com/users/WellingGuzman/events{/privacy}","received_events_url":"https://api.github.com/users/WellingGuzman/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/directus/directus/milestones/1","html_url":"https://github.com/directus/directus/milestones/6.3%20(Lapis%20Lepus)","labels_url":"https://api.github.com/repos/directus/directus/milestones/1/labels","id":228948,"number":1,"title":"6.3 (Lapis Lepus)","description":"Bug fixes, small feature improvements, and design update.","creator":{"login":"RNGR","id":1563261,"avatar_url":"https://avatars.githubusercontent.com/u/1563261?v=3","gravatar_id":"","url":"https://api.github.com/users/RNGR","html_url":"https://github.com/RNGR","followers_url":"https://api.github.com/users/RNGR/followers","following_url":"https://api.github.com/users/RNGR/following{/other_user}","gists_url":"https://api.github.com/users/RNGR/gists{/gist_id}","starred_url":"https://api.github.com/users/RNGR/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/RNGR/subscriptions","organizations_url":"https://api.github.com/users/RNGR/orgs","repos_url":"https://api.github.com/users/RNGR/repos","events_url":"https://api.github.com/users/RNGR/events{/privacy}","received_events_url":"https://api.github.com/users/RNGR/received_events","type":"Organization","site_admin":false},"open_issues":24,"closed_issues":603,"state":"open","created_at":"2012-12-13T01:31:51Z","updated_at":"2016-08-03T03:53:40Z","due_on":"2016-07-31T04:00:00Z","closed_at":null},"comments":3,"created_at":"2016-06-19T14:21:36Z","updated_at":"2016-08-03T14:35:58Z","closed_at":"2016-07-09T23:52:36Z","body":"## Version Info\r\n  - Directus version: bf52351\r\n\r\n## Suggestion\r\n\r\nIt's not a real problem but I think it would be nice if the db schema (both the directus tables and the custom ones) would be set up a bit more consistent:\r\n\r\n* currently some ìd`columns are `INT(10)` some are `INT(11)`\r\n* some ìd` columns are unsigned, some are not\r\n* the `active` column of a new table allows NULL values. I think `NOT NULL` would be a sensible option.\r\n\r\nWhen setting up a new MTO field it would make sense to restrict the data type and length options to exactly the type of the id column of the related table. (ie not showing those options at all)\r\nThere is no point in creating a INT(100) column for referencing an INT(11) column. Then that foreign key column should also be made `unsigned`."},"comment":{"url":"https://api.github.com/repos/directus/directus/issues/comments/237254954","html_url":"https://github.com/directus/directus/issues/1191#issuecomment-237254954","issue_url":"https://api.github.com/repos/directus/directus/issues/1191","id":237254954,"user":{"login":"WellingGuzman","id":1531291,"avatar_url":"https://avatars.githubusercontent.com/u/1531291?v=3","gravatar_id":"","url":"https://api.github.com/users/WellingGuzman","html_url":"https://github.com/WellingGuzman","followers_url":"https://api.github.com/users/WellingGuzman/followers","following_url":"https://api.github.com/users/WellingGuzman/following{/other_user}","gists_url":"https://api.github.com/users/WellingGuzman/gists{/gist_id}","starred_url":"https://api.github.com/users/WellingGuzman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WellingGuzman/subscriptions","organizations_url":"https://api.github.com/users/WellingGuzman/orgs","repos_url":"https://api.github.com/users/WellingGuzman/repos","events_url":"https://api.github.com/users/WellingGuzman/events{/privacy}","received_events_url":"https://api.github.com/users/WellingGuzman/received_events","type":"User","site_admin":false},"created_at":"2016-08-03T14:35:58Z","updated_at":"2016-08-03T14:35:58Z","body":"That's correct, you're right. There's not actual meaning but for padding, but still has meaning.\r\n\r\nWhat I believe this needs to be optional parameter. I'm going to make it optional so the API doesn't required length for numeric types.\r\n\r\nAlthough ZEROFILL can not be set, we plan on doing that, accepting fields options such as ZEROFILL and UNSIGNED.\r\n\r\nThanks @laszlokorte "}}
{"actor":{"display_login":"WellingGuzman"}}