You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

23 lines
1.3KB

  1. SET NAMES utf8mb4;
  2. SET FOREIGN_KEY_CHECKS = 0;
  3. -- ----------------------------
  4. -- Table structure for SHORT_URL
  5. -- ----------------------------
  6. DROP TABLE IF EXISTS `SHORT_URL`;
  7. CREATE TABLE `SHORT_URL` (
  8. `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  9. `random` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '随机串',
  10. `url` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '外部url',
  11. `valid` datetime(0) NULL DEFAULT NULL COMMENT '有效结束时间',
  12. `create_date` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  13. `user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属用户(保留)创建用户IP',
  14. `is_delete` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '是否删除 0可用 1被删除不可用',
  15. PRIMARY KEY (`id`) USING BTREE
  16. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  17. SET FOREIGN_KEY_CHECKS = 1;
  18. INSERT INTO `forwardurl`.`SHORT_URL`(`id`, `random`, `url`, `valid`, `create_date`, `user_id`, `is_delete`) VALUES ('defaults', 'defaults', 'https://bugdq.com', '2099-11-27 14:05:00', '2019-11-27 17:31:21', NULL, '0');