pre_forum_postposition
抢楼帖时会用到
CREATE TABLE `pre_forum_postposition` ( `tid` mediumint(8) unsigned NOT NULL, `position` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(10) unsigned NOT NULL, PRIMARY KEY (`tid`,`position`), KEY `pid` (`pid`)) ENGINE=MyISAM DEFAULT CHARSET=gbk
主键是`tid`,`position`， 当插入 insert into pre_forum_postposition set tid=1128898, pid=2814945;
`position` 以 `tid` `pid` 为区分在该条件下自增
| 1128898 | 38 | 2811923 || 1128898 | 39 | 2814943 |
insert into pre_forum_postposition set tid=1128898, pid=2814945;
| 1128898 | 39 | 2814943 || 1128898 | 40 | 2814945 |
转载于:https://www.cnblogs.com/bandbandme/p/4262013.html
相关资源：数据结构—成绩单生成器