Project

General

Profile

Actions
Copy link

功能 #1028

open

彩票增加投注状况统计

Added by 肖 宏举 7 months ago. Updated 7 months ago.

Status:
新建
Priority:
普通
Assignee:
-
Start date:
10/05/2024
Due date:
% Done:

0%

Estimated time:
版本:
Actions
Copy link
 #1

Updated by 肖 宏举 7 months ago

use test_smb;

drop table if exists `game_oc_lottery_bet_summary_2d`;
drop table if exists `game_oc_lottery_bet_summary_2ddepan`;
drop table if exists `game_oc_lottery_bet_summary_2dtengah`;
drop table if exists `game_oc_lottery_bet_summary_3d`;
drop table if exists `game_oc_lottery_bet_summary_4d`;
drop table if exists `game_oc_lottery_bet_summary_5d`;
drop table if exists `game_oc_lottery_bet_summary_50-50`;
drop table if exists `game_oc_lottery_bet_summary_colokbebas`;
drop table if exists `game_oc_lottery_bet_summary_colokjitu`;
drop table if exists `game_oc_lottery_bet_summary_colokmacau`;
drop table if exists `game_oc_lottery_bet_summary_coloknaga`;
drop table if exists `game_oc_lottery_bet_summary_dasar`;
drop table if exists `game_oc_lottery_bet_summary_index`;
drop table if exists `game_oc_lottery_bet_summary_kembangkempiskembar`;
drop table if exists `game_oc_lottery_bet_summary_kombinasi`;
drop table if exists `game_oc_lottery_bet_summary_macaushio`;
drop table if exists `game_oc_lottery_bet_summary_mistiklama`;
drop table if exists `game_oc_lottery_bet_summary_shio`;
drop table if exists `game_oc_lottery_bet_summary_silanghomo`;
drop table if exists `game_oc_lottery_bet_summary_taysen`;
drop table if exists `game_oc_lottery_bet_summary_tengahtepi`;

CREATE TABLE `game_oc_lottery_bet_summary_2d` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_2ddepan` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_2dtengah` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_3d` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_4d` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_5d` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_50-50` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_colokbebas` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_colokjitu` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_colokmacau` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_coloknaga` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=613 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_dasar` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_index` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_kembangkempiskembar` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_kombinasi` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no2` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_macaushio` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_mistiklama` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_shio` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_silanghomo` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_taysen` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

CREATE TABLE `game_oc_lottery_bet_summary_tengahtepi` (
`id` bigint NOT NULL AUTO_INCREMENT,
`agent_info_pkid` bigint DEFAULT NULL,
`member_username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`product_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`period_name` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_no` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
`bet_amount` decimal(14,2) DEFAULT NULL,
`prize` decimal(14,2) DEFAULT NULL,
`pre_payout` decimal(14,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `bet_no_idx` (`bet_no`),
KEY `sum_idx` (`product_name`,`period_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

drop table if exists `game_oc_lottery_master_num`;
CREATE TABLE `game_oc_lottery_master_num` (
`id` bigint NOT NULL AUTO_INCREMENT,
`num_5d` varchar(5) ,
`num_4d` varchar(4) ,
`num_3d` varchar(3) ,
`num_2d` varchar(2) ,
`posi1` varchar(10) ,
`posi2` varchar(10) ,
`posi3` varchar(10) ,
`posi4` varchar(10) ,
`posi5` varchar(10) ,
`tengahtepi` varchar(10) ,
`odds_even` varchar(10) ,
`big_small` varchar(10) ,
`shio` varchar(10) ,
`posi_2_odds_even` varchar(50) ,
`posi_3_odds_even` varchar(50) ,
`posi_4_odds_even` varchar(50) ,
`posi_5_odds_even` varchar(50) ,
`posi_2_big_small` varchar(50) ,
`posi_3_big_small` varchar(50) ,
`posi_4_big_small` varchar(50) ,
`posi_5_big_small` varchar(50) ,
`silang_homo_1` varchar(20) ,
`silang_homo_2` varchar(20) ,
`silang_homo_3` varchar(20) ,
`kembang_kempis_kembar_1` varchar(20) ,
`kembang_kempis_kembar_2` varchar(20) ,
`kembang_kempis_kembar_3` varchar(20) ,
`Kombinasi_1` varchar(100),
`Kombinasi_2` varchar(100),
`Kombinasi_3` varchar(100),
`Kombinasi_4` varchar(100),
`odds_even_5050` varchar(200) ,
`big_small_5050` varchar(200) ,
`colokjitu_as` varchar(50) ,
`colokjitu_kop` varchar(50) ,
`colokjitu_kepala` varchar(50) ,
`colokjitu_ekor` varchar(50) ,
`kombinasi_1_odds_even` varchar(50) ,
`kombinasi_2_odds_even` varchar(50) ,
`kombinasi_3_odds_even` varchar(50) ,
`kombinasi_4_odds_even` varchar(50) ,
`kombinasi_1_big_small` varchar(50) ,
`kombinasi_2_big_small` varchar(50) ,
`kombinasi_3_big_small` varchar(50) ,
`kombinasi_4_big_small` varchar(50) ,
PRIMARY KEY (`id`),
UNIQUE KEY `lottery_master_num_uk` (`num_5d`)
) ENGINE=InnoDB

Actions
Copy link

Also available in: Atom PDF