Zend_Db_Statement_Exception Object
(
[_previous:Zend_Exception:private] =>
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'customer_entity' already exists
[string:Exception:private] =>
[code:protected] => 42
[file:protected] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 234
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Statement/Pdo/Mysql.php
[line] => 110
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Zend/Db/Statement.php
[line] => 291
[function] => _execute
[class] => Varien_Db_Statement_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[2] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[3] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `customer_entity` (
`entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id',
`entity_type_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Entity Type Id',
`attribute_set_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Attribute Set Id',
`website_id` smallint UNSIGNED NULL COMMENT 'Website Id',
`email` varchar(255) NULL COMMENT 'Email',
`group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Group Id',
`increment_id` varchar(50) NULL COMMENT 'Increment Id',
`store_id` smallint UNSIGNED NULL default '0' COMMENT 'Store Id',
`created_at` timestamp NOT NULL default 0 COMMENT 'Created At',
`updated_at` timestamp NOT NULL default 0 COMMENT 'Updated At',
`is_active` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Active',
PRIMARY KEY (`entity_id`),
INDEX `IDX_CUSTOMER_ENTITY_STORE_ID` (`store_id`),
INDEX `IDX_CUSTOMER_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
INDEX `IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`, `website_id`),
INDEX `IDX_CUSTOMER_ENTITY_WEBSITE_ID` (`website_id`),
CONSTRAINT `FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `FK_CUSTOMER_ENTITY_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Customer Entity' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
[1] => Array
(
)
)
)
[4] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 428
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `customer_entity` (
`entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id',
`entity_type_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Entity Type Id',
`attribute_set_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Attribute Set Id',
`website_id` smallint UNSIGNED NULL COMMENT 'Website Id',
`email` varchar(255) NULL COMMENT 'Email',
`group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Group Id',
`increment_id` varchar(50) NULL COMMENT 'Increment Id',
`store_id` smallint UNSIGNED NULL default '0' COMMENT 'Store Id',
`created_at` timestamp NOT NULL default 0 COMMENT 'Created At',
`updated_at` timestamp NOT NULL default 0 COMMENT 'Updated At',
`is_active` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Active',
PRIMARY KEY (`entity_id`),
INDEX `IDX_CUSTOMER_ENTITY_STORE_ID` (`store_id`),
INDEX `IDX_CUSTOMER_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
INDEX `IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`, `website_id`),
INDEX `IDX_CUSTOMER_ENTITY_WEBSITE_ID` (`website_id`),
CONSTRAINT `FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `FK_CUSTOMER_ENTITY_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Customer Entity' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
[1] => Array
(
)
)
)
[5] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 2048
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `customer_entity` (
`entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id',
`entity_type_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Entity Type Id',
`attribute_set_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Attribute Set Id',
`website_id` smallint UNSIGNED NULL COMMENT 'Website Id',
`email` varchar(255) NULL COMMENT 'Email',
`group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Group Id',
`increment_id` varchar(50) NULL COMMENT 'Increment Id',
`store_id` smallint UNSIGNED NULL default '0' COMMENT 'Store Id',
`created_at` timestamp NOT NULL default 0 COMMENT 'Created At',
`updated_at` timestamp NOT NULL default 0 COMMENT 'Updated At',
`is_active` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Active',
PRIMARY KEY (`entity_id`),
INDEX `IDX_CUSTOMER_ENTITY_STORE_ID` (`store_id`),
INDEX `IDX_CUSTOMER_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
INDEX `IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`, `website_id`),
INDEX `IDX_CUSTOMER_ENTITY_WEBSITE_ID` (`website_id`),
CONSTRAINT `FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `FK_CUSTOMER_ENTITY_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Customer Entity' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
)
)
[6] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Customer/sql/customer_setup/install-1.6.0.0.php
[line] => 94
[function] => createTable
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Varien_Db_Ddl_Table Object
(
[_tableName:protected] => customer_entity
[_schemaName:protected] =>
[_tableComment:protected] => Customer Entity
[_columns:protected] => Array
(
[ENTITY_ID] => Array
(
[COLUMN_NAME] => entity_id
[COLUMN_TYPE] => integer
[COLUMN_POSITION] => 0
[DATA_TYPE] => integer
[DEFAULT] =>
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] => 1
[PRIMARY_POSITION] => 0
[IDENTITY] => 1
[COMMENT] => Entity Id
)
[ENTITY_TYPE_ID] => Array
(
[COLUMN_NAME] => entity_type_id
[COLUMN_TYPE] => smallint
[COLUMN_POSITION] => 1
[DATA_TYPE] => smallint
[DEFAULT] => 0
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Entity Type Id
)
[ATTRIBUTE_SET_ID] => Array
(
[COLUMN_NAME] => attribute_set_id
[COLUMN_TYPE] => smallint
[COLUMN_POSITION] => 2
[DATA_TYPE] => smallint
[DEFAULT] => 0
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Attribute Set Id
)
[WEBSITE_ID] => Array
(
[COLUMN_NAME] => website_id
[COLUMN_TYPE] => smallint
[COLUMN_POSITION] => 3
[DATA_TYPE] => smallint
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Website Id
)
[EMAIL] => Array
(
[COLUMN_NAME] => email
[COLUMN_TYPE] => text
[COLUMN_POSITION] => 4
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 255
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Email
)
[GROUP_ID] => Array
(
[COLUMN_NAME] => group_id
[COLUMN_TYPE] => smallint
[COLUMN_POSITION] => 5
[DATA_TYPE] => smallint
[DEFAULT] => 0
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Group Id
)
[INCREMENT_ID] => Array
(
[COLUMN_NAME] => increment_id
[COLUMN_TYPE] => text
[COLUMN_POSITION] => 6
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 50
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Increment Id
)
[STORE_ID] => Array
(
[COLUMN_NAME] => store_id
[COLUMN_TYPE] => smallint
[COLUMN_POSITION] => 7
[DATA_TYPE] => smallint
[DEFAULT] => 0
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Store Id
)
[CREATED_AT] => Array
(
[COLUMN_NAME] => created_at
[COLUMN_TYPE] => timestamp
[COLUMN_POSITION] => 8
[DATA_TYPE] => timestamp
[DEFAULT] =>
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Created At
)
[UPDATED_AT] => Array
(
[COLUMN_NAME] => updated_at
[COLUMN_TYPE] => timestamp
[COLUMN_POSITION] => 9
[DATA_TYPE] => timestamp
[DEFAULT] =>
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Updated At
)
[IS_ACTIVE] => Array
(
[COLUMN_NAME] => is_active
[COLUMN_TYPE] => smallint
[COLUMN_POSITION] => 10
[DATA_TYPE] => smallint
[DEFAULT] => 1
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Is Active
)
)
[_indexes:protected] => Array
(
[IDX_CUSTOMER_ENTITY_STORE_ID] => Array
(
[INDEX_NAME] => IDX_CUSTOMER_ENTITY_STORE_ID
[COLUMNS] => Array
(
[STORE_ID] => Array
(
[NAME] => store_id
[SIZE] =>
[POSITION] => 0
)
)
[TYPE] => index
)
[IDX_CUSTOMER_ENTITY_ENTITY_TYPE_ID] => Array
(
[INDEX_NAME] => IDX_CUSTOMER_ENTITY_ENTITY_TYPE_ID
[COLUMNS] => Array
(
[ENTITY_TYPE_ID] => Array
(
[NAME] => entity_type_id
[SIZE] =>
[POSITION] => 0
)
)
[TYPE] => index
)
[IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID] => Array
(
[INDEX_NAME] => IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID
[COLUMNS] => Array
(
[EMAIL] => Array
(
[NAME] => email
[SIZE] =>
[POSITION] => 0
)
[WEBSITE_ID] => Array
(
[NAME] => website_id
[SIZE] =>
[POSITION] => 1
)
)
[TYPE] => index
)
[IDX_CUSTOMER_ENTITY_WEBSITE_ID] => Array
(
[INDEX_NAME] => IDX_CUSTOMER_ENTITY_WEBSITE_ID
[COLUMNS] => Array
(
[WEBSITE_ID] => Array
(
[NAME] => website_id
[SIZE] =>
[POSITION] => 0
)
)
[TYPE] => index
)
)
[_foreignKeys:protected] => Array
(
[FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_ID] => Array
(
[FK_NAME] => FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_ID
[COLUMN_NAME] => store_id
[REF_TABLE_NAME] => core_store
[REF_COLUMN_NAME] => store_id
[ON_DELETE] => SET NULL
[ON_UPDATE] => CASCADE
)
[FK_CUSTOMER_ENTITY_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID] => Array
(
[FK_NAME] => FK_CUSTOMER_ENTITY_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID
[COLUMN_NAME] => website_id
[REF_TABLE_NAME] => core_website
[REF_COLUMN_NAME] => website_id
[ON_DELETE] => SET NULL
[ON_UPDATE] => CASCADE
)
)
[_options:protected] => Array
(
[type] => INNODB
[charset] => utf8
[collate] => utf8_general_ci
)
)
)
)
[7] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Customer/sql/customer_setup/install-1.6.0.0.php
)
[function] => include
)
[8] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 421
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 1.6.2.0.1
)
)
[9] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 327
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 1.6.2.0.1
)
)
[10] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 235
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[11] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/App.php
[line] => 417
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[12] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/App.php
[line] => 343
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)
)
[13] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/Mage.php
[line] => 683
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)
)
)
)
[14] => Array
(
[file] => /www/wwwroot/kiwilighting.com/index.php
[line] => 87
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)
)
)
[previous:Exception:private] => PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'customer_entity' already exists
[string:Exception:private] =>
[code:protected] => 42S01
[file:protected] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 228
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Statement/Pdo.php
[line] => 228
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Statement/Pdo/Mysql.php
[line] => 110
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[2] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Zend/Db/Statement.php
[line] => 291
[function] => _execute
[class] => Varien_Db_Statement_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[3] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[4] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `customer_entity` (
`entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id',
`entity_type_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Entity Type Id',
`attribute_set_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Attribute Set Id',
`website_id` smallint UNSIGNED NULL COMMENT 'Website Id',
`email` varchar(255) NULL COMMENT 'Email',
`group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Group Id',
`increment_id` varchar(50) NULL COMMENT 'Increment Id',
`store_id` smallint UNSIGNED NULL default '0' COMMENT 'Store Id',
`created_at` timestamp NOT NULL default 0 COMMENT 'Created At',
`updated_at` timestamp NOT NULL default 0 COMMENT 'Updated At',
`is_active` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Active',
PRIMARY KEY (`entity_id`),
INDEX `IDX_CUSTOMER_ENTITY_STORE_ID` (`store_id`),
INDEX `IDX_CUSTOMER_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
INDEX `IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`, `website_id`),
INDEX `IDX_CUSTOMER_ENTITY_WEBSITE_ID` (`website_id`),
CONSTRAINT `FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `FK_CUSTOMER_ENTITY_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Customer Entity' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
[1] => Array
(
)
)
)
[5] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 428
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `customer_entity` (
`entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id',
`entity_type_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Entity Type Id',
`attribute_set_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Attribute Set Id',
`website_id` smallint UNSIGNED NULL COMMENT 'Website Id',
`email` varchar(255) NULL COMMENT 'Email',
`group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Group Id',
`increment_id` varchar(50) NULL COMMENT 'Increment Id',
`store_id` smallint UNSIGNED NULL default '0' COMMENT 'Store Id',
`created_at` timestamp NOT NULL default 0 COMMENT 'Created At',
`updated_at` timestamp NOT NULL default 0 COMMENT 'Updated At',
`is_active` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Active',
PRIMARY KEY (`entity_id`),
INDEX `IDX_CUSTOMER_ENTITY_STORE_ID` (`store_id`),
INDEX `IDX_CUSTOMER_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
INDEX `IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`, `website_id`),
INDEX `IDX_CUSTOMER_ENTITY_WEBSITE_ID` (`website_id`),
CONSTRAINT `FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `FK_CUSTOMER_ENTITY_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Customer Entity' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
[1] => Array
(
)
)
)
[6] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 2048
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE `customer_entity` (
`entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id',
`entity_type_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Entity Type Id',
`attribute_set_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Attribute Set Id',
`website_id` smallint UNSIGNED NULL COMMENT 'Website Id',
`email` varchar(255) NULL COMMENT 'Email',
`group_id` smallint UNSIGNED NOT NULL default '0' COMMENT 'Group Id',
`increment_id` varchar(50) NULL COMMENT 'Increment Id',
`store_id` smallint UNSIGNED NULL default '0' COMMENT 'Store Id',
`created_at` timestamp NOT NULL default 0 COMMENT 'Created At',
`updated_at` timestamp NOT NULL default 0 COMMENT 'Updated At',
`is_active` smallint UNSIGNED NOT NULL default '1' COMMENT 'Is Active',
PRIMARY KEY (`entity_id`),
INDEX `IDX_CUSTOMER_ENTITY_STORE_ID` (`store_id`),
INDEX `IDX_CUSTOMER_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
INDEX `IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`, `website_id`),
INDEX `IDX_CUSTOMER_ENTITY_WEBSITE_ID` (`website_id`),
CONSTRAINT `FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `FK_CUSTOMER_ENTITY_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `core_website` (`website_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Customer Entity' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
)
)
[7] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Customer/sql/customer_setup/install-1.6.0.0.php
[line] => 94
[function] => createTable
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Varien_Db_Ddl_Table Object
(
[_tableName:protected] => customer_entity
[_schemaName:protected] =>
[_tableComment:protected] => Customer Entity
[_columns:protected] => Array
(
[ENTITY_ID] => Array
(
[COLUMN_NAME] => entity_id
[COLUMN_TYPE] => integer
[COLUMN_POSITION] => 0
[DATA_TYPE] => integer
[DEFAULT] =>
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] => 1
[PRIMARY_POSITION] => 0
[IDENTITY] => 1
[COMMENT] => Entity Id
)
[ENTITY_TYPE_ID] => Array
(
[COLUMN_NAME] => entity_type_id
[COLUMN_TYPE] => smallint
[COLUMN_POSITION] => 1
[DATA_TYPE] => smallint
[DEFAULT] => 0
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Entity Type Id
)
[ATTRIBUTE_SET_ID] => Array
(
[COLUMN_NAME] => attribute_set_id
[COLUMN_TYPE] => smallint
[COLUMN_POSITION] => 2
[DATA_TYPE] => smallint
[DEFAULT] => 0
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Attribute Set Id
)
[WEBSITE_ID] => Array
(
[COLUMN_NAME] => website_id
[COLUMN_TYPE] => smallint
[COLUMN_POSITION] => 3
[DATA_TYPE] => smallint
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Website Id
)
[EMAIL] => Array
(
[COLUMN_NAME] => email
[COLUMN_TYPE] => text
[COLUMN_POSITION] => 4
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 255
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Email
)
[GROUP_ID] => Array
(
[COLUMN_NAME] => group_id
[COLUMN_TYPE] => smallint
[COLUMN_POSITION] => 5
[DATA_TYPE] => smallint
[DEFAULT] => 0
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Group Id
)
[INCREMENT_ID] => Array
(
[COLUMN_NAME] => increment_id
[COLUMN_TYPE] => text
[COLUMN_POSITION] => 6
[DATA_TYPE] => text
[DEFAULT] =>
[NULLABLE] => 1
[LENGTH] => 50
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Increment Id
)
[STORE_ID] => Array
(
[COLUMN_NAME] => store_id
[COLUMN_TYPE] => smallint
[COLUMN_POSITION] => 7
[DATA_TYPE] => smallint
[DEFAULT] => 0
[NULLABLE] => 1
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Store Id
)
[CREATED_AT] => Array
(
[COLUMN_NAME] => created_at
[COLUMN_TYPE] => timestamp
[COLUMN_POSITION] => 8
[DATA_TYPE] => timestamp
[DEFAULT] =>
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Created At
)
[UPDATED_AT] => Array
(
[COLUMN_NAME] => updated_at
[COLUMN_TYPE] => timestamp
[COLUMN_POSITION] => 9
[DATA_TYPE] => timestamp
[DEFAULT] =>
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] =>
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Updated At
)
[IS_ACTIVE] => Array
(
[COLUMN_NAME] => is_active
[COLUMN_TYPE] => smallint
[COLUMN_POSITION] => 10
[DATA_TYPE] => smallint
[DEFAULT] => 1
[NULLABLE] =>
[LENGTH] =>
[SCALE] =>
[PRECISION] =>
[UNSIGNED] => 1
[PRIMARY] =>
[PRIMARY_POSITION] => 0
[IDENTITY] =>
[COMMENT] => Is Active
)
)
[_indexes:protected] => Array
(
[IDX_CUSTOMER_ENTITY_STORE_ID] => Array
(
[INDEX_NAME] => IDX_CUSTOMER_ENTITY_STORE_ID
[COLUMNS] => Array
(
[STORE_ID] => Array
(
[NAME] => store_id
[SIZE] =>
[POSITION] => 0
)
)
[TYPE] => index
)
[IDX_CUSTOMER_ENTITY_ENTITY_TYPE_ID] => Array
(
[INDEX_NAME] => IDX_CUSTOMER_ENTITY_ENTITY_TYPE_ID
[COLUMNS] => Array
(
[ENTITY_TYPE_ID] => Array
(
[NAME] => entity_type_id
[SIZE] =>
[POSITION] => 0
)
)
[TYPE] => index
)
[IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID] => Array
(
[INDEX_NAME] => IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID
[COLUMNS] => Array
(
[EMAIL] => Array
(
[NAME] => email
[SIZE] =>
[POSITION] => 0
)
[WEBSITE_ID] => Array
(
[NAME] => website_id
[SIZE] =>
[POSITION] => 1
)
)
[TYPE] => index
)
[IDX_CUSTOMER_ENTITY_WEBSITE_ID] => Array
(
[INDEX_NAME] => IDX_CUSTOMER_ENTITY_WEBSITE_ID
[COLUMNS] => Array
(
[WEBSITE_ID] => Array
(
[NAME] => website_id
[SIZE] =>
[POSITION] => 0
)
)
[TYPE] => index
)
)
[_foreignKeys:protected] => Array
(
[FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_ID] => Array
(
[FK_NAME] => FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_ID
[COLUMN_NAME] => store_id
[REF_TABLE_NAME] => core_store
[REF_COLUMN_NAME] => store_id
[ON_DELETE] => SET NULL
[ON_UPDATE] => CASCADE
)
[FK_CUSTOMER_ENTITY_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID] => Array
(
[FK_NAME] => FK_CUSTOMER_ENTITY_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID
[COLUMN_NAME] => website_id
[REF_TABLE_NAME] => core_website
[REF_COLUMN_NAME] => website_id
[ON_DELETE] => SET NULL
[ON_UPDATE] => CASCADE
)
)
[_options:protected] => Array
(
[type] => INNODB
[charset] => utf8
[collate] => utf8_general_ci
)
)
)
)
[8] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Customer/sql/customer_setup/install-1.6.0.0.php
)
[function] => include
)
[9] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 421
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 1.6.2.0.1
)
)
[10] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 327
[function] => _installResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 1.6.2.0.1
)
)
[11] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 235
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[12] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/App.php
[line] => 417
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[13] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/App.php
[line] => 343
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)
)
[14] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/Mage.php
[line] => 683
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)
)
)
)
[15] => Array
(
[file] => /www/wwwroot/kiwilighting.com/index.php
[line] => 87
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'customer_entity' already exists
)
)
)