forked from najsword/serverOne
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathcreate.sql
More file actions
51 lines (47 loc) · 994 Bytes
/
Copy pathcreate.sql
File metadata and controls
51 lines (47 loc) · 994 Bytes
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
create table tb_normal_account
(
player_id int(20),
telephone varchar(255),
account varchar(255),
password varchar(255),
create_time int(20),
PRIMARY KEY (`player_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
create table tb_player
(
player_id int(20),
head_id int(20),
head_url varchar(255),
nickname varchar(255),
sex int(2),
gold int(20),
create_time int(20),
PRIMARY KEY (`player_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
create table tb_visitor_account
(
player_id int(20),
visit_token varchar(255),
create_time int(20),
PRIMARY KEY (`player_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
create table tb_weixin_account
(
player_id int(20),
union_id varchar(255),
create_time int(20),
PRIMARY KEY (`player_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
create table tb_role
(
role_id int(20),
player_id int(20),
game_id int(20),
head_id int(20),
head_url varchar(255),
nickname varchar(255),
sex int(2),
gold int(20),
create_time int(20),
PRIMARY KEY (`role_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;