-- --------------------------------------------------------
--
-- 表的结构 `mc_article_cate`
--
CREATE TABLE IF NOT EXISTS `mc_article_cate` (
`id` int(10) unsigned NOT NULL auto_increment,
`parentid` int(10) default NULL,
`level` char(50) default NULL,
`title` char(100) default NULL,
`templateid` int(10) default NULL,
`forumid` int(10) default NULL,
`catetemplateid` int(10) default NULL,
`dir` char(100) default NULL,
`kind` tinyint(4) default '0' COMMENT '显示方式',
`pagesize` tinyint(4) default '0' COMMENT '显示条数',
`specialid` int(10) default '0' COMMENT '对应专题编号',
`url` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='cate' AUTO_INCREMENT=40 ;
--
-- 转存表中的数据 `mc_article_cate`
--
INSERT INTO `mc_article_cate` (`id`, `parentid`, `level`, `title`, `templateid`, `forumid`, `catetemplateid`, `dir`, `kind`, `pagesize`, `specialid`, `url`) VALUES
(1, 0, '01', '测试大类', 9, NULL, 9, '/test/', 0, 0, 0, ''),
(3, 0, '03', '楼盘调用', NULL, NULL, NULL, 'getbuild', 0, 0, 0, ''),
(4, 0, '04', '学习环境', NULL, NULL, NULL, '/asdf/', 0, 0, 0, ''),
(5, 0, '05', '报名方式', NULL, NULL, NULL, NULL, 0, 0, 0, ''),
(6, 0, '06', '学员作品', NULL, NULL, NULL, NULL, 0, 0, 0, ''),
(7, 0, '07', '校院合作', NULL, NULL, NULL, NULL, 0, 0, 0, ''),
(38, 0, '17', '购房宝典', 2, NULL, 2, 'baodian', 0, 0, 0, ''),
(25, 6, '0601', '插画学员作品', NULL, NULL, NULL, NULL, 0, 0, 0, 'works.php'),
(26, 6, '0602', '动画学员作品', NULL, NULL, NULL, NULL, 0, 0, 0, 'works.php'),
(28, 0, '08', '调用文章', NULL, NULL, NULL, NULL, 0, 0, 0, ''),
(29, 3, '0301', '新上市', NULL, NULL, NULL, 'getbuild/new', 0, 0, 0, ''),
(30, 3, '0302', '本月开盘', NULL, NULL, NULL, 'getbuild/this', 0, 0, 0, ''),
(31, 3, '0303', '下月开盘', NULL, NULL, NULL, 'getbuild/next', 0, 0, 0, ''),
(32, 25, '060101', '第一期', NULL, NULL, NULL, NULL, 0, 0, 0, ''),
(33, 25, '060102', '第二期', NULL, NULL, NULL, NULL, 0, 0, 0, ''),
(34, 25, '060103', '第三期', NULL, NULL, NULL, NULL, 0, 0, 0, ''),
(35, 25, '060104', '第四期', NULL, NULL, NULL, NULL, 0, 0, 0, ''),
(36, 26, '060201', '第一期', NULL, NULL, NULL, NULL, 0, 0, 0, ''),
(39, 1, '0101', 'sf', 9, NULL, 2, '/test/sub/', 0, 0, 0, '');
视图代码：
复制代码 代码如下: