00001 <?php
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027
00028
00029
00030
00031
00032
00033
00034
00035 class Mage_Catalog_Model_Resource_Eav_Mysql4_Setup extends Mage_Eav_Model_Entity_Setup
00036 {
00037
00038
00039
00040
00041
00042
00043 public function getDefaultEntities()
00044 {
00045 return array(
00046 'catalog_category' => array(
00047 'entity_model' => 'catalog/category',
00048 'attribute_model' => 'catalog/resource_eav_attribute',
00049 'table' => 'catalog/category',
00050 'attributes' => array(
00051 'name' => array(
00052 'type' => 'varchar',
00053 'backend' => '',
00054 'frontend' => '',
00055 'label' => 'Name',
00056 'input' => 'text',
00057 'class' => '',
00058 'source' => '',
00059 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00060 'visible' => true,
00061 'required' => true,
00062 'user_defined' => false,
00063 'default' => '',
00064 'searchable' => false,
00065 'filterable' => false,
00066 'comparable' => false,
00067 'visible_on_front' => false,
00068 'unique' => false,
00069 ),
00070 'is_active' => array(
00071 'type' => 'int',
00072 'backend' => '',
00073 'frontend' => '',
00074 'label' => 'Is Active',
00075 'input' => 'select',
00076 'class' => '',
00077 'source' => 'eav/entity_attribute_source_boolean',
00078 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00079 'visible' => true,
00080 'required' => false,
00081 'user_defined' => false,
00082 'default' => '',
00083 'searchable' => false,
00084 'filterable' => false,
00085 'comparable' => false,
00086 'visible_on_front' => false,
00087 'unique' => false,
00088 ),
00089 'url_key' => array(
00090 'label' => 'URL key',
00091 'backend' => 'catalog/category_attribute_backend_urlkey',
00092 'required' => false,
00093 ),
00094 'description' => array(
00095 'type' => 'text',
00096 'backend' => '',
00097 'frontend' => '',
00098 'label' => 'Description',
00099 'input' => 'textarea',
00100 'class' => '',
00101 'source' => '',
00102 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00103 'visible' => true,
00104 'required' => false,
00105 'user_defined' => false,
00106 'default' => '',
00107 'searchable' => false,
00108 'filterable' => false,
00109 'comparable' => false,
00110 'visible_on_front' => false,
00111 'unique' => false,
00112 ),
00113 'image' => array(
00114 'type' => 'varchar',
00115
00116
00117 'backend' => 'catalog/category_attribute_backend_image',
00118 'frontend' => '',
00119 'label' => 'Image',
00120 'input' => 'image',
00121 'class' => '',
00122 'source' => '',
00123 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00124 'visible' => true,
00125 'required' => false,
00126 'user_defined' => false,
00127 'default' => '',
00128 'searchable' => false,
00129 'filterable' => false,
00130 'comparable' => false,
00131 'visible_on_front' => false,
00132 'unique' => false,
00133 ),
00134 'meta_title' => array(
00135 'type' => 'varchar',
00136 'backend' => '',
00137 'frontend' => '',
00138 'label' => 'Page Title',
00139 'input' => 'text',
00140 'class' => '',
00141 'source' => '',
00142 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00143 'visible' => true,
00144 'required' => false,
00145 'user_defined' => false,
00146 'default' => '',
00147 'searchable' => false,
00148 'filterable' => false,
00149 'comparable' => false,
00150 'visible_on_front' => false,
00151 'unique' => false,
00152 ),
00153 'meta_keywords' => array(
00154 'type' => 'text',
00155 'backend' => '',
00156 'frontend' => '',
00157 'label' => 'Meta Keywords',
00158 'input' => 'textarea',
00159 'class' => '',
00160 'source' => '',
00161 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00162 'visible' => true,
00163 'required' => false,
00164 'user_defined' => false,
00165 'default' => '',
00166 'searchable' => false,
00167 'filterable' => false,
00168 'comparable' => false,
00169 'visible_on_front' => false,
00170 'unique' => false,
00171 ),
00172 'meta_description' => array(
00173 'type' => 'text',
00174 'backend' => '',
00175 'frontend' => '',
00176 'label' => 'Meta Description',
00177 'input' => 'textarea',
00178 'class' => '',
00179 'source' => '',
00180 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00181 'visible' => true,
00182 'required' => false,
00183 'user_defined' => false,
00184 'default' => '',
00185 'searchable' => false,
00186 'filterable' => false,
00187 'comparable' => false,
00188 'visible_on_front' => false,
00189 'unique' => false,
00190 ),
00191 'display_mode' => array(
00192 'type' => 'varchar',
00193 'backend' => '',
00194 'frontend' => '',
00195 'label' => 'Display Mode',
00196 'input' => 'select',
00197 'class' => '',
00198 'source' => 'catalog/category_attribute_source_mode',
00199 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00200 'visible' => true,
00201 'required' => false,
00202 'user_defined' => false,
00203 'default' => '',
00204 'searchable' => false,
00205 'filterable' => false,
00206 'comparable' => false,
00207 'visible_on_front' => false,
00208 'unique' => false,
00209 ),
00210 'landing_page' => array(
00211 'type' => 'int',
00212 'backend' => '',
00213 'frontend' => '',
00214 'label' => 'CMS Block',
00215 'input' => 'select',
00216 'class' => '',
00217 'source' => 'catalog/category_attribute_source_page',
00218 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00219 'visible' => true,
00220 'required' => false,
00221 'user_defined' => false,
00222 'default' => '',
00223 'searchable' => false,
00224 'filterable' => false,
00225 'comparable' => false,
00226 'visible_on_front' => false,
00227 'unique' => false,
00228 ),
00229 'is_anchor' => array(
00230 'type' => 'int',
00231 'backend' => '',
00232 'frontend' => '',
00233 'label' => 'Is Anchor',
00234 'input' => 'select',
00235 'class' => '',
00236 'source' => 'eav/entity_attribute_source_boolean',
00237 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00238 'visible' => true,
00239 'required' => false,
00240 'user_defined' => false,
00241 'default' => '',
00242 'searchable' => false,
00243 'filterable' => false,
00244 'comparable' => false,
00245 'visible_on_front' => false,
00246 'unique' => false,
00247 ),
00248
00249 'path' => array(
00250 'type' => 'static',
00251 'backend' => '',
00252 'frontend' => '',
00253 'label' => 'Path',
00254 'input' => '',
00255 'class' => '',
00256 'source' => '',
00257 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00258 'visible' => false,
00259 'required' => false,
00260 'user_defined' => false,
00261 'default' => '',
00262 'searchable' => false,
00263 'filterable' => false,
00264 'comparable' => false,
00265 'visible_on_front' => false,
00266 'unique' => false,
00267 ),
00268 'position' => array(
00269 'type' => 'static',
00270 'backend' => '',
00271 'frontend' => '',
00272 'label' => 'Position',
00273 'input' => '',
00274 'class' => '',
00275 'source' => '',
00276 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00277 'visible' => false,
00278 'required' => false,
00279 'user_defined' => false,
00280 'default' => '',
00281 'searchable' => false,
00282 'filterable' => false,
00283 'comparable' => false,
00284 'visible_on_front' => false,
00285 'unique' => false,
00286 ),
00287 'all_children' => array(
00288 'type' => 'text',
00289
00290 'backend' => '',
00291 'frontend' => '',
00292 'label' => '',
00293 'input' => '',
00294 'class' => '',
00295 'source' => '',
00296 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00297 'visible' => false,
00298 'required' => false,
00299 'user_defined' => false,
00300 'default' => '',
00301 'searchable' => false,
00302 'filterable' => false,
00303 'comparable' => false,
00304 'visible_on_front' => false,
00305 'unique' => false,
00306 ),
00307 'path_in_store' => array(
00308 'type' => 'text',
00309
00310 'backend' => '',
00311 'frontend' => '',
00312 'table' => '',
00313 'label' => '',
00314 'input' => '',
00315 'class' => '',
00316 'source' => '',
00317 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00318 'visible' => false,
00319 'required' => false,
00320 'user_defined' => false,
00321 'default' => '',
00322 'searchable' => false,
00323 'filterable' => false,
00324 'comparable' => false,
00325 'visible_on_front' => false,
00326 'unique' => false,
00327 ),
00328 'children' => array(
00329 'type' => 'text',
00330
00331 'frontend' => '',
00332 'table' => '',
00333 'label' => '',
00334 'input' => '',
00335 'class' => '',
00336 'source' => '',
00337 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00338 'visible' => false,
00339 'required' => false,
00340 'user_defined' => false,
00341 'default' => '',
00342 'searchable' => false,
00343 'filterable' => false,
00344 'comparable' => false,
00345 'visible_on_front' => false,
00346 'unique' => false,
00347 ),
00348 'url_path' => array(
00349 'type' => 'varchar',
00350 'frontend' => '',
00351 'table' => '',
00352 'label' => '',
00353 'input' => '',
00354 'class' => '',
00355 'source' => '',
00356 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00357 'visible' => false,
00358 'required' => false,
00359 'user_defined' => false,
00360 'default' => '',
00361 'searchable' => false,
00362 'filterable' => false,
00363 'comparable' => false,
00364 'visible_on_front' => false,
00365 'unique' => true,
00366 ),
00367 'custom_design' => array(
00368 'type' => 'varchar',
00369 'label' => 'Custom Design',
00370 'frontend' => '',
00371 'table' => '',
00372 'input' => 'select',
00373 'class' => '',
00374 'source' => 'core/design_source_design',
00375 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00376 'visible' => true,
00377 'required' => false,
00378 'user_defined' => false,
00379 'default' => '',
00380 'searchable' => false,
00381 'filterable' => false,
00382 'comparable' => false,
00383 'visible_on_front' => false,
00384 'unique' => false,
00385 ),
00386 'custom_design_apply' => array(
00387 'type' => 'int',
00388 'label' => 'Apply To',
00389 'frontend' => '',
00390 'table' => '',
00391 'input' => 'select',
00392 'class' => '',
00393 'source' => 'core/design_source_apply',
00394 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00395 'visible' => true,
00396 'required' => false,
00397 'user_defined' => false,
00398 'default' => '',
00399 'searchable' => false,
00400 'filterable' => false,
00401 'comparable' => false,
00402 'visible_on_front' => false,
00403 'unique' => false,
00404 ),
00405 'custom_design_from' => array(
00406 'type' => 'datetime',
00407 'label' => 'Active From',
00408 'frontend' => '',
00409 'table' => '',
00410 'input' => 'date',
00411 'class' => '',
00412 'source' => '',
00413 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00414 'visible' => true,
00415 'required' => false,
00416 'user_defined' => false,
00417 'default' => '',
00418 'searchable' => false,
00419 'filterable' => false,
00420 'comparable' => false,
00421 'visible_on_front' => false,
00422 'unique' => false,
00423 'backend' => 'eav/entity_attribute_backend_datetime',
00424 ),
00425 'custom_design_to' => array(
00426 'type' => 'datetime',
00427 'label' => 'Active To',
00428 'frontend' => '',
00429 'table' => '',
00430 'input' => 'date',
00431 'class' => '',
00432 'source' => '',
00433 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00434 'visible' => true,
00435 'required' => false,
00436 'user_defined' => false,
00437 'default' => '',
00438 'searchable' => false,
00439 'filterable' => false,
00440 'comparable' => false,
00441 'visible_on_front' => false,
00442 'unique' => false,
00443 'backend' => 'eav/entity_attribute_backend_datetime',
00444 ),
00445 'page_layout' => array(
00446 'type' => 'varchar',
00447 'backend' => '',
00448 'frontend' => '',
00449 'label' => 'Page Layout',
00450 'input' => 'select',
00451 'class' => '',
00452 'source' => 'catalog/category_attribute_source_layout',
00453 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00454 'visible' => true,
00455 'required' => false,
00456 'user_defined' => false,
00457 'default' => '',
00458 'searchable' => false,
00459 'filterable' => false,
00460 'comparable' => false,
00461 'visible_on_front' => false,
00462 'unique' => false,
00463 ),
00464 'custom_layout_update' => array(
00465 'type' => 'text',
00466 'label' => 'Custom Layout Update',
00467 'frontend' => '',
00468 'table' => '',
00469 'input' => 'textarea',
00470 'class' => '',
00471 'source' => '',
00472 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00473 'visible' => true,
00474 'required' => false,
00475 'user_defined' => false,
00476 'default' => '',
00477 'searchable' => false,
00478 'filterable' => false,
00479 'comparable' => false,
00480 'visible_on_front' => false,
00481 'unique' => false,
00482 ),
00483 'level' => array(
00484 'type' => 'static',
00485 'backend' => '',
00486 'frontend' => '',
00487 'label' => 'Level',
00488 'input' => '',
00489 'class' => '',
00490 'source' => '',
00491 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00492 'visible' => false,
00493 'required' => false,
00494 'user_defined' => false,
00495 'default' => '',
00496 'searchable' => false,
00497 'filterable' => false,
00498 'comparable' => false,
00499 'visible_on_front' => false,
00500 'unique' => false,
00501 ),
00502 'children_count' => array(
00503 'type' => 'static',
00504 'backend' => '',
00505 'frontend' => '',
00506 'label' => 'Children Count',
00507 'input' => '',
00508 'class' => '',
00509 'source' => '',
00510 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00511 'visible' => false,
00512 'required' => false,
00513 'user_defined' => false,
00514 'default' => '',
00515 'searchable' => false,
00516 'filterable' => false,
00517 'comparable' => false,
00518 'visible_on_front' => false,
00519 'unique' => false,
00520 )
00521 ),
00522 ),
00523 'catalog_product' => array(
00524 'entity_model' => 'catalog/product',
00525 'attribute_model' => 'catalog/resource_eav_attribute',
00526 'table' => 'catalog/product',
00527 'attributes' => array(
00528 'name' => array(
00529 'type' => 'varchar',
00530 'backend' => '',
00531 'frontend' => '',
00532 'label' => 'Name',
00533 'input' => 'text',
00534 'class' => '',
00535 'source' => '',
00536 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00537 'visible' => true,
00538 'required' => true,
00539 'user_defined' => false,
00540 'default' => '',
00541 'searchable' => true,
00542 'filterable' => false,
00543 'comparable' => false,
00544 'visible_on_front' => false,
00545 'visible_in_advanced_search' => true,
00546 'unique' => false,
00547 ),
00548 'description' => array(
00549 'type' => 'text',
00550 'backend' => '',
00551 'frontend' => '',
00552 'label' => 'Description',
00553 'input' => 'textarea',
00554 'class' => '',
00555 'source' => '',
00556 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00557 'visible' => true,
00558 'required' => true,
00559 'user_defined' => false,
00560 'default' => '',
00561 'searchable' => true,
00562 'filterable' => false,
00563 'comparable' => true,
00564 'visible_on_front' => false,
00565 'visible_in_advanced_search' => true,
00566 'unique' => false,
00567 ),
00568 'short_description' => array(
00569 'type' => 'text',
00570 'backend' => '',
00571 'frontend' => '',
00572 'label' => 'Short Description',
00573 'input' => 'textarea',
00574 'class' => '',
00575 'source' => '',
00576 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00577 'visible' => true,
00578 'required' => true,
00579 'user_defined' => false,
00580 'default' => '',
00581 'searchable' => true,
00582 'filterable' => false,
00583 'comparable' => true,
00584 'visible_on_front' => false,
00585 'visible_in_advanced_search' => true,
00586 'unique' => false,
00587 ),
00588 'sku' => array(
00589 'type' => 'static',
00590 'backend' => '',
00591 'frontend' => '',
00592 'label' => 'SKU',
00593 'input' => 'text',
00594 'class' => '',
00595 'source' => '',
00596 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00597 'visible' => true,
00598 'required' => true,
00599 'user_defined' => false,
00600 'default' => '',
00601 'searchable' => true,
00602 'filterable' => false,
00603 'comparable' => true,
00604 'visible_on_front' => false,
00605 'visible_in_advanced_search' => true,
00606 'unique' => true,
00607 ),
00608 'price' => array(
00609 'group' => 'Prices',
00610 'type' => 'decimal',
00611 'backend' => 'catalog/product_attribute_backend_price',
00612 'frontend' => '',
00613 'label' => 'Price',
00614 'input' => 'price',
00615 'class' => 'validate-number',
00616 'source' => '',
00617 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_WEBSITE,
00618 'visible' => true,
00619 'required' => true,
00620 'user_defined' => false,
00621 'default' => '',
00622 'searchable' => true,
00623 'filterable' => true,
00624 'comparable' => false,
00625 'visible_on_front' => false,
00626 'visible_in_advanced_search' => true,
00627 'unique' => false,
00628 'apply_to' => 'simple,configurable,virtual',
00629 ),
00630 'special_price' => array(
00631 'group' => 'Prices',
00632 'type' => 'decimal',
00633 'backend' => 'catalog/product_attribute_backend_price',
00634 'frontend' => '',
00635 'label' => 'Special Price',
00636 'input' => 'price',
00637 'class' => 'validate-number',
00638 'source' => '',
00639 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_WEBSITE,
00640 'visible' => true,
00641 'required' => false,
00642 'user_defined' => false,
00643 'default' => '',
00644 'searchable' => false,
00645 'filterable' => false,
00646 'comparable' => false,
00647 'visible_on_front' => false,
00648 'unique' => false,
00649 'apply_to' => 'simple,configurable,virtual',
00650 ),
00651 'special_from_date' => array(
00652 'group' => 'Prices',
00653 'type' => 'datetime',
00654 'backend' => 'catalog/product_attribute_backend_startdate',
00655 'frontend' => '',
00656 'label' => 'Special Price From Date',
00657 'input' => 'date',
00658 'class' => 'validate-date',
00659 'source' => '',
00660 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_WEBSITE,
00661 'visible' => true,
00662 'required' => false,
00663 'user_defined' => false,
00664 'default' => '',
00665 'searchable' => false,
00666 'filterable' => false,
00667 'comparable' => false,
00668 'visible_on_front' => false,
00669 'unique' => false,
00670 'apply_to' => 'simple,configurable,virtual',
00671 ),
00672 'special_to_date' => array(
00673 'group' => 'Prices',
00674 'type' => 'datetime',
00675 'backend' => 'eav/entity_attribute_backend_datetime',
00676 'frontend' => '',
00677 'label' => 'Special Price To Date',
00678 'input' => 'date',
00679 'class' => 'validate-date',
00680 'source' => '',
00681 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_WEBSITE,
00682 'visible' => true,
00683 'required' => false,
00684 'user_defined' => false,
00685 'default' => '',
00686 'searchable' => false,
00687 'filterable' => false,
00688 'comparable' => false,
00689 'visible_on_front' => false,
00690 'unique' => false,
00691 'apply_to' => 'simple,configurable,virtual',
00692 ),
00693 'cost' => array(
00694 'group' => 'Prices',
00695 'type' => 'decimal',
00696 'backend' => 'catalog/product_attribute_backend_price',
00697 'frontend' => '',
00698 'label' => 'Cost',
00699 'input' => 'price',
00700 'class' => 'validate-number',
00701 'source' => '',
00702 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_WEBSITE,
00703 'visible' => true,
00704 'required' => false,
00705 'user_defined' => true,
00706 'default' => '',
00707 'searchable' => false,
00708 'filterable' => false,
00709 'comparable' => false,
00710 'visible_on_front' => false,
00711 'unique' => false,
00712 'apply_to' => 'simple,configurable,virtual',
00713 ),
00714 'weight' => array(
00715 'type' => 'decimal',
00716 'backend' => '',
00717 'frontend' => '',
00718 'label' => 'Weight',
00719 'input' => 'text',
00720 'class' => 'validate-number',
00721 'source' => '',
00722 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00723 'visible' => true,
00724 'required' => true,
00725 'user_defined' => false,
00726 'default' => '',
00727 'searchable' => false,
00728 'filterable' => false,
00729 'comparable' => false,
00730 'visible_on_front' => false,
00731 'unique' => false,
00732 'apply_to' => 'simple',
00733 ),
00734 'manufacturer' => array(
00735 'type' => 'int',
00736 'backend' => '',
00737 'frontend' => '',
00738 'label' => 'Manufacturer',
00739 'input' => 'select',
00740 'class' => '',
00741 'source' => '',
00742 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00743 'visible' => true,
00744 'required' => false,
00745 'user_defined' => true,
00746 'default' => '',
00747 'searchable' => true,
00748 'filterable' => true,
00749 'comparable' => true,
00750 'visible_on_front' => false,
00751 'visible_in_advanced_search' => true,
00752 'unique' => false,
00753 'apply_to' => 'simple',
00754 ),
00755 'meta_title' => array(
00756 'group' => 'Meta Information',
00757 'type' => 'varchar',
00758 'backend' => '',
00759 'frontend' => '',
00760 'label' => 'Meta Title',
00761 'input' => 'text',
00762 'class' => '',
00763 'source' => '',
00764 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00765 'visible' => true,
00766 'required' => false,
00767 'user_defined' => false,
00768 'default' => '',
00769 'searchable' => false,
00770 'filterable' => false,
00771 'comparable' => false,
00772 'visible_on_front' => false,
00773 'unique' => false,
00774 ),
00775 'meta_keyword' => array(
00776 'group' => 'Meta Information',
00777 'type' => 'text',
00778 'backend' => '',
00779 'frontend' => '',
00780 'label' => 'Meta Keywords',
00781 'input' => 'textarea',
00782 'class' => '',
00783 'source' => '',
00784 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00785 'visible' => true,
00786 'required' => false,
00787 'user_defined' => false,
00788 'default' => '',
00789 'searchable' => false,
00790 'filterable' => false,
00791 'comparable' => false,
00792 'visible_on_front' => false,
00793 'unique' => false,
00794 ),
00795 'meta_description' => array(
00796 'group' => 'Meta Information',
00797 'type' => 'varchar',
00798 'backend' => '',
00799 'frontend' => '',
00800 'label' => 'Meta Description',
00801 'input' => 'textarea',
00802 'class' => '',
00803 'source' => '',
00804 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00805 'visible' => true,
00806 'required' => false,
00807 'user_defined' => false,
00808 'default' => '',
00809 'searchable' => false,
00810 'filterable' => false,
00811 'comparable' => false,
00812 'visible_on_front' => false,
00813 'unique' => false,
00814 'note' => 'Maximum 255 chars',
00815 ),
00816 'image' => array(
00817 'group' => 'Images',
00818 'type' => 'varchar',
00819
00820 'frontend' => 'catalog/product_attribute_frontend_image',
00821 'label' => 'Base Image',
00822 'input' => 'media_image',
00823 'class' => '',
00824 'source' => '',
00825 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00826 'visible' => true,
00827 'required' => false,
00828 'user_defined' => false,
00829 'default' => '',
00830 'searchable' => false,
00831 'filterable' => false,
00832 'comparable' => false,
00833 'visible_on_front' => false,
00834 'unique' => false,
00835 ),
00836 'small_image' => array(
00837 'group' => 'Images',
00838 'type' => 'varchar',
00839
00840 'frontend' => 'catalog/product_attribute_frontend_image',
00841 'label' => 'Small Image',
00842 'input' => 'media_image',
00843 'class' => '',
00844 'source' => '',
00845 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00846 'visible' => true,
00847 'required' => false,
00848 'user_defined' => false,
00849 'default' => '',
00850 'searchable' => false,
00851 'filterable' => false,
00852 'comparable' => false,
00853 'visible_on_front' => false,
00854 'unique' => false,
00855 ),
00856 'thumbnail' => array(
00857 'group' => 'Images',
00858 'type' => 'varchar',
00859
00860 'frontend' => 'catalog/product_attribute_frontend_image',
00861 'label' => 'Thumbnail',
00862 'input' => 'media_image',
00863 'class' => '',
00864 'source' => '',
00865 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
00866 'visible' => true,
00867 'required' => false,
00868 'user_defined' => false,
00869 'default' => '',
00870 'searchable' => false,
00871 'filterable' => false,
00872 'comparable' => false,
00873 'visible_on_front' => false,
00874 'unique' => false,
00875 ),
00876 'media_gallery' => array(
00877 'group' => 'Images',
00878 'label' => 'Media Gallery',
00879 'input' => 'gallery',
00880 'backend' => 'catalog/product_attribute_backend_media',
00881 'class' => '',
00882 'source' => '',
00883 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00884 'visible' => true,
00885 'required' => true,
00886 'user_defined' => false,
00887 'default' => '',
00888 'searchable' => false,
00889 'filterable' => false,
00890 'comparable' => false,
00891 'visible_on_front' => false,
00892 'unique' => false,
00893 ),
00894 'old_id' => array(
00895 'type' => 'int',
00896 'backend' => '',
00897 'frontend' => '',
00898 'label' => '',
00899 'input' => '',
00900 'class' => '',
00901 'source' => '',
00902 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00903 'visible' => false,
00904 'required' => false,
00905 'user_defined' => false,
00906 'default' => '',
00907 'searchable' => false,
00908 'filterable' => false,
00909 'comparable' => false,
00910 'visible_on_front' => false,
00911 'unique' => false,
00912 ),
00913 'tier_price' => array(
00914 'group' => 'Prices',
00915 'type' => 'decimal',
00916 'backend' => 'catalog/product_attribute_backend_tierprice',
00917 'label' => 'Tier Price',
00918 'input' => 'text',
00919 'class' => '',
00920 'source' => '',
00921 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_WEBSITE,
00922 'visible' => true,
00923 'required' => false,
00924 'user_defined' => false,
00925 'default' => '',
00926 'searchable' => false,
00927 'filterable' => false,
00928 'comparable' => false,
00929 'visible_on_front' => false,
00930 'unique' => false,
00931 'apply_to' => 'simple,configurable,virtual',
00932 ),
00933 'color' => array(
00934 'type' => 'int',
00935 'backend' => '',
00936 'frontend' => '',
00937 'label' => 'Color',
00938 'input' => 'select',
00939 'class' => '',
00940 'source' => '',
00941 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
00942 'visible' => true,
00943 'required' => false,
00944 'user_defined' => true,
00945 'default' => '',
00946 'searchable' => true,
00947 'filterable' => true,
00948 'comparable' => true,
00949 'visible_on_front' => false,
00950 'visible_in_advanced_search' => true,
00951 'unique' => false,
00952 'apply_to' => 'simple',
00953 ),
00954 'news_from_date' => array(
00955 'type' => 'datetime',
00956 'group' => 'General',
00957 'backend' => 'eav/entity_attribute_backend_datetime',
00958 'frontend' => '',
00959 'label' => 'Set Product as New from Date',
00960 'input' => 'date',
00961 'class' => 'validate-date',
00962 'source' => '',
00963 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_WEBSITE,
00964 'visible' => true,
00965 'required' => false,
00966 'user_defined' => false,
00967 'default' => '',
00968 'searchable' => false,
00969 'filterable' => false,
00970 'comparable' => false,
00971 'visible_on_front' => false,
00972 'unique' => false,
00973 ),
00974 'news_to_date' => array(
00975 'type' => 'datetime',
00976 'group' => 'General',
00977 'backend' => 'eav/entity_attribute_backend_datetime',
00978 'frontend' => '',
00979 'label' => 'Set Product as New to Date',
00980 'input' => 'date',
00981 'class' => 'validate-date',
00982 'source' => '',
00983 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_WEBSITE,
00984 'visible' => true,
00985 'required' => false,
00986 'user_defined' => false,
00987 'default' => '',
00988 'searchable' => false,
00989 'filterable' => false,
00990 'comparable' => false,
00991 'visible_on_front' => false,
00992 'unique' => false,
00993 ),
00994 'gallery' => array(
00995 'group' => 'Images',
00996 'type' => 'varchar',
00997
00998
00999 'frontend' => '',
01000 'label' => 'Image Gallery',
01001 'input' => 'gallery',
01002 'class' => '',
01003 'source' => '',
01004 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
01005 'visible' => true,
01006 'required' => false,
01007 'user_defined' => false,
01008 'default' => '',
01009 'searchable' => false,
01010 'filterable' => false,
01011 'comparable' => false,
01012 'visible_on_front' => false,
01013 'unique' => false,
01014 ),
01015 'status' => array(
01016 'type' => 'int',
01017 'backend' => '',
01018 'frontend' => '',
01019 'label' => 'Status',
01020 'input' => 'select',
01021 'class' => '',
01022 'source' => 'catalog/product_status',
01023 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_WEBSITE,
01024 'visible' => true,
01025 'required' => true,
01026 'user_defined' => false,
01027 'default' => '',
01028 'searchable' => true,
01029 'filterable' => false,
01030 'comparable' => false,
01031 'visible_on_front' => false,
01032 'visible_in_advanced_search' => false,
01033 'unique' => false,
01034 ),
01035 'tax_class_id' => array(
01036 'group' => 'Prices',
01037 'type' => 'int',
01038 'backend' => '',
01039 'frontend' => '',
01040 'label' => 'Tax Class',
01041 'input' => 'select',
01042 'class' => '',
01043 'source' => 'tax/class_source_product',
01044 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_WEBSITE,
01045 'visible' => true,
01046 'required' => true,
01047 'user_defined' => false,
01048 'default' => '',
01049 'searchable' => true,
01050 'filterable' => false,
01051 'comparable' => false,
01052 'visible_on_front' => false,
01053 'visible_in_advanced_search' => true,
01054 'unique' => false,
01055 'apply_to' => 'simple,configurable,virtual',
01056 ),
01057
01058
01059
01060
01061
01062
01063
01064
01065
01066
01067
01068
01069
01070
01071
01072
01073
01074
01075
01076
01077
01078 'price' => array(
01079 'group' => 'Prices',
01080 'type' => 'decimal',
01081 'backend' => 'catalog/product_attribute_backend_price',
01082 'frontend' => '',
01083 'label' => 'Price',
01084 'input' => 'price',
01085 'class' => 'validate-number',
01086 'source' => '',
01087 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_WEBSITE,
01088 'visible' => true,
01089 'required' => true,
01090 'user_defined' => false,
01091 'default' => '',
01092 'searchable' => true,
01093 'filterable' => true,
01094 'comparable' => false,
01095 'visible_on_front' => false,
01096 'visible_in_advanced_search' => true,
01097 'unique' => false,
01098 'apply_to' => 'simple,configurable',
01099 ),
01100 'url_key' => array(
01101 'label' => 'URL key',
01102 'backend' => 'catalog/product_attribute_backend_urlkey',
01103 'required' => false,
01104 ),
01105 'url_path' => array(
01106 'type' => 'varchar',
01107 'frontend' => '',
01108 'table' => '',
01109 'label' => '',
01110 'input' => '',
01111 'class' => '',
01112 'source' => '',
01113 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
01114 'visible' => false,
01115 'required' => false,
01116 'user_defined' => false,
01117 'default' => '',
01118 'searchable' => false,
01119 'filterable' => false,
01120 'comparable' => false,
01121 'visible_on_front' => false,
01122 'unique' => true,
01123 ),
01124 'minimal_price' => array(
01125 'group' => 'Prices',
01126 'type' => 'decimal',
01127 'backend' => '',
01128 'frontend' => '',
01129 'label' => 'Minimal Price',
01130 'input' => 'price',
01131 'class' => 'validate-number',
01132 'source' => '',
01133 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
01134 'visible' => false,
01135 'required' => true,
01136 'user_defined' => false,
01137 'default' => '',
01138 'searchable' => false,
01139 'filterable' => false,
01140 'comparable' => false,
01141 'visible_on_front' => false,
01142 'unique' => false,
01143 'apply_to' => 'simple,configurable',
01144 ),
01145 'visibility' => array(
01146 'group' => 'General',
01147 'type' => 'int',
01148 'backend' => '',
01149 'frontend' => '',
01150 'label' => 'Visibility',
01151 'input' => 'select',
01152 'class' => '',
01153 'source' => 'catalog/product_visibility',
01154 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
01155 'visible' => true,
01156 'required' => true,
01157 'user_defined' => false,
01158 'default' => '4',
01159 'searchable' => false,
01160 'filterable' => false,
01161 'comparable' => false,
01162 'visible_on_front' => false,
01163 'visible_in_advanced_search' => false,
01164 'unique' => false,
01165 ),
01166 'custom_design' => array(
01167 'type' => 'varchar',
01168 'label' => 'Custom Design',
01169 'frontend' => '',
01170 'table' => '',
01171 'input' => 'select',
01172 'class' => '',
01173 'source' => 'core/design_source_design',
01174 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
01175 'visible' => true,
01176 'required' => false,
01177 'user_defined' => false,
01178 'default' => '',
01179 'searchable' => false,
01180 'filterable' => false,
01181 'comparable' => false,
01182 'visible_on_front' => false,
01183 'unique' => false,
01184 'group' => 'Design',
01185 ),
01186 'custom_design_from' => array(
01187 'type' => 'datetime',
01188 'label' => 'Active From',
01189 'frontend' => '',
01190 'table' => '',
01191 'input' => 'date',
01192 'class' => '',
01193 'source' => '',
01194 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
01195 'visible' => true,
01196 'required' => false,
01197 'user_defined' => false,
01198 'default' => '',
01199 'searchable' => false,
01200 'filterable' => false,
01201 'comparable' => false,
01202 'visible_on_front' => false,
01203 'unique' => false,
01204 'backend' => 'eav/entity_attribute_backend_datetime',
01205 'group' => 'Design',
01206 ),
01207 'custom_design_to' => array(
01208 'type' => 'datetime',
01209 'label' => 'Active To',
01210 'frontend' => '',
01211 'table' => '',
01212 'input' => 'date',
01213 'class' => '',
01214 'source' => '',
01215 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
01216 'visible' => true,
01217 'required' => false,
01218 'user_defined' => false,
01219 'default' => '',
01220 'searchable' => false,
01221 'filterable' => false,
01222 'comparable' => false,
01223 'visible_on_front' => false,
01224 'unique' => false,
01225 'backend' => 'eav/entity_attribute_backend_datetime',
01226 'group' => 'Design',
01227 ),
01228 'custom_layout_update' => array(
01229 'type' => 'text',
01230 'label' => 'Custom Layout Update',
01231 'frontend' => '',
01232 'table' => '',
01233 'input' => 'textarea',
01234 'class' => '',
01235 'source' => '',
01236 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
01237 'visible' => true,
01238 'required' => false,
01239 'user_defined' => false,
01240 'default' => '',
01241 'searchable' => false,
01242 'filterable' => false,
01243 'comparable' => false,
01244 'visible_on_front' => false,
01245 'unique' => false,
01246 'group' => 'Design',
01247 ),
01248 'page_layout' => array(
01249 'type' => 'varchar',
01250 'backend' => '',
01251 'frontend' => '',
01252 'label' => 'Page Layout',
01253 'input' => 'select',
01254 'class' => '',
01255 'source' => 'catalog/product_attribute_source_layout',
01256 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
01257 'visible' => true,
01258 'required' => false,
01259 'user_defined' => false,
01260 'default' => '',
01261 'searchable' => false,
01262 'filterable' => false,
01263 'comparable' => false,
01264 'visible_on_front' => false,
01265 'unique' => false,
01266 'group' => 'Design'
01267 ),
01268 'category_ids' => array(
01269 'type' => 'static',
01270 'backend' => '',
01271 'label' => '',
01272 'frontend' => '',
01273 'table' => '',
01274 'input' => '',
01275 'class' => '',
01276 'source' => '',
01277 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
01278 'visible' => false,
01279 'required' => false,
01280 'user_defined' => false,
01281 'default' => '',
01282 'searchable' => false,
01283 'filterable' => false,
01284 'comparable' => false,
01285 'visible_on_front' => false,
01286 'unique' => false,
01287 ),
01288 'options_container' => array(
01289 'group' => 'Design',
01290 'type' => 'varchar',
01291 'backend' => '',
01292 'frontend' => '',
01293 'label' => 'Display product options in',
01294 'input' => 'select',
01295 'class' => '',
01296 'source' => 'catalog/entity_product_attribute_design_options_container',
01297 'global' => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
01298 'visible' => true,
01299 'required' => false,
01300 'user_defined' => false,
01301 'default' => 'container2',
01302 'searchable' => false,
01303 'filterable' => false,
01304 'comparable' => false,
01305 'visible_on_front' => false,
01306 'visible_in_advanced_search' => false,
01307 'unique' => false,
01308 )
01309 ),
01310 ),
01311 );
01312 }
01313
01314
01315
01316
01317
01318
01319 public function convertOldTreeToNew()
01320 {
01321 if (!Mage::getModel('catalog/category')->load(1)->getId()) {
01322 Mage::getModel('catalog/category')->setId(1)->setPath(1)->save();
01323 }
01324
01325 $categories = array();
01326
01327 $select = $this->getConnection()->select();
01328 $select->from($this->getTable('catalog/category'));
01329 $categories = $this->getConnection()->fetchAll($select);
01330
01331 if (is_array($categories)) {
01332 foreach ($categories as $category) {
01333 $path = $this->_getCategoryPath($category);
01334 $path = array_reverse($path);
01335 $path = implode('/', $path);
01336 if ($category['entity_id'] != 1 && substr($path, 0, 2) != '1/') {
01337 $path = "1/{$path}";
01338 }
01339
01340 $this
01341 ->getConnection()
01342 ->update(
01343 $this->getTable('catalog/category'),
01344 array('path' => $path),
01345 "entity_id = {$category['entity_id']}"
01346 );
01347 }
01348 }
01349 return $this;
01350 }
01351
01352
01353
01354
01355
01356
01357
01358 protected function _getCategoryEntityRow($id)
01359 {
01360 $select = $this->getConnection()->select();
01361
01362 $select->from($this->getTable('catalog/category'));
01363 $select->where('entity_id = ?', $id);
01364
01365 return $this->getConnection()->fetchRow($select);
01366 }
01367
01368
01369
01370
01371
01372
01373
01374
01375 protected function _getCategoryPath($category, $path = array())
01376 {
01377 $path[] = $category['entity_id'];
01378
01379 if ($category['parent_id'] != 0) {
01380 $parentCategory = $this->_getCategoryEntityRow($category['parent_id']);
01381
01382 if ($parentCategory)
01383 $path = $this->_getCategoryPath($parentCategory, $path);
01384 }
01385
01386 return $path;
01387 }
01388
01389
01390
01391
01392
01393
01394 public function rebuildCategoryLevels()
01395 {
01396 $select = $this->getConnection()->select()
01397 ->from($this->getTable('catalog/category'));
01398
01399 $categories = $this->getConnection()->fetchAll($select);
01400
01401 foreach ($categories as $category) {
01402 $level = count(explode('/', $category['path']))-1;
01403 $this
01404 ->getConnection()
01405 ->update(
01406 $this->getTable('catalog/category'),
01407 array('level' => $level),
01408 "entity_id = {$category['entity_id']}"
01409 );
01410 }
01411 return $this;
01412 }
01413 }