DemacMedia/Magento-Multi-Location-Inventory — pull request #6 by SchumacherFM (2014-08-12 23:40:13+00:00)
Title: BUGFIX: Creation of table stock_status_index failed

because the columns which references to the foreign key columns must be equal to them: size and signed/unsigned. So I've added the correct size and type to those two columns.

Can you confirm that or will it only happen on my database?

Check check check ...

I've just found the original table structure of a fresh 1.8.1.0 install:

Table structure for `core_store`

```
DROP TABLE IF EXISTS `core_store`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `core_store` (
`store_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Store Id',
`code` varchar(32) DEFAULT NULL COMMENT 'Code',
`website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website Id',

```

and `catalog_product_entity`:

```
DROP TABLE IF EXISTS `catalog_product_entity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalog_product_entity` (
`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
`entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
`attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
```

So it seems that maybe other use should also run into that installation issue ...

This is a really cool module. I've got a lot of inspiration from it :+1: