{"action":"created","issue":{"url":"https://api.github.com/repos/TheSophon/sophon/issues/3","labels_url":"https://api.github.com/repos/TheSophon/sophon/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/TheSophon/sophon/issues/3/comments","events_url":"https://api.github.com/repos/TheSophon/sophon/issues/3/events","html_url":"https://github.com/TheSophon/sophon/issues/3","id":118661024,"number":3,"title":"Discussion about database design","user":{"login":"brickgao","id":2117598,"avatar_url":"https://avatars.githubusercontent.com/u/2117598?v=3","gravatar_id":"","url":"https://api.github.com/users/brickgao","html_url":"https://github.com/brickgao","followers_url":"https://api.github.com/users/brickgao/followers","following_url":"https://api.github.com/users/brickgao/following{/other_user}","gists_url":"https://api.github.com/users/brickgao/gists{/gist_id}","starred_url":"https://api.github.com/users/brickgao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/brickgao/subscriptions","organizations_url":"https://api.github.com/users/brickgao/orgs","repos_url":"https://api.github.com/users/brickgao/repos","events_url":"https://api.github.com/users/brickgao/events{/privacy}","received_events_url":"https://api.github.com/users/brickgao/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TheSophon/sophon/labels/database","name":"database","color":"d4c5f9"},{"url":"https://api.github.com/repos/TheSophon/sophon/labels/discussion","name":"discussion","color":"eb6420"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-11-24T17:18:01Z","updated_at":"2015-11-24T17:20:25Z","closed_at":null,"body":"Let's discuss database design in this issue and update the result to wiki.\r\n\r\n## MySQL\r\n\r\n### user_meta\r\n\r\n|Column|Description|\r\n|---|---|\r\n|id|Auto-increment primary id|\r\n|username|Name of user|\r\n|created|Created timestamp of user|\r\n|type|Type of user, 1 represent dev, 2 represent ops|\r\n|password| Password after `passlib.hash.sha256_crypt.encrypt`|\r\n\r\n```sql\r\nCREATE TABLE `user_meta` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `username` varchar(100) DEFAULT NULL,\r\n  `created` date DEFAULT NULL,\r\n  `type` tinyint(4) NOT NULL,\r\n  `password` varchar(100) NOT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET=utf8;\r\n```"},"comment":{"url":"https://api.github.com/repos/TheSophon/sophon/issues/comments/159346665","html_url":"https://github.com/TheSophon/sophon/issues/3#issuecomment-159346665","issue_url":"https://api.github.com/repos/TheSophon/sophon/issues/3","id":159346665,"user":{"login":"brickgao","id":2117598,"avatar_url":"https://avatars.githubusercontent.com/u/2117598?v=3","gravatar_id":"","url":"https://api.github.com/users/brickgao","html_url":"https://github.com/brickgao","followers_url":"https://api.github.com/users/brickgao/followers","following_url":"https://api.github.com/users/brickgao/following{/other_user}","gists_url":"https://api.github.com/users/brickgao/gists{/gist_id}","starred_url":"https://api.github.com/users/brickgao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/brickgao/subscriptions","organizations_url":"https://api.github.com/users/brickgao/orgs","repos_url":"https://api.github.com/users/brickgao/repos","events_url":"https://api.github.com/users/brickgao/events{/privacy}","received_events_url":"https://api.github.com/users/brickgao/received_events","type":"User","site_admin":false},"created_at":"2015-11-24T17:20:25Z","updated_at":"2015-11-24T17:20:25Z","body":"@DevilBin @gracegreat1 Any comments?"}}