vr_cultural_log.sql 1.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : seeseele服务器
  4. Source Server Type : MySQL
  5. Source Server Version : 80021
  6. Source Host : 175.178.124.133:3306
  7. Source Schema : vrone
  8. Target Server Type : MySQL
  9. Target Server Version : 80021
  10. File Encoding : 65001
  11. Date: 02/12/2024 19:06:26
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for vr_cultural_log
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `vr_cultural_log`;
  19. CREATE TABLE `vr_cultural_log` (
  20. `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  21. `user_id` int NULL DEFAULT NULL COMMENT '用户id',
  22. `type_id` int NULL DEFAULT NULL COMMENT '类型id',
  23. `count` int NULL DEFAULT 0 COMMENT '数量',
  24. `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  25. `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '创建者',
  26. `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  27. `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NULL DEFAULT NULL COMMENT '修改者',
  28. PRIMARY KEY (`id`) USING BTREE
  29. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_german2_ci COMMENT = '文创类型创建数统计表' ROW_FORMAT = Dynamic;
  30. -- ----------------------------
  31. -- Records of vr_cultural_log
  32. -- ----------------------------
  33. INSERT INTO `vr_cultural_log` VALUES (1, 100, 1, 2, '2024-07-29 16:14:59', 'seeseele', '2024-07-29 16:15:18', 'seeseele');
  34. SET FOREIGN_KEY_CHECKS = 1;