album.sql

这是基于jsp的相册管理系统。数据库是mysql

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)