{"action":"created","issue":{"url":"https://api.github.com/repos/jquery/themeroller.css-chassis.com/issues/7","labels_url":"https://api.github.com/repos/jquery/themeroller.css-chassis.com/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/jquery/themeroller.css-chassis.com/issues/7/comments","events_url":"https://api.github.com/repos/jquery/themeroller.css-chassis.com/issues/7/events","html_url":"https://github.com/jquery/themeroller.css-chassis.com/issues/7","id":90738105,"number":7,"title":"Database schema (mysql)","user":{"login":"geekman-rohit","id":7365362,"avatar_url":"https://avatars.githubusercontent.com/u/7365362?v=3","gravatar_id":"","url":"https://api.github.com/users/geekman-rohit","html_url":"https://github.com/geekman-rohit","followers_url":"https://api.github.com/users/geekman-rohit/followers","following_url":"https://api.github.com/users/geekman-rohit/following{/other_user}","gists_url":"https://api.github.com/users/geekman-rohit/gists{/gist_id}","starred_url":"https://api.github.com/users/geekman-rohit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/geekman-rohit/subscriptions","organizations_url":"https://api.github.com/users/geekman-rohit/orgs","repos_url":"https://api.github.com/users/geekman-rohit/repos","events_url":"https://api.github.com/users/geekman-rohit/events{/privacy}","received_events_url":"https://api.github.com/users/geekman-rohit/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-06-24T17:25:57Z","updated_at":"2015-06-26T16:11:03Z","closed_at":null,"body":"Decide a database schema to use.\r\n\r\nI am  currently considering something like this : \r\n```sql\r\ncreate table theme (\r\n\tid int unsigned not null auto_increment,\r\n\tname varchar(50),\r\n\tdata TEXT,\r\n\tkeywords varchar(100),\r\n\tcreated TIMESTAMP DEFAULT 0 not null,\r\n\tupdated TIMESTAMP DEFAULT 0 ON UPDATE CURRENT_TIMESTAMP,\r\n\tprimary key(id),\r\n\tindex(name)\r\n)\r\n```\r\ndata will hold the full json data of theme stringified with a JSON.stringify\r\n\r\nI would love suggestions/ better options on this"},"comment":{"url":"https://api.github.com/repos/jquery/themeroller.css-chassis.com/issues/comments/115743343","html_url":"https://github.com/jquery/themeroller.css-chassis.com/issues/7#issuecomment-115743343","issue_url":"https://api.github.com/repos/jquery/themeroller.css-chassis.com/issues/7","id":115743343,"user":{"login":"geekman-rohit","id":7365362,"avatar_url":"https://avatars.githubusercontent.com/u/7365362?v=3","gravatar_id":"","url":"https://api.github.com/users/geekman-rohit","html_url":"https://github.com/geekman-rohit","followers_url":"https://api.github.com/users/geekman-rohit/followers","following_url":"https://api.github.com/users/geekman-rohit/following{/other_user}","gists_url":"https://api.github.com/users/geekman-rohit/gists{/gist_id}","starred_url":"https://api.github.com/users/geekman-rohit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/geekman-rohit/subscriptions","organizations_url":"https://api.github.com/users/geekman-rohit/orgs","repos_url":"https://api.github.com/users/geekman-rohit/repos","events_url":"https://api.github.com/users/geekman-rohit/events{/privacy}","received_events_url":"https://api.github.com/users/geekman-rohit/received_events","type":"User","site_admin":false},"created_at":"2015-06-26T16:11:03Z","updated_at":"2015-06-26T16:11:03Z","body":"@aulvi , we also need some opinion for type of column to use in case of `data`  which will contain a large json data , probably encoded using JSON.stringify.. number of variables can get seriously high with time"}}