UPDATE `tbl-master-produk` SET produk_game = REPLACE(produk_game, '"All Games",', '')
WHERE produk_game LIKE '%All Games%';
ALTER TABLE `tbl-master-produk` ADD COLUMN five_flag tinyint(1) unsigned zerofill DEFAULT '1' COMMENT '是否为5D，1：4D 0：5D';

ALTER TABLE`tbl-master-prize` ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
ALTER TABLE `tbl-master-prize` DROP INDEX prize_index;
ALTER TABLE `tbl-master-prize` ADD UNIQUE prize_index (prize_produk_code, agent_name);

ALTER TABLE `tbl-master-discount` ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
ALTER TABLE `tbl-master-discount` DROP INDEX code_name_game_mode;
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`);
ALTER TABLE `tbl-master-discount` DROP INDEX agent_id;
ALTER TABLE `tbl-master-discount` ADD INDEX agent_name (`agent_name`);

ALTER TABLE `tbl-master-limit` ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
ALTER TABLE `tbl-master-limit` DROP INDEX code_name_game_mode;
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`);
ALTER TABLE `tbl-master-limit` DROP INDEX agent_id;
ALTER TABLE `tbl-master-limit` ADD INDEX agent_name (`agent_name`);



ALTER TABLE `tbl-master-referral-bonus` ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
ALTER TABLE `tbl-master-referral-bonus` DROP INDEX referral_produk_game_uk;
ALTER TABLE `tbl-master-referral-bonus` ADD UNIQUE referral_produk_game_uk (`referral_bonus_produk_code`, `agent_name`, `referral_bonus_produk_game`);
ALTER TABLE `tbl-master-referral-bonus` DROP INDEX agent_id;
ALTER TABLE `tbl-master-referral-bonus` ADD INDEX agent_name (`agent_name`);

ALTER TABLE transaction_summary ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
ALTER TABLE transaction_summary_details ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
ALTER TABLE transaction_summary_player ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';

ALTER TABLE `tbl-log-money` ADD COLUMN `agent_name` varchar(50) DEFAULT NULL COMMENT '代理标识';
ALTER TABLE `tbl-log-money` ADD COLUMN `log_state` varchar(2) DEFAULT NULL COMMENT '1、未派彩  2、已派彩';
ALTER TABLE `tbl-log-money`
ADD `username_virtual` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci GENERATED ALWAYS AS (json_unquote(json_extract(`log_json`,_utf8mb4'$.username'))) VIRTUAL;
ALTER TABLE `tbl-log-money` ADD INDEX idx_username_virtual (`username_virtual`);


