CREATE TABLE `models` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `user` varchar(64) NOT NULL
          PRIMARY KEY (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci";

CREATE TABLE `texts_model` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `text` varchar(1024) NOT NULL,
          PRIMARY KEY (id)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci";

CREATE TABLE `model_text_link` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `model_id` int(11) NOT NULL,
          `text_id` int(11) NOT NULL,
          `last_used` DATETIME NULL,
          PRIMARY KEY (`id`),
          KEY `model_id` (`model_id`),
          KEY `text_id` (`text_id`),
          CONSTRAINT `model_text_link_ibfk_1` FOREIGN KEY (`model_id`) REFERENCES `models` (`id`) ON DELETE CASCADE,
          CONSTRAINT `model_text_link_ibfk_2` FOREIGN KEY (`text_id`) REFERENCES `texts_model` (`id`) ON DELETE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci";

CREATE TRIGGER model_AI AFTER INSERT ON models FOR EACH ROW
BEGIN
INSERT INTO model_text_link (model_id, text_id) SELECT NEW.id, id as text_id FROM texts_model;
END;

CREATE TRIGGER texts_model_AI AFTER INSERT ON texts_model FOR EACH ROW
BEGIN
INSERT INTO model_text_link (model_id, text_id) SELECT id, NEW.id FROM models;
END;