/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('MSG_TEMPLATE','【证件号】','CRED_NUM',NULL,'1',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('MSG_TEMPLATE','【客户姓名】','CST_NAME',NULL,'1',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('MSG_TEMPLATE','【EMAIL】','EMAIL',NULL,'1',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('MSG_TEMPLATE','【客户姓名_姓】','FIRST_NAME',NULL,'1',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('MSG_TEMPLATE','【名】','LAST_NAME',NULL,'1',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('MSG_TEMPLATE','【手机号】','PHONE',NULL,'1',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('RATED','当前是否注册入会','IS_MEMBER','','1','','',CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('RATED','当前是否身份认证','IS_VERIFY','','1','','',CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('RATED','当前积点余额-【消费积分】','NOW_POINTS_CONSUME','','0','','',CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('RATED','单次消费金额','PER_AMOUNT','','0','','',CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('RATED','期间累计消费金额','TOTAL_AMOUNT','','0','','',CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('RATED','期间累计积点增加-【消费积分】','TOTAL_POINTS_CONSUME','','0','','',CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('RATED','期间累计消费次数','TOTAL_TIMES','','0','','',CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('TAG_CONSUME','平均消费单价','AVG_AMOUNT',NULL,'0',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('TAG_CONSUME','平均加权消费折数','AVG_WEIGHTED_DISCOUNT',NULL,'0',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('TAG_CONSUME','最高消费单价','MAX_AMOUNT',NULL,'0',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('TAG_CONSUME','单次消费金额','ONCE_AMOUNT',NULL,'0',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('TAG_CONSUME','累计消费金额','TOTAL_AMOUNT',NULL,'0',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('TAG_CONSUME','累计消费次数','TOTAL_TIMES',NULL,'0',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('TAG_PROPERTY','【是否激活】','ACTIVATE',NULL,'1',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('TAG_PROPERTY','【出生日期】','BIRTHDAY',NULL,'0',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('TAG_PROPERTY','【是否冻结】','FREEZE',NULL,'1',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('TAG_PROPERTY','【入会日期】','REG_TIME',NULL,'0',NULL,NULL,CURRENT_TIMESTAMP);
replace  into `crm_condition_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_OPERATOR`,`VAL_TYPE`,`VAL_OPTIONS`,`VAL_VALID`,`REC_TIME`) values ('TAG_PROPERTY','【是否认证】','VERIFY',NULL,'1',NULL,NULL,CURRENT_TIMESTAMP);





replace into `crm_event` (`EVT_ID`, `EVT_CODE`, `EVT_NAME`, `EVT_DESC`, `GLOBAL`, `INTERNAL`, `REC_TIME`, `REC_USER`) values('1','E000000001','关注','指成功关注本CRM帐套所属微信公众号的事件；','0','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_event` (`EVT_ID`, `EVT_CODE`, `EVT_NAME`, `EVT_DESC`, `GLOBAL`, `INTERNAL`, `REC_TIME`, `REC_USER`) values('2','E000000002','注册入会','指从本CRM帐套新入会成功的事件（包括从本CRM账套所属微信公众号申请入会或者自动绑定成功其它CRM帐套的会员）；','1','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_event` (`EVT_ID`, `EVT_CODE`, `EVT_NAME`, `EVT_DESC`, `GLOBAL`, `INTERNAL`, `REC_TIME`, `REC_USER`) values('3','E000000003','激活老会员','指从本CRM帐套下属顾客移动平台或POS平台或雇员移动平台，通过顾客入会输入手机，成功匹配到本CRM帐套的、未激活的、未冻结的会员信息（已导入系统的未激活的老会员信息），从而自动激活并把顾客当前识别号（如果是微信平台就会有OPENID）绑定到该老会员的事件；','1','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_event` (`EVT_ID`, `EVT_CODE`, `EVT_NAME`, `EVT_DESC`, `GLOBAL`, `INTERNAL`, `REC_TIME`, `REC_USER`) values('4','E000000004','绑定会员','指从本CRM帐套下属顾客移动平台，通过申请入会输入手机，成功匹配到本CRM帐套的、已激活的、未冻结的会员信息，把顾客当前识别号（如OPEN ID）绑定到该会员的事件；','1','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_event` (`EVT_ID`, `EVT_CODE`, `EVT_NAME`, `EVT_DESC`, `GLOBAL`, `INTERNAL`, `REC_TIME`, `REC_USER`) values('5','E000000005','评价商品','指顾客通过顾客移动平台等评价商品成功的事件；','1','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_event` (`EVT_ID`, `EVT_CODE`, `EVT_NAME`, `EVT_DESC`, `GLOBAL`, `INTERNAL`, `REC_TIME`, `REC_USER`) values('6','E000000006','升级',NULL,'1','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_event` (`EVT_ID`, `EVT_CODE`, `EVT_NAME`, `EVT_DESC`, `GLOBAL`, `INTERNAL`, `REC_TIME`, `REC_USER`) values('7','E000000007','消费','指当前CRM帐套所属网点的零售销售单、零售订单、订金订单、零售退货单、订单取消、订单退货事件；','0','1',CURRENT_TIMESTAMP,NULL);
replace  into `crm_event`(`EVT_ID`,`EVT_CODE`,`EVT_NAME`,`EVT_DESC`,`GLOBAL`,`INTERNAL`,`REC_TIME`,`REC_USER`) values (8,'E000000008','发帖',NULL,1,0,CURRENT_TIMESTAMP,NULL);
replace  into `crm_event`(`EVT_ID`,`EVT_CODE`,`EVT_NAME`,`EVT_DESC`,`GLOBAL`,`INTERNAL`,`REC_TIME`,`REC_USER`) values (9,'E000000009','评论',NULL,1,0,CURRENT_TIMESTAMP,NULL);
replace  into `crm_event`(`EVT_ID`,`EVT_CODE`,`EVT_NAME`,`EVT_DESC`,`GLOBAL`,`INTERNAL`,`REC_TIME`,`REC_USER`) values (10,'E000000010','点赞',NULL,1,0,CURRENT_TIMESTAMP,NULL);
replace  into `crm_event`(`EVT_ID`,`EVT_CODE`,`EVT_NAME`,`EVT_DESC`,`GLOBAL`,`INTERNAL`,`REC_TIME`,`REC_USER`) values (11,'E000000011','收藏',NULL,1,0,CURRENT_TIMESTAMP,NULL);
replace  into `crm_event`(`EVT_ID`,`EVT_CODE`,`EVT_NAME`,`EVT_DESC`,`GLOBAL`,`INTERNAL`,`REC_TIME`,`REC_USER`) values (12,'E000000012','分享',NULL,1,0,CURRENT_TIMESTAMP,NULL);
replace  into `crm_event`(`EVT_ID`,`EVT_CODE`,`EVT_NAME`,`EVT_DESC`,`GLOBAL`,`INTERNAL`,`REC_TIME`,`REC_USER`) values (13,'E000000013','回复评论',NULL,1,0,CURRENT_TIMESTAMP,NULL);
replace  into `crm_event`(`EVT_ID`,`EVT_CODE`,`EVT_NAME`,`EVT_DESC`,`GLOBAL`,`INTERNAL`,`REC_TIME`,`REC_USER`) values (14,'E000000014','评论点赞',NULL,1,0,CURRENT_TIMESTAMP,NULL);



replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (1,1,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (2,2,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (3,3,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (4,4,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (5,5,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (6,6,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (7,7,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (7,8,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (7,9,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (8,10,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (9,11,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (10,12,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (11,13,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (12,14,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (13,15,'POINTS');
replace  into `crm_event_action`(`EVT_ID`,`ACTION`,`SCOPE`) values (14,16,'POINTS');




replace into `crm_event_action_process` (`UNION_ID`, `ACTION`, `TEMPLATE`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`) values('1','1','1','0','cn.runsa.crmapp.points.event.SubscribeEventPointsProcessor',NULL,'0','cn.runsa.crmapp.points.event.SubcribeEventPointsParser',NULL);
replace into `crm_event_action_process` (`UNION_ID`, `ACTION`, `TEMPLATE`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`) values('2','2','2','0','cn.runsa.crmapp.points.event.RegisterEventPointsProcessor',NULL,'0','cn.runsa.crmapp.points.event.SimpleEventPointsParser',NULL);
replace into `crm_event_action_process` (`UNION_ID`, `ACTION`, `TEMPLATE`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`) values('3','3','3','0','cn.runsa.crmapp.points.event.ActivateEventPointsProcessor',NULL,'0','cn.runsa.crmapp.points.event.RatedEventPointsParser',NULL);
replace into `crm_event_action_process` (`UNION_ID`, `ACTION`, `TEMPLATE`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`) values('4','4','3','0','cn.runsa.crmapp.points.event.BindedEventPointsProcessor',NULL,'0','cn.runsa.crmapp.points.event.RatedEventPointsParser',NULL);
replace into `crm_event_action_process` (`UNION_ID`, `ACTION`, `TEMPLATE`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`) values('5','5','4','0','0',NULL,'0','0',NULL);
replace into `crm_event_action_process` (`UNION_ID`, `ACTION`, `TEMPLATE`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`) values('6','6','5','0','0',NULL,'0','0',NULL);
replace into `crm_event_action_process` (`UNION_ID`, `ACTION`, `TEMPLATE`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`) values('7','7','6','0','cn.runsa.crmapp.points.event.ScaleConsumeEventPointsProcessor',NULL,'0','cn.runsa.crmapp.points.event.ScaleConsumeEventPointsParser',NULL);
replace into `crm_event_action_process` (`UNION_ID`, `ACTION`, `TEMPLATE`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`) values('8','8','7','0','cn.runsa.crmapp.points.event.RatedAmountSegEventPointsProcessor',NULL,'0','cn.runsa.crmapp.points.event.RatedSegmentEventPointsParser',NULL);
replace into `crm_event_action_process` (`UNION_ID`, `ACTION`, `TEMPLATE`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`) values('9','9','8','0','cn.runsa.crmapp.points.event.RatedDiscountSegEventPointsProcessor',NULL,'0','cn.runsa.crmapp.points.event.RatedSegmentEventPointsParser',NULL);



replace into `crm_event_template` (`TPL_ID`, `TPL_NAME`, `TPL_DESC`) values('1','一次性可撤销事件积点模板',NULL);
replace into `crm_event_template` (`TPL_ID`, `TPL_NAME`, `TPL_DESC`) values('2','一次性不可撤销事件积点模板',NULL);
replace into `crm_event_template` (`TPL_ID`, `TPL_NAME`, `TPL_DESC`) values('3','一次性不可撤销事件分顾客等级积点模板',NULL);
replace into `crm_event_template` (`TPL_ID`, `TPL_NAME`, `TPL_DESC`) values('4','多次性事件计次积点模板',NULL);
replace into `crm_event_template` (`TPL_ID`, `TPL_NAME`, `TPL_DESC`) values('5','顾客评级升级积点模板',NULL);
replace into `crm_event_template` (`TPL_ID`, `TPL_NAME`, `TPL_DESC`) values('6','单一比例消费积点模板',NULL);
replace into `crm_event_template` (`TPL_ID`, `TPL_NAME`, `TPL_DESC`) values('7','顾客等级+金额段消费积点模板',NULL);
replace into `crm_event_template` (`TPL_ID`, `TPL_NAME`, `TPL_DESC`) values('8','顾客等级+折数段消费积点模板',NULL);



replace  into `crm_field`(`FLD_SCOPE`,`FLD_NAME`,`FLD_SQL`,`FLD_TYPE`,`FLD_DESC`,`USE_NEW`,`USE_MOD`,`REQ_NEW`,`REQ_MOD`,`IS_SYSTEM`,`FLD_INDEX`,`FLD_OPTIONS`,`FLD_VALID`,`REC_TIME`,`REC_USER`) values ('MEMBER','出生日期','birthday','_date','出生日期',1,1,1,0,0,6,NULL,'{\"dateType\":\"date\",\"eTime\":\"now\"}',CURRENT_TIMESTAMP,NULL),('MEMBER','证件号','credNum','_char','证件号',1,1,0,0,0,7,NULL,NULL,CURRENT_TIMESTAMP,NULL),('MEMBER','会员名','cstName','_char','会员名称',1,1,0,0,0,1,NULL,'{\"minLen\":\"0\",\"maxLen\":\"64\"}',CURRENT_TIMESTAMP,NULL),('MEMBER','学历','degree','_select','学历',1,1,0,0,0,8,'[{\"value\" : \"小学\", \"text\" : \"小学\"}, {\"value\" : \"初中\", \"text\" : \"初中\"}, {\"value\" : \"高中\", \"text\" : \"高中\"}, {\"value\" : \"中专\", \"text\" : \"中专\"}, {\"value\" : \"大专\", \"text\" : \"大专\"}, {\"value\" : \"本科\", \"text\" : \"本科\"}, {\"value\" : \"硕士\", \"text\" : \"硕士\"}, {\"value\" : \"博士\", \"text\" : \"博士\"}]',NULL,CURRENT_TIMESTAMP,NULL),('MEMBER','邮箱','email','_char','邮箱',1,1,0,0,0,5,NULL,'{\"minLen\":\"0\",\"maxLen\":\"128\",\"pattern\":\"^(\\\\w)+(\\\\.\\\\w+)*@(\\\\w)+((\\\\.\\\\w+)+)$\"}',CURRENT_TIMESTAMP,NULL),('MEMBER','婚否','marriage','_select','婚否',1,1,0,0,0,10,'[{\"value\" : 0, \"text\" : \"未婚\"}, {\"value\" : 1, \"text\" : \"已婚\"},{\"value\" : 2, \"text\" : \"保密\"}]',NULL,CURRENT_TIMESTAMP,NULL),('MEMBER','支付密码','payPass','_passwd','支付密码',1,1,0,0,0,11,NULL,'{\"maxLen\":\"32\",\"pattern\":\"^[\\\\d\\\\w_]{8,32}$\"}',CURRENT_TIMESTAMP,NULL),('MEMBER','手机','phone','_num','手机',1,1,1,0,0,4,NULL,'{\"pattern\":\"^1(3|5|7|8){1}\\\\d{9}$\"}',CURRENT_TIMESTAMP,NULL),('MEMBER','接收消息','rcvMsg','_radio',NULL,1,1,1,0,0,13,'[{\"value\" : 1, \"text\" : \"是\"},{\"value\" : 0, \"text\" : \"否\"}]',NULL,CURRENT_TIMESTAMP,NULL),('MEMBER','真实姓名','realName','_char','真实姓名',1,1,1,0,0,2,NULL,NULL,CURRENT_TIMESTAMP,NULL),('MEMBER','推荐人','referPhone','_num','推荐人手机号',1,1,0,0,0,12,NULL,'{\"pattern\":\"^1(3|5|7|8){1}\\\\d{9}$\"}',CURRENT_TIMESTAMP,NULL),('MEMBER','性别','sex','_select','性别',1,1,1,0,0,3,'[{\"value\" : 1, \"text\" : \"男\"}, {\"value\" : 0, \"text\" : \"女\"}, {\"value\" : 2, \"text\" : \"保密\"}]\r\n',NULL,CURRENT_TIMESTAMP,NULL);



replace  into `crm_points_type`(`PNT_TYPE`,`PNT_NAME`,`PNT_DESC`,`IS_SYSTEM`,`IS_DEFAULT`,`REC_TIME`,`REC_USER`) values ('CONSUME','消费积分','消费积分',1,0,CURRENT_TIMESTAMP,NULL);



insert ignore into `crm_sequence` (`SEQ_NAME`, `CUR_VAL`, `INCRE`) values('ACT','10000','1');
insert ignore into `crm_sequence` (`SEQ_NAME`, `CUR_VAL`, `INCRE`) values('CPN','10000','1');
insert ignore into `crm_sequence` (`SEQ_NAME`, `CUR_VAL`, `INCRE`) values('DOCS','10000','1');



replace into `crm_template` (`TPL_ID`, `SCOPE`, `TPL_DESC`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`, `REC_TIME`) values('CST_AUTO_TAG_001','CUST_AUTO_TAG','顾客自动标签','0','cn.runsa.crmapp.customer.tag.CustomerTagExecutor',NULL,'0','cn.runsa.crmapp.customer.tag.CustomerTagParser',NULL,CURRENT_TIMESTAMP);
replace into `crm_template` (`TPL_ID`, `SCOPE`, `TPL_DESC`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`, `REC_TIME`) values('CST_RNK_DW_001','RANK_DEGRADE','顾客降级','0','cn.runsa.crmapp.points.rank.SimpleDegradeExecutor',NULL,'0','cn.runsa.crmapp.points.rank.SimpleDegradeParser',NULL,CURRENT_TIMESTAMP);
replace into `crm_template` (`TPL_ID`, `SCOPE`, `TPL_DESC`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`, `REC_TIME`) values('CST_RNK_RATE_001','RANK_RATE','顾客评级','0','cn.runsa.crmapp.points.rank.CustomerRelegationExecutor',NULL,'0','cn.runsa.crmapp.points.rank.CustomerRelegationParser',NULL,CURRENT_TIMESTAMP);
replace into `crm_template` (`TPL_ID`, `SCOPE`, `TPL_DESC`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`, `REC_TIME`) values('CST_RNK_UP_001','RANK_UPGRADE','顾客升级','0','cn.runsa.crmapp.points.rank.SimpleUpgradeExecutor',NULL,'0','cn.runsa.crmapp.points.rank.SimpleUpgradeParser',NULL,CURRENT_TIMESTAMP);
replace into `crm_template` (`TPL_ID`, `SCOPE`, `TPL_DESC`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`, `REC_TIME`) values('CST_TPL_TAG_001','CST_TPL_TAG','商品特征喜好标签','0','cn.runsa.crmapp.customer.tag.CustomerTagExecutor',NULL,'0','cn.runsa.crmapp.customer.tag.CustomerTagPopularBrandParser',NULL,CURRENT_TIMESTAMP);
replace into `crm_template` (`TPL_ID`, `SCOPE`, `TPL_DESC`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`, `REC_TIME`) values('CST_TPL_TAG_002','CST_TPL_TAG','RFM标签','0','cn.runsa.crmapp.customer.tag.CustomerTagExecutor',NULL,'0','cn.runsa.crmapp.customer.tag.CustomerTagRFMParser',NULL,CURRENT_TIMESTAMP);
replace into `crm_template` (`TPL_ID`, `SCOPE`, `TPL_DESC`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`, `REC_TIME`) values('PNT_CSH_001','POINTS_CASH','不允许','0',NULL,NULL,'0','cn.runsa.crmapp.points.policy.cash.PointsCashNonsupportParser',NULL,CURRENT_TIMESTAMP);
replace into `crm_template` (`TPL_ID`, `SCOPE`, `TPL_DESC`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`, `REC_TIME`) values('PNT_CSH_002','POINTS_CASH','折扣限制','0',NULL,NULL,'0','cn.runsa.crmapp.points.policy.cash.PointsCashDiscountConditionParser',NULL,CURRENT_TIMESTAMP);
replace into `crm_template` (`TPL_ID`, `SCOPE`, `TPL_DESC`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`, `REC_TIME`) values('PNT_EXP_001','POINTS_EXPIRY','无限期','0','cn.runsa.crmapp.points.policy.expiration.PointsExpiryNeverExecutor',NULL,'0','cn.runsa.crmapp.points.policy.expiration.PointsExpiryNeverParser',NULL,CURRENT_TIMESTAMP);
replace into `crm_template` (`TPL_ID`, `SCOPE`, `TPL_DESC`, `EXE_TYPE`, `EXE_NAME`, `EXECUTER`, `PSR_TYPE`, `PSR_NAME`, `PARSER`, `REC_TIME`) values('PNT_EXP_002','POINTS_EXPIRY','从产生之日起*天','0','cn.runsa.crmapp.points.policy.expiration.PointsExpiryFromProduceExecutor',NULL,'0','cn.runsa.crmapp.points.policy.expiration.PointsExpiryFromProduceParser',NULL,CURRENT_TIMESTAMP);




replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CH_STATUS','1','待审批','待审批','0',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CH_STATUS','2','通过','通过','0',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CH_STATUS','3','驳回','驳回','0',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CH_TYPE','1','券发行','券发行','0',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CH_TYPE','2','雇员发券','雇员发券','0',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('COUPON_TYPE','0','折扣券','折扣券','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('COUPON_TYPE','1','金额券','金额券','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('COUPON_TYPE','2','礼品券','礼品券','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('COUPON_TYPE','3','定价券','定价券','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('COUPON_USE','ORDER','销售订单','销售订单','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CUSTOMER_CHANNEL','OFFLINE','线下','线下','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CUSTOMER_CHANNEL','WEIXIN','微信','微信','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CUSTOMER_SOURCE','ACT','活动','顾客来源渠道：活动','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CUSTOMER_SOURCE','CPN','优惠券','顾客来源渠道：优惠券','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CUSTOMER_SOURCE','CST','推荐顾客','顾客来源渠道：推荐顾客','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CUSTOMER_SOURCE','EMP','推荐雇员','顾客来源渠道：推荐雇员','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CUSTOMER_SOURCE','EXP','物流单','顾客来源渠道：物流单','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CUSTOMER_SOURCE','GDS','商品','顾客来源渠道：商品','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CUSTOMER_SOURCE','GZH','搜索公众号','顾客来源渠道：搜索公众号','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('CUSTOMER_SOURCE','SIT','网点','顾客来源渠道：网点','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('ORDER_RECEIPT','COUPON','优惠券','优惠券','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('ORDER_RECEIPT','POINTS','积分','积分','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_CHL','ACTIVITY','活动','活动','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_CHL','INTERFACE','接口','接口','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_CHL','EVENT','事件','事件','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_CHL','BEGINING','期初剩余积分','期初剩余积分','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_CHL','MANUAL','手动调整','手动调整积分','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_CHL','ORDER','销售订单','销售订单','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_TYPE','ADJ_MAN','积分调整','后台积分调整','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_TYPE','BIRTHDAY','生日送积分','生日送积分','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_TYPE','IMPORT','导入积分','导入积分','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_TYPE','saledx','积分抵现','积分抵现','0',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_TYPE','EVENT','事件积分','事件积分','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_TYPE','CLEAR','积分清理','积分清理','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_TYPE','CRMJFIN','消费','消费','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('POINTS_CHANGE_TYPE','CRMJFOT','退换货','退换货','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('TAG_TYPE','0','手动标签','手动标签','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('TAG_TYPE','1','条件标签','条件标签','1',CURRENT_TIMESTAMP,NULL);
replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) values('TAG_TYPE','2','模板标签','模板标签','1',CURRENT_TIMESTAMP,NULL);
replace  into `crm_variable`(`VAR_SCOPE`,`VAR_CODE`,`VAR_NAME`,`VAR_DESC`,`VAR_SYSTEM`,`REC_TIME`,`REC_USER`) values ('CUSTOMER_SOURCE','APP','APP',NULL,0,CURRENT_TIMESTAMP,NULL);
replace  into `crm_variable`(`VAR_SCOPE`,`VAR_CODE`,`VAR_NAME`,`VAR_DESC`,`VAR_SYSTEM`,`REC_TIME`,`REC_USER`) values ('POINTS_CHANGE_TYPE','sale','销售订单','销售订单',0,CURRENT_TIMESTAMP,NULL);
replace  into `crm_variable`(`VAR_SCOPE`,`VAR_CODE`,`VAR_NAME`,`VAR_DESC`,`VAR_SYSTEM`,`REC_TIME`,`REC_USER`) values ('SALES_CHANNEL','runsa','浪沙渠道',NULL,0,CURRENT_TIMESTAMP,NULL);



replace  into `crm_variable_type`(`VAR_SCOPE`,`VAR_TYPE`,`VAR_NAME`) values ('SALES_TYPE',2,'销售类型');
replace  into `crm_variable_type`(`VAR_SCOPE`,`VAR_TYPE`,`VAR_NAME`) values ('PAYMENT',3,'收款方式');
replace  into `crm_variable_type`(`VAR_SCOPE`,`VAR_TYPE`,`VAR_NAME`) values ('POINTS_CHANGE_CHL',1,'积分变更类型');
replace  into `crm_variable_type`(`VAR_SCOPE`,`VAR_TYPE`,`VAR_NAME`) values ('SALES_CHANNEL',1,'销售渠道');
replace  into `crm_variable_type`(`VAR_SCOPE`,`VAR_TYPE`,`VAR_NAME`) values ('POINTS_TYPE',4,'积分类型');


replace into `crm_account_set` (`ACT_ID`, `ACT_CODE`, `ACT_NAME`, `PTF_ID`, `ENABLE`, `ACT_DESC`, `REC_TIME`, `REC_USER`, `ACT_TYPE`) 
values('1','C001','全局CRM账套','1','1',NULL,CURRENT_TIMESTAMP,NULL,'0');

replace into `crm_points_type` (`PNT_TYPE`, `PNT_NAME`, `PNT_DESC`, `IS_SYSTEM`, `IS_DEFAULT`, `REC_TIME`, `REC_USER`) 
values('LEAGUE','联盟积分','联盟积分','1','1',CURRENT_TIMESTAMP,NULL);

replace into `crm_points_set` (`PNT_ID`, `ACT_ID`, `PNT_TYPE`, `PNT_SET_NAME`, `PNT_UNIT`, `PNT_U_V`, `EXCHANGE`, `IS_FANS`, `ENABLE`, `REC_TIME`, `REC_USER`) values('1','1','LEAGUE','联盟积分账套','分','1.000000','1','0','1',CURRENT_TIMESTAMP,NULL);

replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) 
values('POINTS_CHANGE_TYPE','CRMJFIN','销售订单','销售订单','1',CURRENT_TIMESTAMP,NULL);

replace into `crm_variable` (`VAR_SCOPE`, `VAR_CODE`, `VAR_NAME`, `VAR_DESC`, `VAR_SYSTEM`, `REC_TIME`, `REC_USER`) 
values('POINTS_CHANGE_TYPE','CRMJFOT','销售订单','销售订单','1',CURRENT_TIMESTAMP,NULL);





REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('1000021', 'NAME', '入会时间', 'test_user2', '用户表2', '2', NULL, NULL, NULL, 'java.lang.String', NULL, NULL, NULL, '1', '105', '2016-05-10 14:33:34', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000001', 'ACCOUNT', '账户ID', 'test_user', '用户表', '1', '6', '10', NULL, 'java.lang.String', NULL, NULL, NULL, '1', '105', '2016-05-10 14:33:10', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000002', 'NAME', '账户名称', 'test_user', '用户表', '2', NULL, NULL, '', 'java.lang.String', '0', '^张d{3}.*', '100001', '1', '105', '2016-05-10 14:33:34', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000003', 'ENABLE', '是否可用', 'test_user', '用户表', '3', NULL, NULL, NULL, 'java.lang.Integer', NULL, NULL, '100002,100003', '1', '105', '2016-05-10 14:33:34', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000004', 'ACT_DESC', '描述', 'test_user', '用户表', '4', NULL, '32', NULL, 'java.lang.String', NULL, NULL, NULL, '1', '105', '2016-05-10 14:33:34', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000006', 'BIRTHDAY', '出生日期', 'test_user', '用户表', '5', NULL, NULL, NULL, 'java.util.Date', NULL, NULL, NULL, '1', '105', '2016-05-10 14:33:34', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000008', 'SOURCE', '客户来源', 'test_user', '用户表', '7', NULL, NULL, '1', 'java.util.List', NULL, NULL, NULL, '1', '105', '2016-05-10 14:33:34', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000009', 'CST_ID', '客户ID', 'crm_customer_tags', '打标签', '1', NULL, NULL, NULL, 'java.lang.Integer', NULL, NULL, NULL, '1', '105', '2016-07-13 19:57:49', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000019', 'TAG_KEY', '标签名', 'crm_customer_tags', '打标签', '2', NULL, NULL, NULL, 'java.lang.String', NULL, NULL, NULL, '1', '105', '2016-07-13 19:57:49', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000020', 'TAG_VAL', '标签值', 'crm_customer_tags', '打标签', '3', NULL, NULL, NULL, 'java.lang.String', NULL, NULL, NULL, '1', '105', '2016-07-13 19:57:49', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000021', 'SHP_ID', '雇员ID', 'crm_coupons_grant_shopper', '雇员发放', '1', NULL, NULL, NULL, 'java.lang.Long', NULL, '^[0-9]*$', NULL, '1', NULL, '2016-07-18 19:03:24', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000022', 'PER_NUM', '每人数量', 'crm_coupons_grant_shopper', '雇员发放', '3', NULL, NULL, NULL, 'java.lang.Integer', NULL, '^[0-9]*$', NULL, '1', NULL, '2016-07-18 19:10:56', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000023', 'DOC_CODE', '单据编号', 'crm_coupons_grant_shopper', '雇员发放', '2', NULL, NULL, NULL, 'java.lang.String', NULL, NULL, NULL, '1', NULL, '2016-07-18 19:09:18', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000024', 'CST_ID', '顾客ID', 'crm_point_adjust_detail', '积点调整单详情', '1', NULL, NULL, NULL, 'java.lang.Long', NULL, '^[0-9]*$', NULL, '1', NULL, '2016-07-20 16:13:07', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000025', 'POINTS', '调整积点值', 'crm_point_adjust_detail', '积点调整单详情', '2', NULL, NULL, NULL, 'java.lang.Double', NULL, '^-?[1-9][0-9]*$', NULL, '1', NULL, '2016-07-20 16:17:33', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000026', 'DAYS', '有效天数', 'crm_point_adjust_detail', '积点调整单详情', '3', NULL, NULL, NULL, 'java.lang.Integer', NULL, '^[0-9]*$', NULL, '1', NULL, '2016-07-20 16:19:01', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000027', 'ORDER_ID', '关联单据编号', 'crm_point_adjust_detail', '积点调整单详情', '4', NULL, NULL, NULL, 'java.lang.String', NULL, NULL, NULL, '1', NULL, '2016-07-20 16:19:50', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000028', 'REMARK', '备注', 'crm_point_adjust_detail', '积点调整单详情', '5', NULL, NULL, NULL, 'java.lang.String', NULL, NULL, NULL, '1', NULL, '2016-07-20 16:20:05', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000029', 'ADJ_ID', '单据编号', 'crm_point_adjust_detail', '积点调整单详情', '6', NULL, NULL, NULL, 'java.lang.String', NULL, NULL, NULL, '1', NULL, '2016-07-20 16:20:17', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000030', 'CODE', '编号', 'mtSite', '网点表', '1', NULL, NULL, NULL, 'java.lang.String', '0', NULL, NULL, '1', NULL, '2016-07-20 18:42:26', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000031', 'NAME', '名称', 'mtSite', '网点表', '2', NULL, NULL, NULL, 'java.lang.String', '0', NULL, NULL, '1', NULL, '2016-07-20 18:43:24', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000032', 'SITYPE', '组织类型', 'mtSite', '网点表', '3', NULL, NULL, NULL, 'java.lang.String', '0', NULL, NULL, '1', NULL, '2016-07-20 18:48:54', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000033', 'SISALETYPE', '分销类型', 'mtSite', '网点表', '4', NULL, NULL, NULL, 'java.lang.String', '0', NULL, NULL, '1', NULL, '2016-07-20 18:54:25', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000034', 'SIOPENDATE', '实际开张时间', 'mtSite', '网点表', '5', NULL, NULL, NULL, 'java.util.Date', '0', NULL, NULL, '1', NULL, '2016-07-20 18:55:26', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000035', 'BENAME', '所属经营主体', 'mtSite', '网点表', '6', NULL, NULL, NULL, 'java.lang.String', '0', NULL, NULL, '1', NULL, '2016-07-20 18:56:28', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('10000036', 'BEBNAME', '结算主体', 'mtSite', '网点表', '7', NULL, NULL, NULL, 'java.lang.String', '0', NULL, NULL, '1', NULL, '2016-07-20 18:57:24', '0', '0');
REPLACE INTO `excel_column` (`ROW_ID`, `CODE`, `NAME`, `SHEET_CODE`, `SHEET_NAME`, `SORT_CODE`, `MIN_LENGTH`, `MAX_LENGTH`, `CODE_LIST`, `DATA_TYPE`, `NULLABLE`, `PATTERN`, `RULES`, `STATUS`, `CREATED_USER`, `CREATED_TIME`, `MODIFICATION_NUM`, `DELETED_FLAG`) VALUES ('110000005111111111', 'JOIN_TIME', '入会时间', 'test_user', '用户表', '6', NULL, NULL, NULL, 'java.util.Date', NULL, NULL, NULL, '1', '105', '2016-05-10 14:33:34', '0', '0');


/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;