{"action":"created","issue":{"url":"https://api.github.com/repos/open-classifieds/openclassifieds2/issues/2115","repository_url":"https://api.github.com/repos/open-classifieds/openclassifieds2","labels_url":"https://api.github.com/repos/open-classifieds/openclassifieds2/issues/2115/labels{/name}","comments_url":"https://api.github.com/repos/open-classifieds/openclassifieds2/issues/2115/comments","events_url":"https://api.github.com/repos/open-classifieds/openclassifieds2/issues/2115/events","html_url":"https://github.com/open-classifieds/openclassifieds2/issues/2115","id":184807923,"number":2115,"title":"Innodb","user":{"login":"neo22s","id":241725,"avatar_url":"https://avatars.githubusercontent.com/u/241725?v=3","gravatar_id":"","url":"https://api.github.com/users/neo22s","html_url":"https://github.com/neo22s","followers_url":"https://api.github.com/users/neo22s/followers","following_url":"https://api.github.com/users/neo22s/following{/other_user}","gists_url":"https://api.github.com/users/neo22s/gists{/gist_id}","starred_url":"https://api.github.com/users/neo22s/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/neo22s/subscriptions","organizations_url":"https://api.github.com/users/neo22s/orgs","repos_url":"https://api.github.com/users/neo22s/repos","events_url":"https://api.github.com/users/neo22s/events{/privacy}","received_events_url":"https://api.github.com/users/neo22s/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/open-classifieds/openclassifieds2/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/open-classifieds/openclassifieds2/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":{"login":"neo22s","id":241725,"avatar_url":"https://avatars.githubusercontent.com/u/241725?v=3","gravatar_id":"","url":"https://api.github.com/users/neo22s","html_url":"https://github.com/neo22s","followers_url":"https://api.github.com/users/neo22s/followers","following_url":"https://api.github.com/users/neo22s/following{/other_user}","gists_url":"https://api.github.com/users/neo22s/gists{/gist_id}","starred_url":"https://api.github.com/users/neo22s/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/neo22s/subscriptions","organizations_url":"https://api.github.com/users/neo22s/orgs","repos_url":"https://api.github.com/users/neo22s/repos","events_url":"https://api.github.com/users/neo22s/events{/privacy}","received_events_url":"https://api.github.com/users/neo22s/received_events","type":"User","site_admin":false},"assignees":[{"login":"neo22s","id":241725,"avatar_url":"https://avatars.githubusercontent.com/u/241725?v=3","gravatar_id":"","url":"https://api.github.com/users/neo22s","html_url":"https://github.com/neo22s","followers_url":"https://api.github.com/users/neo22s/followers","following_url":"https://api.github.com/users/neo22s/following{/other_user}","gists_url":"https://api.github.com/users/neo22s/gists{/gist_id}","starred_url":"https://api.github.com/users/neo22s/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/neo22s/subscriptions","organizations_url":"https://api.github.com/users/neo22s/orgs","repos_url":"https://api.github.com/users/neo22s/repos","events_url":"https://api.github.com/users/neo22s/events{/privacy}","received_events_url":"https://api.github.com/users/neo22s/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/open-classifieds/openclassifieds2/milestones/35","html_url":"https://github.com/open-classifieds/openclassifieds2/milestones/3.0.0","labels_url":"https://api.github.com/repos/open-classifieds/openclassifieds2/milestones/35/labels","id":1895803,"number":35,"title":"3.0.0","description":"","creator":{"login":"neo22s","id":241725,"avatar_url":"https://avatars.githubusercontent.com/u/241725?v=3","gravatar_id":"","url":"https://api.github.com/users/neo22s","html_url":"https://github.com/neo22s","followers_url":"https://api.github.com/users/neo22s/followers","following_url":"https://api.github.com/users/neo22s/following{/other_user}","gists_url":"https://api.github.com/users/neo22s/gists{/gist_id}","starred_url":"https://api.github.com/users/neo22s/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/neo22s/subscriptions","organizations_url":"https://api.github.com/users/neo22s/orgs","repos_url":"https://api.github.com/users/neo22s/repos","events_url":"https://api.github.com/users/neo22s/events{/privacy}","received_events_url":"https://api.github.com/users/neo22s/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":41,"state":"open","created_at":"2016-07-21T06:42:05Z","updated_at":"2016-10-24T13:58:19Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2016-10-24T10:50:45Z","updated_at":"2016-10-25T17:25:54Z","closed_at":null,"body":"Migrate all tables to innodb.\r\n\r\nSo in the update 300 alter table to innodb and in install use innodb too. \r\n\r\nWe need to see if this process may time out the sites easily...if thats the case only for new installs.\r\n\r\nReview how we fix the full text search - seems we should move better to varchar. Study this option."},"comment":{"url":"https://api.github.com/repos/open-classifieds/openclassifieds2/issues/comments/256102579","html_url":"https://github.com/open-classifieds/openclassifieds2/issues/2115#issuecomment-256102579","issue_url":"https://api.github.com/repos/open-classifieds/openclassifieds2/issues/2115","id":256102579,"user":{"login":"neo22s","id":241725,"avatar_url":"https://avatars.githubusercontent.com/u/241725?v=3","gravatar_id":"","url":"https://api.github.com/users/neo22s","html_url":"https://github.com/neo22s","followers_url":"https://api.github.com/users/neo22s/followers","following_url":"https://api.github.com/users/neo22s/following{/other_user}","gists_url":"https://api.github.com/users/neo22s/gists{/gist_id}","starred_url":"https://api.github.com/users/neo22s/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/neo22s/subscriptions","organizations_url":"https://api.github.com/users/neo22s/orgs","repos_url":"https://api.github.com/users/neo22s/repos","events_url":"https://api.github.com/users/neo22s/events{/privacy}","received_events_url":"https://api.github.com/users/neo22s/received_events","type":"User","site_admin":false},"created_at":"2016-10-25T17:25:54Z","updated_at":"2016-10-25T17:25:54Z","body":"TEXT can be replaced by VARCHAR (65535 - the other varchars in the table)\r\n\r\nFrom the docs:\r\nhttp://dev.mysql.com/doc/refman/5.7/en/string-type-overview.html\r\nVARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns)\r\n\r\nLONGTEXT is a problem :( could be changed to a MEDIUMTEXT that for sure. But can not get rid off TEXT issue....\r\n\r\n\r\n     Type | Maximum length\r\n-----------+-------------------------------------\r\n  TINYTEXT |           255 (2 8−1) bytes\r\n      TEXT |        65,535 (216−1) bytes = 64 KiB\r\nMEDIUMTEXT |    16,777,215 (224−1) bytes = 16 MiB\r\n  LONGTEXT | 4,294,967,295 (232−1) bytes =  4 GiB"}}
{"actor":{"display_login":"neo22s"}}