Mer-No.05 IP溯源添加新的字段

sql : select * from dic_vendor_field_def where perf_class = 'L0510' and is_available = 1 for update

 

 

insert into dic_vendor_field_def (ID, PERF_CLASS, FIELD_ID, SERIAL, FIELD_TYPE, FIELD_VENDOR_LABEL, FIELD_NAME, TABLE_NAME, TABLE_COLUMN, TABLE_COLUMN_TYPE, FIELD_FORMULA, IS_AVAILABLE, IS_INDEX, IND_TABLE_NAME, IND_TABLE_COLUMN, IND_TABLE_COLUMN_TYPE, SQLLDR_DATATYPE, GROUP_NAME, REMARK, PROJECTIONS, ISJUMP, FILESTORE_MMSBLACK, FILESTORE_BROWSEBLACK, BRANCHSTORE_ERRORTDR)
values (51000017, 'L0510', 'MC0510000017', 17, 1, 13, 'USERTYPE', 'perf_o_syslog_brd', 'USERTYPE', 'int', '', 1, 0, '', '', '', '', '', '', '', 1, null, null, null);

insert into dic_vendor_field_def (ID, PERF_CLASS, FIELD_ID, SERIAL, FIELD_TYPE, FIELD_VENDOR_LABEL, FIELD_NAME, TABLE_NAME, TABLE_COLUMN, TABLE_COLUMN_TYPE, FIELD_FORMULA, IS_AVAILABLE, IS_INDEX, IND_TABLE_NAME, IND_TABLE_COLUMN, IND_TABLE_COLUMN_TYPE, SQLLDR_DATATYPE, GROUP_NAME, REMARK, PROJECTIONS, ISJUMP, FILESTORE_MMSBLACK, FILESTORE_BROWSEBLACK, BRANCHSTORE_ERRORTDR)
values (51000018, 'L0510', 'MC0510000018', 18, 1, 14, 'PROTOCOLTYPE', 'perf_o_syslog_brd', 'PROTOCOLTYPE', 'int', '', 1, 0, '', '', '', '', '', '', '', 1, null, null, null);

insert into dic_vendor_field_def (ID, PERF_CLASS, FIELD_ID, SERIAL, FIELD_TYPE, FIELD_VENDOR_LABEL, FIELD_NAME, TABLE_NAME, TABLE_COLUMN, TABLE_COLUMN_TYPE, FIELD_FORMULA, IS_AVAILABLE, IS_INDEX, IND_TABLE_NAME, IND_TABLE_COLUMN, IND_TABLE_COLUMN_TYPE, SQLLDR_DATATYPE, GROUP_NAME, REMARK, PROJECTIONS, ISJUMP, FILESTORE_MMSBLACK, FILESTORE_BROWSEBLACK, BRANCHSTORE_ERRORTDR)
values (51000019, 'L0510', 'MC0510000019', 19, 1, 15, 'APN ', 'perf_o_syslog_brd', 'APN ', 'char', '', 1, 0, '', '', '', '', '', '', '', 1, null, null, null);