All my tables have the prefix. It looks like the "upgraded" database has an additional two tables
zen_nochex_apc_transactions
zen_nochex_sessions
There is also a lengthy "zen_upgrade_exceptions" table in both old and new databases. The table is much larger in the "upgraded" database however. Is this something I should be worried about?
Michael
--
-- Table structure for table `zen_upgrade_exceptions`
--
DROP TABLE IF EXISTS `zen_upgrade_exceptions`;
CREATE TABLE `zen_upgrade_exceptions` (
`upgrade_exception_id` smallint(5) NOT NULL auto_increment,
`sql_file` varchar(50) default NULL,
`reason` varchar(200) default NULL,
`errordate` datetime default '0001-01-01 00:00:00',
`sqlstatement` text,
PRIMARY KEY (`upgrade_exception_id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `zen_upgrade_exceptions`
--
LOCK TABLES `zen_upgrade_exceptions` WRITE;
/*!40000 ALTER TABLE `zen_upgrade_exceptions` DISABLE KEYS */;
INSERT INTO `zen_upgrade_exceptions` VALUES (1,'sql/mysql_upgrade_zencart_127_to_130.sql','Cannot drop index idx_categories_parent_id_zen on table categories because it does not exist.','2007-10-02 11:12:27','ALTER TABLE categories DROP INDEX idx_categories_parent_id_zen;'),(2,'sql/mysql_upgrade_zencart_127_to_130.sql','Cannot drop index idx_customer_id_zen on table coupon_gv_customer because it does not exist.','2007-10-02 11:12:27','ALTER TABLE coupon_gv_customer DROP INDEX idx_customer_id_zen;'),(3,'sql/mysql_upgrade_zencart_127_to_130.sql','Cannot drop index idx_paypal_paypal_ipn_id_zen on table paypal because it does not exist.','2007-10-02 11:12:27','ALTER TABLE paypal DROP INDEX idx_paypal_paypal_ipn_id_zen;'),(4,'sql/mysql_upgrade_zencart_127_to_130.sql','Cannot drop index idx_prod_opt_val_id_zen on table products_options_values because it does not exist.','2007-10-02 11:12:27','ALTER TABLE products_options_values DROP INDEX idx_prod_opt_val_id_zen;'),(5,'sql/mysql_upgrade_zencart_130_to_1301.sql','Cannot insert configuration_group_title \"EZ-Pages Settings\" because it already exists','2007-10-02 11:12:27','REPLACE INTO configuration_group VALUES (\'30\', \'EZ-Pages Settings\', \'EZ-Pages Settings\', 30, \'1\');'),(6,'sql/mysql_upgrade_zencart_1301_to_1302.sql','Cannot insert configuration_key \"UPLOAD_PREFIX\" because it already exists','2007-10-02 11:12:27','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 (\'Upload prefix\', \'UPLOAD_PREFIX\', \'upload_\', \'Prefix used to differentiate between upload options and other options\', 0, NULL, now(), now(), NULL, NULL);'),(7,'sql/mysql_upgrade_zencart_1301_to_1302.sql','Cannot insert configuration_key \"TEXT_PREFIX\" because it already exists','2007-10-02 11:12:27','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 (\'Text prefix\', \'TEXT_PREFIX\', \'txt_\', \'Prefix used to differentiate between text option values and other option values\', 0, NULL, now(), now(), NULL, NULL);'),(8,'sql/mysql_upgrade_zencart_1302_to_135.sql','Cannot drop index idx_auth_net_id on table authorizenet because it does not exist.','2007-10-02 11:12:28','ALTER TABLE authorizenet DROP INDEX idx_auth_net_id;'),(9,'sql/mysql_upgrade_zencart_136_to_137.sql','Cannot insert configuration_key \"DEFINE_PAGE_NOT_FOUND_STATUS\" because it already exists','2007-10-02 11:12:28','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 (\'Define Page-Not-Found Status\', \'DEFINE_PAGE_NOT_FOUND_STATUS\', \'1\', \'Enable the Defined Page-Not-Found Text from define-pages?<br />0= Define Text OFF<br />1= Define Text ON\', \'25\', \'67\', now(), now(), NULL, \'zen_cfg_select_option(array(\\\'0\\\', \\\'1\\\'),\');'),(10,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE txn_type txn_type varchar(40) NOT NULL default \'\';'),(11,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE reason_code reason_code varchar(40) default NULL;'),(12,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE payment_type payment_type varchar(40) NOT NULL default \'\';'),(13,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE payment_status payment_status varchar(32) NOT NULL default \'\';'),(14,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE pending_reason pending_reason varchar(32) default NULL;'),(15,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE invoice invoice varchar(128) default NULL;'),(16,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE payer_business_name payer_business_name varchar(128) default NULL;'),(17,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE address_name address_name varchar(64) default NULL;'),(18,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE address_street address_street varchar(254) default NULL;'),(19,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE address_city address_city varchar(120) default NULL;'),(20,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE address_state address_state varchar(120) default NULL;'),(21,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE payer_email payer_email varchar(128) NOT NULL default \'\';'),(22,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE business business varchar(128) NOT NULL default \'\';'),(23,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE receiver_email receiver_email varchar(128) NOT NULL default \'\';'),(24,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE txn_id txn_id varchar(20) NOT NULL default \'\';'),(25,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE parent_txn_id parent_txn_id varchar(20) default NULL;'),(26,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing ADD COLUMN module_name varchar(40) NOT NULL default \'\' after txn_type;'),(27,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing ADD COLUMN module_mode varchar(40) NOT NULL default \'\' after module_name;'),(28,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table paypal_testing because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE paypal_testing CHANGE COLUMN zen_order_id order_id int(11) NOT NULL default \'0\';'),(29,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot ALTER or INSERT/REPLACE into table linkpoint_api because it does not exist. CHECK PREFIXES!','2008-02-09 15:08:03','ALTER TABLE linkpoint_api CHANGE COLUMN zen_order_id order_id int(11) NOT NULL default \'0\';'),(30,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot insert configuration_key \"SHOW_SHOPPING_CART_COMBINED\" because it already exists','2008-02-09 15:10:01','INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Show Notice of Combining Shopping Cart on Login\', \'SHOW_SHOPPING_CART_COMBINED\', \'1\', \'When a customer logs in and has a previously stored shopping cart, the products are combined with the existing shopping cart.<br /><br />Do you wish to display a Notice to the customer?<br /><br />0= OFF, do not display a notice<br />1= Yes show notice and go to shopping cart<br />2= Yes show notice, but do not go to shopping cart\', \'9\', \'35\', \'zen_cfg_select_option(array(\\\'0\\\', \\\'1\\\', \\\'2\\\'), \', now());'),(31,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot insert configuration_key \"ORDER_COMMENTS_INVOICE\" because it already exists','2008-02-09 15:10:01','INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (\'Display Order Comments on Admin Invoice\', \'ORDER_COMMENTS_INVOICE\', \'1\', \'Do you want to display the Order Comments on the Admin Invoice?<br />0= OFF<br />1= First Comment by Customer only<br />2= All Comments for the Order\', 7, 25, now(), NULL, \'zen_cfg_select_option(array(\'\'0\'\', \'\'1\'\', \'\'2\'\'), \');'),(32,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot insert configuration_key \"ORDER_COMMENTS_PACKING_SLIP\" because it already exists','2008-02-09 15:10:01','INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (\'Display Order Comments on Admin Packing Slip\', \'ORDER_COMMENTS_PACKING_SLIP\', \'1\', \'Do you want to display the Order Comments on the Admin Packing Slip?<br />0= OFF<br />1= First Comment by Customer only<br />2= All Comments for the Order\', 7, 26, now(), NULL, \'zen_cfg_select_option(array(\'\'0\'\', \'\'1\'\', \'\'2\'\'), \');'),(33,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot insert configuration_key \"SHOW_SHOPPING_CART_COMBINED\" because it already exists','2008-02-09 15:11:20','INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES (\'Show Notice of Combining Shopping Cart on Login\', \'SHOW_SHOPPING_CART_COMBINED\', \'1\', \'When a customer logs in and has a previously stored shopping cart, the products are combined with the existing shopping cart.<br /><br />Do you wish to display a Notice to the customer?<br /><br />0= OFF, do not display a notice<br />1= Yes show notice and go to shopping cart<br />2= Yes show notice, but do not go to shopping cart\', \'9\', \'35\', \'zen_cfg_select_option(array(\\\'0\\\', \\\'1\\\', \\\'2\\\'), \', now());'),(34,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot insert configuration_key \"ORDER_COMMENTS_INVOICE\" because it already exists','2008-02-09 15:11:20','INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (\'Display Order Comments on Admin Invoice\', \'ORDER_COMMENTS_INVOICE\', \'1\', \'Do you want to display the Order Comments on the Admin Invoice?<br />0= OFF<br />1= First Comment by Customer only<br />2= All Comments for the Order\', 7, 25, now(), NULL, \'zen_cfg_select_option(array(\'\'0\'\', \'\'1\'\', \'\'2\'\'), \');'),(35,'sql/mysql_upgrade_zencart_137_to_138.sql','Cannot insert configuration_key \"ORDER_COMMENTS_PACKING_SLIP\" because it already exists','2008-02-09 15:11:20','INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (\'Display Order Comments on Admin Packing Slip\', \'ORDER_COMMENTS_PACKING_SLIP\', \'1\', \'Do you want to display the Order Comments on the Admin Packing Slip?<br />0= OFF<br />1= First Comment by Customer only<br />2= All Comments for the Order\', 7, 26, now(), NULL, \'zen_cfg_select_option(array(\'\'0\'\', \'\'1\'\', \'\'2\'\'), \');');
/*!40000 ALTER TABLE `zen_upgrade_exceptions` ENABLE KEYS */;
UNLOCK TABLES;
Bookmarks