ALTER TABLE `phpup_site` ADD `breaksuff` VARCHAR( 50 ) NOT NULL ;
ALTER TABLE `phpup_site` ADD `limitcity` VARCHAR( 200 ) NOT NULL ;
ALTER TABLE `phpup_site` ADD `limitnum` TINYINT( 5 ) NOT NULL ;
CREATE TABLE IF NOT EXISTS `phpup_othersite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sitename` varchar(50)  NOT NULL,
  `url` varchar(100)  NOT NULL,
  `img` varchar(100)  NOT NULL,
  `cate` int(11) NOT NULL,
  `istop` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
ALTER TABLE `phpup_othersite` ADD `recommend` int(11) NOT NULL;


CREATE TABLE IF NOT EXISTS `phpup_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) NOT NULL,
  `url` varchar(100) NOT NULL,
  `decs` varchar(200) NOT NULL,
  `type` smallint(1) NOT NULL,
  `thumb` varchar(50) NOT NULL,
  `sortorder` int(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
ALTER TABLE `phpup_othersite` ADD `color` varchar(20) NOT NULL;
ALTER TABLE `phpup_othersite` ADD `font` varchar(20) NOT NULL;
ALTER TABLE `phpup_othersite` ADD `sort` int(11) NOT NULL DEFAULT '0';


ALTER TABLE `phpup_site` ADD `localapi` VARCHAR( 200 ) NOT NULL AFTER `siteapi` ;