Updating an existing Opencart database from v2.1.0.2 to v2.3.0.2/v2.3.0.3rc

opencart-v2102_to_v2303rc_post.sql

-- retains stale tables and fields in the vent of downgrading.

ALTER TABLE `oc_dm_address`
  MODIFY `country_id` INT(11) NOT NULL DEFAULT '0',
  MODIFY `zone_id` INT(11) NOT NULL DEFAULT '0'
;

ALTER TABLE `oc_dm_affiliate_activity` 
  CHANGE COLUMN activity_id affiliate_activity_id  INT(11) NOT NULL AUTO_INCREMENT
;

ALTER TABLE `oc_dm_banner_image` 
  ADD title VARCHAR(64) NOT NULL
    AFTER banner_id,
  ADD language_id INT(11) NOT NULL
    AFTER banner_id,
  MODIFY sort_order INT(3) NOT NULL DEFAULT '0'
;

UPDATE `oc_dm_banner_image` SET title = SUBSTRING_INDEX(image, '\\', -1) WHERE title = '';
UPDATE `oc_dm_banner_image` SET language_id = 1 WHERE language_id = 0;

ALTER TABLE `oc_dm_cart` 
  ADD `api_id` INT(11) NOT NULL
    AFTER cart_id,
  MODIFY `cart_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  ADD KEY `cid` (`api_id`,`customer_id`,`session_id`,`product_id`,`recurring_id`)
;

ALTER TABLE `oc_dm_category`
  MODIFY `parent_id` INT(11) NOT NULL DEFAULT '0',
  MODIFY `sort_order` INT(3) NOT NULL DEFAULT '0'
;
-- stale field: sitemap_file


ALTER TABLE `oc_dm_coupon`
  MODIFY `code` VARCHAR(20) NOT NULL
;

ALTER TABLE `oc_dm_custom_field` 
  ADD `validation` VARCHAR(255) NOT NULL
    AFTER VALUE
;
-- stale fields: required, position


ALTER TABLE `oc_dm_customer` 
  ADD `code` VARCHAR(40) NOT NULL
    AFTER token,
  MODIFY `store_id` INT(11) NOT NULL DEFAULT '0',
  MODIFY `newsletter` TINYINT(1) NOT NULL DEFAULT '0',
  MODIFY `address_id` INT(11) NOT NULL DEFAULT '0'
;

ALTER TABLE `oc_dm_customer_activity`
  CHANGE COLUMN activity_id `customer_activity_id` INT(11) NOT NULL AUTO_INCREMENT
;

ALTER TABLE `oc_dm_customer_reward`
  MODIFY `customer_id` INT(11) NOT NULL DEFAULT '0',
  MODIFY `order_id` INT(11) NOT NULL DEFAULT '0',
  MODIFY `points` INT(8) NOT NULL DEFAULT '0'
;

CREATE TABLE `oc_dm_customer_search` (
  `customer_search_id` INT(11) NOT NULL AUTO_INCREMENT,
  `store_id` INT(11) NOT NULL,
  `language_id` INT(11) NOT NULL,
  `customer_id` INT(11) NOT NULL,
  `keyword` VARCHAR(255) NOT NULL,
  `category_id` INT(11) DEFAULT NULL,
  `sub_category` TINYINT(1) NOT NULL,
  `description` TINYINT(1) NOT NULL,
  `products` INT(11) NOT NULL,
  `ip` VARCHAR(40) NOT NULL,
  `date_added` DATETIME NOT NULL,
  PRIMARY KEY (`customer_search_id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

ALTER TABLE `oc_dm_download`
  MODIFY `filename` VARCHAR(160) NOT NULL
;
-- stale field: remaining

ALTER TABLE `oc_dm_event` 
  ADD `date_added` DATETIME NOT NULL
    AFTER ACTION,
  ADD `status` TINYINT(1) NOT NULL
    AFTER ACTION
