Old Wiki:Lpstore
Jump to navigation
Jump to search
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.