tables.sql

spring+webwork+iBatis做的VOD系统web端代码。值得学习MVC和持久层的人看。lib太大没上传。所以需要什么lib可要自己去下载。

drop table vod_playactor_category;
create table vod_playactor_category (
	id				int	auto_increment primary key not null,
	category_name	varchar(50)
);


drop table vod_playactor;
create table vod_playactor (
	id			int		auto_increment primary key not null,
	name		varchar(50),
	category_id	int not null,
	movie_id 	int,
	remark		varchar(255)
);

drop table vod_playactor_movie;
create table vod_playactor_movie (
	playactor_id	int,
	movie_id		int
);


drop table vod_category_config;
create table vod_category_config (
	id			int auto_increment primary key not null,
	name		varchar(50) not null,
	parent_id	int
);

drop table vod_category_movie;
create table vod_category_movie (
	movie_id		int,
	category_id		int 	
);

drop table vod_package;
create table vod_package (
	id			int				auto_increment primary key not null,
	name		varchar(100),
	price		float,
	introduction varchar(255),
	remark		varchar(255)
);

drop table vod_package_url;
create table vod_package_url (
	url_id			int not null,
	package_id	int	not null
);


drop table vod_price;
create table vod_price (
	id			int auto_increment primary key not null,
	price		float
);

drop table vod_url;
create table vod_url (
	id			int		auto_increment primary key not null,
	price_id	int		not null,
	movie_id	int		not null,
	url			varchar(255) not null,
	remark		varchar(255)
);

drop table vod_photo_type;
create table vod_photo_type (
	id			int auto_increment primary key not null,
	name		varchar(100) not null,
	remark		varchar(255)	
);

drop table vod_photo;
create table vod_photo (
	id			int	auto_increment primary key not null,
	movie_id		int,
	name		varchar(50),
	url			varchar(200),
	type_id		int,
	remark		varchar(255)		
);

drop table vod_users;
create table vod_users (
	id			int auto_increment primary key not null,
	username	varchar(20),
	password	varchar(20)
);

	
















drop table vod_movie;
create table vod_movie (
	id			int auto_increment primary key not null,
	quality		varchar(4),
	keyword		varchar(255),
	orders		int,
	number		int,
	cn_name		varchar(100),
	en_name		varchar(100),
	area		varchar(50),
	language	varchar(20),
	play_time	int,
	corporation varchar(50),
	show_time	timestamp,
	create_time	timestamp,
	recommend	varchar(255),
	introduction varchar(255),
	grade		int,
	format		varchar(20)
);