|
1
|
UPDATE `tbl-master-produk` SET produk_game = REPLACE(produk_game, '"All Games",', '')
|
|
2
|
WHERE produk_game LIKE '%All Games%';
|
|
3
|
ALTER TABLE `tbl-master-produk` ADD COLUMN five_flag tinyint(1) unsigned zerofill DEFAULT '1' COMMENT '是否为5D，1：4D 0：5D';
|
|
4
|
|
|
5
|
ALTER TABLE`tbl-master-prize` ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
|
|
6
|
ALTER TABLE `tbl-master-prize` DROP INDEX prize_index;
|
|
7
|
ALTER TABLE `tbl-master-prize` ADD UNIQUE prize_index (prize_produk_code, agent_name);
|
|
8
|
|
|
9
|
ALTER TABLE `tbl-master-discount` ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
|
|
10
|
ALTER TABLE `tbl-master-discount` DROP INDEX code_name_game_mode;
|
|
11
|
ALTER TABLE `tbl-master-discount` ADD UNIQUE code_name_game_mode (`discount_produk_code`, `discount_produk_name`, `discount_produk_game`, `discount_produk_game_mode`, `agent_name`);
|
|
12
|
ALTER TABLE `tbl-master-discount` DROP INDEX agent_id;
|
|
13
|
ALTER TABLE `tbl-master-discount` ADD INDEX agent_name (`agent_name`);
|
|
14
|
|
|
15
|
ALTER TABLE `tbl-master-limit` ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
|
|
16
|
ALTER TABLE `tbl-master-limit` DROP INDEX code_name_game_mode;
|
|
17
|
ALTER TABLE `tbl-master-limit` ADD UNIQUE code_name_game_mode (`limit_produk_code`, `limit_produk_name`, `limit_produk_game`, `limit_produk_game_mode`, `agent_name`);
|
|
18
|
ALTER TABLE `tbl-master-limit` DROP INDEX agent_id;
|
|
19
|
ALTER TABLE `tbl-master-limit` ADD INDEX agent_name (`agent_name`);
|
|
20
|
|
|
21
|
|
|
22
|
|
|
23
|
ALTER TABLE `tbl-master-referral-bonus` ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
|
|
24
|
ALTER TABLE `tbl-master-referral-bonus` DROP INDEX referral_produk_game_uk;
|
|
25
|
ALTER TABLE `tbl-master-referral-bonus` ADD UNIQUE referral_produk_game_uk (`referral_bonus_produk_code`, `agent_name`, `referral_bonus_produk_game`);
|
|
26
|
ALTER TABLE `tbl-master-referral-bonus` DROP INDEX agent_id;
|
|
27
|
ALTER TABLE `tbl-master-referral-bonus` ADD INDEX agent_name (`agent_name`);
|
|
28
|
|
|
29
|
ALTER TABLE transaction_summary ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
|
|
30
|
ALTER TABLE transaction_summary_details ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
|
|
31
|
ALTER TABLE transaction_summary_player ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
|
|
32
|
|
|
33
|
ALTER TABLE `tbl-log-money` ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
|
|
34
|
ALTER TABLE `tbl-log-money` ADD COLUMN `log_state` varchar(2) DEFAULT NULL COMMENT '1、未派彩 2、已派彩';
|
|
35
|
ALTER TABLE `tbl-log-money`
|
|
36
|
ADD `username_virtual` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci GENERATED ALWAYS AS (json_unquote(json_extract(`log_json`,_utf8mb4'$.username'))) VIRTUAL;
|
|
37
|
ALTER TABLE `tbl-log-money` ADD INDEX idx_username_virtual (`username_virtual`);
|
|
38
|
|
|
39
|
|
|
40
|
CREATE TABLE `tbl-master-prize-bak` (
|
|
41
|
`prize_id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
42
|
`prize_produk_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
43
|
`prize_produk_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
44
|
`prize_produk_game` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
45
|
`reg_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
46
|
`prize_game_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
|
|
47
|
`prize_game_diskon` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
|
|
48
|
`prize_game_full` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
|
|
49
|
`prize_game_bolak_balik` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
|
|
50
|
`prize_game_three_prizes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
|
|
51
|
`prize_game_detail_4d` decimal(14,2) DEFAULT '0.00',
|
|
52
|
`prize_game_detail_3d` decimal(14,2) DEFAULT '0.00',
|
|
53
|
`prize_game_detail_2d_depan` decimal(14,2) DEFAULT '0.00',
|
|
54
|
`prize_game_detail_2d_tengah` decimal(14,2) DEFAULT '0.00',
|
|
55
|
`prize_game_detail_2d_belakang` decimal(14,2) DEFAULT '0.00',
|
|
56
|
`prize_game_detail_as_ganjil` decimal(14,2) DEFAULT '0.00',
|
|
57
|
`prize_game_detail_as_genap` decimal(14,2) DEFAULT '0.00',
|
|
58
|
`prize_game_detail_as_besar` decimal(14,2) DEFAULT '0.00',
|
|
59
|
`prize_game_detail_as_kecil` decimal(14,2) DEFAULT '0.00',
|
|
60
|
`prize_game_detail_kop_ganjil` decimal(14,2) DEFAULT '0.00',
|
|
61
|
`prize_game_detail_kop_genap` decimal(14,2) DEFAULT '0.00',
|
|
62
|
`prize_game_detail_kop_besar` decimal(14,2) DEFAULT '0.00',
|
|
63
|
`prize_game_detail_kop_kecil` decimal(14,2) DEFAULT '0.00',
|
|
64
|
`prize_game_detail_kepala_ganjil` decimal(14,2) DEFAULT '0.00',
|
|
65
|
`prize_game_detail_kepala_genap` decimal(14,2) DEFAULT '0.00',
|
|
66
|
`prize_game_detail_kepala_besar` decimal(14,2) DEFAULT '0.00',
|
|
67
|
`prize_game_detail_kepala_kecil` decimal(14,2) DEFAULT '0.00',
|
|
68
|
`prize_game_detail_ekor_ganjil` decimal(14,2) DEFAULT '0.00',
|
|
69
|
`prize_game_detail_ekor_genap` decimal(14,2) DEFAULT '0.00',
|
|
70
|
`prize_game_detail_ekor_besar` decimal(14,2) DEFAULT '0.00',
|
|
71
|
`prize_game_detail_ekor_kecil` decimal(14,2) DEFAULT '0.00',
|
|
72
|
`prize_game_detail_2_kombinasi` decimal(14,2) DEFAULT '0.00',
|
|
73
|
`prize_game_detail_colok_angka` decimal(14,2) DEFAULT '0.00',
|
|
74
|
`prize_game_detail_macau_1` decimal(14,2) DEFAULT '0.00',
|
|
75
|
`prize_game_detail_macau_2` decimal(14,2) DEFAULT '0.00',
|
|
76
|
`prize_game_detail_macau_3` decimal(14,2) DEFAULT '0.00',
|
|
77
|
`prize_game_detail_colok_naga_3` decimal(14,2) DEFAULT '0.00',
|
|
78
|
`prize_game_detail_colok_naga_4` decimal(14,2) DEFAULT '0.00',
|
|
79
|
`prize_game_detail_colok_jitu_as` decimal(14,2) DEFAULT '0.00',
|
|
80
|
`prize_game_detail_colok_jitu_kop` decimal(14,2) DEFAULT '0.00',
|
|
81
|
`prize_game_detail_colok_jitu_kepala` decimal(14,2) DEFAULT '0.00',
|
|
82
|
`prize_game_detail_colok_jitu_ekor` decimal(14,2) DEFAULT '0.00',
|
|
83
|
`prize_game_detail_tepi` decimal(14,2) DEFAULT '0.00',
|
|
84
|
`prize_game_detail_tengah` decimal(14,2) DEFAULT '0.00',
|
|
85
|
`prize_game_detail_shio` decimal(14,2) DEFAULT '0.00',
|
|
86
|
`prize_game_detail_dasar_ganjil` decimal(14,2) DEFAULT '0.00',
|
|
87
|
`prize_game_detail_dasar_genap` decimal(14,2) DEFAULT '0.00',
|
|
88
|
`prize_game_detail_dasar_besar` decimal(14,2) DEFAULT '0.00',
|
|
89
|
`prize_game_detail_dasar_kecil` decimal(14,2) DEFAULT '0.00',
|
|
90
|
`prize_game_detail_silang_depan` decimal(14,2) DEFAULT '0.00',
|
|
91
|
`prize_game_detail_silang_tengah` decimal(14,2) DEFAULT '0.00',
|
|
92
|
`prize_game_detail_silang_belakang` decimal(14,2) DEFAULT '0.00',
|
|
93
|
`prize_game_detail_homo_depan` decimal(14,2) DEFAULT '0.00',
|
|
94
|
`prize_game_detail_homo_tengah` decimal(14,2) DEFAULT '0.00',
|
|
95
|
`prize_game_detail_homo_belakang` decimal(14,2) DEFAULT '0.00',
|
|
96
|
`prize_game_detail_kembang_depan` decimal(14,2) DEFAULT '0.00',
|
|
97
|
`prize_game_detail_kembang_tengah` decimal(14,2) DEFAULT '0.00',
|
|
98
|
`prize_game_detail_kembang_belakang` decimal(14,2) DEFAULT '0.00',
|
|
99
|
`prize_game_detail_kempis_depan` decimal(14,2) DEFAULT '0.00',
|
|
100
|
`prize_game_detail_kempis_tengah` decimal(14,2) DEFAULT '0.00',
|
|
101
|
`prize_game_detail_kempis_belakang` decimal(14,2) DEFAULT '0.00',
|
|
102
|
`prize_game_detail_kembar_depan` decimal(14,2) DEFAULT '0.00',
|
|
103
|
`prize_game_detail_kembar_tengah` decimal(14,2) DEFAULT '0.00',
|
|
104
|
`prize_game_detail_kembar_belakang` decimal(14,2) DEFAULT '0.00',
|
|
105
|
`agent_id` bigint(20) DEFAULT '0',
|
|
106
|
`agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代理标识',
|
|
107
|
`periode_name` int DEFAULT NULL COMMENT '期数',
|
|
108
|
PRIMARY KEY (`prize_id`),
|
|
109
|
UNIQUE KEY `prize_index` (`prize_produk_code`,`agent_name`,`periode_name`) USING BTREE
|
|
110
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
|
|
111
|
|
|
112
|
CREATE TABLE `tbl-master-discount-bak` (
|
|
113
|
`discount_id` int unsigned NOT NULL AUTO_INCREMENT,
|
|
114
|
`discount_produk_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
115
|
`discount_produk_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
116
|
`discount_produk_game` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
117
|
`discount_produk_game_mode` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'default',
|
|
118
|
`discount_deposit_from_level_0` decimal(14,2) DEFAULT '0.00',
|
|
119
|
`discount_deposit_to_level_0` decimal(14,2) DEFAULT '0.00',
|
|
120
|
`discount_deposit_from_level_1` decimal(14,2) DEFAULT '0.00',
|
|
121
|
`discount_deposit_to_level_1` decimal(14,2) DEFAULT '0.00',
|
|
122
|
`discount_deposit_from_level_2` decimal(14,2) DEFAULT '0.00',
|
|
123
|
`discount_deposit_to_level_2` decimal(14,2) DEFAULT '0.00',
|
|
124
|
`discount_deposit_from_level_3` decimal(14,2) DEFAULT '0.00',
|
|
125
|
`discount_deposit_to_level_3` decimal(14,2) DEFAULT '0.00',
|
|
126
|
`discount_level_0` float(5,2) DEFAULT '0.00',
|
|
127
|
`discount_level_1` float(5,2) DEFAULT '0.00',
|
|
128
|
`discount_level_2` float(5,2) DEFAULT '0.00',
|
|
129
|
`discount_level_3` float(5,2) DEFAULT '0.00',
|
|
130
|
`reg_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
131
|
`agent_id` bigint(20) DEFAULT '0',
|
|
132
|
`agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代理标识',
|
|
133
|
`periode_name` int DEFAULT NULL COMMENT '期数',
|
|
134
|
PRIMARY KEY (`discount_id`),
|
|
135
|
UNIQUE KEY `code_name_game_mode` (`discount_produk_code`,`discount_produk_game`,`discount_produk_game_mode`,`agent_name`,`periode_name`) USING BTREE
|
|
136
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
|
|
137
|
|
|
138
|
CREATE TABLE `tbl-master-limit-bak` (
|
|
139
|
`limit_id` int unsigned NOT NULL AUTO_INCREMENT,
|
|
140
|
`limit_produk_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
|
|
141
|
`limit_produk_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
|
|
142
|
`limit_produk_game` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
|
|
143
|
`limit_produk_game_mode` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'default',
|
|
144
|
`limit_min` decimal(14,2) DEFAULT '1000.00',
|
|
145
|
`limit_max` decimal(14,2) DEFAULT '10000.00',
|
|
146
|
`limit_div` decimal(14,2) DEFAULT '1000.00',
|
|
147
|
`limit_global_orang` decimal(14,2) DEFAULT '0.00',
|
|
148
|
`limit_global_all` decimal(14,2) DEFAULT '0.00',
|
|
149
|
`reg_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
150
|
`agent_id` bigint(20) DEFAULT '0',
|
|
151
|
`agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代理标识',
|
|
152
|
`periode_name` int DEFAULT NULL COMMENT '期数',
|
|
153
|
PRIMARY KEY (`limit_id`),
|
|
154
|
UNIQUE KEY `code_name_game_mode` (`limit_produk_code`,`limit_produk_name`,`limit_produk_game`,`limit_produk_game_mode`,`agent_name`,`periode_name`) USING BTREE
|
|
155
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
|
|
156
|
|
|
157
|
CREATE TABLE `tbl-master-referral-bonus-bak` (
|
|
158
|
`referral_bonus_id` int unsigned NOT NULL AUTO_INCREMENT,
|
|
159
|
`referral_bonus_produk_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
|
|
160
|
`referral_bonus_produk_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
|
|
161
|
`referral_bonus_produk_game` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
|
|
162
|
`referral_bonus_from_level_0` decimal(14,2) DEFAULT '0.00',
|
|
163
|
`referral_bonus_to_level_0` decimal(14,2) DEFAULT '0.00',
|
|
164
|
`referral_bonus_from_level_1` decimal(14,2) DEFAULT '0.00',
|
|
165
|
`referral_bonus_to_level_1` decimal(14,2) DEFAULT '0.00',
|
|
166
|
`referral_bonus_from_level_2` decimal(14,2) DEFAULT '0.00',
|
|
167
|
`referral_bonus_to_level_2` decimal(14,2) DEFAULT '0.00',
|
|
168
|
`referral_bonus_from_level_3` decimal(14,2) DEFAULT '0.00',
|
|
169
|
`referral_bonus_to_level_3` decimal(14,2) DEFAULT '0.00',
|
|
170
|
`referral_bonus_level_0` float(5,2) DEFAULT '0.00',
|
|
171
|
`referral_bonus_level_1` float(5,2) DEFAULT '0.00',
|
|
172
|
`referral_bonus_level_2` float(5,2) DEFAULT '0.00',
|
|
173
|
`referral_bonus_level_3` float(5,2) DEFAULT '0.00',
|
|
174
|
`reg_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
175
|
`agent_id` bigint(20) DEFAULT '0',
|
|
176
|
`agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代理标识',
|
|
177
|
`periode_name` int DEFAULT NULL COMMENT '期数',
|
|
178
|
PRIMARY KEY (`referral_bonus_id`),
|
|
179
|
UNIQUE KEY `referral_bonus_produk_code_index` (`referral_bonus_produk_code`,`agent_name`,`referral_bonus_produk_game`,`periode_name`) USING BTREE
|
|
180
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
|
|
181
|
|
|
182
|
CREATE TABLE `tbl_template` (
|
|
183
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
|
184
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模板名称',
|
|
185
|
`create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
|
|
186
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
187
|
`update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
|
|
188
|
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
|
189
|
`remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
|
|
190
|
PRIMARY KEY (`id`) USING BTREE
|
|
191
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
|
|
192
|
|
|
193
|
|
|
194
|
CREATE TABLE `tbl_template_node` (
|
|
195
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
|
196
|
`template_id` bigint DEFAULT NULL COMMENT '模板id',
|
|
197
|
`produk_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '彩池编码',
|
|
198
|
`status` int DEFAULT NULL COMMENT '状态 1开启 0关闭',
|
|
199
|
`agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代理名称',
|
|
200
|
`control_data` int DEFAULT NULL COMMENT '控制是否可修改配置数据，1开启 0关闭',
|
|
201
|
`control_process` int DEFAULT NULL COMMENT '控制是否可开奖:1开启 0关闭',
|
|
202
|
`create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
|
|
203
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
204
|
`update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
|
|
205
|
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
|
206
|
PRIMARY KEY (`id`) USING BTREE,
|
|
207
|
KEY `template_produk_index` (`template_id`,`produk_code`,`agent_name`) USING BTREE
|
|
208
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;
|
|
209
|
|
|
210
|
CREATE TABLE `tbl_template_node_bak` (
|
|
211
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
|
212
|
`template_id` bigint DEFAULT NULL COMMENT '模板id',
|
|
213
|
`produk_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '彩池编码',
|
|
214
|
`status` int DEFAULT NULL COMMENT '状态 1开启 0关闭',
|
|
215
|
`agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代理名称',
|
|
216
|
`control_data` int DEFAULT NULL COMMENT '控制是否可修改配置数据，1开启 0关闭',
|
|
217
|
`control_process` int DEFAULT NULL COMMENT '控制是否可开奖:1开启 0关闭',
|
|
218
|
`create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
|
|
219
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
220
|
`update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
|
|
221
|
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
|
|
222
|
`periode_name` int DEFAULT NULL COMMENT '期数',
|
|
223
|
PRIMARY KEY (`id`),
|
|
224
|
KEY `template_produk_index` (`produk_code`,`agent_name`,`periode_name`) USING BTREE
|
|
225
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
|
|
226
|
INSERT INTO `lottery_agent_info`( `AGENT_ID`, `AGENT_NAME`, `LOCK_FLAG`, `AUTH_KEY`, `SECRET_KEY`, `DESCRIPTION`, `REVISION`, `CREATE_BY`, `CREATE_TIME`, `UPDATE_BY`, `UPDATE_TIME`, `PUBLIC_KEY`, `AREA`) VALUES ( 'admin', 'admin', b'0', 'admin', 'ndOypBWr2KY8ubKPpqqiboduomwuyjLO', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1');
|
|
227
|
INSERT INTO `tbl_template`(`id`, `name`, `create_by`, `create_time`, `remarks`) VALUES (1, 'admin', 'admin_lwh', now(), '用来新增模板使用');
|
|
228
|
|
|
229
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'SGD', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
230
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'HKG', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
231
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'SYD', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
232
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'NCD', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
233
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'CHN', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
234
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'JPN', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
235
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'CMB', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
236
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'ORG03', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
237
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'ORG6', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
238
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'ORG09', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
239
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'ORG12', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
240
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'TTM5', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
241
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'TTM1', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
242
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'TTM2', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
243
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'TTM3', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
244
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'TTM4', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
245
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'KTM', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
246
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'KTE', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
247
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'FLM', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
248
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'FLE', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
249
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'NYM', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
250
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'NYE', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
251
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'HUA01', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
252
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'HUA02', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
253
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'HUA03', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
254
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'BKK01', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
255
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'BKK02', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
256
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'NCD2', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
257
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'BRU02', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
258
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'BRU14', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
259
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'BRU21', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
260
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'CLF', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
261
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'PPT12', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
262
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'PPT15', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
263
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'PPT19', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
264
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'PPT22', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
265
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'BLE', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
266
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'CHS11', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
267
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'CHS15', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
268
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'CHS19', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
269
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'CHS21', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
270
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'NVD', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
271
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'MAG', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
272
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'PCO', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
273
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'TWN', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
274
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'TTM6', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
275
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'TTC', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
276
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'MALI15', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
277
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'MALI20', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
278
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'MALI23', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
279
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'KK1', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
280
|
INSERT INTO `tbl_template_node`(`template_id`, `produk_code`, `status`, `agent_name`, `control_data`, `control_process`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 'KK2', 1, 'admin', 1, 1, 'admin_lwh', now(), 'admin', now());
|
|
281
|
|
|
282
|
UPDATE `tbl-master-prize` SET agent_name = 'admin' WHERE agent_id = 0 ;
|
|
283
|
UPDATE `tbl-master-discount` SET agent_name = 'admin' WHERE agent_id = 0 ;
|
|
284
|
UPDATE `tbl-master-limit` SET agent_name = 'admin' WHERE agent_id = 0 ;
|
|
285
|
UPDATE `tbl-master-referral-bonus` SET agent_name = 'admin' WHERE agent_id = 0 ;
|