Re: VALUES deprecation on INSERT since 8.0.19
ok thank you
Here the needed tables and some example entries
CREATE TABLE `articles` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`appId` int unsigned DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`shortTitle` varchar(255) DEFAULT NULL,
`byline` varchar(1024) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
`artTimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='\r\n';
CREATE TABLE `articles_pre` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`appId` int unsigned DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`shortTitle` varchar(255) DEFAULT NULL,
`byline` varchar(1024) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
`artTimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='\r\n';
CREATE TABLE `cards_pre` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`collectionIdRef` int unsigned NOT NULL,
`name` varchar(65) DEFAULT NULL,
`contentType` enum('collection','article','banner') DEFAULT 'article',
`title` varchar(255) DEFAULT NULL,
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
`artIdRef` int unsigned DEFAULT NULL,
`crdTimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `artIdRef` (`artIdRef`),
CONSTRAINT `cards_pre_ibfk_1` FOREIGN KEY (`artIdRef`) REFERENCES `articles_pre` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
INSERT INTO `articles_pre`(`id`, `appId`, `title`, `shortTitle`, `byline`, `author`, `artTimestamp`) VALUES (1, 1, 'Knows 01(free)', NULL, NULL, NULL, '2019-11-19 15:29:40');
INSERT INTO `articles_pre`(`id`, `appId`, `title`, `shortTitle`, `byline`, `author`, `artTimestamp`) VALUES (2, 1, 'Knows 02 (free)', NULL, NULL, NULL, '2019-03-26 15:01:45');
INSERT INTO `articles_pre`(`id`, `appId`, `title`, `shortTitle`, `byline`, `author`, `artTimestamp`) VALUES (3, 1, 'Knows 03 (restricted)', NULL, NULL, NULL, '2019-03-20 16:35:39');
INSERT INTO `articles_pre`(`id`, `appId`, `title`, `shortTitle`, `byline`, `author`, `artTimestamp`) VALUES (4, 1, 'Knows 04 (restricted)', NULL, NULL, NULL, '2019-03-20 16:35:53');
INSERT INTO `articles`(`id`, `appId`, `title`, `shortTitle`, `byline`, `author`, `artTimestamp`) VALUES (1, 1, 'Knows 01(free)', NULL, NULL, NULL, '2019-11-19 15:29:40');
INSERT INTO `articles`(`id`, `appId`, `title`, `shortTitle`, `byline`, `author`, `artTimestamp`) VALUES (2, 1, 'Knows 02 (free)', NULL, NULL, NULL, '2019-03-26 15:01:45');
INSERT INTO `cards_pre`(`id`, `collectionIdRef`, `name`, `contentType`, `title`, `description`, `artIdRef`, `crdTimestamp`) VALUES (1, 1134, 'Art1', 'article', 'Art1', NULL, 1, '2018-11-30 16:52:28');
INSERT INTO `cards_pre`(`id`, `collectionIdRef`, `name`, `contentType`, `title`, `description`, `artIdRef`, `crdTimestamp`) VALUES (2, 1134, 'Art2', 'article', 'Art2', NULL, 2, '2018-11-30 16:52:28');
INSERT INTO `cards_pre`(`id`, `collectionIdRef`, `name`, `contentType`, `title`, `description`, `artIdRef`, `crdTimestamp`) VALUES (3, 1134, 'Art3', 'article', 'Art3', NULL, 3, '2018-11-30 16:52:28');
INSERT INTO `cards_pre`(`id`, `collectionIdRef`, `name`, `contentType`, `title`, `description`, `artIdRef`, `crdTimestamp`) VALUES (4, 1134, 'Art4', 'article', 'Art4', NULL, 4, '2018-11-30 16:52:28');
INSERT INTO `cards_pre`(`id`, `collectionIdRef`, `name`, `contentType`, `title`, `description`, `artIdRef`, `crdTimestamp`) VALUES (5, 1135, 'Art3', 'article', 'Art3', NULL, 3, '2018-11-30 16:52:28');