为什么我的mysql数据库的表创建不了呢?(紧急求助.)

Question

create table people(userID varchar(20), 
                    userName varchar(50), 
                    sex varchar(2), 
                    natuve_place varchar(50), 
                    native varchar(6), 
                    birth_time varchar(10), 
                    polity_name varchar(2), 
                    ID_card varchar(18), 
                    isAffiance varchar(2), 
                    dwelling_place varchar(50), 
                    photo_path varchar(100), 
                    photo_name varchar(20) 
                    constraint P_key primary key(userID,userName),                     
                    constraint P_fkey foreign key(userID) references register(userID) 
   )
在创建主键、外键、索引时应该给个名字，而且定义索引时不应该在创建表时定义，应该另外用SQL语句创建“Create Index..."

Answer 1

我好郁闷啊。为什么定义索引是不能在创建表是定义？
这是我后来改的。在其他机子上可以创建。我的就不行。
什么都不提示。就是给出了：Can`t creat table 'jspdev.people'(errno 150)
这是代码：
create table register(userID varchar(20),
                     pd varchar(20), 
                      email varchar(30),
                      primary key(userID,pd))engine=innodb; create table people(userID varchar(20),
                    userName varchar(50),
                    sex varchar(2),
                    natuve_place varchar(50),
                    native varchar(6),
                    birth_time varchar(10),
                    polity_name varchar(2),
                    ID_card varchar(18),
                    isAffiance varchar(2),
                    dwelling_place varchar(50),
                    photo_path varchar(100),
                    photo_name varchar(20),
                    primary key(userID,userName),
                    index(userID),
                    index(userName),  
                    foreign key(userID) references register(userID) on delete cascade)engine=innodb;create table job(userName varchar(50),
                 start_time varchar(10),
                 end_time varchar(10),
                 company_name varchar(50),
                 department_name varchar(15),
                 duty_name varchar(10),
                 pay smallint,
                 primary key(company_name),
                 index(userName),
                 foreign key(userName) references people(userName)on delete cascade)engine=innodb;那位高手快救救我吧。

Answer 2

发错地方了，这里是mssql,不是mysql