create table tb_user
(
user_id int(100) not null auto_increment,
user_name varchar(200) not null default'',
user_password varchar(1000)not null,
user_phone varchar(1000),
user_typeint(10)not null,
user_emailvarchar(2000) not null,
user_imgvarchar(2000) default null,
create_time datetime default null,
last_edit_time datetime default null,
primary key(user_id)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

create table tb_lost
(
lost_idint(100)not null auto_increment,
lost_typevarchar(2000) not null,
lost_placevarchar(2000)not null,
lost_user_idint(100)not null,
lost_user_namevarchar(2000)not null,
lost_phonevarchar(1000) not null,
lost_time varchar(2000) not null,
take_time varchar(2000) not null,
lost_img varchar(2000) not null,
primary key(lost_id),
constraint fk_lostuser_idforeign key(lost_user_id) references tb_user(user_id)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

create table tb_pick
(
pick_idint(100)not null auto_increment,
pick_typevarchar(2000) not null,
pick_placevarchar(2000)not null,
pick_user_idint(100)not null,
pick_user_namevarchar(2000)not null,
pick_phonevarchar(1000) not null,
pick_time varchar(2000) not null,
take_time varchar(2000) not null,
pick_img varchar(2000) not null,
primary key(pick_id),
constraint fk_pcikuser_idforeign key(pick_user_id) references tb_user(user_id)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

create table ly_info
(
ly_info_idint(100)not null auto_increment,
ly_user_idint(100)not null,
ly_txtvarchar(2000)not null,
ly_timevarchar(2000)not null,
primary key(ly_info_id),
constraint fk_ly_idforeign key(ly_user_id) referencestb_user(user_id)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

create table hf_info
(
hf_idint(100)not null auto_increment,
hf_info_idint(100)not null,
hf_user_idint(100)not null,
hf_txtvarchar(2000)not null,
hf_timevarchar(2000)not null,
primary key(hf_info_id),
constraint hf_info_id foreign key(ly_info_id)referencesly_info(hf_info_id),
constraintfk_hf_id foreign key(hf_user_id)referencestb_user(hf_user_id)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

create table gg_info
(
gg_idint(100)not null auto_increment,
gg_txtvarchar(2000)not null,
gg_timedatetime not null,
primary key(gg_id)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
第四张表的约束外键约束有问题，为什么

新手求指教类似百度文库模式的代码

wtcwater

4个回复