E_D("DROP TABLE IF EXISTS `db_cat`;"); $this->E_C("CREATE TABLE `db_cat` ( `catid` smallint(11) NOT NULL AUTO_INCREMENT, `modelid` int(11) NOT NULL, `lang` varchar(10) DEFAULT '' COMMENT '语言', `pubid` bigint(15) NOT NULL, `classpath` varchar(255) NOT NULL DEFAULT '', `table_name` varchar(100) NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `infonum` int(11) NOT NULL COMMENT '信息条数', `lencord` smallint(5) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) NOT NULL DEFAULT '0', `sort` smallint(6) unsigned NOT NULL, `pid` smallint(6) unsigned NOT NULL, `level` tinyint(1) unsigned NOT NULL, `is_last` tinyint(1) NOT NULL DEFAULT '0', `parent_catids` text COMMENT '所有父级栏目', `son_catids` text COMMENT '所有子级栏目', `listtemp` int(10) unsigned NOT NULL DEFAULT '0', `viewtemp` int(10) unsigned NOT NULL DEFAULT '0', `thumb` varchar(255) NOT NULL DEFAULT '', `pagetitle` varchar(255) NOT NULL DEFAULT '', `keywords` varchar(255) NOT NULL DEFAULT '', `description` text, `is_page` tinyint(1) unsigned NOT NULL DEFAULT '0', `is_show` tinyint(1) NOT NULL DEFAULT '0', `list_type` varchar(20) DEFAULT NULL, `view_type` varchar(20) DEFAULT NULL, `listorder` varchar(255) DEFAULT NULL, `reorder` varchar(255) DEFAULT NULL, `member_group_id` varchar(255) DEFAULT NULL, `test22` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`catid`), KEY `level` (`level`), KEY `pid` (`pid`), KEY `status` (`status`), KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8"); $this->E_D("replace into `db_cat` values('11','5','','15661933204692','/news/','news','新闻中心','0','20','1','10','0','1','1','',NULL,'8','7','123','1212','12121','212','0','0','static','static','newstime desc','views desc',NULL,'');"); $this->E_D("replace into `db_cat` values('15','6','','15680939854166','/product/','product','产品中心','0','20','1','20','0','1','1','',NULL,'6','3','','','','','0','0','static','static','','',NULL,'');"); ?>