gcol/r/innodb_virtual_fk.result

805 email_id int,
807 generated_email_id int as (email_id),
811 FOREIGN KEY (email_id) REFERENCES emails (id) ON DELETE SET NULL
815 email_id int,
816 PRIMARY KEY (email_id),
817 CONSTRAINT FK FOREIGN KEY (email_id) REFERENCES emails (id) ON DELETE CASCADE
821 INSERT INTO email_stats (id, email_id,  date_sent) VALUES (1,1,'Jan');
840 email_id int unsigned DEFAULT NULL,
846 KEY IDX_ES1 (email_id),
847 KEY mautic_generated_sent_date_email_id(generated_sent_date, email_id),
848 FOREIGN KEY (email_id) REFERENCES emails (id) ON DELETE SET NULL
851 INSERT INTO email_stats (id, email_id, date_sent)
854 id	email_id	date_sent	generated_sent_date
871 email_id int unsigned DEFAULT NULL,
877 KEY IDX_ES1 (email_id),
878 KEY mautic_generated_sent_date_email_id(generated_sent_date, email_id),
879 FOREIGN KEY (email_id) REFERENCES emails (id)
884 INSERT INTO email_stats (id, email_id, date_sent)
890 id	email_id	date_sent	generated_sent_date
893 SET email_id=2
896 id	email_id	date_sent	generated_sent_date
911 email_id int unsigned DEFAULT NULL,
914 (CONCAT(YEAR(date_sent), '-', COALESCE(email_id, '$'))),
916 KEY idx_es1 (email_id),
917 KEY mautic_generated_sent_date_email(generated_sent_email, email_id),
918 FOREIGN KEY (email_id) REFERENCES emails (id) ON DELETE SET NULL
921 INSERT INTO email_stats (id, email_id, date_sent)
924 id	email_id	date_sent	generated_sent_email
931 id	email_id	date_sent	generated_sent_email
946 email_id int unsigned DEFAULT NULL,
949 (CONCAT(YEAR(date_sent), '-', COALESCE(email_id, '$'))),
951 KEY idx_es1 (email_id),
952 KEY mautic_generated_sent_date_email(generated_sent_email, email_id),
953 FOREIGN KEY (email_id) REFERENCES emails (id) ON UPDATE SET NULL
956 INSERT INTO email_stats (id, email_id, date_sent)
959 id	email_id	date_sent	generated_sent_email
966 id	email_id	date_sent	generated_sent_email
980 email_id int unsigned DEFAULT NULL,
985 COALESCE(email_id, '$'))),
987 KEY idx_es1 (email_id),
988 KEY mautic_generated_sent_date_email (generated_sent_email, email_id),
989 FOREIGN KEY fk_ea1 (email_id) REFERENCES emails (breaker)
996   `email_id` int(10) unsigned DEFAULT NULL,
998 …` varchar(20) GENERATED ALWAYS AS (concat(year(`date_sent`),'-',coalesce(`email_id`,'$'))) VIRTUAL,
1000   KEY `idx_es1` (`email_id`),
1001   KEY `mautic_generated_sent_date_email` (`generated_sent_email`,`email_id`),
1002   CONSTRAINT `fk_ea1` FOREIGN KEY (`email_id`) REFERENCES `emails` (`breaker`) ON DELETE SET NULL
1005 INSERT INTO email_stats(id, email_id, date_sent)
1008 id	email_id	date_sent	generated_sent_email
1015 id	email_id	date_sent	generated_sent_email