upgrade script for 1.4.6??

Code: Select all

// Add "invoice_id" to order table
$sql = "DESC `" . DB_PREFIX . "order` invoice_id";
$query = $db->query($sql);
if (!$query->num_rows) {
	$sql = "
	ALTER TABLE `" . DB_PREFIX . "order` ADD COLUMN `invoice_id` int(11) collate utf8_unicode_ci NOT NULL Default '0';
	";
}
$db->query($sql);

// Add "invoice_prefix" to order table
$sql = "DESC `" . DB_PREFIX . "order` invoice_prefix";
$query = $db->query($sql);
if (!$query->num_rows) {
	$sql = "
	ALTER TABLE `" . DB_PREFIX . "order` ADD COLUMN `invoice_prefix` varchar(10) collate utf8_bin NOT NULL;
	";
}
$db->query($sql);

Code: Select all

-- Table structure for table `oc_order`
--

DROP TABLE IF EXISTS `oc_order`;
CREATE TABLE `oc_order` (
  `order_id` int(11) NOT NULL auto_increment,
  `invoice_id` int(11) NOT NULL default '0',
  `invoice_prefix` varchar(10) collate utf8_bin NOT NULL,

Code: Select all

1.4.5 > 1.4.6

To Upgrade:
1. First off backup your entire site.
2. Goto your opencart's store admin and download a backup of your database.
3. Upload and replace the files from the OpenCart 1.4.4 download to your OpenCart 1.4.5 installation.
4. Copy & replace the config files for bolth the root directory and the admin from your old install to your new installation.
5. Open your DB manager and run this code:


INSERT INTO `opencart_dev`.`shop_setting` (
`setting_id` ,
`group` ,
`key` ,
`value` 
)
VALUES (
NULL , 'config', 'config_language', 'en'
);





1.4.4 > 1.4.5

To Upgrade:
1. First off backup your entire site.
2. Goto your opencart's store admin and download a backup of your database.
3. Upload and replace the files from the OpenCart 1.4.4 download to your OpenCart 1.4.5 installation.
4. Copy & replace the config files for bolth the root directory and the admin from your old install to your new installation.
5. Open your DB manager and run this code:

ALTER TABLE `shop_store` DROP `stock_status_id`; 
ALTER TABLE `shop_customer` ADD `store_id` INT( 11 ) NOT NULL DEFAULT '0' AFTER `customer_id`;
ALTER TABLE `shop_order` ADD `invoice_id` INT( 11 ) NOT NULL DEFAULT '0' AFTER `order_id`;  
ALTER TABLE `shop_order` ADD `invoice_prefix` VARCHAR( 10 ) NOT NULL AFTER `invoice_id`;