CREATETABLE`noteplan_0000000002`(`NP_ID`char(10)NOTNULL,`NP_Type`char(7),`Creater_ID`char(10)NOTNULL,`NP_Item`char(40)NOTNULL,`NP_CreateDate`datetimeNOTNULL,`NP_Begin`dat...
CREATE TABLE `noteplan_0000000002` (
`NP_ID` char(10) NOT NULL,
`NP_Type` char(7),
`Creater_ID` char(10) NOT NULL,
`NP_Item` char(40) NOT NULL,
`NP_CreateDate` datetime NOT NULL,
`NP_Begin` datetime NOT NULL,
`NP_End` datetime NOT NULL,
`NP_Over` int(11) NOT NULL,
`NP_Remarks` varchar(280) DEFAULT NULL,
PRIMARY KEY (`NP_ID`),
KEY `creater_fk1_idx` (`Creater_ID`),
CONSTRAINT `creater_fk2` FOREIGN KEY (`Creater_ID`) REFERENCES `d_user` (`U_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
建不了,错误为外键问题~
d_user 里面的U_ID是主键 非空 char(20)
CREATE TABLE T_Name
(
`F_ID` char(20) NOT NULL,
`U_ID` char(20) DEFAULT NULL,
`F_Name` char(20) NOT NULL,
PRIMARY KEY (`F_ID`),
KEY `U_ID` (`U_ID`),
CONSTRAINT `friend_fk` FOREIGN KEY(`U_ID`) REFERENCES `d_user` (`U_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
我这个就可以创建成功
展开