用户记录表#
create table t_christ_user
(
f_id int(11) not null auto_increment,
primary key(f_id),
f_session_key varchar(100),
f_name varchar(100),
f_wechat_open_id varchar(124),
f_circle int(6) ,
f_no int(5),
f_headimgurl varchar(124) ,
f_ctime timestamp default CURRENT_TIMESTAMP,
f_status enum(0 ,1) default 0

)engine=myisam default charset=utf8;

礼品表

create table t_christ_gift
(
f_id int(11) not null auto_increment,
primary key(f_id),
f_brand varchar(30),
f_name varchar(64),
f_no int(6) default 0,
f_img varchar(32) ,
f_qrcode varchar(32)
)engine=myisam default charset=utf8;

http://cache.hinabian.com/mobile/images/activity/christ/#

insert into t_christ_gift values
(null , ‘dada’ , ‘价值110元的嗒嗒巴士代金券套票一套’ , 2000 , ‘dd110.png’ , ‘ddqr.png’),
(null , ‘qiubao’ , ‘价值268元的球宝手缝足球一枚’ , 20 , ‘qiubaoball.jpg’ , ‘quibaoqr.png’),
(null , ‘jumi’ , ‘小米手环一个’ , 5 , ‘jumish.jpg’ , ‘jumishouhuanqr.png’),
(null , ‘jumi’ , ‘10元话费’ , 30 ,’jumi10hf.png’,’jumishouhuan.png’ ),
(null , ‘jumi’ , ‘10元现金 长按下方二维码扫描注册即可领取，将于1-2日到达您的账户’ , 30 , ‘jumi10.png’ , ‘jumi10qr.png’),
(null , ‘jumi’ , ‘66元红包 长按下方二维码扫描注册即可领取，将于1-2日到达您的账户’ , 200 , ‘jumi66.png’ , ‘jumi10qr.png’),
(null , ‘jumi’ , ‘88元红包 长按下方二维码扫描注册即可领取，将于1-2日到达您的账户’ , 200 , ‘jumi88.png’ , ‘jumi10qr.png’),
(null , ‘oupeng’ , ‘旅朋出境游·800元代金券一张’ , 100 , ‘oupeng800.png’ , ‘oupeng800qr.png’),
(null , ‘oupeng’ , ‘旅朋出境游·500元代金券一张’ , 500 , ‘oupeng500.png’ , ‘oupeng500qr.png’),
(null , ‘oupeng’ , ‘旅朋出境游·300元代金券一张’ , 1000 , ‘oupeng300.png’ , ‘oupeng300qr.png’),
(null , ‘hnd’ , ‘海那边定制充电宝一个’ , 50 , ‘hnbpower.png’ , ‘hnbqr.png’) \W;

中奖池子表

create table t_christ_awards
(
f_id int(11) not null auto_increment,
primary key(f_id),
f_name varchar(30),
f_mobile int(11),
f_addr varchar(124) ,
f_award_id int(4),
f_wechat_open_id varchar(124),
f_ctime timestamp default CURRENT_TIMESTAMP
)engine=myisam default charset=utf8;

create table t_christ_award_winner(

f_id int(11) not null auto_increment,
primary key (f_id),
f_wechat_open_id varchar(248),
f_session_key varchar(212),
f_award_id int(3),
f_ctime timestamp default CURRENT_TIMESTAMP

)engine=myisam default charset=utf8;

+—————————+———————+———+——-+—————————-+————————+
| Field | Type | Null | Key | Default | Extra |
+—————————+———————+———+——-+—————————-+————————+
| f_id | int(11) | NO | PRI | NULL | auto_increment |
| f_name | varchar(30) | YES | | NULL | |
| f_mobile | int(11) | YES | | NULL | |
| f_addr | varchar(124) | YES | | NULL | |
| f_award_id | int(4) | YES | | NULL | |
| f_wechat_open_id | varchar(124) | YES | | NULL | |
| f_ctime | timestamp | NO | | CURRENT_TIMESTAMP | |
+—————————+———————+———+——-+—————————-+————————+