mysql_tables.txt
3.78 KB
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
CREATE TABLE `dtb_user_main` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '??ID',
`mobile` varchar(20) DEFAULT '' COMMENT '???',
`passwd` char(32) DEFAULT '' COMMENT '??',
`avatar` varchar(255) DEFAULT '' COMMENT '????',
`avatar_thumb` varchar(255) DEFAULT '' COMMENT '??(??APP?) ???',
`nick_name` varchar(20) DEFAULT '' COMMENT '??',
`gender` tinyint(1) unsigned DEFAULT '0' COMMENT '?? 0???/?? 1?? 2??',
`user_marks` varchar(60) DEFAULT '' COMMENT '????',
`diamond_num` int(11) unsigned DEFAULT '0' COMMENT '????',
`user_gold` int(11) unsigned DEFAULT '0' COMMENT '??????',
`games_max` int(11) unsigned DEFAULT '0' COMMENT '????????',
`clubs_max` int(11) unsigned DEFAULT '0' COMMENT '?????????',
`current_games` int(11) unsigned DEFAULT '0' COMMENT '?????????',
`current_clubs` int(11) unsigned DEFAULT '0' COMMENT '??????????',
`point` int(11) unsigned DEFAULT '0' COMMENT '????',
`reg_code` varchar(8) DEFAULT '' COMMENT '?????',
`sale_code` varchar(8) DEFAULT '' COMMENT '?????',
`card_type` tinyint(1) unsigned DEFAULT '0' COMMENT '???? 0??? 1???2??(??)?3???(??)',
`token` varchar(200) DEFAULT '' COMMENT '????',
`device_type` tinyint(1) unsigned DEFAULT '0' COMMENT '?????0 ???? 1 ios 2 Android',
`reg_time` int(10) unsigned DEFAULT '0' COMMENT '????',
`last_login` int(10) unsigned DEFAULT '0' COMMENT '??????',
`is_online` tinyint(1) unsigned DEFAULT '0' COMMENT '???? 0 ?? 1??',
`room_id` int(20) NOT NULL DEFAULT '0' COMMENT '?????ID',
PRIMARY KEY (`id`),
UNIQUE KEY `reg_code` (`reg_code`),
UNIQUE KEY `sale_code` (`sale_code`) USING BTREE,
KEY `mobile` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
CREATE TABLE `dtb_table_data` (
`id` int(64) NOT NULL,
`start_time` int(64) NOT NULL,
`room_id` int(22) NOT NULL,
`bb_value` int(10) NOT NULL,
`board` char(60) NOT NULL,
`total_pot` int(10) NOT NULL,
`end_time` int(64) NOT NULL,
`bb_seatid` int(10) NOT NULL,
`co_seatid` int(10) NOT NULL,
`dealer_seatid` int(10) NOT NULL,
`sb_seatid` int(10) NOT NULL,
`players` varchar(1024) NOT NULL,
`preflop_process` varchar(2048) DEFAULT NULL,
`flop_process` varchar(2048) DEFAULT NULL,
`turn_process` varchar(2048) DEFAULT NULL,
`river_process` varchar(2048) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `dtb_table_round` (
`id` bigint(64) unsigned NOT NULL AUTO_INCREMENT COMMENT '??ID',
`room_id` int(16) NOT NULL,
`OwnerID` int(12) unsigned NOT NULL DEFAULT '0' COMMENT '???ID',
`club_id` int(12) NOT NULL DEFAULT '0' COMMENT '???ID',
`table_name` varchar(64) NOT NULL DEFAULT '' COMMENT '????',
`sb` int(16) NOT NULL DEFAULT '0' COMMENT '?????',
`bb` int(16) NOT NULL DEFAULT '0' COMMENT '?????',
`buyin_min` int(12) unsigned NOT NULL DEFAULT '0' COMMENT '????',
`buyin_max` int(12) unsigned NOT NULL DEFAULT '0' COMMENT '????',
`table_players` int(12) NOT NULL DEFAULT '0' COMMENT '???????(??????,??????)',
`is_Start` int(12) NOT NULL DEFAULT '0' COMMENT '???????????',
`game_time` int(12) unsigned NOT NULL DEFAULT '0' COMMENT '????',
`mode` int(12) unsigned DEFAULT '0' COMMENT '??????',
`player_count` int(12) unsigned DEFAULT '0' COMMENT '??????',
`buyin_control` int(12) unsigned DEFAULT '0' COMMENT '??',
`insurance` int(12) unsigned DEFAULT '0' COMMENT '??',
`anti_cheating` int(12) unsigned DEFAULT '0' COMMENT '??',
`straddle` int(12) unsigned DEFAULT '0' COMMENT '??',
`rand_seat` int(12) unsigned DEFAULT '0' COMMENT '??',
`ante` int(12) unsigned DEFAULT '0' COMMENT '??',
`_data` varchar(2048) DEFAULT NULL COMMENT '????????',
`max_pot` int(10) NOT NULL DEFAULT '0' COMMENT '???????POT',
PRIMARY KEY (`id`),
KEY `creater_id` (`insurance`) USING BTREE,
KEY `area_id` (`anti_cheating`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;