Skip to content

Instantly share code, notes, and snippets.

@codeeshop-oc
Created July 4, 2021 09:24
Show Gist options
  • Save codeeshop-oc/7fa6164d7d0616008ebece76de3d300e to your computer and use it in GitHub Desktop.
Save codeeshop-oc/7fa6164d7d0616008ebece76de3d300e to your computer and use it in GitHub Desktop.
Preview Save Database
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment