[P]mysql 建表[/P][P]CREATE TABLE `leadbbs_selllist` (
`ID` bigint(20) NOT NULL AUTO_INCREMENT,
`PID` bigint(20) NOT NULL DEFAULT '0',
`UserName` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
`PayPoints` int(11) NOT NULL DEFAULT '0',
`GetPoints` int(11) NOT NULL DEFAULT '0',
`SellTime` bigint(20) NOT NULL DEFAULT '0',
`PayFlag` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`),
KEY `IX_LeadBBS_SellList_PayFlag` (`PayFlag`) USING BTREE,
KEY `IX_LeadBBS_SellList_PID` (`PID`) USING BTREE,
KEY `IX_LeadBBS_SellList_SellTime` (`SellTime`) USING BTREE,
KEY `IX_LeadBBS_SellList_UserName` (`UserName`) USING BTREE,
KEY `IX_LeadBBS_SellList_UserNamePayFlag` (`UserName`,`PayFlag`,`ID`) USING BTREE,
KEY `IX_LeadBBS_SellList_UserSellTime` (`UserName`,`PayFlag`,`SellTime`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=679 DEFAULT CHARSET=gbk ROW_FORMAT=COMPACT;[/P] |