Magento Forum

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

Database Diagram 1.2.0.2 to 1.2.1 Change Summary

File Attachments
MAGENTO_v1.2.0.2 to 1.2.1---Change Summary.txt  (File Size: 7KB - Downloads: 793)
 
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.1 to 1.2.1.1...

 
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.1.1 to 1.2.1.2...

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

Database Diagram 1.2.1.x to 1.3.0 Change Summary
As soon as I have time to format the diagram I will post it.  Until then, here are the changes...

* Create Table “catalog_category_flat”
* Create Column “image_size_x” in the Table “catalog_product_option”
* Create Column “image_size_y” in the Table “catalog_product_option”
* Create Column “frontend_input_renderer” in the Table “eav_attribute”
* Create Column “used_in_product_listing” in the Table “eav_attribute”
* Create Column “used_for_sort_by” in the Table “eav_attribute”
* Create Reference “FK_CATEGORY_FLAT_CATEGORY_ID”
* Create Reference “FK_CATEGORY_FLAT_STORE_ID”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “catalog_product_entity_datetime”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “catalog_product_entity_decimal”
* Create Key “IDX_BASE” in the Table “catalog_product_entity_gallery”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “catalog_product_entity_int”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “catalog_product_entity_text”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “catalog_product_entity_varchar”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “customer_address_entity_datetime”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “customer_address_entity_decimal”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “customer_address_entity_int”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “customer_address_entity_text”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “customer_address_entity_varchar”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “customer_entity_datetime”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “customer_entity_decimal”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “customer_entity_int”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “customer_entity_text”
* Create Key “IDX_ATTRIBUTE_VALUE” in the Table “customer_entity_varchar”
* Create Index “IDX_CATALOG_PRODUCT_OPTION_PRICE_SI_OI” in the Table “catalog_product_option_price”
* Create Index “IDX_CATALOG_PRODUCT_OPTION_TITLE_SI_OI” in the Table “catalog_product_option_title”
* Create Index “IDX_CATALOG_PRODUCT_OPTION_TYPE_PRICE_SI_OTI” in the Table “catalog_product_option_type_price”
* Create Index “IDX_CATALOG_PRODUCT_OPTION_TYPE_TITLE_SI_OTI” in the Table “catalog_product_option_type_title”
* Create Index “IDX_CATALOG_PRODUCT_SUPER_ATTRIBUTE_STORE_PSAI_SI” in the Table “catalog_product_super_attribute_label”
* Create Index “IDX_USED_FOR_SORT_BY” in the Table “eav_attribute”
* Create Index “IDX_USED_IN_PRODUCT_LISTING” in the Table “eav_attribute”
* Delete Index “IDX_ATTRIBUTE_VALUE” in the Table “catalog_product_entity_datetime”
* Delete Index “IDX_ATTRIBUTE_VALUE” in the Table “catalog_product_entity_decimal”
* Delete Index “idx_base” in the Table “catalog_product_entity_gallery”
* Delete Index “IDX_ATTRIBUTE_VALUE” in the Table “catalog_product_entity_int”
* Delete Index “IDX_ATTRIBUTE_VALUE” in the Table “catalog_product_entity_text”
* Delete Index “IDX_ATTRIBUTE_VALUE” in the Table “catalog_product_entity_varchar”
* Modify Column “is_used_for_price_rules” in the Table “eav_attribute” (Default Value)
* Modify Column “is_filterable_in_search” in the Table “eav_attribute” (Default Value)
* Modify Column “global_currency_code” in the Table “sales_flat_quote” (Data Type, Extended Attributes)
* Insert rule_id in collection Columns of sort_order
* Move sort_order to collection Columns of sort_order
* Move is_used_for_price_rules to collection Columns of eav_attribute
* Move is_filterable_in_search to collection Columns of eav_attribute

 
Magento Community Magento Community
Magento Community
Magento Community
 
harry12bar
Sr. Member
 
Avatar
Total Posts:  168
Joined:  2008-01-07
 

Hi, been trying to convert Database Diagram 1.2.1.x to 1.3.0 Change Summary into mysql statements to make amendmants ... but im crap at mysql… would really appreciate a version I can cut and paste into my phpmyadmin..

Thanks again for the great work

 
Magento Community Magento Community
Magento Community
Magento Community
 
niaxilin
Member
 
Avatar
Total Posts:  64
Joined:  2009-05-19
Minneapolis, Minnesota
 

Amazing resource! We just printed a 3’x4’ copy at Kinkos ($9) and hung it on the wall. Should we need some help on our project, would you be looking for consulting work?

Also, out of curiosity, can I ask what software you used to draw/create the diagram?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Charles Albert
Member
 
Total Posts:  56
Joined:  2008-06-24
 

Hey ggoodwin, great work! That’s a priceless work, specially for ones that have to migrate data from one version of magento to another. Thank you very much.
Let me ask you: what is the program that you use to generate the diagram? Is it easy to use? If possible, i would love to help you so we can generate once for all that 1.3.0 diagram.
Ah, another question: There is changes in database from version 1.3.0 to 1.3.2.1?

Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
walltoolsllc
Sr. Member
 
Total Posts:  146
Joined:  2008-08-21
 

Is there a written version of the schema that includes field names in addition to the tables and there relationships?  A document that defines what all the tables are and what the associated field names are and their function?

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

DB Diagram Update v1.3.2.3 Available Soon
I’m back from my Euro vacation/project and will update the docs in the coming week as soon as my new system is pieced together.  I will also include the DB schema syntax. 

No decision on whether or not to diagram the databases for any Magento releases I’ve skipped over.  If you need a diagram for one of the skipped releases let me know and I will see what I can do.

Cheers,
Gordon

 
Magento Community Magento Community
Magento Community
Magento Community
 
gfxguru
Sr. Member
 
Total Posts:  186
Joined:  2008-11-20
 

Again ggodwin you are awesome thanks so much. How about a highres version?

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

Sorry for the update delay.  A few unexpected items required my immediate attention and it appears the Magento DB diagram update will be delayed until after the holiday (next week) rather than this week.

To answer questions asked earlier in the forum…
- The software I use for the model is Sybase PowerDesigner.
- Yes, I will include a high-res version with this next release

Thanks again for your suggestions and for the kind words on the thread…

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

Finally… I’ve installed and configured a Magento development environment on my new machine.  I started on the DB Diagram changes today and should have something in a PDF soon.  See attachment for a summary of changes (since v1.3.0) that will be included.

File Attachments
MAGENTO_v1.3.2.3---Change Summary.txt  (File Size: 12KB - Downloads: 795)
 
Magento Community Magento Community
Magento Community
Magento Community
 
GrG
Member
 
Total Posts:  41
Joined:  2008-11-12
 

Many many thanks to you.

This document is a really great work. I’m amazed by the quality of your doc (and the way you maintain it is really valuable for all of us).

Thanks a lot.

Waitin’ for you next release,

Best Regards,

Greg

 
Magento Community Magento Community
Magento Community
Magento Community
 
Uniquesone
Sr. Member
 
Total Posts:  220
Joined:  2009-03-14
 

Very nice diagram, thank you very much.

But why I have in “catalog_category_flat” columns like:
- all_children
- available_sort_by
- children
- custom_design
- custom_design_apply
...

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

Uniquesone… good catch

The change summary only included changes from 1.3 to 1.3.2.3 and did not include changes from the last diagram version (1.2.x).  I had done my comparison from an unposted 1.3 diagram.  I have added a comparison summary to reflect changes from 1.2.x to 1.3.2.3. 

Yes, the diagram is finally ready - posting it now.  Again, thanks for the kind words.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top