Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 2 of 4
Magento Database
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

I checked for 1.1.1 to 1.1.2 DB changes as well and, as Scott said, there aren’t any.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

1.1.3 included only minor extended attribute changes in a few tax tables (National Flags).  The schema is otherwise identical.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

* NOTE:  Version 1.1.4 - same as 1.1.1/1.1.2./1.1.3

 
Magento Community Magento Community
Magento Community
Magento Community
 
oxygen
Member
 
Total Posts:  69
Joined:  2008-06-09
 

This is very useful info. thank you.

 
Magento Community Magento Community
Magento Community
Magento Community
 
schmelzgeist
Sr. Member
 
Total Posts:  92
Joined:  2008-05-27
Marzipane World Capital (Lübeck, Germany)
 

Thanks it helped much more than anything else wink

i search for the refunding storage because we have to create a non ZF and non Magento external backend for multivendors.
a diagram of most basic sales action would be nice, but i haven’t found any in the forum/wiki :(

are there any?

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

Das wollte ich auch, aber…

It has been a few months since I’ve searched, but when I did look I wasn’t able to find any diagrams or docs outlining data transactions for any process.  I agree that something outlining the sales/product/migration data flow processes would be nice documentation to have. 

My DB diagram was a first step in researching a data migration/conversion.  However, since my client ultimately chose to go with a system other than Magento I haven’t taken time to document the system further.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

Diagram 1.1.6 Changes

* Create Table “core_flag” in the Physical Data Model
* Create Column “sessid” in the Table “api_user”
* Create Column “children_count” in the Table “catalog_category_entity”
* Create Column “tax_class_id” in the Table “catalogindex_minimal_price”
* Create Column “tax_class_id” in the Table “catalogindex_price”
* Create Column “percent_approved” in the Table “rating_option_vote_aggregated”
* Create Column “is_changed” in the Table “sales_flat_quote”
* Create Column “method_title” in the Table “sales_flat_quote_shipping_rate”
* Modify Column “session_data” in the Table “core_session” (Data Type, Extended Attributes)
* Create Index “IDX_INCREMENT_ID” in the Table “sales_order”
* Create Reference “FK_RATING_OPTION_REVIEW_ID”

 
Magento Community Magento Community
Magento Community
Magento Community
 
lmenchu
Jr. Member
 
Total Posts:  3
Joined:  2008-08-06
 

I noticed that in the category entity, catalog_category_entity illustration that some text has been truncated. I believe the column name is children_count. I have not looked for other similar problems.

I am/was writing a script to auto update my categories and products directly to the database. However; the children_count column is new and probably required by the new category manager.

My questions:

If I load my categories directly to the category tables is there a trigger that will fire to auto increment the value in the children_count column for a given row?

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

lmenchu,

Thanks for letting me know.  I re-flagged the autosize table option for all tables - should be fine now.  Just re-download the 1.1.6 file in the 1st post to get the update.

The children_count value is not auto-incremented via trigger.  I believe it is updated in the “...\app\code\core\Mage\Catalog\Model\Resource\Eav\Mysql4\Category.php” script.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

Database Diagram 1.1.6 to 1.1.7/1.1.8 Change Summary

* Create Column “stock_status_changed_automatically” in the Table “cataloginventory_stock_item”
* Create Column “is_html” in the Table “checkout_agreement”
* Create Column “trigger_recollect” in the Table “sales_flat_quote”
* Create Column “shipping_tax_refunded” in the Table “sales_order”
* Create Column “base_shipping_tax_refunded” in the Table “sales_order”
* Create Table “catalogrule_affected_product”
* Create Table “googlebase_attributes”
* Create Table “googlebase_items”
* Create Table “googlebase_types”
* Create Table “googleoptimizer_code”
* Create Reference “FK_CUSTOMER”
* Create Reference “FK_GOOGLEOPTIMIZER_CODE_STORE”
* Create Reference “FK_SALES_ORDER_TAX_ORDER”
* Create Reference “GOOGLEBASE_ATTRIBUTES_ATTRIBUTE_ID”
* Create Reference “GOOGLEBASE_ATTRIBUTES_TYPE_ID”
* Create Reference “GOOGLEBASE_ITEMS_PRODUCT_ID”
* Create Reference “GOOGLEBASE_ITEMS_STORE_ID”
* Create Reference “GOOGLEBASE_TYPES_ATTRIBUTE_SET_ID”
* Modify Column “title” in the Table “catalog_product_option_title” (Data Type)
* Modify Column “title” in the Table “catalog_product_option_type_title” (Data Type)
* Modify Column “conditions_serialized” in the Table “catalogrule” (Data Type)
* Modify Column “actions_serialized” in the Table “catalogrule” (Data Type)
* Modify Column “name” in the Table “core_store” (Data Type)
* Modify Column “name” in the Table “core_store_group” (Data Type)
* Modify Column “conditions_serialized” in the Table “salesrule” (Data Type)
* Modify Column “actions_serialized” in the Table “salesrule” (Data Type)

 
Magento Community Magento Community
Magento Community
Magento Community
 
loko101
Jr. Member
 
Total Posts:  15
Joined:  2008-11-11
 

Great Post! Thanks for the information.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Nighthawk
Jr. Member
 
Avatar
Total Posts:  4
Joined:  2008-10-20
Paris
 

Thanks a lot for the diagrams !! They are a great help. By the way, does anyone know when the diagrams for 1.2.0 will be available?

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

Database Diagram 1.1.8 to 1.2.0.2 Change Summary


* Delete Column “store_id” in the Table “catalogindex_minimal_price”
* Delete Column “store_id” in the Table “catalogindex_price”
* Create Column “store_id” in the Table “catalog_category_product_index”
* Create Column “visibility” in the Table “catalog_category_product_index”
* Create Column “website_id” in the Table “catalogindex_minimal_price”
* Create Column “website_id” in the Table “catalogindex_price”
* Create Column “is_active” in the Table “catalogsearch_query”
* Create Column “is_processed” in the Table “catalogsearch_query”
* Create Column “is_filterable_in_search” in the Table “eav_attribute”
* Create Column “weee_tax_applied” in the Table “sales_flat_order_item”
* Create Column “weee_tax_applied_amount” in the Table “sales_flat_order_item”
* Create Column “weee_tax_applied_row_amount” in the Table “sales_flat_order_item”
* Create Column “base_weee_tax_applied_amount” in the Table “sales_flat_order_item”
* Create Column “base_weee_tax_applied_row_amount” in the Table “sales_flat_order_item”
* Create Column “weee_tax_disposition” in the Table “sales_flat_order_item”
* Create Column “weee_tax_row_disposition” in the Table “sales_flat_order_item”
* Create Column “base_weee_tax_disposition” in the Table “sales_flat_order_item”
* Create Column “base_weee_tax_row_disposition” in the Table “sales_flat_order_item”
* Create Column “global_currency_code” in the Table “sales_flat_quote”
* Create Column “base_to_global_rate” in the Table “sales_flat_quote”
* Create Column “base_to_quote_rate” in the Table “sales_flat_quote”
* Create Column “weee_tax_applied” in the Table “sales_flat_quote_item”
* Create Column “weee_tax_applied_amount” in the Table “sales_flat_quote_item”
* Create Column “weee_tax_applied_row_amount” in the Table “sales_flat_quote_item”
* Create Column “base_weee_tax_applied_amount” in the Table “sales_flat_quote_item”
* Create Column “base_weee_tax_applied_row_amount” in the Table “sales_flat_quote_item”
* Create Column “weee_tax_disposition” in the Table “sales_flat_quote_item”
* Create Column “weee_tax_row_disposition” in the Table “sales_flat_quote_item”
* Create Column “base_weee_tax_disposition” in the Table “sales_flat_quote_item”
* Create Column “base_weee_tax_row_disposition” in the Table “sales_flat_quote_item”
* Create Column “discount_refunded” in the Table “sales_order”
* Create Column “discount_canceled” in the Table “sales_order”
* Create Column “discount_invoiced” in the Table “sales_order”
* Create Column “base_discount_refunded” in the Table “sales_order”
* Create Column “base_discount_canceled” in the Table “sales_order”
* Create Column “base_discount_invoiced” in the Table “sales_order”
* Create Column “hidden” in the Table “sales_order_tax”
* Create Table “catalogindex_aggregation”
* Create Table “catalogindex_aggregation_tag”
* Create Table “catalogindex_aggregation_to_tag”
* Create Table “catalogsearch_fulltext”
* Create Table “catalogsearch_result”
* Create Table “downloadable_link”
* Create Table “downloadable_link_price”
* Create Table “downloadable_link_purchased”
* Create Table “downloadable_link_purchased_item”
* Create Table “downloadable_link_title”
* Create Table “downloadable_sample”
* Create Table “downloadable_sample_title”
* Create Table “weee_discount”
* Create Table “weee_tax”
* Modify Column “ip” in the Table “sendfriend_log” (Extended Attributes)

(Attached file also includes Index and “foreign key” reference changes)

File Attachments
MAGENTO_v1.1.8 to v1.2.0.2---Change Summary.txt  (File Size: 7KB - Downloads: 581)
 
Magento Community Magento Community
Magento Community
Magento Community
 
freshwebs
Sr. Member
 
Total Posts:  153
Joined:  2008-05-27
Leicestershire, UK
 

Just a quick thank you for your efforts - much appreciated.

Eddie

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

No changes from 1.2.0.2 to 1.2.0.3.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 2 of 4