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] => /sweetpack/lib/Zend/Db/Statement/Pdo.php [line:protected] => 234 [trace:Exception:private] => Array ( [0] => Array ( [file] => /sweetpack/lib/Varien/Db/Statement/Pdo/Mysql.php [line] => 110 [function] => _execute [class] => Zend_Db_Statement_Pdo [type] => -> [args] => Array ( [0] => Array ( ) ) ) [1] => Array ( [file] => /sweetpack/lib/Zend/Db/Statement.php [line] => 300 [function] => _execute [class] => Varien_Db_Statement_Pdo_Mysql [type] => -> [args] => Array ( [0] => Array ( ) ) ) [2] => Array ( [file] => /sweetpack/lib/Zend/Db/Adapter/Abstract.php [line] => 479 [function] => execute [class] => Zend_Db_Statement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [3] => Array ( [file] => /sweetpack/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 COMMENT 'Created At', `updated_at` timestamp NOT NULL 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] => /sweetpack/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 419 [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 COMMENT 'Created At', `updated_at` timestamp NOT NULL 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] => /sweetpack/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 2039 [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 COMMENT 'Created At', `updated_at` timestamp NOT NULL 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] => /sweetpack/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] => /sweetpack/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 624 [args] => Array ( [0] => /sweetpack/app/code/core/Mage/Customer/sql/customer_setup/install-1.6.0.0.php ) [function] => include ) [8] => Array ( [file] => /sweetpack/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] => /sweetpack/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] => /sweetpack/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] => /sweetpack/app/code/core/Mage/Core/Model/App.php [line] => 417 [function] => applyAllUpdates [class] => Mage_Core_Model_Resource_Setup [type] => :: [args] => Array ( ) ) [12] => Array ( [file] => /sweetpack/app/code/core/Mage/Core/Model/App.php [line] => 343 [function] => _initModules [class] => Mage_Core_Model_App [type] => -> [args] => Array ( ) ) [13] => Array ( [file] => /sweetpack/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] => /sweetpack/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] => /sweetpack/lib/Zend/Db/Statement/Pdo.php [line:protected] => 228 [trace:Exception:private] => Array ( [0] => Array ( [file] => /sweetpack/lib/Zend/Db/Statement/Pdo.php [line] => 228 [function] => execute [class] => PDOStatement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [1] => Array ( [file] => /sweetpack/lib/Varien/Db/Statement/Pdo/Mysql.php [line] => 110 [function] => _execute [class] => Zend_Db_Statement_Pdo [type] => -> [args] => Array ( [0] => Array ( ) ) ) [2] => Array ( [file] => /sweetpack/lib/Zend/Db/Statement.php [line] => 300 [function] => _execute [class] => Varien_Db_Statement_Pdo_Mysql [type] => -> [args] => Array ( [0] => Array ( ) ) ) [3] => Array ( [file] => /sweetpack/lib/Zend/Db/Adapter/Abstract.php [line] => 479 [function] => execute [class] => Zend_Db_Statement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [4] => Array ( [file] => /sweetpack/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 COMMENT 'Created At', `updated_at` timestamp NOT NULL 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] => /sweetpack/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 419 [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 COMMENT 'Created At', `updated_at` timestamp NOT NULL 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] => /sweetpack/lib/Varien/Db/Adapter/Pdo/Mysql.php [line] => 2039 [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 COMMENT 'Created At', `updated_at` timestamp NOT NULL 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] => /sweetpack/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] => /sweetpack/app/code/core/Mage/Core/Model/Resource/Setup.php [line] => 624 [args] => Array ( [0] => /sweetpack/app/code/core/Mage/Customer/sql/customer_setup/install-1.6.0.0.php ) [function] => include ) [9] => Array ( [file] => /sweetpack/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] => /sweetpack/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] => /sweetpack/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] => /sweetpack/app/code/core/Mage/Core/Model/App.php [line] => 417 [function] => applyAllUpdates [class] => Mage_Core_Model_Resource_Setup [type] => :: [args] => Array ( ) ) [13] => Array ( [file] => /sweetpack/app/code/core/Mage/Core/Model/App.php [line] => 343 [function] => _initModules [class] => Mage_Core_Model_App [type] => -> [args] => Array ( ) ) [14] => Array ( [file] => /sweetpack/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] => /sweetpack/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 ) ) )