{"comment":{"created_at":"2011-10-18T15:11:20Z","body":"The commit above has been deleted it was on the wrong bug.","updated_at":"2011-10-18T15:11:20Z","url":"https://api.github.com/repos/openphoto/frontend/issues/comments/2442911","id":2442911,"user":{"avatar_url":"https://secure.gravatar.com/avatar/df9b23c550b548fb8b5779e897d3d39e?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"df9b23c550b548fb8b5779e897d3d39e","url":"https://api.github.com/users/hfiguiere","id":114441,"login":"hfiguiere"}},"action":"created","issue":{"number":186,"created_at":"2011-10-04T03:58:30Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"Have a couple thoughts on the MySql configuration. These are primarily to allow for features to be added without requiring a schema upgrade.\r\n\r\n1. The `user` table to have 2 columns: `id` and `meta` and make `meta` a TEXT field storing JSON. Inspired by an exception after adding \"groups\" and there not being a lastGroupId column.\r\n1. The `photo` table has an `exif` column. We can either make that general purpose (anything which won't need to be searched or sorted) or have another column for that. I remember we did talk about this earlier, so just bringing it back up.\r\n\r\n","comments":1,"title":"MySql schema considerations","updated_at":"2011-10-18T15:11:20Z","url":"https://api.github.com/repos/openphoto/frontend/issues/186","id":1810130,"assignee":{"avatar_url":"https://secure.gravatar.com/avatar/df9b23c550b548fb8b5779e897d3d39e?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"df9b23c550b548fb8b5779e897d3d39e","url":"https://api.github.com/users/hfiguiere","id":114441,"login":"hfiguiere"},"milestone":null,"closed_at":null,"user":{"avatar_url":"https://secure.gravatar.com/avatar/e4d1f099d40e3b453be3355349b90457?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"e4d1f099d40e3b453be3355349b90457","url":"https://api.github.com/users/jmathai","id":6384,"login":"jmathai"},"html_url":"https://github.com/openphoto/frontend/issues/186","labels":[{"name":"Release 1.3","url":"https://api.github.com/repos/openphoto/frontend/labels/Release+1.3","color":"e102d8"}],"state":"open"},"legacy":{"issue_id":1810130,"comment_id":2442911}}