katao/data/sql/patch-2011-11-08.sql

SET FOREIGN_KEY_CHECKS = 0;

SET AUTOCOMMIT = 0;
START TRANSACTION;

CREATE TABLE `katao_supplier_product_category`
(
	`katao_supplier_id` INTEGER  NOT NULL,
	`katao_product_category_id` INTEGER  NOT NULL,
	PRIMARY KEY (`katao_supplier_id`,`katao_product_category_id`),
	CONSTRAINT `katao_supplier_product_category_FK_1`
		FOREIGN KEY (`katao_supplier_id`)
		REFERENCES `katao_supplier` (`id`)
		ON UPDATE CASCADE
		ON DELETE CASCADE,
	INDEX `katao_supplier_product_category_FI_2` (`katao_product_category_id`),
	CONSTRAINT `katao_supplier_product_category_FK_2`
		FOREIGN KEY (`katao_product_category_id`)
		REFERENCES `katao_product_category` (`id`)
		ON UPDATE CASCADE
		ON DELETE CASCADE
)Engine=InnoDB;

SET FOREIGN_KEY_CHECKS = 1;

COMMIT;