Preview Save Database

preview-db.sql

DROP TABLE IF EXISTS `preview`;
CREATE TABLE `tbl_preview` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `json_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `createdDtm` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp(),
  `updatedDtm` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;