Item categoriesTable: Difference between revisions

Latest revision as of 12:23, 11 January 2022


Field	Type	Key Type	Default	Extra	Description
category_id	int(8) unsigned	PRI		auto_increment
name	varchar(20)
item_stat_id_repair_tool	int(11)
is_repair_tool_consumed	char(1)		Y
skill_id_repair	int(11)
repair_difficulty_pct	int(3) unsigned		100		Difficulty amount when repairing this item category (passed to the repair scripts)
identify_skill_id	int(10)
identify_min_skill	int(8) unsigned

@@ Line 1: / Line 1: @@
-{| border=1
+{| class="wikitable"
+|+
+!UE
+!Field
+!Type
+!Key Type
+!Default
+!Extra
+!Description
 |-
-! field
+|
-! type
+|category_id
-! foreign key
+|int(8) unsigned
-! description
+|PRI
+|
+|auto_increment
+|
 |-
-| category_id
+|
-| int(8) unsigned
+|name
+|varchar(20)
+|
+|
+|
 |
+|-
+|
+|item_stat_id_repair_tool
+|int(11)
+|
 |
+|
+|
 |-
-| name
-| varchar(20)
 |
+|is_repair_tool_consumed
+|char(1)
 |
+|Y
+|
+|
 |-
-| item_stat_id_repair_tool
+|
-| int(11)
+|skill_id_repair
+|int(11)
+|
+|
+|
 |
+|-
 |
+|repair_difficulty_pct
+|int(3) unsigned
+|
+|100
+|
+|Difficulty amount when repairing this item category (passed to the repair scripts)
 |-
-| is_repair_tool_consumed
+|
-| char(1)
+|identify_skill_id
-| N
+|int(10)
-| (Y/N)
+|
-|-
-| skill_id_repair
-| int(11)
 |
 |
+|
 |-
-| identify_skill_id
-| int(10)
 |
+|identify_min_skill
+|int(8) unsigned
 |
-|-
-| identify_min_skill
-| int(8) unsigned
 |
 |
+|
 |}
 [[Category:Engine documents]]