function uc_stock_schema in Ubercart 6.2
Same name and namespace in other branches
- 8.4 uc_stock/uc_stock.install \uc_stock_schema()
- 7.3 uc_stock/uc_stock.install \uc_stock_schema()
Implements hook_schema().
File
- uc_stock/
uc_stock.install, line 11 - Install, update and uninstall functions for the uc_stock module.
Code
function uc_stock_schema() {
$schema = array();
$schema['uc_product_stock'] = array(
'description' => 'Stock levels for Ubercart products.',
'fields' => array(
'sku' => array(
'description' => 'SKU (Stock Keeping Unit) of a product.',
'type' => 'varchar',
'length' => '255',
'not null' => TRUE,
'default' => '',
),
'nid' => array(
'description' => 'Node ID of a product.',
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
'active' => array(
'description' => 'Boolean flag indicating whether stock is being tracked for this product. 1 => Yes. 0 => No.',
'type' => 'int',
'size' => 'tiny',
'unsigned' => TRUE,
'not null' => TRUE,
'default' => 0,
),
'stock' => array(
'description' => 'Quantity in stock.',
'type' => 'int',
'size' => 'medium',
'not null' => TRUE,
'default' => 0,
),
'threshold' => array(
'description' => 'Minimum quantity threshold level.',
'type' => 'int',
'size' => 'medium',
'not null' => TRUE,
'default' => 0,
),
),
'indexes' => array(
'nid' => array(
'nid',
),
),
'primary key' => array(
'sku',
),
);
return $schema;
}