Trade transformationsTable
| 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 |