-
Notifications
You must be signed in to change notification settings - Fork 38
/
Copy pathupdate.sql
220 lines (191 loc) · 20.1 KB
/
update.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
--
-- 配置分类充值配置
--
INSERT INTO `eb_system_config_tab`(`id`, `title`, `eng_title`, `status`, `info`, `icon`, `type`) VALUES (23, '充值金币', 'recharge', 1, 0, 'jpy', 7);
INSERT INTO `eb_system_config`(`id`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES (176, 'gold_rate', 'text', 'input', 23, NULL, NULL, 'number:rue', 100, NULL, '\"10\"', '人民币与金币换算率', '充值人民币和金币的换算概率，默认：1元人民币=10系统虚拟金币', 0, 1);
INSERT INTO `eb_system_config`(`id`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES (177, 'gold_name', 'text', 'input', 23, NULL, NULL, NULL, 100, NULL, '\"\\u91d1\\u5e01\"', '虚拟货币名称', '虚拟货币名称（如，金币，水滴，鲜花等）', 0, 1);
INSERT INTO `eb_system_config`(`id`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES (178, 'gold_image', 'upload', 'input', 23, NULL, 1, NULL, NULL, NULL, '\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/61d9d202006181439471781.png\"', '虚拟货币图标', '虚拟货币图标', 0, 1);
/*UPDATE `eb_system_config` SET `menu_name` = 'store_user_min_recharge', `type` = 'text', `input_type` = 'input', `config_tab_id` = 23, `parameter` = '', `upload_type` = 0, `required` = 'required:true,number:true,min:0', `width` = 100, `high` = 0, `value` = '\"0.01\"', `info` = '用户最低充值金额', `desc` = '用户单次最低充值金额', `sort` = 0, `status` = 1 WHERE `id` = 44;*/
ALTER TABLE `eb_user` ADD COLUMN `gold_num` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '虚拟币余额' AFTER `now_money`;
ALTER TABLE `eb_user_recharge` ADD COLUMN `gold_num` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '虚拟币余额' AFTER `price`;
ALTER TABLE `eb_system_admin` ADD COLUMN `phone` varchar(11) NOT NULL COMMENT '前端登录电话号码'AFTER `roles`;
UPDATE `eb_system_config` SET `config_tab_id` = 23 WHERE `id` = 44;
ALTER TABLE `eb_recommend_relation` MODIFY COLUMN `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型,0=专题,1=新闻，2=直播，3=活动';
INSERT INTO `eb_system_config`(`id`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES (179, 'single_gold_coin', 'text', 'input', 22, NULL, NULL, '', 100, NULL, '1', '单次签到虚拟币数', '每次签到用户可以获得的虚拟币数（默认为金币）', 0, 1);
INSERT INTO `eb_system_config`(`id`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES (180, 'sign_default_poster', 'upload', 'input', 22, NULL, 1, NULL, NULL, NULL, '\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/20362202002201412303972.jpg\"', '签到海报', '签到默认海报（没有签到海报时默认显示此图）', 0, 1);
INSERT INTO `eb_system_config`(`id`, `menu_name`, `type`, `input_type`, `config_tab_id`, `parameter`, `upload_type`, `required`, `width`, `high`, `value`, `info`, `desc`, `sort`, `status`) VALUES (181, 'balance_switch', 'radio', 'input', 22, '1=开启\n0=关闭', NULL, NULL, NULL, NULL, '\"1\"', '余额开关', '余额开关', 0, 1);
INSERT INTO `eb_system_role`(`id`, `role_name`, `sign`, `rules`, `level`, `status`) VALUES (3, '核销员', 'verification', '518,286', 1, 1);
--
-- 菜单
--
UPDATE `eb_system_menus` SET `params` = '{\"tab_id\":\"1\",\"type\":\"7\"}' WHERE `id` = 6;
UPDATE `eb_system_menus` SET `params` = '{\"tab_id\":\"22\",\"type\":\"6\"}' WHERE `id` = 508;
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (512, 287, '', '充值配置', 'admin', 'setting.system_config', 'index', '{\"tab_id\":\"23\",\"type\":\"7\"}', 0, 1, 1);
UPDATE `eb_system_menus` SET `params` = '{\"tab_id\":\"1\",\"type\":\"999\"}' WHERE `id` = 6;
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (513, 0, 'video-camera', '直播', 'admin', '', '', '[]', 298, 1, 1);
UPDATE `eb_system_menus` SET `pid` = 513, `menu_name` = '直播列表', `sort` = 292 WHERE `id` = 487;
/*INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (514, 513, '', '推荐课程', 'admin', 'live.aliyun_live', 'live_goods', '[]', 0, 1, 1);*/
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (515, 513, '', '直播间管理', 'admin', 'live.aliyun_live', 'index', '{\"special_type\":\"4\",\"type\":\"2\"}', 290, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (516, 513, '', '礼物管理', 'admin', 'setting.system_group_data', 'index', '{\"gid\":\"59\"}', 289, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (517, 513, '', '直播贡献', 'admin', 'live.aliyun_live', 'live_reward', '[]', 288, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (518, 307, '', '虚拟币监控', 'admin', 'finance.finance', 'bill', '{\"category\":\"gold_num\"}', 0, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (519, 286, '', '活动管理', 'admin', 'ump.eventRegistration', 'index', '[]', 0, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (520, 485, '', '专题列表', 'admin', 'special.SpecialType', 'index', '{\"special_type\":\"3\"}', 1, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (521, 485, '', '素材列表', 'admin', 'special.SpecialType', 'source_index', '{\"special_type\":\"3\"}', 0, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (522, 484, '', '专题列表', 'admin', 'special.special_type', 'index', '{\"special_type\":\"2\"}', 1, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (523, 484, '', '素材列表', 'admin', 'special.special_type', 'source_index', '{\"special_type\":\"2\"}', 0, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (524, 483, '', '专题列表', 'admin', 'special.special_type', 'index', '{\"special_type\":\"1\"}', 1, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (525, 483, '', '素材列表', 'admin', 'special.special_type', 'source_index', '{\"special_type\":\"1\"}', 0, 1, 1);
INSERT INTO `eb_system_group`(`id`, `name`, `info`, `config_name`, `fields`) VALUES (59, '直播间礼物列表', '直播间礼物列表', 'live_gift', '[{\"name\":\"\\u793c\\u7269\\u540d\\u79f0\",\"title\":\"live_gift_name\",\"type\":\"input\",\"param\":\"\"},{\"name\":\"\\u793c\\u7269\\u4ef7\\u683c\\uff08\\u865a\\u62df\\u8d27\\u5e01\\uff09\",\"title\":\"live_gift_price\",\"type\":\"input\",\"param\":\"\"},{\"name\":\"\\u8d60\\u9001\\u6570\\u91cf\\u5217\\u8868\",\"title\":\"live_gift_num\",\"type\":\"checkbox\",\"param\":\"1=1\\n5=5\\n10=10\\n20=20\\n66=66\\n99=99\\n520=520\\n999=999\\n1314=1314\"},{\"name\":\"\\u793c\\u7269\\u56fe\\u6807\",\"title\":\"live_gift_show_img\",\"type\":\"upload\",\"param\":\"\"}]');
INSERT INTO `eb_system_group_data`(`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES (170, 59, '{\"live_gift_name\":{\"type\":\"input\",\"value\":\"\\u9c9c\\u82b1\"},\"live_gift_price\":{\"type\":\"input\",\"value\":\"2\"},\"live_gift_num\":{\"type\":\"checkbox\",\"value\":[\"1\",\"5\",\"66\",\"520\",\"999\",\"1314\"]},\"live_gift_show_img\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/da616202007011009436251.png\"}}', 1590739724, 9, 1);
INSERT INTO `eb_system_group_data`(`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES (171, 59, '{\"live_gift_name\":{\"type\":\"input\",\"value\":\"\\u7231\\u5fc3\"},\"live_gift_price\":{\"type\":\"input\",\"value\":\"1\"},\"live_gift_num\":{\"type\":\"checkbox\",\"value\":[\"1\",\"5\",\"10\",\"20\"]},\"live_gift_show_img\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/5a2d520200701101025960.png\"}}', 1590740368, 10, 1);
INSERT INTO `eb_system_group_data`(`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES (172, 59, '{\"live_gift_name\":{\"type\":\"input\",\"value\":\"\\u6c14\\u7403\"},\"live_gift_price\":{\"type\":\"input\",\"value\":\"6\"},\"live_gift_num\":{\"type\":\"checkbox\",\"value\":[\"1\",\"5\",\"10\",\"20\",\"66\",\"99\",\"520\",\"999\",\"1314\"]},\"live_gift_show_img\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/0c648202007011012055342.png\"}}', 1593569535, 7, 1);
INSERT INTO `eb_system_group_data`(`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES (173, 59, '{\"live_gift_name\":{\"type\":\"input\",\"value\":\"\\u7687\\u51a0\"},\"live_gift_price\":{\"type\":\"input\",\"value\":\"20\"},\"live_gift_num\":{\"type\":\"checkbox\",\"value\":[\"1\",\"5\",\"10\",\"20\",\"66\",\"99\",\"520\"]},\"live_gift_show_img\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/82d4c202007011013025359.png\"}}', 1593569588, 5, 1);
INSERT INTO `eb_system_group_data`(`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES (174, 59, '{\"live_gift_name\":{\"type\":\"input\",\"value\":\"\\u5956\\u676f\"},\"live_gift_price\":{\"type\":\"input\",\"value\":\"15\"},\"live_gift_num\":{\"type\":\"checkbox\",\"value\":[\"1\",\"5\",\"10\",\"20\",\"66\",\"99\",\"520\"]},\"live_gift_show_img\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/1caae202007011013442033.png\"}}', 1593569629, 6, 1);
INSERT INTO `eb_system_group_data`(`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES (175, 59, '{\"live_gift_name\":{\"type\":\"input\",\"value\":\"\\u9526\\u9ca4\"},\"live_gift_price\":{\"type\":\"input\",\"value\":\"30\"},\"live_gift_num\":{\"type\":\"checkbox\",\"value\":[\"1\",\"5\",\"10\",\"20\",\"66\",\"99\",\"520\"]},\"live_gift_show_img\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/226e5202007011015051008.png\"}}', 1593569720, 4, 1);
INSERT INTO `eb_system_group_data`(`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES (176, 59, '{\"live_gift_name\":{\"type\":\"input\",\"value\":\"\\u5609\\u5e74\\u534e\"},\"live_gift_price\":{\"type\":\"input\",\"value\":\"50\"},\"live_gift_num\":{\"type\":\"checkbox\",\"value\":[\"1\",\"5\",\"10\",\"20\",\"66\",\"99\",\"520\"]},\"live_gift_show_img\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/22c8e202007011017537720.png\"}}', 1593569880, 3, 1);
INSERT INTO `eb_system_group_data`(`id`, `gid`, `value`, `add_time`, `sort`, `status`) VALUES (177, 59, '{\"live_gift_name\":{\"type\":\"input\",\"value\":\"\\u7c89\\u7b14\"},\"live_gift_price\":{\"type\":\"input\",\"value\":\"5\"},\"live_gift_num\":{\"type\":\"checkbox\",\"value\":[\"1\",\"5\",\"10\",\"20\",\"66\",\"99\",\"520\"]},\"live_gift_show_img\":{\"type\":\"upload\",\"value\":\"http:\\/\\/cremb-zsff.oss-cn-beijing.aliyuncs.com\\/96ea420200701101917287.png\"}}', 1593569968, 8, 1);
UPDATE `eb_system_menus` SET `pid` = 307, `icon` = '', `menu_name` = '资金监控', `module` = 'admin', `controller` = 'finance.finance', `action` = 'bill', `params` = '{\"category\":\"now_money\"}', `sort` = 0, `is_show` = 1, `access` = 1 WHERE `id` = 312;
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (526, 417, '', '新闻分类', 'admin', 'article.article_category', 'index', '[]', 0, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (527, 286, '', '签到管理', 'admin', '', '', '[]', 0, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (528, 527, '', '签到海报', 'admin', 'user.signPoster', 'index', '[]', 0, 1, 1);
INSERT INTO `eb_system_menus`(`id`, `pid`, `icon`, `menu_name`, `module`, `controller`, `action`, `params`, `sort`, `is_show`, `access`) VALUES (529, 527, '', '签到记录', 'admin', 'user.userSign', 'index', '[]', 0, 1, 1);
--
-- 新增表
--
CREATE TABLE `eb_live_reward` (
`id` int(11) NOT NULL,
`live_id` int(11) unsigned NOT NULL COMMENT '直播间id',
`uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户uid',
`nickname` varchar(100) CHARACTER SET utf8mb4 NOT NULL COMMENT '昵称',
`gift_id` int(11) NOT NULL COMMENT '礼物id',
`gift_name` varchar(100) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '礼物名称',
`gift_price` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '虚拟货币价格',
`gift_num` int(11) NOT NULL DEFAULT '0' COMMENT '礼物数量',
`total_price` int(11) NOT NULL DEFAULT '0' COMMENT '总虚拟货币价格',
`add_time` int(11) NOT NULL DEFAULT '0' COMMENT '打赏时间',
`is_show` int(11) NOT NULL DEFAULT '1' COMMENT '是否显示 1= 显示，0=隐藏'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='直播间礼物打赏表';
ALTER TABLE `eb_live_reward`
ADD PRIMARY KEY (`id`),
ADD KEY `uid` (`uid`) USING BTREE;
ALTER TABLE `eb_live_reward`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
CREATE TABLE `eb_live_goods` (
`id` int(11) NOT NULL,
`special_id` int(11) NOT NULL DEFAULT '0' COMMENT '专题id',
`live_id` int(11) NOT NULL DEFAULT '0' COMMENT '直播间id',
`special_name` varchar(100) NOT NULL DEFAULT '' COMMENT '课程名称',
`is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示',
`sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
`sales` int(10) NOT NULL DEFAULT '0' COMMENT '销量',
`fake_sales` int(10) NOT NULL DEFAULT '0' COMMENT '虚拟销量',
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
`add_time` int(11) unsigned NOT NULL COMMENT '添加时间',
`update_time` int(11) NOT NULL COMMENT '修改时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='直播间带货表';
ALTER TABLE `eb_live_goods`
ADD PRIMARY KEY (`id`);
ALTER TABLE `eb_live_goods`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
CREATE TABLE `eb_event_registration` (
`id` int(10) NOT NULL,
`title` varchar(255) NOT NULL COMMENT '标题',
`phone` varchar(12) NOT NULL COMMENT '电话',
`image` varchar(255) NOT NULL COMMENT '封面图',
`signup_start_time` int(50) NOT NULL COMMENT '报名开始时间',
`signup_end_time` int(50) NOT NULL COMMENT '报名结束时间',
`start_time` int(50) NOT NULL COMMENT '活动开始时间',
`end_time` int(50) NOT NULL COMMENT '活动结束时间',
`province` varchar(255) NOT NULL COMMENT '省',
`city` varchar(255) NOT NULL COMMENT '市',
`district` varchar(255) NOT NULL COMMENT '区',
`detail` varchar(255) NOT NULL COMMENT '详细地址',
`latitude` varchar(255) NOT NULL COMMENT '纬度',
`longitude` varchar(255) NOT NULL COMMENT '经度',
`number` int(10) NOT NULL DEFAULT '0' COMMENT '人数',
`sort` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
`activity_rules` varchar(3000) DEFAULT NULL COMMENT '活动规则',
`content` varchar(5000) DEFAULT NULL COMMENT '活动详情',
`pay_type` int(2) NOT NULL DEFAULT '0' COMMENT '是否免费',
`price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '价格',
`member_pay_type` tinyint(2) NOT NULL COMMENT '会员支付状态（0:免费1:付费）',
`member_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '会员价格',
`write_off_code` varchar(255) NOT NULL COMMENT '核销码',
`restrictions` tinyint(2) NOT NULL DEFAULT '0' COMMENT '限购',
`is_fill` tinyint(2) NOT NULL DEFAULT '1' COMMENT '是否填写资料',
`qrcode_img` varchar(255) DEFAULT NULL COMMENT '群聊二维码',
`is_show` tinyint(2) NOT NULL COMMENT '是否显示',
`is_del` int(2) NOT NULL DEFAULT '0' COMMENT '是否删除',
`add_time` int(50) NOT NULL DEFAULT '1' COMMENT '添加时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='活动报名表';
ALTER TABLE `eb_event_registration`
ADD PRIMARY KEY (`id`);
ALTER TABLE `eb_event_registration`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
CREATE TABLE `eb_event_sign_up` (
`id` int(10) NOT NULL,
`order_id` varchar(64) NOT NULL COMMENT '订单号',
`trade_no` varchar(64) NOT NULL COMMENT '支付宝支付,支付宝交易订单号',
`uid` int(10) NOT NULL,
`user_info` varchar(3072) NOT NULL COMMENT '报名信息',
`activity_id` int(10) NOT NULL DEFAULT '0' COMMENT '活动ID',
`pay_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '实际支付价格',
`paid` int(2) NOT NULL DEFAULT '0' COMMENT '支付状态',
`pay_time` int(50) DEFAULT '0' COMMENT '支付时间',
`pay_type` varchar(20) NOT NULL DEFAULT '0' COMMENT '支付方式',
`status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '状态（0:未核销1:已核销）',
`write_off_code` varchar(255) DEFAULT NULL COMMENT '核销二维码',
`is_del` tinyint(2) NOT NULL,
`add_time` int(50) NOT NULL DEFAULT '0' COMMENT '添加时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户报名表';
ALTER TABLE `eb_event_sign_up`
ADD PRIMARY KEY (`id`);
ALTER TABLE `eb_event_sign_up`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
CREATE TABLE `eb_user_sign` (
`id` int(11) NOT NULL,
`uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户uid',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '签到说明',
`number` int(11) NOT NULL DEFAULT '0' COMMENT '获得金币',
`balance` int(11) NOT NULL DEFAULT '0' COMMENT '剩余金币',
`add_time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='签到记录表';
ALTER TABLE `eb_user_sign`
ADD PRIMARY KEY (`id`),
ADD KEY `uid` (`uid`) USING BTREE;
ALTER TABLE `eb_user_sign`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
CREATE TABLE `eb_sign_poster` (
`id` int(10) NOT NULL,
`sign_time` int(50) unsigned NOT NULL DEFAULT '0' COMMENT '签到时间',
`poster` varchar(255) DEFAULT NULL COMMENT '分享海报',
`sort` int(5) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
`add_time` int(50) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='签到海报';
ALTER TABLE `eb_sign_poster`
ADD PRIMARY KEY (`id`);
ALTER TABLE `eb_sign_poster`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
CREATE TABLE `eb_search_history` (
`id` int(11) NOT NULL,
`uid` int(11) NOT NULL DEFAULT '0',
`search` varchar(255) NOT NULL COMMENT '搜索内容',
`add_time` int(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='历史搜索';
ALTER TABLE `eb_search_history`
ADD PRIMARY KEY (`id`);
ALTER TABLE `eb_search_history`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
CREATE TABLE `eb_special_watch` (
`id` int(11) NOT NULL,
`uid` int(11) NOT NULL COMMENT 'uid',
`special_id` int(11) NOT NULL COMMENT '专题ID',
`task_id` int(11) NOT NULL COMMENT '素材ID',
`viewing_time` int(50) DEFAULT '0' COMMENT '观看时间',
`add_time` int(50) DEFAULT '0' COMMENT '时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户观看素材时间';
ALTER TABLE `eb_special_watch`
ADD PRIMARY KEY (`id`);
ALTER TABLE `eb_special_watch`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;