MySQL里AUTO_INCREMENT表里插入0值的问题

昨天在搞给注册的玩家自动发放avatar item的问题，最后还是决定在DB这一级来做。

自己写了一个trigger, 目前是在AccountStat这个表插入时来触发。当然是不是放在Account表，CharacterAttr表或者GameCharacter表上会更好，还是要了解清楚注册的流程才能定。

主要的问题不在这里，在调试的过程中，发现男性的默认脸部的ItemID是0，往PlayerItem里插入里也是写的0这个ID。

可是到Item表里一看，奇怪，根本就没有ID为0的数据，怎么回事呢？查出一下Item的生成脚本和插入数据的脚本：

 

 

 

 

 注意这里每3行里的"`ItemID` int(10) unsigned NOT NULL auto_increDROP TABLE IF EXISTS `Item`; CREATE TABLE `Item` ( `ItemID` int(10) unsigned NOT NULL auto_increment, `ItemTypeID` tinyint(1) NOT NULL, `Gender` tinyint(1) default NULL COMMENT 'indicate which gender the item is used by. 0:man 1:woman 2:both', `Description` varchar(64) default NULL, `ItemName` varchar(64) default NULL, PRIMARY KEY (`ItemID`,`ItemTypeID`), KEY `ItemTypeID` (`ItemTypeID`) ) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8; INSERT INTO `Item` VALUES ('0','0','0',' ','MFace1'), ('1','0','0',' ','MFace2'), ('2','0','0',' ','MFace3'), ('3','0','1','','FFace1'), ('4','0','1','','FFace2'), ('5','0','1','','FFace3'), ('7','2','1','','FHair1'), ('9','2','1','','FHair2'), ('11','2','1','','FHair3'), ('13','2','1','','FHair4'), ('15','2','0',' ','MHair1'), ('17','2','0',' ','MHair2'), ('19','2','0',' ','MHair3'), ('21','3','1','','FCloth1'), ('22','3','1','','FCloth2'), ('23','3','1','','FCloth3'), ('24','3','1','','FCloth4'), ('28','3','0',' ','MCloth1'), ('29','3','0',' ','MCloth2'), ('30','3','0',' ','MCloth3'), ('31','3','0',' ','MCloth4'), ('39','0','0',' ','MFace1'), ('42','4','1',' ','FGlass1'), ('43','4','1',' ','FGlass2'), ('44','4','1',' ','FGlass3'), ('45','4','1',' ',