诗人刚刚删电影站数据库中VOD表的数据,不小心把表删了。
找到以前备份的数据库,拷出VOD那段的代码。
解决办法如下:
[code]
CREATE TABLE IF NOT EXISTS 表前缀(这个自行修改,诗人直接复制我的备份,所以隐去)_vod
(
vod_id
mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
vod_cid
smallint(6) NOT NULL,
vod_name
varchar(255) NOT NULL,
vod_title
varchar(255) NOT NULL,
vod_keywords
varchar(255) NOT NULL,
vod_color
char(8) NOT NULL,
vod_actor
varchar(255) NOT NULL,
vod_director
varchar(255) NOT NULL,
vod_content
text NOT NULL,
vod_pic
varchar(255) NOT NULL,
vod_area
char(10) NOT NULL,
vod_language
char(10) NOT NULL,
vod_year
smallint(4) NOT NULL,
vod_continu
varchar(20) NOT NULL DEFAULT '0',
vod_addtime
int(11) NOT NULL,
vod_hits
mediumint(8) NOT NULL DEFAULT '0',
vod_stars
tinyint(1) NOT NULL DEFAULT '0',
vod_del
tinyint(1) NOT NULL DEFAULT '0',
vod_up
mediumint(8) NOT NULL DEFAULT '0',
vod_down
mediumint(8) NOT NULL DEFAULT '0',
vod_play
varchar(255) NOT NULL,
vod_server
varchar(255) NOT NULL,
vod_url
longtext NOT NULL,
vod_inputer
varchar(30) NOT NULL,
vod_reurl
varchar(255) NOT NULL,
vod_letter
char(2) NOT NULL,
vod_skin
varchar(30) NOT NULL,
vod_gold
decimal(3,1) NOT NULL,
vod_golder
smallint(6) NOT NULL,
PRIMARY KEY (vod_id
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=33278 ;
[/code]
会员登录关闭
注册会员关闭