--liquibase formatted sql

--changeset cyril:qc_item_category
CREATE TABLE `qc_item_category`
(
    `id`           INT NOT NULL,
    `qcItemId`     INT NOT NULL,
    `qcCategoryId` INT NOT NULL,
    PRIMARY KEY (`id`),
    INDEX          `FK_QC_ITEM_CATEGORY_ON_QCITEMID` (`qcItemId` ASC) VISIBLE,
    INDEX          `FK_QC_ITEM_CATEGORY_ON_QCCATEGORYID` (`qcCategoryId` ASC) VISIBLE,
    CONSTRAINT `FK_QC_ITEM_CATEGORY_ON_QCITEMID`
        FOREIGN KEY (`qcItemId`)
            REFERENCES `qc_item` (`id`)
            ON DELETE RESTRICT
            ON UPDATE RESTRICT,
    CONSTRAINT `FK_QC_ITEM_CATEGORY_ON_QCCATEGORYID`
        FOREIGN KEY (`qcCategoryId`)
            REFERENCES `qc_category` (`id`)
            ON DELETE RESTRICT
            ON UPDATE RESTRICT
);
