2021-007-jy-001.sql 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738
  1. /*
  2. Navicat MySQL Data Transfer
  3. Source Server : 本地
  4. Source Server Version : 50734
  5. Source Host : localhost:3306
  6. Source Database : gen
  7. Target Server Type : MYSQL
  8. Target Server Version : 50734
  9. File Encoding : 65001
  10. Date: 2021-07-01 11:05:26
  11. */
  12. SET FOREIGN_KEY_CHECKS=0;
  13. -- ----------------------------
  14. -- Table structure for platform_project_name_record
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `platform_project_name_record`;
  17. CREATE TABLE `platform_project_name_record` (
  18. `id` varchar(64) NOT NULL COMMENT 'id',
  19. `records_time` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '项目发布时间',
  20. `data_name` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '数据类型',
  21. `view_number` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '浏览数',
  22. `concern_number` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '关注数',
  23. `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  24. `create_by` varchar(64) DEFAULT NULL COMMENT '创建人',
  25. `update_by` varchar(64) DEFAULT NULL COMMENT '修改人',
  26. `update_date` datetime DEFAULT NULL COMMENT '修改时间',
  27. `backup_one` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备用字段1',
  28. `backup_two` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备用字段2',
  29. `backup_three` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备用字段3',
  30. `backup_four` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备用字段4',
  31. `backup_five` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备用字段5',
  32. PRIMARY KEY (`id`) USING BTREE
  33. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;