`host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'target''s host name', `port` int(11) DEFAULT NULL COMMENT 'port number used to connect to target', `db` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'target''s database name', `syntax` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'marc format provided by this target', `encoding` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'characters encoding provided by this target', Seems to me that those fields should be NOT NULL.
Noting that my production table looks like: `host` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `port` int(11) DEFAULT NULL, `db` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `syntax` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `encoding` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, Cannot find out why my host, syntax and encoding are NOT NULL. But it looks like that it is more correct. Did not find wrong dbrevs.
Linking it to the sync omnibus since it is at least very related in nature.