function uc_product_power_tools_update_4 in Ubercart Product Power Tools 6.2

Same name and namespace in other branches

1. 6 uc_product_power_tools.install \uc_product_power_tools_update_4()

File

./uc_product_power_tools.install, line 312

Install, update, and uninstall functions for the uc_product_power_tools module.

Code

function uc_product_power_tools_update_4() {
  return array(
    update_sql("ALTER TABLE `uc_power_tools` CHANGE `asku` `asku` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', " . "CHANGE `asku-settings` `asku-settings` TEXT NULL DEFAULT NULL, " . "CHANGE `lp` `lp` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', " . "CHANGE `lp-settings` `lp-settings` DECIMAL(15,3) NOT NULL DEFAULT '0.000', " . "CHANGE `cost` `cost` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', " . "CHANGE `cost-settings` `cost-settings` DECIMAL(15,3) NOT NULL DEFAULT '0.000', " . "CHANGE `sp` `sp` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', " . "CHANGE `sp-settings` `sp-settings` DECIMAL(15,3) NOT NULL DEFAULT '0.000', " . "CHANGE `dq` `dq` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', " . "CHANGE `dq-settings` `dq-settings` INT(11) NOT NULL DEFAULT '1', " . "CHANGE `pq` `pq` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', " . "CHANGE `pq-settings` `pq-settings` INT(11) NOT NULL DEFAULT '1', " . "CHANGE `ship` `ship` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', " . "CHANGE `lpos` `lpos` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', " . "CHANGE `lpos-settings` `lpos-settings` INT(10) UNSIGNED NOT NULL DEFAULT '0', " . "CHANGE `stock` `stock` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0', " . "CHANGE `stock-settings` `stock-settings` INT(10) UNSIGNED NOT NULL DEFAULT '0', " . "CHANGE `stock-threshold` `stock-threshold` INT(10) UNSIGNED NOT NULL DEFAULT '0'"),
  );
}