Stock by Attributes - use a prefix such as "zen_"
Ok just trying to add this mod to my site..
Stock by Attributes v4.7a
And they are telling me if i have a prfix such as "zen_" i have to fix the .sql up.. HOW do i do this as this is my config file...
Code:
/ define our database connection
define('DB_TYPE', 'mysql');
define('DB_PREFIX', 'zen_');
and here is the stock_attribute.sql update file
Code:
CREATE TABLE products_with_attributes_stock (
stock_id INT NOT NULL AUTO_INCREMENT ,
products_id INT NOT NULL ,
stock_attributes VARCHAR( 255 ) NOT NULL ,
quantity FLOAT NOT NULL ,
PRIMARY KEY ( `stock_id` )
);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value,
configuration_description, configuration_group_id, sort_order,
last_modified, date_added, use_function, set_function)
VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false',
'When customer places more items in cart than are available, show the available amount on the shopping cart page:',
'9',
'6',
NULL,
now(),
NULL,
"zen_cfg_select_option(array('true', 'false'),"
);
What do i DO???