ホーム エクスプローラ ヘルプ
登録 サインイン
lizhenghang
/
dev
1
0
フォーク 0
ファイル 課題 0 プルリクエスト 0 Wiki
ツリー: 4f971b3fae
ブランチ タグ
dev
/
2020
/
2020-024(OK)
/
2020-024-ljh-001.sql

2020-024-ljh-001.sql 12 KB
履歴 Raw

12345678910111213141516171819202122232425262728293031 
  1. use dcp;
    2. 

  2. INSERT INTO `dcp`.`base_portal_model_type_query_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e14a11eab4d30040ff5ec9i', 'investmentGuidelines', 'language', 'language', NULL, 'string', 'ZH', '1', '2020-12-22 16:45:54', NULL, '2020-12-22 16:45:59', NULL, '2020-12-22 16:46:03');
    3. 

  3. INSERT INTO `dcp`.`base_portal_model_type_query_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e14a11eab4d30040ff5ec9j', 'investmentGuidelines', 'language', 'language', NULL, 'string', 'EN', '1', '2020-12-22 16:45:56', NULL, '2020-12-22 16:46:00', NULL, '2020-12-22 16:46:05');
    4. 

  4. INSERT INTO `dcp`.`base_portal_model_type_query_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e14a11eab4d30040ff5ec9l', 'investmentGuidelines', 'ids', 'ids', NULL, 'string', 'EN', '1', '2020-12-22 16:46:44', NULL, '2020-12-22 16:46:47', NULL, '2020-12-22 16:46:50');
    5. 

  5. INSERT INTO `dcp`.`base_portal_model_type_query_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e14a11eab4d30040ff5ec9m', 'investmentGuidelines', 'ids', 'ids', NULL, 'string', 'ZH', '1', '2020-12-22 16:46:46', NULL, '2020-12-22 16:46:49', NULL, '2020-12-22 16:46:53');
    6. 

  6. INSERT INTO `dcp`.`base_portal_model_type_query_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e15a11eab4d30040ff5ec9i', 'financialInstitution', 'language', 'language', NULL, 'string', 'ZH', '1', '2020-12-22 16:45:54', NULL, '2020-12-22 16:45:59', NULL, '2020-12-22 16:46:03');
    7. 

  7. INSERT INTO `dcp`.`base_portal_model_type_query_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e15a11eab4d30040ff5ec9j', 'financialInstitution', 'language', 'language', NULL, 'string', 'EN', '1', '2020-12-22 16:45:56', NULL, '2020-12-22 16:46:00', NULL, '2020-12-22 16:46:05');
    8. 

  8. INSERT INTO `dcp`.`base_portal_model_type_query_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e15a11eab4d30040ff5ec9l', 'financialInstitution', 'ids', 'ids', NULL, 'string', 'EN', '1', '2020-12-22 16:46:44', NULL, '2020-12-22 16:46:47', NULL, '2020-12-22 16:46:50');
    9. 

  9. INSERT INTO `dcp`.`base_portal_model_type_query_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e15a11eab4d30040ff5ec9m', 'financialInstitution', 'ids', 'ids', NULL, 'string', 'ZH', '1', '2020-12-22 16:46:46', NULL, '2020-12-22 16:46:49', NULL, '2020-12-22 16:46:53');
    10. 

  10. INSERT INTO `dcp`.`base_portal_model_type`(`id`, `model_name`, `language`, `model_type`, `model_get_url`, `follow_time`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('913d7028e29713eab4Ea20040ff5fc10', '金融机构', 'ZH', 'financialInstitution', 'http://itim-project-service/baseFinancialInstitutionInfos/getViewByIdsAndLanguage', '2020-12-22 16:34:05', NULL, '2020-12-22 16:34:06', NULL, '2020-12-22 16:34:10');
    11. 

  11. INSERT INTO `dcp`.`base_portal_model_type`(`id`, `model_name`, `language`, `model_type`, `model_get_url`, `follow_time`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('913d7028e29713eab4Ea20040ff5fc8p', '投资指引', 'ZH', 'investmentGuidelines', 'http://itim-project-service/baseInvestmentGuidelinesInfos/getViewByIdsAndLanguage', '2020-12-22 14:02:35', NULL, '2020-12-23 14:02:39', NULL, '2020-12-22 14:02:50');
    12. 

  12. INSERT INTO `dcp`.`base_portal_model_type`(`id`, `model_name`, `language`, `model_type`, `model_get_url`, `follow_time`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('913d7028e29713eab4Ea20040ff5fc9p', 'Investment', 'EN', 'investmentGuidelines', 'http://itim-project-service/baseInvestmentGuidelinesInfos/getViewByIdsAndLanguage', '2020-08-20 11:46:58', NULL, '2020-08-20 11:45:19', NULL, '2020-08-18 02:45:19');
    13. 

  13. INSERT INTO `dcp`.`base_portal_model_type`(`id`, `model_name`, `language`, `model_type`, `model_get_url`, `follow_time`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('913d7028e29713eab4Ea20040ff5fcp', 'Financial', 'EN', 'financialInstitution', 'http://itim-project-service/baseFinancialInstitutionInfos/getViewByIdsAndLanguage', '2020-12-22 15:31:23', NULL, '2020-12-22 15:31:25', NULL, '2020-12-22 15:31:27');
    14. 

  14. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e13a12eab4d30040ff5e291', 'financialInstitution', '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');
    15. 

  15. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e13a12eab4d30040ff5ec91', 'financialInstitution', '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');
    16. 

  16. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e13a12eab4da20040ff55c92', 'financialInstitution', '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');
    17. 

  17. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e13a12eab4da20040ff5ec92', 'financialInstitution', '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');
    18. 

  18. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e13a12eab4da20040ff5f993', 'financialInstitution', 'unitCity', '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');
    19. 

  19. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e13a12eab4da20040ff5fc93', 'financialInstitution', 'unitCity', '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');
    20. 

  20. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e13a12eab4da30040ff51597', 'financialInstitution', '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');
    21. 

  21. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e13a12eab4da30040ff5fc97', 'financialInstitution', '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');
    22. 

  22. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e14a12eab4d30040ff5e291', 'investmentGuidelines', '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');
    23. 

  23. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e14a12eab4d30040ff5ec91', 'investmentGuidelines', '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');
    24. 

  24. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e14a12eab4da20040ff55c92', 'investmentGuidelines', 'name', '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');
    25. 

  25. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e14a12eab4da20040ff5ec92', 'investmentGuidelines', 'name', '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');
    26. 

  26. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e14a12eab4da20040ff5f993', 'investmentGuidelines', 'countriesName', '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');
    27. 

  27. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e14a12eab4da20040ff5fc93', 'investmentGuidelines', 'countriesName', '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');
    28. 

  28. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e14a12eab4da30040ff51597', 'investmentGuidelines', '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');
    29. 

  29. INSERT INTO `dcp`.`base_portal_model_type_field`(`id`, `model_type`, `model_field_k`, `model_field_v`, `model_field_k_format`, `model_field_k_type`, `language`, `order_type`, `status`, `create_by`, `create_date`, `update_by`, `update_date`) VALUES ('88245820e14a12eab4da30040ff5fc97', 'investmentGuidelines', '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');
    30. 

  30. 

  31. /*已操作161,159*/
    32.