Trade transformationsTable - Revision history

Grimston at 13:25, 11 January 2022

2022-01-11T13:25:13Z

← Older revision		Revision as of 13:25, 11 January 2022
Line 1:		Line 1:
	{\| ~~border~~="1"		{\| class="wikitable"
			\|+
			!UE
			!Field
			!Type
			!Key Type
			!Default
			!Extra
			!Description
	\|-		\|-
	~~! field~~		\|
	~~! type~~		\|id
	~~! foreign key~~		\|int(10) unsigned
	~~! description~~		\|PRI
			\|
			\|auto_increment
			\|
	\|-		\|-
	\| id		\|
	\| ~~integer~~		\|pattern_id
	\|		\|int(10) unsigned
	\|		\|
			\|
			\|
			\|pattern for the transformation
	\|-		\|-
	\| ~~pattern_id~~		\|
	\| ~~integer~~		\|process_id
	\|		\|int(10) unsigned
	\|		\|
			\|
			\|
			\|process for transformation
	\|-		\|-
	\| ~~process_id~~		\|
	\| ~~integer~~		\|result_id
	\|		\|int(10) unsigned
	\|		\|
			\|
			\|
			\|resulting item
	\|-		\|-
	\| ~~result_id~~		\|
	\| ~~integer~~		\|result_qty
	\|		\|int(8) unsigned
	\|		\|
			\|
			\|
			\|resulting item quantity
	\|-		\|-
	\| ~~result_qty~~		\|
	\| ~~integer~~		\|item_id
	\|		\|int(10) unsigned
	\|		\|
			\|
			\|
			\|item to be transformed
	\|-		\|-
	\| ~~item_id~~		\|
	\| ~~integer~~		\|item_qty
	\|		\|int(8) unsigned
	\|		\|
			\|
			\|
			\|required quantity for transformation
	\|-		\|-
	\| ~~item_qty~~		\|
	\| ~~integer~~		\|trans_points
	\|		\|varchar(255)
	\|		\|
			\|0
			\|
			\|ammount of time to complete transformation
	\|-		\|-
	\| ~~trans_points~~		\|
	\| ~~integer~~		\|penalty_pct
	\|		\|float(10,6)
	\|		\|
			\|1.000000
			\|
			\|percent of quality for resulting item
	\|-		\|-
	\| ~~penilty_pct~~		\|
	\| ~~real~~		\|description
	\|		\|varchar(255)
			\|
			\|
			\|
	\|		\|
	\|-		\|-
	\| ~~description~~		\|ADD
	\| ~~varchar~~		\|present_in_book
	\|		\|tinyint(4)
	\|		\|
			\|1
			\|
			\|If true, this transform will be present in the crafting book
	\|}		\|}


	[[Category:Engine documents]]		[[Category:Engine documents]]

Ethryn: add to category (Engine documents)

2010-10-23T00:19:53Z

add to category (Engine documents)

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


			[[Category:Engine documents]]

Talad: Created page with '{| border="1" |- ! field ! type ! foreign key ! description |- | id | integer | | |- | pattern_id | integer | | |- | process_id | integer | | |- | result_id | integer | | …'

2010-10-12T22:21:30Z

Created page with '{| border="1" |- ! field ! type ! foreign key ! description |- | id | integer | | |- | pattern_id | integer | | |- | process_id | integer | | |- | result_id | integer | | …'

New page

{| border="1"
|-
! field
! type
! foreign key
! description
|-
| id
| integer
|
|
|-
| pattern_id
| integer
|
|
|-
| process_id
| integer
|
|
|-
| result_id
| integer
|
|
|-
| result_qty
| integer
|
|
|-
| item_id
| integer
|
|
|-
| item_qty
| integer
|
|
|-
| trans_points
| integer
|
|
|-
| penilty_pct
| real
|
|
|-
| description
| varchar
|
|
|}