PokemonWithJava/databaseScript.sql at master · rhrcastro/PokemonWithJava · GitHub

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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
CREATE TABLE pn_member(
id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(32),
password VARCHAR(32),
dob VARCHAR(32),
email VARCHAR(32),
lastLoginTime VARCHAR(32),
lastLoginServer VARCHAR(32),
lastLoginIP VARCHAR(15),
lastLanguageUsed INTEGER,
sprite INTEGER,
party INTEGER,
money INTEGER,
skHerb INTEGER,
skCraft INTEGER,
skFish INTEGER,
skTrain INTEGER,
skCoord INTEGER,
skBreed INTEGER,
x INTEGER,
y INTEGER,
mapX INTEGER,
mapY INTEGER,
badges VARCHAR,
healX INTEGER,
healY INTEGER,
healMapX INTEGER,
healMapY INTEGER,
isSurfing BOOLEAN,
muted BOOLEAN,
adminLevel INTEGER
);
CREATE TABLE pn_bag(
member INTEGER NOT NULL,
item INTEGER NOT NULL,
quantity INTEGER NOT NULL
);
CREATE TABLE pn_party(
id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
member INTEGER,
pokemon0 INTEGER,
pokemon1 INTEGER,
pokemon2 INTEGER,
pokemon3 INTEGER,
pokmeon4 INTEGER,
pokemon5 INTEGER
);
CREATE TABLE pn_pokemon(
id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(32),
speciesName VARCHAR(32),
exp FLOAT,
baseExp INTEGER,
expType VARCHAR(32),
isFainted BOOLEAN,
level INTEGER,
happiness INTEGER,
gender INTEGER,
nature VARCHAR(16),
abilityName VARCHAR(32),
itemName VARCHAR(32),
isShiny BOOLEAN,
originalTrainerName VARCHAR(32),
currentTrainerName VARCHAR(32),
contestStats VARCHAR(32),
move0 VARCHAR(16),
move1 VARCHAR(16),
move2 VARCHAR(16),
move3 VARCHAR(16),
hp INTEGER,
atk INTEGER,
def INTEGER,
speed INTEGER,
spATK INTEGER,
spDEF INTEGER,
evHP INTEGER,
evDEF INTEGER,
evSPD INTEGER,
evSPATK INTEGER,
evSPED INTEGR,
ivHP INTEGER,
ivATK INTEGER,
ivDEF INTEGER,
ivSPD INTEGER,
ivSPATK INTEGER,
ivSPDEF INTEGER,
pp0 INTEGER,
pp1 INTEGER,
pp2 INTEGER,
pp3 INTEGER,
maxpp0 INTEGER,
maxpp1 INTEGER,
maxpp3 INTEGER,
ppUp0 INTEGER,
ppUp1 INTEGER,
ppUp2 INTEGER,
ppUp3 INTEGER,
date DATE
);
CREATE TABLE pn_bans(
ip VARCHAR(16)
);
CREATE TABLE pn_history(
member INTEGER,
action INTEGER,
with INTEGER,
timestamps DATETIME,
details VARCHAR(32)
);
CREATE TABLE pn_box(
id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
member INTEGER,
pokemon0 INTEGER NOT NULL DEFAULT -1,
pokemon1 INTEGER NOT NULL DEFAULT -1,
pokemon2 INTEGER NOT NULL DEFAULT -1,
pokemon3 INTEGER NOT NULL DEFAULT -1,
pokemon4 INTEGER NOT NULL DEFAULT -1,
pokemon5 INTEGER NOT NULL DEFAULT -1,
pokemon6 INTEGER NOT NULL DEFAULT -1,
pokemon7 INTEGER NOT NULL DEFAULT -1,
pokemon8 INTEGER NOT NULL DEFAULT -1,
pokemon9 INTEGER NOT NULL DEFAULT -1,
pokemon10 INTEGER NOT NULL DEFAULT -1,
pokemon11 INTEGER NOT NULL DEFAULT -1,
pokemon12 INTEGER NOT NULL DEFAULT -1,
pokemon13 INTEGER NOT NULL DEFAULT -1,
pokemon14 INTEGER NOT NULL DEFAULT -1,
pokemon15 INTEGER NOT NULL DEFAULT -1,
pokemon16 INTEGER NOT NULL DEFAULT -1,
pokemon17 INTEGER NOT NULL DEFAULT -1,
pokemon18 INTEGER NOT NULL DEFAULT -1,
pokemon19 INTEGER NOT NULL DEFAULT -1,
pokemon20 INTEGER NOT NULL DEFAULT -1,
pokemon21 INTEGER NOT NULL DEFAULT -1,
pokemon22 INTEGER NOT NULL DEFAULT -1,
pokemon23 INTEGER NOT NULL DEFAULT -1,
pokemon24 INTEGER NOT NULL DEFAULT -1,
pokemon25 INTEGER NOT NULL DEFAULT -1,
pokemon26 INTEGER NOT NULL DEFAULT -1,
pokemon27 INTEGER NOT NULL DEFAULT -1,
pokemon28 INTEGER NOT NULL DEFAULT -1,
pokemon29 INTEGER NOT NULL DEFAULT -1
);