Trade transformationsTable: Difference between revisions
		
		
		
		Jump to navigation
		Jump to search
		
| m add to category (Engine documents) | No edit summary | ||
| Line 1: | Line 1: | ||
| {|  | {| class="wikitable" | ||
| |+ | |||
| !UE | |||
| !Field | |||
| !Type | |||
| !Key Type | |||
| !Default | |||
| !Extra | |||
| !Description | |||
| |- | |- | ||
| | | |||
| |id | |||
| |int(10) unsigned | |||
| |PRI | |||
| | | |||
| |auto_increment | |||
| |  | |||
| |- | |- | ||
| |  | | | ||
| |  | |pattern_id | ||
| |   | |int(10) unsigned | ||
| |   | | | ||
| | | |||
| | | |||
| |pattern for the transformation  | |||
| |- | |- | ||
| |  | | | ||
| |  | |process_id | ||
| |   | |int(10) unsigned | ||
| |   | | | ||
| | | |||
| | | |||
| |process for transformation  | |||
| |- | |- | ||
| |  | | | ||
| |  | |result_id | ||
| |   | |int(10) unsigned | ||
| |   | | | ||
| | | |||
| | | |||
| |resulting item  | |||
| |- | |- | ||
| |  | | | ||
| |  | |result_qty | ||
| |   | |int(8) unsigned | ||
| |   | | | ||
| | | |||
| | | |||
| |resulting item quantity  | |||
| |- | |- | ||
| |  | | | ||
| |  | |item_id | ||
| |   | |int(10) unsigned | ||
| |   | | | ||
| | | |||
| | | |||
| |item to be transformed  | |||
| |- | |- | ||
| |  | | | ||
| |  | |item_qty | ||
| |   | |int(8) unsigned | ||
| |   | | | ||
| | | |||
| | | |||
| |required quantity for transformation  | |||
| |- | |- | ||
| |  | | | ||
| |  | |trans_points | ||
| |   | |varchar(255) | ||
| |   | | | ||
| |0 | |||
| | | |||
| |ammount of time to complete transformation  | |||
| |- | |- | ||
| |  | | | ||
| |  | |penalty_pct | ||
| |   | |float(10,6) | ||
| |   | | | ||
| |1.000000 | |||
| | | |||
| |percent of quality for resulting item  | |||
| |- | |- | ||
| |  | | | ||
| |  | |description | ||
| |   | |varchar(255) | ||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | |ADD | ||
| |  | |present_in_book | ||
| |   | |tinyint(4) | ||
| |   | | | ||
| |1 | |||
| | | |||
| |If true, this transform will be present in the crafting book  | |||
| |} | |} | ||
| [[Category:Engine documents]] | [[Category:Engine documents]] | ||
Latest revision as of 13:25, 11 January 2022
| UE | Field | Type | Key Type | Default | Extra | Description | 
|---|---|---|---|---|---|---|
| id | int(10) unsigned | PRI | auto_increment | |||
| pattern_id | int(10) unsigned | pattern for the transformation | ||||
| process_id | int(10) unsigned | process for transformation | ||||
| result_id | int(10) unsigned | resulting item | ||||
| result_qty | int(8) unsigned | resulting item quantity | ||||
| item_id | int(10) unsigned | item to be transformed | ||||
| item_qty | int(8) unsigned | required quantity for transformation | ||||
| trans_points | varchar(255) | 0 | ammount of time to complete transformation | |||
| penalty_pct | float(10,6) | 1.000000 | percent of quality for resulting item | |||
| description | varchar(255) | |||||
| ADD | present_in_book | tinyint(4) | 1 | If true, this transform will be present in the crafting book |