Database upgrade question

Post By:user_28390 | Reply

 

Hi I wanted to know how do oyu know if your database upgraded? I know when I did the magento connect to upgrade site and then pressed the refresh it scolled with all these my sql stuff and a error at the end , Looks like it was trying to create existing tables.
Anyway is there a sql script we can run to double check all the tables were updated ? or another way to confirm the upgrade happened in the database?
Slav

user_28390 Sat, 26 Jul 2008

 

Aslo I must say that doing the upgrade has not changed all the files to the new one either....... 

Also by not knowing which files were modified easily what needs to be overwritten when doing a manual upgrade.
Slav

user_28390 Sat, 26 Jul 2008

 

ok I have looked at the databse from a fresh install and it is missing 2 tables.

Where is the upgrade mysql file int he install sititng ? So We can manually upgrade

user_28390 Sat, 26 Jul 2008

 

Is it also possible to know apart from the extra tables where there any chnages ot exisitng ones?

Slav

user_28390 Sat, 26 Jul 2008

 

It looks like the database has updated itself a bit and added 4 new tables and altered the others.....

The only thing it has not altered so far as I see is this

-- Table structure for table `customer_entity`
--

CREATE TABLE IF NOT EXISTS `customer_entity` (
  `
entity_idint(10unsigned NOT NULL auto_increment,
  `
entity_type_idsmallint(8unsigned NOT NULL default '0',
  `
attribute_set_idsmallint(5unsigned NOT NULL default '0',
  `
website_idsmallint(5unsigned default NULL,
  `
emailvarchar(255NOT NULL default '',
  `
group_idsmallint(3unsigned NOT NULL default '0',
  `
increment_idvarchar(50NOT NULL default '',
  `
store_idsmallint(5unsigned default '0',
  `
created_atdatetime NOT NULL default '0000-00-00 00:00:00',
  `
updated_atdatetime NOT NULL default '0000-00-00 00:00:00',
  `
is_activetinyint(1unsigned NOT NULL default '1',
  
PRIMARY KEY  (`entity_id`),
  
KEY `FK_CUSTOMER_ENTITY_STORE` (`store_id`),
  
KEY `IDX_ENTITY_TYPE` (`entity_type_id`),
  
KEY `IDX_AUTH` (`email`,`website_id`),
  
KEY `FK_CUSTOMER_WEBSITE` (`website_id`)
ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entityies' AUTO_INCREMENT=;

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

oyh

-- Table structure for table `customer_entity`
--

CREATE TABLE IF NOT EXISTS `customer_entity` (
  `
entity_idint(10unsigned NOT NULL auto_increment,
  `
entity_type_idsmallint(8unsigned NOT NULL default '0',
  `
attribute_set_idsmallint(5unsigned NOT NULL default '0',
  `
website_idsmallint(5unsigned default NULL,
  `
emailvarchar(255NOT NULL default '',
  `
group_idsmallint(3unsigned NOT NULL default '0',
  `
increment_idvarchar(50NOT NULL default '',
  `
store_idsmallint(5unsigned default '0',
  `
created_atdatetime NOT NULL default '0000-00-00 00:00:00',
  `
updated_atdatetime NOT NULL default '0000-00-00 00:00:00',
  `
is_activetinyint(1unsigned NOT NULL default '1',
  
PRIMARY KEY  (`entity_id`),
  
KEY `FK_CUSTOMER_ENTITY_STORE` (`store_id`),
  
KEY `IDX_ENTITY_TYPE` (`entity_type_id`),
  
KEY `IDX_AUTH` (`email`,`website_id`),
  
KEY `FK_CUSTOMER_WEBSITE` (`website_id`)
ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Customer Entityies' AUTO_INCREMENT=;

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

the main part it has not added the following code ont he last line

ROW_FORMAT=DYNAMIC

Not sure if that makes a difference or not..

user_28390 Sat, 26 Jul 2008

 

i also noticed that not all tables have been modified as to what they should look on a clean install.

Eg thi is my current one

-- Table structure for table `sales_flat_quote_address`
--

CREATE TABLE IF NOT EXISTS `sales_flat_quote_address` (
  `
address_idint(10unsigned NOT NULL auto_increment,
  `
quote_idint(10unsigned NOT NULL default '0',
  `
created_atdatetime NOT NULL default '0000-00-00 00:00:00',
  `
updated_atdatetime NOT NULL default '0000-00-00 00:00:00',
  `
customer_idint(10unsigned default NULL,
  `
save_in_address_booktinyint(1) default '0',
  `
customer_address_idint(10unsigned default NULL,
  `
address_typevarchar(255) default NULL,
  `
emailvarchar(255) default NULL,
  `
prefixvarchar(40) default NULL,
  `
firstnamevarchar(255) default NULL,
  `
middlenamevarchar(40) default NULL,
  `
lastnamevarchar(255) default NULL,
  `
suffixvarchar(40) default NULL,
  `
companyvarchar(255) default NULL,
  `
streetvarchar(255) default NULL,
  `
cityvarchar(255) default NULL,
  `
regionvarchar(255) default NULL,
  `
region_idint(10unsigned default NULL,
  `
postcodevarchar(255) default NULL,
  `
country_idvarchar(255) default NULL,
  `
telephonevarchar(255) default NULL,
  `
faxvarchar(255) default NULL,
  `
same_as_billingtinyint(1unsigned NOT NULL default '0',
  `
free_shippingtinyint(1unsigned NOT NULL default '0',
  `
collect_shipping_ratestinyint(1unsigned NOT NULL default '0',
  `
shipping_methodvarchar(255NOT NULL default '',
  `
shipping_descriptionvarchar(255NOT NULL default '',
  `
weightdecimal(12,4NOT NULL default '0.0000',
  `
subtotaldecimal(12,4NOT NULL default '0.0000',
  `
base_subtotaldecimal(12,4NOT NULL default '0.0000',
  `
subtotal_with_discountdecimal(12,4NOT NULL default '0.0000',
  `
base_subtotal_with_discountdecimal(12,4NOT NULL default '0.0000',
  `
tax_amountdecimal(12,4NOT NULL default '0.0000',
  `
base_tax_amountdecimal(12,4NOT NULL default '0.0000',
  `
shipping_amountdecimal(12,4NOT NULL default '0.0000',
  `
base_shipping_amountdecimal(12,4NOT NULL default '0.0000',
  `
shipping_tax_amountdecimal(12,4) default NULL,
  `
base_shipping_tax_amountdecimal(12,4) default NULL,
  `
discount_amountdecimal(12,4NOT NULL default '0.0000',
  `
base_discount_amountdecimal(12,4NOT NULL default '0.0000',
  `
grand_totaldecimal(12,4NOT NULL default '0.0000',
  `
base_grand_totaldecimal(12,4NOT NULL default '0.0000',
  `
customer_notestext,
  `
applied_taxestext,
  `
gift_message_idvarchar(255) default NULL,
  
PRIMARY KEY  (`address_id`),
  
KEY `FK_SALES_QUOTE_ADDRESS_SALES_QUOTE` (`quote_id`)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=;

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

this is the one if I do a fresh install

-- Table structure for table `sales_flat_quote_address`
--

-- 
Table structure for table `sales_flat_quote_address`
--

CREATE TABLE IF NOT EXISTS `sales_flat_quote_address` (
  `
address_idint(10unsigned NOT NULL auto_increment,
  `
quote_idint(10unsigned NOT NULL default '0',
  `
created_atdatetime NOT NULL default '0000-00-00 00:00:00',
  `
updated_atdatetime NOT NULL default '0000-00-00 00:00:00',
  `
customer_idint(10unsigned default NULL,
  `
save_in_address_booktinyint(1) default '0',
  `
customer_address_idint(10unsigned default NULL,
  `
address_typevarchar(255) default NULL,
  `
emailvarchar(255) default NULL,
  `
prefixvarchar(40) default NULL,
  `
firstnamevarchar(255) default NULL,
  `
middlenamevarchar(40) default NULL,
  `
lastnamevarchar(255) default NULL,
  `
suffixvarchar(40) default NULL,
  `
companyvarchar(255) default NULL,
  `
streetvarchar(255) default NULL,
  `
cityvarchar(255) default NULL,
  `
regionvarchar(255) default NULL,
  `
region_idint(10unsigned default NULL,
  `
postcodevarchar(255) default NULL,
  `
country_idvarchar(255) default NULL,
  `
telephonevarchar(255) default NULL,
  `
faxvarchar(255) default NULL,
  `
same_as_billingtinyint(1unsigned NOT NULL default '0',
  `
free_shippingtinyint(1unsigned NOT NULL default '0',
  `
collect_shipping_ratestinyint(1unsigned NOT NULL default '0',
  `
shipping_methodvarchar(255NOT NULL default '',
  `
shipping_descriptionvarchar(255NOT NULL default '',
  `
weightdecimal(12,4NOT NULL default '0.0000',
  `
subtotaldecimal(12,4NOT NULL default '0.0000',
  `
base_subtotaldecimal(12,4NOT NULL default '0.0000',
  `
subtotal_with_discountdecimal(12,4NOT NULL default '0.0000',
  `
base_subtotal_with_discountdecimal(12,4NOT NULL default '0.0000',
  `
tax_amountdecimal(12,4NOT NULL default '0.0000',
  `
base_tax_amountdecimal(12,4NOT NULL default '0.0000',
  `
shipping_amountdecimal(12,4NOT NULL default '0.0000',
  `
base_shipping_amountdecimal(12,4NOT NULL default '0.0000',
  `
shipping_tax_amountdecimal(12,4) default NULL,
  `
base_shipping_tax_amountdecimal(12,4) default NULL,
  `
discount_amountdecimal(12,4NOT NULL default '0.0000',
  `
base_discount_amountdecimal(12,4NOT NULL default '0.0000',
  `
grand_totaldecimal(12,4NOT NULL default '0.0000',
  `
base_grand_totaldecimal(12,4NOT NULL default '0.0000',
  `
customer_notestext,
  `
entity_idvarchar(255) default NULL,
  `
parent_idvarchar(255) default NULL,
  `
custbalance_amountvarchar(255) default NULL,
  `
base_custbalance_amountvarchar(255) default NULL,
  `
applied_taxestext,
  `
gift_message_idvarchar(255) default NULL,
  
PRIMARY KEY  (`address_id`),
  
KEY `FK_SALES_QUOTE_ADDRESS_SALES_QUOTE` (`quote_id`)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=;

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

user_28390 Sat, 26 Jul 2008

 

again it is missing

entity_id` varchar(255) default NULL,
  
`parent_id` varchar(255) default NULL,
  
`custbalance_amount` varchar(255) default NULL,
  
`base_custbalance_amount` varchar(255) default NULL,

How do they alter themselves or add themselves?

`Reply Or Comment!
Please LogIn to Reply!