561400 of lisp codes in a single log for `WARNING Source column "table"."column" is casted to type #1=#S(PGLOADER.CATALOG:SQLTYPE {561398_LINES} which is not the same as "...", the type of current target database column ..."` #1574

n0099 · 2024-04-11T09:11:40Z

pgloader --version

pgloader version "3.6.af8c3c1"
compiled with SBCL 2.1.11.debian

did you test a fresh compile from the source tree?
did you search for other similar issues?

how can I reproduce the bug?

LOAD DATABASE
     FROM mysql://user:@localhost/tbm
     INTO pgsql://user:@localhost/tbm

WITH quote identifiers, schema only

It will only logging with data only, not when importing schema and data within single pgloader process which is by default.

LOAD DATABASE
     FROM mysql://user:@localhost/db
     INTO pgsql://user:@localhost/db

WITH quote identifiers, data only, on error stop, workers = 2, concurrency = 1, batch rows = 100, batch size = 1MB, prefetch rows = 1000

pgloader output you obtain

$ wc -l enum
561400 enum
$ head enum

2024-04-09T05:26:32.560005+08:00 WARNING Source column "tbm"."tbmi_forum_script"."\"script\"" is casted to type #1=#S(PGLOADER.CATALOG:SQLTYPE
                                                                             :NAME "\"tbmi_forum_script_script\""
                                                                             :SCHEMA #2=#S(PGLOADER.CATALOG:SCHEMA
                                                                                           :SOURCE-NAME #3="tbm"
                                                                                           :NAME "\"tbm\""
                                                                                           :CATALOG #S(PGLOADER.CATALOG:CATALOG
                                                                                                       :NAME #3#
                                                                                                       :SCHEMA-LIST (#2#)
                                                                                                       :TYPES-WITHOUT-BTREE (("aclitem"
                                                                                                                              . "hash")

$ tail enum

                                                                                               :MATVIEW-LIST NIL
                                                                                               :EXTENSION-LIST NIL
                                                                                               :SQLTYPE-LIST NIL)
                                                                                 :TYPE :ENUM
                                                                                 :SOURCE-DEF #270#
                                                                                 :EXTRA ("TesseractHorizontal"
                                                                                         "TesseractVertical"
                                                                                         "PaddleOCRv4"
                                                                                         "PaddleOCRv3")
                                                                                 :EXTENSION NIL) which is not the same as "\"tbmi_ocr_box_Latn_recognizer\"", the type of current target database column "tbm"."tbmi_ocr_box_Latn"."recognizer".

The complete log is 91MiB large after decompress: enum.zip

data that is being loaded, if relevant

table schema