CREATE TABLE `tbl-master-prize-bak` (
  `prize_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `prize_produk_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prize_produk_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prize_produk_game` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reg_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `prize_game_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prize_game_diskon` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prize_game_full` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prize_game_bolak_balik` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prize_game_three_prizes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prize_game_detail_4d` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_3d` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_2d_depan` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_2d_tengah` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_2d_belakang` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_as_ganjil` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_as_genap` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_as_besar` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_as_kecil` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kop_ganjil` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kop_genap` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kop_besar` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kop_kecil` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kepala_ganjil` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kepala_genap` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kepala_besar` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kepala_kecil` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_ekor_ganjil` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_ekor_genap` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_ekor_besar` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_ekor_kecil` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_2_kombinasi` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_colok_angka` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_macau_1` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_macau_2` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_macau_3` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_colok_naga_3` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_colok_naga_4` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_colok_jitu_as` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_colok_jitu_kop` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_colok_jitu_kepala` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_colok_jitu_ekor` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_tepi` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_tengah` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_shio` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_dasar_ganjil` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_dasar_genap` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_dasar_besar` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_dasar_kecil` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_silang_depan` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_silang_tengah` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_silang_belakang` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_homo_depan` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_homo_tengah` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_homo_belakang` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kembang_depan` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kembang_tengah` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kembang_belakang` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kempis_depan` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kempis_tengah` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kempis_belakang` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kembar_depan` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kembar_tengah` decimal(14,2) DEFAULT '0.00',
  `prize_game_detail_kembar_belakang` decimal(14,2) DEFAULT '0.00',
  `agent_id` bigint(20) DEFAULT '0',
  `agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代理标识',
  `periode_name` int DEFAULT NULL COMMENT '期数',
  PRIMARY KEY (`prize_id`),
  UNIQUE KEY `prize_index` (`prize_produk_code`,`agent_name`,`periode_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

CREATE TABLE `tbl-master-discount-bak` (
  `discount_id` int unsigned NOT NULL AUTO_INCREMENT,
  `discount_produk_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_produk_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_produk_game` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_produk_game_mode` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'default',
  `discount_deposit_from_level_0` decimal(14,2) DEFAULT '0.00',
  `discount_deposit_to_level_0` decimal(14,2) DEFAULT '0.00',
  `discount_deposit_from_level_1` decimal(14,2) DEFAULT '0.00',
  `discount_deposit_to_level_1` decimal(14,2) DEFAULT '0.00',
  `discount_deposit_from_level_2` decimal(14,2) DEFAULT '0.00',
  `discount_deposit_to_level_2` decimal(14,2) DEFAULT '0.00',
  `discount_deposit_from_level_3` decimal(14,2) DEFAULT '0.00',
  `discount_deposit_to_level_3` decimal(14,2) DEFAULT '0.00',
  `discount_level_0` float(5,2) DEFAULT '0.00',
  `discount_level_1` float(5,2) DEFAULT '0.00',
  `discount_level_2` float(5,2) DEFAULT '0.00',
  `discount_level_3` float(5,2) DEFAULT '0.00',
  `reg_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `agent_id` bigint(20) DEFAULT '0',
  `agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代理标识',
  `periode_name` int DEFAULT NULL COMMENT '期数',
  PRIMARY KEY (`discount_id`),
  UNIQUE KEY `code_name_game_mode` (`discount_produk_code`,`discount_produk_game`,`discount_produk_game_mode`,`agent_name`,`periode_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

CREATE TABLE `tbl-master-limit-bak` (
  `limit_id` int unsigned NOT NULL AUTO_INCREMENT,
  `limit_produk_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `limit_produk_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `limit_produk_game` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `limit_produk_game_mode` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'default',
  `limit_min` decimal(14,2) DEFAULT '1000.00',
  `limit_max` decimal(14,2) DEFAULT '10000.00',
  `limit_div` decimal(14,2) DEFAULT '1000.00',
  `limit_global_orang` decimal(14,2) DEFAULT '0.00',
  `limit_global_all` decimal(14,2) DEFAULT '0.00',
  `reg_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `agent_id` bigint(20) DEFAULT '0',
  `agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代理标识',
  `periode_name` int DEFAULT NULL COMMENT '期数',
  PRIMARY KEY (`limit_id`),
  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
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

CREATE TABLE `tbl-master-referral-bonus-bak` (
  `referral_bonus_id` int unsigned NOT NULL AUTO_INCREMENT,
  `referral_bonus_produk_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `referral_bonus_produk_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `referral_bonus_produk_game` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `referral_bonus_from_level_0` decimal(14,2) DEFAULT '0.00',
  `referral_bonus_to_level_0` decimal(14,2) DEFAULT '0.00',
  `referral_bonus_from_level_1` decimal(14,2) DEFAULT '0.00',
  `referral_bonus_to_level_1` decimal(14,2) DEFAULT '0.00',
  `referral_bonus_from_level_2` decimal(14,2) DEFAULT '0.00',
  `referral_bonus_to_level_2` decimal(14,2) DEFAULT '0.00',
  `referral_bonus_from_level_3` decimal(14,2) DEFAULT '0.00',
  `referral_bonus_to_level_3` decimal(14,2) DEFAULT '0.00',
  `referral_bonus_level_0` float(5,2) DEFAULT '0.00',
  `referral_bonus_level_1` float(5,2) DEFAULT '0.00',
  `referral_bonus_level_2` float(5,2) DEFAULT '0.00',
  `referral_bonus_level_3` float(5,2) DEFAULT '0.00',
  `reg_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `agent_id` bigint(20) DEFAULT '0',
  `agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代理标识',
  `periode_name` int DEFAULT NULL COMMENT '期数',
  PRIMARY KEY (`referral_bonus_id`),
  UNIQUE KEY `referral_bonus_produk_code_index` (`referral_bonus_produk_code`,`agent_name`,`referral_bonus_produk_game`,`periode_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

CREATE TABLE `tbl_template` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '模板名称',
  `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;


CREATE TABLE `tbl_template_node` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `template_id` bigint DEFAULT NULL COMMENT '模板id',
  `produk_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '彩池编码',
  `status` int DEFAULT NULL COMMENT '状态 1开启 0关闭',
  `agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代理名称',
  `control_data` int DEFAULT NULL COMMENT '控制是否可修改配置数据，1开启 0关闭',
  `control_process` int DEFAULT NULL COMMENT '控制是否可开奖:1开启 0关闭',
  `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `template_produk_index` (`template_id`,`produk_code`,`agent_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

CREATE TABLE `tbl_template_node_bak` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `template_id` bigint DEFAULT NULL COMMENT '模板id',
  `produk_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '彩池编码',
  `status` int DEFAULT NULL COMMENT '状态 1开启 0关闭',
  `agent_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代理名称',
  `control_data` int DEFAULT NULL COMMENT '控制是否可修改配置数据，1开启 0关闭',
  `control_process` int DEFAULT NULL COMMENT '控制是否可开奖:1开启 0关闭',
  `create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `periode_name` int DEFAULT NULL COMMENT '期数',
  PRIMARY KEY (`id`),
  KEY `template_produk_index` (`produk_code`,`agent_name`,`periode_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
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');
INSERT INTO `tbl_template`(`id`, `name`, `create_by`, `create_time`, `remarks`) VALUES (1, 'admin', 'admin_lwh', now(), '用来新增模板使用');

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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());
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());

UPDATE `tbl-master-prize` SET agent_name = 'admin' WHERE agent_id = 0 ;
UPDATE `tbl-master-discount` SET agent_name = 'admin' WHERE agent_id = 0 ;
UPDATE `tbl-master-limit` SET agent_name = 'admin' WHERE agent_id = 0 ;
UPDATE `tbl-master-referral-bonus` SET agent_name = 'admin' WHERE agent_id = 0 ;