SQLize | PHPize | SQLtest

-- CREATE TABLE IF NOT EXISTS dc_addtitionalproduct_insurance_relation_rule -- ( -- id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, -- shop_id INT NOT NULL, -- outlet_id INT NULL, -- additional_product_id INT NULL, -- insurance_type_id INT NULL, -- status_id INT NOT NULL, -- uid VARCHAR (CONCAT(shop_id, IFNULL(outlet_id, ''), IFNULL(additional_product_id, ''), IFNULL(insurance_type_id, ''), status_id)), -- CONSTRAINT dc_insurance_relation_rule_uc UNIQUE (uid) -- ); -- CREATE TABLE triangle ( -- sidea INT NOT NULL, -- sideb INT NULL, -- sidec VARCHAR(32) AS (MD5((CONCAT(sidea, IFNULL(sideb, ''))))), -- CONSTRAINT dc_insurance_relation_rule_uc UNIQUE (sidec) -- ); -- INSERT INTO triangle (sidea, sideb) VALUES(1, NULL); -- INSERT INTO triangle (sidea, sideb) VALUES(1, NULL); -- SELECT * FROM triangle; CREATE TABLE IF NOT EXISTS dc_addtitionalproduct_insurance_relation_rule ( uid VARCHAR(32) AS (MD5(CONCAT(shop_id, IFNULL(outlet_id, ''), IFNULL(additional_product_id, ''), IFNULL(insurance_type_id, ''), status_id))) INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, shop_id INT NOT NULL, outlet_id INT NULL, additional_product_id INT NULL, insurance_type_id INT NULL, status_id INT NOT NULL, -- uid VARCHAR(32) AS (MD5(CONCAT(shop_id, IFNULL(outlet_id, ''), IFNULL(additional_product_id, ''), IFNULL(insurance_type_id, ''), status_id))), -- CONSTRAINT dc_insurance_relation_rule_uc UNIQUE (uid) ); -- INSERT INTO dc_addtitionalproduct_insurance_relation_rule (shop_id, outlet_id, additional_product_id, insurance_type_id, status_id) VALUES(1, NULL, NULL, NULL, 1); -- INSERT INTO dc_addtitionalproduct_insurance_relation_rule (shop_id, outlet_id, additional_product_id, insurance_type_id, status_id) VALUES(1, NULL, 4, NULL, 1); -- SELECT * FROM dc_addtitionalproduct_insurance_relation_rule;