Comment 3 for bug 526380

Hi Blueyed,

The following plugin table is how I found it :

[code]
 function GetDbLayout()
 {
  $layout = array( 'CREATE TABLE IF NOT EXISTS '.$this->get_sql_table( 'inventory' ).' (
    inv_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    inv_shop_ID INT(10) UNSIGNED NOT NULL,
    inv_sku VARCHAR(255) NOT NULL,
    inv_price Float(10,2) NOT NULL,
    inv_weight DECIMAL(10,4) NOT NULL,
    inv_stock INT(10) UNSIGNED NULL,
    inv_created DATETIME NOT NULL,
    inv_updated DATETIME NOT NULL,
    PRIMARY KEY (inv_ID),
    KEY inv_sku (inv_sku),
    KEY inv_shop_ID (inv_shop_ID)
    )',
[/code]

Thanks for looking into it :D

¥