08CMS房产网3.2商业版+域名无限制

# <?exit();?> # 08cms InstallPack Dump Vol.1 # Version: 08cms 3.2 # Date: 2012-07-30 # -------------------------------------------------------- # Home: www.08cms.com # -------------------------------------------------------- DROP TABLE IF EXISTS {$tblprefix}aalbum_hxt; CREATE TABLE {$tblprefix}aalbum_hxt ( abid mediumint(8) unsigned NOT NULL auto_increment COMMENT '合辑编号', arid smallint(6) unsigned NOT NULL default '0' COMMENT '合辑项目编号', inid mediumint(8) unsigned NOT NULL default '0' COMMENT '文档编号', pid mediumint(8) unsigned NOT NULL default '0' COMMENT '文档父编号', incheck tinyint(1) unsigned NOT NULL default '0' COMMENT '文档检查', inorder smallint(6) unsigned NOT NULL default '0' COMMENT '合辑排序', PRIMARY KEY (abid) ) TYPE=MyISAM COMMENT='合辑-房源内户型图表'; DROP TABLE IF EXISTS {$tblprefix}aalbum_xqt; CREATE TABLE {$tblprefix}aalbum_xqt ( abid mediumint(8) unsigned NOT NULL auto_increment COMMENT '合辑编号', arid smallint(6) unsigned NOT NULL default '0' COMMENT '合辑项目编号', inid mediumint(8) unsigned NOT NULL default '0' COMMENT '文档编号', pid mediumint(8) unsigned NOT NULL default '0' COMMENT '文档父编号', incheck tinyint(1) unsigned NOT NULL default '0' COMMENT '文档检查', inorder smallint(6) unsigned NOT NULL default '0' COMMENT '合辑排序', PRIMARY KEY (abid), KEY pid (pid) ) TYPE=MyISAM COMMENT='合辑-房源内小区图表'; DROP TABLE IF EXISTS {$tblprefix}aalbum_zt; CREATE TABLE {$tblprefix}aalbum_zt ( abid mediumint(8) unsigned NOT NULL auto_increment COMMENT '合辑编号', arid smallint(6) unsigned NOT NULL default '0' COMMENT '合辑项目编号', inid mediumint(8) unsigned NOT NULL default '0' COMMENT '文档编号', pid mediumint(8) unsigned NOT NULL default '0' COMMENT '文档父编号', incheck tinyint(1) unsigned NOT NULL default '0' COMMENT '文档检查', inorder smallint(6) unsigned NOT NULL default '0' COMMENT '合辑排序', PRIMARY KEY (abid), KEY pid (pid) ) TYPE=MyISAM COMMENT='合辑-关联专题表'; DROP TABLE IF EXISTS {$tblprefix}aalbums; CREATE TABLE {$tblprefix}aalbums ( abid mediumint(8) unsigned NOT NULL auto_increment COMMENT '合辑编号', arid smallint(6) unsigned NOT NULL default '0' COMMENT '合辑项目编号', inid mediumint(8) unsigned NOT NULL default '0' COMMENT '文档编号', pid mediumint(8) unsigned NOT NULL default '0' COMMENT '文档父编号', incheck tinyint(1) unsigned NOT NULL default '0' COMMENT '文档检查', inorder smallint(6) unsigned NOT NULL default '0' COMMENT '合辑排序', PRIMARY KEY (abid), KEY pid (pid) ) TYPE=MyISAM COMMENT='合辑表'; DROP TABLE IF EXISTS {$tblprefix}abrels; CREATE TABLE {$tblprefix}abrels ( arid smallint(6) unsigned NOT NULL auto_increment COMMENT '合辑项目编号', cname varchar(50) NOT NULL COMMENT '合辑项目名称', remark varchar(255) NOT NULL COMMENT '备注', `source` tinyint(1) unsigned NOT NULL default '0' COMMENT '归辑来源', target tinyint(1) unsigned NOT NULL default '0' COMMENT '归辑目标', tbl varchar(50) NOT NULL COMMENT '记录表', available tinyint(1) unsigned NOT NULL default '0' COMMENT '生效', cfgs text NOT NULL COMMENT '参数数组', cfgs0 text NOT NULL COMMENT '参数数组', content text NOT NULL COMMENT '内容说明', vieworder smallint(6) unsigned NOT NULL default '0' COMMENT '排序', PRIMARY KEY (arid) ) TYPE=MyISAM AUTO_INCREMENT=33 COMMENT='合辑项目表'; INSERT INTO {$tblprefix}abrels VALUES ('1','楼盘内资讯','资讯->楼盘','0','0','aalbums','1','a:3:{s:6:\"schids\";a:1:{i:0;i:1;}s:6:\"tchids\";a:1:{i:0;i:4;}s:9:\"autocheck\";i:1;}','array (\r\n \'schids\' => \r\n array (\r\n 0 => 1,\r\n ),\r\n \'tchids\' => \r\n array (\r\n 0 => 4,\r\n ),\r\n \'autocheck\' => 1,\r\n)','','0'); INSERT INTO {$tblprefix}abrels VALUES ('4','公司内经纪人','经纪人->经纪公司','1','1','','1','','','经纪人会员独立注册，注册时选择公司或注册后加入公司。\r\n公司审核加入的经纪人，也可以取消申请，公司允许修改内部经纪人的密码或解审会员。\r\n可以为经济人分配运作资金。可以查看经纪人的基本信息及房源统计信息。','0'); INSERT INTO {$tblprefix}abrels VALUES ('2','订购活动内户型','户型->订购活动','0','0','aalbums','1','a:3:{s:6:\"schids\";a:1:{i:0;i:11;}s:6:\"tchids\";a:1:{i:0;i:5;}s:9:\"autocheck\";i:1;}','array (\r\n \'schids\' => \r\n array (\r\n 11\r\n ),\r\n \'tchids\' => \r\n array (\r\n 5\r\n ),\r\n \'autocheck\' => 1,\r\n)','','0'); INSERT INTO {$tblprefix}abrels VALUES ('3','楼盘内房源(团购)','单个文档->单个楼盘','0','0','','1','a:3:{s:6:\"schids\";a:5:{i:0;i:2;i:1;i:3;i:2;i:5;i:3;i:7;i:4;i:11;}s:6:\"tchids\";a:1:{i:0;i:4;}s:9:\"autocheck\";i:1;}','array (\r\n \'schids\' => \r\n array (\r\n 2,3,5,7,11\r\n ),\r\n \'tchids\' => \r\n array (\r\n 0 => 4,\r\n ),\r\n \'autocheck\' => 1,\r\n)','','0'); INSERT INTO {$tblprefix}abrels VALUES ('5','楼盘内视频','视频->楼盘','0','0','','1','','','一个视频属于多个楼盘，一个楼盘里面只能加载一个视频','0'); INSERT INTO {$tblprefix}abrels VALUES ('6','楼盘内开发商','开发商->楼盘','0','0','','1','','','一个开发商可以属于多个楼盘，一个楼盘只能有一个开发商','0'); INSERT INTO {$tblprefix}abrels VALUES ('17','房源内小区图','小区图->房源','0','0','aalbum_xqt','1','a:4:{s:6:\"schids\";a:1:{i:0;i:7;}s:6:\"tchids\";a:2:{i:0;i:2;i:1;i:3;}s:9:\"autocheck\";i:1;s:8:\"issingle\";i:1;}','array (\r\n \'schids\' => \r\n array (\r\n 0 => 7,\r\n ),\r\n \'tchids\' => \r\n array (\r\n 0 => 2,\r\n 1 => 3,\r\n ),\r\n \'autocheck\' => 1,\r\n \'issingle\' => 1,\r\n)','','0'); INSERT INTO {$tblprefix}abrels VALUES ('12','关联专题','资讯、楼盘、活动、视频、开发商->专题','0','0','aalbum_zt','1','','','','0'); INSERT INTO {$tblprefix}abrels VALUES ('18','房源内户型图','户型图->房源','0','0','aalbum_hxt','1','a:4:{s:6:\"schids\";a:1:{i:0;i:11;}s:6:\"tchids\";a:2:{i:0;i:2;i:1;i:3;}s:9:\"autocheck\";i:1;s:8:\"issingle\";i:1;}','array (\r\n \'schids\' => \r\n array (\r\n 0 => 11,\r\n ),\r\n \'tchids\' => \r\n array (\r\n 0 => 2,\r\n 1 => 3,\r\n ),\r\n \'autocheck\' => 1,\r\n\'issingle\' => 1,\r\n)','','0'); INSERT INTO {$tblprefix}abrels VALUES ('31','设计师案例','设计师->装修案例','0','0','','1','','','','0'); INSERT INTO {$tblprefix}abrels VALUES ('32','装修案例','装修案例->楼盘','0','0','','1','','','','0'); DROP TABLE IF EXISTS {$tblprefix}acommus; CREATE TABLE {$tblprefix}acommus ( cuid smallint(6) unsigned NOT NULL auto_increment COMMENT '交互项目编号', cname varchar(30) NOT NULL COMMENT '名称', remark varchar(100) NOT NULL COMMENT '备注', available tinyint(1) unsigned NOT NULL default '1' COMMENT '生效', tbl varchar(30) NOT NULL COMMENT '记录表', cfgs0 text NOT NULL COMMENT '参数数组', cfgs text NOT NULL COMMENT '参数数组', vieworder smallint(6) unsigned NOT NULL default '0' COMMENT '排序', content text NOT NULL COMMENT '内容说明', PRIMARY KEY (cuid) ) TYPE=MyISAM AUTO_INCREMENT=41 COMMENT='交互项目表'; INSERT INTO {$tblprefix}acommus VALUES ('1','资讯评论','','1','commu_zixun','','a:4:{s:5:\"chids\";a:2:{i:0;s:1:\"1\";i:1;s:2:\"14\";}s:4:\"pmid\";s:1:\"0\";s:9:\"autocheck\";s:1:\"1\";s:10:\"repeattime\";s:0:\"\";}','0','模板资料调用--------------------------------------------------\r\nopt1有道理次数，opt2没有道理次数\r\n表单使用说明--------------------------------------------------\r\n前台评论链接：etools/comment.php?aid=xx&tocid=xx 有tocid表示在评论的基础上进行评论\r\n表单按钮：bsubmit，表单数组前缀：fmdata\r\n表单中来源页链接传送：forward={forward}\r\n投票链接：etools/comment.php?action=vote&cid=xx&opt=x(1或2)&inajax=1(可选)'); INSERT INTO {$tblprefix}acommus VALUES ('2','楼盘点评','','1','commu_dp','','a:4:{s:5:\"chids\";a:1:{i:0;s:1:\"4\";}s:4:\"pmid\";s:1:\"0\";s:9:\"autocheck\";s:1:\"1\";s:10:\"repeattime\";s:2:\"30\";}','0','模板资料调用--------------------------------------------------\r\ntotal为单条总评分\r\n\r\n表单使用说明--------------------------------------------------\r\n前台点评链接：etools/dianpin.php?aid=xx\r\n表单按钮：bsubmit，表单数组前缀：fmdata\r\n表单中来源页链接传送：forward={forward}'); INSERT INTO {$tblpref