Magento-在sales_flat_quote_item和sales_flat_order_item中添加新列 [英] Magento - Adding a new column to sales_flat_quote_item and sales_flat_order_item
问题描述
我正在使用Magento 1.4.1.1版,我想在sales_flat_quote_item
表中保存一个值(并将其传递给sales_flat_order_item
).
I'm working with Magento version 1.4.1.1, and I want to save a value in sales_flat_quote_item
table (and pass it to sales_flat_order_item
).
我找到了本教程,但是我不确定是否它仍然与(Magento版本1.4.1.1)相关,因为它讨论的是名为sales_order
的表,我相信它现在是sales_flat_order
,并且看起来有些不同.
I've found this tutorial, but I'm not sure if it's still relevant (to Magento version 1.4.1.1) since it talks about a table called sales_order
, which I believe is now sales_flat_order
and looks a bit different.
此方法是否仍然有效?如果是这样-我可以将它用于sales_flat_quote_item
和sales_flat_order_item
以及应该在命令中添加什么entity_type_id
:
Should this method still work? If so - Can I use it for sales_flat_quote_item
and sales_flat_order_item
and what entity_type_id
should I put in the commend :
`insert into eav_attribute('entity_type_id','attribute_code','attribute_model','backend_model','backend_type','backend_table','frontend_model','frontend_input','frontend_input_renderer','frontend_label','frontend_class','source_model','is_global','is_visible','is_required','is_user_defined','default_value','is_searchable','is_filterable','is_comparable','is_visible_on_front','is_html_allowed_on_front','is_unique','is_used_for_price_rules','is_filterable_in_search','used_in_product_listing','used_for_sort_by','is_configurable','apply_to','position','note','is_visible_in_advanced_search' )
values(11, 'my_new_column', null, '', 'static', '', '', 'text', '','',null, '', 1,1,1,0,'',0,0,0,0,0,0,1,0,0,0,1,'',0,'',0);`
如果这不是在新的Magento版本中做到这一点的方法,那我应该怎么做?
If this is not the way to do that in the new Magento version, how should I do that?
谢谢, 沙尼
推荐答案
-
使用自
Mage_Sales_Model_Mysql4_Setup
扩展的自己的安装程序类创建新模块,或仅将其用作config.xml
中的模块安装程序类:
Create a new module with own setup class extended from
Mage_Sales_Model_Mysql4_Setup
or just use it as module setup class inconfig.xml
:
<global>
<resources>
<your_module_setup>
<setup>
<module>Your_Module</module>
<class>Mage_Sales_Model_Mysql4_Setup</class>
</setup>
</your_module_setup>
</resources>
</global>
在安装脚本中使用
使用addAttribute($entity, $attributeCode, $options)
方法,它将自动向sales_flat_order故事中添加新列.其他实体也一样.
Use addAttribute($entity, $attributeCode, $options)
method inside of your setup script, it will automatically add a new column to sales_flat_order tale. The same for other entites.
$installer = $this;
$installer->startSetup();
$installer->addAttribute(
'order',
'your_attribute_code',
array(
'type' => 'int', /* varchar, text, decimal, datetime */,
'grid' => false /* or true if you wan't use this attribute on orders grid page */
)
);
$installer->endSetup();
这篇关于Magento-在sales_flat_quote_item和sales_flat_order_item中添加新列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!