Re: ERROR 1005 (HY000): Can't create table 'myTable' (errno: 708)
CREATE TABLE `user` (
`UID` int( 11 ) NOT NULL AUTO_INCREMENT ,
`UEmail` varchar( 64 ) NOT NULL ,
`tempEmail` varchar( 64 ) default NULL ,
`UPassword` varchar( 32 ) NOT NULL ,
`UNickName` varchar( 32 ) NOT NULL ,
`URealName` varchar( 16 ) default NULL ,
`ULocation` varchar( 32 ) default NULL ,
`USex` enum( '男', '女', '保密' ) NOT NULL default '保密',
`UBirthday` date default NULL ,
`UQQ` varchar( 12 ) default NULL ,
`UProvince` varchar( 32 ) default NULL ,
`UCity` varchar( 32 ) default NULL ,
`UEducation` varchar( 32 ) default NULL ,
`UWork` varchar( 32 ) default NULL ,
`USite` varchar( 64 ) default NULL ,
`UFace` varchar( 255 ) NOT NULL default 'candle.png',
`UIntro` text,
`USign` text,
`UIDCard` varchar( 18 ) default NULL ,
`UAdreess` varchar( 255 ) default NULL ,
`UPostNum` varchar( 6 ) default NULL ,
`UBank` varchar( 32 ) default NULL ,
`USubBank` varchar( 32 ) default NULL ,
`UAccounts` varchar( 32 ) default NULL ,
`UMPhone` varchar( 16 ) default NULL ,
`UPhone` varchar( 16 ) default NULL ,
`UState` tinyint( 1 ) NOT NULL default '0' COMMENT '闪客状态,0为个人,1为团体',
`UActive` tinyint( 1 ) NOT NULL default '0',
`GID` tinyint( 4 ) default '10',
`SID` int( 11 ) NOT NULL default '0',
`RegTime` datetime NOT NULL ,
`RegIP` varchar( 40 ) default NULL ,
`LoginCounter` int( 11 ) NOT NULL default '0',
`LastLoginTime` datetime default NULL ,
`LoginTime` datetime default NULL ,
`ActiveTime` int( 11 ) NOT NULL default '0',
`ActivePoint` int( 11 ) NOT NULL default '0',
`NumSwf` int( 11 ) NOT NULL default '0',
`NumSwfDown` int( 11 ) NOT NULL default '0',
`NumTopic` int( 11 ) NOT NULL default '0',
`NumReply` int( 11 ) NOT NULL default '0',
`NumMark` int( 11 ) NOT NULL default '0',
`NumRemark` int( 11 ) NOT NULL default '0',
`PointStd` int( 11 ) NOT NULL default '0',
`PointPro` int( 11 ) NOT NULL default '0',
`IsReturn` tinyint( 1 ) NOT NULL default '0',
`IsPro` tinyint( 1 ) NOT NULL default '0',
`DelayTimes` tinyint( 4 ) NOT NULL default '0',
`AutoPay` tinyint( 1 ) NOT NULL default '0',
PRIMARY KEY ( `UID` )
) ENGINE = NDBCLUSTER DEFAULT CHARSET = gbk COMMENT = '用户' AUTO_INCREMENT =10019
MySQL 返回:
#1005 - Can't create table './xsj_library/user.frm' (errno: 708)