Home > Software > Magento 1.5.0.1 core_directory_storage problem

Magento 1.5.0.1 core_directory_storage problem

/app/code/core/Mage/Core/Model/Mysql4/File/Storage/Directory/Database.php
CREATE TABLE IF NOT EXISTS `PREFIX_core_directory_storage` (
`directory_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`path` varchar(255) NOT NULL DEFAULT '',
`upload_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`parent_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`directory_id`),
UNIQUE KEY `IDX_DIRECTORY_PATH` (`name`, `path`),
KEY `parent_id` (`parent_id`),
CONSTRAINT `FK_DIRECTORY_PARENT_ID` FOREIGN KEY (`parent_id`)
REFERENCES `PREFIX_core_directory_storage` (`directory_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory storage';
May with
SET FOREIGN_KEY_CHECKS = 0;
Categories: Software Tags:
  1. No comments yet.
  1. No trackbacks yet.