--
-- 表的结构 `dy_classtype`
--
CREATE TABLE IF NOT EXISTS `dy_classtype` (
`tid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`molds` char(20) NOT NULL,
`pid` smallint(5) unsigned NOT NULL DEFAULT '0',
`classname` char(50) NOT NULL,
`enname` varchar(255) NOT NULL,
`gourl` char(255) NOT NULL,
`litpic` char(200) NOT NULL,
`title` char(100) NOT NULL,
`keywords` char(255) NOT NULL,
`description` varchar(300) NOT NULL,
`isindex` tinyint(1) unsigned NOT NULL DEFAULT '1',
`t_index` char(50) NOT NULL,
`t_list` char(50) NOT NULL,
`t_listimg` char(50) NOT NULL,
`t_listb` char(50) NOT NULL,
`t_content` char(50) NOT NULL,
`listnum` mediumint(8) unsigned NOT NULL DEFAULT '0',
`htmldir` char(100) NOT NULL,
`htmlfile` char(100) NOT NULL,
`mrank` smallint(5) NOT NULL DEFAULT '0',
`msubmit` smallint(5) NOT NULL DEFAULT '0',
`orders` int(10) NOT NULL DEFAULT '0',
`body` mediumtext NOT NULL,
`mshow` tinyint(1) unsigned NOT NULL DEFAULT '1',
`imgw` smallint(5) unsigned NOT NULL DEFAULT '0',
`imgh` smallint(5) unsigned NOT NULL DEFAULT '0',
`unit` char(20) NOT NULL,
PRIMARY KEY (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;
--
-- 转存表中的数据 `dy_classtype`
--
INSERT INTO `dy_classtype` (`tid`, `molds`, `pid`, `classname`, `enname`, `gourl`, `litpic`, `title`, `keywords`, `description`, `isindex`, `t_index`, `t_list`, `t_listimg`, `t_listb`, `t_content`, `listnum`, `htmldir`, `htmlfile`, `mrank`, `msubmit`, `orders`, `body`, `mshow`, `imgw`, `imgh`, `unit`) VALUES
(34, 'sqcx', 0, '授权查询', '', '', '', '授权查询', '', '', 3, 'list_index.html', 'list.html', 'list_image.html', 'list_body.html', 'content.html', 9, '', '', 0, 0, 0, '', 0, 0, 0, ''),
(33, 'message', 0, '代理加盟', '', '', '', '代理加盟', '', '', 1, 'message.html', 'message.html', 'message.html', 'message.html', 'message.html', 9, '', '', 0, 1, 0, '', 0, 0, 0, ''),
(32, 'article', 0, '联系我们', '', '', '', '联系我们', '', '', 3, 'list_index.html', 'list.html', 'list_image.html', 'list_body.html', 'article.html', 9, '', '', 0, 0, 0, '', 0, 0, 0, ''),
(31, 'article', 0, '品牌故事', '', '', '', '品牌故事', '', '', 2, 'list_index.html', 'list.html', 'list_image3.html', 'list_body.html', 'article.html', 9, '', '', 0, 0, 0, '', 1, 0, 0, ''),
(30, 'article', 0, '案例分享', '', '', '', '案例分享', '', '', 2, 'list_index.html', 'list.html', 'list_image2.html', 'list_body.html', 'article.html', 9, '', '', 0, 0, 0, '', 1, 0, 0, ''),
(29, 'article', 0, '成分解析', '', '', '', '成分解析', '', '', 3, 'list_index.html', 'list.html', 'list_image.html', 'list_body.html', 'article.html', 9, '', '', 0, 0, 0, '', 1, 0, 0, ''),
(27, 'article', 0, '本季活动', '', '', '', '本季活动', '', '', 1, 'list_index.html', 'list.html', 'list_image.html', 'list_body.html', 'article.html', 9, '', '', 0, 0, 0, '', 1, 0, 0, ''),
(28, 'article', 0, '产品中心', '', '', '', '产品中心', '', '', 2, 'list_index.html', 'list.html', 'list_image.html', 'list_body.html', 'article.html', 9, '', '', 0, 0, 0, '', 1, 0, 0, '');
-- --------------------------------------------------------
--