configuration

Description

Additional settings for shop.

Definition

Name Type Constraint Description
shop TEXT PRIMARY KEY Shop ID. (shop.username)
counting_method INTEGER NOT NULL Inserting a product to cart piece by piece or inserting some products at once specified by quantity.
  • 0: Piece by piece
  • 1: Specifying by quantity
stock INTEGER NOT NULL Whether to be able to specify a stock or not.
  • 0: Disable to specify.
  • 1: Enable to specify.
account_activation INTEGER NOT NULL Whether a customer have to activate his/her account after account registration or not. Activation is accessing an URL written on account activation mail.
  • 0: No activation.
  • 1: Use activation.
cart_capacity INTEGER NOT NULL Maximum number of products that cart can have. If the value is 0, the cart can have any number of products.
product_duplicable INTEGER NOT NULL

The cart can have several identical products at once or not.

As of Mar. 27th 2008, this value is used when the counting_method is 0 (piece by piece addition.)

  • 0: It eliminates identical products
  • 1: It doesn't eliminate identical products, which is regarded as different product.

Note: Definition of identical products is subtle. Affair exists at whether products, which have same product_id, has different options are identical or not. As of Mar. 27th 2008, products have different options are identical.

download INTEGER NOT NULL Do download sales or not.
  • 0: Direct sales.
  • 1: Download sales.
trackback INTEGER NOT NULL Receive trackbacking or not.
  • 0: Not receive.
  • 1: Receive.

Realted tables

Query

CREATE TABLE configuration(
shop                TEXT     PRIMARY KEY,
counting_method     INTEGER  NOT NULL,
stock               INTEGER  NOT NULL,
account_activation  INTEGER  NOT NULL,
cart_capacity       INTEGER  NOT NULL,
product_duplicable  INTEGER  NOT NULL,
download            INTEGER  NOT NULL,
trackback           INTEGER  NOT NULL
);