mysql.sql

来自「开源jsp电子相册网站 开源jsp电子相册网站」· SQL 代码 · 共 42 行

# --------------------------------------------------------

#
# table structure for table `album_config`
#

drop table if exists `album_config`;
create table `album_config` (
  `id` int(8) not null auto_increment,
  `udirectory` varchar(20) default null,
  `cols` int(8) default null,
  `rows` int(8) default null,
  `twidth` int(8) default null,
  `theight` int(8) default null,
  `password` varchar(20) default null,
  primary key  (`id`)
) type=myisam auto_increment=2 ;

#
# dumping data for table `album_config`
#

insert into `album_config` values (1, 'photos', 4, 3, 130, 130, '123456');

# --------------------------------------------------------

#
# table structure for table `album_photos`
#

drop table if exists `album_photos`;
create table `album_photos` (
  `id` int(8) not null auto_increment,
  `name` varchar(20) default null,
  `filename` varchar(20) default null,
  `size` int(8) default null,
  `width` int(8) default null,
  `height` int(8) default null,
  `udate` timestamp(14) not null,
  `description` varchar(100) default null,
  primary key  (`id`)
) type=myisam;