select consumer_id,vip_start_time,vip_end_time,`status`  from mddb.md_consumer where mobile='13309377346';

select  consumer_id  into @p from mddb.md_consumer where mobile='13309377346';

select @p  from dual;

/*

update mddb.md_consumer set nick_name=''  where mobile='13309377346'     

*/

/*执行上面如果为空，说明手机号不存在，如果vip_start_time 和vip_end_time 不为空，说明之前已经是vip，无需开通*/

INSERT INTO mddb.md_member_distribution  select @p,null,null,null,null,2,2,null,null,now(),null,1,null from dual;

REPLACE INTO mddb.md_member_distribution_info(`member_id`, `parent_id`, `status`, `create_time`) select @p,null,1,now();

update mddb.md_consumer set vip_start_time=now(),remark='手动创建超级会员' ,type=2 where consumer_id=@p;

update mddb.md_consumer set  vip_end_time=SUBDATE(vip_start_time,INTERVAL -1 YEAR) where consumer_id=@p;

update fddb.fd_member_asset set shell=1314 where member_id=@p;

INSERT INTO `mddb`.`md_member_invitation_code` (

`member_id`,

`invite_code`,

`status`,

`create_time`,

`remark`

) SELECT

consumer_id,

CEILING(RAND()*90000+10000),

0,

vip_start_time,

NULL

FROM

mddb.md_consumer

WHERE

consumer_id NOT IN (

SELECT

member_id

FROM

mddb.md_member_invitation_code

)

AND vip_start_time IS NOT NULL

AND vip_end_time > now()