DROP TABLE IF EXISTS `dircms_admin`;
CREATE TABLE `dircms_admin` (
  `memberid` mediumint(8) unsigned NOT NULL,
  `username` char(20) NOT NULL,
  `allowmultilogin` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `roleid` int(6) NOT NULL DEFAULT '0',
  `categorypriv` text NOT NULL,
  PRIMARY KEY (`memberid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_ads`;
CREATE TABLE `dircms_ads` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL DEFAULT 'name',
  `introduce` varchar(255) DEFAULT NULL,
  `adsposid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `type` varchar(10) NOT NULL,
  `linkurl` varchar(100) NOT NULL DEFAULT 'http://',
  `imageurl` varchar(100) NOT NULL DEFAULT 'http://',
  `alt` varchar(80) NOT NULL DEFAULT 'http://www.dircms.net',
  `flashurl` varchar(100) NOT NULL DEFAULT 'http://',
  `wmode` varchar(20) DEFAULT NULL,
  `text` text,
  `text_link` varchar(100) NOT NULL DEFAULT 'http://',
  `code` text,
  `fromdate` varchar(20) NOT NULL DEFAULT '0',
  `todate` varchar(20) NOT NULL DEFAULT '0',
  `addtime` varchar(20) NOT NULL DEFAULT '0',
  `views` int(10) unsigned NOT NULL DEFAULT '0',
  `clicks` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `ispassed` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fromdate` (`fromdate`,`todate`),
  KEY `adsposid` (`adsposid`,`ispassed`,`fromdate`,`todate`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_ads` VALUES('15','960X60广告位','','14','1','http://','images/ads/201101248532.jpg','','','transparent','','http://','','1295798400','1298390400','1295798400','623','0','1');
REPLACE INTO `dircms_ads` VALUES('16','240X75广告位','','15','1','http://','images/ads/201101247494.gif','','','transparent','','http://','','1295798400','1298390400','1295798400','170','0','1');
REPLACE INTO `dircms_ads` VALUES('4','易创Cms：让建站更简单','','4','3','http://','','','','transparent','【易创Cms：让建站更简单】','http://www.dircms.net/','','1292169600','1326297600','1292169600','383','0','1');
REPLACE INTO `dircms_ads` VALUES('5','内容页590X50广告位下','内容页590X50广告位下','6','1','http://www.dircms.net/','images/ads/201012132444.gif','','','transparent','','http://','','1292169600','1326297600','1292169600','356','1','1');
REPLACE INTO `dircms_ads` VALUES('6','内容页590X50广告位上','','5','1','http://www.dircms.net/','images/ads/201012133840.gif','','','transparent','','http://','','1292169600','1326297600','1292169600','188','0','1');
REPLACE INTO `dircms_ads` VALUES('7','内容页300X250广告位','','7','1','http://www.dircms.net/','images/ads/201012132140.jpg','','','transparent','','http://','','1292169600','1326297600','1292169600','518','0','1');
REPLACE INTO `dircms_ads` VALUES('8','首页960X75广告','','8','1','http://www.dircms.cn/','images/ads/201012132601.jpg','','','transparent','','http://','','1292169600','1326297600','1292169600','1021','4','1');
REPLACE INTO `dircms_ads` VALUES('17','600X80广告位','','16','1','http://','images/ads/201101256623.jpg','','','transparent','','http://','','1295884800','1298476800','1295884800','119','0','1');
REPLACE INTO `dircms_ads` VALUES('20','960X60广告位','','18','1','http://','images/ads/201101259649.png','','','transparent','','http://','','1295884800','1298476800','1295884800','78','0','1');
REPLACE INTO `dircms_ads` VALUES('21','220X70广告位','','19','1','http://','images/ads/201101255076.gif','','','transparent','','http://','','1295884800','1298476800','1295884800','287','0','1');
DROP TABLE IF EXISTS `dircms_adspos`;
CREATE TABLE `dircms_adspos` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(50) NOT NULL,
  `template` char(30) NOT NULL DEFAULT '0',
  `introduce` char(100) DEFAULT NULL,
  `price` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `width` smallint(4) unsigned NOT NULL DEFAULT '0',
  `number` tinyint(2) NOT NULL DEFAULT '0',
  `height` smallint(4) unsigned NOT NULL DEFAULT '0',
  `ispassed` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `option` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_adspos` VALUES('15','240X75广告位','ads_tlp','','100','240','1','75','1','1');
REPLACE INTO `dircms_adspos` VALUES('14','960X60广告位','ads_tlp','960X60广告位','100','960','1','60','1','1');
REPLACE INTO `dircms_adspos` VALUES('4','易创Cms：让建站更简单','ads_tlp','易创Cms：让建站更简单广告位','50','165','1','50','1','0');
REPLACE INTO `dircms_adspos` VALUES('5','内容页590X50广告位上','ads_tlp','内容页590X50广告位上','50','590','1','50','1','0');
REPLACE INTO `dircms_adspos` VALUES('6','内容页590X50广告位下','ads_tlp','内容页590X50广告位下','50','590','1','50','1','0');
REPLACE INTO `dircms_adspos` VALUES('7','内容页300X250广告位','ads_tlp','内容页300X250广告位','50','300','1','250','1','0');
REPLACE INTO `dircms_adspos` VALUES('8','首页960X75广告','ads_tlp','','50','960','1','75','1','0');
REPLACE INTO `dircms_adspos` VALUES('16','600X80广告位','ads_tlp','','100','600','1','80','1','1');
REPLACE INTO `dircms_adspos` VALUES('18','960X60广告位','ads_tlp','','100','960','1','60','1','1');
REPLACE INTO `dircms_adspos` VALUES('19','220X70广告位','ads_tlp','','100','220','1','70','1','1');
DROP TABLE IF EXISTS `dircms_area`;
CREATE TABLE `dircms_area` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `area` varchar(80) NOT NULL,
  `grade` tinyint(3) NOT NULL DEFAULT '1',
  `parentid` int(6) NOT NULL DEFAULT '0',
  `orderby` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gbk COMMENT='地区表';
REPLACE INTO `dircms_area` VALUES('1','上城区','1','0','0');
REPLACE INTO `dircms_area` VALUES('2','下城区','1','0','0');
DROP TABLE IF EXISTS `dircms_article`;
CREATE TABLE `dircms_article` (
  `contentid` mediumint(8) NOT NULL,
  `content` mediumtext NOT NULL,
  `copyfrom` varchar(255) NOT NULL,
  `author` varchar(255) NOT NULL,
  `vote` varchar(255) NOT NULL,
  KEY `contentid` (`contentid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_author`;
CREATE TABLE `dircms_author` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `username` varchar(80) NOT NULL,
  `orderby` tinyint(3) NOT NULL DEFAULT '0',
  `islocked` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_card`;
CREATE TABLE `dircms_card` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cardid` varchar(32) NOT NULL DEFAULT '0',
  `userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `username` char(20) NOT NULL DEFAULT 'anonymity',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `inputerid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `inputer` char(20) NOT NULL DEFAULT 'anonymity',
  `regtime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `regip` char(15) NOT NULL DEFAULT '0.0.0.0',
  `point` smallint(5) unsigned NOT NULL DEFAULT '0',
  `amount` varchar(5) NOT NULL DEFAULT '0',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `cardid` (`cardid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_cargo_method`;
CREATE TABLE `dircms_cargo_method` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `fee` varchar(100) NOT NULL DEFAULT '0',
  `desc` text NOT NULL,
  `orderby` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_cargo_method` VALUES('1','申通快递','10.00元 ','送货费10.00元 ','1');
DROP TABLE IF EXISTS `dircms_category`;
CREATE TABLE `dircms_category` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `modelid` int(4) NOT NULL,
  `categoryname` varchar(100) NOT NULL,
  `categorydir` varchar(50) NOT NULL,
  `categorypic` varchar(200) NOT NULL,
  `meta_title` varchar(200) NOT NULL,
  `meta_keywords` varchar(200) NOT NULL,
  `meta_description` text NOT NULL,
  `domain` varchar(200) NOT NULL,
  `url` varchar(200) NOT NULL DEFAULT 'http://',
  `ispage` tinyint(1) NOT NULL DEFAULT '0',
  `listpage` tinyint(1) NOT NULL DEFAULT '1',
  `pageid` mediumint(8) NOT NULL,
  `categorytlp` varchar(80) NOT NULL,
  `listtlp` varchar(80) NOT NULL,
  `contenttlp` varchar(80) NOT NULL,
  `ishtml` tinyint(1) NOT NULL DEFAULT '0',
  `content_html` varchar(15) NOT NULL,
  `passpriv` varchar(100) NOT NULL,
  `isthumb` tinyint(1) NOT NULL DEFAULT '0',
  `thumb_width` int(4) NOT NULL DEFAULT '75',
  `thumb_height` int(4) NOT NULL DEFAULT '75',
  `presentpoint` int(6) NOT NULL DEFAULT '0',
  `viewpoint` int(6) NOT NULL DEFAULT '0',
  `orderby` int(6) NOT NULL DEFAULT '0',
  `parentid` int(6) NOT NULL DEFAULT '0',
  `isshow` tinyint(1) NOT NULL DEFAULT '1',
  `postpriv` varchar(100) NOT NULL,
  `isend` tinyint(1) NOT NULL DEFAULT '1',
  `istop` tinyint(1) NOT NULL DEFAULT '0',
  `totalnumber` mediumint(8) NOT NULL DEFAULT '0',
  `pagesize` int(4) NOT NULL DEFAULT '0',
  `grade` tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=133 DEFAULT CHARSET=gbk COMMENT='栏目表';
REPLACE INTO `dircms_category` VALUES('48','1','新闻资讯','article','','提供本地新闻资讯','文章,故事,新闻','提供本地新闻资讯','','article','0','0','0','category_news','final_category_news','show_news','1','content_html_2','1,4','1','285','415','5','0','4','0','1','1,4','0','1','0','20','1');
REPLACE INTO `dircms_category` VALUES('49','1','本地快讯','article/xinqing','','提供本地新闻资讯','提供本地新闻资讯','提供本地新闻资讯','','article/xinqing','0','0','0','category_news','final_category_news','show_news','1','content_html_2','1,4','1','285','415','5','0','1','48','1','1,4','1','1','1','20','2');
REPLACE INTO `dircms_category` VALUES('45','0','关于我们','about','','关于我们','关于我们','关于我们','','about/index.html','1','1','20','','','','0','','','0','75','75','0','0','1','0','1','','1','0','0','0','1');
REPLACE INTO `dircms_category` VALUES('46','0','联系我们','about','','联系我们','联系我们','联系我们','','about/connectus.html','1','1','21','','','','0','','','0','75','75','0','0','2','0','1','','1','0','0','0','1');
REPLACE INTO `dircms_category` VALUES('47','0','法律条款','about','','法律条款','法律条款','法律条款','','about/contract.html','1','1','22','','','','0','','','0','75','75','0','0','3','0','1','','1','0','0','0','1');
REPLACE INTO `dircms_category` VALUES('50','1','健康常识','article/jiankang','','提供健康资讯信息','提供健康资讯信息','提供健康资讯信息','','article/jiankang','0','0','0','category_news','final_category_news','show_news','1','content_html_2','1,4','1','285','415','5','0','2','48','1','1,4','1','1','1','20','2');
REPLACE INTO `dircms_category` VALUES('51','1','社交礼仪','article/shejiao','','社交礼仪','社交礼仪','社交礼仪','','article/shejiao','0','0','0','category_news','final_category_news','show_news','1','content_html_2','1,4','1','285','415','5','0','3','48','1','1,4','1','1','5','20','2');
REPLACE INTO `dircms_category` VALUES('52','1','母婴健康','article/muying','','母婴健康','母婴健康','母婴健康','','article/muying','0','0','0','category_news','final_category_news','show_news','1','content_html_2','1,4','1','285','415','5','0','4','48','1','1,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('53','1','生活百科','article/baike','','生活百科','生活百科','生活百科','','article/baike','0','0','0','category_news','final_category_news','show_news','1','content_html_2','1,4','1','285','415','5','0','5','48','1','1,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('54','1','职场人生','article/zhichang','','职场人生','职场人生','职场人生','','article/zhichang','0','0','0','category_news','final_category_news','show_news','1','content_html_2','1,4','1','285','415','5','0','6','48','1','1,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('55','6','跳蚤市场','ershou','','跳蚤市场','跳蚤市场','跳蚤市场','','ershou','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','5','0','1','1,2,3,4','0','1','0','20','1');
REPLACE INTO `dircms_category` VALUES('56','6','台式电脑','ershou/tsdiannao','','台式电脑','台式电脑','台式电脑','','ershou/tsdiannao','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','1','55','1','1,2,3,4','1','1','1','20','2');
REPLACE INTO `dircms_category` VALUES('57','6','二手笔记本','ershou/bijiben','','二手笔记本','二手笔记本','二手笔记本','','ershou/bijiben','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','2','55','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('58','6','手机/通讯相关','ershou/tongxun','','手机/通讯相关','手机/通讯相关','手机/通讯相关','','ershou/tongxun','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','3','55','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('59','6','二手数码/摄录','ershou/shuma','','二手数码/摄录','二手数码/摄录','二手数码/摄录','','ershou/shuma','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','4','55','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('60','6','二手家电','ershou/jiadian','','二手家电','二手家电','二手家电','','ershou/jiadian','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','5','55','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('61','6','二手回收','ershou/huishou','','二手回收','二手回收','二手回收','','ershou/huishou','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','6','55','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('62','6','音响/乐器/影音','ershou/yinxiang','','音响/乐器/影音','音响/乐器/影音','音响/乐器/影音','','ershou/yinxiang','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','7','55','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('63','6','软件/图书/音像','ershou/tushu','','软件/图书/音像','软件/图书/音像','软件/图书/音像','','ershou/tushu','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','8','55','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('64','6','艺术/工艺/收藏品','ershou/yishu','','艺术/工艺/收藏品','艺术/工艺/收藏品','艺术/工艺/收藏品','','ershou/yishu','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','9','55','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('65','6','母婴/儿童用品','ershou/muying','','母婴/儿童用品','母婴/儿童用品','母婴/儿童用品','','ershou/muying','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','10','55','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('66','6','服饰/箱包/鞋帽 ','ershou/fushi','','服饰/箱包/鞋帽 ','服饰/箱包/鞋帽 ','服饰/箱包/鞋帽 ','','ershou/fushi','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','11','55','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('67','6','化妆品/保健品','ershou/baojianpin','','化妆品/保健品','化妆品/保健品','化妆品/保健品','','ershou/baojianpin','0','1','0','category_ershou','final_category_ershou','show_ershou','1','content_html_2','1,2,3,4','1','285','415','5','0','12','55','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('68','4','房屋交易','fang','','房屋交易','房屋交易','房屋交易','','fang','0','1','0','category_chuzu','final_category_chuzu','show_chuzu','1','content_html_2','1,2,3,4','1','285','415','5','0','6','0','1','1,2,3,4','0','1','0','20','1');
REPLACE INTO `dircms_category` VALUES('69','4','出租房','fang/chuzu','','出租房','出租房','出租房','','fang/chuzu','0','1','0','category_chuzu','final_category_chuzu','show_chuzu','1','content_html_2','1,2,3,4','1','285','415','5','0','1','68','1','1,2,3,4','1','1','1','20','2');
REPLACE INTO `dircms_category` VALUES('70','4','二手房出售','fang/esfchushou','','二手房出售','二手房出售','二手房出售','','fang/esfchushou','0','1','0','category_chuzu','final_category_chuzu','show_chuzu','1','content_html_2','1,2,3,4','1','285','415','5','0','2','68','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('71','4','合租房','fang/hezu','','合租房','合租房','合租房','','fang/hezu','0','1','0','category_chuzu','final_category_chuzu','show_chuzu','1','content_html_2','1,2,3,4','1','285','415','5','0','3','68','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('72','4','日租房/短期租房','fang/duanzu','','日租房/短期租房','日租房/短期租房','日租房/短期租房','','fang/duanzu','0','1','0','category_chuzu','final_category_chuzu','show_chuzu','1','content_html_2','1,2,3,4','1','285','415','5','0','4','68','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('73','4','求租房','fang/qiuzu','','求租房','求租房','求租房','','fang/qiuzu','0','1','0','category_chuzu','final_category_chuzu','show_chuzu','1','content_html_2','1,2,3,4','1','285','415','5','0','5','68','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('74','4','二手房求购','fang/esfqiugou','','二手房求购','二手房求购','二手房求购','','fang/esfqiugou','0','1','0','category_chuzu','final_category_chuzu','show_chuzu','1','content_html_2','1,2,3,4','1','285','415','5','0','6','68','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('75','4','商铺出租/求租 ','fang/sp','','商铺出租/求租 ','商铺出租/求租 ','商铺出租/求租 ','','fang/sp','0','1','0','category_chuzu','final_category_chuzu','show_chuzu','1','content_html_2','1,2,3,4','1','285','415','5','0','7','68','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('76','4','商铺出售/求购','fang/spmm','','商铺出售/求购','商铺出售/求购','商铺出售/求购','','fang/spmm','0','1','0','category_chuzu','final_category_chuzu','show_chuzu','1','content_html_2','1,2,3,4','1','285','415','5','0','8','68','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('77','4','写字楼出租/求租','fang/xiezilou','','写字楼出租/求租','写字楼出租/求租','写字楼出租/求租','','fang/xiezilou','0','1','0','category_chuzu','final_category_chuzu','show_chuzu','1','content_html_2','1,2,3,4','1','285','415','5','0','9','68','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('78','7','招聘求职','job','','招聘求职','招聘求职','招聘求职','','job','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','7','0','1','1,2,3,4','0','1','0','20','1');
REPLACE INTO `dircms_category` VALUES('79','7','技师/工人/学徒','job/jishi','','技师/工人/学徒','技师/工人/学徒','技师/工人/学徒','','job/jishi','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','1','78','1','1,2,3,4','1','1','1','20','2');
REPLACE INTO `dircms_category` VALUES('80','7','行政/文秘/助理','job/xingzheng','','行政/文秘/助理','行政/文秘/助理','行政/文秘/助理','','job/xingzheng','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','2','78','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('81','7','平面/网页设计','job/sheji','','平面设计/网页设计','平面设计/网页设计','平面设计/网页设计','','job/sheji','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','3','78','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('82','7','财务/会计/出纳','job/caiwu','','财务/会计/出纳','财务/会计/出纳','财务/会计/出纳','','job/caiwu','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','4','78','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('83','7','兼职/促销/实习','job/jianzhi','','兼职/促销/实习','兼职/促销/实习','兼职/促销/实习','','job/jianzhi','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','5','78','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('84','7','清洁/搬运/保管','job/qingjie','','清洁工/搬运工/保管','清洁工/搬运工/保管','清洁工/搬运工/保管','','job/qingjie','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','6','78','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('85','7','公关/演艺/DJ ','job/dj','','公关/演艺/吧丽/DJ ','公关/演艺/吧丽/DJ ','公关/演艺/吧丽/DJ ','','job/dj','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','7','78','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('86','7','销售/业务 ','job/yewu','','销售/业务 ','销售/业务 ','销售/业务 ','','job/yewu','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','8','78','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('87','7','美容/美发/按摩','job/meirong','','美容师/美发师/按摩','美容师/美发师/按摩','美容师/美发师/按摩','','job/meirong','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','9','78','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('88','7','医护人员/老师','job/yihu','','医护人员/老师','医护人员/老师','医护人员/老师','','job/yihu','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','10','78','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('89','7','求职','job/qiuzhi','','求职','求职','求职','','job/qiuzhi','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','11','78','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('90','7','其它招聘','job/qita','','其它招聘','其它招聘','其它招聘','','job/qita','0','1','0','category_job','final_category_job','show_job','1','content_html_2','1,2,3,4','1','285','415','5','0','12','78','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('91','8','生活服务','shenghuo','','生活服务','生活服务','生活服务','','shenghuo','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','8','0','1','1,2,3,4','0','1','0','20','1');
REPLACE INTO `dircms_category` VALUES('92','8','公司注册/年检','shenghuo/gongsi','','公司注册/年检','公司注册/年检','公司注册/年检','','shenghuo/gongsi','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','1','91','1','1,2,3,4','1','1','1','20','2');
REPLACE INTO `dircms_category` VALUES('93','8','会计/审计/评估','shenghuo/shenji','','会计/审计/评估 ','会计/审计/评估 ','会计/审计/评估 ','','shenghuo/shenji','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','2','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('94','8','印刷','shenghuo/yinshua','','印刷','印刷','印刷','','shenghuo/yinshua','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','3','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('95','8','喷绘招牌/制卡','shenghuo/penhui','','喷绘招牌/制卡','喷绘招牌/制卡','喷绘招牌/制卡','','shenghuo/penhui','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','4','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('96','8','设计策划','shenghuo/sheji','','设计策划','设计策划','设计策划','','shenghuo/sheji','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','5','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('97','8','网站建设','shenghuo/wangzhan','','网站建设','网站建设','网站建设','','shenghuo/wangzhan','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','6','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('98','8','二手回收','shenghuo/ershou','','二手回收 ','二手回收 ','二手回收 ','','shenghuo/ershou','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','7','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('99','8','物流/货运 ','shenghuo/wuliu','','物流/货运','物流/货运','物流/货运','','shenghuo/wuliu','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','8','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('100','8','设备租赁维修 ','shenghuo/zulin','','设备租赁维修 ','设备租赁维修 ','设备租赁维修 ','','shenghuo/zulin','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','9','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('101','8','金融/担保贷款','shenghuo/daikuan','','金融/担保贷款','金融/担保贷款','金融/担保贷款','','shenghuo/daikuan','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','10','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('102','8','清欠/商务调查','shenghuo/shangwu','','清欠/商务调查','清欠/商务调查','清欠/商务调查','','shenghuo/shangwu','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','11','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('103','8','招商加盟','shenghuo/zhaoshang','','招商加盟','招商加盟','招商加盟','','shenghuo/zhaoshang','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','12','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('104','8','展览/展示','shenghuo/zhanlan','','展览/展示','展览/展示','展览/展示','','shenghuo/zhanlan','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','13','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('105','8','教育培训','shenghuo/peixun','','教育培训/学校招生 ','教育培训/学校招生 ','教育培训/学校招生 ','','shenghuo/peixun','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','14','91','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('106','8','同城活动','tongcheng','','同城活动','同城活动','同城活动','','tongcheng','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','9','0','1','1,2,3,4','0','1','0','20','1');
REPLACE INTO `dircms_category` VALUES('107','8','团购/打折','tongcheng/tuangou','','团购/打折','团购/打折','团购/打折','','tongcheng/tuangou','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','1','106','1','1,2,3,4','1','1','1','20','2');
REPLACE INTO `dircms_category` VALUES('108','8','结伴出游 ','tongcheng/lvyou','','结伴出游 ','结伴出游 ','结伴出游 ','','tongcheng/lvyou','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','2','106','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('109','8','相约运动','tongcheng/yundong','','相约运动','相约运动','相约运动','','tongcheng/yundong','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','3','106','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('110','8','公益活动/志愿者','tongcheng/gongyi','','公益活动/志愿者','公益活动/志愿者','公益活动/志愿者','','tongcheng/gongyi','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','4','106','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('111','8','讲座/招聘会','tongcheng/zhaopin','','讲座/招聘会','讲座/招聘会','讲座/招聘会','','tongcheng/zhaopin','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','5','106','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('112','8','演出/展览 ','tongcheng/zhanlan','','演出/展览 ','演出/展览 ','演出/展览 ','','tongcheng/zhanlan','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','6','106','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('113','8','寻人寻友','tongcheng/xunren','','寻人寻友','寻人寻友','寻人寻友','','tongcheng/xunren','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','7','106','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('114','8','同乡会','tongcheng/tingxiang','','同乡会','同乡会','同乡会','','tongcheng/tingxiang','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','8','106','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('115','8','交友征婚','tongcheng/zhenghun','','交友征婚','交友征婚','交友征婚','','tongcheng/zhenghun','0','1','0','category_xinxi','final_category_xinxi','show_xinxi','1','content_html_2','1,2,3,4','1','285','415','5','0','9','106','1','1,2,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('116','9','团购活动','tg','','团购活动','团购活动','团购活动','','tg','0','1','0','category_tg','final_category_tg','show_tg','1','content_html_2','1,4','1','285','415','5','0','10','0','1','1,4','0','1','0','20','1');
REPLACE INTO `dircms_category` VALUES('117','9','购房团','tg/goufang','','购房团','购房团','购房团','','tg/goufang','0','0','0','category_tg','final_category_tg','show_tg','1','content_html_2','1,4','1','285','415','5','0','1','116','1','1,4','1','1','2','20','2');
REPLACE INTO `dircms_category` VALUES('118','9','建材团','tg/jiancai','','建材团','建材团','建材团','','tg/jiancai','0','0','0','category_tg','final_category_tg','show_tg','1','content_html_2','1,4','1','285','415','5','0','2','116','1','1,4','1','1','1','20','2');
REPLACE INTO `dircms_category` VALUES('119','9','旅游团','tg/lvyou','','旅游团','旅游团','旅游团','','tg/lvyou','0','0','0','category_tg','final_category_tg','show_tg','1','content_html_2','1,4','1','285','415','5','0','3','116','1','1,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('120','9','购车团','tg/che','','购车团','购车团','购车团','','tg/che','0','0','0','category_tg','final_category_tg','show_tg','1','content_html_2','1,4','1','285','415','5','0','4','116','1','1,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('121','9','吃喝团','tg/chi','','吃喝团','吃喝团','吃喝团','','tg/chi','0','0','0','category_tg','final_category_tg','show_tg','1','content_html_2','1,4','1','285','415','5','0','5','116','1','1,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('122','9','婚庆团','tg/hunqing','','婚庆团','婚庆团','婚庆团','','tg/hunqing','0','0','0','category_tg','final_category_tg','show_tg','1','content_html_2','1,4','1','285','415','5','0','6','116','1','1,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('123','9','母婴团','tg/muying','','母婴团','母婴团','母婴团','','tg/muying','0','0','0','category_tg','final_category_tg','show_tg','1','content_html_2','1,4','1','285','415','5','0','7','116','1','1,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('124','0','如何参与团购？','tg/about','','','','','','tg/abouttg.html','1','1','24','','','','0','','','0','75','75','0','0','8','116','1','','1','1','0','0','2');
REPLACE INTO `dircms_category` VALUES('125','1','房产资讯','article/fangchan','','房产资讯','房产资讯','房产资讯','','article/fangchan','0','0','0','category_news','final_category_news','show_news','1','content_html_2','1,4','1','285','415','5','0','7','48','1','1,3,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('126','1','新闻精选','article/jingxuan','','新闻精选','新闻精选','新闻精选','','article/jingxuan','0','0','0','category_news','final_category_news','show_news','1','content_html_2','1,4','1','285','415','5','0','8','48','1','1,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('127','10','本地房源','loupan','','楼盘展示','楼盘展示','楼盘展示','','loupan','0','1','0','category_lp','final_category_lp','show_lp','1','content_html_2','1,4','1','285','415','5','0','11','0','1','1,4','0','1','0','20','1');
REPLACE INTO `dircms_category` VALUES('128','10','二手房房源','loupan/ershoufang','','二手房','二手房','二手房','','loupan/ershoufang','0','0','0','category_lp','final_category_lp','show_lp','1','content_html_2','1,4','1','285','415','5','0','1','127','1','1,4','1','1','1','20','2');
REPLACE INTO `dircms_category` VALUES('129','10','出租房源','loupan/chuzu','','出租房源','出租房源','出租房源','','loupan/chuzu','0','0','0','category_lp','final_category_lp','show_lp','1','content_html_2','1,4','1','285','415','5','0','2','127','1','1,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('130','10','出售房源','loupan/chushou','','出售房源','出售房源','出售房源','','loupan/chushou','0','0','0','category_lp','final_category_lp','show_lp','1','content_html_2','1,4','1','285','415','5','0','3','127','1','1,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('131','10','求购房源','loupan/qiugou','','求购房源','求购房源','求购房源','','loupan/qiugou','0','0','0','category_lp','final_category_lp','show_lp','1','content_html_2','1,4','1','285','415','5','0','4','127','1','1,4','1','1','0','20','2');
REPLACE INTO `dircms_category` VALUES('132','10','求租房源','loupan/qiuzu','','求租房源','求租房源','求租房源','','loupan/qiuzu','0','0','0','category_lp','final_category_lp','show_lp','1','content_html_2','1,4','1','285','415','5','0','5','127','1','1,4','1','1','0','20','2');
DROP TABLE IF EXISTS `dircms_chuzu`;
CREATE TABLE `dircms_chuzu` (
  `contentid` mediumint(8) NOT NULL,
  `content` mediumtext NOT NULL,
  `zhongjie` varchar(255) NOT NULL,
  `huxing` varchar(255) NOT NULL,
  `peizhi` varchar(255) NOT NULL,
  `zujin` varchar(255) NOT NULL,
  `zhifu` varchar(255) NOT NULL,
  `tupian` mediumtext NOT NULL,
  `youxiaoqi` varchar(255) NOT NULL,
  `lianxiren` varchar(80) NOT NULL,
  `dianhua` varchar(255) NOT NULL,
  `qq` varchar(255) NOT NULL,
  `map` varchar(255) NOT NULL,
  KEY `contentid` (`contentid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_co_coupon`;
CREATE TABLE `dircms_co_coupon` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `userid` mediumint(8) NOT NULL,
  `company` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `titleimg` varchar(255) NOT NULL,
  `clicks` mediumint(8) NOT NULL DEFAULT '0',
  `comments` mediumint(8) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `content` mediumtext NOT NULL,
  `inputtime` varchar(10) NOT NULL,
  `starttime` varchar(10) NOT NULL,
  `endtime` varchar(10) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_co_news`;
CREATE TABLE `dircms_co_news` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `userid` mediumint(8) NOT NULL,
  `company` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `clicks` mediumint(8) NOT NULL DEFAULT '0',
  `comments` mediumint(8) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `content` mediumtext NOT NULL,
  `inputtime` varchar(10) NOT NULL,
  `updatetime` varchar(10) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_co_product`;
CREATE TABLE `dircms_co_product` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `typeid` mediumint(8) NOT NULL,
  `userid` mediumint(8) NOT NULL,
  `company` varchar(255) NOT NULL,
  `product` varchar(255) NOT NULL,
  `price` varchar(10) NOT NULL,
  `pruductimg` varchar(255) NOT NULL,
  `clicks` mediumint(8) NOT NULL DEFAULT '0',
  `comments` mediumint(8) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `content` mediumtext NOT NULL,
  `inputtime` varchar(10) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_collect`;
CREATE TABLE `dircms_collect` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `userid` mediumint(8) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `url` varchar(200) NOT NULL DEFAULT 'http://',
  `time` varchar(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='我的收藏';
DROP TABLE IF EXISTS `dircms_comment`;
CREATE TABLE `dircms_comment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contentid` mediumint(8) NOT NULL DEFAULT '0',
  `catid` int(8) NOT NULL DEFAULT '0',
  `userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL,
  `userface` varchar(100) NOT NULL,
  `score` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `support` smallint(5) unsigned NOT NULL DEFAULT '0',
  `against` smallint(5) unsigned NOT NULL DEFAULT '0',
  `content` text NOT NULL,
  `ip` varchar(15) NOT NULL DEFAULT '0.0.0.0',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`,`status`,`id`),
  KEY `ip` (`ip`,`status`,`id`),
  KEY `status` (`status`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_content`;
CREATE TABLE `dircms_content` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `catid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `areaid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `groupid` char(80) NOT NULL DEFAULT '0',
  `template` char(100) NOT NULL,
  `title` char(160) NOT NULL,
  `style` char(30) NOT NULL,
  `thumb` char(100) NOT NULL DEFAULT '',
  `keywords` varchar(500) NOT NULL,
  `description` varchar(510) NOT NULL,
  `posid` tinyint(1) NOT NULL DEFAULT '0',
  `url` char(100) NOT NULL DEFAULT 'http://',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '3',
  `point` smallint(5) NOT NULL DEFAULT '0',
  `pages` tinyint(2) NOT NULL DEFAULT '0',
  `userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `username` char(80) NOT NULL,
  `inputtime` int(10) unsigned NOT NULL DEFAULT '0',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0',
  `tags` varchar(300) NOT NULL,
  `clicks` int(5) NOT NULL DEFAULT '0',
  `digups` mediumint(8) NOT NULL DEFAULT '0',
  `digdowns` int(5) NOT NULL DEFAULT '0',
  `comments` int(5) NOT NULL DEFAULT '0',
  `islink` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `iscomment` tinyint(1) NOT NULL DEFAULT '1',
  `orderby` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `catid` (`catid`,`status`,`id`),
  KEY `status` (`status`,`id`),
  KEY `typeid` (`typeid`,`status`,`id`),
  KEY `userid` (`userid`),
  FULLTEXT KEY `tags` (`tags`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_content_posid`;
CREATE TABLE `dircms_content_posid` (
  `contentid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `posid` smallint(5) unsigned NOT NULL DEFAULT '0',
  KEY `posid` (`posid`),
  KEY `contentid` (`contentid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_content_posid` VALUES('1','8');
REPLACE INTO `dircms_content_posid` VALUES('1','7');
REPLACE INTO `dircms_content_posid` VALUES('1','6');
REPLACE INTO `dircms_content_posid` VALUES('1','5');
REPLACE INTO `dircms_content_posid` VALUES('1','3');
REPLACE INTO `dircms_content_posid` VALUES('1','12');
DROP TABLE IF EXISTS `dircms_copyfrom`;
CREATE TABLE `dircms_copyfrom` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `copyfrom` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL DEFAULT 'http://',
  `orderby` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='文章来源';
DROP TABLE IF EXISTS `dircms_corporatemember`;
CREATE TABLE `dircms_corporatemember` (
  `userid` mediumint(8) DEFAULT NULL,
  `companyname` varchar(255) DEFAULT NULL,
  `linkman` varchar(40) DEFAULT NULL,
  `phone` varchar(80) DEFAULT NULL,
  `busroute` varchar(255) DEFAULT NULL,
  `openingtime` varchar(30) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `about` mediumtext,
  `companypic` varchar(255) DEFAULT NULL,
  `map` varchar(80) DEFAULT NULL,
  `pics` mediumtext NOT NULL,
  `shipin` varchar(255) NOT NULL,
  `qq` varchar(15) NOT NULL,
  `shenfenzheng` varchar(255) NOT NULL,
  `zhizhao` varchar(255) NOT NULL,
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_counts`;
CREATE TABLE `dircms_counts` (
  `id` char(32) NOT NULL DEFAULT '',
  `count` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MEMORY DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_db_fields`;
CREATE TABLE `dircms_db_fields` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `modelid` mediumint(8) NOT NULL,
  `name` varchar(50) NOT NULL,
  `fieldname` varchar(100) NOT NULL,
  `tips` varchar(255) NOT NULL,
  `formtype` varchar(20) NOT NULL,
  `js` varchar(250) NOT NULL,
  `css` varchar(80) NOT NULL,
  `preg` varchar(255) NOT NULL,
  `defaultvalue` varchar(200) NOT NULL,
  `minsize` varchar(10) NOT NULL,
  `maxsize` varchar(10) NOT NULL,
  `optionvalue` text NOT NULL,
  `editorwidth` smallint(5) NOT NULL,
  `editorheight` smallint(5) NOT NULL,
  `orderby` tinyint(5) NOT NULL DEFAULT '0',
  `disabled` tinyint(1) NOT NULL DEFAULT '0',
  `isbase` tinyint(1) NOT NULL DEFAULT '0',
  `issearch` tinyint(1) NOT NULL DEFAULT '0',
  `searchby` varchar(20) NOT NULL,
  `searchbyvalue` varchar(250) NOT NULL,
  `privilege` varchar(200) NOT NULL,
  `issystem` tinyint(1) NOT NULL DEFAULT '0',
  `danwei` varchar(100) NOT NULL,
  `createimage` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=287 DEFAULT CHARSET=gbk COMMENT='字段表';
REPLACE INTO `dircms_db_fields` VALUES('123','4','style','加亮显示','','style','','','','','1','200','','0','0','2','0','1','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('122','4','title','信息标题','','title','','','','','1','200','','0','0','1','0','1','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('250','9','bm','在线报名','','sign','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','10','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('249','9','map','团购地图','','map','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','11','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('248','9','jiezhi','截止时间','','_date','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','7','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('246','9','kaishi','报名时间','','_date','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','6','0','1','0','0','','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('133','4','huxing','房屋户型','','radio','','radio','','二室','0','255','独院|独院\r\n一室|一室\r\n二室|二室\r\n三室|三室\r\n四室|四室\r\n其他|其他','0','0','4','0','1','1','eq','hx','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('132','4','zhongjie','是否中介','','radio','','radio','','0','0','255','0|个人\r\n1|中介','0','0','5','0','1','1','eq','zj','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('131','4','point','阅读所需点数','启用静态化时此选项无效','point','','','','','1','200','','0','0','9','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('130','4','areaid','选择地区','','areaid','','','','','1','200','','0','0','10','0','1','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('129','4','posid','信息推荐位','','posid','','','','','1','200','','0','0','7','0','1','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('128','4','groupid','阅读权限','启用静态化时此选项无效','groupid','','','','','1','200','','0','0','6','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('127','4','inputtime','发布时间','','inputtime','','','','','1','200','','0','0','5','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('126','4','description','信息摘要','不要超过255个字符','description','','','','','1','200','','0','0','9','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('124','4','thumb','信息图片','','thumb','','','','','1','200','','0','0','3','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('125','4','keywords','信息关键词','多关键词之间用空格隔开','keyword','','','','','1','200','','0','0','4','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('244','9','jiaotong','交通线路','','text','','','','如:11路,K315路','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','10','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('243','9','dizhi','报名地址','','text','','text_15x225','','如:延安路11号家乐福','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','9','0','1','0','0','','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('242','9','tel','报名电话','','text','','','','0571-','0','50','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','8','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('241','9','pics','产品图片','支持jpg格式图片','images','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','11','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('240','9','zhekou','折扣','不要输入单位','text','','text_15x55','number','8.5','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','12','0','1','0','0','','1,4','0','折','0');
REPLACE INTO `dircms_db_fields` VALUES('239','9','yuanjia','原价','不要输入单位','text','','text_15x55','number','10.0','0','20','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','13','0','1','0','0','','1,4','0','元','0');
REPLACE INTO `dircms_db_fields` VALUES('238','9','point','阅读所需点数','启用后内容不会被静态化','point','','','','','1','200','','0','0','18','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('237','9','areaid','所属地区','','areaid','','','','','1','200','','0','0','19','0','0','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('245','9','lianxiren','联系人','','text','','text_15x55','','先生','0','50','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','5','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('236','9','posid','推荐位设置','','posid','','','','','1','200','','0','0','17','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('229','9','title','团购名称','','title','','','','','1','200','','0','0','1','0','1','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('230','9','style','加亮显示','','style','','','','','1','200','','0','0','2','0','1','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('231','9','thumb','宣传图片','','thumb','','','','','1','200','','0','0','3','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('232','9','keywords','团购关键词','多关键词之间用空格隔开','keyword','','','','','1','200','','0','0','4','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('233','9','description','简要介绍','不要超过255个字符','description','','','','','1','200','','0','0','14','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('234','9','inputtime','添加时间','','inputtime','','','','','1','200','','0','0','15','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('235','9','groupid','阅读权限','启用后内容不会被静态化','groupid','','','','','1','200','','0','0','16','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('87','1','vote','在线投票','','vote','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','7','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('86','1','author','责任编辑','','author','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','6','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('85','1','copyfrom','文章来源','','copyfrom','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','5','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('84','1','point','阅读所需点数','启用静态化时此选项无效','point','','input_title','','','1','200','','0','0','12','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('83','1','areaid','地区','','areaid','','input_title','','','1','200','','0','0','11','0','0','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('82','1','posid','推荐位','','posid','','input_title','','','1','200','','0','0','9','0','1','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('81','1','groupid','阅读权限','启用静态化时此选项无效','groupid','','input_title','','','1','200','','0','0','10','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('80','1','inputtime','添加时间','','inputtime','','input_title','','','1','200','','0','0','8','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('79','1','description','内容导读','不要超过255个字符','description','','input_title','','','1','200','','0','0','8','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('77','1','thumb','封面图片','','thumb','','input_title','','','1','200','','0','0','3','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('78','1','keywords','关键词','多关键词之间用空格隔开','keyword','','input_title','','','1','200','','0','0','4','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('75','1','title','标题','','title','','input_title','','','1','200','','0','0','1','0','1','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('76','1','style','标题加亮','','style','','input_title','','','1','200','','0','0','2','0','1','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('134','4','peizhi','房屋配置','','checkbox','','checkbox','','自来水/民用电/管道煤气/床/宽带','0','255','自来水|自来水\r\n民用电|民用电\r\n管道煤气|管道煤气\r\n有线电视|有线电视\r\n暖气|暖气\r\n床|床\r\n衣柜|衣柜\r\n热水器|热水器\r\n洗衣机|洗衣机\r\n空调|空调\r\n冰箱|冰箱\r\n电视机|电视机\r\n宽带|宽带\r\n抽油烟机|抽油烟机\r\n电话|电话','0','0','6','0','1','1','like','pz','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('135','4','zujin','房屋价格','','text','','text_15x55','number','800','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','7','0','1','1','ltgt','minzj-maxzj','1,2,3,4','0','元','0');
REPLACE INTO `dircms_db_fields` VALUES('136','4','zhifu','支付方式','','select','','','','','0','255','面议|面议\r\n押一付一|押一付一\r\n押一付二|押一付二\r\n押一付三|押一付三\r\n押一付四|押一付四\r\n年付|年付','0','0','8','0','1','1','eq','zf','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('137','4','tupian','房屋图片','','images','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','8','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('138','4','youxiaoqi','信息有效期','','select','','','','','0','255','30天|30天\r\n60天|60天\r\n一年|一年\r\n长期有效|长期有效','0','0','8','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('139','4','lianxiren','联系人','','text','','text_15x55','','先生','0','80','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','8','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('140','4','dianhua','联系电话','','text','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','8','0','1','0','0','','1,2,3,4','0','','1');
REPLACE INTO `dircms_db_fields` VALUES('141','4','qq','联系QQ','','text','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','7','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('142','5','title','片名','','title','','','','','1','200','','0','0','1','0','1','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('143','5','style','加亮显示','','style','','','','','1','200','','0','0','2','0','1','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('144','5','thumb','缩略图','','thumb','','','','','1','200','','0','0','3','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('145','5','keywords','关键词','多关键词之间用空格隔开','keyword','','','','','1','200','','0','0','4','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('146','5','description','电影简介','不要超过255个字符','description','','','','','1','200','','0','0','14','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('147','5','inputtime','添加时间','','inputtime','','','','','1','200','','0','0','5','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('148','5','groupid','观看权限','启用静态化时此选项无效','groupid','','','','','1','200','','0','0','6','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('149','5','posid','电影推荐位','','posid','','','','','1','200','','0','0','13','0','1','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('150','5','areaid','地区','','areaid','','','','','1','200','','0','0','8','1','0','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('151','5','point','观看所需点数','启用静态化时此选项无效','point','','text_15x25','','','1','200','','0','0','9','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('152','5','daoyan','导演','','text','','','','','0','100','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','5','0','1','1','like','dy','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('153','5','zhuyan','主演','多个演员用 / 隔开','text','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','6','0','1','1','like','zy','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('154','5','guojia','制片国家/地区','','select','','','','港台','0','255','中国大陆|中国大陆\r\n港台|港台\r\n欧美|欧美\r\n日本|日本\r\n印度|印度\r\n泰国|泰国\r\n新加坡|新加坡\r\n其他|其他','0','0','7','0','1','1','eq','gj','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('155','5','leixing','类型','','radio','','radio','','爱情','0','255','动作|动作\r\n喜剧|喜剧\r\n科幻|科幻\r\n恐怖|恐怖\r\n灾难|灾难\r\n动画|动画\r\n伦理|伦理\r\n爱情|爱情\r\n其他|其他','0','0','8','0','1','1','eq','lx','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('156','5','yuyan','语言','','text','','','','中英双语','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','9','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('157','5','pianchang','片长','','text','','text_15x25','','90','0','10','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','10','0','1','0','0','','1,2,3,4','0','分钟','0');
REPLACE INTO `dircms_db_fields` VALUES('158','5','banben','版本','','radio','','radio','','普通版','0','255','普通版|普通版\r\n高清|高清\r\n蓝光|蓝光\r\n枪版|枪版','0','0','11','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('159','5','dizhi','视频地址','','videourl','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','12','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('160','5','haibao','电影海报','','images','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','12','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('161','6','title','信息标题','','title','','','','','1','200','','0','0','1','0','1','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('162','6','style','加亮显示','','style','','','','','1','200','','0','0','2','0','1','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('163','6','thumb','标题图片','','thumb','','','','','1','200','','0','0','3','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('164','6','keywords','信息关键词','多关键词之间用空格隔开','keyword','','','','','1','200','','0','0','4','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('165','6','description','信息摘要','不要超过255个字符','description','','','','','1','200','','0','0','14','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('166','6','inputtime','添加时间','','inputtime','','','','','1','200','','0','0','5','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('167','6','groupid','阅读权限','启用静态化时此选项无效','groupid','','','','','1','200','','0','0','6','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('168','6','posid','信息推荐位','','posid','','','','','1','200','','0','0','7','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('169','6','areaid','所属地区','','areaid','','','','','1','200','','0','0','13','0','1','1','eq','areaid','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('170','6','point','阅读所需点数','启用静态化时此选项无效','point','','','','','1','200','','0','0','9','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('171','6','fukuan','付款方式','','radio','','radio','','现金','0','255','电汇|电汇\r\n支付宝|支付宝\r\n现金|现金\r\n其他|其他','0','0','5','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('172','6','price','价格','','text','','text_15x55','number','1000.00','0','50','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','6','0','1','0','0','','1,2,3,4','0','元','0');
REPLACE INTO `dircms_db_fields` VALUES('173','6','shuliang','数量','','text','','text_15x55','integer','1','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','7','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('174','6','xinjiu','新旧程度','','select','','','','8成新','0','255','全新|全新\r\n9成新|9成新\r\n8成新|8成新\r\n7成新|7成新\r\n6成新以下|6成新以下','0','0','8','0','1','1','eq','xj','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('175','6','lianxiren','联系人','','text','','text_15x55','','先生','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','9','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('176','6','qq','联系QQ','','text','','','qq','','3','15','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','10','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('177','6','dianhua','联系电话','','text','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','11','0','1','0','0','','1,2,3,4','0','','1');
REPLACE INTO `dircms_db_fields` VALUES('178','6','email','电子邮箱','','text','','','','@','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','12','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('179','6','tupian','物品图片','','images','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','13','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('180','6','leixing','信息类型','','select','','','','','0','255','求购|求购\r\n出售|出售','0','0','8','0','1','1','eq','lx','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('181','6','youxiaoqi','有效期','','text','','text_15x55','number','30','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','8','0','1','0','0','','1,2,3,4','0','天','0');
REPLACE INTO `dircms_db_fields` VALUES('182','7','title','信息标题','','title','','','','','1','200','','0','0','1','0','1','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('183','7','style','加亮显示','','style','','','','','1','200','','0','0','2','0','1','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('184','7','thumb','封面图片','','thumb','','','','','1','200','','0','0','3','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('185','7','keywords','信息关键词','多关键词之间用空格隔开','keyword','','','','','1','200','','0','0','4','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('186','7','description','信息摘要','不要超过255个字符','description','','','','','1','200','','0','0','14','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('187','7','inputtime','添加时间','','inputtime','','','','','1','200','','0','0','5','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('188','7','groupid','阅读权限','启用静态化时此选项无效','groupid','','','','','1','200','','0','0','6','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('189','7','posid','信息推荐位','','posid','','','','','1','200','','0','0','7','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('190','7','areaid','所属地区','','areaid','','','','','1','200','','0','0','13','0','1','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('191','7','point','阅读所需点数','启用静态化时此选项无效','point','','','','','1','200','','0','0','9','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('192','7','xingbie','性别要求','','radio','','radio','','不限','0','255','男|男\r\n女|女\r\n不限|不限','0','0','5','0','1','1','eq','xb','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('193','7','xingzhi','工作性质','','select','','','','','0','255','全职|全职\r\n兼职|兼职','0','0','6','0','1','1','eq','xz','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('194','7','xinjin','薪金','','text','','text_15x55','number','1200.00','0','30','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','7','0','1','0','0','','1,2,3,4','0','元','0');
REPLACE INTO `dircms_db_fields` VALUES('195','7','leixing','信息类型','','select','','','','','0','30','招聘|招聘\r\n求职|求职','0','0','8','0','1','1','eq','lx','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('196','7','dizhi','地址','','text','','text_15x225','','如：杭州市文三路47号','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','9','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('197','7','lianxiren','联系人','','text','','text_15x55','','','0','50','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','10','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('198','7','qq','联系QQ','','text','','','qq','','3','15','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','11','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('199','7','dianhua','联系电话','','text','','','','','0','80','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','12','0','1','0','0','','1,2,3,4','0','','1');
REPLACE INTO `dircms_db_fields` VALUES('200','7','youxiaoqi','有效日期','','text','','text_15x55','number','30','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','8','0','1','0','0','','1,2,3,4','0','天','0');
REPLACE INTO `dircms_db_fields` VALUES('201','8','title','信息标题','','title','','','','','1','200','','0','0','1','0','1','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('202','8','style','加亮显示','','style','','','','','1','200','','0','0','2','0','1','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('203','8','thumb','封面图片','','thumb','','','','','1','200','','0','0','3','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('204','8','keywords','信息关键词','多关键词之间用空格隔开','keyword','','','','','1','200','','0','0','4','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('205','8','description','信息摘要','不要超过255个字符','description','','','','','1','200','','0','0','10','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('206','8','inputtime','添加时间','','inputtime','','','','','1','200','','0','0','5','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('207','8','groupid','阅读权限','启用静态化时此选项无效','groupid','','','','','1','200','','0','0','6','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('208','8','posid','信息推荐位','','posid','','','','','1','200','','0','0','7','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('209','8','areaid','所属地区','','areaid','','','','','1','200','','0','0','9','0','1','1','eq','areaid','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('210','8','point','阅读所需点数','启用静态化时此选项无效','point','','text_15x55','','','1','200','','0','0','9','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('211','8','lianxiren','联系人','','text','','text_15x55','','先生','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','5','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('212','8','qq','联系QQ','','text','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','6','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('213','8','dianhua','联系电话','','text','','','','','0','80','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','7','0','1','0','0','','1,2,3,4','0','','1');
REPLACE INTO `dircms_db_fields` VALUES('214','8','email','电子邮箱','','text','','','','@','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','8','0','1','0','0','','1,2,3,4','0','','1');
REPLACE INTO `dircms_db_fields` VALUES('215','8','tupian','信息图片','','images','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','9','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('216','8','youxiaoqi','有效日期','','select','','','','30天','0','50','30天|30天\r\n60天|60天\r\n一年|一年\r\n长期有效|长期有效','0','0','8','0','1','1','eq','yx','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('217','8','xingzhi','服务性质','','select','','','','0','0','255','1|个人\r\n2|中介','0','0','8','0','1','1','eq','xz','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('218','4','map','地图位置','','map','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','0','0','8','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('251','10','title','楼盘名称','','title','','','','','1','200','','0','0','1','0','1','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('252','10','style','加亮显示','','style','','','','','1','200','','0','0','2','0','1','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('253','10','thumb','封面图片','','thumb','','','','','1','200','','0','0','3','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('254','10','keywords','搜索关键词','多关键词之间用空格隔开','keyword','','','','','1','200','','0','0','4','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('255','10','description','楼盘简介','不要超过255个字符','description','','','','','1','200','','0','0','28','0','1','0','like','','1,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('256','10','inputtime','添加时间','','inputtime','','','','','1','200','','0','0','5','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('257','10','groupid','阅读权限','启用后内容不会被静态化','groupid','','','','','1','200','','0','0','6','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('258','10','posid','推荐位设置','','posid','','','','','1','200','','0','0','7','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('259','10','areaid','所属地区','','areaid','','','','','1','200','','0','0','27','0','0','0','like','','1,2,3,4','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('260','10','point','阅读所需点数','启用后内容不会被静态化','point','','','','','1','200','','0','0','9','0','0','0','like','','1','1','','0');
REPLACE INTO `dircms_db_fields` VALUES('261','10','xiaoshou','销售情况','','radio','','radio','','在售','0','255','预售|预售\r\n在售|在售\r\n停售|停售','500','350','2','0','1','1','eq','xs','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('262','10','shoujia','参考售价','','text','','','','8000','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','3','0','1','1','ltgt','minsj-maxsj','1,4','0','元/平米','0');
REPLACE INTO `dircms_db_fields` VALUES('263','10','kaipan','开盘时间','','_date','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','13','0','1','0','0','','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('264','10','zhuli','主力户型','','text','','','','如：2居室100平米','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','4','0','1','0','0','','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('265','10','wuyelx','物业类型','','radio','','radio','','商住两用型','0','255','居住性|居住性\r\n商用型|商用型\r\n商住两用型|商住两用型','500','350','5','0','1','1','eq','wylx','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('266','10','jianzhulb','建筑类别','','checkbox','','checkbox','','小高层/联排别墅','0','255','小高层|小高层\r\n联排别墅|联排别墅','500','350','6','0','1','1','like','jzlb','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('267','10','zhuangxiu','装修情况','','radio','','radio','','简单装修','0','255','毛坯房|毛坯房\r\n简单装修|简单装修\r\n精装修|精装修','500','350','7','0','1','1','eq','zx','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('268','10','ghmj','规划总面积','','text','','','','10000.0','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','8','0','1','0','0','','1,4','0','平米','0');
REPLACE INTO `dircms_db_fields` VALUES('269','10','jzmj','建筑面积','','text','','','number','10000.0','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','9','0','1','0','0','','1,4','0','平米','0');
REPLACE INTO `dircms_db_fields` VALUES('270','10','ghhs','规划户数','','text','','','integer','100','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','10','0','1','0','0','','1,4','0','户','0');
REPLACE INTO `dircms_db_fields` VALUES('271','10','rjl','容积率','','text','','','number','0.8','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','11','0','1','0','0','','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('272','10','lhv','绿化率','','text','','','number','30.0','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','12','0','1','0','0','','1,4','0','%','0');
REPLACE INTO `dircms_db_fields` VALUES('273','10','ruzhusj','入住时间','','_date','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','14','0','1','0','0','','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('274','10','chanquannx','产权年限','','text','','','number','70','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','15','0','1','0','0','','1,4','0','年','0');
REPLACE INTO `dircms_db_fields` VALUES('275','10','chewei','车位数','','text','','','number','300','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','16','0','1','0','0','','1,4','0','个','0');
REPLACE INTO `dircms_db_fields` VALUES('276','10','wuyefei','物业费','','text','','','number','2.0','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','17','0','1','0','0','','1,4','0','元/平米/月','0');
REPLACE INTO `dircms_db_fields` VALUES('277','10','kaifashang','开发商','','text','','','','不详','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','18','0','1','0','0','','1,2,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('278','10','touzishang','投资商','','text','','','','不详','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','19','0','1','0','0','','1,2,3,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('279','10','wuyegs','物业公司','','text','','','','不详','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','20','0','1','0','0','','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('280','10','dianhua','售楼电话','','text','','','','0571-','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','21','0','1','0','0','','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('281','10','lpdizhi','楼盘地址','','text','','','','如：延安路11号','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','22','0','1','0','0','','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('282','10','shouloudz','售楼处地址','','text','','','','如：延安路11号','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','23','0','1','0','0','','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('283','10','lppics','楼盘图片','','images','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','24','0','1','0','0','','1,2,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('284','10','huxingtu','户型图','','images','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','26','0','1','0','0','','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('285','10','map','地图','','map','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','25','0','1','0','0','','1,4','0','','0');
REPLACE INTO `dircms_db_fields` VALUES('286','10','gongzuoshijian','工作时间','','text','','','','8:00 - 21:00','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','500','350','21','0','1','0','0','','1,4','0','','0');
DROP TABLE IF EXISTS `dircms_ershou`;
CREATE TABLE `dircms_ershou` (
  `contentid` mediumint(8) NOT NULL,
  `content` mediumtext NOT NULL,
  `fukuan` varchar(255) NOT NULL,
  `price` varchar(50) NOT NULL,
  `shuliang` varchar(255) NOT NULL,
  `xinjiu` varchar(255) NOT NULL,
  `lianxiren` varchar(255) NOT NULL,
  `qq` varchar(15) NOT NULL,
  `dianhua` varchar(255) NOT NULL,
  `email` varchar(80) NOT NULL,
  `tupian` mediumtext NOT NULL,
  `leixing` varchar(255) NOT NULL,
  `youxiaoqi` varchar(255) NOT NULL,
  KEY `contentid` (`contentid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_gather_url`;
CREATE TABLE `dircms_gather_url` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `noteid` varchar(200) NOT NULL,
  `modelid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `title` varchar(60) NOT NULL DEFAULT '',
  `url` varchar(100) NOT NULL DEFAULT '',
  `dtime` int(10) unsigned NOT NULL DEFAULT '0',
  `isdown` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `isexport` tinyint(1) NOT NULL DEFAULT '0',
  `result` longtext,
  PRIMARY KEY (`id`),
  KEY `noteid` (`noteid`),
  KEY `modelid` (`modelid`,`title`,`url`,`dtime`,`isdown`,`isexport`)
) ENGINE=MyISAM AUTO_INCREMENT=1801 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_guestbook`;
CREATE TABLE `dircms_guestbook` (
  `id` smallint(5) NOT NULL AUTO_INCREMENT,
  `title` char(255) NOT NULL,
  `content` text NOT NULL,
  `reply` text NOT NULL,
  `userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `username` char(20) NOT NULL,
  `hidden` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `passed` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ip` char(15) NOT NULL,
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `replyer` char(20) NOT NULL,
  `replytime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `hidden` (`hidden`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_job`;
CREATE TABLE `dircms_job` (
  `contentid` mediumint(8) NOT NULL,
  `content` mediumtext NOT NULL,
  `xingbie` varchar(255) NOT NULL,
  `xingzhi` varchar(255) NOT NULL,
  `xinjin` varchar(30) NOT NULL,
  `leixing` varchar(30) NOT NULL,
  `dizhi` varchar(255) NOT NULL,
  `lianxiren` varchar(50) NOT NULL,
  `qq` varchar(15) NOT NULL,
  `dianhua` varchar(80) NOT NULL,
  `youxiaoqi` varchar(255) NOT NULL,
  KEY `contentid` (`contentid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_link`;
CREATE TABLE `dircms_link` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `logo` varchar(255) NOT NULL DEFAULT '',
  `introduce` varchar(255) NOT NULL,
  `ispassed` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `hits` int(10) unsigned NOT NULL DEFAULT '0',
  `isindex` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `orderby` tinyint(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_link` VALUES('2','Dircms内容管理系统文字链','http://www.dircms.net/','images/logo/413adbce67148e5c11ece4647eda2a48.gif','','1','1283219752','0','1','1');
DROP TABLE IF EXISTS `dircms_loupan`;
CREATE TABLE `dircms_loupan` (
  `contentid` mediumint(8) NOT NULL,
  `content` mediumtext NOT NULL,
  `xiaoshou` varchar(255) NOT NULL,
  `shoujia` varchar(255) NOT NULL,
  `kaipan` varchar(255) NOT NULL,
  `zhuli` varchar(255) NOT NULL,
  `wuyelx` varchar(255) NOT NULL,
  `jianzhulb` varchar(255) NOT NULL,
  `zhuangxiu` varchar(255) NOT NULL,
  `ghmj` varchar(255) NOT NULL,
  `jzmj` varchar(255) NOT NULL,
  `ghhs` varchar(255) NOT NULL,
  `rjl` varchar(255) NOT NULL,
  `lhv` varchar(255) NOT NULL,
  `ruzhusj` varchar(255) NOT NULL,
  `chanquannx` varchar(255) NOT NULL,
  `chewei` varchar(255) NOT NULL,
  `wuyefei` varchar(255) NOT NULL,
  `kaifashang` varchar(255) NOT NULL,
  `touzishang` varchar(255) NOT NULL,
  `wuyegs` varchar(255) NOT NULL,
  `dianhua` varchar(255) NOT NULL,
  `lpdizhi` varchar(255) NOT NULL,
  `shouloudz` varchar(255) NOT NULL,
  `lppics` mediumtext NOT NULL,
  `huxingtu` mediumtext NOT NULL,
  `map` varchar(255) NOT NULL,
  `gongzuoshijian` varchar(255) NOT NULL,
  KEY `contentid` (`contentid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_member`;
CREATE TABLE `dircms_member` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `touserid` mediumint(8) NOT NULL DEFAULT '0',
  `modelid` int(20) NOT NULL,
  `groupid` int(10) NOT NULL,
  `gradeid` int(6) NOT NULL DEFAULT '0',
  `honorid` int(6) NOT NULL DEFAULT '0',
  `areaid` int(20) NOT NULL DEFAULT '0',
  `username` varchar(30) NOT NULL COMMENT '用户名',
  `password` varchar(32) NOT NULL COMMENT '用户密码',
  `facephoto` varchar(100) NOT NULL DEFAULT 'member/images/face/face01.gif',
  `email` varchar(100) NOT NULL,
  `message` tinyint(3) NOT NULL DEFAULT '0',
  `spaceurl` varchar(255) NOT NULL DEFAULT 'space/index.php?id=1' COMMENT '空间地址',
  `companyurl` varchar(255) NOT NULL,
  `template` varchar(80) NOT NULL DEFAULT 'company',
  `amount` decimal(8,2) unsigned NOT NULL DEFAULT '0.00',
  `point` int(20) NOT NULL DEFAULT '5',
  `regtime` varchar(10) NOT NULL DEFAULT '0',
  `logintime` varchar(10) NOT NULL DEFAULT '0',
  `logintimes` int(10) NOT NULL DEFAULT '0' COMMENT '登录次数',
  `movetime` varchar(10) NOT NULL DEFAULT '0',
  `loginip` varchar(20) NOT NULL DEFAULT '0.0.0.0',
  `ispassed` tinyint(1) NOT NULL DEFAULT '1',
  `iscompmayed` tinyint(1) NOT NULL DEFAULT '0',
  `isvip` tinyint(1) NOT NULL DEFAULT '0',
  `vipstart` varchar(10) NOT NULL DEFAULT '0',
  `vipto` varchar(10) NOT NULL DEFAULT '0',
  `islocked` tinyint(1) NOT NULL DEFAULT '0',
  `typeid` tinyint(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `modelid` (`modelid`,`groupid`),
  KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_member_cache`;
CREATE TABLE `dircms_member_cache` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `touserid` mediumint(8) NOT NULL DEFAULT '0',
  `modelid` int(20) NOT NULL,
  `groupid` int(10) NOT NULL,
  `gradeid` int(6) NOT NULL DEFAULT '0',
  `honorid` int(6) NOT NULL DEFAULT '0',
  `areaid` int(20) NOT NULL DEFAULT '0',
  `username` varchar(30) NOT NULL COMMENT '用户名',
  `password` varchar(32) NOT NULL COMMENT '用户密码',
  `facephoto` varchar(100) NOT NULL DEFAULT 'member/images/face/face01.gif',
  `email` varchar(100) NOT NULL,
  `message` tinyint(3) NOT NULL DEFAULT '0',
  `spaceurl` varchar(255) NOT NULL DEFAULT 'space/index.php?id=1' COMMENT '空间地址',
  `companyurl` varchar(255) NOT NULL,
  `template` varchar(80) NOT NULL DEFAULT 'company',
  `amount` decimal(8,2) unsigned NOT NULL DEFAULT '0.00',
  `point` int(20) NOT NULL DEFAULT '5',
  `regtime` varchar(10) NOT NULL DEFAULT '0',
  `logintime` varchar(10) NOT NULL DEFAULT '0',
  `logintimes` int(10) NOT NULL DEFAULT '0' COMMENT '登录次数',
  `movetime` varchar(10) NOT NULL DEFAULT '0',
  `loginip` varchar(20) NOT NULL DEFAULT '0.0.0.0',
  `ispassed` tinyint(1) NOT NULL DEFAULT '1',
  `iscompmayed` tinyint(1) NOT NULL DEFAULT '0',
  `isvip` tinyint(1) NOT NULL DEFAULT '0',
  `vipstart` varchar(10) NOT NULL DEFAULT '0',
  `vipto` varchar(10) NOT NULL DEFAULT '0',
  `islocked` tinyint(1) NOT NULL DEFAULT '0',
  `typeid` tinyint(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `modelid` (`modelid`,`groupid`),
  KEY `username` (`username`)
) ENGINE=MEMORY AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_member_comment`;
CREATE TABLE `dircms_member_comment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fuwu` tinyint(1) NOT NULL DEFAULT '0',
  `pinzhi` tinyint(1) NOT NULL DEFAULT '0',
  `xingjiabi` tinyint(1) NOT NULL DEFAULT '0',
  `memberid` mediumint(8) NOT NULL DEFAULT '0',
  `membername` varchar(30) NOT NULL,
  `userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `username` varchar(20) NOT NULL,
  `userface` varchar(100) NOT NULL DEFAULT 'images/nophoto.gif',
  `score` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `support` smallint(5) unsigned NOT NULL DEFAULT '0',
  `against` smallint(5) unsigned NOT NULL DEFAULT '0',
  `content` text NOT NULL,
  `ip` varchar(15) NOT NULL DEFAULT '0.0.0.0',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`,`status`,`id`),
  KEY `ip` (`ip`,`status`,`id`),
  KEY `status` (`status`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_member_convert`;
CREATE TABLE `dircms_member_convert` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `userid` int(8) NOT NULL,
  `nowmodelid` tinyint(8) NOT NULL,
  `modelid` int(8) NOT NULL,
  `username` varchar(36) CHARACTER SET utf8 NOT NULL,
  `amount` int(8) NOT NULL,
  `point` int(8) NOT NULL,
  `regtime` int(10) NOT NULL,
  `logintime` int(10) NOT NULL,
  `loginip` varchar(20) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`),
  KEY `userid_2` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_member_type`;
CREATE TABLE `dircms_member_type` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(80) NOT NULL,
  `grade` tinyint(5) NOT NULL DEFAULT '1',
  `parentid` int(20) NOT NULL DEFAULT '0',
  `orderby` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_member_type` VALUES('1','生活服务','1','0','1');
REPLACE INTO `dircms_member_type` VALUES('2','餐饮美食','1','0','2');
REPLACE INTO `dircms_member_type` VALUES('3','娱乐休闲','1','0','3');
REPLACE INTO `dircms_member_type` VALUES('4','旅游度假','1','0','4');
REPLACE INTO `dircms_member_type` VALUES('5','购物广场','1','0','5');
REPLACE INTO `dircms_member_type` VALUES('6','教育培训','1','0','6');
REPLACE INTO `dircms_member_type` VALUES('9','家政保洁','2','1','0');
REPLACE INTO `dircms_member_type` VALUES('10','搬家','2','1','0');
REPLACE INTO `dircms_member_type` VALUES('11','房产中介','2','1','0');
REPLACE INTO `dircms_member_type` VALUES('12','快递','2','1','0');
REPLACE INTO `dircms_member_type` VALUES('13','婚纱影楼','2','1','0');
REPLACE INTO `dircms_member_type` VALUES('14','婚庆礼仪','2','1','0');
REPLACE INTO `dircms_member_type` VALUES('15','婚介交友','2','1','0');
REPLACE INTO `dircms_member_type` VALUES('17','快餐','2','2','0');
REPLACE INTO `dircms_member_type` VALUES('18','火锅','2','2','0');
REPLACE INTO `dircms_member_type` VALUES('19','海鲜','2','2','0');
REPLACE INTO `dircms_member_type` VALUES('20','川菜','2','2','0');
REPLACE INTO `dircms_member_type` VALUES('21','京菜','2','2','0');
REPLACE INTO `dircms_member_type` VALUES('22','粤菜','2','2','0');
REPLACE INTO `dircms_member_type` VALUES('23','湘菜','2','2','0');
REPLACE INTO `dircms_member_type` VALUES('24','家常','2','2','0');
REPLACE INTO `dircms_member_type` VALUES('25','西餐','2','2','0');
REPLACE INTO `dircms_member_type` VALUES('26','风味','2','2','0');
REPLACE INTO `dircms_member_type` VALUES('28','酒吧','2','3','0');
REPLACE INTO `dircms_member_type` VALUES('29','茶楼','2','3','0');
REPLACE INTO `dircms_member_type` VALUES('30','咖啡厅','2','3','0');
REPLACE INTO `dircms_member_type` VALUES('31','俱乐部','2','3','0');
REPLACE INTO `dircms_member_type` VALUES('32','KTV','2','3','0');
REPLACE INTO `dircms_member_type` VALUES('33','洗浴足疗','2','3','0');
REPLACE INTO `dircms_member_type` VALUES('34','美容','2','3','0');
REPLACE INTO `dircms_member_type` VALUES('35','健身','2','3','0');
REPLACE INTO `dircms_member_type` VALUES('36','运动','2','3','0');
REPLACE INTO `dircms_member_type` VALUES('37','票务','2','3','0');
REPLACE INTO `dircms_member_type` VALUES('39','旅行社','2','4','0');
REPLACE INTO `dircms_member_type` VALUES('40','度假村','2','4','0');
REPLACE INTO `dircms_member_type` VALUES('41','景点','2','4','0');
REPLACE INTO `dircms_member_type` VALUES('42','酒店宾馆','2','4','0');
REPLACE INTO `dircms_member_type` VALUES('43','交通票务','2','4','0');
REPLACE INTO `dircms_member_type` VALUES('46','商场超市','2','5','0');
REPLACE INTO `dircms_member_type` VALUES('47','家电数码','2','5','0');
REPLACE INTO `dircms_member_type` VALUES('48','休闲运动','2','5','0');
REPLACE INTO `dircms_member_type` VALUES('49','文化艺术','2','5','0');
REPLACE INTO `dircms_member_type` VALUES('50','保健美容','2','5','0');
REPLACE INTO `dircms_member_type` VALUES('51','服装皮具','2','5','0');
REPLACE INTO `dircms_member_type` VALUES('52','眼镜钟表','2','5','0');
REPLACE INTO `dircms_member_type` VALUES('53','珠宝首饰','2','5','0');
REPLACE INTO `dircms_member_type` VALUES('55','外语','2','6','0');
REPLACE INTO `dircms_member_type` VALUES('56','IT','2','6','0');
REPLACE INTO `dircms_member_type` VALUES('57','家教','2','6','0');
REPLACE INTO `dircms_member_type` VALUES('58','管理财务','2','6','0');
REPLACE INTO `dircms_member_type` VALUES('59','艺术影视','2','6','0');
REPLACE INTO `dircms_member_type` VALUES('60','远程教育','2','6','0');
REPLACE INTO `dircms_member_type` VALUES('61','技能认证','2','6','0');
REPLACE INTO `dircms_member_type` VALUES('62','留学移民','2','6','0');
REPLACE INTO `dircms_member_type` VALUES('63','装饰装修','1','0','7');
REPLACE INTO `dircms_member_type` VALUES('65','装饰装修','2','63','0');
REPLACE INTO `dircms_member_type` VALUES('66','设计装修','2','63','0');
REPLACE INTO `dircms_member_type` VALUES('67','家居广场','2','63','0');
REPLACE INTO `dircms_member_type` VALUES('68','建材市场','2','63','0');
REPLACE INTO `dircms_member_type` VALUES('69','门窗','2','63','0');
DROP TABLE IF EXISTS `dircms_memberdb_fields`;
CREATE TABLE `dircms_memberdb_fields` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `modelid` mediumint(8) NOT NULL,
  `name` varchar(50) NOT NULL,
  `fieldname` varchar(100) NOT NULL,
  `tips` varchar(255) NOT NULL,
  `formtype` varchar(20) NOT NULL,
  `js` varchar(250) NOT NULL,
  `css` varchar(80) NOT NULL,
  `preg` varchar(255) NOT NULL,
  `defaultvalue` varchar(200) NOT NULL,
  `minsize` varchar(10) NOT NULL,
  `maxsize` varchar(10) NOT NULL,
  `optionvalue` text NOT NULL,
  `editorwidth` smallint(5) NOT NULL,
  `editorheight` smallint(5) NOT NULL,
  `orderby` tinyint(5) NOT NULL DEFAULT '0',
  `disabled` tinyint(1) NOT NULL DEFAULT '0',
  `isbase` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=gbk COMMENT='字段表';
REPLACE INTO `dircms_memberdb_fields` VALUES('3','1','realname','真实姓名','您的真实姓名或昵称：','text','','text_15x55','chinese','','0','20','选项名称1|选项值1\r\n选项名称2|选项值2','500','300','1','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('8','2','companyname','公司名称','','text','','text_15x225','limit','','2','255','选项名称1|选项值1\r\n选项名称2|选项值2','700','300','1','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('9','2','linkman','联 系 人','','text','','text_15x55','chinese','','0','40','选项名称1|选项值1\r\n选项名称2|选项值2','700','300','10','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('10','2','phone','联系电话','多个电话用，隔开','text','','text_15x105','limit','','0','80','选项名称1|选项值1\r\n选项名称2|选项值2','700','300','3','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('11','2','busroute','公交线路','','text','','text_15x105','limit','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','700','300','4','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('12','2','openingtime','开放时间','','text','','text_15x55','limit','8:00-17:30','0','30','选项名称1|选项值1\r\n选项名称2|选项值2','700','300','5','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('13','2','address','详细地址','','text','','text_15x225','limit','','2','255','选项名称1|选项值1\r\n选项名称2|选项值2','700','300','9','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('14','2','about','详细介绍','','editor','','','limit','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','550','200','14','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('15','2','companypic','公司图片','图片大小为：184px X 144px','image','','','limit','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','700','300','2','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('16','2','map','商家地图','标注到地图','map','','','','','0','80','选项名称1|选项值1\r\n选项名称2|选项值2','700','300','6','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('20','2','pics','商家图片','','images','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','650','250','7','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('21','2','shipin','视频展示','','videourl','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','650','250','8','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('22','2','qq','在线客服','','text','','','qq','QQ号码','3','15','选项名称1|选项值1\r\n选项名称2|选项值2','650','250','11','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('23','2','shenfenzheng','身 份 证','','image','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','650','250','12','0','1');
REPLACE INTO `dircms_memberdb_fields` VALUES('24','2','zhizhao','营业执照','','image','','','','','0','255','选项名称1|选项值1\r\n选项名称2|选项值2','650','250','13','0','1');
DROP TABLE IF EXISTS `dircms_membergrade`;
CREATE TABLE `dircms_membergrade` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `gradename` varchar(80) NOT NULL,
  `grade` varchar(10) NOT NULL,
  `amount` varchar(10) NOT NULL,
  `point` varchar(10) NOT NULL,
  `issystem` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_membergrade` VALUES('1','普通会员','10','0','0','1','1');
REPLACE INTO `dircms_membergrade` VALUES('2','高级会员','20','100','100','1','1');
DROP TABLE IF EXISTS `dircms_membergroup`;
CREATE TABLE `dircms_membergroup` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `groupname` varchar(200) NOT NULL,
  `orderby` int(6) NOT NULL,
  `issystem` tinyint(1) NOT NULL DEFAULT '0',
  `isdisabled` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=gbk COMMENT='会员组表';
REPLACE INTO `dircms_membergroup` VALUES('1','管理员','0','1','0');
REPLACE INTO `dircms_membergroup` VALUES('2','游客','1','1','0');
REPLACE INTO `dircms_membergroup` VALUES('3','待审核','2','1','0');
REPLACE INTO `dircms_membergroup` VALUES('4','注册会员','3','1','0');
DROP TABLE IF EXISTS `dircms_memberhonor`;
CREATE TABLE `dircms_memberhonor` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `honorname` varchar(80) NOT NULL,
  `point` varchar(10) NOT NULL,
  `ico` varchar(10) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_memberhonor` VALUES('1','列兵','10','1','1');
REPLACE INTO `dircms_memberhonor` VALUES('2','班长','20','2','1');
DROP TABLE IF EXISTS `dircms_membermodel`;
CREATE TABLE `dircms_membermodel` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '模型ID',
  `name` varchar(30) NOT NULL COMMENT '模型名',
  `modelname` varchar(50) NOT NULL COMMENT '模型名称',
  `template` varchar(80) NOT NULL,
  `stemplate` varchar(80) NOT NULL DEFAULT 'search_result',
  `register_enabled` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否开放注册',
  `isinstall` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否禁用',
  `iscompany` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gbk COMMENT='会员模型表';
REPLACE INTO `dircms_membermodel` VALUES('1','nomalmember','普通会员','space_geren','search_result','1','1','0');
REPLACE INTO `dircms_membermodel` VALUES('2','corporatemember','企业会员','default','search_space','1','1','1');
DROP TABLE IF EXISTS `dircms_message`;
CREATE TABLE `dircms_message` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `send_from_user` varchar(30) NOT NULL,
  `send_to_user` varchar(30) NOT NULL,
  `folder` enum('all','inbox','outbox') NOT NULL,
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `message_time` int(10) unsigned NOT NULL DEFAULT '0',
  `subject` char(200) NOT NULL,
  `content` text NOT NULL,
  `replyid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `msgtoid` (`send_to_user`,`folder`),
  KEY `replyid` (`replyid`),
  KEY `folder` (`send_from_user`,`folder`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_model`;
CREATE TABLE `dircms_model` (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '模型ID',
  `name` varchar(50) NOT NULL COMMENT '模型名',
  `modelname` varchar(50) NOT NULL COMMENT '模型名称',
  `isinstall` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否禁用',
  `categorytlp` varchar(80) NOT NULL,
  `listtlp` varchar(80) NOT NULL,
  `contenttlp` varchar(80) NOT NULL,
  `stemplate` varchar(80) NOT NULL DEFAULT 'search_result',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=gbk COMMENT='模型表';
REPLACE INTO `dircms_model` VALUES('1','article','文章','1','category_news','final_category_news','show_news','search_result');
REPLACE INTO `dircms_model` VALUES('9','tg','团购','1','category_tg','final_category_tg','show_tg','search_result');
REPLACE INTO `dircms_model` VALUES('4','chuzu','房屋','1','category_chuzu','final_category_chuzu','show_chuzu','search_chuzu');
REPLACE INTO `dircms_model` VALUES('5','movie','视频','1','category_movie','final_category_movie','show_movie','search_movie');
REPLACE INTO `dircms_model` VALUES('6','ershou','二手','1','category_ershou','final_category_ershou','show_ershou','search_ershou');
REPLACE INTO `dircms_model` VALUES('7','job','招聘','1','category_job','final_category_job','show_job','search_job');
REPLACE INTO `dircms_model` VALUES('8','xinxi','信息','1','category_xinxi','final_category_xinxi','show_xinxi','search_xinxi');
REPLACE INTO `dircms_model` VALUES('10','loupan','楼盘','1','category_lp','final_category_lp','show_lp','search_lp');
DROP TABLE IF EXISTS `dircms_movie`;
CREATE TABLE `dircms_movie` (
  `contentid` mediumint(8) NOT NULL,
  `content` mediumtext NOT NULL,
  `daoyan` varchar(100) NOT NULL,
  `zhuyan` varchar(255) NOT NULL,
  `guojia` varchar(255) NOT NULL,
  `leixing` varchar(255) NOT NULL,
  `yuyan` varchar(255) NOT NULL,
  `pianchang` varchar(10) NOT NULL,
  `banben` varchar(255) NOT NULL,
  `dizhi` varchar(255) NOT NULL,
  `haibao` mediumtext NOT NULL,
  KEY `contentid` (`contentid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_nomalmember`;
CREATE TABLE `dircms_nomalmember` (
  `userid` int(20) NOT NULL,
  `realname` varchar(50) DEFAULT NULL,
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_notice`;
CREATE TABLE `dircms_notice` (
  `id` tinyint(5) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `content` text NOT NULL,
  `time` varchar(10) NOT NULL DEFAULT '0',
  `orderby` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_notice` VALUES('1','网站隆重上线啦！','<p>谢谢您的访问！</p>','1290074105','1');
DROP TABLE IF EXISTS `dircms_order`;
CREATE TABLE `dircms_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `orderid` varchar(32) NOT NULL DEFAULT '0',
  `goodsid` char(32) NOT NULL,
  `goodsname` char(80) NOT NULL,
  `goodsurl` char(100) NOT NULL,
  `price` decimal(8,2) unsigned NOT NULL DEFAULT '0.00',
  `number` smallint(5) unsigned NOT NULL DEFAULT '0',
  `carriage` decimal(8,2) unsigned NOT NULL DEFAULT '0.00',
  `amount` decimal(8,2) unsigned DEFAULT '0.00',
  `consignee` char(40) NOT NULL,
  `cargomethodid` tinyint(5) NOT NULL DEFAULT '0',
  `areaid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `telephone` char(20) NOT NULL,
  `mobile` char(15) NOT NULL,
  `address` char(200) NOT NULL,
  `postcode` char(6) NOT NULL,
  `note` char(255) NOT NULL,
  `memo` char(255) NOT NULL,
  `userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `username` char(20) NOT NULL,
  `ip` char(15) NOT NULL,
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  `date` date NOT NULL DEFAULT '0000-00-00',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`,`status`),
  KEY `goodsid` (`goodsid`,`status`,`date`,`id`),
  KEY `date` (`status`,`date`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_page`;
CREATE TABLE `dircms_page` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `catid` mediumint(8) NOT NULL DEFAULT '0',
  `pagename` varchar(50) NOT NULL,
  `meta_title` varchar(255) NOT NULL,
  `meta_keywords` varchar(255) NOT NULL,
  `meta_description` varchar(255) NOT NULL,
  `filename` varchar(30) NOT NULL,
  `dir` varchar(20) NOT NULL,
  `template` varchar(64) NOT NULL,
  `content` mediumtext NOT NULL,
  `mtime` varchar(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_page` VALUES('17','12','联系我们','联系我们','联系我们','联系我们','connectus','about','page_about','<p>联系我们</p>','0');
REPLACE INTO `dircms_page` VALUES('16','11','关于我们','易创网站管理系统','易创CMS是简单易用的cms,dircms,Dircms内容管理系统','易创网站管理系统(DIRCMS)是国内自主开发的一款具有强大的系统功能并且永久开源，操作简单的内容管理系统，其产品之一Lifecms也是用户支持率较高的PHP地方生活门户系统之一.','index','about','page_about','<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 易创网站管理系统(DIRCMS)是国内自主开发的一款具有强大的系统功能并且永久开源，操作简单的内容管理系统，其产品之一Lifecms也是用户支持率较高的PHP地方生活门户系统之一，而且其PHP源码也是完全开源的。 拥有文章、图片、下载、留言、友情链接、广告系统、自定义模型、自定义表单等众多丰富的功能模型；同时系统具有灵活的产品架构、严密的安全性、系统百分百开放源代码方便功能的扩展，采用PHP+Mysql数据库架构，适合于各行各类的网站应用平台。</p>','1291008354');
REPLACE INTO `dircms_page` VALUES('19','14','法律条款','法律条款','法律条款','法律条款','contract','about','page_about','<p>法律条款</p>','0');
REPLACE INTO `dircms_page` VALUES('20','45','关于我们','关于我们','关于我们','关于我们','index','about','page_about','<p>页面内容</p>','0');
REPLACE INTO `dircms_page` VALUES('21','46','联系我们','联系我们','联系我们','联系我们','connectus','about','page_about','<p>页面内容</p>','0');
REPLACE INTO `dircms_page` VALUES('22','47','法律条款','法律条款','法律条款','法律条款','contract','about','page_about','<p>页面内容</p>','0');
REPLACE INTO `dircms_page` VALUES('23','0','如何加入黄页?','如何加入黄页','如何加入黄页','如何加入黄页','company','about','page_about','<p>页面内容</p>','1292489323');
REPLACE INTO `dircms_page` VALUES('24','124','如何参与团购？','','','','tg','about','page_about','<p>页面内容</p>','0');
DROP TABLE IF EXISTS `dircms_pay_exchange`;
CREATE TABLE `dircms_pay_exchange` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `type` enum('amount','point') NOT NULL,
  `number` decimal(8,2) NOT NULL,
  `blance` decimal(8,2) unsigned NOT NULL DEFAULT '0.00',
  `userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `username` char(30) NOT NULL DEFAULT 'anonymity',
  `inputid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `inputer` char(30) NOT NULL DEFAULT 'anonymity',
  `ip` char(15) NOT NULL DEFAULT '0.0.0.0',
  `time` int(10) NOT NULL DEFAULT '0',
  `note` char(200) NOT NULL,
  `authid` char(32) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`,`type`,`id`),
  KEY `inputid` (`inputid`,`type`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_pay_method`;
CREATE TABLE `dircms_pay_method` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL,
  `name` varchar(120) NOT NULL,
  `desc` text NOT NULL,
  `fee` varchar(10) NOT NULL,
  `config` text NOT NULL,
  `is_cod` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_online` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `orderby` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `author` varchar(100) NOT NULL,
  `website` varchar(100) NOT NULL,
  `version` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_pay_method` VALUES('1','alipay','支付宝','支付宝网站(www.alipay.com) 是国内先进的网上支付平台。\r\nDedeCMS联合支付宝推出支付宝接口。','0','array (\n  \'alipay_account\' => \'\',\n  \'alipay_key\' => \'\',\n  \'alipay_partner\' => \'\',\n  \'service_type\' => \'0\',\n)','0','1','0','1','DirCMS','http://www.alipay.com','1.0.0');
REPLACE INTO `dircms_pay_method` VALUES('2','post','邮局汇款','收款人信息：姓名 ××× ；地址 ××× ；邮编 ××× 。\r\n注意事项： 请在汇款单背面的附言中注明您的订单号，只填写后6位即可。','0.0','','0','0','0','1','DirCMS','','1.0.0');
REPLACE INTO `dircms_pay_method` VALUES('3','bank','银行汇款/转帐','银行名称\r\n收款人信息：全称 ××× ；帐号或地址 ××× ；开户行 ×××。\r\n注意事项：办理电汇时，请在电汇单“汇款用途”一栏处注明您的订单号。','0.0','','0','0','0','1','DirCMS','','1.0.0');
DROP TABLE IF EXISTS `dircms_pay_user_account`;
CREATE TABLE `dircms_pay_user_account` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `username` char(20) NOT NULL DEFAULT 'anonymity',
  `email` char(40) NOT NULL,
  `contactname` char(50) NOT NULL,
  `telephone` char(20) NOT NULL,
  `sn` char(50) NOT NULL,
  `inputer` char(20) NOT NULL,
  `inputerid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `amount` decimal(8,2) unsigned NOT NULL,
  `quantity` decimal(8,2) unsigned NOT NULL,
  `addtime` int(10) NOT NULL DEFAULT '0',
  `paytime` int(10) NOT NULL DEFAULT '0',
  `adminnote` char(255) NOT NULL,
  `usernote` char(255) NOT NULL,
  `type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `payment` char(90) NOT NULL,
  `ip` char(15) NOT NULL DEFAULT '0.0.0.0',
  `ispay` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `ispay` (`ispay`),
  KEY `sn` (`sn`,`amount`,`ispay`,`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_plus`;
CREATE TABLE `dircms_plus` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `author` varchar(100) NOT NULL DEFAULT 'DirCMS开发团队',
  `link` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk COMMENT='插件表';
DROP TABLE IF EXISTS `dircms_pointcard`;
CREATE TABLE `dircms_pointcard` (
  `id` tinyint(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `point` int(5) unsigned NOT NULL DEFAULT '0',
  `price` varchar(5) NOT NULL DEFAULT '0',
  `orderby` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_pointcard` VALUES('1','白金卡','200','10.5','1');
REPLACE INTO `dircms_pointcard` VALUES('2','牡丹卡','100','5.0','2');
DROP TABLE IF EXISTS `dircms_posid`;
CREATE TABLE `dircms_posid` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `posname` varchar(255) NOT NULL,
  `orderby` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=gbk COMMENT='推荐位';
REPLACE INTO `dircms_posid` VALUES('3','首页推荐','1');
REPLACE INTO `dircms_posid` VALUES('5','栏目页推荐','2');
REPLACE INTO `dircms_posid` VALUES('6','内容页推荐','3');
REPLACE INTO `dircms_posid` VALUES('7','栏目焦点图','4');
REPLACE INTO `dircms_posid` VALUES('8','首页焦点图','5');
REPLACE INTO `dircms_posid` VALUES('12','推荐分类信息','0');
DROP TABLE IF EXISTS `dircms_role`;
CREATE TABLE `dircms_role` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `orderby` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `issystem` tinyint(1) NOT NULL DEFAULT '0',
  `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_role` VALUES('1','超级管理员','1','1','0');
REPLACE INTO `dircms_role` VALUES('7','网站总编','2','1','0');
REPLACE INTO `dircms_role` VALUES('9','栏目编辑','3','1','0');
REPLACE INTO `dircms_role` VALUES('10','美工设计师','4','1','0');
REPLACE INTO `dircms_role` VALUES('11','会计人员','5','1','0');
DROP TABLE IF EXISTS `dircms_session`;
CREATE TABLE `dircms_session` (
  `sessionid` char(32) NOT NULL,
  `userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `ip` char(15) NOT NULL,
  `lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
  `data` char(255) NOT NULL,
  PRIMARY KEY (`sessionid`),
  KEY `lastvisit` (`lastvisit`)
) ENGINE=MEMORY DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_sign`;
CREATE TABLE `dircms_sign` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `userid` mediumint(8) NOT NULL,
  `contentid` mediumint(8) NOT NULL,
  `username` varchar(80) NOT NULL,
  `sex` tinyint(1) NOT NULL DEFAULT '1',
  `tel` varchar(80) NOT NULL,
  `email` varchar(100) NOT NULL,
  `qq` varchar(18) NOT NULL,
  `num` mediumint(8) NOT NULL DEFAULT '0',
  `msg` text NOT NULL,
  `title` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  KEY `contentid` (`contentid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_tg`;
CREATE TABLE `dircms_tg` (
  `contentid` mediumint(8) NOT NULL,
  `content` mediumtext NOT NULL,
  `yuanjia` varchar(20) NOT NULL,
  `zhekou` varchar(255) NOT NULL,
  `pics` mediumtext NOT NULL,
  `tel` varchar(50) NOT NULL,
  `dizhi` varchar(255) NOT NULL,
  `jiaotong` varchar(255) NOT NULL,
  `lianxiren` varchar(50) NOT NULL,
  `kaishi` varchar(255) NOT NULL,
  `jiezhi` varchar(255) NOT NULL,
  `map` varchar(255) NOT NULL,
  `bm` varchar(255) NOT NULL,
  KEY `contentid` (`contentid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_type`;
CREATE TABLE `dircms_type` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `modelid` int(5) NOT NULL,
  `name` varchar(200) NOT NULL,
  `islocked` tinyint(1) NOT NULL DEFAULT '0',
  `orderby` tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_vote`;
CREATE TABLE `dircms_vote` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `votename` varchar(50) NOT NULL DEFAULT '',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0',
  `endtime` int(10) unsigned NOT NULL DEFAULT '0',
  `delay` int(10) NOT NULL DEFAULT '0',
  `totalcount` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `ismore` tinyint(6) NOT NULL DEFAULT '0',
  `votenote` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gbk;
REPLACE INTO `dircms_vote` VALUES('1','您以为我们的服务哪方面有待提高？','1290960000','1293552000','86400','7','1','<vote id=\"1\" count=\"1\">产品质量</vote>\r\n<vote id=\"2\" count=\"2\">售后服务</vote>\r\n<vote id=\"3\" count=\"2\">发货速度</vote>\r\n<vote id=\"4\" count=\"2\">其他</vote>\r\n');
DROP TABLE IF EXISTS `dircms_vote_ip`;
CREATE TABLE `dircms_vote_ip` (
  `voteid` mediumint(8) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `votetime` int(10) NOT NULL,
  KEY `voteid` (`voteid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
DROP TABLE IF EXISTS `dircms_xinxi`;
CREATE TABLE `dircms_xinxi` (
  `contentid` mediumint(8) NOT NULL,
  `content` mediumtext NOT NULL,
  `lianxiren` varchar(255) NOT NULL,
  `qq` varchar(255) NOT NULL,
  `dianhua` varchar(80) NOT NULL,
  `email` varchar(255) NOT NULL,
  `tupian` mediumtext NOT NULL,
  `youxiaoqi` varchar(50) NOT NULL,
  `xingzhi` varchar(255) NOT NULL,
  KEY `contentid` (`contentid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;