I've noticed that in \app\code\community\MageWorx\OrdersGrid\sql\mageworx_ordersgrid_setup\mysql4-upgrade-2.1.1-2.2.0.php there is table structure which is valid.
How can I run this file manually? I've tried by putting .httaccess with allow all but I get
Internal Server Error
<?php
/**
* MageWorx
* Admin Order Editor extension
*
* @category MageWorx
* @package MageWorx_OrdersEdit
*
@CopyRight Copyright (c) 2016 MageWorx (
Для просмотра ссылки Войди или Зарегистрируйся)
*/
$installer = $this;
$installer->startSetup();
if (!$installer->tableExists($this->getTable('mageworx_ordersgrid/order_grid'))) {
$table = $installer->getConnection()
->newTable($installer->getTable('mageworx_ordersgrid/order_grid'))
->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
'unsigned' => true,
'nullable' => false,
'primary' => true,
), 'Entity Id')
->addColumn('status', Varien_Db_Ddl_Table::TYPE_TEXT, 32, array(), 'Status')
->addColumn('store_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array(
'unsigned' => true,
), 'Store Id')
->addColumn('store_name', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(), 'Store Name')
->addColumn('customer_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
'unsigned' => true,
), 'Customer Id')
->addColumn('base_grand_total', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(), 'Base Grand Total')
->addColumn('base_total_paid', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(), 'Base Total Paid')
->addColumn('grand_total', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(), 'Grand Total')
->addColumn('total_paid', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(), 'Total Paid')
->addColumn('increment_id', Varien_Db_Ddl_Table::TYPE_TEXT, 50, array(), 'Increment Id')
->addColumn('base_currency_code', Varien_Db_Ddl_Table::TYPE_TEXT, 3, array(), 'Base Currency Code')
->addColumn('order_currency_code', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(), 'Order Currency Code')
->addColumn('shipping_name', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(), 'Shipping Name')
->addColumn('billing_name', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(), 'Billing Name')
->addColumn('created_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, null, array(), 'Created At')
->addColumn('updated_at', Varien_Db_Ddl_Table::TYPE_TIMESTAMP, null, array(), 'Updated At')
->addColumn('customer_email', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(), 'Customer Email')
->addColumn('customer_group_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array(), 'Customer Group Id')
->addColumn('total_qty_ordered', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(
'nullable' => false,
'default' => '0.0000',
), 'Total Qty Ordered')
->addColumn('coupon_code', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(), 'Coupon Code')
->addColumn('subtotal', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(
'nullable' => false,
'default' => '0.0000',
), 'Subtotal')
->addColumn('tax_amount', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(
'nullable' => false,
'default' => '0.0000',
), 'Tax Amount')
Код:
require_once('app/Mage.php');
Mage::app()->setCurrentStore(Mage::getModel('core/store')->load(Mage_Core_Model_App::ADMIN_STORE_ID));
$installer = new Mage_Sales_Model_Mysql4_Setup; //Mage_Eav_Model_Entity_Setup,Mage_Catalog_Model_Resource_Setup,
->addColumn('discount_amount', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(
'nullable' => false,
'default' => '0.0000',
), 'Discount Amount')
->addColumn('total_refunded', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(
'nullable' => false,
'default' => '0.0000',
), 'Total Refunded')
->addColumn('shipping_amount', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(
'nullable' => false,
'default' => '0.0000',
), 'Shipping Amount')
->addColumn('base_subtotal', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(
'nullable' => false,
'default' => '0.0000',
.........etc.
