Item categoriesTable - Revision history

Grimston at 12:23, 11 January 2022

2022-01-11T12:23:10Z

← Older revision		Revision as of 12:23, 11 January 2022
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]]		[[Category:Engine documents]]

Ethryn: add to category (Engine documents)

2010-10-23T00:20:07Z

add to category (Engine documents)

← Older revision		Revision as of 00:20, 23 October 2010
Line 41:		Line 41:
	\|		\|
	\|}		\|}


			[[Category:Engine documents]]

Talad: Created page with '{| border=1 |- ! field ! type ! foreign key ! description |- | category_id | int(8) unsigned | | |- | name | varchar(20) | | |- | item_stat_id_repair_tool | int(11) | | |- | is…'

2010-10-12T22:23:02Z

Created page with '{| border=1 |- ! field ! type ! foreign key ! description |- | category_id | int(8) unsigned | | |- | name | varchar(20) | | |- | item_stat_id_repair_tool | int(11) | | |- | is…'

New page

{| border=1
|-
! field
! type
! foreign key
! description
|-
| category_id
| int(8) unsigned
|
|
|-
| name
| varchar(20)
|
|
|-
| item_stat_id_repair_tool
| int(11)
|
|
|-
| is_repair_tool_consumed
| char(1)
| N
| (Y/N)
|-
| skill_id_repair
| int(11)
|
|
|-
| identify_skill_id
| int(10)
|
|
|-
| identify_min_skill
| int(8) unsigned
|
|
|}