
--device_type_info
insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1426, 'RS-4POS192-24GE-28', 'ZTE', 'RS-4POS192-24GE端口-28', 28, '1398', 'image', 318, 10, 11, 8, 'red', 1, 'RS-4POS192-24GE_POS192.png', 'pos192_[X]/[Y]', to_date('16-08-2013 14:19:10', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:19:10', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1425, 'RS-4POS192-24GE-27', 'ZTE', 'RS-4POS192-24GE端口-27', 27, '1398', 'image', 301, 10, 11, 8, 'red', 1, 'RS-4POS192-24GE_POS192.png', 'pos192_[X]/[Y]', to_date('16-08-2013 14:19:10', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:19:10', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1424, 'RS-4POS192-24GE-26', 'ZTE', 'RS-4POS192-24GE端口-26', 26, '1398', 'image', 284, 10, 11, 8, 'red', 1, 'RS-4POS192-24GE_POS192.png', 'pos192_[X]/[Y]', to_date('16-08-2013 14:19:10', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:19:10', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1423, 'RS-4POS192-24GE-25', 'ZTE', 'RS-4POS192-24GE端口-25', 25, '1398', 'image', 269, 10, 11, 8, 'red', 1, 'RS-4POS192-24GE_POS192.png', 'pos192_[X]/[Y]', to_date('16-08-2013 14:19:10', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:19:10', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1422, 'RS-4POS192-24GE-24', 'ZTE', 'RS-4POS192-24GE端口-24', 24, '1398', 'image', 234, 6, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1421, 'RS-4POS192-24GE-23', 'ZTE', 'RS-4POS192-24GE端口-23', 23, '1398', 'image', 234, 19, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1420, 'RS-4POS192-24GE-22', 'ZTE', 'RS-4POS192-24GE端口-22', 22, '1398', 'image', 214, 6, 12, 8, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1419, 'RS-4POS192-24GE-21', 'ZTE', 'RS-4POS192-24GE端口-21', 21, '1398', 'image', 215, 18, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1418, 'RS-4POS192-24GE-20', 'ZTE', 'RS-4POS192-24GE端口-20', 20, '1398', 'image', 197, 6, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1417, 'RS-4POS192-24GE-19', 'ZTE', 'RS-4POS192-24GE端口-19', 19, '1398', 'image', 197, 18, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1416, 'RS-4POS192-24GE-18', 'ZTE', 'RS-4POS192-24GE端口-18', 18, '1398', 'image', 179, 6, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1415, 'RS-4POS192-24GE-17', 'ZTE', 'RS-4POS192-24GE端口-17', 17, '1398', 'image', 179, 18, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1414, 'RS-4POS192-24GE-16', 'ZTE', 'RS-4POS192-24GE端口-16', 16, '1398', 'image', 161, 6, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1413, 'RS-4POS192-24GE-15', 'ZTE', 'RS-4POS192-24GE端口-15', 15, '1398', 'image', 161, 18, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1412, 'RS-4POS192-24GE-14', 'ZTE', 'RS-4POS192-24GE端口-14', 14, '1398', 'image', 143, 6, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1411, 'RS-4POS192-24GE-13', 'ZTE', 'RS-4POS192-24GE端口-13', 13, '1398', 'image', 143, 18, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1410, 'RS-4POS192-24GE-12', 'ZTE', 'RS-4POS192-24GE端口-12', 12, '1398', 'image', 117, 6, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1409, 'RS-4POS192-24GE-11', 'ZTE', 'RS-4POS192-24GE端口-11', 11, '1398', 'image', 117, 18, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1408, 'RS-4POS192-24GE-10', 'ZTE', 'RS-4POS192-24GE端口-10', 10, '1398', 'image', 99, 6, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1407, 'RS-4POS192-24GE-9', 'ZTE', 'RS-4POS192-24GE端口-9', 9, '1398', 'image', 99, 18, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1406, 'RS-4POS192-24GE-8', 'ZTE', 'RS-4POS192-24GE端口-8', 8, '1398', 'image', 81, 6, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1405, 'RS-4POS192-24GE-7', 'ZTE', 'RS-4POS192-24GE端口-7', 7, '1398', 'image', 81, 18, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1404, 'RS-4POS192-24GE-6', 'ZTE', 'RS-4POS192-24GE端口-6', 6, '1398', 'image', 63, 6, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:12', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1403, 'RS-4POS192-24GE-5', 'ZTE', 'RS-4POS192-24GE端口-5', 5, '1398', 'image', 63, 18, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:11', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:11', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1402, 'RS-4POS192-24GE-4', 'ZTE', 'RS-4POS192-24GE端口-4', 4, '1398', 'image', 45, 6, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:11', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:11', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1401, 'RS-4POS192-24GE-3', 'ZTE', 'RS-4POS192-24GE端口-3', 3, '1398', 'image', 45, 18, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:11', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:11', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1400, 'RS-4POS192-24GE-2', 'ZTE', 'RS-4POS192-24GE端口-2', 2, '1398', 'image', 27, 6, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:11', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:11', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1399, 'RS-4POS192-24GE-1', 'ZTE', 'RS-4POS192-24GE端口-1', 1, '1398', 'image', 27, 18, 12, 9, 'red', 1, 'RS-4POS192-24GE_GEI.png', 'gei_[X]/[Y]', to_date('16-08-2013 14:18:11', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:18:11', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1398, 'RS-4POS192-24GE', 'ZTE', 'RS-4POS192-24GE板卡', 1, '0', 'image', 35, 35, 359, 40, 'red', 1, 'RS-4POS192-24GE.png', 'RS-4POS192-24GE', to_date('16-08-2013 14:17:04', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:17:04', 'dd-mm-yyyy hh24:mi:ss'), 4, '', '', '', '', '', 2, 0, 0, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1397, 'RS-4POS192-8GE-12', 'ZTE', 'RS-4POS192-8GE端口-12', 12, '1385', 'image', 317, 11, 11, 10, 'red', 1, 'RS-4POS192-8GE_POS192.png', 'pos192_[X]/[Y]', to_date('16-08-2013 14:02:25', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:02:25', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1396, 'RS-4POS192-8GE-11', 'ZTE', 'RS-4POS192-8GE端口-11', 11, '1385', 'image', 301, 11, 11, 10, 'red', 1, 'RS-4POS192-8GE_POS192.png', 'pos192_[X]/[Y]', to_date('16-08-2013 14:02:25', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:02:25', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1395, 'RS-4POS192-8GE-10', 'ZTE', 'RS-4POS192-8GE端口-10', 10, '1385', 'image', 285, 11, 11, 10, 'red', 1, 'RS-4POS192-8GE_POS192.png', 'pos192_[X]/[Y]', to_date('16-08-2013 14:02:25', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:02:25', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1394, 'RS-4POS192-8GE-9', 'ZTE', 'RS-4POS192-8GE端口-9', 9, '1385', 'image', 269, 11, 11, 10, 'red', 1, 'RS-4POS192-8GE_POS192.png', 'pos192_[X]/[Y]', to_date('16-08-2013 14:02:25', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 14:02:25', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1393, 'RS-4POS192-8GE-8', 'ZTE', 'RS-4POS192-8GE端口-8', 8, '1385', 'image', 184, 12, 11, 9, 'red', 1, 'RS-4POS192-8GE_GEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1392, 'RS-4POS192-8GE-7', 'ZTE', 'RS-4POS192-8GE端口-7', 7, '1385', 'image', 167, 12, 11, 9, 'red', 1, 'RS-4POS192-8GE_GEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1391, 'RS-4POS192-8GE-6', 'ZTE', 'RS-4POS192-8GE端口-6', 6, '1385', 'image', 151, 12, 11, 9, 'red', 1, 'RS-4POS192-8GE_GEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1390, 'RS-4POS192-8GE-5', 'ZTE', 'RS-4POS192-8GE端口-5', 5, '1385', 'image', 135, 12, 11, 9, 'red', 1, 'RS-4POS192-8GE_GEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1389, 'RS-4POS192-8GE-4', 'ZTE', 'RS-4POS192-8GE端口-4', 4, '1385', 'image', 119, 12, 11, 9, 'red', 1, 'RS-4POS192-8GE_GEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1388, 'RS-4POS192-8GE-3', 'ZTE', 'RS-4POS192-8GE端口-3', 3, '1385', 'image', 103, 12, 11, 9, 'red', 1, 'RS-4POS192-8GE_GEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1387, 'RS-4POS192-8GE-2', 'ZTE', 'RS-4POS192-8GE端口-2', 2, '1385', 'image', 86, 12, 11, 9, 'red', 1, 'RS-4POS192-8GE_GEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1386, 'RS-4POS192-8GE-1', 'ZTE', 'RS-4POS192-8GE端口-1', 1, '1385', 'image', 70, 12, 11, 9, 'red', 1, 'RS-4POS192-8GE_GEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:59:34', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1385, 'RS-4POS192-8GE', 'ZTE', 'RS-4POS192-8GE板卡', 1, '0', 'image', 35, 35, 359, 40, 'red', 1, 'RS-4POS192-8GE.png', 'RS-4POS192-8GE', to_date('16-08-2013 13:57:42', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:57:42', 'dd-mm-yyyy hh24:mi:ss'), 4, '', '', '', '', '', 2, 0, 0, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1384, 'RS-4XGP-10GE-8', 'ZTE', 'RS-4XGP-10GE端口-8', 8, '1376', 'image', null, null, null, null, 'red', 1, 'RS-4XGP-10GE_XGEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1383, 'RS-4XGP-10GE-7', 'ZTE', 'RS-4XGP-10GE端口-7', 7, '1376', 'image', null, null, null, null, 'red', 1, 'RS-4XGP-10GE_XGEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1382, 'RS-4XGP-10GE-6', 'ZTE', 'RS-4XGP-10GE端口-6', 6, '1376', 'image', null, null, null, null, 'red', 1, 'RS-4XGP-10GE_XGEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1381, 'RS-4XGP-10GE-5', 'ZTE', 'RS-4XGP-10GE端口-5', 5, '1376', 'image', null, null, null, null, 'red', 1, 'RS-4XGP-10GE_XGEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1380, 'RS-4XGP-10GE-4', 'ZTE', 'RS-4XGP-10GE端口-4', 4, '1376', 'image', 274, 11, 14, 11, 'red', 1, 'RS-4XGP-10GE_XGEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1379, 'RS-4XGP-10GE-3', 'ZTE', 'RS-4XGP-10GE端口-3', 3, '1376', 'image', 208, 11, 14, 11, 'red', 1, 'RS-4XGP-10GE_XGEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1378, 'RS-4XGP-10GE-2', 'ZTE', 'RS-4XGP-10GE端口-2', 2, '1376', 'image', 139, 11, 14, 11, 'red', 1, 'RS-4XGP-10GE_XGEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1377, 'RS-4XGP-10GE-1', 'ZTE', 'RS-4XGP-10GE端口-1', 1, '1376', 'image', 66, 11, 14, 11, 'red', 1, 'RS-4XGP-10GE_XGEI.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:46:47', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1376, 'RS-4XGP-10GE', 'ZTE', 'RS-4XGP-10GE板卡', 1, '0', 'image', 35, 35, 359, 40, 'red', 1, 'RS-4XGP-10GE.png', 'RS-4XGP-10GE', to_date('16-08-2013 13:44:40', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:44:40', 'dd-mm-yyyy hh24:mi:ss'), 4, '', '', '', '', '', 2, 0, 0, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1375, 'RS-XGTN4-4POS192-8XGE-12', 'ZTE', 'RS-XGTN4-4POS192-8XGE端口-12', 12, '1363', 'image', 319, 12, 14, 10, 'red', 1, 'RS-XGTN4-4POS192-8XGE_POS192.png', 'pos192_[X]/[Y]', to_date('16-08-2013 13:25:34', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:25:34', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1374, 'RS-XGTN4-4POS192-8XGE-11', 'ZTE', 'RS-XGTN4-4POS192-8XGE端口-11', 11, '1363', 'image', 294, 12, 14, 10, 'red', 1, 'RS-XGTN4-4POS192-8XGE_POS192.png', 'pos192_[X]/[Y]', to_date('16-08-2013 13:25:34', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:25:34', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1373, 'RS-XGTN4-4POS192-8XGE-10', 'ZTE', 'RS-XGTN4-4POS192-8XGE端口-10', 10, '1363', 'image', 99, 12, 14, 10, 'red', 1, 'RS-XGTN4-4POS192-8XGE_POS192.png', 'pos192_[X]/[Y]', to_date('16-08-2013 13:25:34', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:25:34', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1372, 'RS-XGTN4-4POS192-8XGE-9', 'ZTE', 'RS-XGTN4-4POS192-8XGE端口-9', 9, '1363', 'image', 74, 12, 14, 10, 'red', 1, 'RS-XGTN4-4POS192-8XGE_POS192.png', 'pos192_[X]/[Y]', to_date('16-08-2013 13:25:34', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:25:34', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1371, 'RS-XGTN4-4POS192-8XGE-8', 'ZTE', 'RS-XGTN4-4POS192-8XGE端口-8', 8, '1363', 'image', 270, 12, 14, 10, 'red', 1, 'RS-XGTN4-4POS192-8XGE_XGE.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1370, 'RS-XGTN4-4POS192-8XGE-7', 'ZTE', 'RS-XGTN4-4POS192-8XGE端口-7', 7, '1363', 'image', 246, 12, 14, 10, 'red', 1, 'RS-XGTN4-4POS192-8XGE_XGE.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1369, 'RS-XGTN4-4POS192-8XGE-6', 'ZTE', 'RS-XGTN4-4POS192-8XGE端口-6', 6, '1363', 'image', 50, 12, 14, 10, 'red', 1, 'RS-XGTN4-4POS192-8XGE_XGE.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1368, 'RS-XGTN4-4POS192-8XGE-5', 'ZTE', 'RS-XGTN4-4POS192-8XGE端口-5', 5, '1363', 'image', 25, 12, 14, 10, 'red', 1, 'RS-XGTN4-4POS192-8XGE_XGE.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1367, 'RS-XGTN4-4POS192-8XGE-4', 'ZTE', 'RS-XGTN4-4POS192-8XGE端口-4', 4, '1363', 'image', 192, 16, 10, 9, 'red', 1, 'RS-XGTN4-4POS192-8XGE_XGE.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1366, 'RS-XGTN4-4POS192-8XGE-3', 'ZTE', 'RS-XGTN4-4POS192-8XGE端口-3', 3, '1363', 'image', 179, 16, 10, 9, 'red', 1, 'RS-XGTN4-4POS192-8XGE_XGE.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1365, 'RS-XGTN4-4POS192-8XGE-2', 'ZTE', 'RS-XGTN4-4POS192-8XGE端口-2', 2, '1363', 'image', 166, 16, 10, 9, 'red', 1, 'RS-XGTN4-4POS192-8XGE_XGE.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1364, 'RS-XGTN4-4POS192-8XGE-1', 'ZTE', 'RS-XGTN4-4POS192-8XGE端口-1', 1, '1363', 'image', 153, 16, 10, 9, 'red', 1, 'RS-XGTN4-4POS192-8XGE_XGE.png', 'xgei_[X]/[Y]', to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:23:09', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1363, 'RS-XGTN4-4POS192-8XGE', 'ZTE', 'RS-XGTN4-4POS192-8XGE板卡', 1, '0', 'image', 35, 35, 359, 40, 'red', 1, 'RS-XGTN4-4POS192-8XGE.png', 'RS-XGTN4-4POS192-8XGE', to_date('16-08-2013 13:17:58', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 13:17:58', 'dd-mm-yyyy hh24:mi:ss'), 4, '', '', '', '', '', 2, 0, 0, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1362, 'LEOMX4UXC-3', 'HUAWEI', 'LEOMX4UXC端口-3', 3, '1358', 'image', 268, 21, 12, 8, 'red', 1, 'LEOMX4UXC_XGE.png', 'GigabitEthernet[X]/0/[Y]', to_date('16-08-2013 11:31:45', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 11:31:45', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1361, 'LEOMX4UXC-2', 'HUAWEI', 'LEOMX4UXC端口-2', 2, '1358', 'image', 208, 20, 12, 8, 'red', 1, 'LEOMX4UXC_XGE.png', 'GigabitEthernet[X]/0/[Y]', to_date('16-08-2013 11:31:45', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 11:31:45', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1360, 'LEOMX4UXC-1', 'HUAWEI', 'LEOMX4UXC端口-1', 1, '1358', 'image', 149, 20, 12, 8, 'red', 1, 'LEOMX4UXC_XGE.png', 'GigabitEthernet[X]/0/[Y]', to_date('16-08-2013 11:31:45', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 11:31:45', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1359, 'LEOMX4UXC-0', 'HUAWEI', 'LEOMX4UXC端口-0', 0, '1358', 'image', 90, 21, 12, 8, 'red', 1, 'LEOMX4UXC_XGE.png', 'GigabitEthernet[X]/0/[Y]', to_date('16-08-2013 11:31:45', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 11:31:45', 'dd-mm-yyyy hh24:mi:ss'), 4, 'DI_SWITCHPORT', 'ifDescr', '', '', '', 3, 1, 1, 1, 0, 0);

insert into device_type_info (ID, DEVICE_TYPE_CODE, DEVICE_RAND_CODE, DEVICE_DESC, SHOW_INDEX, PID, FIGURE_TYPE, FIGURE_X, FIGURE_Y, FIGURE_WIDTH, FIGURE_HEIGHT, FIGURE_STROKE, FIGURE_STROKE_WIDTH, FIGURE_FILL, NAME_FORMAT, ADD_TIME, ADD_USERID, LAST_UPDATE_TIME, LAST_UPDATE_USERID, DI_TABLE_NAME, INDEX_FILED, STATUS_FILED, STATUS_SYMBOLS, STATUS_VALUE, SHOW_LEVEL, IS_LINK, IS_LEAF, MAX_DEVICE_NUM, IS_POSITIONDEV, HAS_INSTANCE)
values (1358, 'LEOMX4UXC', 'HUAWEI', 'LEOMX4UXC板卡（4口）', 1, '0', 'image', 35, 35, 373, 41, 'red', 1, 'LEOMX4UXC.png', 'LEOMX4UXC', to_date('16-08-2013 11:28:24', 'dd-mm-yyyy hh24:mi:ss'), 4, to_date('16-08-2013 11:28:24', 'dd-mm-yyyy hh24:mi:ss'), 4, '', '', '', '', '', 2, 0, 0, 1, 0, 0);

commit;


--设备中间表数据更新
insert into device_brand_type (ID, DEVICE_BRAND_CODE, PAR_DEVICE_TYPE_CODE, SUB_DEVICE_TYPE_CODE)
values (405, 'ZTE', 'ZXR10-T240G', 'RS-4POS192-24GE');

insert into device_brand_type (ID, DEVICE_BRAND_CODE, PAR_DEVICE_TYPE_CODE, SUB_DEVICE_TYPE_CODE)
values (404, 'ZTE', 'ZXR10-T240G', 'RS-4POS192-8GE');

insert into device_brand_type (ID, DEVICE_BRAND_CODE, PAR_DEVICE_TYPE_CODE, SUB_DEVICE_TYPE_CODE)
values (403, 'ZTE', 'ZXR10-T240G', 'RS-4XGP-10GE');

insert into device_brand_type (ID, DEVICE_BRAND_CODE, PAR_DEVICE_TYPE_CODE, SUB_DEVICE_TYPE_CODE)
values (402, 'ZTE', 'ZXR10-T240G', 'RS-XGTN4-4POS192-8XGE');

insert into device_brand_type (ID, DEVICE_BRAND_CODE, PAR_DEVICE_TYPE_CODE, SUB_DEVICE_TYPE_CODE)
values (401, 'HUAWEI', 'HUAWEI-9312', 'LEOMX4UXC');

commit;

--新增板卡：为槽位添加可配板卡 华为9312：
--LEOMX4UXC
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'HUAWEI','HUAWEI-9312-12','LEOMX4UXC','HUAWEI-9312');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'HUAWEI','HUAWEI-9312-11','LEOMX4UXC','HUAWEI-9312');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'HUAWEI','HUAWEI-9312-10','LEOMX4UXC','HUAWEI-9312');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'HUAWEI','HUAWEI-9312-9','LEOMX4UXC','HUAWEI-9312');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'HUAWEI','HUAWEI-9312-8','LEOMX4UXC','HUAWEI-9312');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'HUAWEI','HUAWEI-9312-7','LEOMX4UXC','HUAWEI-9312');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'HUAWEI','HUAWEI-9312-6','LEOMX4UXC','HUAWEI-9312');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'HUAWEI','HUAWEI-9312-5','LEOMX4UXC','HUAWEI-9312');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'HUAWEI','HUAWEI-9312-4','LEOMX4UXC','HUAWEI-9312');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'HUAWEI','HUAWEI-9312-3','LEOMX4UXC','HUAWEI-9312');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'HUAWEI','HUAWEI-9312-2','LEOMX4UXC','HUAWEI-9312');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'HUAWEI','HUAWEI-9312-1','LEOMX4UXC','HUAWEI-9312');

