Unnamed

CREATE TABLE IF NOT EXISTS shop_prod (
	    		shop_prod_id      INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	    		shop_prod_code    VARCHAR(32),
	    		shop_prod_title   VARCHAR(50) NOT NULL,
	    		shop_prod_text    MEDIUMBLOB NOT NULL,
	    		shop_prod_price   FLOAT NOTNULL,
	    		shop_prod_coin    INT(1) NOT NULL,
	    		shop_prod_pricemy FLOAT NOT NULL,
	    		shop_prod_coinmy  INT(1) NOT NULL,
	    		shop_prod_minqty  FLOAT NOT NULL,
	    		INDEX shop_prod_coin (shop_prod_coin),
	    		INDEX shop_prod_coinmy (shop_prod_coinmy),
    			FOREIGN KEY (shop_prod_coin)   REFERENCES shop_coin(shop_coin_id),
    			FOREIGN KEY (shop_prod_coinmy) REFERENCES shop_coin(shop_coin_id)
    		)
			ENGINE=INNODB;