{"action":"closed","issue":{"url":"https://api.github.com/repos/mautic/mautic/issues/4372","repository_url":"https://api.github.com/repos/mautic/mautic","labels_url":"https://api.github.com/repos/mautic/mautic/issues/4372/labels{/name}","comments_url":"https://api.github.com/repos/mautic/mautic/issues/4372/comments","events_url":"https://api.github.com/repos/mautic/mautic/issues/4372/events","html_url":"https://github.com/mautic/mautic/issues/4372","id":241219837,"number":4372,"title":"Make text field column size configurable ","user":{"login":"MaxWebmecanik","id":18265735,"avatar_url":"https://avatars1.githubusercontent.com/u/18265735?v=4","gravatar_id":"","url":"https://api.github.com/users/MaxWebmecanik","html_url":"https://github.com/MaxWebmecanik","followers_url":"https://api.github.com/users/MaxWebmecanik/followers","following_url":"https://api.github.com/users/MaxWebmecanik/following{/other_user}","gists_url":"https://api.github.com/users/MaxWebmecanik/gists{/gist_id}","starred_url":"https://api.github.com/users/MaxWebmecanik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MaxWebmecanik/subscriptions","organizations_url":"https://api.github.com/users/MaxWebmecanik/orgs","repos_url":"https://api.github.com/users/MaxWebmecanik/repos","events_url":"https://api.github.com/users/MaxWebmecanik/events{/privacy}","received_events_url":"https://api.github.com/users/MaxWebmecanik/received_events","type":"User","site_admin":false},"labels":[{"id":154414465,"url":"https://api.github.com/repos/mautic/mautic/labels/Feature%20Request","name":"Feature Request","color":"1d76db","default":false},{"id":557054648,"url":"https://api.github.com/repos/mautic/mautic/labels/P1","name":"P1","color":"ffc691","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2017-07-07T10:11:40Z","updated_at":"2018-02-25T17:58:19Z","closed_at":"2018-02-25T17:58:19Z","author_association":"CONTRIBUTOR","body":"What type of report is this:\r\n\r\n| Q  | A\r\n| ---| ---\r\n| Bug report? | \r\n| Feature request? | \r\n| Enhancement? | ✓\r\n\r\n## Description:\r\n\r\nToday, all text contact fields are stored in the database as `VARCHAR(255)`. This makes it really easy to reach the maximum row size.\r\n\r\nI ran some tests on my machine running MariaDB `10.2.6` where I would add columns of the same size to a table until it broke.\r\n\r\nHere are the results:\r\n\r\n| `VARCHAR` size | Number of columns |\r\n| --- | --- |\r\n| 255 | 85 |\r\n| 127 | 171 (almost a two-fold increase!) |\r\n| 63 | 196 |\r\n| 31 | 196 |\r\n| 15 | 196 |\r\n| 7 | 367 (a pretty good increase as well) |\r\n\r\nMaybe we could introduce a few contact field _types_\r\n- We keep the normal text type and maybe relabel it\r\n- a 127 char type\r\n- a 7 char type that could be used for short codes"}}
{"actor":{"display_login":"dbhurley"}}