CREATE TABLE `tbm_bilibiliVote` (
  `pid` bigint NOT NULL,
  `authorUid` bigint NOT NULL,
  `authorExpGrade` int DEFAULT NULL,
  `isValid` tinyint(1) NOT NULL,
  `voteBy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `voteFor` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `replyContent` json DEFAULT NULL,
  `postTime` datetime NOT NULL,
  PRIMARY KEY (`pid`),
  KEY `authorUid` (`authorUid`),
  KEY `isVaild` (`isValid`) USING BTREE,
  KEY `voteFor` (`voteFor`(100),`isValid`) USING BTREE,
  KEY `postTime` (`postTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbm_forum` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `fid` int unsigned NOT NULL,
  `name` text NOT NULL,
  `isCrawling` tinyint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `fid` (`fid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f17019292_reply` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `pid` bigint unsigned NOT NULL,
  `floor` int unsigned NOT NULL,
  `authorUid` bigint NOT NULL,
  `subReplyCount` int unsigned DEFAULT NULL,
  `postedAt` int unsigned NOT NULL,
  `isFold` tinyint unsigned DEFAULT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `geolocation` blob,
  `signatureId` int unsigned DEFAULT NULL,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid` (`pid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `tid` (`tid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f17019292_reply_content` (
  `pid` bigint NOT NULL,
  `protoBufBytes` blob,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f17019292_reply_content_image` (
  `pid` bigint unsigned NOT NULL,
  `imageId` int unsigned NOT NULL,
  PRIMARY KEY (`pid`,`imageId`),
  KEY `imageId` (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f17019292_subReply` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `pid` bigint unsigned NOT NULL,
  `spid` bigint unsigned NOT NULL,
  `authorUid` bigint NOT NULL,
  `postedAt` int unsigned NOT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `spid` (`spid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `tid` (`tid`),
  KEY `pid` (`pid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f17019292_subReply_content` (
  `spid` bigint NOT NULL,
  `protoBufBytes` blob,
  PRIMARY KEY (`spid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f17019292_thread` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `threadType` bigint unsigned NOT NULL,
  `stickyType` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `topicType` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `isGood` tinyint DEFAULT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `authorUid` bigint NOT NULL,
  `postedAt` int unsigned NOT NULL,
  `latestReplyPostedAt` int unsigned NOT NULL,
  `latestReplierUid` bigint DEFAULT NULL,
  `replyCount` int unsigned DEFAULT NULL,
  `viewCount` int unsigned DEFAULT NULL,
  `shareCount` int unsigned DEFAULT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `zan` blob,
  `geolocation` blob,
  `authorPhoneType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tid` (`tid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f2265748_reply` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `pid` bigint unsigned NOT NULL,
  `floor` int unsigned NOT NULL,
  `authorUid` bigint NOT NULL,
  `subReplyCount` int unsigned DEFAULT NULL,
  `postedAt` int unsigned NOT NULL,
  `isFold` tinyint unsigned DEFAULT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `geolocation` blob,
  `signatureId` int unsigned DEFAULT NULL,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid` (`pid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `tid` (`tid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f2265748_reply_content` (
  `pid` bigint NOT NULL,
  `protoBufBytes` blob,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f2265748_reply_content_image` (
  `pid` bigint unsigned NOT NULL,
  `imageId` int unsigned NOT NULL,
  PRIMARY KEY (`pid`,`imageId`),
  KEY `imageId` (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f2265748_subReply` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `pid` bigint unsigned NOT NULL,
  `spid` bigint unsigned NOT NULL,
  `authorUid` bigint NOT NULL,
  `postedAt` int unsigned NOT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `spid` (`spid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `tid` (`tid`),
  KEY `pid` (`pid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f2265748_subReply_content` (
  `spid` bigint NOT NULL,
  `protoBufBytes` blob,
  PRIMARY KEY (`spid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f2265748_thread` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `threadType` bigint unsigned NOT NULL,
  `stickyType` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `topicType` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `isGood` tinyint DEFAULT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `authorUid` bigint NOT NULL,
  `postedAt` int unsigned NOT NULL,
  `latestReplyPostedAt` int unsigned NOT NULL,
  `latestReplierUid` bigint DEFAULT NULL,
  `replyCount` int unsigned DEFAULT NULL,
  `viewCount` int unsigned DEFAULT NULL,
  `shareCount` int unsigned DEFAULT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `zan` blob,
  `geolocation` blob,
  `authorPhoneType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tid` (`tid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f25459979_reply` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `pid` bigint unsigned NOT NULL,
  `floor` int unsigned NOT NULL,
  `authorUid` bigint NOT NULL,
  `subReplyCount` int unsigned DEFAULT NULL,
  `postedAt` int unsigned NOT NULL,
  `isFold` tinyint unsigned DEFAULT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `geolocation` blob,
  `signatureId` int unsigned DEFAULT NULL,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid` (`pid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `tid` (`tid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f25459979_reply_content` (
  `pid` bigint NOT NULL,
  `protoBufBytes` blob,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f25459979_reply_content_image` (
  `pid` bigint unsigned NOT NULL,
  `imageId` int unsigned NOT NULL,
  PRIMARY KEY (`pid`,`imageId`),
  KEY `imageId` (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f25459979_subReply` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `pid` bigint unsigned NOT NULL,
  `spid` bigint unsigned NOT NULL,
  `authorUid` bigint NOT NULL,
  `postedAt` int unsigned NOT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `spid` (`spid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `tid` (`tid`),
  KEY `pid` (`pid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f25459979_subReply_content` (
  `spid` bigint NOT NULL,
  `protoBufBytes` blob,
  PRIMARY KEY (`spid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f25459979_thread` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `threadType` bigint unsigned NOT NULL,
  `stickyType` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `topicType` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `isGood` tinyint DEFAULT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `authorUid` bigint NOT NULL,
  `postedAt` int unsigned NOT NULL,
  `latestReplyPostedAt` int unsigned NOT NULL,
  `latestReplierUid` bigint DEFAULT NULL,
  `replyCount` int unsigned DEFAULT NULL,
  `viewCount` int unsigned DEFAULT NULL,
  `shareCount` int unsigned DEFAULT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `zan` blob,
  `geolocation` blob,
  `authorPhoneType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tid` (`tid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f27546680_reply` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `pid` bigint unsigned NOT NULL,
  `floor` int unsigned NOT NULL,
  `authorUid` bigint NOT NULL,
  `subReplyCount` int unsigned DEFAULT NULL,
  `postedAt` int unsigned NOT NULL,
  `isFold` tinyint unsigned DEFAULT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `geolocation` blob,
  `signatureId` int unsigned DEFAULT NULL,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid` (`pid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `tid` (`tid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f27546680_reply_content` (
  `pid` bigint NOT NULL,
  `protoBufBytes` blob,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f27546680_reply_content_image` (
  `pid` bigint unsigned NOT NULL,
  `imageId` int unsigned NOT NULL,
  PRIMARY KEY (`pid`,`imageId`),
  KEY `imageId` (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f27546680_subReply` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `pid` bigint unsigned NOT NULL,
  `spid` bigint unsigned NOT NULL,
  `authorUid` bigint NOT NULL,
  `postedAt` int unsigned NOT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `spid` (`spid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `tid` (`tid`),
  KEY `pid` (`pid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f27546680_subReply_content` (
  `spid` bigint NOT NULL,
  `protoBufBytes` blob,
  PRIMARY KEY (`spid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f27546680_thread` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `threadType` bigint unsigned NOT NULL,
  `stickyType` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `topicType` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `isGood` tinyint DEFAULT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `authorUid` bigint NOT NULL,
  `postedAt` int unsigned NOT NULL,
  `latestReplyPostedAt` int unsigned NOT NULL,
  `latestReplierUid` bigint DEFAULT NULL,
  `replyCount` int unsigned DEFAULT NULL,
  `viewCount` int unsigned DEFAULT NULL,
  `shareCount` int unsigned DEFAULT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `zan` blob,
  `geolocation` blob,
  `authorPhoneType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tid` (`tid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f78579_reply` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `pid` bigint unsigned NOT NULL,
  `floor` int unsigned NOT NULL,
  `authorUid` bigint NOT NULL,
  `subReplyCount` int unsigned DEFAULT NULL,
  `postedAt` int unsigned NOT NULL,
  `isFold` tinyint unsigned DEFAULT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `geolocation` blob,
  `signatureId` int unsigned DEFAULT NULL,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid` (`pid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `tid` (`tid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f78579_reply_content` (
  `pid` bigint NOT NULL,
  `protoBufBytes` blob,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f78579_reply_content_image` (
  `pid` bigint unsigned NOT NULL,
  `imageId` int unsigned NOT NULL,
  PRIMARY KEY (`pid`,`imageId`),
  KEY `imageId` (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f78579_subReply` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `pid` bigint unsigned NOT NULL,
  `spid` bigint unsigned NOT NULL,
  `authorUid` bigint NOT NULL,
  `postedAt` int unsigned NOT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `spid` (`spid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `tid` (`tid`),
  KEY `pid` (`pid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f78579_subReply_content` (
  `spid` bigint NOT NULL,
  `protoBufBytes` blob,
  PRIMARY KEY (`spid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmc_f78579_thread` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tid` bigint unsigned NOT NULL,
  `threadType` bigint unsigned NOT NULL,
  `stickyType` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `topicType` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `isGood` tinyint DEFAULT NULL,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `authorUid` bigint NOT NULL,
  `postedAt` int unsigned NOT NULL,
  `latestReplyPostedAt` int unsigned NOT NULL,
  `latestReplierUid` bigint DEFAULT NULL,
  `replyCount` int unsigned DEFAULT NULL,
  `viewCount` int unsigned DEFAULT NULL,
  `shareCount` int unsigned DEFAULT NULL,
  `agreeCount` int DEFAULT NULL,
  `disagreeCount` int DEFAULT NULL,
  `zan` blob,
  `geolocation` blob,
  `authorPhoneType` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `createdAt` int unsigned NOT NULL,
  `updatedAt` int unsigned DEFAULT NULL,
  `lastSeenAt` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tid` (`tid`) USING BTREE,
  KEY `authorUid` (`authorUid`),
  KEY `postTime` (`postedAt` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_failed` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `imageId` int unsigned NOT NULL,
  `exception` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `imageId` (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_forum_script` (
  `fid` int unsigned NOT NULL,
  `script` enum('Hans','Hant','Jpan','Latn') NOT NULL,
  PRIMARY KEY (`fid`,`script`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_hash` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `pHash` binary(8) NOT NULL,
  `averageHash` binary(8) NOT NULL,
  `blockMeanHash` binary(32) NOT NULL,
  `marrHildrethHash` binary(72) NOT NULL,
  `thumbHash` tinyblob NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_metadata` (
  `imageId` int unsigned NOT NULL,
  `format` enum('jpeg','png','gif','bmp') NOT NULL,
  `width` smallint unsigned NOT NULL,
  `height` smallint unsigned NOT NULL,
  `bitsPerPixel` tinyint unsigned NOT NULL,
  `frameCount` smallint unsigned NOT NULL,
  `xxHash3` binary(8) NOT NULL,
  PRIMARY KEY (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_metadata_bmp` (
  `imageId` int unsigned NOT NULL,
  `infoHeaderType` enum('WinVersion2','Os2Version2Short','WinVersion3','AdobeVersion3','AdobeVersion3WithAlpha','Os2Version2','WinVersion4','WinVersion5') NOT NULL,
  `bitsPerPixel` enum('Pixel1','Pixel2','Pixel4','Pixel8','Pixel16','Pixel24','Pixel32') NOT NULL,
  PRIMARY KEY (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_metadata_downloadedByteSize` (
  `imageId` int unsigned NOT NULL,
  `downloadedByteSize` int unsigned NOT NULL,
  PRIMARY KEY (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_metadata_embedded_exif` (
  `imageId` int unsigned NOT NULL,
  `orientation` text,
  `imageDescription` text,
  `userComment` text,
  `artist` text,
  `xpAuthor` text,
  `copyright` text,
  `imageUniqueId` text,
  `bodySerialNumber` text,
  `make` text,
  `model` text,
  `software` text,
  `customRendered` smallint DEFAULT NULL,
  `dateTime` datetime DEFAULT NULL,
  `dateTimeOffset` text,
  `dateTimeDigitized` datetime DEFAULT NULL,
  `dateTimeDigitizedOffset` text,
  `dateTimeOriginal` datetime DEFAULT NULL,
  `dateTimeOriginalOffset` text,
  `offsetTime` text,
  `offsetTimeDigitized` text,
  `offsetTimeOriginal` text,
  `gpsDateTime` datetime DEFAULT NULL,
  `gpsCoordinate` point DEFAULT NULL,
  `gpsImgDirection` float DEFAULT NULL,
  `gpsImgDirectionRef` text,
  `rawBytes` blob,
  `xxHash3` binary(8) NOT NULL,
  PRIMARY KEY (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_metadata_embedded_exif_old` (
  `imageId` int unsigned NOT NULL,
  `orientation` enum('Horizontal','MirrorHorizontal','Rotate180','MirrorVertical','MirrorHorizontalRotate270Cw','Rotate90Cw','MirrorHorizontalRotate90Cw','Rotate270Cw') DEFAULT NULL,
  `make` text,
  `model` text,
  `createDate` datetime DEFAULT NULL,
  `modifyDate` datetime DEFAULT NULL,
  `tagNames` json NOT NULL,
  `rawBytes` blob NOT NULL,
  PRIMARY KEY (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_metadata_embedded_exif_tagName` (
  `imageId` int unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`imageId`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_metadata_embedded_icc` (
  `imageId` int unsigned NOT NULL,
  `rawBytes` mediumblob,
  `xxHash3` binary(8) NOT NULL,
  PRIMARY KEY (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_metadata_embedded_iptc` (
  `imageId` int unsigned NOT NULL,
  `rawBytes` blob,
  `xxHash3` binary(8) NOT NULL,
  PRIMARY KEY (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_metadata_embedded_xmp` (
  `imageId` int unsigned NOT NULL,
  `rawBytes` mediumblob,
  `xxHash3` binary(8) NOT NULL,
  PRIMARY KEY (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_metadata_gif` (
  `imageId` int unsigned NOT NULL,
  `repeatCount` smallint unsigned NOT NULL,
  `colorTableMode` enum('Global','Local') NOT NULL,
  `globalColorTableLength` int NOT NULL,
  `comments` json DEFAULT NULL,
  PRIMARY KEY (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_metadata_jpg` (
  `imageId` int unsigned NOT NULL,
  `quality` int NOT NULL,
  `colorType` enum('YCbCrRatio420','YCbCrRatio444','YCbCrRatio422','YCbCrRatio411','YCbCrRatio410','Luminance','Rgb','Cmyk','Ycck') DEFAULT NULL,
  `interleaved` tinyint DEFAULT NULL,
  `progressive` tinyint DEFAULT NULL,
  PRIMARY KEY (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_metadata_png` (
  `imageId` int unsigned NOT NULL,
  `bitDepth` enum('Bit1','Bit2','Bit4','Bit8','Bit16') DEFAULT NULL,
  `colorType` enum('Grayscale','Rgb','Palette','GrayscaleWithAlpha','RgbWithAlpha') DEFAULT NULL,
  `interlaceMethod` enum('None','Adam7') DEFAULT NULL,
  `gamma` float NOT NULL,
  `transparentR` tinyint unsigned DEFAULT NULL,
  `transparentG` tinyint unsigned DEFAULT NULL,
  `transparentB` tinyint unsigned DEFAULT NULL,
  `textData` json DEFAULT NULL,
  PRIMARY KEY (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_box_Hans` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `centerPointX` smallint unsigned NOT NULL,
  `centerPointY` smallint unsigned NOT NULL,
  `width` smallint unsigned NOT NULL,
  `height` smallint unsigned NOT NULL,
  `rotationDegrees` smallint unsigned NOT NULL,
  `recognizer` enum('TesseractHorizontal','TesseractVertical','PaddleOCRv4','PaddleOCRv3') NOT NULL,
  `confidence` tinyint unsigned NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`,`centerPointX`,`centerPointY`,`width`,`height`,`rotationDegrees`,`recognizer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_box_Hant` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `centerPointX` smallint unsigned NOT NULL,
  `centerPointY` smallint unsigned NOT NULL,
  `width` smallint unsigned NOT NULL,
  `height` smallint unsigned NOT NULL,
  `rotationDegrees` smallint unsigned NOT NULL,
  `recognizer` enum('TesseractHorizontal','TesseractVertical','PaddleOCRv4','PaddleOCRv3') NOT NULL,
  `confidence` tinyint unsigned NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`,`centerPointX`,`centerPointY`,`width`,`height`,`rotationDegrees`,`recognizer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_box_Jpan` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `centerPointX` smallint unsigned NOT NULL,
  `centerPointY` smallint unsigned NOT NULL,
  `width` smallint unsigned NOT NULL,
  `height` smallint unsigned NOT NULL,
  `rotationDegrees` smallint unsigned NOT NULL,
  `recognizer` enum('TesseractHorizontal','TesseractVertical','PaddleOCRv4','PaddleOCRv3') NOT NULL,
  `confidence` tinyint unsigned NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`,`centerPointX`,`centerPointY`,`width`,`height`,`rotationDegrees`,`recognizer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_box_Latn` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `centerPointX` smallint unsigned NOT NULL,
  `centerPointY` smallint unsigned NOT NULL,
  `width` smallint unsigned NOT NULL,
  `height` smallint unsigned NOT NULL,
  `rotationDegrees` smallint unsigned NOT NULL,
  `recognizer` enum('TesseractHorizontal','TesseractVertical','PaddleOCRv4','PaddleOCRv3') NOT NULL,
  `confidence` tinyint unsigned NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`,`centerPointX`,`centerPointY`,`width`,`height`,`rotationDegrees`,`recognizer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f17019292` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f19871743` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f2265748` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f228500` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f23546288` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f25459979` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f27278534` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f27497591` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f27546680` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f3255599` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f4734432` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f6087183` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f78579` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f898666` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hans_f97650` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Hant_f228500` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Jpan_f2265748` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Jpan_f25459979` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Jpan_f27278534` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Jpan_f27497591` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Jpan_f27546680` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Jpan_f3255599` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Jpan_f78579` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Jpan_f97650` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Latn_f19871743` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_ocr_line_Latn_f23546288` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `textLines` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `tbmi_qrCode` (
  `imageId` int unsigned NOT NULL,
  `frameIndex` int unsigned NOT NULL,
  `point1X` smallint NOT NULL,
  `point1Y` smallint NOT NULL,
  `point2X` smallint NOT NULL,
  `point2Y` smallint NOT NULL,
  `point3X` smallint NOT NULL,
  `point3Y` smallint NOT NULL,
  `point4X` smallint NOT NULL,
  `point4Y` smallint NOT NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`imageId`,`frameIndex`,`point1X`,`point1Y`,`point2X`,`point2Y`,`point3X`,`point3Y`,`point4X`,`point4Y`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

How the data is different from what you expected, if relevant

All data are the same with doublecheck after import.

The text was updated successfully, but these errors were encountered:

n0099 · 2024-04-16T18:30:27Z

A shorter one with 352 lines:

2024-04-17T02:28:21.032000+08:00 LOG pgloader version "3.6.af8c3c1"
2024-04-17T02:28:21.231999+08:00 LOG Migrating from #<MYSQL-CONNECTION mysql://pgloader@localhost:3306/tbm {1007F66303}>
2024-04-17T02:28:21.231999+08:00 LOG Migrating into #<PGSQL-CONNECTION pgsql://tbm@localhost:5432/tbm {1007F66F23}>
2024-04-17T02:28:21.543997+08:00 WARNING Source column "tbm"."tbmi_metadata_embedded_exif_old"."\"orientation\"" is casted to type #1=#S(PGLOADER.CATALOG:SQLTYPE
                                                                                                :NAME "\"tbmi_metadata_embedded_exif_old_orientation\""
                                                                                                :SCHEMA #2=#S(PGLOADER.CATALOG:SCHEMA
                                                                                                              :SOURCE-NAME #3="tbm"
                                                                                                              :NAME "\"tbm\""
                                                                                                              :CATALOG #S(PGLOADER.CATALOG:CATALOG
                                                                                                                          :NAME #3#
                                                                                                                          :SCHEMA-LIST (#2#)
                                                                                                                          :TYPES-WITHOUT-BTREE (("aclitem"
                                                                                                                                                 . "hash")
                                                                                                                                                ("box"
                                                                                                                                                 . "gist")
                                                                                                                                                ("cid"
                                                                                                                                                 . "hash")
                                                                                                                                                ("circle"
                                                                                                                                                 . "gist")
                                                                                                                                                ("point"
                                                                                                                                                 . "gist")
                                                                                                                                                ("polygon"
                                                                                                                                                 . "gist")
                                                                                                                                                ("xid"
                                                                                                                                                 . "hash"))
                                                                                                                          :DISTRIBUTION-RULES NIL)
                                                                                                              :IN-SEARCH-PATH T
                                                                                                              :TABLE-LIST (#S(PGLOADER.CATALOG:TABLE
                                                                                                                              :SOURCE-NAME #4="tbmi_metadata_embedded_exif_old"
                                                                                                                              :NAME "\"tbmi_metadata_embedded_exif_old\""
                                                                                                                              :SCHEMA #2#
                                                                                                                              :OID 240037
                                                                                                                              :COMMENT NIL
                                                                                                                              :STORAGE-PARAMETER-LIST NIL
                                                                                                                              :TABLESPACE NIL
                                                                                                                              :ROW-COUNT-ESTIMATE 270818
                                                                                                                              :FIELD-LIST (#S(PGLOADER.SOURCE.MYSQL::MYSQL-COLUMN
                                                                                                                                              :TABLE-NAME #4#
                                                                                                                                              :NAME "imageId"
                                                                                                                                              :DTYPE "int"
                                                                                                                                              :CTYPE "int unsigned"
                                                                                                                                              :DEFAULT NIL
                                                                                                                                              :NULLABLE "NO"
                                                                                                                                              :EXTRA NIL
                                                                                                                                              :COMMENT NIL)
                                                                                                                                           #S(PGLOADER.SOURCE.MYSQL::MYSQL-COLUMN
                                                                                                                                              :TABLE-NAME "tbmi_metadata_embedded_exif_old"
                                                                                                                                              :NAME "orientation"
                                                                                                                                              :DTYPE "enum"
                                                                                                                                              :CTYPE #5="enum('Horizontal','MirrorHorizontal','Rotate180','MirrorVertical','MirrorHorizontalRotate270Cw','Rotate90Cw','MirrorHorizontalRotate90Cw','Rotate270Cw')"
                                                                                                                                              :DEFAULT NIL
                                                                                                                                              :NULLABLE "YES"
                                                                                                                                              :EXTRA NIL
                                                                                                                                              :COMMENT NIL)
                                                                                                                                           #S(PGLOADER.SOURCE.MYSQL::MYSQL-COLUMN
                                                                                                                                              :TABLE-NAME "tbmi_metadata_embedded_exif_old"
                                                                                                                                              :NAME "make"
                                                                                                                                              :DTYPE "text"
                                                                                                                                              :CTYPE "text"
                                                                                                                                              :DEFAULT NIL
                                                                                                                                              :NULLABLE "YES"
                                                                                                                                              :EXTRA NIL
                                                                                                                                              :COMMENT NIL)
                                                                                                                                           #S(PGLOADER.SOURCE.MYSQL::MYSQL-COLUMN
                                                                                                                                              :TABLE-NAME "tbmi_metadata_embedded_exif_old"
                                                                                                                                              :NAME "model"
                                                                                                                                              :DTYPE "text"
                                                                                                                                              :CTYPE "text"
                                                                                                                                              :DEFAULT NIL
                                                                                                                                              :NULLABLE "YES"
                                                                                                                                              :EXTRA NIL
                                                                                                                                              :COMMENT NIL)
                                                                                                                                           #S(PGLOADER.SOURCE.MYSQL::MYSQL-COLUMN
                                                                                                                                              :TABLE-NAME "tbmi_metadata_embedded_exif_old"
                                                                                                                                              :NAME "createDate"
                                                                                                                                              :DTYPE "datetime"
                                                                                                                                              :CTYPE "datetime"
                                                                                                                                              :DEFAULT NIL
                                                                                                                                              :NULLABLE "YES"
                                                                                                                                              :EXTRA NIL
                                                                                                                                              :COMMENT NIL)
                                                                                                                                           #S(PGLOADER.SOURCE.MYSQL::MYSQL-COLUMN
                                                                                                                                              :TABLE-NAME "tbmi_metadata_embedded_exif_old"
                                                                                                                                              :NAME "modifyDate"
                                                                                                                                              :DTYPE "datetime"
                                                                                                                                              :CTYPE "datetime"
                                                                                                                                              :DEFAULT NIL
                                                                                                                                              :NULLABLE "YES"
                                                                                                                                              :EXTRA NIL
                                                                                                                                              :COMMENT NIL)
                                                                                                                                           #S(PGLOADER.SOURCE.MYSQL::MYSQL-COLUMN
                                                                                                                                              :TABLE-NAME "tbmi_metadata_embedded_exif_old"
                                                                                                                                              :NAME "tagNames"
                                                                                                                                              :DTYPE "json"
                                                                                                                                              :CTYPE #6="json"
                                                                                                                                              :DEFAULT NIL
                                                                                                                                              :NULLABLE "NO"
                                                                                                                                              :EXTRA NIL
                                                                                                                                              :COMMENT NIL)
                                                                                                                                           #S(PGLOADER.SOURCE.MYSQL::MYSQL-COLUMN
                                                                                                                                              :TABLE-NAME "tbmi_metadata_embedded_exif_old"
                                                                                                                                              :NAME "rawBytes"
                                                                                                                                              :DTYPE "blob"
                                                                                                                                              :CTYPE "blob"
                                                                                                                                              :DEFAULT NIL
                                                                                                                                              :NULLABLE "NO"
                                                                                                                                              :EXTRA NIL
                                                                                                                                              :COMMENT NIL))
                                                                                                                              :COLUMN-LIST (#S(PGLOADER.CATALOG:COLUMN
                                                                                                                                               :TABLE NIL
                                                                                                                                               :NAME "\"imageId\""
                                                                                                                                               :TYPE-NAME "bigint"
                                                                                                                                               :TYPE-MOD NIL
                                                                                                                                               :NULLABLE NIL
                                                                                                                                               :DEFAULT NIL
                                                                                                                                               :COMMENT NIL
                                                                                                                                               :TRANSFORM NIL
                                                                                                                                               :EXTRA NIL
                                                                                                                                               :TRANSFORM-DEFAULT T)
                                                                                                                                            #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                               :TABLE NIL
                                                                                                                                               :NAME "\"orientation\""
                                                                                                                                               :TYPE-NAME #1#
                                                                                                                                               :TYPE-MOD NIL
                                                                                                                                               :NULLABLE T
                                                                                                                                               :DEFAULT NIL
                                                                                                                                               :COMMENT NIL
                                                                                                                                               :TRANSFORM NIL
                                                                                                                                               :EXTRA NIL
                                                                                                                                               :TRANSFORM-DEFAULT T)
                                                                                                                                            #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                               :TABLE NIL
                                                                                                                                               :NAME "\"make\""
                                                                                                                                               :TYPE-NAME #7="text"
                                                                                                                                               :TYPE-MOD NIL
                                                                                                                                               :NULLABLE T
                                                                                                                                               :DEFAULT NIL
                                                                                                                                               :COMMENT NIL
                                                                                                                                               :TRANSFORM PGLOADER.TRANSFORMS::REMOVE-NULL-CHARACTERS
                                                                                                                                               :EXTRA NIL
                                                                                                                                               :TRANSFORM-DEFAULT T)
                                                                                                                                            #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                               :TABLE NIL
                                                                                                                                               :NAME "\"model\""
                                                                                                                                               :TYPE-NAME #7#
                                                                                                                                               :TYPE-MOD NIL
                                                                                                                                               :NULLABLE T
                                                                                                                                               :DEFAULT NIL
                                                                                                                                               :COMMENT NIL
                                                                                                                                               :TRANSFORM PGLOADER.TRANSFORMS::REMOVE-NULL-CHARACTERS
                                                                                                                                               :EXTRA NIL
                                                                                                                                               :TRANSFORM-DEFAULT T)
                                                                                                                                            #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                               :TABLE NIL
                                                                                                                                               :NAME "\"createDate\""
                                                                                                                                               :TYPE-NAME #8="timestamptz"
                                                                                                                                               :TYPE-MOD NIL
                                                                                                                                               :NULLABLE T
                                                                                                                                               :DEFAULT NIL
                                                                                                                                               :COMMENT NIL
                                                                                                                                               :TRANSFORM PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL
                                                                                                                                               :EXTRA NIL
                                                                                                                                               :TRANSFORM-DEFAULT T)
                                                                                                                                            #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                               :TABLE NIL
                                                                                                                                               :NAME "\"modifyDate\""
                                                                                                                                               :TYPE-NAME #8#
                                                                                                                                               :TYPE-MOD NIL
                                                                                                                                               :NULLABLE T
                                                                                                                                               :DEFAULT NIL
                                                                                                                                               :COMMENT NIL
                                                                                                                                               :TRANSFORM PGLOADER.TRANSFORMS::ZERO-DATES-TO-NULL
                                                                                                                                               :EXTRA NIL
                                                                                                                                               :TRANSFORM-DEFAULT T)
                                                                                                                                            #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                               :TABLE NIL
                                                                                                                                               :NAME "\"tagNames\""
                                                                                                                                               :TYPE-NAME #6#
                                                                                                                                               :TYPE-MOD NIL
                                                                                                                                               :NULLABLE NIL
                                                                                                                                               :DEFAULT NIL
                                                                                                                                               :COMMENT NIL
                                                                                                                                               :TRANSFORM NIL
                                                                                                                                               :EXTRA NIL
                                                                                                                                               :TRANSFORM-DEFAULT T)
                                                                                                                                            #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                               :TABLE NIL
                                                                                                                                               :NAME "\"rawBytes\""
                                                                                                                                               :TYPE-NAME "bytea"
                                                                                                                                               :TYPE-MOD NIL
                                                                                                                                               :NULLABLE NIL
                                                                                                                                               :DEFAULT NIL
                                                                                                                                               :COMMENT NIL
                                                                                                                                               :TRANSFORM PGLOADER.TRANSFORMS::BYTE-VECTOR-TO-BYTEA
                                                                                                                                               :EXTRA NIL
                                                                                                                                               :TRANSFORM-DEFAULT T))
                                                                                                                              :INDEX-LIST #9=(#S(PGLOADER.CATALOG:INDEX
                                                                                                                                                 :NAME "\"idx_240037_PRIMARY\""
                                                                                                                                                 :OID 240042
                                                                                                                                                 :SCHEMA #10=#S(PGLOADER.CATALOG:SCHEMA
                                                                                                                                                                :SOURCE-NAME "tbm"
                                                                                                                                                                :NAME "\"tbm\""
                                                                                                                                                                :CATALOG #S(PGLOADER.CATALOG:CATALOG
                                                                                                                                                                            :NAME "tbm"
                                                                                                                                                                            :SCHEMA-LIST (#10#)
                                                                                                                                                                            :TYPES-WITHOUT-BTREE NIL
                                                                                                                                                                            :DISTRIBUTION-RULES NIL)
                                                                                                                                                                :IN-SEARCH-PATH NIL
                                                                                                                                                                :TABLE-LIST (#11=#S(PGLOADER.CATALOG:TABLE
                                                                                                                                                                                    :SOURCE-NAME "tbmi_metadata_embedded_exif_old"
                                                                                                                                                                                    :NAME "\"tbmi_metadata_embedded_exif_old\""
                                                                                                                                                                                    :SCHEMA #10#
                                                                                                                                                                                    :OID 240037
                                                                                                                                                                                    :COMMENT NIL
                                                                                                                                                                                    :STORAGE-PARAMETER-LIST NIL
                                                                                                                                                                                    :TABLESPACE NIL
                                                                                                                                                                                    :ROW-COUNT-ESTIMATE 0
                                                                                                                                                                                    :FIELD-LIST (#S(PGLOADER.CATALOG:COLUMN
                                                                                                                                                                                                    :TABLE #11#
                                                                                                                                                                                                    :NAME "imageId"
                                                                                                                                                                                                    :TYPE-NAME "bigint"
                                                                                                                                                                                                    :TYPE-MOD :NULL
                                                                                                                                                                                                    :NULLABLE NIL
                                                                                                                                                                                                    :DEFAULT :NULL
                                                                                                                                                                                                    :COMMENT NIL
                                                                                                                                                                                                    :TRANSFORM NIL
                                                                                                                                                                                                    :EXTRA NIL
                                                                                                                                                                                                    :TRANSFORM-DEFAULT NIL)
                                                                                                                                                                                                 #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                                                                                    :TABLE #11#
                                                                                                                                                                                                    :NAME "orientation"
                                                                                                                                                                                                    :TYPE-NAME "tbmi_metadata_embedded_exif_old_orientation"
                                                                                                                                                                                                    :TYPE-MOD :NULL
                                                                                                                                                                                                    :NULLABLE T
                                                                                                                                                                                                    :DEFAULT :NULL
                                                                                                                                                                                                    :COMMENT NIL
                                                                                                                                                                                                    :TRANSFORM NIL
                                                                                                                                                                                                    :EXTRA NIL
                                                                                                                                                                                                    :TRANSFORM-DEFAULT NIL)
                                                                                                                                                                                                 #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                                                                                    :TABLE #11#
                                                                                                                                                                                                    :NAME "make"
                                                                                                                                                                                                    :TYPE-NAME "text"
                                                                                                                                                                                                    :TYPE-MOD :NULL
                                                                                                                                                                                                    :NULLABLE T
                                                                                                                                                                                                    :DEFAULT :NULL
                                                                                                                                                                                                    :COMMENT NIL
                                                                                                                                                                                                    :TRANSFORM NIL
                                                                                                                                                                                                    :EXTRA NIL
                                                                                                                                                                                                    :TRANSFORM-DEFAULT NIL)
                                                                                                                                                                                                 #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                                                                                    :TABLE #11#
                                                                                                                                                                                                    :NAME "model"
                                                                                                                                                                                                    :TYPE-NAME "text"
                                                                                                                                                                                                    :TYPE-MOD :NULL
                                                                                                                                                                                                    :NULLABLE T
                                                                                                                                                                                                    :DEFAULT :NULL
                                                                                                                                                                                                    :COMMENT NIL
                                                                                                                                                                                                    :TRANSFORM NIL
                                                                                                                                                                                                    :EXTRA NIL
                                                                                                                                                                                                    :TRANSFORM-DEFAULT NIL)
                                                                                                                                                                                                 #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                                                                                    :TABLE #11#
                                                                                                                                                                                                    :NAME "createDate"
                                                                                                                                                                                                    :TYPE-NAME "timestamp with time zone"
                                                                                                                                                                                                    :TYPE-MOD :NULL
                                                                                                                                                                                                    :NULLABLE T
                                                                                                                                                                                                    :DEFAULT :NULL
                                                                                                                                                                                                    :COMMENT NIL
                                                                                                                                                                                                    :TRANSFORM NIL
                                                                                                                                                                                                    :EXTRA NIL
                                                                                                                                                                                                    :TRANSFORM-DEFAULT NIL)
                                                                                                                                                                                                 #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                                                                                    :TABLE #11#
                                                                                                                                                                                                    :NAME "modifyDate"
                                                                                                                                                                                                    :TYPE-NAME "timestamp with time zone"
                                                                                                                                                                                                    :TYPE-MOD :NULL
                                                                                                                                                                                                    :NULLABLE T
                                                                                                                                                                                                    :DEFAULT :NULL
                                                                                                                                                                                                    :COMMENT NIL
                                                                                                                                                                                                    :TRANSFORM NIL
                                                                                                                                                                                                    :EXTRA NIL
                                                                                                                                                                                                    :TRANSFORM-DEFAULT NIL)
                                                                                                                                                                                                 #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                                                                                    :TABLE #11#
                                                                                                                                                                                                    :NAME "tagNames"
                                                                                                                                                                                                    :TYPE-NAME "json"
                                                                                                                                                                                                    :TYPE-MOD :NULL
                                                                                                                                                                                                    :NULLABLE NIL
                                                                                                                                                                                                    :DEFAULT :NULL
                                                                                                                                                                                                    :COMMENT NIL
                                                                                                                                                                                                    :TRANSFORM NIL
                                                                                                                                                                                                    :EXTRA NIL
                                                                                                                                                                                                    :TRANSFORM-DEFAULT NIL)
                                                                                                                                                                                                 #S(PGLOADER.CATALOG:COLUMN
                                                                                                                                                                                                    :TABLE #11#
                                                                                                                                                                                                    :NAME "rawBytes"
                                                                                                                                                                                                    :TYPE-NAME "bytea"
                                                                                                                                                                                                    :TYPE-MOD :NULL
                                                                                                                                                                                                    :NULLABLE NIL
                                                                                                                                                                                                    :DEFAULT :NULL
                                                                                                                                                                                                    :COMMENT NIL
                                                                                                                                                                                                    :TRANSFORM NIL
                                                                                                                                                                                                    :EXTRA NIL
                                                                                                                                                                                                    :TRANSFORM-DEFAULT NIL))
                                                                                                                                                                                    :COLUMN-LIST NIL
                                                                                                                                                                                    :INDEX-LIST #9#
                                                                                                                                                                                    :FKEY-LIST NIL
                                                                                                                                                                                    :TRIGGER-LIST NIL
                                                                                                                                                                                    :CITUS-RULE NIL))
                                                                                                                                                                :VIEW-LIST NIL
                                                                                                                                                                :MATVIEW-LIST NIL
                                                                                                                                                                :EXTENSION-LIST NIL
                                                                                                                                                                :SQLTYPE-LIST (#S(PGLOADER.CATALOG:SQLTYPE
                                                                                                                                                                                  :NAME "\"tbmi_metadata_embedded_exif_old_orientation\""
                                                                                                                                                                                  :SCHEMA #10#
                                                                                                                                                                                  :TYPE :ENUM
                                                                                                                                                                                  :SOURCE-DEF NIL
                                                                                                                                                                                  :EXTRA ("Horizontal"
                                                                                                                                                                                          "MirrorHorizontal"
                                                                                                                                                                                          "Rotate180"
                                                                                                                                                                                          "MirrorVertical"
                                                                                                                                                                                          "MirrorHorizontalRotate270Cw"
                                                                                                                                                                                          "Rotate90Cw"
                                                                                                                                                                                          "MirrorHorizontalRotate90Cw"
                                                                                                                                                                                          "Rotate270Cw")
                                                                                                                                                                                  :EXTENSION NIL)))
                                                                                                                                                 :TABLE #11#
                                                                                                                                                 :TYPE NIL
                                                                                                                                                 :PRIMARY T
                                                                                                                                                 :UNIQUE T
                                                                                                                                                 :COLUMNS ("imageId")
                                                                                                                                                 :SQL "CREATE UNIQUE INDEX \"idx_240037_PRIMARY\" ON tbm.tbmi_metadata_embedded_exif_old USING btree (\"imageId\")"
                                                                                                                                                 :CONNAME "\"idx_240037_PRIMARY\""
                                                                                                                                                 :CONDEF "PRIMARY KEY (\"imageId\")"
                                                                                                                                                 :FILTER NIL
                                                                                                                                                 :FK-DEPS NIL))
                                                                                                                              :FKEY-LIST NIL
                                                                                                                              :TRIGGER-LIST NIL
                                                                                                                              :CITUS-RULE NIL))
                                                                                                              :VIEW-LIST NIL
                                                                                                              :MATVIEW-LIST NIL
                                                                                                              :EXTENSION-LIST NIL
                                                                                                              :SQLTYPE-LIST NIL)
                                                                                                :TYPE :ENUM
                                                                                                :SOURCE-DEF #5#
                                                                                                :EXTRA ("Horizontal"
                                                                                                        "MirrorHorizontal"
                                                                                                        "Rotate180"
                                                                                                        "MirrorVertical"
                                                                                                        "MirrorHorizontalRotate270Cw"
                                                                                                        "Rotate90Cw"
                                                                                                        "MirrorHorizontalRotate90Cw"
                                                                                                        "Rotate270Cw")
                                                                                                :EXTENSION NIL) which is not the same as "tbmi_metadata_embedded_exif_old_orientation", the type of current target database column "tbm"."tbmi_metadata_embedded_exif_old"."orientation".

using following mysql table schema:

CREATE TABLE `tbmi_metadata_embedded_exif_old` (
  `imageId` int unsigned NOT NULL,
  `orientation` enum('Horizontal','MirrorHorizontal','Rotate180','MirrorVertical','MirrorHorizontalRotate270Cw','Rotate90Cw','MirrorHorizontalRotate90Cw','Rotate270Cw') DEFAULT NULL,
  `make` text,
  `model` text,
  `createDate` datetime DEFAULT NULL,
  `modifyDate` datetime DEFAULT NULL,
  `tagNames` json NOT NULL,
  `rawBytes` blob NOT NULL,
  PRIMARY KEY (`imageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

561400 of lisp codes in a single log for `WARNING Source column "table"."column" is casted to type #1=#S(PGLOADER.CATALOG:SQLTYPE {561398_LINES} which is not the same as "...", the type of current target database column ..."` #1574

561400 of lisp codes in a single log for `WARNING Source column "table"."column" is casted to type #1=#S(PGLOADER.CATALOG:SQLTYPE {561398_LINES} which is not the same as "...", the type of current target database column ..."` #1574

n0099 commented Apr 11, 2024 •

edited

n0099 commented Apr 16, 2024 •

edited

561400 of lisp codes in a single log for WARNING Source column "table"."column" is casted to type #1=#S(PGLOADER.CATALOG:SQLTYPE {561398_LINES} which is not the same as "...", the type of current target database column ..." #1574

561400 of lisp codes in a single log for WARNING Source column "table"."column" is casted to type #1=#S(PGLOADER.CATALOG:SQLTYPE {561398_LINES} which is not the same as "...", the type of current target database column ..." #1574

Comments

n0099 commented Apr 11, 2024 • edited

n0099 commented Apr 16, 2024 • edited

561400 of lisp codes in a single log for `WARNING Source column "table"."column" is casted to type #1=#S(PGLOADER.CATALOG:SQLTYPE {561398_LINES} which is not the same as "...", the type of current target database column ..."` #1574

561400 of lisp codes in a single log for `WARNING Source column "table"."column" is casted to type #1=#S(PGLOADER.CATALOG:SQLTYPE {561398_LINES} which is not the same as "...", the type of current target database column ..."` #1574

n0099 commented Apr 11, 2024 •

edited

n0099 commented Apr 16, 2024 •

edited