执行SQL
全新安装数据表
--
-- 表的结构 `uchome_attention`
--
CREATE TABLE IF NOT EXISTS `uchome_attention` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(80) NOT NULL,
`imgurl` varchar(255) NOT NULL,
`imglink` varchar(255) character set geostd8 NOT NULL,
`content` mediumtext NOT NULL,
`islunar` tinyint(1) NOT NULL default '0',
`startime` int(10) NOT NULL default '0',
`endtime` int(10) NOT NULL default '0',
`isactive` tinyint(1) NOT NULL default '0',
`aorder` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=5 ;
升级数据表:
ALTER TABLE `uchome_attention` ADD `imglink` VARCHAR( 255 ) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL AFTER `imgurl` ,
ADD `aorder` INT( 10 ) NOT NULL DEFAULT '0' AFTER `isactive`; |