Difference between revisions of "Old Wiki:Lpstore"
Jump to navigation
Jump to search
(Bot: Automated import of articles) |
(No difference)
|
Latest revision as of 16:27, 3 April 2021
lpstore
Description of the lpstore Table in the EVEmu database.
| Field Name | Field Type | Nullable | Key |
|---|---|---|---|
| 'storeID' | int(5) unsigned | NOT NULL | PRIMARY |
| 'corporationID' | int(10) | NOT NULL | |
| 'typeID' | int(10) | NOT NULL | |
| 'quantity' | int(10) | NOT NULL | |
| 'lpCost' | int(10) | NOT NULL | |
| 'iskCost' | int(10) | NOT NULL |
Description of the fields
'storeID'
This is the StoreID in the table Lprequireditems. Incremental for every offer.
'corporationID'
The corporationID of the item(s) needed to purchase. Refers to the corporation table.
'typeID'
The typeID of the item given. Refers to the invtypes table.
'quantity'
The quantity of the items (typeID) given.
'lpCost'
The Loyalty Points (LP) needed to make a purchase.
'iskCost'
The ISK needed to make a purchase.