/app/code/core/Mage/Weee/sql/weee_setup/install-1.6.0.0.php

https://bitbucket.org/dnejedly/eaparts · PHP · 174 lines · 134 code · 9 blank · 31 comment · 0 complexity · 1a2b2438e6759751f02799422d2155e5 MD5 · raw file 

    

  1. <?php

    2. 

  2. /**

    3. 

  3.  * Magento

    4. 

  4.  *

    5. 

  5.  * NOTICE OF LICENSE

    6. 

  6.  *

    7. 

  7.  * This source file is subject to the Open Software License (OSL 3.0)

    8. 

  8.  * that is bundled with this package in the file LICENSE.txt.

    9. 

  9.  * It is also available through the world-wide-web at this URL:

    10. 

  10.  * http://opensource.org/licenses/osl-3.0.php

    11. 

  11.  * If you did not receive a copy of the license and are unable to

    12. 

  12.  * obtain it through the world-wide-web, please send an email

    13. 

  13.  * to license@magentocommerce.com so we can send you a copy immediately.

    14. 

  14.  *

    15. 

  15.  * DISCLAIMER

    16. 

  16.  *

    17. 

  17.  * Do not edit or add to this file if you wish to upgrade Magento to newer

    18. 

  18.  * versions in the future. If you wish to customize Magento for your

    19. 

  19.  * needs please refer to http://www.magentocommerce.com for more information.

    20. 

  20.  *

    21. 

  21.  * @category    Mage

    22. 

  22.  * @package     Mage_Weee

    23. 

  23.  * @copyright   Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)

    24. 

  24.  * @license     http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)

    25. 

  25.  */

    26. 

  26. 

    27. 

  27. /** @var $installer Mage_Weee_Model_Resource_Setup */

    28. 

  28. $installer = $this;

    29. 

  29. /**

    30. 

  30.  * Create table 'weee/tax'

    31. 

  31.  */

    32. 

  32. $table = $installer->getConnection()

    33. 

  33.     ->newTable($installer->getTable('weee/tax'))

    34. 

  34.     ->addColumn('value_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(

    35. 

  35.         'identity'  => true,

    36. 

  36.         'nullable'  => false,

    37. 

  37.         'primary'   => true,

    38. 

  38.         ), 'Value Id')

    39. 

  39.     ->addColumn('website_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array(

    40. 

  40.         'unsigned'  => true,

    41. 

  41.         'nullable'  => false,

    42. 

  42.         'default'   => '0',

    43. 

  43.         ), 'Website Id')

    44. 

  44.     ->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(

    45. 

  45.         'unsigned'  => true,

    46. 

  46.         'nullable'  => false,

    47. 

  47.         'default'   => '0',

    48. 

  48.         ), 'Entity Id')

    49. 

  49.     ->addColumn('country', Varien_Db_Ddl_Table::TYPE_TEXT, 2, array(

    50. 

  50.         'nullable'  => true,

    51. 

  51.         ), 'Country')

    52. 

  52.     ->addColumn('value', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(

    53. 

  53.         'nullable'  => false,

    54. 

  54.         'default'   => '0.0000',

    55. 

  55.         ), 'Value')

    56. 

  56.     ->addColumn('state', Varien_Db_Ddl_Table::TYPE_TEXT, 255, array(

    57. 

  57.         'nullable'  => false,

    58. 

  58.         'default'   => '*',

    59. 

  59.         ), 'State')

    60. 

  60.     ->addColumn('attribute_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array(

    61. 

  61.         'unsigned'  => true,

    62. 

  62.         'nullable'  => false,

    63. 

  63.         ), 'Attribute Id')

    64. 

  64.     ->addColumn('entity_type_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array(

    65. 

  65.         'unsigned'  => true,

    66. 

  66.         'nullable'  => false,

    67. 

  67.         ), 'Entity Type Id')

    68. 

  68.     ->addIndex($installer->getIdxName('weee/tax', array('website_id')),

    69. 

  69.         array('website_id'))

    70. 

  70.     ->addIndex($installer->getIdxName('weee/tax', array('entity_id')),

    71. 

  71.         array('entity_id'))

    72. 

  72.     ->addIndex($installer->getIdxName('weee/tax', array('country')),

    73. 

  73.         array('country'))

    74. 

  74.     ->addIndex($installer->getIdxName('weee/tax', array('attribute_id')),

    75. 

  75.         array('attribute_id'))

    76. 

  76.     ->addForeignKey($installer->getFkName('weee/tax', 'country', 'directory/country', 'country_id'),

    77. 

  77.         'country', $installer->getTable('directory/country'), 'country_id',

    78. 

  78.         Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE)

    79. 

  79.     ->addForeignKey($installer->getFkName('weee/tax', 'entity_id', 'catalog/product', 'entity_id'),

    80. 

  80.         'entity_id', $installer->getTable('catalog/product'), 'entity_id',

    81. 

  81.         Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE)

    82. 

  82.     ->addForeignKey($installer->getFkName('weee/tax', 'website_id', 'core/website', 'website_id'),

    83. 

  83.         'website_id', $installer->getTable('core/website'), 'website_id',

    84. 

  84.         Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE)

    85. 

  85.     ->addForeignKey($installer->getFkName('weee/tax', 'attribute_id', 'eav/attribute', 'attribute_id'),

    86. 

  86.         'attribute_id', $installer->getTable('eav/attribute'), 'attribute_id',

    87. 

  87.         Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE)

    88. 

  88.     ->setComment('Weee Tax');

    89. 

  89. $installer->getConnection()->createTable($table);

    90. 

  90. 

    91. 

  91. /**

    92. 

  92.  * Create table 'weee/discount'

    93. 

  93.  */

    94. 

  94. $table = $installer->getConnection()

    95. 

  95.     ->newTable($installer->getTable('weee/discount'))

    96. 

  96.     ->addColumn('entity_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(

    97. 

  97.         'unsigned'  => true,

    98. 

  98.         'nullable'  => false,

    99. 

  99.         'default'   => '0',

    100. 

  100.         ), 'Entity Id')

    101. 

  101.     ->addColumn('website_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array(

    102. 

  102.         'unsigned'  => true,

    103. 

  103.         'nullable'  => false,

    104. 

  104.         'default'   => '0',

    105. 

  105.         ), 'Website Id')

    106. 

  106.     ->addColumn('customer_group_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, null, array(

    107. 

  107.         'unsigned'  => true,

    108. 

  108.         'nullable'  => false,

    109. 

  109.         ), 'Customer Group Id')

    110. 

  110.     ->addColumn('value', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(

    111. 

  111.         'nullable'  => false,

    112. 

  112.         'default'   => '0.0000',

    113. 

  113.         ), 'Value')

    114. 

  114.     ->addIndex($installer->getIdxName('weee/discount', array('website_id')),

    115. 

  115.         array('website_id'))

    116. 

  116.     ->addIndex($installer->getIdxName('weee/discount', array('entity_id')),

    117. 

  117.         array('entity_id'))

    118. 

  118.     ->addIndex($installer->getIdxName('weee/discount', array('customer_group_id')),

    119. 

  119.         array('customer_group_id'))

    120. 

  120.     ->addForeignKey($installer->getFkName('weee/discount', 'customer_group_id', 'customer/customer_group', 'customer_group_id'),

    121. 

  121.         'customer_group_id', $installer->getTable('customer/customer_group'), 'customer_group_id',

    122. 

  122.         Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE)

    123. 

  123.     ->addForeignKey($installer->getFkName('weee/discount', 'entity_id', 'catalog/product', 'entity_id'),

    124. 

  124.         'entity_id', $installer->getTable('catalog/product'), 'entity_id',

    125. 

  125.         Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE)

    126. 

  126.     ->addForeignKey($installer->getFkName('weee/discount', 'website_id', 'core/website', 'website_id'),

    127. 

  127.         'website_id', $installer->getTable('core/website'), 'website_id',

    128. 

  128.         Varien_Db_Ddl_Table::ACTION_CASCADE, Varien_Db_Ddl_Table::ACTION_CASCADE)

    129. 

  129.     ->setComment('Weee Discount');

    130. 

  130. $installer->getConnection()->createTable($table);

    131. 

  131. 

    132. 

  132. $installer->addAttribute('order_item', 'base_weee_tax_applied_amount', array('type'=>'decimal'));

    133. 

  133. $installer->addAttribute('order_item', 'base_weee_tax_applied_row_amnt', array('type'=>'decimal'));

    134. 

  134. $installer->addAttribute('order_item', 'weee_tax_applied_amount', array('type'=>'decimal'));

    135. 

  135. $installer->addAttribute('order_item', 'weee_tax_applied_row_amount', array('type'=>'decimal'));

    136. 

  136. $installer->addAttribute('order_item', 'weee_tax_applied', array('type'=>'text'));

    137. 

  137. 

    138. 

  138. $installer->addAttribute('quote_item', 'weee_tax_disposition', array('type'=>'decimal'));

    139. 

  139. $installer->addAttribute('quote_item', 'weee_tax_row_disposition', array('type'=>'decimal'));

    140. 

  140. $installer->addAttribute('quote_item', 'base_weee_tax_disposition', array('type'=>'decimal'));

    141. 

  141. $installer->addAttribute('quote_item', 'base_weee_tax_row_disposition', array('type'=>'decimal'));

    142. 

  142. 

    143. 

  143. $installer->addAttribute('order_item', 'weee_tax_disposition', array('type'=>'decimal'));

    144. 

  144. $installer->addAttribute('order_item', 'weee_tax_row_disposition', array('type'=>'decimal'));

    145. 

  145. $installer->addAttribute('order_item', 'base_weee_tax_disposition', array('type'=>'decimal'));

    146. 

  146. $installer->addAttribute('order_item', 'base_weee_tax_row_disposition', array('type'=>'decimal'));

    147. 

  147. 

    148. 

  148. $installer->addAttribute('invoice_item', 'base_weee_tax_applied_amount', array('type'=>'decimal'));

    149. 

  149. $installer->addAttribute('invoice_item', 'base_weee_tax_applied_row_amnt', array('type'=>'decimal'));

    150. 

  150. $installer->addAttribute('invoice_item', 'weee_tax_applied_amount', array('type'=>'decimal'));

    151. 

  151. $installer->addAttribute('invoice_item', 'weee_tax_applied_row_amount', array('type'=>'decimal'));

    152. 

  152. $installer->addAttribute('invoice_item', 'weee_tax_applied', array('type'=>'text'));

    153. 

  153. $installer->addAttribute('invoice_item', 'weee_tax_disposition', array('type'=>'decimal'));

    154. 

  154. $installer->addAttribute('invoice_item', 'weee_tax_row_disposition', array('type'=>'decimal'));

    155. 

  155. $installer->addAttribute('invoice_item', 'base_weee_tax_disposition', array('type'=>'decimal'));

    156. 

  156. $installer->addAttribute('invoice_item', 'base_weee_tax_row_disposition', array('type'=>'decimal'));

    157. 

  157. 

    158. 

  158. $installer->addAttribute('quote_item', 'weee_tax_applied', array('type'=>'text'));

    159. 

  159. $installer->addAttribute('quote_item', 'weee_tax_applied_amount', array('type'=>'decimal'));

    160. 

  160. $installer->addAttribute('quote_item', 'weee_tax_applied_row_amount', array('type'=>'decimal'));

    161. 

  161. $installer->addAttribute('quote_item', 'base_weee_tax_applied_amount', array('type'=>'decimal'));

    162. 

  162. $installer->addAttribute('quote_item', 'base_weee_tax_applied_row_amnt', array('type'=>'decimal'));

    163. 

  163. 

    164. 

  164. $installer->addAttribute('creditmemo_item', 'weee_tax_disposition', array('type'=>'decimal'));

    165. 

  165. $installer->addAttribute('creditmemo_item', 'weee_tax_row_disposition', array('type'=>'decimal'));

    166. 

  166. $installer->addAttribute('creditmemo_item', 'base_weee_tax_disposition', array('type'=>'decimal'));

    167. 

  167. $installer->addAttribute('creditmemo_item', 'base_weee_tax_row_disposition', array('type'=>'decimal'));

    168. 

  168. $installer->addAttribute('creditmemo_item', 'weee_tax_applied', array('type'=>'text'));

    169. 

  169. $installer->addAttribute('creditmemo_item', 'base_weee_tax_applied_amount', array('type'=>'decimal'));

    170. 

  170. $installer->addAttribute('creditmemo_item', 'base_weee_tax_applied_row_amnt', array('type'=>'decimal'));

    171. 

  171. $installer->addAttribute('creditmemo_item', 'weee_tax_applied_amount', array('type'=>'decimal'));

    172. 

  172. $installer->addAttribute('creditmemo_item', 'weee_tax_applied_row_amount', array('type'=>'decimal'));

    173. 

  173. 

    174. 

  174. $installer->endSetup();
    175.