/app/code/core/Mage/Core/sql/core_setup/mysql4-install-0.8.0.php

https://bitbucket.org/dnejedly/eaparts · PHP · 222 lines · 168 code · 29 blank · 25 comment · 0 complexity · d6fd9fe90c5ccba8092662a3a594cb44 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_Core

    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. $installer = $this;

    28. 

  28. /* @var $installer Mage_Core_Model_Resource_Setup */

    29. 

  29. 

    30. 

  30. $installer->startSetup();

    31. 

  31. 

    32. 

  32. $installer->run("

    33. 

  33. CREATE TABLE `{$installer->getTable('core_resource')}` (

    34. 

  34.   `code` varchar(50) NOT NULL default '',

    35. 

  35.   `version` varchar(50) NOT NULL default '',

    36. 

  36.   PRIMARY KEY  (`code`)

    37. 

  37. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Resource version registry';

    38. 

  38. 

    39. 

  39. CREATE TABLE `{$installer->getTable('core_website')}` (

    40. 

  40.   `website_id` smallint(5) unsigned NOT NULL auto_increment,

    41. 

  41.   `code` varchar(32) NOT NULL default '',

    42. 

  42.   `name` varchar(64) NOT NULL default '',

    43. 

  43.   `sort_order` smallint(5) unsigned NOT NULL default '0',

    44. 

  44.   `default_group_id` smallint(5) unsigned NOT NULL default '0',

    45. 

  45.   PRIMARY KEY  (`website_id`),

    46. 

  46.   UNIQUE KEY `code` (`code`),

    47. 

  47.   KEY `sort_order` (`sort_order`),

    48. 

  48.   KEY `default_group_id` (`default_group_id`)

    49. 

  49. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Websites';

    50. 

  50. 

    51. 

  51. INSERT INTO `{$installer->getTable('core_website')}` VALUES

    52. 

  52.     (0, 'admin', 'Admin', 0, 0),

    53. 

  53.     (1, 'base', 'Main Website', 0, 1);

    54. 

  54. 

    55. 

  55. -- DROP TABLE IF EXISTS `{$installer->getTable('core_store_group')}`;

    56. 

  56. CREATE TABLE `{$installer->getTable('core_store_group')}` (

    57. 

  57.   `group_id` smallint(5) unsigned NOT NULL auto_increment,

    58. 

  58.   `website_id` smallint(5) unsigned NOT NULL default '0',

    59. 

  59.   `name` varchar(32) NOT NULL default '',

    60. 

  60.   `root_category_id` int(10) unsigned NOT NULL default '0',

    61. 

  61.   `default_store_id` smallint(5) unsigned NOT NULL default '0',

    62. 

  62.   PRIMARY KEY  (`group_id`),

    63. 

  63.   KEY `FK_STORE_GROUP_WEBSITE` (`website_id`),

    64. 

  64.   KEY `default_store_id` (`default_store_id`)

    65. 

  65. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    66. 

  66. 

    67. 

  67. INSERT INTO `{$installer->getTable('core_store_group')}` VALUES

    68. 

  68.     (0, 0, 'Default', 0, 0),

    69. 

  69.     (1, 1, 'Main Website Store', 2, 1);

    70. 

  70. 

    71. 

  71. -- DROP TABLE IF EXISTS `{$installer->getTable('core_store')}`;

    72. 

  72. CREATE TABLE `{$installer->getTable('core_store')}` (

    73. 

  73.   `store_id` smallint(5) unsigned NOT NULL auto_increment,

    74. 

  74.   `code` varchar(32) NOT NULL default '',

    75. 

  75.   `website_id` smallint(5) unsigned default '0',

    76. 

  76.   `group_id` smallint(5) unsigned NOT NULL default '0',

    77. 

  77.   `name` varchar(32) NOT NULL default '',

    78. 

  78.   `sort_order` smallint(5) unsigned NOT NULL default '0',

    79. 

  79.   `is_active` tinyint(1) unsigned NOT NULL default '0',

    80. 

  80.   PRIMARY KEY  (`store_id`),

    81. 

  81.   UNIQUE KEY `code` (`code`),

    82. 

  82.   KEY `FK_STORE_WEBSITE` (`website_id`),

    83. 

  83.   KEY `is_active` (`is_active`,`sort_order`),

    84. 

  84.   KEY `FK_STORE_GROUP` (`group_id`)

    85. 

  85. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores';

    86. 

  86. 

    87. 

  87. INSERT INTO `{$installer->getTable('core_store')}` VALUES

    88. 

  88.     (0, 'admin', 0, 0, 'Admin', 0, 1),

    89. 

  89.     (1, 'default', 1, 1, 'Default Store View', 0, 1);

    90. 

  90. 

    91. 

  91. CREATE TABLE `{$installer->getTable('core_config_data')}` (

    92. 

  92.   `config_id` int(10) unsigned NOT NULL auto_increment,

    93. 

  93.   `scope` enum('default','websites','stores','config') NOT NULL default 'default',

    94. 

  94.   `scope_id` int(11) NOT NULL default '0',

    95. 

  95.   `path` varchar(255) NOT NULL default 'general',

    96. 

  96.   `value` text NOT NULL,

    97. 

  97.   PRIMARY KEY  (`config_id`),

    98. 

  98.   UNIQUE KEY `config_scope` (`scope`,`scope_id`,`path`)

    99. 

  99. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    100. 

  100. 

    101. 

  101. CREATE TABLE `{$installer->getTable('core_email_template')}` (

    102. 

  102.   `template_id` int(7) unsigned NOT NULL auto_increment,

    103. 

  103.   `template_code` varchar(150) default NULL,

    104. 

  104.   `template_text` text,

    105. 

  105.   `template_type` int(3) unsigned default NULL,

    106. 

  106.   `template_subject` varchar(200) default NULL,

    107. 

  107.   `template_sender_name` varchar(200) default NULL,

    108. 

  108.   `template_sender_email` varchar(200) character set latin1 collate latin1_general_ci default NULL,

    109. 

  109.   `added_at` datetime default NULL,

    110. 

  110.   `modified_at` datetime default NULL,

    111. 

  111.   PRIMARY KEY  (`template_id`),

    112. 

  112.   UNIQUE KEY `template_code` (`template_code`),

    113. 

  113.   KEY `added_at` (`added_at`),

    114. 

  114.   KEY `modified_at` (`modified_at`)

    115. 

  115. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email templates';

    116. 

  116. 

    117. 

  117. CREATE TABLE `{$installer->getTable('core_layout_update')}` (

    118. 

  118.   `layout_update_id` int(10) unsigned NOT NULL auto_increment,

    119. 

  119.   `handle` varchar(255) default NULL,

    120. 

  120.   `xml` text,

    121. 

  121.   PRIMARY KEY  (`layout_update_id`),

    122. 

  122.   KEY `handle` (`handle`)

    123. 

  123. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    124. 

  124. 

    125. 

  125. CREATE TABLE `{$installer->getTable('core_layout_link')}` (

    126. 

  126.   `layout_link_id` int(10) unsigned NOT NULL auto_increment,

    127. 

  127.   `store_id` smallint(5) unsigned NOT NULL default '0',

    128. 

  128.   `package` varchar(64) NOT NULL default '',

    129. 

  129.   `theme` varchar(64) NOT NULL default '',

    130. 

  130.   `layout_update_id` int(10) unsigned NOT NULL default '0',

    131. 

  131.   PRIMARY KEY  (`layout_link_id`),

    132. 

  132.   UNIQUE KEY `store_id` (`store_id`,`package`,`theme`,`layout_update_id`),

    133. 

  133.   KEY `FK_core_layout_link_update` (`layout_update_id`)

    134. 

  134. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    135. 

  135. 

    136. 

  136. CREATE TABLE `{$installer->getTable('core_session')}` (

    137. 

  137.   `session_id` varchar(255) NOT NULL default '',

    138. 

  138.   `website_id` smallint(5) unsigned default NULL,

    139. 

  139.   `session_expires` int(10) unsigned NOT NULL default '0',

    140. 

  140.   `session_data` text NOT NULL,

    141. 

  141.   PRIMARY KEY  (`session_id`),

    142. 

  142.   KEY `FK_SESSION_WEBSITE` (`website_id`)

    143. 

  143. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Session data store';

    144. 

  144. 

    145. 

  145. CREATE TABLE `{$installer->getTable('core_translate')}` (

    146. 

  146.   `key_id` int(10) unsigned NOT NULL auto_increment,

    147. 

  147.   `string` varchar(255) NOT NULL default '',

    148. 

  148.   `store_id` smallint(5) unsigned NOT NULL default '0',

    149. 

  149.   `translate` varchar(255) NOT NULL default '',

    150. 

  150.   `locale` varchar(20) NOT NULL default 'en_US',

    151. 

  151.   PRIMARY KEY  (`key_id`),

    152. 

  152.   UNIQUE KEY `IDX_CODE` (`store_id`,`locale`,`string`),

    153. 

  153.   KEY `FK_CORE_TRANSLATE_STORE` (`store_id`)

    154. 

  154. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Translation data';

    155. 

  155. 

    156. 

  156. CREATE TABLE `{$installer->getTable('core_url_rewrite')}` (

    157. 

  157.   `url_rewrite_id` int(10) unsigned NOT NULL auto_increment,

    158. 

  158.   `store_id` smallint(5) unsigned NOT NULL default '0',

    159. 

  159.   `id_path` varchar(255) NOT NULL default '',

    160. 

  160.   `request_path` varchar(255) NOT NULL default '',

    161. 

  161.   `target_path` varchar(255) NOT NULL default '',

    162. 

  162.   `options` varchar(255) NOT NULL default '',

    163. 

  163.   `type` int(1) NOT NULL default '0',

    164. 

  164.   `description` varchar(255) default NULL,

    165. 

  165.   PRIMARY KEY  (`url_rewrite_id`),

    166. 

  166.   UNIQUE KEY `id_path` (`id_path`,`store_id`),

    167. 

  167.   UNIQUE KEY `request_path` (`request_path`,`store_id`),

    168. 

  168.   KEY `target_path` (`target_path`,`store_id`),

    169. 

  169.   KEY `store_id` (`store_id`)

    170. 

  170. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    171. 

  171. 

    172. 

  172. CREATE TABLE `{$installer->getTable('core_url_rewrite_tag')}` (

    173. 

  173.   `url_rewrite_tag_id` int(10) unsigned NOT NULL auto_increment,

    174. 

  174.   `url_rewrite_id` int(10) unsigned NOT NULL default '0',

    175. 

  175.   `tag` varchar(255) default NULL,

    176. 

  176.   PRIMARY KEY  (`url_rewrite_tag_id`),

    177. 

  177.   UNIQUE KEY `tag` (`tag`,`url_rewrite_id`),

    178. 

  178.   KEY `url_rewrite_id` (`url_rewrite_id`)

    179. 

  179. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    180. 

  180. 

    181. 

  181. CREATE TABLE `{$installer->getTable('design_change')}` (

    182. 

  182.   `design_change_id` int(11) NOT NULL auto_increment,

    183. 

  183.   `store_id` smallint(5) unsigned NOT NULL default '0',

    184. 

  184.   `design` varchar(255) NOT NULL default '',

    185. 

  185.   `date_from` date NOT NULL default '0000-00-00',

    186. 

  186.   `date_to` date NOT NULL default '0000-00-00',

    187. 

  187.   PRIMARY KEY  (`design_change_id`),

    188. 

  188.   KEY `FK_DESIGN_CHANGE_STORE` (`store_id`)

    189. 

  189. ) ENGINE=InnoDB DEFAULT CHARSET=utf8

    190. 

  190. ");

    191. 

  191. 

    192. 

  192. $installer->run("

    193. 

  193. 

    194. 

  194. ALTER TABLE `{$installer->getTable('core_store_group')}`

    195. 

  195.   ADD CONSTRAINT `FK_STORE_GROUP_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `{$installer->getTable('core_website')}` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

    196. 

  196. 

    197. 

  197. ALTER TABLE `{$installer->getTable('core_store')}`

    198. 

  198.   ADD CONSTRAINT `FK_STORE_GROUP_STORE` FOREIGN KEY (`group_id`) REFERENCES `{$installer->getTable('core_store_group')}` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,

    199. 

  199.   ADD CONSTRAINT `FK_STORE_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `{$installer->getTable('core_website')}` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

    200. 

  200. 

    201. 

  201. ALTER TABLE `{$installer->getTable('core_layout_link')}`

    202. 

  202.   ADD CONSTRAINT `FK_CORE_LAYOUT_LINK_STORE` FOREIGN KEY (`store_id`) REFERENCES `{$installer->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,

    203. 

  203.   ADD CONSTRAINT `FK_CORE_LAYOUT_LINK_UPDATE` FOREIGN KEY (`layout_update_id`) REFERENCES `{$installer->getTable('core_layout_update')}` (`layout_update_id`) ON DELETE CASCADE ON UPDATE CASCADE;

    204. 

  204. 

    205. 

  205. ALTER TABLE `{$installer->getTable('core_session')}`

    206. 

  206.   ADD CONSTRAINT `FK_SESSION_WEBSITE` FOREIGN KEY (`website_id`) REFERENCES `{$installer->getTable('core_website')}` (`website_id`) ON DELETE CASCADE ON UPDATE CASCADE;

    207. 

  207. 

    208. 

  208. ALTER TABLE `{$installer->getTable('core_translate')}`

    209. 

  209.   ADD CONSTRAINT `FK_CORE_TRANSLATE_STORE` FOREIGN KEY (`store_id`) REFERENCES `{$installer->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

    210. 

  210. 

    211. 

  211. ALTER TABLE `{$installer->getTable('core_url_rewrite')}`

    212. 

  212.   ADD CONSTRAINT `FK_CORE_URL_REWRITE_STORE` FOREIGN KEY (`store_id`) REFERENCES `{$installer->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

    213. 

  213. 

    214. 

  214. ALTER TABLE `{$installer->getTable('core_url_rewrite_tag')}`

    215. 

  215.   ADD CONSTRAINT `FK_CORE_URL_REWRITE_TAG_URL_REWRITE` FOREIGN KEY (`url_rewrite_id`) REFERENCES `{$installer->getTable('core_url_rewrite')}` (`url_rewrite_id`) ON DELETE CASCADE ON UPDATE CASCADE;

    216. 

  216. 

    217. 

  217. ALTER TABLE `{$installer->getTable('design_change')}`

    218. 

  218.   ADD CONSTRAINT `FK_DESIGN_CHANGE_STORE` FOREIGN KEY (`store_id`) REFERENCES `{$installer->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE;

    219. 

  219. 

    220. 

  220. ");

    221. 

  221. 

    222. 

  222. $installer->endSetup();
    223.