commit;

--RS-XGTN4-4POS192-8XGE
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-12','RS-XGTN4-4POS192-8XGE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-11','RS-XGTN4-4POS192-8XGE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-10','RS-XGTN4-4POS192-8XGE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-9','RS-XGTN4-4POS192-8XGE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-8','RS-XGTN4-4POS192-8XGE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-7','RS-XGTN4-4POS192-8XGE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-6','RS-XGTN4-4POS192-8XGE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-5','RS-XGTN4-4POS192-8XGE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-4','RS-XGTN4-4POS192-8XGE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-3','RS-XGTN4-4POS192-8XGE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-2','RS-XGTN4-4POS192-8XGE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-1','RS-XGTN4-4POS192-8XGE','ZXR10-T240G');

commit;

--RS-4XGP-10GE 
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-12','RS-4XGP-10GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-11','RS-4XGP-10GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-10','RS-4XGP-10GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-9','RS-4XGP-10GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-8','RS-4XGP-10GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-7','RS-4XGP-10GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-6','RS-4XGP-10GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-5','RS-4XGP-10GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-4','RS-4XGP-10GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-3','RS-4XGP-10GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-2','RS-4XGP-10GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-1','RS-4XGP-10GE','ZXR10-T240G');

commit;

--RS-4POS192-8GE
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-12','RS-4POS192-8GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-11','RS-4POS192-8GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-10','RS-4POS192-8GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-9','RS-4POS192-8GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-8','RS-4POS192-8GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-7','RS-4POS192-8GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-6','RS-4POS192-8GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-5','RS-4POS192-8GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-4','RS-4POS192-8GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-3','RS-4POS192-8GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-2','RS-4POS192-8GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-1','RS-4POS192-8GE','ZXR10-T240G');

commit;

--RS-4POS192-24GE
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-12','RS-4POS192-24GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-11','RS-4POS192-24GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-10','RS-4POS192-24GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-9','RS-4POS192-24GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-8','RS-4POS192-24GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-7','RS-4POS192-24GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-6','RS-4POS192-24GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-5','RS-4POS192-24GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-4','RS-4POS192-24GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-3','RS-4POS192-24GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-2','RS-4POS192-24GE','ZXR10-T240G');
insert into device_boardsolt_board(id,device_brand_code,device_board_solt_code,device_board_code,device_type_code) 
values(seq_device_boardsolt_board.nextval,'ZTE','ZXR10-T240G-1','RS-4POS192-24GE','ZXR10-T240G');

commit;