{"action":"created","issue":{"url":"https://api.github.com/repos/CAPU-ENG/CAPUHome-API/issues/6","labels_url":"https://api.github.com/repos/CAPU-ENG/CAPUHome-API/issues/6/labels{/name}","comments_url":"https://api.github.com/repos/CAPU-ENG/CAPUHome-API/issues/6/comments","events_url":"https://api.github.com/repos/CAPU-ENG/CAPUHome-API/issues/6/events","html_url":"https://github.com/CAPU-ENG/CAPUHome-API/issues/6","id":85532123,"number":6,"title":"论坛数据库重构方案","user":{"login":"JeldorPKU","id":8514953,"avatar_url":"https://avatars.githubusercontent.com/u/8514953?v=3","gravatar_id":"","url":"https://api.github.com/users/JeldorPKU","html_url":"https://github.com/JeldorPKU","followers_url":"https://api.github.com/users/JeldorPKU/followers","following_url":"https://api.github.com/users/JeldorPKU/following{/other_user}","gists_url":"https://api.github.com/users/JeldorPKU/gists{/gist_id}","starred_url":"https://api.github.com/users/JeldorPKU/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JeldorPKU/subscriptions","organizations_url":"https://api.github.com/users/JeldorPKU/orgs","repos_url":"https://api.github.com/users/JeldorPKU/repos","events_url":"https://api.github.com/users/JeldorPKU/events{/privacy}","received_events_url":"https://api.github.com/users/JeldorPKU/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/CAPU-ENG/CAPUHome-API/labels/task","name":"task","color":"bfd4f2"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":12,"created_at":"2015-06-05T13:21:40Z","updated_at":"2015-07-09T08:05:49Z","closed_at":null,"body":"这里说的只是**论坛**的数据库，不含其他模块。目前已经成熟的改进方案是：\r\n- 用`threads`和`posts`两个表来存储帖子；\r\n- 每个帖子有唯一的tid，版面也要标记，但是tid能唯一确定一个帖子；\r\n- 用发帖时间来对帖子进行排序，去掉pid，用算法来分页排楼；\r\n- ...\r\n\r\n欢迎补充。"},"comment":{"url":"https://api.github.com/repos/CAPU-ENG/CAPUHome-API/issues/comments/119866268","html_url":"https://github.com/CAPU-ENG/CAPUHome-API/issues/6#issuecomment-119866268","issue_url":"https://api.github.com/repos/CAPU-ENG/CAPUHome-API/issues/6","id":119866268,"user":{"login":"zhzhzoo","id":5500555,"avatar_url":"https://avatars.githubusercontent.com/u/5500555?v=3","gravatar_id":"","url":"https://api.github.com/users/zhzhzoo","html_url":"https://github.com/zhzhzoo","followers_url":"https://api.github.com/users/zhzhzoo/followers","following_url":"https://api.github.com/users/zhzhzoo/following{/other_user}","gists_url":"https://api.github.com/users/zhzhzoo/gists{/gist_id}","starred_url":"https://api.github.com/users/zhzhzoo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zhzhzoo/subscriptions","organizations_url":"https://api.github.com/users/zhzhzoo/orgs","repos_url":"https://api.github.com/users/zhzhzoo/repos","events_url":"https://api.github.com/users/zhzhzoo/events{/privacy}","received_events_url":"https://api.github.com/users/zhzhzoo/received_events","type":"User","site_admin":false},"created_at":"2015-07-09T08:05:49Z","updated_at":"2015-07-09T08:05:49Z","body":"咳咳要不我们这样吧：把原来数据库的 sql 文件（也可以是别的语言写的 ddl）传到 repo 里，然后改这个文件，交 pr"}}