Project

General

Profile

Bug #542

修改数据库脚本（bug536：CCTV收藏模式名或者是摄像头收藏名字过长会导致插入数据库失败）

Added by pengfei xu over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
pengfei xu
Target version:
2.2.3 sp2
Start date:
05/06/2020
Due date:
% Done:

100%

Estimated time:
Defect version:

Description

需要对TB5014_CCTVDISPLAYMODE这张表里面的F5014_DESC字段进行修改,将之前的CHAR(40)修改为CHAR(255)。（因为mysql中char范围是1~255，所以oracle与mysql保持一致为char（255））

将semodel.TB2023_CCTVDEV表中F2023_DEVNO 改为char(40)；

新增：由于semodel.TB2023_CCTVDEV表中字段之前已手动更改，无需新增脚本，将脚本中相关内容注释；

History

#1

Updated by pengfei xu over 4 years ago

  • Status changed from New to In Progress
#2

Updated by xiangyang li over 4 years ago

  • Target version changed from 2.2.3 to 2.2.3 sp2
#3

Updated by pengfei xu over 4 years ago

  • Description updated (diff)
#4

Updated by pengfei xu over 4 years ago

  • Status changed from In Progress to Resolved
#5

Updated by pengfei xu over 4 years ago

  • Description updated (diff)
  • % Done changed from 0 to 100
#6

Updated by xiangyang li over 4 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF