set names utf8;CREATE TABLE `lyfz_admin` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID号',
  `name` varchar(50) NOT NULL COMMENT '账号',
  `email` varchar(100) NOT NULL COMMENT '邮箱',
  `pass` varchar(50) NOT NULL COMMENT '密码',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1正常0锁定',
  `if_system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1系统管理员0普通管理员',
  `popedom` text NOT NULL COMMENT '权限',
  `langid` varchar(255) NOT NULL COMMENT '可操作的语言权限，系统管理员不限',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
insert into `lyfz_admin`(`id`,`name`,`email`,`pass`,`status`,`if_system`,`popedom`,`langid`) values('1','admin','admin@admin.com','c3284d0f94606de1fd2af172aba15bf3','1','1','','');

CREATE TABLE `lyfz_cache` (
  `id` varchar(50) NOT NULL COMMENT 'ID号',
  `langid` varchar(5) NOT NULL DEFAULT 'zh' COMMENT '语言ID',
  `content` longtext NOT NULL COMMENT '缓存内容',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '缓存时间',
  PRIMARY KEY (`id`,`langid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `lyfz_cate` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID号',
  `identifier` varchar(30) NOT NULL COMMENT '标识串，必须是唯一的',
  `langid` varchar(5) NOT NULL COMMENT '语言标识',
  `cate_name` varchar(100) NOT NULL COMMENT '分类名称',
  `parentid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '父级ID，如果为根分类，则使用0',
  `module_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '模块ID',
  `tpl_index` varchar(100) NOT NULL COMMENT '封面模板',
  `tpl_list` varchar(100) NOT NULL COMMENT '列表模板',
  `tpl_file` varchar(100) NOT NULL COMMENT '内容模板',
  `if_index` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否是封面，0否1是',
  `taxis` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT '排序，值越小越往前靠',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1使用中0禁用',
  `if_hidden` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1隐藏0显示',
  `keywords` varchar(255) NOT NULL COMMENT 'SEO关键字',
  `description` varchar(255) NOT NULL COMMENT 'SEO描述',
  `ifspec` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0非单页1单页',
  `note` text NOT NULL COMMENT '简要描述',
  `psize` tinyint(3) unsigned NOT NULL DEFAULT '30' COMMENT '每页显示数量，默认30',
  `inpic` varchar(100) NOT NULL COMMENT '前台默认图片关联',
  `linkurl` varchar(255) NOT NULL COMMENT '自定义链接',
  `target` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '新窗口打开1是0否',
  `ordertype` varchar(100) NOT NULL DEFAULT 'post_date:desc' COMMENT '排序类型，默认是发布时间',
  `subcate` varchar(100) NOT NULL COMMENT '分类副标题',
  `ico` varchar(255) NOT NULL COMMENT '图标',
  `small_pic` varchar(255) NOT NULL COMMENT '小图',
  `medium_pic` varchar(255) NOT NULL COMMENT '中图',
  `big_pic` varchar(255) NOT NULL COMMENT '大图',
  `fields` varchar(255) NOT NULL COMMENT '有效字段',
  PRIMARY KEY (`id`),
  KEY `module_id` (`module_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `lyfz_commission` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID号',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `pid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `uname` varchar(200) NOT NULL,
  `cid` mediumint(8) NOT NULL,
  `username` varchar(100) NOT NULL COMMENT '会员名称',
  `proname` varchar(220) NOT NULL DEFAULT '0',
  `ctype` varchar(20) NOT NULL DEFAULT '0',
  `turnover` float NOT NULL COMMENT '当前推荐客户的成交金额',
  `money` float NOT NULL COMMENT '当前合伙人佣金',
  `money2` float NOT NULL COMMENT '当前合伙人推荐人佣金',
  `money3` float NOT NULL COMMENT '当前合伙人第二推荐人佣金',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0未审核1正常2锁定',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `listid` (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
insert into `lyfz_commission`(`id`,`uid`,`pid`,`uname`,`cid`,`username`,`proname`,`ctype`,`turnover`,`money`,`money2`,`money3`,`status`,`postdate`) values('1','1','0','刘超','1','李四','2015双11聚划算','佣金','2000','100','0','0','1','1447382474');
insert into `lyfz_commission`(`id`,`uid`,`pid`,`uname`,`cid`,`username`,`proname`,`ctype`,`turnover`,`money`,`money2`,`money3`,`status`,`postdate`) values('2','3','0','李四','1','李四','2015双11聚划算','佣金','2000','100','60','40','0','1447383443');
insert into `lyfz_commission`(`id`,`uid`,`pid`,`uname`,`cid`,`username`,`proname`,`ctype`,`turnover`,`money`,`money2`,`money3`,`status`,`postdate`) values('3','2','2','张三','1','李四','2015双11聚划算','佣金','0','60','0','0','0','1447383443');
insert into `lyfz_commission`(`id`,`uid`,`pid`,`uname`,`cid`,`username`,`proname`,`ctype`,`turnover`,`money`,`money2`,`money3`,`status`,`postdate`) values('4','1','2','刘超','1','李四','2015双11聚划算','佣金','0','40','0','0','0','1447383443');

CREATE TABLE `lyfz_commissiontx` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID号',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `uname` varchar(200) NOT NULL,
  `money` float NOT NULL,
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0申请中1已提现',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '申请提现时时间',
  `okpostdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '完成提现时间',
  PRIMARY KEY (`id`),
  KEY `listid` (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
insert into `lyfz_commissiontx`(`id`,`uid`,`uname`,`money`,`status`,`postdate`,`okpostdate`) values('1','1','刘超','50','0','1447382674','0');

CREATE TABLE `lyfz_customer` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID号',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `uname` varchar(200) NOT NULL,
  `username` varchar(100) NOT NULL COMMENT '会员名称',
  `cellphone` varchar(20) NOT NULL,
  `proname` varchar(220) NOT NULL DEFAULT '0',
  `appointment_date` varchar(10) NOT NULL DEFAULT '0',
  `appointment_time` varchar(10) NOT NULL,
  `remark` text NOT NULL,
  `guwenname` varchar(100) NOT NULL,
  `guwentel` varchar(100) NOT NULL,
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0未审核1正常2锁定',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0',
  `daofang` int(1) NOT NULL DEFAULT '0',
  `dfnote` text NOT NULL,
  `renchou` int(1) NOT NULL DEFAULT '0',
  `rcnote` text NOT NULL,
  `rengou` int(1) NOT NULL DEFAULT '0',
  `rgnote` text NOT NULL,
  `qianyue` int(1) NOT NULL DEFAULT '0',
  `qynote` text NOT NULL,
  `huikuan` int(1) NOT NULL DEFAULT '0',
  `hknote` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `listid` (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
insert into `lyfz_customer`(`id`,`uid`,`uname`,`username`,`cellphone`,`proname`,`appointment_date`,`appointment_time`,`remark`,`guwenname`,`guwentel`,`status`,`postdate`,`daofang`,`dfnote`,`renchou`,`rcnote`,`rengou`,`rgnote`,`qianyue`,`qynote`,`huikuan`,`hknote`) values('1','1','刘超','李四','13669855458','2015双11聚划算','2015-11-14','10:40','','','','1','1447382457','0','','0','','0','','0','','0','');

CREATE TABLE `lyfz_gd` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID号',
  `pictype` varchar(50) NOT NULL DEFAULT '' COMMENT '图片类型标识',
  `picsubject` varchar(255) NOT NULL DEFAULT '' COMMENT '类型名称',
  `width` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '图片宽度',
  `height` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '图片高度',
  `water` varchar(255) NOT NULL DEFAULT '' COMMENT '水印图片位置',
  `picposition` varchar(100) NOT NULL DEFAULT '' COMMENT '水印位置',
  `trans` tinyint(3) unsigned NOT NULL DEFAULT '65' COMMENT '透明度，默认是60',
  `cuttype` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '图片生成方式，支持缩放法和裁剪法两种，默认使用缩放法',
  `quality` tinyint(3) unsigned NOT NULL DEFAULT '80' COMMENT '图片生成质量，默认是80',
  `border` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否支持边框，1是0否',
  `bordercolor` varchar(10) NOT NULL DEFAULT 'FFFFFF' COMMENT '边框颜色',
  `padding` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '间距，默认是0,最大不超过255',
  `bgcolor` varchar(10) NOT NULL DEFAULT 'FFFFFF' COMMENT '补白背景色，默认是白色',
  `bgimg` varchar(255) NOT NULL DEFAULT '' COMMENT '背景图片，默认为空',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否使用，默认是使用',
  `taxis` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT '排序，值越小越往前靠，最大不超过255，最小为0',
  `edit_default` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
insert into `lyfz_gd`(`id`,`pictype`,`picsubject`,`width`,`height`,`water`,`picposition`,`trans`,`cuttype`,`quality`,`border`,`bordercolor`,`padding`,`bgcolor`,`bgimg`,`status`,`taxis`,`edit_default`) values('1','thumb','头像缩图','75','75','','middle-middle','50','0','80','0','','0','CD332C','','1','1','0');
insert into `lyfz_gd`(`id`,`pictype`,`picsubject`,`width`,`height`,`water`,`picposition`,`trans`,`cuttype`,`quality`,`border`,`bordercolor`,`padding`,`bgcolor`,`bgimg`,`status`,`taxis`,`edit_default`) values('3','big','大图','600','600','','bottom-right','70','2','80','0','','0','FFFFFF','','1','2','1');
insert into `lyfz_gd`(`id`,`pictype`,`picsubject`,`width`,`height`,`water`,`picposition`,`trans`,`cuttype`,`quality`,`border`,`bordercolor`,`padding`,`bgcolor`,`bgimg`,`status`,`taxis`,`edit_default`) values('2','mid','项目标志','282','120','','middle-middle','50','1','60','0','','0','CD332C','','1','2','0');

CREATE TABLE `lyfz_identifier` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `sign` varchar(32) NOT NULL COMMENT '标识符，用于本系统内所有需要此功能，仅限字母数字及下划线且第一个必须是字母',
  `title` varchar(100) NOT NULL COMMENT '名称',
  `langid` varchar(5) NOT NULL COMMENT '语言编号，如zh,en等',
  `module_id` mediumint(8) unsigned NOT NULL COMMENT '一个标识符只能用于一个模块，一个模块有多个标识符',
  `if_system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1系统0自定义',
  `g_sign` varchar(100) NOT NULL COMMENT '组标识，仅在核心技术中使用',
  `taxis` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT '排序',
  PRIMARY KEY (`id`),
  KEY `module_id` (`module_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
insert into `lyfz_identifier`(`id`,`sign`,`title`,`langid`,`module_id`,`if_system`,`g_sign`,`taxis`) values('1','popedom','权限管理','zh','1','1','','255');
insert into `lyfz_identifier`(`id`,`sign`,`title`,`langid`,`module_id`,`if_system`,`g_sign`,`taxis`) values('2','module','模块管理','zh','2','1','','255');
insert into `lyfz_identifier`(`id`,`sign`,`title`,`langid`,`module_id`,`if_system`,`g_sign`,`taxis`) values('3','add','添加','zh','0','1','popedom','201');
insert into `lyfz_identifier`(`id`,`sign`,`title`,`langid`,`module_id`,`if_system`,`g_sign`,`taxis`) values('4','modify','修改','zh','0','1','popedom','202');
insert into `lyfz_identifier`(`id`,`sign`,`title`,`langid`,`module_id`,`if_system`,`g_sign`,`taxis`) values('5','check','审核','zh','0','1','popedom','203');
insert into `lyfz_identifier`(`id`,`sign`,`title`,`langid`,`module_id`,`if_system`,`g_sign`,`taxis`) values('6','delete','删除','zh','0','1','popedom','204');
insert into `lyfz_identifier`(`id`,`sign`,`title`,`langid`,`module_id`,`if_system`,`g_sign`,`taxis`) values('7','list','查看','zh','0','1','popedom','200');
insert into `lyfz_identifier`(`id`,`sign`,`title`,`langid`,`module_id`,`if_system`,`g_sign`,`taxis`) values('8','setting','设置','zh','0','1','popedom','205');
insert into `lyfz_identifier`(`id`,`sign`,`title`,`langid`,`module_id`,`if_system`,`g_sign`,`taxis`) values('9','save','存储','zh','0','1','popedom','206');
insert into `lyfz_identifier`(`id`,`sign`,`title`,`langid`,`module_id`,`if_system`,`g_sign`,`taxis`) values('10','group','组管理','zh','0','1','popedom','255');

CREATE TABLE `lyfz_input` (
  `input` varchar(50) NOT NULL COMMENT '扩展框类型',
  `langid` varchar(5) NOT NULL DEFAULT 'zh' COMMENT '语言ID',
  `name` varchar(100) NOT NULL COMMENT '名字',
  `taxis` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT '排序',
  `ifuser` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否允许会员表使用0否1是',
  PRIMARY KEY (`input`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
insert into `lyfz_input`(`input`,`langid`,`name`,`taxis`,`ifuser`) values('text','zh','文本框','10','1');
insert into `lyfz_input`(`input`,`langid`,`name`,`taxis`,`ifuser`) values('radio','zh','单选框','20','1');
insert into `lyfz_input`(`input`,`langid`,`name`,`taxis`,`ifuser`) values('checkbox','zh','复选框','30','1');
insert into `lyfz_input`(`input`,`langid`,`name`,`taxis`,`ifuser`) values('textarea','zh','文本区域','40','1');
insert into `lyfz_input`(`input`,`langid`,`name`,`taxis`,`ifuser`) values('edit','zh','可视化编辑器','50','0');
insert into `lyfz_input`(`input`,`langid`,`name`,`taxis`,`ifuser`) values('select','zh','下拉菜单','60','1');
insert into `lyfz_input`(`input`,`langid`,`name`,`taxis`,`ifuser`) values('img','zh','图片选择器','70','1');
insert into `lyfz_input`(`input`,`langid`,`name`,`taxis`,`ifuser`) values('video','zh','影音选择器','80','1');
insert into `lyfz_input`(`input`,`langid`,`name`,`taxis`,`ifuser`) values('download','zh','下载框选择器','90','1');
insert into `lyfz_input`(`input`,`langid`,`name`,`taxis`,`ifuser`) values('opt','zh','联动选择','100','1');
insert into `lyfz_input`(`input`,`langid`,`name`,`taxis`,`ifuser`) values('simg','zh','图片选择器（单张）','75','1');
insert into `lyfz_input`(`input`,`langid`,`name`,`taxis`,`ifuser`) values('module','zh','内联模块','110','0');

CREATE TABLE `lyfz_lang` (
  `langid` varchar(5) NOT NULL DEFAULT 'zh' COMMENT '语言ID',
  `title` varchar(100) NOT NULL COMMENT '显示名',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态1不使用2使用',
  `note` varchar(255) NOT NULL COMMENT '描述',
  `taxis` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT '排序，小值排前',
  `ifdefault` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否是系统默认',
  `ifsystem` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1系统语言0应用语言',
  `ico` varchar(255) NOT NULL COMMENT '图标',
  `small_pic` varchar(255) NOT NULL COMMENT '小图',
  `medium_pic` varchar(255) NOT NULL COMMENT '中图',
  `big_pic` varchar(255) NOT NULL COMMENT '大图',
  PRIMARY KEY (`langid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
insert into `lyfz_lang`(`langid`,`title`,`status`,`note`,`taxis`,`ifdefault`,`ifsystem`,`ico`,`small_pic`,`medium_pic`,`big_pic`) values('zh','简体中文','1','','1','1','1','','','','');

CREATE TABLE `lyfz_lang_msg` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID号',
  `langid` varchar(5) NOT NULL DEFAULT 'zh' COMMENT '语言ID',
  `ltype` enum('www','admin','all') NOT NULL DEFAULT 'all' COMMENT '语言包应用范围',
  `var` varchar(100) NOT NULL COMMENT '语言变量名，仅英文数字及下划线',
  `val` varchar(255) NOT NULL COMMENT '语言值',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=469 DEFAULT CHARSET=utf8;
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('1','zh','admin','cp_name','后台管理');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('2','zh','all','error_note','如果系统不能在 <span style=\"color:red;\">{time}</span> 秒后自动返回，请点这里');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('11','zh','admin','select_cate','请选择分类');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('4','zh','admin','no_popedom','Error: 对不起，您没有操作此功能权限');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('5','zh','admin','login_false','管理员登录失败，请检查…');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('6','zh','admin','login_not_user_pass','账号或密码不能为空');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('7','zh','admin','login_success','欢迎您 <span style=\'color:red;\'>{admin_realname}</span> 登录网站系统后台，请稍候…');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('8','zh','all','login_vcode_empty','验证码不能为空');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('9','zh','all','login_vcode_false','验证码填写错误');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('10','zh','admin','logout_success','管理员 <span style=\'color:red;\'>{admin_realname}</span> 成功退出！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('23','zh','www','login_false_empty','登录失败，账号或密码为空！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('24','zh','www','login_false_rs','登录失败，会员信息不存在，请检查。');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('25','zh','www','login_false_password','登录失败，会员密码不正确。');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('26','zh','www','login_false_lock','登录失败，会员账号已被管理员锁定，请联系管理员。');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('27','zh','www','login_false_check','登录失败，您的账号尚未激活！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('28','zh','www','login_usccess','您的账号已经正常登录，请稍候……');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('29','zh','www','login_exists','您已经登录，请返回…');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('30','zh','www','module_is_close','模块未启用');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('31','zh','www','not_any_title_in_module','没有任何相关主题');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('32','zh','www','not_found_any_module','没有找到模块信息！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('34','zh','www','not_any_cate_in_module','当前模块中没有任何分类信息');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('59','zh','www','download_error','没有指定附件信息！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('60','zh','www','download_empty','附件已经不存在！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('61','zh','www','login','合伙人登录');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('63','zh','www','login_user_email_chk','账号或邮箱不允许为空！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('64','zh','www','login_not_user_email','账号不存在或是邮箱填写不正确！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('467','zh','www','recommend','推荐客户');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('468','zh','www','customer','我的客户');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('67','zh','www','login_not_code_user','会员账号或验证串不允许为空');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('68','zh','www','login_not_user','账号不存在！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('71','zh','www','login_not_pass','密码不允许为空！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('72','zh','www','login_error_pass','两次输入的密码不一致！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('73','zh','www','login_update','会员密码更新成功！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('74','zh','www','msg_not_id','获取数据失败，没有指定主题标识串或ID');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('75','zh','www','msg_not_rs','无法获取内容信息，请检查');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('76','zh','www','open_user','非会员不支持此功能！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('77','zh','all','open_not_picture','批量生成图片错误，没有取得一张有效图片');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('78','zh','all','open_not_id','没有指定要生成的图片ID');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('79','zh','all','open_pl_ok','图片批量生成完毕');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('80','zh','all','open_pl_wait','请稍候，系统正在批量生成新的图片方案');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('81','zh','all','open_not_pre_id','没有选择要预览的ID');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('82','zh','www','please_login','请先登录！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('83','zh','www','usercp','会员中心');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('86','zh','all','error','操作有错误，请检查！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('93','zh','all','all_category','全部分类');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('94','zh','all','category_select','请选择分类');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('97','zh','all','error_save','数据存储失败，请检查！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('98','zh','all','save_success','数据存储成功，请稍候…');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('99','zh','all','del_not_id','error：删除失败，没有指定ID');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('101','zh','www','is_logined','您已经登录了，不能使用注册功能');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('102','zh','all','register','合伙人注册');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('103','zh','www','empty_pass','密码不允许为空！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('104','zh','www','pass_not_right','两次输入的密码不一致');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('106','zh','www','register_ok','恭喜您注册成为我们的合伙人');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('107','zh','www','user_exists','账号已经存在');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('108','zh','www','empty_user','账号不允许为空');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('109','zh','all','error_not_id','error：操作错误，没有取得ID信息');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('110','zh','all','error_not_rs','error：操作错误，没有取得数据信息');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('114','zh','all','search','站内搜索');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('116','zh','www','user_not_login','非会员不允许执行此操作，请先登录！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('117','zh','www','usercp_info','修改资料');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('118','zh','www','usercp_save_success','会员信息更新成功！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('119','zh','www','usercp_changepass','修改个人密码');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('120','zh','www','usercp_not_oldpass','旧密码为空或是旧密码填写不正确！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('121','zh','www','usercp_not_newpass','新密码不允许为空或是两次输入的新密码不一致！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('122','zh','www','usercp_old_new','新旧密码一致，不需要修改！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('123','zh','www','pass_save_success','密码已经更新成功，下次请用新密码登录。');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('344','zh','all','page_home','首页');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('345','zh','all','page_prev','上一页');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('346','zh','all','page_next','下一页');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('347','zh','all','page_last','尾页');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('348','zh','all','not_popedom','您没有此权限！');
insert into `lyfz_lang_msg`(`id`,`langid`,`ltype`,`var`,`val`) values('349','zh','www','logout_user_success','成功退出');

CREATE TABLE `lyfz_list` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `module_id` mediumint(8) unsigned NOT NULL COMMENT '模块ID',
  `cate_id` mediumint(8) unsigned NOT NULL COMMENT '分类ID',
  `title` varchar(255) NOT NULL COMMENT '主题',
  `subtitle` varchar(255) NOT NULL COMMENT '副标题',
  `style` varchar(255) NOT NULL COMMENT '主题样式',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态，1正常0锁定',
  `hidden` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1隐藏0显示',
  `link_url` varchar(255) NOT NULL COMMENT '访问网址',
  `target` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否在新窗口打开1是0否',
  `author` varchar(100) NOT NULL COMMENT '发布人',
  `author_type` enum('admin','user','guest') NOT NULL DEFAULT 'user' COMMENT '发布人类型',
  `keywords` varchar(255) NOT NULL COMMENT '关键字，标签',
  `description` varchar(255) NOT NULL COMMENT '简要描述用于SEO优化',
  `note` text NOT NULL COMMENT '简要描述，用于列表简要说明',
  `identifier` varchar(100) NOT NULL COMMENT '访问标识串，为空时使用系统ID',
  `hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击率',
  `good_hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '支持次数',
  `bad_hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '拍砖次数',
  `post_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
  `modify_date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后修改时间',
  `thumb_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '缩略图ID',
  `istop` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1置顶0非置顶',
  `isvouch` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1推荐0非推荐',
  `isbest` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1精华0非精华',
  `langid` varchar(5) NOT NULL DEFAULT 'zh' COMMENT '语言ID，默认是中文',
  `points` int(10) NOT NULL DEFAULT '0' COMMENT '积分，点数',
  `ip` varchar(100) NOT NULL COMMENT '发布人IP号',
  `replydate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后回复时间',
  `taxis` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '自定义排序，值越大越往前靠',
  `htmltype` enum('mid','cateid','date','root') NOT NULL DEFAULT 'date' COMMENT 'HTML存储方式，默认是以时间来存储',
  `tplfile` varchar(100) NOT NULL COMMENT '模板文件',
  `star` float unsigned NOT NULL DEFAULT '0' COMMENT '星级评论，默认为0，根据评论表中的星数来决定',
  `yongjin` varchar(200) NOT NULL,
  `jili` varchar(200) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `module_id` (`module_id`,`cate_id`,`title`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
insert into `lyfz_list`(`id`,`module_id`,`cate_id`,`title`,`subtitle`,`style`,`status`,`hidden`,`link_url`,`target`,`author`,`author_type`,`keywords`,`description`,`note`,`identifier`,`hits`,`good_hits`,`bad_hits`,`post_date`,`modify_date`,`thumb_id`,`istop`,`isvouch`,`isbest`,`langid`,`points`,`ip`,`replydate`,`taxis`,`htmltype`,`tplfile`,`star`,`yongjin`,`jili`) values('1','2','0','注册协议','','','1','0','','0','admin','','','','','','54','0','0','1407889552','1411232737','0','0','0','0','zh','0','127.0.0.1','0','0','cateid','','0','','');
insert into `lyfz_list`(`id`,`module_id`,`cate_id`,`title`,`subtitle`,`style`,`status`,`hidden`,`link_url`,`target`,`author`,`author_type`,`keywords`,`description`,`note`,`identifier`,`hits`,`good_hits`,`bad_hits`,`post_date`,`modify_date`,`thumb_id`,`istop`,`isvouch`,`isbest`,`langid`,`points`,`ip`,`replydate`,`taxis`,`htmltype`,`tplfile`,`star`,`yongjin`,`jili`) values('2','2','0','活动细则','','','1','0','','0','admin','','','','','','108','0','0','1407889644','1411204961','0','0','0','0','zh','0','127.0.0.1','0','0','cateid','','0','','');
insert into `lyfz_list`(`id`,`module_id`,`cate_id`,`title`,`subtitle`,`style`,`status`,`hidden`,`link_url`,`target`,`author`,`author_type`,`keywords`,`description`,`note`,`identifier`,`hits`,`good_hits`,`bad_hits`,`post_date`,`modify_date`,`thumb_id`,`istop`,`isvouch`,`isbest`,`langid`,`points`,`ip`,`replydate`,`taxis`,`htmltype`,`tplfile`,`star`,`yongjin`,`jili`) values('3','2','0','欢迎页图片管理','','','1','0','','0','admin','','','','','','1','0','0','1407889679','1447555495','0','0','0','0','zh','0','127.0.0.1','0','0','cateid','','0','','');
insert into `lyfz_list`(`id`,`module_id`,`cate_id`,`title`,`subtitle`,`style`,`status`,`hidden`,`link_url`,`target`,`author`,`author_type`,`keywords`,`description`,`note`,`identifier`,`hits`,`good_hits`,`bad_hits`,`post_date`,`modify_date`,`thumb_id`,`istop`,`isvouch`,`isbest`,`langid`,`points`,`ip`,`replydate`,`taxis`,`htmltype`,`tplfile`,`star`,`yongjin`,`jili`) values('9','3','0','2015双11聚划算','','','1','0','','0','admin','','','','','','70','0','0','1407921108','1447143451','24','0','0','0','zh','0','127.0.0.1','0','0','cateid','','0','2000','');

CREATE TABLE `lyfz_list_c` (
  `id` int(10) unsigned NOT NULL COMMENT '主题ID',
  `field` varchar(30) NOT NULL DEFAULT '' COMMENT '字段名',
  `val` text NOT NULL COMMENT '内容',
  PRIMARY KEY (`id`,`field`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
insert into `lyfz_list_c`(`id`,`field`,`val`) values('1','content','<p class=\"grey2 txt_indent f12 mt25 clearfix\">欢迎您使用利亚方舟万众营销软件产品，我们将竭诚为您提供更全面、更优质的服务。本协议适用于新疆万科开发的商品房。在您注册之前，请先仔细阅读本协议的条款。您在使用程序前请点击&quot;我已阅读并同意以上条款&quot;按钮即表示您与公司达成协议，视为您已了解并完全接受本协议项下的全部条款。</p><p class=\"f14 grey1 mt25 clearfix\"><span class=\"b l\">1、</span><span class=\"r s4 b\">协议的完善和修改</span></p>    <p class=\"grey2 f12\">公司有权在必要时将根据互联网的发展和中华人民共和国有关法律、法规的变化，不断地完善服务质量并依此修改本协议的条款，修改后的协议条款将及时予以公布，用户确认公司无需就协议条款的修改事宜逐一通知用户。用户继续使用公司软件产品的，视为该用户接受修改后的协议条款，有关公司与该用户之间的权利以及义务的表述关系，均适用以最新修改后的协议条款为准。</p>    <p class=\"f14 grey1 mt25 clearfix\"><span class=\"b l\">2、</span><span class=\"r s4 b\">资质认证及推荐流程须知</span></p>    <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">2.1</span><span class=\"r s4\">合伙人身份认证：</span></p>    <p class=\"grey2 f12\">合伙人需年满18周岁，具有完全民事行为能力，并能够提供合法的身份证明，且合伙人需保证注册个人信息的真实性，不得以虚假信息注册，否则将被取消推荐资格，公司有权收回一切合伙人权益。</p><p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">2.2</span><span class=\"r s4\">被推荐人身份认证：</span></p>    <p class=\"grey2 f12\">由合伙人推荐的被推荐人，不得是合伙人本人或其直系亲属，且经系统筛查，被推荐人自到访之日起前30天内无到访新疆万科在售项目记录，则认定为新客户，否则相应的推荐行为无效。</p>    <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">2.3</span><span class=\"r s4\">信息传播的真实性：</span></p>    <p class=\"grey2 f12\">合伙人需通过万科现场培训、网络培训等形式，实际掌握各项目资料、在售产品情况，并真实、准确传播项目相关销售信息，不得弄虚作假传播任何虚假信息；</p>    <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">2.4</span><span class=\"r s4\">推荐有效期限：</span></p>    <p class=\"grey2 f12\">推荐双方经身份认证后，推荐人必须提前在&quot;我的客户&quot;模块中预约到访时间【预约时间最长不超过3天，若超过，则自动过期；预约时间最迟不得超过2014年8月31日】；若无预约记录，则不能享有推荐奖励；</p>    <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">2.5</span><span class=\"r s4\">具体推荐流程及奖励方式：</span></p>    <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">2.5.1</span><span class=\"r s2\">被推荐人权益：</span></p><p class=\"grey2 f12\">被推荐人在成功购买合伙人推荐的住宅时，若在2014年7月31日前完成《商品房买卖合同》的签订与签约，可在对应楼盘正常对外折扣的基础上，<span class=\"red\">额外享受该房源公示总价的1%优惠，逾期作废。</span></p>     <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">2.5.2</span><span class=\"r s2\">合伙人权益：</span></p>     <p class=\"grey2 f12\">被推荐人成功认购，<span class=\"red\">合伙人即可获得现金奖励500元</span>；被推荐人完成网上备案并成功签订《商品房买卖合同》，合伙人即可获得<span class=\"red\">最终成交价4‰（税前）推荐奖励（含500元）。</span></p>     <p class=\"grey2 f12\">（万科自有营销团队合伙人可获得5‰（税前）推荐奖励）</p>         <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">2.6</span><span class=\"r s2\">奖励结算方式：</span></p>     <p class=\"grey2 f12\">合伙人推荐成功后，合伙人和被推荐人需在2014年8月31日前到楼盘销售现场书面签订《新疆万科合伙人推荐表》确认双方身份，否则双方不享受相应的推荐奖励。</p>     <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">2.7</span><span class=\"r s5 b\">新疆万科对此次活动保留解释和说明的权利。</span></p>          <p class=\"f14 grey1 mt25 clearfix\"><span class=\"b l\">3.</span><span class=\"r s4 b\">注册信息和隐私保护</span></p>     <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">3.1</span><span class=\"r s5\">用户完成注册申请手续后，获得帐号的使用权，帐号的所有权归公司所有。用户应提供及时、详尽及准确的个人资料，并不断更新注册资料，符合及时、详尽、准确的要求。如果因注册信息不真实而引起的问题，并对问题发生所带来的后果，公司不负任何责任。</span></p>     <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">3.2</span><span class=\"r s5\">用户不应将其帐号、密码转让或出借予他人使用。如用户发现其帐号遭他人非法使用，应立即通知公司。因黑客行为或用户的保管疏忽导致帐号、密码遭他人非法使用，公司不承担任何责任。</span></p>     <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">3.3</span><span class=\"r s5\">用户因忘记密码遗失或密码被盗向公司查询密码时，必须提供完整、准确的注册信息，否则公司有权本着为用户保密的原则不予告知。</span></p>     <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">3.4</span><span class=\"r s5\">用户的用户名和密码只能供用户本人使用，不得以任何形式转让或授权他人使用，如果发现同一帐号和密码在同一时间内被多人同时登陆使用，公司有权取消此帐号的用户资格，并不予任何赔偿或者退还任何服务费用。</span></p>     <p class=\"f14 grey1 mt25 clearfix\"><span class=\"b l\">4.</span><span class=\"r s4 b\">服务内容的版权</span></p>     <p class=\"grey2 f12 mt25 clearfix\">公司的软件产品均受版权保护，用户不能擅自复制、随意发布相关服务内容，不得根据服务内容，改造或创造与服务内容有关的派生产品，不得将公司提供的数据和信息内容向他人发布并收取不正当的费用。</p>     <p class=\"f14 grey1 mt25 clearfix\"><span class=\"b l\">5、</span><span class=\"r s4 b\">免责条款</span></p>     <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">5.1</span><span class=\"r s5\">在服务期内，公司将有权根据经营活动的需要，随时对软件产品的服务内容进行更新、增加或删除，且无需另行通知或取得用户的同意。</span></p>     <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">5.2</span><span class=\"r s5\">公司尽力提供完整、及时、准确的信息，但不对所提供信息的完整性、及时性、准确性承担任何责任。</span></p>     <p class=\"f12 grey2 mt25 clearfix\"><span class=\"l  b\">5.3</span><span class=\"r s5\">由于地震、台风、战争、罢工、政府行为、瘟疫、爆发性和流行性传染病或其他重大疫情、各方原因造成的火灾、基础电信网络中断造成的及其它各方不能预见并且对其发生后果不能预防或避免的不可抗力原因，致使相关服务中断，公司不承担由此产生的损失，但应及时通知服务中断原因，并积极加以解决。</span></p>');
insert into `lyfz_list_c`(`id`,`field`,`val`) values('2','content','<p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px;\">1</span><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px; font-family: 宋体;\">、基础条款：</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">1<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）经纪人身份认证：</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-family: 宋体;\"></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 24px;\"><span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">经纪人需年满</span>18<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">周岁，具有完全民事行为能力。经纪人须提供合法的身份证明，且需保证注册的个人信息的真实性，任何人均不得以虚假信息注册，否则将被取消推荐资格，并不再享受与此有关的一切权益。</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 24px;\">2<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）被推荐人身份认证：</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 24px;\">Ø&nbsp;&nbsp;<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">由经纪人推荐的被推荐人，不得是经纪人本人或其直系亲属（配偶、父母、子女、兄弟姐妹）。</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 24px;\">Ø&nbsp;&nbsp;<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">经成都万科房地产有限公司（以下简称“成都万科”）销售系统查询，被推荐人在推荐日60日前有到访万科项目的记录，则相应的推荐行为无效。</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 24px;\">3<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）信息宣传的真实性：</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 24px;\">Ø&nbsp;&nbsp;<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">经纪人需熟练掌握各项目资料、在售产品情况，并真实、准确地宣传项目相关销售信息，不得夸大、隐瞒、虚假或过度承诺；</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 24px;\">Ø&nbsp;&nbsp;<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">经纪人需实施真实的推荐行为，即与被推荐人进行过明确的推荐沟通，否则相应推荐行为无效。</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">4）此政策执行至新政策发布之前。</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">&nbsp;</p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px;\">2</span><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px; font-family: 宋体;\">、推荐有效期限：</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">1<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）实施推荐后，被推荐人须在被推荐后</span><span style=\"margin: 0px; padding: 0px;\">20</span><span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">天内到访指定项目，并登记个人基本信息；若被推荐人在</span><span style=\"margin: 0px; padding: 0px;\">20<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">天</span></span><span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">内未到访指定项目，则视为推荐无效。</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">2<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）实施推荐后，被推荐人到访项目后</span>30<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">天内未认购所推荐的项目，则视为推荐无效；</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-family: 宋体;\"><br style=\"margin: 0px; padding: 0px;\" /></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px;\">3</span><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px; font-family: 宋体;\">、推荐人的权利与义务：</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">1<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）推荐人需自行配备上网的所需设备，负担个人上网所支付的与此相关的电话、网络及其他费用；</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">2<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）推荐人必须提供本人真实、准确、最新及完整的资料，并凭其身份证、注册的电话号码作为佣金结算的凭证。若推荐人提供任何错误、不实、过时或不完整的资料，导致不能成功结算佣金，成都万科概不承担任何责任。若成都万科确认或有合理理由相信推荐人的资料错误、不实、过时或不完整，成都万科有权暂停或终止推荐人的账号，推荐人不再享有成都万科官方微信所提供的全部或部分服务；</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">3<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）推荐人注册的用户名不能侵犯任何第三方的合法权益。否则，成都万科有权暂停或终止该账号的使用；</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">4<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）推荐人可以通过成都万科的微信公众账号或者现场培训（需要预约），了解万科各项目的资料、在售产品情况；</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">5<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）推荐人须真实、准确对外宣传所推荐项目的优惠信息，若有任何不实宣传，概由推荐人自行承担。若因此给成都万科或所推荐项目的开发企业造成任何损失，均有推荐人承担全部责任。</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-family: 宋体;\"><br style=\"margin: 0px; padding: 0px;\" /></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px;\">4</span><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px; font-family: 宋体;\">、推荐人与推荐客户推荐关系的确立细则：</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"margin: 0px; padding: 0px; line-height: 24px; font-family: 宋体;\">1）推荐人通过官方微信推荐有购买意向且未曾到访过项目的客户，客户必须为诚意客户，有意向项目。若客户被推荐后</span><span style=\"margin: 0px; padding: 0px; line-height: 24px;\">20<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">天</span><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(227, 108, 10); font-family: 宋体;\"></span></span></span><span style=\"margin: 0px; padding: 0px; line-height: 24px; font-family: 宋体;\">内未到访指定项目，则视为无效推荐。</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\">2<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）成都万科根据万科销售系统“明源系统”的记录反馈推荐客户的身份是否成立。登记客户推荐日前</span>60<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">天内未到访过万科项目或被其他人提前通过任何渠道推荐过，则推荐关系成立；</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\">3<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）推荐人不能把自己或直系亲属推荐为诚意客户。</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\">4<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）推荐人可以选择带或者不带诚意客户到成都万科购房中心。</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\">5<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）推荐人不得恶意推荐诚意客户，恶意推荐包括但不限于提供虚假的电话号码、推荐完全没有购买意向的客户。一经确认，成都万科有权暂停或终止推荐人的账号，并暂停前期未结佣金的发放。</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">&nbsp;</p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px;\">5</span><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px; font-family: 宋体;\">、被推荐人成交以及结佣：</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">1<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）被推荐人到达成都万科购房中心后由成都万科安排专人接待，客户到场、成交、签约的过程，推荐人可以通过成都万科的微信平台查询。</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">2<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）被推荐人成功购买万科购房中心所售房源且签订《商品房买卖合同》，经纪人可获得房屋最终成交推荐奖励；</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">3<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）具体推荐奖励比例，以当期公示为准。成都万科有权根据市场情况，进行推荐奖励比例的合理调整。</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">4<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）推荐人因此获得的佣金，需要按照国家相关税收法律法规的规定缴纳个人所得税。</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">5<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）“佣金收益”通过转账的方式结算，不直接支付现金。</span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">&nbsp;</p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px;\">6</span><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px; font-family: 宋体;\">、奖励结算方式：</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\">1<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）推荐成功后，推荐人需到成都万科购房中心填写推荐奖励凭据，否则不享受相应的推荐奖励。</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\">2<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）结算条件：</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\">Ø&nbsp;&nbsp;<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">推荐客户至购房中心成交，而非其他项目现场；</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\">Ø&nbsp;&nbsp;<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">被推荐人认购万科项目并签订《商品房买卖合同》。</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\">&nbsp;</p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px;\">7</span><span style=\"margin: 0px; padding: 0px; font-size: 16px; line-height: 24px; font-family: 宋体;\">、推荐关系成立，但不计算收益的情况：</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\">1<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）推荐人推荐成交的客户，如在成交后发现直系亲属（父母、配偶、子女）曾经由成都万科购房中心销售人员接待并登记（以明源的登记记录为准，登记的时间在推荐人推荐的时间之前），则此单推荐不获得收益；</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\">2<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）诚意客户有多个电话号码，其中一个电话号码（不同于推荐平台确认的电话号码）在销售现场登记过（以明源的登记记录为准，电话作为首要的认证凭证，登记的时间在推荐人推荐的时间之前），则此单推荐不获得收益；</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\">3<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）拥有多个电话号码的客户，被不同的推荐人以不同的电话号码同时推荐成功，先确定推荐关系的推荐人获得</span>100%<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">佣金收益，后推荐的推荐人不能获得收益；</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 19.5px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\">4<span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）推荐关系确立，但客户未先到访万科购房中心而是到访各项目销售现场，则此单推荐不获得收益；</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 21.059999465942383px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px;\"><span style=\"margin: 0px; padding: 0px; font-family: Calibri, sans-serif;\">5</span><span style=\"margin: 0px; padding: 0px; font-family: 宋体;\">）诚意客户认购，但最终退房，推荐人不能获得此单佣金收益；</span></span></p><p style=\"margin: 0px; padding: 0px; font-family: arial; font-size: 13px; line-height: 21.059999465942383px;\"><span style=\"margin: 0px; padding: 0px; font-size: 16px; font-family: 宋体;\">6）被推荐人经核实已通过其他第三方渠道进行过推荐，包括但不限于万客会APP、中介公司转介、行销代访等。</span></p><div><span style=\"margin: 0px; padding: 0px; font-size: 16px; font-family: 宋体;\"><br /></span></div>');
insert into `lyfz_list_c`(`id`,`field`,`val`) values('3','content','<img src=\"./upfiles/201511/15/big_25.png\" border=\"0\" alt=\"\" /><br /><img src=\"./upfiles/201511/15/big_27.png\" border=\"0\" alt=\"\" /><br /><img src=\"./upfiles/201511/15/big_26.png\" border=\"0\" alt=\"\" /><br />');
insert into `lyfz_list_c`(`id`,`field`,`val`) values('9','content','<img src=\"./upfiles/201511/10/big_20.png\" border=\"0\" alt=\"\" /><br /><img src=\"./upfiles/201511/10/big_21.png\" border=\"0\" alt=\"\" /><br /><img src=\"./upfiles/201511/10/big_22.png\" border=\"0\" alt=\"\" /><br /><img src=\"./upfiles/201511/10/big_23.png\" border=\"0\" alt=\"\" /><br />');

CREATE TABLE `lyfz_module` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `group_id` mediumint(8) unsigned NOT NULL COMMENT '组ID',
  `langid` varchar(5) NOT NULL DEFAULT 'zh' COMMENT '语言ID，默认是zh',
  `identifier` varchar(32) NOT NULL DEFAULT '0' COMMENT '标识符',
  `title` varchar(100) NOT NULL COMMENT '名称',
  `note` varchar(255) NOT NULL COMMENT '备注',
  `ctrl_init` varchar(100) NOT NULL COMMENT '执行文件，不同模块可能执行相同的文件，使用标识符区分',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0不使用1使用',
  `taxis` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT '排序值越小越往靠，最小为0',
  `if_system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1系统模块2自定义添加模块',
  `if_cate` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否启用分类功能，1使用0不使用',
  `if_biz` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否支持电子商务，0否1是',
  `if_propety` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0不支持属性，1支持',
  `if_hits` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0不持点击1支持',
  `popedom` varchar(255) NOT NULL COMMENT '权限ID，多个权限ID用英文逗号隔开',
  `if_thumb` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1支持缩略图0不支持',
  `if_thumb_m` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1必填0非必填',
  `if_point` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0不支持点数1支持点数',
  `if_url_m` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0不支持自定义网址，1支持，2支持且必填',
  `inpic` varchar(100) NOT NULL COMMENT '前台默认图片关联',
  `insearch` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支持前台搜索',
  `if_content` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0不支持读取内容1读取内容及管理员回复',
  `if_email` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1邮件通知0不通知',
  `link_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '联动ID，0为不使用联动搜索',
  `search_id` varchar(30) NOT NULL COMMENT '联动搜索的字段名',
  `psize` tinyint(3) unsigned NOT NULL DEFAULT '30' COMMENT '默认分页数量',
  `if_subtitle` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否启用副标题0否1是',
  `ico` varchar(255) NOT NULL COMMENT '图标',
  `small_pic` varchar(255) NOT NULL COMMENT '小图',
  `medium_pic` varchar(255) NOT NULL COMMENT '中图',
  `big_pic` varchar(255) NOT NULL COMMENT '大图',
  `tplset` enum('list','pic') NOT NULL DEFAULT 'list' COMMENT 'list列表，pic图文',
  `title_nickname` varchar(50) NOT NULL COMMENT '主题别称',
  `subtitle_nickname` varchar(50) NOT NULL COMMENT '副标题别称',
  `sign_nickname` varchar(50) NOT NULL COMMENT '标识串别称',
  `if_sign_m` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '标识串是否必填',
  `if_ext` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '可选扩展1使用0不使用',
  `if_des` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '简短描述1允许0不使用',
  `if_list` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1支持0不支持',
  `if_msg` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1支持0不支持',
  `layout` varchar(255) NOT NULL COMMENT '后台布局设置',
  PRIMARY KEY (`id`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('16','1','zh','module','模块管理','','ctrl','0','16','1','0','0','0','0','','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('8','1','zh','setting','网站信息','','setting','1','8','1','0','0','0','0','8','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('13','1','zh','mypass','修改密码','','mypass','1','13','1','0','0','0','0','8','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('3','3','zh','projects','项目管理','','list','1','3','0','0','0','0','1','7,3,4,5,6','1','1','0','1','','1','1','0','0','','30','0','','','','','list','','','','0','1','0','1','1','hits');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('7','4','zh','customer','推荐人管理','','customer','1','7','0','0','0','0','0','7,3','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('14','1','zh','tpl','前台风格','','tpl','0','14','0','0','0','0','0','','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('15','1','zh','lang','语言设置','','lang','0','15','0','0','0','0','0','','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('6','6','zh','user','合伙人列表','','user','1','6','0','0','0','0','0','7,3,4,5,6','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('10','1','zh','admin','超级管理','','admin','1','10','0','0','0','0','0','7,3,4,5,6','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('9','6','zh','commission','佣金明细','','commission','1','9','0','0','0','0','0','7,3,4,5,6','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('18','6','zh','commissiontx','提现管理','','commissiontx','1','10','0','0','0','0','0','7,3,4,5,6','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('2','3','zh','onepage','单页管理','','list','1','2','0','0','0','0','0','7,3,4,5,6','0','0','0','0','thumb','0','0','0','0','','30','0','','','','','list','','','','0','0','0','0','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('11','1','zh','gd','图片设置','','gd','1','11','0','0','0','0','0','7,4','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('4','3','zh','files','附件管理','','files','1','4','0','0','0','0','0','7,6','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('1','0','zh','home','后台首页','','home','1','1','0','0','0','0','0','','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('12','1','zh','phpoksql','数据备份','','phpoksql','1','12','0','0','0','0','0','7,8','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('5','6','zh','usergroup','合伙人组别','','usergroup','1','5','0','0','0','0','0','7,3,4,6','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');
insert into `lyfz_module`(`id`,`group_id`,`langid`,`identifier`,`title`,`note`,`ctrl_init`,`status`,`taxis`,`if_system`,`if_cate`,`if_biz`,`if_propety`,`if_hits`,`popedom`,`if_thumb`,`if_thumb_m`,`if_point`,`if_url_m`,`inpic`,`insearch`,`if_content`,`if_email`,`link_id`,`search_id`,`psize`,`if_subtitle`,`ico`,`small_pic`,`medium_pic`,`big_pic`,`tplset`,`title_nickname`,`subtitle_nickname`,`sign_nickname`,`if_sign_m`,`if_ext`,`if_des`,`if_list`,`if_msg`,`layout`) values('17','6','zh','excel_user','导出合伙人','','excel_user','1','17','0','0','0','0','0','7','0','0','0','0','','0','0','0','0','','30','0','','','','','list','','','','0','1','1','1','1','');

CREATE TABLE `lyfz_module_fields` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `module_id` mediumint(8) unsigned NOT NULL COMMENT '模块ID',
  `identifier` varchar(32) NOT NULL COMMENT '标识符',
  `title` varchar(100) NOT NULL COMMENT '主题',
  `if_post` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1支持会员0不支持',
  `if_guest` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1支持游客0不支持',
  `sub_left` varchar(60) NOT NULL COMMENT '左侧主题',
  `sub_note` varchar(120) NOT NULL COMMENT '右侧备注信息',
  `input` varchar(50) NOT NULL DEFAULT 'text' COMMENT '表单类型',
  `width` varchar(20) NOT NULL COMMENT '宽度',
  `height` varchar(20) NOT NULL COMMENT '高度',
  `default_val` varchar(50) NOT NULL COMMENT '默认值',
  `list_val` varchar(255) NOT NULL COMMENT '值列表',
  `link_id` int(10) NOT NULL DEFAULT '0' COMMENT '联动组ID',
  `taxis` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT '自定义排序，值越小越往前靠',
  `if_must` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1必填0非必填',
  `if_html` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1支持HTML，0不支持',
  `error_note` varchar(255) NOT NULL COMMENT '错误时的提示',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1启用0禁用',
  `if_system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1系统字段，0用户配置字段',
  `tbl` enum('ext','c') NOT NULL COMMENT 'ext指长度不大于255的表中，c指长度大于255的数据',
  `show_html` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0不显示源码1显示源码',
  `if_js` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1支持0不支持',
  `if_search` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否允许搜索',
  PRIMARY KEY (`id`),
  KEY `module_id` (`module_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
insert into `lyfz_module_fields`(`id`,`module_id`,`identifier`,`title`,`if_post`,`if_guest`,`sub_left`,`sub_note`,`input`,`width`,`height`,`default_val`,`list_val`,`link_id`,`taxis`,`if_must`,`if_html`,`error_note`,`status`,`if_system`,`tbl`,`show_html`,`if_js`,`if_search`) values('1','2','content','内容','0','0','','','edit','650px','400px','','','0','1','1','1','请输入内容','1','0','c','0','1','0');
insert into `lyfz_module_fields`(`id`,`module_id`,`identifier`,`title`,`if_post`,`if_guest`,`sub_left`,`sub_note`,`input`,`width`,`height`,`default_val`,`list_val`,`link_id`,`taxis`,`if_must`,`if_html`,`error_note`,`status`,`if_system`,`tbl`,`show_html`,`if_js`,`if_search`) values('2','3','content','内容','0','0','','','edit','650px','400px','','','0','2','0','1','请输入内容','1','0','c','0','1','0');

CREATE TABLE `lyfz_module_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `langid` varchar(32) NOT NULL DEFAULT 'zh' COMMENT '语言编号，如zh,en等',
  `title` varchar(100) NOT NULL COMMENT '组名称',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0不使用1使用',
  `taxis` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT '值越小越往靠，最小为0',
  `js_function` varchar(100) NOT NULL DEFAULT '' COMMENT 'JS控制器，为空使用系统自动生成',
  `if_system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1系统0自定义',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
insert into `lyfz_module_group`(`id`,`langid`,`title`,`status`,`taxis`,`js_function`,`if_system`) values('1','zh','核心配置','1','0','','1');
insert into `lyfz_module_group`(`id`,`langid`,`title`,`status`,`taxis`,`js_function`,`if_system`) values('2','zh','退出','1','7','logout','1');
insert into `lyfz_module_group`(`id`,`langid`,`title`,`status`,`taxis`,`js_function`,`if_system`) values('3','zh','内容管理','1','1','','1');
insert into `lyfz_module_group`(`id`,`langid`,`title`,`status`,`taxis`,`js_function`,`if_system`) values('4','zh','客户管理','1','3','','1');
insert into `lyfz_module_group`(`id`,`langid`,`title`,`status`,`taxis`,`js_function`,`if_system`) values('5','zh','网站首页','1','6','gohome','1');
insert into `lyfz_module_group`(`id`,`langid`,`title`,`status`,`taxis`,`js_function`,`if_system`) values('6','zh','经济合伙人','1','2','','0');
insert into `lyfz_module_group`(`id`,`langid`,`title`,`status`,`taxis`,`js_function`,`if_system`) values('7','zh','清空缓存','1','5','clear_cache','1');

CREATE TABLE `lyfz_session` (
  `id` varchar(32) NOT NULL COMMENT 'session_id',
  `data` text NOT NULL COMMENT 'session 内容',
  `lasttime` int(10) unsigned NOT NULL COMMENT '时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('na8easjn9haakgndeu6t7qctp4','sys_lang_id|s:2:\"zh\";user_id|i:6;user_name|s:9:\"三小二\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:9:\"三小二\";s:5:\"phone\";s:11:\"13698544748\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447494712;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:6;}','1447494712');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('9mkmj3gs4ckuje10g2l45399i1','sys_lang_id|s:2:\"zh\";phpok_login_chk|s:32:\"8af141d3c5a5146a3eac9d166ab4c458\";user_id|i:7;user_name|s:9:\"乔刘佳\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:9:\"乔刘佳\";s:5:\"phone\";s:11:\"13669511413\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447550154;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:7;}','1447550157');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('v46cohjabdieht69db2f81rlk2','sys_lang_id|s:2:\"zh\";user_id|i:4;user_name|s:6:\"张三\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:6:\"张三\";s:5:\"phone\";s:11:\"13658458758\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447492605;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:4;}admin_id|s:1:\"1\";admin_name|s:5:\"admin\";admin_realname|s:5:\"admin\";admin_md5|s:32:\"abcae11b2503110d4fb4b61d5b85137d\";','1447494132');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('mif79uroqp3jgfhc1us45lbql4','sys_lang_id|s:2:\"zh\";user_id|i:5;user_name|s:9:\"小小明\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:9:\"小小明\";s:5:\"phone\";s:11:\"13669854758\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447494161;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:5;}admin_id|s:1:\"1\";admin_name|s:5:\"admin\";admin_realname|s:5:\"admin\";admin_md5|s:32:\"abcae11b2503110d4fb4b61d5b85137d\";','1447494687');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('hco3ru8ilar6p8oit53ajlr5n4','sys_lang_id|s:2:\"zh\";user_id|s:1:\"1\";user_name|N;roup_id|s:1:\"2\";user_rs|N;:4:\"pass\";s:32:\"14e1b600b1fd579f47433b88e8d85291\";s:5:\"phone\";s:11:\"13669511419\";s:7:\"regdate\";s:10:\"1447326480\";s:6:\"status\";s:1:\"1\";s:8:\"fxstatus\";s:1:\"1\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";s:0:\"\";s:8:\"thumb_id\";s:1:\"0\";s:11:\"bankAccount\";s:0:\"\";s:8:\"cardCode\";s:0:\"\";s:8:\"bankName\";s:0:\"\";s:9:\"Recommend\";s:1:\"0\";s:13:\"RecommendName\";s:0:\"\";s:8:\"wxopenid\";s:0:\"\";s:7:\"picture\";N;}admin_id|s:1:\"1\";admin_id|s:1:\"1\";admin_name|s:5:\"admin\";admin_realname|s:5:\"admin\";admin_md5|s:32:\"abcae11b2503110d4fb4b61d5b85137d\";','1447492375');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('g4u7rc4h7r29gif00o0k97mna2','sys_lang_id|s:2:\"zh\";user_id|i:8;user_name|s:6:\"大家\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:6:\"大家\";s:5:\"phone\";s:11:\"13685455652\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447550619;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:8;}','1447551408');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('ufg1h41c22l8gg824tjiuup272','sys_lang_id|s:2:\"zh\";user_id|i:9;user_name|s:12:\"大家的要\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:12:\"大家的要\";s:5:\"phone\";s:11:\"13685455654\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447551441;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:9;}','1447551441');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('avog8t0p0bjunrgpppaaupb6r5','sys_lang_id|s:2:\"zh\";user_id|i:10;user_name|s:12:\"大家的要\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:12:\"大家的要\";s:5:\"phone\";s:11:\"13685455654\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447551469;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:10;}','1447551469');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('dtqkb0c9gd02hqojbj85a7scu5','sys_lang_id|s:2:\"zh\";user_id|i:11;user_name|s:12:\"大家的要\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:12:\"大家的要\";s:5:\"phone\";s:11:\"13685455654\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447551731;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:11;}','1447551731');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('k6fq67t8aap85e60edk3pobj80','sys_lang_id|s:2:\"zh\";user_id|i:12;user_name|s:12:\"大家的要\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:12:\"大家的要\";s:5:\"phone\";s:11:\"13685455654\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447551927;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:12;}','1447552335');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('p7lpq10i2ufc4ap87ma9sc0uq4','sys_lang_id|s:2:\"zh\";user_id|i:13;user_name|s:12:\"大家的要\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:12:\"大家的要\";s:5:\"phone\";s:11:\"13685455654\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447552342;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:13;}admin_id|s:1:\"1\";admin_name|s:5:\"admin\";admin_realname|s:5:\"admin\";admin_md5|s:32:\"abcae11b2503110d4fb4b61d5b85137d\";','1447552465');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('h6dtgo2al6u618c07sfid0oek3','sys_lang_id|s:2:\"zh\";user_id|i:14;user_name|s:6:\"需要\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:6:\"需要\";s:5:\"phone\";s:11:\"13698545652\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447552608;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:14;}','1447552611');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('qhlll8qi8e1m01l9so7thbmop1','sys_lang_id|s:2:\"zh\";user_id|i:15;user_name|s:6:\"丰城\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:6:\"丰城\";s:5:\"phone\";s:11:\"13487565485\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447552705;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:15;}','1447552735');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('rhfhmlajgktsfhv6nj2a811gc0','sys_lang_id|s:2:\"zh\";user_id|i:16;user_name|s:12:\"一大规模\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:12:\"一大规模\";s:5:\"phone\";s:11:\"13586996856\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447552757;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:16;}admin_id|s:1:\"1\";admin_name|s:5:\"admin\";admin_realname|s:5:\"admin\";admin_md5|s:32:\"abcae11b2503110d4fb4b61d5b85137d\";','1447555499');
insert into `lyfz_session`(`id`,`data`,`lasttime`) values('ttgla0d2ciu7h84parr5da2rj1','sys_lang_id|s:2:\"zh\";user_id|i:17;user_name|s:6:\"对非\";group_id|s:1:\"2\";user_rs|a:10:{s:8:\"username\";s:6:\"对非\";s:5:\"phone\";s:11:\"13695869586\";s:3:\"job\";s:4:\"WXFS\";s:7:\"company\";b:0;s:8:\"wxopenid\";N;s:4:\"pass\";s:32:\"be83f61bd04b549bc355a38a8c0fd6c5\";s:7:\"regdate\";i:1447555695;s:6:\"status\";i:1;s:7:\"groupid\";s:1:\"2\";s:2:\"id\";i:17;}phpok_login_chk|s:32:\"151e50feaf21b61cf23e0b944abebe28\";','1447574180');

CREATE TABLE `lyfz_tpl` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID号',
  `langid` varchar(5) NOT NULL DEFAULT 'zh' COMMENT '语言ID，默认是zh',
  `title` varchar(100) NOT NULL COMMENT '名称',
  `folder` varchar(50) NOT NULL COMMENT '文件夹',
  `ext` varchar(10) NOT NULL DEFAULT 'html' COMMENT '模板后缀',
  `autoimg` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否自动解析图片地址',
  `ifdefault` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否默认',
  `ifsystem` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1系统模板0用户模板',
  `taxis` tinyint(3) unsigned NOT NULL DEFAULT '255' COMMENT '排序',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '1正在使用0未使用',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
insert into `lyfz_tpl`(`id`,`langid`,`title`,`folder`,`ext`,`autoimg`,`ifdefault`,`ifsystem`,`taxis`,`status`) values('1','zh','前台默认风格','www','html','1','1','0','1','1');

CREATE TABLE `lyfz_upfiles` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '图片ID',
  `title` varchar(100) NOT NULL COMMENT '标题',
  `filename` varchar(255) NOT NULL COMMENT '图片路径，基于网站根目录的相对路径',
  `thumb` varchar(255) NOT NULL COMMENT '缩略图路径，基于网站根目录的相对路径',
  `postdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传时间',
  `ftype` varchar(10) NOT NULL COMMENT '附件类型',
  `uid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID号，0表示管理员上传',
  `flv_pic` varchar(255) NOT NULL COMMENT 'FLV封面图片',
  `sessid` varchar(50) NOT NULL COMMENT '游客上传标识串',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
insert into `lyfz_upfiles`(`id`,`title`,`filename`,`thumb`,`postdate`,`ftype`,`uid`,`flv_pic`,`sessid`) values('26','w-1-03.png','upfiles/201511/15/77382e5dfa169474.png','upfiles/201511/15/thumb26.png','1447553802','png','0','','');
insert into `lyfz_upfiles`(`id`,`title`,`filename`,`thumb`,`postdate`,`ftype`,`uid`,`flv_pic`,`sessid`) values('8','微信分享图标','upfiles/201409/21/e0b6a40a8fd833a6.jpg','upfiles/201409/21/thumb8.jpg','1411274455','jpg','0','','');
insert into `lyfz_upfiles`(`id`,`title`,`filename`,`thumb`,`postdate`,`ftype`,`uid`,`flv_pic`,`sessid`) values('25','w-1-02.png','upfiles/201511/15/909ca29823ac4c2d.png','upfiles/201511/15/thumb25.png','1447553801','png','0','','');
insert into `lyfz_upfiles`(`id`,`title`,`filename`,`thumb`,`postdate`,`ftype`,`uid`,`flv_pic`,`sessid`) values('20','婚纱摄影活动1-01.png','upfiles/201511/10/329b75d902afe407.png','upfiles/201511/10/thumb20.png','1447142563','png','0','','');
insert into `lyfz_upfiles`(`id`,`title`,`filename`,`thumb`,`postdate`,`ftype`,`uid`,`flv_pic`,`sessid`) values('21','婚纱摄影活动1-02.png','upfiles/201511/10/7a07f5bcebd912d8.png','upfiles/201511/10/thumb21.png','1447142563','png','0','','');
insert into `lyfz_upfiles`(`id`,`title`,`filename`,`thumb`,`postdate`,`ftype`,`uid`,`flv_pic`,`sessid`) values('22','婚纱摄影活动1-03.png','upfiles/201511/10/26753a34f44faecb.png','upfiles/201511/10/thumb22.png','1447142564','png','0','','');
insert into `lyfz_upfiles`(`id`,`title`,`filename`,`thumb`,`postdate`,`ftype`,`uid`,`flv_pic`,`sessid`) values('23','婚纱摄影活动1-04.png','upfiles/201511/10/97688a4fead67417.png','upfiles/201511/10/thumb23.png','1447142564','png','0','','');
insert into `lyfz_upfiles`(`id`,`title`,`filename`,`thumb`,`postdate`,`ftype`,`uid`,`flv_pic`,`sessid`) values('24','婚纱摄影活动1-展示首页-01.png','upfiles/201511/10/6067e8ca5642035a.png','upfiles/201511/10/thumb24.png','1447142564','png','0','','');
insert into `lyfz_upfiles`(`id`,`title`,`filename`,`thumb`,`postdate`,`ftype`,`uid`,`flv_pic`,`sessid`) values('18','53d5ed7d93bce.jpg','upfiles/201511/10/93e444ea94ccb0f2.jpg','upfiles/201511/10/thumb18.jpg','1447142562','jpg','0','','');
insert into `lyfz_upfiles`(`id`,`title`,`filename`,`thumb`,`postdate`,`ftype`,`uid`,`flv_pic`,`sessid`) values('27','w-1-04.png','upfiles/201511/15/edd0f432f57f0a0f.png','upfiles/201511/15/thumb27.png','1447553802','png','0','','');

CREATE TABLE `lyfz_upfiles_gd` (
  `pid` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '图片ID，对应upfiles里的ID',
  `gdtype` varchar(100) NOT NULL COMMENT '图片类型',
  `filename` varchar(255) NOT NULL COMMENT '图片地址（生成类型的图片地址）',
  PRIMARY KEY (`pid`,`gdtype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('25','mid','upfiles/201511/15/mid_25.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('26','thumb','upfiles/201511/15/thumb_26.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('8','thumb','upfiles/201409/21/thumb_8.jpg');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('8','big','upfiles/201409/21/big_8.jpg');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('8','mid','upfiles/201409/21/mid_8.jpg');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('24','big','upfiles/201511/10/big_24.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('24','thumb','upfiles/201511/10/thumb_24.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('18','mid','upfiles/201511/10/mid_18.jpg');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('25','thumb','upfiles/201511/15/thumb_25.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('23','mid','upfiles/201511/10/mid_23.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('23','big','upfiles/201511/10/big_23.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('23','thumb','upfiles/201511/10/thumb_23.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('22','mid','upfiles/201511/10/mid_22.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('22','big','upfiles/201511/10/big_22.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('22','thumb','upfiles/201511/10/thumb_22.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('21','mid','upfiles/201511/10/mid_21.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('21','big','upfiles/201511/10/big_21.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('20','big','upfiles/201511/10/big_20.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('20','mid','upfiles/201511/10/mid_20.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('21','thumb','upfiles/201511/10/thumb_21.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('20','thumb','upfiles/201511/10/thumb_20.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('25','big','upfiles/201511/15/big_25.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('18','thumb','upfiles/201511/10/thumb_18.jpg');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('18','big','upfiles/201511/10/big_18.jpg');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('26','big','upfiles/201511/15/big_26.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('26','mid','upfiles/201511/15/mid_26.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('27','thumb','upfiles/201511/15/thumb_27.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('27','big','upfiles/201511/15/big_27.png');
insert into `lyfz_upfiles_gd`(`pid`,`gdtype`,`filename`) values('27','mid','upfiles/201511/15/mid_27.png');

CREATE TABLE `lyfz_user` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `groupid` mediumint(8) unsigned NOT NULL DEFAULT '1' COMMENT '会员组ID',
  `username` varchar(100) NOT NULL COMMENT '会员名称',
  `pass` varchar(50) NOT NULL COMMENT '密码',
  `phone` varchar(100) NOT NULL COMMENT '手机',
  `regdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态1已审核0未审核2锁定',
  `fxstatus` tinyint(1) NOT NULL,
  `job` varchar(150) NOT NULL,
  `company` varchar(20) NOT NULL,
  `thumb_id` int(10) unsigned NOT NULL COMMENT '个性头像ID',
  `bankAccount` varchar(100) NOT NULL,
  `cardCode` varchar(100) NOT NULL,
  `bankName` varchar(100) NOT NULL,
  `Recommend` int(10) unsigned DEFAULT '0' COMMENT '推荐人ID',
  `RecommendName` varchar(100) DEFAULT '' COMMENT '推荐人姓名',
  `wxopenid` varchar(100) DEFAULT '' COMMENT '微信Opneid',
  `wxthumb` varchar(800) DEFAULT '' COMMENT '微信头像',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('1','2','刘超','14e1b600b1fd579f47433b88e8d85291','13669511419','1447326480','1','1','WXFS','','0','','','','0','','','');
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('2','2','张三','14e1b600b1fd579f47433b88e8d85291','13669511417','1447383180','0','1','WXFS','','0','','','','1','刘超','','');
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('3','2','李四','14e1b600b1fd579f47433b88e8d85291','13669511416','1447383180','0','1','WXFS','','0','','','','2','张三','','');
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('4','2','张三','be83f61bd04b549bc355a38a8c0fd6c5','13658458758','1447492605','1','0','WXFS','','0','','','','0','','','');
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('5','2','小小明','be83f61bd04b549bc355a38a8c0fd6c5','13669854758','1447494161','1','0','WXFS','','0','','','','0','','','');
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('6','2','三小二','be83f61bd04b549bc355a38a8c0fd6c5','13698544748','1447494712','1','0','WXFS','','0','','','','0','','','');
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('7','2','乔刘佳','be83f61bd04b549bc355a38a8c0fd6c5','13669511413','1447550154','1','0','WXFS','','0','','','','0','','','');
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('8','2','大家','be83f61bd04b549bc355a38a8c0fd6c5','13685455652','1447550619','1','0','WXFS','','0','','','','0','','','');
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('13','2','大家的要','be83f61bd04b549bc355a38a8c0fd6c5','13685455654','1447552342','1','0','WXFS','','0','','','','0','','','');
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('14','2','需要','be83f61bd04b549bc355a38a8c0fd6c5','13698545652','1447552608','1','0','WXFS','','0','','','','0','','','');
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('15','2','丰城','be83f61bd04b549bc355a38a8c0fd6c5','13487565485','1447552705','1','0','WXFS','','0','','','','0','','','');
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('16','2','一大规模','be83f61bd04b549bc355a38a8c0fd6c5','13586996856','1447552757','1','0','WXFS','','0','','','','0','','','');
insert into `lyfz_user`(`id`,`groupid`,`username`,`pass`,`phone`,`regdate`,`status`,`fxstatus`,`job`,`company`,`thumb_id`,`bankAccount`,`cardCode`,`bankName`,`Recommend`,`RecommendName`,`wxopenid`,`wxthumb`) values('17','2','对非','be83f61bd04b549bc355a38a8c0fd6c5','13695869586','1447555695','1','0','WXFS','','0','','','','0','','','');

CREATE TABLE `lyfz_user_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '会员组ID',
  `group_type` enum('user','guest') NOT NULL DEFAULT 'user' COMMENT '用户组类型',
  `title` varchar(100) NOT NULL COMMENT '组名称',
  `popedom_post` text NOT NULL COMMENT '发布权限',
  `popedom_reply` text NOT NULL COMMENT '回复权限',
  `popedom_read` text NOT NULL COMMENT '阅读权限，默认为all',
  `post_cert` tinyint(1) NOT NULL DEFAULT '0' COMMENT '发布0需要验证1免验证',
  `reply_cert` tinyint(1) NOT NULL DEFAULT '0' COMMENT '回复0需要验证1免验证',
  `ifsystem` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否系统组0否1是',
  `ifdefault` tinyint(1) NOT NULL DEFAULT '0' COMMENT '会员注册后默认选择的组',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
insert into `lyfz_user_group`(`id`,`group_type`,`title`,`popedom_post`,`popedom_reply`,`popedom_read`,`post_cert`,`reply_cert`,`ifsystem`,`ifdefault`) values('1','guest','游客','','','all','0','0','1','1');
insert into `lyfz_user_group`(`id`,`group_type`,`title`,`popedom_post`,`popedom_reply`,`popedom_read`,`post_cert`,`reply_cert`,`ifsystem`,`ifdefault`) values('2','user','初级合伙人','','','all','1','0','1','1');
insert into `lyfz_user_group`(`id`,`group_type`,`title`,`popedom_post`,`popedom_reply`,`popedom_read`,`post_cert`,`reply_cert`,`ifsystem`,`ifdefault`) values('3','user','金牌合伙人','','','','0','0','0','0');

