14 lines
565 B
SQL
14 lines
565 B
SQL
CREATE OR REPLACE TABLE `util`.`logCleanMultiConfig` (
|
|
`schemaName` varchar(64) NOT NULL,
|
|
`tableName` varchar(64) NOT NULL,
|
|
`retentionDays` int(11) DEFAULT NULL,
|
|
`order` int(11) DEFAULT NULL,
|
|
`started` datetime DEFAULT NULL,
|
|
`finished` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`schemaName`,`tableName`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
|
|
|
|
INSERT INTO `util`.`logCleanMultiConfig` (`schemaName`, `tableName`)
|
|
SELECT TABLE_SCHEMA, TABLE_NAME FROM information_schema.`COLUMNS`
|
|
WHERE COLUMN_NAME IN ('newInstance', 'newInstance');
|