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 $installer = $this;
00028
00029
00030 $installer->startSetup();
00031
00032 $installer->run("
00033
00034 -- DROP TABLE IF EXISTS `{$this->getTable('cataloginventory_stock')}`;
00035 CREATE TABLE `{$this->getTable('cataloginventory_stock')}` (
00036 `stock_id` smallint(4) unsigned NOT NULL auto_increment,
00037 `stock_name` varchar(255) NOT NULL default '',
00038 PRIMARY KEY (`stock_id`)
00039 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog inventory Stocks list';
00040
00041 insert into `{$this->getTable('cataloginventory_stock')}`(`stock_id`,`stock_name`) values (1, 'Default');
00042
00043 -- DROP TABLE IF EXISTS `{$this->getTable('cataloginventory_stock_item')}`;
00044 CREATE TABLE `{$this->getTable('cataloginventory_stock_item')}` (
00045 `item_id` int(10) unsigned NOT NULL auto_increment,
00046 `product_id` int(10) unsigned NOT NULL default '0',
00047 `stock_id` smallint(4) unsigned NOT NULL default '0',
00048 `qty` decimal(12,4) NOT NULL default '0.0000',
00049 `min_qty` decimal(12,4) NOT NULL default '0.0000',
00050 `use_config_min_qty` tinyint(1) unsigned NOT NULL default '1',
00051 `is_qty_decimal` tinyint(1) unsigned NOT NULL default '0',
00052 `backorders` tinyint(3) unsigned NOT NULL default '0',
00053 `use_config_backorders` tinyint(1) unsigned NOT NULL default '1',
00054 `min_sale_qty` decimal(12,4) NOT NULL default '1.0000',
00055 `use_config_min_sale_qty` tinyint(1) unsigned NOT NULL default '1',
00056 `max_sale_qty` decimal(12,4) NOT NULL default '0.0000',
00057 `use_config_max_sale_qty` tinyint(1) unsigned NOT NULL default '1',
00058 `is_in_stock` tinyint(1) unsigned NOT NULL default '0',
00059 PRIMARY KEY (`item_id`),
00060 UNIQUE KEY `IDX_STOCK_PRODUCT` (`product_id`,`stock_id`),
00061 KEY `FK_CATALOGINVENTORY_STOCK_ITEM_PRODUCT` (`product_id`),
00062 KEY `FK_CATALOGINVENTORY_STOCK_ITEM_STOCK` (`stock_id`),
00063 CONSTRAINT `FK_CATALOGINVENTORY_STOCK_ITEM_PRODUCT` FOREIGN KEY (`product_id`) REFERENCES `{$this->getTable('catalog_product_entity')}` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
00064 CONSTRAINT `FK_CATALOGINVENTORY_STOCK_ITEM_STOCK` FOREIGN KEY (`stock_id`) REFERENCES `{$this->getTable('cataloginventory_stock')}` (`stock_id`) ON DELETE CASCADE ON UPDATE CASCADE
00065 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Inventory Stock Item Data';
00066
00067 ");
00068
00069 $installer->endSetup();
00070