View source for Old Wiki:Lpstore

__NOTOC____NOEDITSECTION__
<div id="mw-content-text" class="mw-content-ltr" lang="en" dir="ltr">

== <span id="lpstore" class="mw-headline"> lpstore </span> ==

Description of the lpstore Table in the EVEmu [[Category_EVE_Database.html|database]].

<br />


{|
! '''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'''

<br />
''''storeID''''

This is the StoreID in the table [[Lprequireditems.html|Lprequireditems]]. Incremental for every offer.

<br />
''''corporationID''''

The corporationID of the item(s) needed to purchase. Refers to the [http://wiki.evemu.dev/index.php?title=Corporation&action=edit&redlink=1 corporation] table.

<br />
''''typeID''''

The typeID of the item given. Refers to the [[Invtypes.html|invtypes]] table.

<br />
''''quantity''''

The quantity of the items (typeID) given.

<br />
''''lpCost''''

The Loyalty Points (LP) needed to make a purchase.

<br />
''''iskCost''''

The ISK needed to make a purchase.


</div>