id |
int(11)
|
|
|
|
name |
varchar(50)
|
utf8mb4_general_ci
|
|
|
faction |
enum('alliance', 'berserker', 'undead', 'guardian', 'divine')
|
utf8mb4_general_ci
|
|
|
class |
enum('attacker', 'defender', 'support')
|
utf8mb4_general_ci
|
|
|
rarity |
enum('common', 'rare', 'epic', 'legendary')
|
utf8mb4_general_ci
|
|
|
hp |
int(11)
|
|
|
|
mp |
int(11)
|
|
|
|
damage |
int(11)
|
|
|
|
abilities |
longtext
|
utf8mb4_general_ci
|
|
|
image |
varchar(255)
|
utf8mb4_general_ci
|
|
|
class_bonus |
varchar(100)
|
utf8mb4_general_ci
|
|
|
user_id |
int(10)
|
|
|
|
warrior_id |
int(10)
|
|
|
|
level |
int(11)
|
|
|
|
experience |
int(11)
|
|
|
|
weapon_id |
int(11)
|
|
|
|
armor_id |
int(11)
|
|
|
|
accessory_id |
int(11)
|
|
|
|