DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
	`id` INTEGER UNSIGNED AUTO_INCREMENT,
	`firstname` VARCHAR(50) NOT NULL,
	`lastname` VARCHAR(50) NOT NULL,
	`email` VARCHAR(128) NOT NULL,
	`phone` VARCHAR(20),
	`custinfo` JSON NOT NULL,
	`title` VARCHAR(50) GENERATED ALWAYS AS (JSON_VALUE(`custinfo`, "$.title")),
	`zipcode` VARCHAR(10) AS (JSON_VALUE(`custinfo`, "$.zipcode")),
 
	`created` DATETIME DEFAULT CURRENT_TIMESTAMP,
	`modified` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 
	PRIMARY KEY PK_COMMENT_ID(`id`),
	UNIQUE KEY UI_COMMENT_EMAIL(`email`),
	KEY IX_COMMENT_ZIPCODE(`zipcode`)
);
 
 
INSERT INTO `comment` ( `firstname` , `lastname` , `email` , `phone`, `custinfo` )
VALUES
	("Eugene", "X", "example@example.com", "00123", '{"zipcode": "123123"}');