为 mysql 数据表添加主键

DROP TABLE IF EXISTS `sdo_actData`.`actCDKey`;CREATE TABLE `sdo_actData`.`actCDKey` (  `RoleID` ) ' COMMENT '玩家ID',  `CDKey` ) NOT NULL default '' COMMENT 'CDKey',  `ZoneID` ) ' COMMENT '大区号',  `PlatID` ) ' COMMENT '平台号',  `Type` ) ' COMMENT '类型',  `SubType` ) ' COMMENT '子类型',  `Serial` ) ' COMMENT '序列号',  `GotTime` ) ' COMMENT '领取时间',  PRIMARY KEY  (`CDKey`),  KEY `RoleID` USING BTREE (`RoleID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;ALTER TABLE `sdo_actData`.`inviteCode` ADD INDEX InviteCode (`InviteCode`);ALTER TABLE `sdo_actData`.`inviteCode` ADD INDEX AccepterID (`AccepterID`);ALTER TABLE `sdo_actData`.`inviteCode` ADD INDEX DeviceID (`DeviceID`);