mysql create table demo

Just a demo..

CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `product_id` varchar(100) NOT NULL COMMENT '商品id',
  `product_name` varchar(255) DEFAULT NULL COMMENT '商品名',
  `price` varchar(100) DEFAULT NULL COMMENT '价格',
  `shop_name` varchar(100) DEFAULT NULL COMMENT '店铺名',
  `product_desc` text DEFAULT NULL COMMENT '商品描述',
  `create_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  `update_dt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_products` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='demo_products';