DROP TABLE IF EXISTS `dircms_gather`;
CREATE TABLE `dircms_gather` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `modelid` smallint(4) NOT NULL,
  `cotime` char(10) NOT NULL,
  `addtime` char(10) NOT NULL,
  `code` varchar(10) NOT NULL,
  `urlcounts` mediumint(8) NOT NULL,
  `listsetting` text NOT NULL,
  `itemsetting` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `dircms_gather_tmp`;
CREATE TABLE `dircms_gather_tmp` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `nodeid` mediumint(8) NOT NULL,
  `title` varchar(80) NOT NULL,
  `url` varchar(160) NOT NULL,
  `content` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=318 DEFAULT CHARSET=utf8;
