lbs

Tables

======================================================================
Name: lbs_pricing_sitewide   - This will store the site wide pricing multiplier per client

Fields:
-->client_id(PK) - Client ID
-->sitewide_multiplier - Sitewide multiplier

When the client fills in a value in the pricing config page - we write to this table.
If he changes the value - we update the records. If he removes the value - we remove the record.

======================================================================

Name: lbs_pricing_vocab_priority - this will store the priority of vocabularies and status ON/FF (whether priority should be used or just stored for convenience in case client wants to turn it back on later and not re-input the value)

Fields:
-->client_id(PK) - Client ID
-->vocab_id - Taxonomy vocabulary ID
-->status - Status ON/OFF (int), default 0
-->priority - Vocabulary priority value, int default NULL



======================================================================

Name: lbs_pricing_term_settings  - this will store price settings per term per user

Fields:
-->client_id(PK) - Client ID
-->term_id  - taxonomy term id
-->vocab_id - vocabulary id
-->pricing_status = Status ON/OFF (int), default 0
-->pricing_multiplier = multiplier of the price for the term, default NULL
-->pricing_fixed - value of the fixed price , default NULL
======================================================================

Name: lbs_pricing_product_fixed_price - this will store fixed price per product per user
Fields:
-->client_id(PK) - Client ID
-->product_id - product id
—->fixed_price_status = ON/OFF , whether fixed price is on or off
—->fixed_price_value - value of the fixed price.