;
INSERT INTO `oc_dm_event` SET `trigger` = 'catalog/model/checkout/order/addOrderHistory/after', `code` = 'voucher', `action` = 'extension/total/voucher/send', `status` = 0, `date_added` = '0000-00-00 00:00:00';


-- --------------------------------------------------------
--
-- Taken from base install - extensions and mods would need to be reintegrated
--
-- Table structure for table `oc_extension`
--

DROP TABLE IF EXISTS `oc_dm_extension`;
CREATE TABLE `oc_dm_extension` (
  `extension_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(32) NOT NULL,
  `code` varchar(32) NOT NULL,
  PRIMARY KEY (`extension_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `oc_extension`
--

INSERT INTO `oc_dm_extension` (`extension_id`, `type`, `code`) VALUES
(1, 'payment', 'cod'),
(2, 'total', 'shipping'),
(3, 'total', 'sub_total'),
(4, 'total', 'tax'),
(5, 'total', 'total'),
(6, 'module', 'banner'),
(7, 'module', 'carousel'),
(8, 'total', 'credit'),
(9, 'shipping', 'flat'),
(10, 'total', 'handling'),
(11, 'total', 'low_order_fee'),
(12, 'total', 'coupon'),
(13, 'module', 'category'),
(14, 'module', 'account'),
(15, 'total', 'reward'),
(16, 'total', 'voucher'),
(17, 'payment', 'free_checkout'),
(18, 'module', 'featured'),
(19, 'module', 'slideshow'),
(20, 'theme', 'theme_default'),
(21, 'dashboard', 'activity'),
(22, 'dashboard', 'sale'),
(23, 'dashboard', 'recent'),
(24, 'dashboard', 'order'),
(25, 'dashboard', 'online'),
(26, 'dashboard', 'map'),
(27, 'dashboard', 'customer'),
(28, 'dashboard', 'chart');

-- --------------------------------------------------------


ALTER TABLE `oc_dm_information`
  MODIFY `bottom` INT(1) NOT NULL DEFAULT '0',
  MODIFY `sort_order` INT(3) NOT NULL DEFAULT '0'
;

ALTER TABLE `oc_dm_language`
  MODIFY `sort_order` INT(3) NOT NULL DEFAULT '0'
;
UPDATE `oc_dm_language` SET `code` = 'en-gb', `locale` = 'en-US,en_US.UTF-8,en_US,en-gb,english' WHERE `code` = 'en';
-- en to en-gb
-- stale field: filename

INSERT INTO `oc_dm_layout` SET `name` = 'Home';

ALTER TABLE `oc_dm_layout_route`
  MODIFY `route` VARCHAR(64) NOT NULL
;
INSERT INTO `oc_dm_layout_route` SET `layout_id` = 4, `store_id` = 0, `route` = '';

ALTER TABLE `oc_dm_length_class_description`
  MODIFY `length_class_id` INT(11) NOT NULL
;

ALTER TABLE `oc_dm_marketing`
  MODIFY `clicks` INT(5) NOT NULL DEFAULT '0'
;

CREATE TABLE `oc_dm_menu` (
  `menu_id` INT(11) NOT NULL AUTO_INCREMENT,
  `store_id` INT(11) NOT NULL,
  `type` VARCHAR(6) NOT NULL,
  `link` VARCHAR(255) NOT NULL,
  `sort_order` INT(3) NOT NULL,
  `status` TINYINT(1) NOT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

CREATE TABLE `oc_dm_menu_description` (
  `menu_id` INT(11) NOT NULL,
  `language_id` INT(11) NOT NULL,
  `name` VARCHAR(64) NOT NULL,
  PRIMARY KEY (`menu_id`,`language_id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

CREATE TABLE `oc_dm_menu_module` (
  `menu_module_id` INT(11) NOT NULL,
  `menu_id` INT(11) NOT NULL,
  `code` VARCHAR(64) NOT NULL,
  `sort_order` INT(3) NOT NULL,
  PRIMARY KEY (`menu_module_id`),
  KEY `menu_id` (`menu_id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

ALTER TABLE `oc_dm_modification`
  MODIFY `xml` MEDIUMTEXT NOT NULL
;
-- stale field: date_modified

ALTER TABLE `oc_dm_order`
  MODIFY `invoice_no` INT(11) NOT NULL DEFAULT '0',
  MODIFY `store_id` INT(11) NOT NULL DEFAULT '0',
  MODIFY `customer_id` INT(11) NOT NULL DEFAULT '0',
  MODIFY `customer_group_id` INT(11) NOT NULL DEFAULT '0',
  MODIFY `payment_company` VARCHAR(60) NOT NULL,
  MODIFY `shipping_company` VARCHAR(60) NOT NULL,
  MODIFY `order_status_id` INT(11) NOT NULL DEFAULT '0'
;
-- stale fields: weight, invoice_filename, payment_company_id, payment_tax_id, amazon_order_id, tax_exempttiny, payment_address_id, shipping_address_id, tax_custom_shiptiny, optional_feesmedium, customer_ref, layaway_deposit, transaction_id, order_refundedtiny, cc_last_4, order_paidtiny, custorderref, recipientsmedium, tax_overridemedium, sales_agent, check_number, check_date, bank_name, cart_weight, invoice_date, invoice_number, tracking_number

ALTER TABLE `oc_dm_order_history`
  MODIFY `notify` TINYINT(1) NOT NULL DEFAULT '0'
;
-- stale fields: tracking_url, tracker_id, tracking_numbers

ALTER TABLE `oc_dm_order_option`
  MODIFY `product_option_value_id` INT(11) NOT NULL DEFAULT '0'
;

ALTER TABLE `oc_dm_product`
  MODIFY `quantity` INT(4) NOT NULL DEFAULT '0',
  MODIFY `points` INT(8) NOT NULL DEFAULT '0',
  MODIFY `weight_class_id` INT(11) NOT NULL DEFAULT '0',
  MODIFY `length_class_id` INT(11) NOT NULL DEFAULT '0',
  MODIFY `sort_order` INT(11) NOT NULL DEFAULT '0',
  MODIFY `status` TINYINT(1) NOT NULL DEFAULT '0',
  MODIFY `viewed` INT(5) NOT NULL DEFAULT '0',
  MODIFY `asin` VARCHAR(13) NOT NULL,
  MODIFY `product_apt` TEXT NOT NULL,
  MODIFY `youtube` TEXT NOT NULL,
  MODIFY `sitemap_file` INT(4) NOT NULL
;
-- stale fields: sitemap_file
-- additional fields: asin, realprice, product_apt, youtube

ALTER TABLE `oc_dm_product_description`
  MODIFY `name` VARCHAR(255) NOT NULL,
  MODIFY `description` MEDIUMTEXT NOT NULL
;
-- stale fields: seo_title, seo_h1, seo_h2, seo_h3, auto_gen, alt_image, title_image, meta_seo_dat

ALTER TABLE `oc_dm_product_discount`
  MODIFY `quantity` INT(4) NOT NULL DEFAULT '0'
;

ALTER TABLE `oc_dm_product_image`
  MODIFY `sort_order` INT(3) NOT NULL DEFAULT '0'
;

ALTER TABLE oc_dm_product_option
  MODIFY `value` TEXT NOT NULL
;

ALTER TABLE oc_dm_product_reward
  MODIFY `product_id` INT(11) NOT NULL DEFAULT '0',
  MODIFY `customer_group_id` INT(11) NOT NULL DEFAULT '0',
  MODIFY `points` INT(8) NOT NULL DEFAULT '0'
;

ALTER TABLE oc_dm_recurring
  MODIFY `duration` INT(10) UNSIGNED NOT NULL,
  MODIFY `cycle` INT(10) UNSIGNED NOT NULL,
  MODIFY `trial_duration` INT(10) UNSIGNED NOT NULL,
  MODIFY `trial_cycle` INT(10) UNSIGNED NOT NULL
;

ALTER TABLE oc_dm_return_action
  MODIFY `language_id` INT(11) NOT NULL DEFAULT '0'
;
ALTER TABLE oc_dm_return_reason
  MODIFY `language_id` INT(11) NOT NULL DEFAULT '0'
;
ALTER TABLE oc_dm_return_status
  MODIFY `language_id` INT(11) NOT NULL DEFAULT '0'
;
ALTER TABLE oc_dm_review
  MODIFY `status` TINYINT(1) NOT NULL DEFAULT '0'
;

ALTER TABLE oc_dm_setting
  MODIFY `value` TEXT NOT NULL
;
UPDATE `oc_dm_setting` SET `value` = 'en-gb' WHERE `key` = 'config_admin_language';
UPDATE `oc_dm_setting` SET `value` = 'en-gb' WHERE `key` = 'config_language';
UPDATE `oc_dm_setting` SET `value` = 'basic_captcha' WHERE `key` = 'config_captcha';
UPDATE `oc_dm_setting` SET `value` = '["order"]' WHERE `key` = 'config_mail_alert';
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'config', `key` = 'config_fraud_detection', `value` = '0', `serialized` = 0;  -- UPDATE `oc_dm_setting` SET `key` = 'config_fraud_detection' , `value` = '0' WHERE `key` = 'config_fraud_status_id';
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'config', `key` = 'config_alert_email', `value` = '', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'config', `key` = 'config_customer_search', `value` = '0', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'config', `key` = 'config_theme', `value` = 'theme_default', `serialized` = 0; -- config_template = digitalmeans
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_activity', `key` = 'dashboard_activity_sort_order', `value` = '7', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_activity', `key` = 'dashboard_activity_status', `value` = '1', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_activity', `key` = 'dashboard_activity_width', `value` = '4', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_chart', `key` = 'dashboard_chart_sort_order', `value` = '6', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_chart', `key` = 'dashboard_chart_status', `value` = '1', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_chart', `key` = 'dashboard_chart_width', `value` = '6', `serialized` = 0;

INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_customer', `key` = 'dashboard_customer_sort_order', `value` = '3', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_customer', `key` = 'dashboard_customer_status', `value` = '1', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_customer', `key` = 'dashboard_customer_width', `value` = '3', `serialized` = 0;

INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_map', `key` = 'dashboard_map_sort_order', `value` = '5', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_map', `key` = 'dashboard_map_status', `value` = '1', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_map', `key` = 'dashboard_map_width', `value` = '6', `serialized` = 0;

INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_online', `key` = 'dashboard_online_sort_order', `value` = '4', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_online', `key` = 'dashboard_online_status', `value` = '1', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_online', `key` = 'dashboard_online_width', `value` = '3', `serialized` = 0;

INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_order', `key` = 'dashboard_order_sort_order', `value` = '1', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_order', `key` = 'dashboard_order_status', `value` = '1', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_order', `key` = 'dashboard_order_width', `value` = '3', `serialized` = 0;

INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_recent', `key` = 'dashboard_recent_sort_order', `value` = '8', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_recent', `key` = 'dashboard_recent_status', `value` = '1', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_recent', `key` = 'dashboard_recent_width', `value` = '8', `serialized` = 0;

INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_sale', `key` = 'dashboard_sale_sort_order', `value` = '2', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_sale', `key` = 'dashboard_sale_status', `value` = '1', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'dashboard_sale', `key` = 'dashboard_sale_width', `value` = '3', `serialized` = 0;

INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_directory', `value` = 'default', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_additional_height', `value` = '74', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_additional_width', `value` = '74', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_cart_height', `value` = '47', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_cart_width', `value` = '47', `serialized` = 0;

INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_category_height', `value` = '80', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_category_width', `value` = '80', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_compare_height', `value` = '90', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_compare_width', `value` = '90', `serialized` = 0;

INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_location_height', `value` = '50', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_location_width', `value` = '268', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_popup_height', `value` = '500', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_popup_width', `value` = '500', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_product_height', `value` = '228', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_product_width', `value` = '228', `serialized` = 0;

INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_related_height', `value` = '200', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_related_width', `value` = '200', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_thumb_height', `value` = '228', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_thumb_width', `value` = '228', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_wishlist_height', `value` = '47', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_image_wishlist_width', `value` = '47', `serialized` = 0;

INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_product_description_length', `value` = '100', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_product_limit', `value` = '15', `serialized` = 0;
INSERT INTO `oc_dm_setting` SET `store_id` = 0, `code` = 'theme_default', `key` = 'theme_default_status', `value` = '1', `serialized` = 0;

-- CREATE TABLE `oc_dm_smpa_notification` (
--   `template_id` int(11) NOT NULL AUTO_INCREMENT,
--   `status` tinyint(1) NOT NULL DEFAULT '0',
--   PRIMARY KEY (`template_id`)
-- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- CREATE TABLE `oc_dm_smpa_notification_description` (
--   `template_id` int(11) NOT NULL AUTO_INCREMENT,
--   `language_id` int(11) NOT NULL,
--   `subject` varchar(255) NOT NULL,
--   `template` text NOT NULL,
--   PRIMARY KEY (`template_id`,`language_id`),
--   KEY `subject` (`subject`)
-- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- CREATE TABLE `oc_dm_smpa_record` (
--   `record_id` int(11) NOT NULL AUTO_INCREMENT,
--   `product_id` int(11) NOT NULL,
--   `email` text NOT NULL,
--   `firstname` varchar(32) NOT NULL,
--   `lastname` varchar(32) NOT NULL,
--   `telephone` varchar(32) NOT NULL,
--   `status` tinyint(1) NOT NULL DEFAULT '0',
--   `ip` varchar(40) NOT NULL,
--   `currency_code` varchar(3) NOT NULL,
--   `user_agent` varchar(255) NOT NULL,
--   `accept_language` varchar(255) NOT NULL,
--   `user_language_id` int(11) NOT NULL,
--   `date_added` datetime NOT NULL,
--   `store_name` text NOT NULL,
--   `store_url` text NOT NULL,
--   PRIMARY KEY (`record_id`)
-- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE oc_dm_tax_rate
  MODIFY `geo_zone_id` INT(11) NOT NULL DEFAULT '0'
;

CREATE TABLE `oc_dm_theme` (
  `theme_id` INT(11) NOT NULL AUTO_INCREMENT,
  `store_id` INT(11) NOT NULL,
  `theme` VARCHAR(64) NOT NULL,
  `route` VARCHAR(64) NOT NULL,
  `code` TEXT NOT NULL,
  PRIMARY KEY (`theme_id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

CREATE TABLE `oc_dm_translation` (
  `translation_id` INT(11) NOT NULL AUTO_INCREMENT,
  `store_id` INT(11) NOT NULL,
  `language_id` INT(11) NOT NULL,
  `route` VARCHAR(64) NOT NULL,
  `key` VARCHAR(64) NOT NULL,
  `value` TEXT NOT NULL,
  PRIMARY KEY (`translation_id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8;

ALTER TABLE oc_dm_user_group
  MODIFY `permission` MEDIUMTEXT NOT NULL
;

ALTER TABLE oc_dm_weight_class_description
  MODIFY `weight_class_id` INT(11) NOT NULL
;

ALTER TABLE oc_dm_zone_to_geo_zone
  MODIFY `zone_id` INT(11) NOT NULL DEFAULT '0'
;