Project

General

Profile

Bug #542

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

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

Status:
Closed
Priority:
Normal
Assignee:
Target version:
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 about 4 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF