album.sql

来自「这是基于jsp的相册管理系统。数据库是mysql」· SQL 代码 · 共 13 行

create table album
(
 albumId varchar(20) not null ,
 ownerId varchar(15) not null ,
 albumName nvarchar(15) not null,
 albumPWD  varchar(20),
 albumDesc  nvarchar(100),
 albumType int(5) not null,
  albumState int(5) default 0 not null,
  albumCheck int(5) not null,
  primary key(albumId,ownerId)
);
 foreign key(albumId) references users(userName)