-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.5.24-log - MySQL Community Server (GPL)
-- Server OS:                    Win64
-- HeidiSQL version:             7.0.0.4053
-- Date/time:                    2012-12-24 15:09:52
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

-- Dumping structure for table ci_pw_house.pw_admin_auth
CREATE TABLE IF NOT EXISTS `pw_admin_auth` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `username` varchar(15) NOT NULL DEFAULT '' COMMENT '用户名',
  `roles` varchar(255) NOT NULL DEFAULT '' COMMENT '角色',
  `created_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `modified_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后修改时间',
  PRIMARY KEY (`id`),
  KEY `idx_uid` (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户权限角色表（后台用户权限与角色关系表：即时用户名属于什么用户角色，即拥有什么权限，一个用户可以允许有多个角色）';

-- Dumping data for table ci_pw_house.pw_admin_auth: 1 rows
/*!40000 ALTER TABLE `pw_admin_auth` DISABLE KEYS */;
INSERT INTO `pw_admin_auth` (`id`, `uid`, `username`, `roles`, `created_time`, `modified_time`) VALUES
	(1, 2, 'user1', '管理员', 1352450908, 1352450908);
/*!40000 ALTER TABLE `pw_admin_auth` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_admin_custom
CREATE TABLE IF NOT EXISTS `pw_admin_custom` (
  `username` varchar(15) NOT NULL COMMENT '用户名',
  `custom` text NOT NULL COMMENT '常用菜单项',
  PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='后台常用菜单表';

-- Dumping data for table ci_pw_house.pw_admin_custom: 1 rows
/*!40000 ALTER TABLE `pw_admin_custom` DISABLE KEYS */;
INSERT INTO `pw_admin_custom` (`username`, `custom`) VALUES
	('user1', 'config_site');
/*!40000 ALTER TABLE `pw_admin_custom` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_admin_log
CREATE TABLE IF NOT EXISTS `pw_admin_log` (
  `logid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` char(50) NOT NULL DEFAULT '',
  `operation` varchar(255) NOT NULL DEFAULT '',
  `ip` int(10) unsigned NOT NULL DEFAULT '0',
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`logid`),
  KEY `idx_userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='后台操作日志表';

-- Dumping data for table ci_pw_house.pw_admin_log: 0 rows
/*!40000 ALTER TABLE `pw_admin_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_admin_log` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_admin_role
CREATE TABLE IF NOT EXISTS `pw_admin_role` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(15) NOT NULL DEFAULT '' COMMENT '角色名',
  `auths` text COMMENT '权限点',
  `created_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `modified_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后修改时间',
  PRIMARY KEY (`id`),
  KEY `idx_name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='后台用户角色表（后台权限用户组）';

-- Dumping data for table ci_pw_house.pw_admin_role: 1 rows
/*!40000 ALTER TABLE `pw_admin_role` DISABLE KEYS */;
INSERT INTO `pw_admin_role` (`id`, `name`, `auths`, `created_time`, `modified_time`) VALUES
	(1, '管理员', 'custom_set,config_site,config_nav,config_register,config_credit,config_editor,config_emotion,config_attachment,config_watermark,config_verifycode,config_seo,config_rewrite,config_domain,config_email,config_pay,config_area,config_school,u_groups,u_upgrade,u_manage,u_forbidden,u_check,bbs_article,contents_tag,contents_message,contents_report,bbs_contentcheck_forum,contentcheck_word,contents_user_tag,bbs_recycle,bbs_configbbs,bbs_setforum,bbs_setbbs,design_page,design_component,design_module,design_push,design_permissions,database_backup,cache_m,data_hook,cron_operations,app_album,app_vote,app_medal,app_task,app_punch,app_link,app_message,app_announce,platform_server,platform_appList,platform_server_check,platform_index,platform_siteStyle', 1340275489, 1347092145);
/*!40000 ALTER TABLE `pw_admin_role` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_common_announce
CREATE TABLE IF NOT EXISTS `pw_common_announce` (
  `announceid` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Civ1：公告id',
  `type` enum('text','url') NOT NULL DEFAULT 'text' COMMENT 'pw：类型',
  `url` varchar(80) NOT NULL DEFAULT '' COMMENT 'pw：地址',
  `subject` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：标题',
  `content` text NOT NULL COMMENT 'pw：内容',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Civ1：发布人id',
  `username` varchar(15) NOT NULL DEFAULT '' COMMENT 'Civ1：发布人帐号',
  `created` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Civ1：创建时间',
  `start_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：开始日期',
  `end_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：结束日期',
  `vieworder` smallint(6) NOT NULL DEFAULT '0' COMMENT 'pw：排序',
  PRIMARY KEY (`announceid`),
  KEY `idx_startdate` (`start_date`),
  KEY `idx_vieworder` (`vieworder`),
  KEY `idx_enddate` (`end_date`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='公告管理表';

-- Dumping data for table ci_pw_house.pw_common_announce: 9 rows
/*!40000 ALTER TABLE `pw_common_announce` DISABLE KEYS */;
INSERT INTO `pw_common_announce` (`announceid`, `type`, `url`, `subject`, `content`, `uid`, `username`, `created`, `start_date`, `end_date`, `vieworder`) VALUES
	(2, 'text', '', '公告1', '', 1, 'admin', 1354864079, 1354924800, 1356825600, 0),
	(3, 'text', '', '公告2', '', 1, 'admin', 1354864079, 1354924800, 1356825600, 0),
	(4, 'text', '', '公告3', '', 1, 'admin', 1354864079, 1353924800, 1353924800, 0),
	(5, 'text', '', '公告4', '', 1, 'admin', 1354864079, 1354924800, 1356825600, 0),
	(6, 'text', '', '公告5', '', 1, 'admin', 1354864079, 1354924800, 1356827874, 0),
	(7, 'text', '', '标题1', '内容1', 1, 'admin', 1354864079, 1354838400, 1355011200, 0),
	(8, 'url', 'http://localhost/codeigniter/pwhouse/', '标题2', '', 1, 'admin', 1354864079, 1354924800, 1355702400, 0),
	(9, 'text', '', '标题3', '内容3', 1, 'admin', 1354864293, 1354838400, 1355011200, 0),
	(12, 'text', '', '标题2', '标题2', 1, 'admin', 1354866803, 1354838400, 1355616000, 0);
/*!40000 ALTER TABLE `pw_common_announce` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_common_config
CREATE TABLE IF NOT EXISTS `pw_common_config` (
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `namespace` varchar(15) NOT NULL DEFAULT 'global' COMMENT '配置命名空间',
  `value` text NOT NULL COMMENT '缓存值',
  `vtype` enum('string','array','object') NOT NULL DEFAULT 'string' COMMENT '配置值类型',
  `description` text NOT NULL COMMENT '配置介绍',
  PRIMARY KEY (`namespace`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='网站配置表';

-- Dumping data for table ci_pw_house.pw_common_config: 0 rows
/*!40000 ALTER TABLE `pw_common_config` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_common_config` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_common_link
CREATE TABLE IF NOT EXISTS `pw_common_link` (
  `linkid` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'CIv1：友情链接id',
  `type` enum('all','newhouse','secondhouse') NOT NULL DEFAULT 'newhouse' COMMENT 'CIv1：类型',
  `name` varchar(15) NOT NULL DEFAULT '' COMMENT 'pw：名称',
  `url` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：链接',
  `descrip` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：描述',
  `logo` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：logo',
  `iflogo` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否有logo（前端显示时有logo的分类）',
  `contact` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：联系方式',
  `created` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：创建时间',
  `updated` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：修改时间',
  `ifcheck` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否审核',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：排序',
  PRIMARY KEY (`linkid`),
  KEY `idx_ifcheck_vieworder` (`ifcheck`,`vieworder`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='CIv1：友情链接表';

-- Dumping data for table ci_pw_house.pw_common_link: 3 rows
/*!40000 ALTER TABLE `pw_common_link` DISABLE KEYS */;
INSERT INTO `pw_common_link` (`linkid`, `type`, `name`, `url`, `descrip`, `logo`, `iflogo`, `contact`, `created`, `updated`, `ifcheck`, `vieworder`) VALUES
	(2, 'newhouse', '2友情网站', 'http://localhost/test/phpwind90rc/', '', '', 0, '', 0, 0, 1, 0),
	(3, 'secondhouse', '3二手首页', 'http://localhost/test/phpwind90rc/', '', '', 0, '', 0, 0, 1, 0),
	(4, 'all', '4友情网站', 'http://地址', '', '', 0, '', 0, 0, 1, 0);
/*!40000 ALTER TABLE `pw_common_link` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_fields
CREATE TABLE IF NOT EXISTS `pw_h_fields` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：选项id',
  `type` varchar(20) NOT NULL DEFAULT '' COMMENT 'pw：字段名称',
  `fieldvalue` varchar(80) NOT NULL DEFAULT '' COMMENT 'pw：选项名称',
  `vieworder` smallint(6) NOT NULL DEFAULT '0' COMMENT 'pw：排序',
  `ifopen` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'pw：是否开启',
  `parent` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：父id',
  PRIMARY KEY (`type`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：房产共用字段表';

-- Dumping data for table ci_pw_house.pw_h_fields: 42 rows
/*!40000 ALTER TABLE `pw_h_fields` DISABLE KEYS */;
INSERT INTO `pw_h_fields` (`id`, `type`, `fieldvalue`, `vieworder`, `ifopen`, `parent`) VALUES
	(1, 'property', '别墅', 6, 1, 0),
	(2, 'property', '普通住宅', 1, 1, 0),
	(3, 'property', '公寓', 2, 1, 0),
	(4, 'property', '花园式洋房', 3, 1, 0),
	(5, 'property', '酒店式公寓', 10, 1, 0),
	(6, 'property', '商住两用', 5, 1, 0),
	(7, 'property', '写字楼', 7, 1, 0),
	(8, 'property', '商铺', 8, 1, 0),
	(1, 'buildtype', '低层', 1, 1, 0),
	(2, 'buildtype', '多层', 2, 1, 0),
	(3, 'buildtype', '小高层', 3, 1, 0),
	(4, 'buildtype', '高层', 4, 1, 0),
	(5, 'buildtype', '超高层', 5, 1, 0),
	(1, 'paystatus', '简装修', 0, 1, 0),
	(2, 'paystatus', '毛坯', 4, 1, 0),
	(3, 'paystatus', '精装修', 1, 1, 0),
	(1, 'housetype', '学区房', 0, 1, 0),
	(2, 'housetype', '地铁房', 2, 1, 0),
	(3, 'housetype', '江景房', 3, 1, 0),
	(4, 'housetype', '景区房', 4, 1, 0),
	(5, 'housetype', '新婚房', 5, 1, 0),
	(6, 'housetype', '养老房', 6, 1, 0),
	(1, 'propertyright', '经济适用房', 4, 1, 0),
	(2, 'propertyright', '商品房', 2, 1, 0),
	(3, 'propertyright', '使用权', 3, 1, 0),
	(4, 'propertyright', '个人产权', 1, 1, 0),
	(5, 'propertyright', '公司产权', 5, 1, 0),
	(1, 'amenities', '水', 1, 1, 0),
	(2, 'amenities', '电', 2, 1, 0),
	(3, 'amenities', '煤气/天然气', 3, 1, 0),
	(4, 'amenities', '暖气', 4, 1, 0),
	(5, 'amenities', '有线电视', 5, 1, 0),
	(6, 'amenities', '宽带', 6, 1, 0),
	(7, 'amenities', '家具', 7, 1, 0),
	(8, 'amenities', '车位/车库', 8, 1, 0),
	(9, 'amenities', '电梯', 9, 1, 0),
	(1, 'score', '交通', 1, 1, 0),
	(2, 'score', '环境', 2, 1, 0),
	(3, 'score', '规划', 3, 1, 0),
	(4, 'score', '配套', 4, 1, 0),
	(5, 'score', '开发商', 5, 1, 0),
	(1, 'plate', '厚兴', 1, 1, 3);
/*!40000 ALTER TABLE `pw_h_fields` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_fields_area
CREATE TABLE IF NOT EXISTS `pw_h_fields_area` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：自增id',
  `code` varchar(8) NOT NULL DEFAULT '' COMMENT 'pw：行政区划代码',
  `name` varchar(60) NOT NULL DEFAULT '' COMMENT 'pw：区域名称',
  `ifopen` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'pw：是否开启',
  `ord` smallint(6) NOT NULL DEFAULT '0' COMMENT 'pw：排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='pw：房产共用字段之所属区域表';

-- Dumping data for table ci_pw_house.pw_h_fields_area: 4 rows
/*!40000 ALTER TABLE `pw_h_fields_area` DISABLE KEYS */;
INSERT INTO `pw_h_fields_area` (`id`, `code`, `name`, `ifopen`, `ord`) VALUES
	(2, '442000', '中山市', 1, 0),
	(3, '805352', '东区', 1, 0),
	(4, '836396', '南区', 1, 0),
	(5, '476137', '其他区', 1, 0);
/*!40000 ALTER TABLE `pw_h_fields_area` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_fields_vrange
CREATE TABLE IF NOT EXISTS `pw_h_fields_vrange` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：选项id',
  `type` varchar(20) NOT NULL DEFAULT '' COMMENT 'pw：字段名称',
  `fieldvalue` varchar(80) NOT NULL DEFAULT '' COMMENT 'pw：选项名称',
  `vstart` mediumint(8) NOT NULL DEFAULT '0' COMMENT 'pw：区间起始值',
  `vend` mediumint(8) NOT NULL DEFAULT '0' COMMENT 'pw：区间结束值',
  `vieworder` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：排序',
  `ifopen` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'pw：是否开启',
  PRIMARY KEY (`type`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：房产共用字段之区间数据表';

-- Dumping data for table ci_pw_house.pw_h_fields_vrange: 29 rows
/*!40000 ALTER TABLE `pw_h_fields_vrange` DISABLE KEYS */;
INSERT INTO `pw_h_fields_vrange` (`id`, `type`, `fieldvalue`, `vstart`, `vend`, `vieworder`, `ifopen`) VALUES
	(1, 'aveprice', '3000以下', 0, 3000, 0, 1),
	(2, 'aveprice', '3000-5000', 3000, 5000, 1, 1),
	(3, 'aveprice', '5000-7000', 5000, 7000, 2, 1),
	(4, 'aveprice', '7000-10000', 7000, 10000, 3, 1),
	(5, 'aveprice', '10000-13000', 10000, 13000, 4, 1),
	(6, 'aveprice', '13000-16000', 13000, 16000, 5, 1),
	(7, 'aveprice', '16000-20000', 16000, 20000, 6, 1),
	(8, 'aveprice', '20000-25000', 20000, 25000, 7, 1),
	(9, 'aveprice', '25000以上', 25000, 0, 8, 1),
	(1, 'budget', '30万以下', 0, 300000, 0, 1),
	(2, 'budget', '30万-40万', 300000, 400000, 1, 1),
	(3, 'budget', '40万-50万', 400000, 500000, 2, 1),
	(4, 'budget', '50万-60万', 500000, 600000, 3, 1),
	(5, 'budget', '60万-80万', 600000, 800000, 4, 1),
	(6, 'budget', '80万以上', 800000, 0, 5, 1),
	(1, 'acreage', '50平米以下', 0, 50, 0, 1),
	(2, 'acreage', '50-70平米', 50, 70, 1, 1),
	(3, 'acreage', '70-100平米', 70, 100, 2, 1),
	(4, 'acreage', '100-150平米', 100, 150, 3, 1),
	(5, 'acreage', '150-200平米', 150, 200, 4, 1),
	(6, 'acreage', '200平米以上', 200, 0, 5, 1),
	(1, 'rentprice', '500元以下', 0, 500, 0, 1),
	(2, 'rentprice', '500-1000元', 500, 1000, 1, 1),
	(3, 'rentprice', '1000-1500元', 1000, 1500, 2, 1),
	(4, 'rentprice', '1500-2000元', 1500, 2000, 3, 1),
	(5, 'rentprice', '2000元以上', 2000, 0, 4, 1),
	(1, 'sellprice', '50万以内', 0, 50, 0, 1),
	(2, 'sellprice', '50-100万', 50, 100, 1, 1),
	(3, 'sellprice', '100万以上', 100, 0, 2, 1);
/*!40000 ALTER TABLE `pw_h_fields_vrange` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_developer
CREATE TABLE IF NOT EXISTS `pw_h_new_developer` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：id',
  `name` varchar(80) NOT NULL DEFAULT '' COMMENT 'pw：开发商名称',
  `level` varchar(120) NOT NULL DEFAULT '' COMMENT 'pw：资质等级',
  `address` varchar(120) NOT NULL DEFAULT '' COMMENT 'pw：开发商地址',
  `zipcode` varchar(6) NOT NULL DEFAULT '' COMMENT 'pw：邮政编码',
  `email` varchar(60) NOT NULL DEFAULT '' COMMENT 'pw：Email',
  `url` varchar(120) NOT NULL DEFAULT '' COMMENT 'pw：开发商网站',
  `principal` varchar(20) NOT NULL DEFAULT '' COMMENT 'pw：负责人',
  `linkman` varchar(20) NOT NULL DEFAULT '' COMMENT 'pw：联系人',
  `tel` varchar(30) NOT NULL DEFAULT '' COMMENT 'pw：联系电话',
  `fax` varchar(30) NOT NULL DEFAULT '' COMMENT 'pw：传真电话',
  `introduction` text NOT NULL COMMENT 'pw：开发商简介',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='pw：开发商信息表';

-- Dumping data for table ci_pw_house.pw_h_new_developer: 1 rows
/*!40000 ALTER TABLE `pw_h_new_developer` DISABLE KEYS */;
INSERT INTO `pw_h_new_developer` (`id`, `name`, `level`, `address`, `zipcode`, `email`, `url`, `principal`, `linkman`, `tel`, `fax`, `introduction`) VALUES
	(1, '开发商名称', '资质等级', '公司地址', '邮政编码', 'Email', '网址', '负责人', '联系人', '联系电话', '传真', '公司简介');
/*!40000 ALTER TABLE `pw_h_new_developer` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_evaluations
CREATE TABLE IF NOT EXISTS `pw_h_new_evaluations` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：id',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：uid',
  `username` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：用户名',
  `hid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘id',
  `hname` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：楼盘名称',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：点评时间',
  `ctype` enum('evaluation','score') NOT NULL DEFAULT 'evaluation' COMMENT 'pw：类型（evaluation:点评 score:评分）',
  `content` text NOT NULL COMMENT 'pw：评论内容',
  `total` text NOT NULL COMMENT 'pw：',
  `ifcheck` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否审核 1审核 0未审',
  PRIMARY KEY (`id`),
  KEY `hid` (`hid`),
  KEY `uid` (`uid`),
  KEY `hname` (`hname`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='pw：楼盘楼盘评论表';

-- Dumping data for table ci_pw_house.pw_h_new_evaluations: 4 rows
/*!40000 ALTER TABLE `pw_h_new_evaluations` DISABLE KEYS */;
INSERT INTO `pw_h_new_evaluations` (`id`, `uid`, `username`, `hid`, `hname`, `ctime`, `ctype`, `content`, `total`, `ifcheck`) VALUES
	(1, 1, '', 1, '楼盘名称', 1329183384, 'evaluation', '萨法撒旦发', '', 1),
	(2, 0, '', 1, '', 1330395065, 'score', 'a:10:{s:8:"actCount";i:2;s:11:"defindCount";i:0;i:1;a:2:{s:3:"act";i:80;s:3:"def";i:10;}i:2;a:2:{s:3:"act";i:80;s:3:"def";i:4;}i:3;a:2:{s:3:"act";i:80;s:3:"def";i:0;}i:4;a:2:{s:3:"act";i:80;s:3:"def";i:0;}i:5;a:2:{s:3:"act";i:80;s:3:"def";i:0;}s:15:"actAverageScore";d:80;s:18:"defindAverageScore";d:82;s:15:"totalEvaluation";s:8:"非常好哦";}', '', 0),
	(3, 1, '', 1, '楼盘名称', 1330394933, 'evaluation', '很好，哇大大', '', 1),
	(4, 1, '', 1, '楼盘名称', 1352797631, 'evaluation', '点评点评点评', '', 1);
/*!40000 ALTER TABLE `pw_h_new_evaluations` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_feed
CREATE TABLE IF NOT EXISTS `pw_h_new_feed` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：动态自增id',
  `hid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘id',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：自定义发布时间',
  `descrip` text NOT NULL COMMENT 'pw：动态描述（一句话描述）',
  `adddate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：添加时间（实际时间）',
  PRIMARY KEY (`id`),
  KEY `hid` (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：楼盘动态信息表';

-- Dumping data for table ci_pw_house.pw_h_new_feed: 0 rows
/*!40000 ALTER TABLE `pw_h_new_feed` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_new_feed` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_groupbuy
CREATE TABLE IF NOT EXISTS `pw_h_new_groupbuy` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：id',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：uid',
  `author` varchar(40) NOT NULL DEFAULT '游客' COMMENT 'pw：用户帐号（未注册 则插入游客）',
  `hid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘id',
  `hname` varchar(40) NOT NULL DEFAULT '' COMMENT 'pw：楼盘名称',
  `username` varchar(40) NOT NULL DEFAULT '' COMMENT 'pw：真实姓名',
  `gender` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：性别（0男性 1女性）',
  `phone` varchar(20) NOT NULL DEFAULT '' COMMENT 'pw：电话或手机',
  `mobel` varchar(20) NOT NULL DEFAULT '' COMMENT 'pw：',
  `qq` varchar(30) NOT NULL DEFAULT '' COMMENT 'pw：QQ',
  `msn` varchar(60) NOT NULL DEFAULT '' COMMENT 'pw：MSN',
  `email` varchar(60) NOT NULL DEFAULT '' COMMENT 'pw：Email',
  `budget` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：购房预算',
  `area` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：户型面积',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：提交时间',
  `remark` text NOT NULL COMMENT 'pw：留言',
  PRIMARY KEY (`id`),
  KEY `hname` (`hname`),
  KEY `budget` (`budget`),
  KEY `area` (`area`),
  KEY `ctime` (`ctime`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='pw：楼盘团购表';

-- Dumping data for table ci_pw_house.pw_h_new_groupbuy: 2 rows
/*!40000 ALTER TABLE `pw_h_new_groupbuy` DISABLE KEYS */;
INSERT INTO `pw_h_new_groupbuy` (`id`, `uid`, `author`, `hid`, `hname`, `username`, `gender`, `phone`, `mobel`, `qq`, `msn`, `email`, `budget`, `area`, `ctime`, `remark`) VALUES
	(1, 1, 'admin', 1, '楼盘名称', 'admin', 2, '0760-888888888', '', '', '52371354', '[email protected]', 1, 1, 1328174429, '我要团购我要团购我要团购'),
	(2, 1, 'admin', 1, '楼盘名称', 'admin', 1, '0760-888888888', '', '', '52371354', '[email protected]', 4, 0, 1329200867, '撒分');
/*!40000 ALTER TABLE `pw_h_new_groupbuy` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_image
CREATE TABLE IF NOT EXISTS `pw_h_new_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：id',
  `typeid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘相册类型id（imagetype id）',
  `hid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘id',
  `size` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：尺寸',
  `path` varchar(80) NOT NULL DEFAULT '' COMMENT 'pw：存储路径',
  `uploadtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：上传时间',
  `descrip` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：描述',
  `creator` varchar(20) NOT NULL DEFAULT '' COMMENT 'pw：创建人账号',
  PRIMARY KEY (`id`),
  KEY `typeid` (`typeid`),
  KEY `hid` (`hid`,`typeid`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='pw：楼盘图片信息列表';

-- Dumping data for table ci_pw_house.pw_h_new_image: 5 rows
/*!40000 ALTER TABLE `pw_h_new_image` DISABLE KEYS */;
INSERT INTO `pw_h_new_image` (`id`, `typeid`, `hid`, `size`, `path`, `uploadtime`, `descrip`, `creator`) VALUES
	(1, 5, 1, 4, 'house/nature/1/13300474287d39f.gif', 1330047428, '', 'admin'),
	(2, 5, 1, 104, 'house/nature/1/13300474285f414.jpg', 1330047428, '', 'admin'),
	(3, 5, 1, 24, 'house/nature/1/13300474291a690.jpg', 1330047429, '非常漂亮，娃哈哈哈哈\n非常漂亮，娃哈哈哈哈', 'admin'),
	(4, 5, 1, 19, 'house/nature/1/1330047429f2251.jpg', 1330047429, '', 'admin'),
	(5, 1, 1, 16, 'house/nature/1/1330048096ebce8.jpg', 1330048096, '', 'admin');
/*!40000 ALTER TABLE `pw_h_new_image` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_imagedata
CREATE TABLE IF NOT EXISTS `pw_h_new_imagedata` (
  `imageid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：照片ID',
  `hits` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：浏览数',
  PRIMARY KEY (`imageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：照片信息表';

-- Dumping data for table ci_pw_house.pw_h_new_imagedata: 5 rows
/*!40000 ALTER TABLE `pw_h_new_imagedata` DISABLE KEYS */;
INSERT INTO `pw_h_new_imagedata` (`imageid`, `hits`) VALUES
	(1, 0),
	(2, 0),
	(3, 0),
	(4, 0),
	(5, 0);
/*!40000 ALTER TABLE `pw_h_new_imagedata` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_imagetype
CREATE TABLE IF NOT EXISTS `pw_h_new_imagetype` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：id',
  `name` varchar(25) NOT NULL DEFAULT '' COMMENT 'pw：相册名称',
  `sub` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否子分类（父id）',
  `position` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：排序',
  `ifuse` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'pw：是否启用',
  `ifsystem` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否统默认相册（默认相册不允许删除）',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='pw：楼盘相册类型';

-- Dumping data for table ci_pw_house.pw_h_new_imagetype: 10 rows
/*!40000 ALTER TABLE `pw_h_new_imagetype` DISABLE KEYS */;
INSERT INTO `pw_h_new_imagetype` (`id`, `name`, `sub`, `position`, `ifuse`, `ifsystem`) VALUES
	(1, '户型图', 0, 0, 1, 1),
	(2, '样板间', 0, 0, 1, 1),
	(3, '实景图', 0, 0, 1, 1),
	(4, '规划图', 0, 0, 1, 1),
	(5, '一室', 1, 1, 1, 0),
	(6, '二室', 1, 2, 1, 0),
	(7, '三室', 1, 3, 1, 0),
	(8, '四室', 1, 4, 1, 0),
	(9, '复式', 1, 5, 1, 0),
	(10, '沙盘图', 0, 1, 1, 0);
/*!40000 ALTER TABLE `pw_h_new_imagetype` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_info
CREATE TABLE IF NOT EXISTS `pw_h_new_info` (
  `hid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：hid',
  `name` varchar(40) NOT NULL DEFAULT '' COMMENT 'pw：楼盘名称',
  `ifopen` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT 'pw：是否开启',
  `recommend` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否推荐',
  `logo` varchar(80) NOT NULL DEFAULT '' COMMENT 'pw：楼盘Logo',
  `banner` varchar(80) NOT NULL DEFAULT '' COMMENT 'pw：楼盘banner',
  `property` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：物业类型',
  `buildtype` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：建筑类型',
  `area` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属区域',
  `plate` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属商圈',
  `housetype` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘类型（新婚 养老 江景等）',
  `address` varchar(120) NOT NULL DEFAULT '' COMMENT 'pw：楼盘地址',
  `saletele` varchar(30) NOT NULL DEFAULT '' COMMENT 'pw：售楼热线',
  `saleaddress` varchar(120) NOT NULL DEFAULT '' COMMENT 'pw：售楼部地址',
  `developer` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：开发商',
  `aveprice` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：参考均价',
  `status` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：销售状态',
  `sellinglicense` varchar(120) NOT NULL DEFAULT '' COMMENT 'pw：销售许可',
  `paystatus` tinyint(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：交付标准',
  `opendate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：开盘日期',
  `deliverdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：交房日期',
  `isdimopendate` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：开盘日期显示为模糊时间（将根据具体时间显示上旬、中旬、下旬）',
  `isdimdeliverdate` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：交房日期显示为模糊时间（将根据具体时间显示上旬、中旬、下旬）',
  `buildingarea` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：建筑面积',
  `floorspace` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：占地面积',
  `plotratio` decimal(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'pw：容积率',
  `greenratio` decimal(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'pw：绿化率',
  `carport` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：车位数',
  `carportfee` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'pw：车位费',
  `cleaningfee` decimal(8,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'pw：物业费',
  `adddate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：添加时间',
  `postnum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：点评人数',
  `groupbuynum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：团购数量',
  `collectnum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：收藏数',
  `hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：点击数',
  `score` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：点评总分',
  `cyid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：绑定业主小区',
  `tags` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：关键字',
  PRIMARY KEY (`hid`),
  KEY `area` (`area`),
  KEY `aveprice` (`aveprice`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='pw：楼盘主信息表';

-- Dumping data for table ci_pw_house.pw_h_new_info: 1 rows
/*!40000 ALTER TABLE `pw_h_new_info` DISABLE KEYS */;
INSERT INTO `pw_h_new_info` (`hid`, `name`, `ifopen`, `recommend`, `logo`, `banner`, `property`, `buildtype`, `area`, `plate`, `housetype`, `address`, `saletele`, `saleaddress`, `developer`, `aveprice`, `status`, `sellinglicense`, `paystatus`, `opendate`, `deliverdate`, `isdimopendate`, `isdimdeliverdate`, `buildingarea`, `floorspace`, `plotratio`, `greenratio`, `carport`, `carportfee`, `cleaningfee`, `adddate`, `postnum`, `groupbuynum`, `collectnum`, `hits`, `score`, `cyid`, `tags`) VALUES
	(1, '楼盘名称', 1, 1, '', 'house/logo/banner_1.jpg', 14, 0, 0, 0, 5, '楼盘地址', '售楼热线', '售楼地址', 1, 100, 1, '销售许可', 1, 1328112000, 1329235200, 1, 0, 100, 1000, 0.11, 1.00, 100, 100.00, 10.00, 1328173984, 3, 2, 0, 49, 82, 0, '');
/*!40000 ALTER TABLE `pw_h_new_info` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_infoextra
CREATE TABLE IF NOT EXISTS `pw_h_new_infoextra` (
  `hid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘id',
  `traffic` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：交通状况',
  `propertycompany` varchar(80) NOT NULL DEFAULT '' COMMENT 'pw：物业公司',
  `peripheral` text NOT NULL COMMENT 'pw：周边配套',
  `introduction` text NOT NULL COMMENT 'pw：项目介绍',
  `nav` text NOT NULL COMMENT 'pw：自定义导航信息 JSON',
  `seotitle` varchar(80) NOT NULL DEFAULT '' COMMENT 'pw：HTML title',
  `seokeywords` varchar(250) NOT NULL DEFAULT '' COMMENT 'pw：Meta Keywords',
  `seodescription` text NOT NULL COMMENT 'pw：Meta Description',
  PRIMARY KEY (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：楼盘信息附加表';

-- Dumping data for table ci_pw_house.pw_h_new_infoextra: 1 rows
/*!40000 ALTER TABLE `pw_h_new_infoextra` DISABLE KEYS */;
INSERT INTO `pw_h_new_infoextra` (`hid`, `traffic`, `propertycompany`, `peripheral`, `introduction`, `nav`, `seotitle`, `seokeywords`, `seodescription`) VALUES
	(1, '交通状况', '物业公司', '周边配套', '项目介绍', 'a:1:{i:0;a:6:{s:5:"title";s:12:"自定义导航一";s:4:"link";s:0:"";s:3:"alt";s:0:"";s:5:"style";s:6:"|0|0|0";s:6:"target";i:0;s:4:"view";i:1;}}', 'title', 'Meta Keywords', 'Meta Description');
/*!40000 ALTER TABLE `pw_h_new_infoextra` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_map
CREATE TABLE IF NOT EXISTS `pw_h_new_map` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：自增id',
  `hid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘id',
  `x` varchar(20) NOT NULL DEFAULT '0' COMMENT 'pw：x坐标',
  `y` varchar(20) NOT NULL DEFAULT '0' COMMENT 'pw：y坐标',
  `zoom` smallint(2) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：放大镜范围 3 - 17',
  `laber` text NOT NULL COMMENT 'pw：标注说明',
  PRIMARY KEY (`id`),
  UNIQUE KEY `hid` (`hid`),
  KEY `x` (`hid`,`x`,`y`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='pw：楼盘地图相关';

-- Dumping data for table ci_pw_house.pw_h_new_map: 2 rows
/*!40000 ALTER TABLE `pw_h_new_map` DISABLE KEYS */;
INSERT INTO `pw_h_new_map` (`id`, `hid`, `x`, `y`, `zoom`, `laber`) VALUES
	(1, 1, '22.514531917588627', '113.40169813157917', 17, ''),
	(2, 2, '0', '0', 0, '');
/*!40000 ALTER TABLE `pw_h_new_map` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_pagecache
CREATE TABLE IF NOT EXISTS `pw_h_new_pagecache` (
  `sign` char(32) NOT NULL DEFAULT '' COMMENT 'pw：缓存模块标识符',
  `type` enum('flash','feed','price','tag','group','evaluations','round','housesort','imagetype') NOT NULL DEFAULT 'flash' COMMENT 'pw90v1：缓存模块类型 [update]',
  `data` text NOT NULL COMMENT 'pw：缓存数据',
  `cachetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：缓存创建时间',
  PRIMARY KEY (`sign`),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：页面缓存（每个楼盘都缓存了这些数据）\r\n1、详细页播放器（flash）        2、楼盘动态（feed）                  3、价格动态（price）         4、相关资讯（tag）\r\n5、业主小区回复（group）      6、楼盘点评（evaluations）      7、周边楼盘（round）       8、楼盘排行（housesort）\r\n9、楼盘图片（imagetype）\r\n备注：业主小区可以使用pw8.7的群组来做业主小区';

-- Dumping data for table ci_pw_house.pw_h_new_pagecache: 17 rows
/*!40000 ALTER TABLE `pw_h_new_pagecache` DISABLE KEYS */;
INSERT INTO `pw_h_new_pagecache` (`sign`, `type`, `data`, `cachetime`) VALUES
	('0ef26726307de6a0113904dca56dcfe6', 'flash', 'a:0:{}', 0),
	('0d32f692b0ca01bb73c6d152938af1de', 'price', 'a:0:{}', 0),
	('a5f02e21c889642b001cdd38ae2a9c03', 'feed', 'a:1:{i:0;a:1:{s:7:"descrip";s:24:"动态描述动态描述动态描述";}}', 0),
	('dccb6f3a61be2952a131d9dc07bae89c', 'tag', 'a:1:{i:0;a:13:{s:2:"id";s:1:"1";s:3:"hid";s:1:"1";s:5:"model";s:8:"newinfor";s:5:"title";s:12:"广告歌zssadf";s:8:"titlecss";a:4:{s:5:"color";s:0:"";s:1:"b";s:0:"";s:1:"i";s:0:"";s:1:"u";s:0:"";}s:3:"url";s:7:"http://";s:5:"image";s:0:"";s:4:"data";s:0:"";s:6:"offset";s:1:"0";s:6:"author";s:5:"admin";s:8:"pushtime";s:10:"2012-02-28";s:9:"iffailure";s:1:"0";s:8:"postdate";s:10:"2012-02-28";}}', 1352881141),
	('cf70c0a8ec2e40795e2bb86625675493', 'group', 'a:0:{}', 1352881141),
	('0bbedc5e7d5c7001a3d5600cb2b2a720', 'imagetype', 'a:4:{i:0;a:7:{s:3:"url";s:30:"index.php?m=house&q=image&id=5";s:5:"title";s:0:"";s:5:"value";N;s:5:"image";s:45:"attachment/house/nature/1/1330048096ebce8.jpg";s:4:"mini";s:47:"attachment/house/nature/1/s_1330048096ebce8.jpg";s:10:"uploadtime";s:16:"2012-02-24 09:48";s:8:"addition";a:0:{}}i:1;a:7:{s:3:"url";s:30:"index.php?m=house&q=image&id=4";s:5:"title";s:0:"";s:5:"value";N;s:5:"image";s:45:"attachment/house/nature/1/1330047429f2251.jpg";s:4:"mini";s:47:"attachment/house/nature/1/s_1330047429f2251.jpg";s:10:"uploadtime";s:16:"2012-02-24 09:37";s:8:"addition";a:0:{}}i:2;a:7:{s:3:"url";s:30:"index.php?m=house&q=image&id=3";s:5:"title";s:41:"非常漂亮，娃哈哈哈哈\n非常漂亮，娃哈哈哈哈";s:5:"value";N;s:5:"image";s:45:"attachment/house/nature/1/13300474291a690.jpg";s:4:"mini";s:47:"attachment/house/nature/1/s_13300474291a690.jpg";s:10:"uploadtime";s:16:"2012-02-24 09:37";s:8:"addition";a:0:{}}i:3;a:7:{s:3:"url";s:30:"index.php?m=house&q=image&id=2";s:5:"title";s:0:"";s:5:"value";N;s:5:"image";s:45:"attachment/house/nature/1/13300474285f414.jpg";s:4:"mini";s:47:"attachment/house/nature/1/s_13300474285f414.jpg";s:10:"uploadtime";s:16:"2012-02-24 09:37";s:8:"addition";a:0:{}}}', 0),
	('2c157143a49f58d8ebb0ba6c62499769', 'round', 'a:0:{}', 1352881141),
	('72ee2b19d19f1536a2dee62c1f823da2', 'housesort', 'a:1:{i:0;a:11:{s:3:"hid";s:1:"1";s:3:"url";s:30:"index.php?m=house&q=info&hid=1";s:5:"title";s:8:"楼盘名称";s:4:"name";s:8:"楼盘名称";s:4:"hits";s:2:"53";s:8:"aveprice";s:3:"100";s:5:"value";s:3:"100";s:4:"area";N;s:5:"image";s:11:"attachment/";s:8:"opendate";s:8:"11月上旬";s:5:"state";s:4:"新盘";}}', 1352881141),
	('21d3ddb00d37cf1e0eebdd1a53918c6b', 'housesort', 'a:1:{i:0;a:11:{s:3:"hid";s:1:"1";s:3:"url";s:30:"index.php?m=house&q=info&hid=1";s:5:"title";s:8:"楼盘名称";s:4:"name";s:8:"楼盘名称";s:4:"hits";s:1:"1";s:8:"aveprice";s:3:"100";s:5:"value";s:3:"100";s:4:"area";N;s:5:"image";s:11:"attachment/";s:8:"opendate";s:8:"2012-2-2";s:5:"state";s:4:"新盘";}}', 0),
	('9bd3a5a10a029bd085599ed9df5c7493', 'housesort', 'a:1:{i:0;a:11:{s:3:"hid";s:1:"1";s:3:"url";s:30:"index.php?m=house&q=info&hid=1";s:5:"title";s:8:"楼盘名称";s:4:"name";s:8:"楼盘名称";s:4:"hits";s:2:"53";s:8:"aveprice";s:3:"100";s:5:"value";s:3:"100";s:4:"area";N;s:5:"image";s:11:"attachment/";s:8:"opendate";s:8:"11月上旬";s:5:"state";s:4:"新盘";}}', 1352881141),
	('bc991af8b9802e903c8eb6cf8dfd58c4', 'housesort', 'a:1:{i:0;a:11:{s:3:"hid";s:1:"1";s:3:"url";s:30:"index.php?m=house&q=info&hid=1";s:5:"title";s:8:"楼盘名称";s:4:"name";s:8:"楼盘名称";s:4:"hits";s:2:"53";s:8:"aveprice";s:3:"100";s:5:"value";s:3:"100";s:4:"area";N;s:5:"image";s:11:"attachment/";s:8:"opendate";s:8:"11月上旬";s:5:"state";s:4:"新盘";}}', 1352881141),
	('820da202d0819d0b52805df1750ac369', 'imagetype', 'a:4:{i:0;a:7:{s:3:"url";s:30:"index.php?m=house&q=image&id=5";s:5:"title";s:0:"";s:5:"value";N;s:5:"image";s:45:"attachment/house/nature/1/1330048096ebce8.jpg";s:4:"mini";s:47:"attachment/house/nature/1/s_1330048096ebce8.jpg";s:10:"uploadtime";s:16:"2012-02-24 09:48";s:8:"addition";a:0:{}}i:1;a:7:{s:3:"url";s:30:"index.php?m=house&q=image&id=4";s:5:"title";s:0:"";s:5:"value";N;s:5:"image";s:45:"attachment/house/nature/1/1330047429f2251.jpg";s:4:"mini";s:47:"attachment/house/nature/1/s_1330047429f2251.jpg";s:10:"uploadtime";s:16:"2012-02-24 09:37";s:8:"addition";a:0:{}}i:2;a:7:{s:3:"url";s:30:"index.php?m=house&q=image&id=3";s:5:"title";s:41:"非常漂亮，娃哈哈哈哈\n非常漂亮，娃哈哈哈哈";s:5:"value";N;s:5:"image";s:45:"attachment/house/nature/1/13300474291a690.jpg";s:4:"mini";s:47:"attachment/house/nature/1/s_13300474291a690.jpg";s:10:"uploadtime";s:16:"2012-02-24 09:37";s:8:"addition";a:0:{}}i:3;a:7:{s:3:"url";s:30:"index.php?m=house&q=image&id=2";s:5:"title";s:0:"";s:5:"value";N;s:5:"image";s:45:"attachment/house/nature/1/13300474285f414.jpg";s:4:"mini";s:47:"attachment/house/nature/1/s_13300474285f414.jpg";s:10:"uploadtime";s:16:"2012-02-24 09:37";s:8:"addition";a:0:{}}}', 0),
	('34143ea7dd5a2caa37097a4814c972d6', 'imagetype', 'a:0:{}', 0),
	('7a0b37be9cc3a9e7b1c1ed418e641a12', 'imagetype', 'a:0:{}', 0),
	('ff77d1c0a8cbb3e2b44cebe05b4a6015', 'imagetype', 'a:0:{}', 0),
	('6b30ad047cdec68e9bf6f3c089cb76ba', 'imagetype', 'a:0:{}', 0),
	('fcd9cac81b312345fa4b2bf6762e7083', 'evaluations', 'a:3:{i:0;a:7:{s:2:"id";s:1:"4";s:3:"uid";s:1:"1";s:8:"username";s:5:"admin";s:7:"content";s:12:"点评点评点评";s:3:"sub";N;s:4:"icon";s:43:"attachment/upload/small/00/1.jpg?1329963439";s:7:"ifcheck";s:1:"1";}i:1;a:7:{s:2:"id";s:1:"3";s:3:"uid";s:1:"1";s:8:"username";s:5:"admin";s:7:"content";s:12:"很好，哇大大";s:3:"sub";N;s:4:"icon";s:43:"attachment/upload/small/00/1.jpg?1329963439";s:7:"ifcheck";s:1:"1";}i:2;a:7:{s:2:"id";s:1:"1";s:3:"uid";s:1:"1";s:8:"username";s:5:"admin";s:7:"content";s:10:"萨法撒旦发";s:3:"sub";N;s:4:"icon";s:43:"attachment/upload/small/00/1.jpg?1329963439";s:7:"ifcheck";s:1:"1";}}', 0);
/*!40000 ALTER TABLE `pw_h_new_pagecache` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_pricedetail
CREATE TABLE IF NOT EXISTS `pw_h_new_pricedetail` (
  `id` smallint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：自增id',
  `hid` smallint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘id',
  `title` varchar(30) NOT NULL DEFAULT '' COMMENT 'pw：标题',
  `propertyid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：物业类型',
  `buildtypeid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：建筑类别',
  `paystatusid` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：交付标准（装修状况）',
  `currentprice` varchar(10) NOT NULL DEFAULT '' COMMENT 'pw：当前价格',
  `opentime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：开盘时间',
  `paytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：交付时间',
  `hnum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：本期户数',
  PRIMARY KEY (`id`),
  KEY `hid` (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：楼盘价格明细表';

-- Dumping data for table ci_pw_house.pw_h_new_pricedetail: 0 rows
/*!40000 ALTER TABLE `pw_h_new_pricedetail` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_new_pricedetail` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_pushdata
CREATE TABLE IF NOT EXISTS `pw_h_new_pushdata` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：自增id',
  `hid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘id',
  `model` varchar(30) NOT NULL DEFAULT '' COMMENT 'pw：模块标识',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：内容标题',
  `titlecss` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：内容样式',
  `url` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：内容地址',
  `image` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：相关图片',
  `data` text NOT NULL COMMENT 'pw：其他数据',
  `offset` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：数据位置',
  `author` varchar(20) NOT NULL DEFAULT '' COMMENT 'pw：用户名称',
  `pushtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：推送时间',
  `iffailure` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否展示',
  PRIMARY KEY (`id`),
  KEY `hid` (`hid`,`model`),
  KEY `iffailure` (`iffailure`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='pw：详细页相关资讯展示';

-- Dumping data for table ci_pw_house.pw_h_new_pushdata: 1 rows
/*!40000 ALTER TABLE `pw_h_new_pushdata` DISABLE KEYS */;
INSERT INTO `pw_h_new_pushdata` (`id`, `hid`, `model`, `title`, `titlecss`, `url`, `image`, `data`, `offset`, `author`, `pushtime`, `iffailure`) VALUES
	(1, 1, 'newinfor', '广告歌zssadf', 'a:4:{s:5:"color";s:0:"";s:1:"b";s:0:"";s:1:"i";s:0:"";s:1:"u";s:0:"";}', 'http://', '', '', 0, 'admin', 1330395924, 0);
/*!40000 ALTER TABLE `pw_h_new_pushdata` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_recommend
CREATE TABLE IF NOT EXISTS `pw_h_new_recommend` (
  `hid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘id',
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：推荐时间',
  PRIMARY KEY (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：推荐楼盘列表';

-- Dumping data for table ci_pw_house.pw_h_new_recommend: 1 rows
/*!40000 ALTER TABLE `pw_h_new_recommend` DISABLE KEYS */;
INSERT INTO `pw_h_new_recommend` (`hid`, `timestamp`) VALUES
	(1, 1328174309);
/*!40000 ALTER TABLE `pw_h_new_recommend` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_userscore
CREATE TABLE IF NOT EXISTS `pw_h_new_userscore` (
  `hid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘id',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：uid',
  `stime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：评分时间',
  `content` text NOT NULL COMMENT 'pw：评分内容',
  PRIMARY KEY (`hid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：用户评分表';

-- Dumping data for table ci_pw_house.pw_h_new_userscore: 1 rows
/*!40000 ALTER TABLE `pw_h_new_userscore` DISABLE KEYS */;
INSERT INTO `pw_h_new_userscore` (`hid`, `uid`, `stime`, `content`) VALUES
	(1, 12, 1330481269, 'a:5:{i:1;s:1:"3";i:3;s:1:"3";i:2;s:1:"3";i:5;s:1:"3";i:4;s:1:"3";}');
/*!40000 ALTER TABLE `pw_h_new_userscore` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_new_video
CREATE TABLE IF NOT EXISTS `pw_h_new_video` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：自增id',
  `hid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：楼盘id',
  `address` text NOT NULL COMMENT 'pw：视频链接',
  `image` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：视频图片',
  `uploadtime` int(10) NOT NULL DEFAULT '0' COMMENT 'pw：图片上传时间',
  `descrip` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：视频描述 ',
  `ifembed` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'pw：是否是可播放视频',
  `creator` varchar(25) NOT NULL DEFAULT '' COMMENT 'pw：创建用户名',
  PRIMARY KEY (`id`),
  KEY `hid` (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：楼盘视频信息表';

-- Dumping data for table ci_pw_house.pw_h_new_video: 0 rows
/*!40000 ALTER TABLE `pw_h_new_video` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_new_video` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_agency
CREATE TABLE IF NOT EXISTS `pw_h_second_agency` (
  `agencyid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：公司id',
  `parentid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw90v1：父id',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：名称',
  `telphone` varchar(32) NOT NULL DEFAULT '' COMMENT 'CIv1：电话',
  `fax` varchar(32) NOT NULL DEFAULT '' COMMENT 'CIv1：传真',
  `address` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：地址',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：Logo',
  `bgimg` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：背景',
  `adminname` varchar(30) NOT NULL DEFAULT '' COMMENT 'pw：管理账号',
  `created` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw90v1：创建时间',
  `updated` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw90v1：修改时间',
  `isopen` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否开启（0关闭 1开启）',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：排序',
  PRIMARY KEY (`agencyid`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='pw：中介公司信息表';

-- Dumping data for table ci_pw_house.pw_h_second_agency: 2 rows
/*!40000 ALTER TABLE `pw_h_second_agency` DISABLE KEYS */;
INSERT INTO `pw_h_second_agency` (`agencyid`, `parentid`, `name`, `telphone`, `fax`, `address`, `icon`, `bgimg`, `adminname`, `created`, `updated`, `isopen`, `vieworder`) VALUES
	(1, 0, '家家顺地产', '', '', '', '', '', 'admin', 1353058260, 1355302974, 1, 1),
	(2, 1, '家家顺地产总店', '', '', '', '', '', 'admin', 1353058297, 0, 1, 1);
/*!40000 ALTER TABLE `pw_h_second_agency` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_agency_data
CREATE TABLE IF NOT EXISTS `pw_h_second_agency_data` (
  `agencyid` int(10) unsigned NOT NULL COMMENT 'CIv1：公司id',
  `salenum` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：【统计】出售房总数量',
  `hirenum` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：【统计】出租房总数量',
  `todaysalenum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：【统计】当日出售房数量',
  `weeksalenum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】当周出售房数量',
  `monthsalenum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】当月出售房数量',
  `fixedsalenum` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】固定出售房数量',
  `lastsaletime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：【统计】最后发布出售房时间',
  `todayhirenum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：【统计】当日出租房数量',
  `weekhirenum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】当周出租房数量',
  `monthhirenum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】当月出租房数量',
  `fixedhirenum` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】固定出租房数量',
  `lasthiretime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：【统计】最后发布出租房时间',
  `lastpost` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】最后发布时间（出售、出租都更新）',
  `rmbnum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：人民币余额',
  PRIMARY KEY (`agencyid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw90：中介公司数据表';

-- Dumping data for table ci_pw_house.pw_h_second_agency_data: 1 rows
/*!40000 ALTER TABLE `pw_h_second_agency_data` DISABLE KEYS */;
INSERT INTO `pw_h_second_agency_data` (`agencyid`, `salenum`, `hirenum`, `todaysalenum`, `weeksalenum`, `monthsalenum`, `fixedsalenum`, `lastsaletime`, `todayhirenum`, `weekhirenum`, `monthhirenum`, `fixedhirenum`, `lasthiretime`, `lastpost`, `rmbnum`) VALUES
	(1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10);
/*!40000 ALTER TABLE `pw_h_second_agency_data` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_agency_right
CREATE TABLE IF NOT EXISTS `pw_h_second_agency_right` (
  `agencyid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：中介id',
  `rkey` varchar(64) NOT NULL DEFAULT '' COMMENT 'CIv1：权限Key',
  `rvalue` text NOT NULL COMMENT 'CIv1：权限值',
  `vtype` enum('string','array') NOT NULL DEFAULT 'string' COMMENT 'CIv1：权限值类型',
  PRIMARY KEY (`agencyid`,`rkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw90：中介公司发布权限';

-- Dumping data for table ci_pw_house.pw_h_second_agency_right: 20 rows
/*!40000 ALTER TABLE `pw_h_second_agency_right` DISABLE KEYS */;
INSERT INTO `pw_h_second_agency_right` (`agencyid`, `rkey`, `rvalue`, `vtype`) VALUES
	(1, 'posttype', 'day', 'string'),
	(1, 'postnum', '500', 'string'),
	(1, 'postsalenum', '200', 'string'),
	(1, 'posthirenum', '200', 'string'),
	(1, 'ifpost_all', '1', 'string'),
	(1, 'ifpost_sale', '1', 'string'),
	(1, 'ifpost_hire', '1', 'string'),
	(1, 'ifpost_batchsale', '1', 'string'),
	(1, 'ifpost_batchhire', '1', 'string'),
	(1, 'sale_publish', '1', 'string'),
	(1, 'hire_publish', '1', 'string'),
	(1, 'second_publish_check', '0', 'string'),
	(1, 'second_user_shop', '0', 'string'),
	(1, 'second_publish_merge', '1', 'string'),
	(1, 'second_publish_type', 'day', 'string'),
	(1, 'second_publish_num', '10', 'string'),
	(1, 'sale_publish_type', 'day', 'string'),
	(1, 'sale_publish_num', '', 'string'),
	(1, 'hire_publish_type', 'day', 'string'),
	(1, 'hire_publish_num', '', 'string');
/*!40000 ALTER TABLE `pw_h_second_agency_right` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_expired
CREATE TABLE IF NOT EXISTS `pw_h_second_expired` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：自增id',
  `datatype` enum('sale','hire') NOT NULL DEFAULT 'sale' COMMENT 'pw90v1：数据类型 sale(0),hire(1)  [modified pw]',
  `expiredtype` enum('expired','urgent','top') NOT NULL DEFAULT 'expired' COMMENT 'pw90v1：过期类型 expired(0)过期,urgent(1)加急,top(2)置顶  [modified pw]',
  `houseid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：房源id',
  `expiredtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：过期时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `datatype` (`datatype`,`houseid`,`expiredtype`),
  KEY `expiredtime` (`expiredtime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：过期数据表';

-- Dumping data for table ci_pw_house.pw_h_second_expired: 0 rows
/*!40000 ALTER TABLE `pw_h_second_expired` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_second_expired` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_hireinfo
CREATE TABLE IF NOT EXISTS `pw_h_second_hireinfo` (
  `houseid` int(8) NOT NULL AUTO_INCREMENT COMMENT 'pw：houseid',
  `areatype` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：所属区域',
  `platetype` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：所属商圈',
  `pricetype` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：所属价格区间',
  `housetype` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：所属物业类型',
  `roomtype` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：所属户型',
  `hiretype` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：租赁方式（整租 合租 床位）',
  `subject` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：标题',
  `uid` int(10) NOT NULL DEFAULT '0' COMMENT 'pw：uid',
  `username` varchar(15) NOT NULL DEFAULT '' COMMENT 'pw：用户名',
  `ischarge` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：是否收费',
  `istop` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：是否置顶（0不置顶）',
  `isurgent` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：是否加急（0不加急）',
  `isbroker` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：是否经纪人（0个人  1经纪人）',
  `acreage` float NOT NULL DEFAULT '0' COMMENT 'pw：建筑面积',
  `currentfloor` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：当前楼层',
  `totalfloor` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：总的楼层',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'pw：租金',
  `room` smallint(6) NOT NULL DEFAULT '0' COMMENT 'pw：户型（3221:3房2厅2卫1阳台）',
  `village` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：小区名',
  `address` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：地址',
  `buildtime` smallint(6) NOT NULL DEFAULT '0' COMMENT 'pw：建筑年代',
  `traffic` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：交通状况',
  `fitment` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：装修程度',
  `equipment` varchar(20) NOT NULL DEFAULT '' COMMENT 'pw：配套设施',
  `thumb` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：封面缩略图',
  `descrip` text NOT NULL COMMENT 'pw：房源描述',
  `gate` varchar(200) NOT NULL DEFAULT '' COMMENT 'pw：组合信息供搜索用（字段组合 标题+小区名）',
  `linkman` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：联系人',
  `posttime` int(10) NOT NULL DEFAULT '0' COMMENT 'pw：发布时间',
  `modifytime` int(10) NOT NULL DEFAULT '0' COMMENT 'pw：修改时间',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：备注',
  `state` enum('publish','prepare','expired','deleted') NOT NULL DEFAULT 'publish' COMMENT 'CIv1：状态 prepare(1):待发布, publish(0):已发布,expired(2):已过期',
  PRIMARY KEY (`houseid`),
  KEY `idx_modifytime` (`modifytime`),
  KEY `idx_posttime` (`posttime`),
  KEY `idx_uid` (`uid`),
  KEY `idx_state` (`state`),
  KEY `idx_price` (`price`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='pw：二手房出租房源基本信息表';

-- Dumping data for table ci_pw_house.pw_h_second_hireinfo: 2 rows
/*!40000 ALTER TABLE `pw_h_second_hireinfo` DISABLE KEYS */;
INSERT INTO `pw_h_second_hireinfo` (`houseid`, `areatype`, `platetype`, `pricetype`, `housetype`, `roomtype`, `hiretype`, `subject`, `uid`, `username`, `ischarge`, `istop`, `isurgent`, `isbroker`, `acreage`, `currentfloor`, `totalfloor`, `price`, `room`, `village`, `address`, `buildtime`, `traffic`, `fitment`, `equipment`, `thumb`, `descrip`, `gate`, `linkman`, `posttime`, `modifytime`, `remark`, `state`) VALUES
	(1, 1, 0, 0, 0, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 0, 0, 0.00, 0, '', '', 0, '', 0, '', '', '', '', '', 0, 0, '', 'publish'),
	(2, 1, 0, 0, 0, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 0, 0, 0.00, 0, '', '', 0, '', 0, '', '', '', '', '', 0, 0, '', 'publish');
/*!40000 ALTER TABLE `pw_h_second_hireinfo` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_hiremodifytime_index
CREATE TABLE IF NOT EXISTS `pw_h_second_hiremodifytime_index` (
  `houseid` int(8) unsigned NOT NULL COMMENT 'pw：房源id',
  `areatype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属区域',
  `platetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属商圈',
  `pricetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属价格区间',
  `housetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属物业类型',
  `roomtype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属户型',
  `hiretype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：租赁方式（整租 合租 床位）',
  `modifytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：修改时间',
  KEY `idx_houseid` (`houseid`),
  KEY `idx_price_house_room_hire_modifytime` (`pricetype`,`housetype`,`roomtype`,`hiretype`,`modifytime`),
  KEY `idx_house_room_hire_modifytime` (`housetype`,`roomtype`,`hiretype`,`modifytime`),
  KEY `idx_room_hire_modifytime` (`roomtype`,`hiretype`,`modifytime`),
  KEY `idx_hire_modifytime` (`hiretype`,`modifytime`),
  KEY `idx_area_plate_price_house_room_hire_modifytime` (`areatype`,`platetype`,`pricetype`,`housetype`,`roomtype`,`hiretype`,`modifytime`),
  KEY `idx_plate_price_house_room_hire_modifytime` (`platetype`,`pricetype`,`housetype`,`roomtype`,`hiretype`,`modifytime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：出租房修改时间索引表';

-- Dumping data for table ci_pw_house.pw_h_second_hiremodifytime_index: 0 rows
/*!40000 ALTER TABLE `pw_h_second_hiremodifytime_index` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_second_hiremodifytime_index` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_hireposttime_index
CREATE TABLE IF NOT EXISTS `pw_h_second_hireposttime_index` (
  `houseid` int(8) unsigned NOT NULL COMMENT 'pw：房源id',
  `areatype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属区域',
  `platetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属商圈',
  `pricetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属价格区间',
  `housetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属物业类型',
  `roomtype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属户型',
  `hiretype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：租赁方式（整租 合租 床位）',
  `posttime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：发布时间（刷新时也会更新该字段）',
  KEY `idx_houseid` (`houseid`),
  KEY `idx_price_house_room_hire_posttime` (`pricetype`,`housetype`,`roomtype`,`hiretype`,`posttime`),
  KEY `idx_house_room_hire_posttime` (`housetype`,`roomtype`,`hiretype`,`posttime`),
  KEY `idx_room_hire_posttime` (`roomtype`,`hiretype`,`posttime`),
  KEY `idx_hire_posttime` (`hiretype`,`posttime`),
  KEY `idx_area_plate_price_house_room_hire_posttime` (`areatype`,`platetype`,`pricetype`,`housetype`,`roomtype`,`hiretype`,`posttime`),
  KEY `idx_plate_price_house_room_hire_posttime` (`platetype`,`pricetype`,`housetype`,`roomtype`,`hiretype`,`posttime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：出租房发布时间索引表';

-- Dumping data for table ci_pw_house.pw_h_second_hireposttime_index: 0 rows
/*!40000 ALTER TABLE `pw_h_second_hireposttime_index` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_second_hireposttime_index` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_hireprice_index
CREATE TABLE IF NOT EXISTS `pw_h_second_hireprice_index` (
  `houseid` int(8) unsigned NOT NULL COMMENT 'pw：房源id',
  `areatype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属区域',
  `platetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属商圈',
  `pricetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属价格区间',
  `housetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属物业类型',
  `roomtype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属户型',
  `hiretype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：租赁方式（整租 合租 床位）',
  `price` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：租金',
  KEY `idx_houseid` (`houseid`),
  KEY `idx_price_house_room_hire_price` (`pricetype`,`housetype`,`roomtype`,`hiretype`,`price`),
  KEY `idx_house_room_hire_price` (`housetype`,`roomtype`,`hiretype`,`price`),
  KEY `idx_room_hire_price` (`roomtype`,`hiretype`,`price`),
  KEY `idx_hire_price` (`hiretype`,`price`),
  KEY `idx_area_plate_price_house_room_hire_price` (`areatype`,`platetype`,`pricetype`,`housetype`,`roomtype`,`hiretype`,`price`),
  KEY `idx_plate_price_house_room_hire_price` (`platetype`,`pricetype`,`housetype`,`roomtype`,`hiretype`,`price`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：出租房租金索引表';

-- Dumping data for table ci_pw_house.pw_h_second_hireprice_index: 0 rows
/*!40000 ALTER TABLE `pw_h_second_hireprice_index` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_second_hireprice_index` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_image
CREATE TABLE IF NOT EXISTS `pw_h_second_image` (
  `imageid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：主键ID',
  `type` enum('sale','hire') NOT NULL DEFAULT 'sale' COMMENT 'pw90v1：图片类型sale(0)出售 hire(1)出租 [modified pw]',
  `houseid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：房子id',
  `size` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：图片大小',
  `path` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：图片路径',
  `uploadtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：上传时间',
  `descrip` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：图片描述',
  `creator` varchar(20) NOT NULL DEFAULT '' COMMENT 'pw：上传者',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT 'pw：图片名称',
  PRIMARY KEY (`imageid`),
  KEY `idx_type` (`type`,`houseid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：二手房，租房相关图片表';

-- Dumping data for table ci_pw_house.pw_h_second_image: 0 rows
/*!40000 ALTER TABLE `pw_h_second_image` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_second_image` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_report
CREATE TABLE IF NOT EXISTS `pw_h_second_report` (
  `reportid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：举报自增id',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：举报人id',
  `username` varchar(15) NOT NULL DEFAULT '' COMMENT 'pw：举报人帐号',
  `reason` text NOT NULL COMMENT 'pw：举报原因',
  `handle` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否已处理（1已处理 0未处理）',
  `type` enum('sale','hire') NOT NULL DEFAULT 'sale' COMMENT 'pw90v1：房源类型（sale(0)出售，hire(1)出租）[update]',
  `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：房源id',
  `time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：举报时间',
  PRIMARY KEY (`reportid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：二手房举报信息表';

-- Dumping data for table ci_pw_house.pw_h_second_report: 0 rows
/*!40000 ALTER TABLE `pw_h_second_report` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_second_report` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_saleinfo
CREATE TABLE IF NOT EXISTS `pw_h_second_saleinfo` (
  `houseid` int(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：houseid',
  `areatype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属区域',
  `platetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属商圈',
  `pricetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属价格区间',
  `acreagetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属面积区间',
  `roomtype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属户型',
  `housetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属物业类型',
  `subject` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：标题',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：uid',
  `username` varchar(15) NOT NULL DEFAULT '' COMMENT 'pw：用户名',
  `istop` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否置顶（0不置顶）',
  `isurgent` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否加急（0不加急）',
  `isbroker` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否经纪人（0个人  1经纪人）',
  `acreage` float unsigned NOT NULL DEFAULT '0' COMMENT 'pw：建筑面积',
  `currentfloor` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw：当前楼层',
  `totalfloor` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：总楼层',
  `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'pw：总价',
  `unitprice` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：单价',
  `room` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '户型（3221:3室2厅2卫1阳台）',
  `righter` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：房屋产权',
  `village` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：小区名',
  `address` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：具体地址',
  `buildtime` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：建筑年代',
  `traffic` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：交通状况',
  `fitment` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：装修程度',
  `equipment` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：配套设施',
  `thumb` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：封面缩略图',
  `descrip` text NOT NULL COMMENT 'pw：房源描述',
  `gate` varchar(200) NOT NULL DEFAULT '' COMMENT 'pw：组合信息供搜索用（字段组合 标题+小区名）',
  `linkman` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：联系人',
  `posttime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：发布时间',
  `modifytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：修改时间',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：备注',
  `state` enum('publish','prepare','expired','deleted') NOT NULL DEFAULT 'publish' COMMENT 'CIv1：状态（publish 0发布，prepare 1待发布，expired 2过期）',
  PRIMARY KEY (`houseid`),
  KEY `idx_modifytime` (`modifytime`),
  KEY `idx_posttime` (`posttime`),
  KEY `idx_uid` (`uid`),
  KEY `idx_status` (`state`),
  KEY `idx_price` (`price`),
  KEY `idx_unitprice` (`unitprice`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='pw：二手房出售房源基本信息表';

-- Dumping data for table ci_pw_house.pw_h_second_saleinfo: 1 rows
/*!40000 ALTER TABLE `pw_h_second_saleinfo` DISABLE KEYS */;
INSERT INTO `pw_h_second_saleinfo` (`houseid`, `areatype`, `platetype`, `pricetype`, `acreagetype`, `roomtype`, `housetype`, `subject`, `uid`, `username`, `istop`, `isurgent`, `isbroker`, `acreage`, `currentfloor`, `totalfloor`, `price`, `unitprice`, `room`, `righter`, `village`, `address`, `buildtime`, `traffic`, `fitment`, `equipment`, `thumb`, `descrip`, `gate`, `linkman`, `posttime`, `modifytime`, `remark`, `state`) VALUES
	(1, 0, 0, 0, 0, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 0, 0.00, 0, 0, 0, '', '', 0, '', 0, '', '', '', '', '', 0, 0, '', 'publish');
/*!40000 ALTER TABLE `pw_h_second_saleinfo` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_salemodifytime_index
CREATE TABLE IF NOT EXISTS `pw_h_second_salemodifytime_index` (
  `houseid` int(8) unsigned NOT NULL COMMENT 'pw：房源id',
  `areatype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属区域',
  `platetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属商圈',
  `pricetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属价格区间',
  `acreagetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属面积区间',
  `roomtype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属户型',
  `housetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属物业类型',
  `modifytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：更新时间',
  KEY `idx_houseid` (`houseid`),
  KEY `idx_price_acreage_room_house_modifytime` (`pricetype`,`acreagetype`,`roomtype`,`housetype`,`modifytime`),
  KEY `idx_acreage_room_house_modifytime` (`acreagetype`,`roomtype`,`housetype`,`modifytime`),
  KEY `idx_room_house_modifytime` (`roomtype`,`housetype`,`modifytime`),
  KEY `idx_house_modifytime` (`housetype`,`modifytime`),
  KEY `idx_area_plate_price_acreage_room_house_modifytime` (`areatype`,`platetype`,`pricetype`,`acreagetype`,`roomtype`,`housetype`,`modifytime`),
  KEY `idx_plate_price_acreage_room_house_modifytime` (`platetype`,`pricetype`,`acreagetype`,`roomtype`,`housetype`,`modifytime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：二手房修改时间索引表';

-- Dumping data for table ci_pw_house.pw_h_second_salemodifytime_index: 0 rows
/*!40000 ALTER TABLE `pw_h_second_salemodifytime_index` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_second_salemodifytime_index` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_saleposttime_index
CREATE TABLE IF NOT EXISTS `pw_h_second_saleposttime_index` (
  `houseid` int(8) unsigned NOT NULL COMMENT 'pw：房源id',
  `areatype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属区域',
  `platetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属商圈',
  `pricetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属价格区间',
  `acreagetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属面积区间',
  `roomtype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属户型',
  `housetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属物业类型',
  `posttime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：发布时间（刷新时也会更新该字段）',
  KEY `idx_houseid` (`houseid`),
  KEY `idx_price_acreage_room_house_posttime` (`pricetype`,`acreagetype`,`roomtype`,`housetype`,`posttime`),
  KEY `idx_acreage_room_house_posttime` (`acreagetype`,`roomtype`,`housetype`,`posttime`),
  KEY `idx_room_house_posttime` (`roomtype`,`housetype`,`posttime`),
  KEY `idx_house_posttime` (`housetype`,`posttime`),
  KEY `idx_plate_price_acreage_room_house_posttime` (`platetype`,`pricetype`,`acreagetype`,`roomtype`,`housetype`,`posttime`),
  KEY `idx_area_plate_price_acreage_room_house_posttime` (`areatype`,`platetype`,`pricetype`,`acreagetype`,`roomtype`,`housetype`,`posttime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：二手房发布时间索引表';

-- Dumping data for table ci_pw_house.pw_h_second_saleposttime_index: 0 rows
/*!40000 ALTER TABLE `pw_h_second_saleposttime_index` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_second_saleposttime_index` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_saleprice_index
CREATE TABLE IF NOT EXISTS `pw_h_second_saleprice_index` (
  `houseid` int(8) unsigned NOT NULL COMMENT 'pw：房源id',
  `areatype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属区域',
  `platetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属商圈',
  `pricetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属价格区间',
  `acreagetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属面积区间',
  `roomtype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属户型',
  `housetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属物业类型',
  `price` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：总价',
  KEY `idx_houseid` (`houseid`),
  KEY `idx_price_acreage_room_house_price` (`pricetype`,`acreagetype`,`roomtype`,`housetype`,`price`),
  KEY `idx_acreage_room_house_price` (`acreagetype`,`roomtype`,`housetype`,`price`),
  KEY `idx_room_house_price` (`roomtype`,`housetype`,`price`),
  KEY `idx_house_price` (`housetype`,`price`),
  KEY `idx_area_plate_price_acreage_room_house_price` (`areatype`,`platetype`,`pricetype`,`acreagetype`,`roomtype`,`housetype`,`price`),
  KEY `idx_plate_price_acreage_room_house_price` (`platetype`,`pricetype`,`acreagetype`,`roomtype`,`housetype`,`price`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：二手房总价索引表';

-- Dumping data for table ci_pw_house.pw_h_second_saleprice_index: 0 rows
/*!40000 ALTER TABLE `pw_h_second_saleprice_index` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_second_saleprice_index` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_saleunitprice_index
CREATE TABLE IF NOT EXISTS `pw_h_second_saleunitprice_index` (
  `houseid` int(8) unsigned NOT NULL COMMENT 'pw：房源id',
  `areatype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属区域',
  `platetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属商圈',
  `pricetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属价格区间',
  `acreagetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属面积区间',
  `roomtype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属户型',
  `housetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属物业类型',
  `unitprice` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：单价（总价/建筑面积）',
  KEY `idx_houseid` (`houseid`),
  KEY `idx_price_acreage_room_house_unitprice` (`pricetype`,`acreagetype`,`roomtype`,`housetype`,`unitprice`),
  KEY `idx_acreage_room_house_unitprice` (`acreagetype`,`roomtype`,`housetype`,`unitprice`),
  KEY `idx_room_house_unitprice` (`roomtype`,`housetype`,`unitprice`),
  KEY `idx_house_unitprice` (`housetype`,`unitprice`),
  KEY `idx_area_plate_price_acreage_room_house_unitprice` (`areatype`,`platetype`,`pricetype`,`acreagetype`,`roomtype`,`housetype`,`unitprice`),
  KEY `idx_plate_price_acreage_room_house_unitprice` (`platetype`,`pricetype`,`acreagetype`,`roomtype`,`housetype`,`unitprice`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：二手房单价索引表';

-- Dumping data for table ci_pw_house.pw_h_second_saleunitprice_index: 0 rows
/*!40000 ALTER TABLE `pw_h_second_saleunitprice_index` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_second_saleunitprice_index` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_tagdata
CREATE TABLE IF NOT EXISTS `pw_h_second_tagdata` (
  `tag_id` mediumint(8) unsigned NOT NULL COMMENT 'pw90v1：标签id',
  `house_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw90v1：房源id',
  KEY `idx_tagid` (`tag_id`),
  KEY `idx_houseid` (`house_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw90v1：二手房源标签信息+房源关系表';

-- Dumping data for table ci_pw_house.pw_h_second_tagdata: 0 rows
/*!40000 ALTER TABLE `pw_h_second_tagdata` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_second_tagdata` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_h_second_tags
CREATE TABLE IF NOT EXISTS `pw_h_second_tags` (
  `tag_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw90v1：标签id',
  `name` varchar(15) NOT NULL DEFAULT '' COMMENT 'pw90v1：标签名',
  `num` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw90v1：使用数',
  `ifhot` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'pw90v1：是否热门',
  PRIMARY KEY (`tag_id`),
  KEY `idx_name` (`name`),
  KEY `idx_ifhot_num` (`ifhot`,`num`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw90v1：二手房源标签主信息表';

-- Dumping data for table ci_pw_house.pw_h_second_tags: 0 rows
/*!40000 ALTER TABLE `pw_h_second_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `pw_h_second_tags` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_user
CREATE TABLE IF NOT EXISTS `pw_user` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'CIv1：uid',
  `username` varchar(15) NOT NULL DEFAULT '' COMMENT 'CIv1：账号',
  `email` varchar(40) NOT NULL DEFAULT '' COMMENT 'CIv1：邮箱',
  `password` char(32) NOT NULL DEFAULT '' COMMENT 'CIv1：密码',
  `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：用户组id',
  `realname` varchar(20) NOT NULL DEFAULT '' COMMENT 'CIv1：真实姓名',
  `gender` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：性别 0=女 1=男',
  `mobile` varchar(16) NOT NULL DEFAULT '' COMMENT 'CIv1：手机号',
  `telphone` varchar(20) NOT NULL DEFAULT '' COMMENT 'CIv1：固定电话',
  `qq` varchar(15) NOT NULL DEFAULT '' COMMENT 'CIv1：qq号码',
  `address` varchar(100) NOT NULL DEFAULT '' COMMENT 'CIv1：地址',
  `face` varchar(20) NOT NULL DEFAULT '' COMMENT 'CIv1：头像',
  `sign` varchar(255) NOT NULL DEFAULT '' COMMENT 'CIv1：签名',
  `alipay` varchar(50) NOT NULL DEFAULT '' COMMENT 'CIv1：支付宝账号',
  `created` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：注册时间',
  `created_ip` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：注册IP',
  `ifbroker` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：是否经纪人',
  `status` enum('active','unactive','lock') NOT NULL DEFAULT 'unactive' COMMENT 'CIv1：状态（2锁定 1激活 0未激活)',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `idx_username` (`username`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='CIv1：用户基本表';

-- Dumping data for table ci_pw_house.pw_user: 7 rows
/*!40000 ALTER TABLE `pw_user` DISABLE KEYS */;
INSERT INTO `pw_user` (`uid`, `username`, `email`, `password`, `groupid`, `realname`, `gender`, `mobile`, `telphone`, `qq`, `address`, `face`, `sign`, `alipay`, `created`, `created_ip`, `ifbroker`, `status`) VALUES
	(1, 'admin', '[email protected]', '21232f297a57a5a743894a0e4a801fc3', 1, '李先生', 0, '', '李先生', '', '', '', '房源签名', '', 1353058297, 4200000000, 0, 'active'),
	(2, 'broker', '[email protected]', 'e3c9c373c82d6d5bd4a4aa6a8269bbe6', 1, '李小姐', 0, '15820501000', '', '', '', '', '', '', 1347675285, 2130706433, 0, 'active'),
	(3, 'broker1', '[email protected]', 'ecb8d44f1bb507250d73a0f8a84cadcf', 1, '李小姐', 0, '15820501000', '', '', '', '', '', '', 1350984892, 2130706433, 0, 'active'),
	(4, 'admin1', '', 'e00cf25ad42683b3df678c61f42c6bda', 6, '', 0, '2147483647', '', '', '', '', '', '', 1350984892, 2130706433, 0, 'active'),
	(19, 'admin4', '[email protected]', 'fc1ebc848e31e0a68e868432225e3c82', 6, '', 0, '15820501000', '', '', '', '', '', '', 1350987631, 2130706433, 0, 'active'),
	(20, 'admin2', '[email protected]', 'c84258e9c39059a89ab77d846ddab909', 6, '', 0, '15820501000', '', '', '', '', '', '', 1351069577, 2130706433, 0, 'unactive'),
	(21, 'admin10', '[email protected]', '4fbd41a36dac3cd79aa1041c9648ab89', 6, '', 0, '15820501000', '', '', '', '', '', '', 1351078321, 2130706433, 0, 'lock');
/*!40000 ALTER TABLE `pw_user` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_user_broker
CREATE TABLE IF NOT EXISTS `pw_user_broker` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：uid',
  `username` varchar(15) NOT NULL DEFAULT '' COMMENT 'pw：账号（用于查询）',
  `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：经纪人用户组id',
  `realname` varchar(30) NOT NULL DEFAULT '' COMMENT 'pw：真实姓名（用于查询）',
  `plate` text NOT NULL COMMENT 'pw：服务商圈',
  `company` varchar(30) NOT NULL DEFAULT '' COMMENT 'pw：所属公司',
  `address` varchar(150) NOT NULL DEFAULT '' COMMENT 'pw：工作地址',
  `email` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：电子邮箱',
  `tel` varchar(15) NOT NULL DEFAULT '' COMMENT 'pw：电话号码',
  `phone` varchar(15) NOT NULL DEFAULT '' COMMENT 'pw：手机号码',
  `verify` text NOT NULL COMMENT 'pw：认证类型',
  `idcard` char(18) NOT NULL DEFAULT '' COMMENT 'pw：身份证号码',
  `idcardpic` varchar(100) NOT NULL DEFAULT '' COMMENT 'pw：身份证图片',
  `alipay` varchar(50) NOT NULL DEFAULT '' COMMENT 'pw：支付宝账号',
  `otherinfo` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：其他认证信息',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT 'pw：备注',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：加入时间',
  `announce` text NOT NULL COMMENT 'pw：店铺公告',
  `agencyparentid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属总公司id',
  `agencyid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属分店id',
  `ifcompany` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否加入中介公司（申请加入是否审核成功）',
  `status` enum('active','unactive','lock') NOT NULL DEFAULT 'unactive' COMMENT 'CIv1：状态（2锁定 1激活 0未激活)',
  PRIMARY KEY (`uid`),
  KEY `idx_username` (`username`),
  KEY `idx_groupid` (`groupid`),
  KEY `idx_realname` (`realname`),
  KEY `idx_agencyid_ifcompany_status` (`agencyid`,`status`,`ifcompany`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：经纪人信息表';

-- Dumping data for table ci_pw_house.pw_user_broker: 1 rows
/*!40000 ALTER TABLE `pw_user_broker` DISABLE KEYS */;
INSERT INTO `pw_user_broker` (`uid`, `username`, `groupid`, `realname`, `plate`, `company`, `address`, `email`, `tel`, `phone`, `verify`, `idcard`, `idcardpic`, `alipay`, `otherinfo`, `remark`, `createtime`, `announce`, `agencyparentid`, `agencyid`, `ifcompany`, `status`) VALUES
	(1, 'admin', 11, '木子', '', '易阅传媒', '宝利大厦5EF', '', '', '', '1,3', '', '', '', '', '', 1353058260, '', 1, 2, 1, 'active');
/*!40000 ALTER TABLE `pw_user_broker` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_user_data
CREATE TABLE IF NOT EXISTS `pw_user_data` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：uid',
  `ifbroker` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：是否中介',
  `salenum` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：【统计】出售房总数量',
  `hirenum` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：【统计】出租房总数量',
  `todaysalenum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：【统计】当日出售房数量',
  `weeksalenum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】当周出售房数量',
  `monthsalenum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】当月出售房数量',
  `fixedsalenum` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】固定出售房数量',
  `lastsaletime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：【统计】最后发布出售房时间',
  `todayhirenum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：【统计】当日出租房数量',
  `weekhirenum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】当周出租房数量',
  `monthhirenum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】当月出租房数量',
  `fixedhirenum` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】固定出租房数量',
  `lasthiretime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：【统计】最后发布出租房时间',
  `lastpost` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：【统计】最后发布时间（出售、出租都更新）',
  `rmbnum` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：人民币余额',
  `notices` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：消息数',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='CIv1：用户信息表（ = pw8.7 house_secondpost）';

-- Dumping data for table ci_pw_house.pw_user_data: 1 rows
/*!40000 ALTER TABLE `pw_user_data` DISABLE KEYS */;
INSERT INTO `pw_user_data` (`uid`, `ifbroker`, `salenum`, `hirenum`, `todaysalenum`, `weeksalenum`, `monthsalenum`, `fixedsalenum`, `lastsaletime`, `todayhirenum`, `weekhirenum`, `monthhirenum`, `fixedhirenum`, `lasthiretime`, `lastpost`, `rmbnum`, `notices`) VALUES
	(1, 0, 147, 471, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0);
/*!40000 ALTER TABLE `pw_user_data` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_user_group
CREATE TABLE IF NOT EXISTS `pw_user_group` (
  `groupid` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT 'CIv1：groupid',
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT 'CIv1：名称',
  `type` enum('default','member','system','special','vip','broker') NOT NULL DEFAULT 'member' COMMENT 'CIv1：类型',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'CIv1：排序',
  PRIMARY KEY (`groupid`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='CIv1：用户组基本表';

-- Dumping data for table ci_pw_house.pw_user_group: 12 rows
/*!40000 ALTER TABLE `pw_user_group` DISABLE KEYS */;
INSERT INTO `pw_user_group` (`groupid`, `name`, `type`, `vieworder`) VALUES
	(1, '会员', 'default', 0),
	(2, '游客', 'default', 0),
	(3, '管理员', 'system', 0),
	(4, '总编', 'system', 0),
	(5, '编辑', 'system', 0),
	(6, '禁止发言', 'default', 0),
	(7, '未验证会员', 'default', 0),
	(8, '一星会员', 'member', 0),
	(9, '二星会员', 'member', 0),
	(10, '三星会员', 'member', 0),
	(11, '一星经纪人', 'broker', 0),
	(12, '二星经纪人', 'broker', 0);
/*!40000 ALTER TABLE `pw_user_group` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_user_group_right
CREATE TABLE IF NOT EXISTS `pw_user_group_right` (
  `groupid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：用户组id',
  `rkey` varchar(32) NOT NULL DEFAULT '' COMMENT 'CIv1：权限Key',
  `rtype` enum('basic','system','secondhouse','newhouse') NOT NULL DEFAULT 'basic' COMMENT 'CIv1：权限类型（base:基础 system:系统）',
  `rvalue` text NOT NULL COMMENT 'CIv1：权限值',
  `vtype` enum('string','array') NOT NULL DEFAULT 'string' COMMENT 'CIv1：权限值类型',
  PRIMARY KEY (`groupid`,`rkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='CIv1：用户组权限';

-- Dumping data for table ci_pw_house.pw_user_group_right: 50 rows
/*!40000 ALTER TABLE `pw_user_group_right` DISABLE KEYS */;
INSERT INTO `pw_user_group_right` (`groupid`, `rkey`, `rtype`, `rvalue`, `vtype`) VALUES
	(8, 'newhouse_publish', 'newhouse', '0', 'string'),
	(8, 'hire_publish_num', 'secondhouse', '1', 'string'),
	(8, 'hire_publish_type', 'secondhouse', 'day', 'string'),
	(8, 'sale_publish_num', 'secondhouse', '1', 'string'),
	(8, 'sale_publish_type', 'secondhouse', 'day', 'string'),
	(8, 'second_publish_num', 'secondhouse', '1', 'string'),
	(8, 'second_publish_type', 'secondhouse', 'day', 'string'),
	(8, 'second_publish_merge', 'secondhouse', '1', 'string'),
	(8, 'second_user_shop', 'secondhouse', '0', 'string'),
	(8, 'second_publish_check', 'secondhouse', '0', 'string'),
	(8, 'hire_publish', 'secondhouse', '1', 'string'),
	(8, 'sale_publish', 'secondhouse', '1', 'string'),
	(8, 'newhouse_publish_check', 'newhouse', '1', 'string'),
	(8, 'newhouse_publish_num', 'newhouse', '1', 'string'),
	(9, 'sale_publish', 'secondhouse', '1', 'string'),
	(9, 'hire_publish', 'secondhouse', '1', 'string'),
	(9, 'second_publish_check', 'secondhouse', '0', 'string'),
	(9, 'second_user_shop', 'secondhouse', '0', 'string'),
	(9, 'second_publish_merge', 'secondhouse', '1', 'string'),
	(9, 'second_publish_type', 'secondhouse', 'day', 'string'),
	(9, 'second_publish_num', 'secondhouse', '2', 'string'),
	(9, 'sale_publish_type', 'secondhouse', 'day', 'string'),
	(9, 'sale_publish_num', 'secondhouse', '', 'string'),
	(9, 'hire_publish_type', 'secondhouse', 'day', 'string'),
	(9, 'hire_publish_num', 'secondhouse', '', 'string'),
	(9, 'newhouse_publish', 'newhouse', '0', 'string'),
	(9, 'newhouse_publish_check', 'newhouse', '1', 'string'),
	(9, 'newhouse_publish_num', 'newhouse', '1', 'string'),
	(11, 'sale_publish', 'secondhouse', '1', 'string'),
	(11, 'hire_publish', 'secondhouse', '1', 'string'),
	(11, 'second_publish_check', 'secondhouse', '0', 'string'),
	(11, 'second_user_shop', 'secondhouse', '1', 'string'),
	(11, 'second_publish_merge', 'secondhouse', '1', 'string'),
	(11, 'second_publish_type', 'secondhouse', 'day', 'string'),
	(11, 'second_publish_num', 'secondhouse', '2', 'string'),
	(11, 'sale_publish_type', 'secondhouse', 'day', 'string'),
	(11, 'sale_publish_num', 'secondhouse', '', 'string'),
	(11, 'hire_publish_type', 'secondhouse', 'day', 'string'),
	(11, 'hire_publish_num', 'secondhouse', '', 'string'),
	(12, 'second_publish_check', 'secondhouse', '0', 'string'),
	(12, 'hire_publish', 'secondhouse', '1', 'string'),
	(12, 'sale_publish', 'secondhouse', '1', 'string'),
	(12, 'second_user_shop', 'secondhouse', '1', 'string'),
	(12, 'second_publish_merge', 'secondhouse', '1', 'string'),
	(12, 'second_publish_type', 'secondhouse', 'day', 'string'),
	(12, 'second_publish_num', 'secondhouse', '4', 'string'),
	(12, 'sale_publish_type', 'secondhouse', 'day', 'string'),
	(12, 'sale_publish_num', 'secondhouse', '', 'string'),
	(12, 'hire_publish_type', 'secondhouse', 'day', 'string'),
	(12, 'hire_publish_num', 'secondhouse', '', 'string');
/*!40000 ALTER TABLE `pw_user_group_right` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_user_log_login
CREATE TABLE IF NOT EXISTS `pw_user_log_login` (
  `uid` int(10) unsigned NOT NULL COMMENT 'CIv1：用户id',
  `logintime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：登陆时间',
  `loginip` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'CIv1：登陆ip',
  KEY `idx_uid` (`uid`),
  KEY `idx_logintime` (`logintime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='CIv1：用户登陆记录表';

-- Dumping data for table ci_pw_house.pw_user_log_login: 55 rows
/*!40000 ALTER TABLE `pw_user_log_login` DISABLE KEYS */;
INSERT INTO `pw_user_log_login` (`uid`, `logintime`, `loginip`) VALUES
	(2, 1347867347, 2130706433),
	(1, 1347867200, 2130706433),
	(1, 1347682515, 2130706433),
	(2, 1347682431, 2130706433),
	(1, 1347681187, 2130706433),
	(1, 1347681169, 2130706433),
	(2, 1347675654, 2130706433),
	(1, 1351049171, 2130706433),
	(1, 1351049295, 2130706433),
	(1, 1351049329, 2130706433),
	(1, 1351049833, 2130706433),
	(1, 1351072352, 2130706433),
	(1, 1351072359, 2130706433),
	(1, 1351072377, 2130706433),
	(1, 1351072397, 2130706433),
	(1, 1351072427, 2130706433),
	(1, 1351072439, 2130706433),
	(1, 1351073170, 2130706433),
	(1, 1351073238, 2130706433),
	(1, 1351073246, 2130706433),
	(1, 1351073388, 2130706433),
	(1, 1351073393, 2130706433),
	(1, 1351073398, 2130706433),
	(1, 1351073404, 2130706433),
	(1, 1351073495, 2130706433),
	(21, 1351078321, 2130706433),
	(1, 1351136873, 2130706433),
	(1, 1351137321, 2130706433),
	(1, 1351137662, 2130706433),
	(1, 1351137676, 2130706433),
	(1, 1351146925, 2130706433),
	(1, 1351147448, 2130706433),
	(1, 1351147463, 2130706433),
	(1, 1351155609, 2130706433),
	(1, 1351233846, 2130706433),
	(1, 1351847579, 2130706433),
	(1, 1351848187, 2130706433),
	(1, 1351848206, 2130706433),
	(1, 1351848254, 2130706433),
	(1, 1351848330, 2130706433),
	(1, 1352097720, 2130706433),
	(1, 1352098286, 2130706433),
	(1, 1352098384, 2130706433),
	(1, 1352098451, 2130706433),
	(1, 1352098701, 2130706433),
	(1, 1352168368, 2130706433),
	(1, 1352184710, 2130706433),
	(1, 1352251562, 2130706433),
	(1, 1352346449, 2130706433),
	(1, 1352354679, 2130706433),
	(1, 1352424975, 2130706433),
	(1, 1352510525, 2130706433),
	(1, 1352515897, 2130706433),
	(1, 1352527421, 2130706433),
	(1, 1359610114, 2130706433);
/*!40000 ALTER TABLE `pw_user_log_login` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.pw_user_notices
CREATE TABLE IF NOT EXISTS `pw_user_notices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '通知id',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户uid',
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '类型id',
  `param` int(10) NOT NULL DEFAULT '0' COMMENT '应用类型id',
  `is_read` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否已读',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
  `body` text COMMENT '内容',
  `created` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  PRIMARY KEY (`id`),
  KEY `idx_uid_read_updated` (`uid`,`is_read`,`updated`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='用户通知表';

-- Dumping data for table ci_pw_house.pw_user_notices: 8 rows
/*!40000 ALTER TABLE `pw_user_notices` DISABLE KEYS */;
INSERT INTO `pw_user_notices` (`id`, `uid`, `typeid`, `param`, `is_read`, `title`, `body`, `created`, `updated`) VALUES
	(1, 1, 5, 1, 1, '未完成任务提醒', 'a:6:{s:2:"id";s:1:"4";s:5:"title";s:18:"喜欢一个帖子";s:4:"icon";s:0:"";s:3:"url";s:20:"bbs/thread/run?fid=2";s:12:"created_time";i:1351836935;s:8:"complete";i:0;}', 1351836935, 1351836935),
	(2, 1, 5, 1, 1, '未完成任务提醒', 'a:6:{s:2:"id";s:1:"1";s:5:"title";s:18:"发布一个帖子";s:4:"icon";s:0:"";s:3:"url";s:18:"bbs/post/run?fid=2";s:12:"created_time";i:1351836935;s:8:"complete";i:0;}', 1351836935, 1351836935),
	(3, 1, 4, 0, 1, '勋章提醒', 'a:5:{s:5:"logid";s:1:"1";s:4:"name";s:12:"社区居民";s:7:"medelId";s:1:"1";s:4:"type";i:1;s:6:"reason";s:0:"";}', 1351836935, 1351836935),
	(4, 1, 5, 1, 1, '任务奖励领取提醒', 'a:6:{s:2:"id";s:1:"1";s:5:"title";s:18:"发布一个帖子";s:4:"icon";s:0:"";s:3:"url";s:18:"bbs/post/run?fid=2";s:12:"created_time";i:1352099420;s:8:"complete";i:1;}', 1352099420, 1352099420),
	(5, 2, 5, 2, 0, '未完成任务提醒', 'a:6:{s:2:"id";s:1:"4";s:5:"title";s:18:"喜欢一个帖子";s:4:"icon";s:0:"";s:3:"url";s:20:"bbs/thread/run?fid=2";s:12:"created_time";i:1352531228;s:8:"complete";i:0;}', 1352531228, 1352531228),
	(6, 2, 5, 2, 0, '未完成任务提醒', 'a:6:{s:2:"id";s:1:"1";s:5:"title";s:18:"发布一个帖子";s:4:"icon";s:0:"";s:3:"url";s:18:"bbs/post/run?fid=2";s:12:"created_time";i:1352531228;s:8:"complete";i:0;}', 1352531228, 1352531228),
	(7, 2, 4, 0, 0, '勋章提醒', 'a:5:{s:5:"logid";s:1:"2";s:4:"name";s:12:"社区居民";s:7:"medelId";s:1:"1";s:4:"type";i:1;s:6:"reason";s:0:"";}', 1352531228, 1352531228),
	(8, 2, 13, 2, 0, '您的帐号已被system执行禁止签名操作。', 'a:6:{s:8:"operator";s:6:"system";s:4:"type";a:1:{i:0;s:12:"禁止签名";}s:8:"end_time";s:0:"";s:12:"created_time";N;s:6:"reason";s:12:"禁止理由";s:3:"ban";i:1;}', 1354083191, 1354083191);
/*!40000 ALTER TABLE `pw_user_notices` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.z_pw_h_second_hireoverdue
CREATE TABLE IF NOT EXISTS `z_pw_h_second_hireoverdue` (
  `houseid` int(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：房源id',
  `areatype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属区域',
  `platetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属商圈',
  `pricetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属价格区间',
  `housetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属物业类型',
  `roomtype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属户型',
  `hiretype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：租赁方式（整租 合租 床位）',
  `posttime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：发布时间',
  `modifytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：修改时间',
  `price` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：租金',
  KEY `idx_houseid` (`houseid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：出租房过期索引表';

-- Dumping data for table ci_pw_house.z_pw_h_second_hireoverdue: 0 rows
/*!40000 ALTER TABLE `z_pw_h_second_hireoverdue` DISABLE KEYS */;
/*!40000 ALTER TABLE `z_pw_h_second_hireoverdue` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.z_pw_h_second_saleoverdue
CREATE TABLE IF NOT EXISTS `z_pw_h_second_saleoverdue` (
  `houseid` int(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：房源id',
  `areatype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属区域',
  `platetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属商圈',
  `pricetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属价格区间',
  `acreagetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属面积区间',
  `roomtype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属户型',
  `housetype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：所属物业类型',
  `modifytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：发布时间',
  `posttime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：修改时间',
  `price` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：总价',
  `unitprice` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：单价',
  KEY `idx_houseid` (`houseid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：二手房过期索引表';

-- Dumping data for table ci_pw_house.z_pw_h_second_saleoverdue: 0 rows
/*!40000 ALTER TABLE `z_pw_h_second_saleoverdue` DISABLE KEYS */;
/*!40000 ALTER TABLE `z_pw_h_second_saleoverdue` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.z_pw_user_broker_group
CREATE TABLE IF NOT EXISTS `z_pw_user_broker_group` (
  `groupid` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT 'pw：用户组ID',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT 'pw：用户组名称',
  `usernum` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：成员统计',
  `vieworder` tinyint(3) NOT NULL DEFAULT '0' COMMENT 'pw90v1：排序',
  PRIMARY KEY (`groupid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='pw：经纪人用户组';

-- Dumping data for table ci_pw_house.z_pw_user_broker_group: 4 rows
/*!40000 ALTER TABLE `z_pw_user_broker_group` DISABLE KEYS */;
INSERT INTO `z_pw_user_broker_group` (`groupid`, `name`, `usernum`, `vieworder`) VALUES
	(1, '一星经纪人', 0, 0),
	(2, '二星经纪人', 0, 0),
	(3, '三星经纪人', 0, 0),
	(4, '四星经纪人', 0, 0);
/*!40000 ALTER TABLE `z_pw_user_broker_group` ENABLE KEYS */;


-- Dumping structure for table ci_pw_house.z_pw_user_broker_right
CREATE TABLE IF NOT EXISTS `z_pw_user_broker_right` (
  `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'pw：用户组ID',
  `rkey` varchar(32) NOT NULL COMMENT 'pw：权限键值',
  `rvalue` varchar(32) NOT NULL COMMENT 'pw：权限值',
  `vtype` enum('string','array') NOT NULL DEFAULT 'string' COMMENT 'CIv1：权限值类型',
  PRIMARY KEY (`groupid`,`rkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='pw：经纪人用户组权限';

-- Dumping data for table ci_pw_house.z_pw_user_broker_right: 4 rows
/*!40000 ALTER TABLE `z_pw_user_broker_right` DISABLE KEYS */;
INSERT INTO `z_pw_user_broker_right` (`groupid`, `rkey`, `rvalue`, `vtype`) VALUES
	(1, 'posttype', 'day', 'string'),
	(1, 'postnum', '2', 'string'),
	(1, 'ifpost_sale', '1', 'string'),
	(1, 'ifpost_hire', '1', 'string');
/*!40000 ALTER TABLE `z_pw_user_broker_right` ENABLE KEYS */;
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;