tify"> `Name_metall` varchar (20) DEFAULT NULL, KEY (`ID`)
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = koi8r;
-------------------------- structure for production
-------------------------- TABLE IF EXISTS `production`; TABLE `production` (
`ID` int (11) NOT NULL AUTO_INCREMENT,
`Name` varchar (20) DEFAULT NULL,
`Type_ex_ID` int (11) DEFAULT NULL,
`ID_supplier` int (11) DEFAULT NULL,
`ID_manufacturer` int (11) DEFAULT NULL,
`Price` int (11) DEFAULT NULL, KEY (`ID`), `FK_7` (`Type_ex_ID`), `FK_8` (`ID_supplier`), `FK_10` (`ID_manufacturer` ), `FK_8` FOREIGN KEY (`ID_supplier`) REFERENCES `suppliers` (`ID`) ON DELETE SET NULL ON UPDATE CASCADE, `FK_10` FOREIGN KEY (`ID_manufacturer`) REFERENCES `manufacturer` (`ID`) ON DELETE SET NULL ON UPDATE CASCADE, `FK_7` FOREIGN KEY (`Type_ex_ID`) REFERENCES `type_ex` (`ID`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 6 DEFAULT CHARSET = koi8r;
-------------------------- structure for shop
-------------------------- TABLE IF EXISTS `shop`; TABLE `shop` (
`ID` int (11) NOT NULL AUTO_INCREMENT,
`Name_shop` varchar (20) DEFAULT NULL, KEY (`ID`)
) ENGINE = InnoDB AUTO_INCREMENT = 6 DEFAULT CHARSET = koi8r;
-------------------------- structure for shop_ex
-------------------------- TABLE IF EXISTS `shop_ex`; TABLE `shop_ex` (
`ID` int (11) NOT NULL AUTO_INCREMENT,
`Shop_ID` int (11) DEFAULT NULL,
`Production_ID` int (11) DEFAULT NULL,
`Comments` varchar (50) DEFAULT NULL, KEY (`ID`), `FK_2` (`Shop_ID`), `FK_3` (`Production_ID`), `FK_3` FOREIGN KEY (` Production_ID `) REFERENCES` production `(` ID `) ON DELETE CASCADE ON UPDATE CASCADE,` FK_2 `FOREIGN KEY (` Shop_ID `) REFERENCES` shop `(` ID `) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 10 DEFAULT CHARSET = koi8r;
-------------------------- structure for stone
-------------------------- TABLE IF EXISTS `stone`; TABLE `stone` (
`ID` int (11) NOT NULL AUTO_INCREMENT,
`Name_stone` varchar (20) DEFAULT NULL, KEY (`ID`)
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = koi8r;
-------------------------- structure for suppliers
-------------------------- TABLE IF EXISTS `suppliers`; TABLE `suppliers` (
`ID` int (11) NOT NULL AUTO_INCREMENT,
`Name_s...
