巫师的蜕变

导航

 

首先给usercategory表新增libraryid字段:

alter table usercategory add libraryid varchar(50)

 修改picturelibrary表的libraryid字段为表usercategory的外键

alter table usercategory add constraint libraryid foreign key(libraryid) references picturelibrary(libraryid)

 

posted on 2017-06-29 09:50  jacunjpg  阅读(6079)  评论(0编辑  收藏  举报