Миграция в VirtueMart 2 - [VM2&3] Установка, обновление

CREATE TABLE `jos_vm_product` (
  `product_id` int(11) NOT NULL auto_increment,
  `vendor_id` int(11) NOT NULL default '0',
  `product_parent_id` int(11) NOT NULL default '0',
  `product_sku` varchar(1024) NOT NULL default '',
  `product_s_desc` text,
  `product_desc` text,
[b]  `product_thumb_image` varchar(255) default NULL,
  `product_full_image` varchar(255) default NULL,[/b]
  `product_publish` char(1) default NULL,
  `product_weight` decimal(10,4) default NULL,
  `product_weight_uom` varchar(32) default 'pounds.',
  `product_length` decimal(10,4) default NULL,
  `product_width` decimal(10,4) default NULL,
  `product_height` decimal(10,4) default NULL,
  `product_lwh_uom` varchar(32) default 'inches',
  `product_url` varchar(255) default NULL,
  `product_in_stock` int(11) NOT NULL default '0',
  `product_available_date` int(11) default NULL,
  `product_availability` varchar(56) NOT NULL default '',
  `product_special` char(1) default NULL,
  `product_discount_id` int(11) default NULL,
  `ship_code_id` int(11) default NULL,
  `cdate` int(11) default NULL,
  `mdate` int(11) default NULL,
  `product_name` varchar(1024) default NULL,
  `product_sales` int(11) NOT NULL default '0',
  `attribute` text,
  `custom_attribute` text NOT NULL,
  `product_tax_id` int(11) default NULL,
  `product_unit` varchar(32) default NULL,
  `product_packaging` int(11) default NULL,
  `child_options` varchar(45) default NULL,
  `quantity_options` varchar(45) default NULL,
  `child_option_ids` varchar(45) default NULL,
  `product_order_levels` varchar(45) default NULL,
  PRIMARY KEY  (`product_id`),
  KEY `idx_product_vendor_id` (`vendor_id`),
  KEY `idx_product_product_parent_id` (`product_parent_id`),
  KEY `idx_product_sku` (`product_sku`(333)),
  KEY `idx_product_ship_code_id` (`ship_code_id`),
  KEY `idx_product_name` (`product_name`(333))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='All products are stored here.' AUTO_INCREMENT=1656 ;

CREATE TABLE `jos_virtuemart_medias` (
  `virtuemart_media_id` int(11) unsigned NOT NULL auto_increment,
  `virtuemart_vendor_id` smallint(11) NOT NULL default '1',
  `file_title` char(126) NOT NULL default '',
  `file_description` char(254) NOT NULL default '',
  `file_meta` char(254) NOT NULL default '',
  `file_mimetype` char(64) NOT NULL default '',
  `file_type` char(32) NOT NULL default '',
  `file_url` text,
  `file_url_thumb` char(254) NOT NULL default '',
  `file_is_product_image` tinyint(1) NOT NULL default '0',
  `file_is_downloadable` tinyint(1) NOT NULL default '0',
  `file_is_forSale` tinyint(1) NOT NULL default '0',
  `file_params` text,
  `ordering` int(11) NOT NULL default '0',
  `shared` tinyint(1) NOT NULL default '0',
  `published` tinyint(1) NOT NULL default '1',
  `created_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `created_by` int(11) NOT NULL default '0',
  `modified_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified_by` int(11) NOT NULL default '0',
  `locked_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `locked_by` int(11) NOT NULL default '0',
  PRIMARY KEY  (`virtuemart_media_id`),
  KEY `i_virtuemart_vendor_id` (`virtuemart_vendor_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Additional Images and Files which are assigned to products' AUTO_INCREMENT=3300 ;

CREATE TABLE `jos_virtuemart_product_medias` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `virtuemart_product_id` int(1) unsigned NOT NULL default '0',
  `virtuemart_media_id` int(1) unsigned NOT NULL default '0',
  `ordering` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `i_virtuemart_category_id` (`virtuemart_product_id`,`virtuemart_media_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;