Página Principal Explorar Ajuda
Registe-se Iniciar Sessão
lizhenghang
/
dev
1
0
Fork 0
Ficheiros Problemas 0 Pull Requests 0 Wiki
Ramo: master
Ramos Etiquetas
dev
/
2020
/
2020-010(OK)
/
2020-010-ljh-002.sql

2020-010-ljh-002.sql 12 KB
Link permanente Histórico Em bruto

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 10.0.1.159_3306
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50722
    7. 

  7.  Source Host           : 10.0.1.159:3306
    8. 

  8.  Source Schema         : dcp
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50722
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 13/10/2020 20:21:30
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. use dcp;
    20. 

  20. 

  21. -- ----------------------------
    22. 

  22. -- Table structure for base_portal_model_type_field
    23. 

  23. -- ----------------------------
    24. 

  24. DROP TABLE IF EXISTS `base_portal_model_type_field`;
    25. 

  25. CREATE TABLE `base_portal_model_type_field`  (
    26. 

  26.   `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '主键ID',
    27. 

  27.   `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块名称',
    28. 

  28.   `model_field_k` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原数据字段名',
    29. 

  29.   `model_field_v` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '转换数据字段名',
    30. 

  30.   `model_field_k_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'k字段的数据格式化',
    31. 

  31.   `model_field_k_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'k字段的数据类型',
    32. 

  32.   `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '语言版本',
    33. 

  33.   `order_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块顺序处理',
    34. 

  34.   `status` datetime(0) NULL DEFAULT NULL COMMENT '浏览时间',
    35. 

  35.   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
    36. 

  36.   `create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    37. 

  37.   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
    38. 

  38.   `update_date` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
    39. 

  39.   PRIMARY KEY (`id`) USING BTREE
    40. 

  40. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '门户-关注记录模块字段对应' ROW_FORMAT = Dynamic;
    41. 

  41. 

  42. -- ----------------------------
    43. 

  43. -- Records of base_portal_model_type_field
    44. 

  44. -- ----------------------------
    45. 

  45. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5e18c', 'enterprise', 'baseEntityId', 'id', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    46. 

  46. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5e19z', 'activity', 'baseActivityEntityId', 'id', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    47. 

  47. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5e291', 'country', 'baseEntityId', 'id', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    48. 

  48. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5e39c', 'project', 'projectId', 'id', NULL, 'string', 'EN', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    49. 

  49. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5ec8c', 'enterprise', 'baseEntityId', 'id', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    50. 

  50. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5ec90', 'activity', 'baseActivityEntityId', 'id', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    51. 

  51. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5ec91', 'country', 'baseEntityId', 'id', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    52. 

  52. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4d30040ff5ec9c', 'project', 'projectId', 'id', NULL, 'string', 'ZH', '1', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 06:06:49');
    53. 

  53. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da10040ff51597', 'activity', 'activityLogo', 'bannerImg', '0', 'string', 'EN', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    54. 

  54. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da11040ff5fc97', 'activity', 'activityLogo', 'bannerImg', '0', 'string', 'ZH', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    55. 

  55. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5109c', 'project', 'unitCountry', 'followUnitCountry', NULL, 'string', 'EN', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
    56. 

  56. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5119e', 'project', 'setUpDate', 'followSetUpDate', 'yyyy-MM-dd HH:mm:ss', 'date', 'EN', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
    57. 

  57. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5129z', 'project', 'setDownDate', 'Deadline', 'yyyy-MM-dd HH:mm:ss', 'date', 'EN', '5', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
    58. 

  58. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff54c8c', 'enterprise', 'unitName', 'followName', NULL, 'string', 'EN', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
    59. 

  59. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff55192', 'activity', 'activityName', 'followName', NULL, 'string', 'EN', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
    60. 

  60. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff55c92', 'country', 'zhName', 'followName', NULL, 'string', 'EN', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
    61. 

  61. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5e69c', 'project', 'projectName', 'followName', NULL, 'string', 'EN', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
    62. 

  62. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5ec8c', 'enterprise', 'unitName', 'followName', NULL, 'string', 'ZH', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
    63. 

  63. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5ec92', 'country', 'zhName', 'followName', NULL, 'string', 'ZH', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
    64. 

  64. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5ec9c', 'project', 'projectName', 'followName', NULL, 'string', 'ZH', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
    65. 

  65. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5ed92', 'activity', 'activityName', 'followName', NULL, 'string', 'ZH', '2', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
    66. 

  66. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5f88c', 'enterprise', 'unitCountry', 'followUnitCountry', NULL, 'string', 'EN', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
    67. 

  67. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5f993', 'country', 'are', 'followUnitCountry', NULL, 'string', 'EN', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
    68. 

  68. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fc8c', 'enterprise', 'unitCountry', 'followUnitCountry', NULL, 'string', 'ZH', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
    69. 

  69. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fc93', 'country', 'are', 'followUnitCountry', NULL, 'string', 'ZH', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
    70. 

  70. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fc9c', 'project', 'unitCountry', 'followUnitCountry', NULL, 'string', 'ZH', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
    71. 

  71. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fc9e', 'project', 'setUpDate', 'followSetUpDate', 'yyyy-MM-dd HH:mm:ss', 'date', 'ZH', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
    72. 

  72. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fc9z', 'project', 'setDownDate', 'Deadline', 'yyyy-MM-dd HH:mm:ss', 'date', 'ZH', '5', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 03:06:49');
    73. 

  73. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fm93', 'activity', 'activityArea', 'followUnitCountry', NULL, 'string', 'ZH', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
    74. 

  74. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da20040ff5fy93', 'activity', 'activityArea', 'followUnitCountry', NULL, 'string', 'EN', '3', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 01:06:49');
    75. 

  75. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5138c', 'enterprise', 'industry', 'unitLabel', NULL, 'string', 'EN', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    76. 

  76. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5149c', 'project', 'projectLabel', 'unitLabel', NULL, 'string', 'EN', '6', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    77. 

  77. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff51597', 'country', 'note', 'bannerImg', '0', 'string', 'EN', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    78. 

  78. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5169z', 'project', 'bannerList', 'bannerImg', '0', 'string', 'EN', '7', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    79. 

  79. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5ec8c', 'enterprise', 'industry', 'unitLabel', NULL, 'string', 'ZH', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    80. 

  80. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5ec9c', 'project', 'projectLabel', 'unitLabel', NULL, 'string', 'ZH', '6', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    81. 

  81. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5fc97', 'country', 'note', 'bannerImg', '0', 'string', 'ZH', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    82. 

  82. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eab4da30040ff5fc9z', 'project', 'bannerList', 'bannerImg', '0', 'string', 'ZH', '7', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    83. 

  83. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eae4da30040ff51597', 'enterprise', 'photo', 'bannerImg', '0', 'string', 'EN', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    84. 

  84. INSERT INTO `base_portal_model_type_field` VALUES ('88245820e13a11eae4da30040ff5fc97', 'enterprise', 'photo', 'bannerImg', '0', 'string', 'ZH', '4', '2020-08-18 18:08:27', NULL, '2020-08-18 18:06:49', NULL, '2020-08-18 05:06:49');
    85. 

  85. 

  86. SET FOREIGN_KEY_CHECKS = 1;
    87.