- CREATE TABLE `uchome_yake_dianying` (
- `id` int(10) unsigned NOT NULL auto_increment,
- `name` varchar(20) default NULL,
- `name_ot` varchar(30) NOT NULL default '',
- `leader` varchar(20) NOT NULL default '',
- `actor` varchar(100) NOT NULL default '',
- `play_year` char(4) NOT NULL default '',
- `tag` varchar(50) NOT NULL default '',
- `message` text,
- `tuijian` varchar(150) NOT NULL,
- `videopic` mediumtext NOT NULL,
- `pic` varchar(100) NOT NULL default '',
- `has_brand` tinyint(1) unsigned NOT NULL default '0',
- `karma` mediumint(9) unsigned NOT NULL default '0',
- `karma_num` mediumint(9) unsigned NOT NULL default '0',
- `like_num` mediumint(9) unsigned NOT NULL default '0',
- `unlike_num` mediumint(9) unsigned NOT NULL default '0',
- `score` float(2,1) NOT NULL default '5.0',
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`),
- KEY `has_brand` (`has_brand`,`karma`)
- ) ENGINE=MyISAM";
- CREATE TABLE `uchome_yake_dianying_player` (
- `id` INTEGER(10) UNSIGNED NOT NULL,
- `hash` CHAR(32) NOT NULL DEFAULT '',
- `title` VARCHAR(30) DEFAULT '',
- `is_pass` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
- `img` VARCHAR(150) DEFAULT NULL,
- `url` VARCHAR(200) NOT NULL DEFAULT '',
- `ordering` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT '0',
- `waring_num` TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `waring_user` VARCHAR(200) DEFAULT NULL,
- UNIQUE KEY `hash` (`hash`),
- KEY `id` (`id`, `is_pass`)
- ) ENGINE=MyISAM";
- CREATE TABLE `uchome_yake_dianying_reply` (
- `rid` int(10) unsigned NOT NULL auto_increment,
- `id` int(10) unsigned NOT NULL default '0',
- `uid` int(10) unsigned NOT NULL default '0',
- `username` varchar(20) default '',
- `score` tinyint(1) NOT NULL default '0',
- `content` varchar(200) NOT NULL default '',
- `feedid` int(10) unsigned NOT NULL default '0',
- `createdate` int(10) unsigned NOT NULL default '0',
- `reply_num` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
- PRIMARY KEY (`rid`),
- UNIQUE KEY `id` (`id`,`uid`),
- KEY `uid` (`uid`)
- ) ENGINE=MyISAM";
- CREATE TABLE `uchome_yake_dianying_view` (
- `uid` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
- `username` VARCHAR(20) NOT NULL DEFAULT '',
- `id` INTEGER(10) UNSIGNED NOT NULL DEFAULT '0',
- UNIQUE KEY `uid` (`uid`, `id`),
- KEY `id` (`id`)
- )ENGINE=MyISAM";
复制代码 这个是电影插件,我的是UTF的,在DZ粘贴代码老是提示:
升级错误,MySQL 提示: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"' at line 1 ,请返回。
点击这里返回上一页 |