--创建表DEVICE_BRAND_TYPE
create table DEVICE_BRAND_TYPE
(
  ID                   NUMBER not null,
  DEVICE_BRAND_CODE    VARCHAR2(64),
  PAR_DEVICE_TYPE_CODE VARCHAR2(64),
  SUB_DEVICE_TYPE_CODE VARCHAR2(64)
);
comment on table DEVICE_BRAND_TYPE
  is '设备品牌型号对应子设备表';
comment on column DEVICE_BRAND_TYPE.DEVICE_BRAND_CODE
  is '设备品牌代码';
comment on column DEVICE_BRAND_TYPE.PAR_DEVICE_TYPE_CODE
  is '设备型号代码';
comment on column DEVICE_BRAND_TYPE.SUB_DEVICE_TYPE_CODE
  is '设备型号的子设备型号代码';
alter table DEVICE_BRAND_TYPE
  add constraint PK_DEVICE_BRAND_TYPE primary key (ID);
commit;

insert into DEVICE_BRAND_TYPE (ID, DEVICE_BRAND_CODE, PAR_DEVICE_TYPE_CODE, SUB_DEVICE_TYPE_CODE)
values (1, 'DPtech', 'DPX8000-A12', 'MPUA');
insert into DEVICE_BRAND_TYPE (ID, DEVICE_BRAND_CODE, PAR_DEVICE_TYPE_CODE, SUB_DEVICE_TYPE_CODE)
values (2, 'DPtech', 'DPX8000-A12', 'PF4XPS8XGES-E');
insert into DEVICE_BRAND_TYPE (ID, DEVICE_BRAND_CODE, PAR_DEVICE_TYPE_CODE, SUB_DEVICE_TYPE_CODE)
values (3, 'DPtech', 'DPX8000-A12', '8XGEP-D');
insert into DEVICE_BRAND_TYPE (ID, DEVICE_BRAND_CODE, PAR_DEVICE_TYPE_CODE, SUB_DEVICE_TYPE_CODE)
values (4, 'DPtech', 'MPUA2', 'MPUA_SUB');
insert into DEVICE_BRAND_TYPE (ID, DEVICE_BRAND_CODE, PAR_DEVICE_TYPE_CODE, SUB_DEVICE_TYPE_CODE)
values (5, 'DPtech', 'MPUA', 'MPUA_SUB_2');
insert into DEVICE_BRAND_TYPE (ID, DEVICE_BRAND_CODE, PAR_DEVICE_TYPE_CODE, SUB_DEVICE_TYPE_CODE)
values (6, 'DPtech', 'PF4XPS8XGES-E', 'PF4XPS8XGES-E_SUB');
insert into DEVICE_BRAND_TYPE (ID, DEVICE_BRAND_CODE, PAR_DEVICE_TYPE_CODE, SUB_DEVICE_TYPE_CODE)
values (7, 'DPtech', 'DPX8000-A12', '8XGEP-D-BLANK');
commit;

--清空device_type_info表的数据
truncate table DEVICE_TYPE_INFO;
commit;

--DEVICE_TYPE_INFO表增加SHOW_LEVEL、IS_LINK、IS_LEAF字段
alter table DEVICE_TYPE_INFO add SHOW_LEVEL number;
alter table DEVICE_TYPE_INFO add IS_LINK number;
alter table DEVICE_TYPE_INFO add IS_LEAF number;

--向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)
values (24, 'PF4XPS8XGES-E-Six', 'DPtech', 'PF4XPS8XGES-E端口6', 6, '4', 'image', 291, 5, 14, 7, 'red', 1, 'PF4XPS8XGES-E-Eth.png', 'eth[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (43, 'S5048E-12', 'H3C', 'H3C S5048E交换机端口12', 12, '6', 'image', 94, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (60, 'S5048E-29', 'H3C', 'H3C S5048E交换机端口29', 29, '6', 'image', 246, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (82, 'DPX8000-A12-Fan', 'DPtech', 'DPX8000-A12风扇指示灯（暂时没用）', 1, '0', 'image', 200, 300, 10, 10, 'red', 1, 'DPX8000-A12-Fan.png', 'DPX8000-A12-Fan', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 0, 1);
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)
values (19, 'PF4XPS8XGES-E-One', 'DPtech', 'PF4XPS8XGES-E端口1', 1, '4', 'image', 97, 18, 18, 8, 'red', 1, 'PF4XPS8XGES-E-POS.png', 'pos[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (20, 'PF4XPS8XGES-E-Two', 'DPtech', 'PF4XPS8XGES-E端口2', 2, '4', 'image', 153, 18, 18, 8, 'red', 1, 'PF4XPS8XGES-E-POS.png', 'pos[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (21, 'PF4XPS8XGES-E-Three', 'DPtech', 'PF4XPS8XGES-E端口3', 3, '4', 'image', 210, 18, 18, 8, 'red', 1, 'PF4XPS8XGES-E-POS.png', 'pos[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (22, 'PF4XPS8XGES-E-Four', 'DPtech', 'PF4XPS8XGES-E端口4', 4, '4', 'image', 278, 5, 14, 7, 'red', 1, 'PF4XPS8XGES-E-Eth.png', 'eth[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (23, 'PF4XPS8XGES-E-Five', 'DPtech', 'PF4XPS8XGES-E端口5', 5, '4', 'image', 278, 19, 14, 7, 'red', 1, 'PF4XPS8XGES-E-Eth.png', 'eth[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (25, 'PF4XPS8XGES-E-Seven', 'DPtech', 'PF4XPS8XGES-E端口7', 7, '4', 'image', 291, 19, 14, 7, 'red', 1, 'PF4XPS8XGES-E-Eth.png', 'eth[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (26, 'PF4XPS8XGES-E-Eight', 'DPtech', 'PF4XPS8XGES-E端口8', 8, '4', 'image', 304, 5, 14, 7, 'red', 1, 'PF4XPS8XGES-E-Eth.png', 'eth[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (27, 'PF4XPS8XGES-E-Nine', 'DPtech', 'PF4XPS8XGES-E端口9', 9, '4', 'image', 304, 19, 14, 7, 'red', 1, 'PF4XPS8XGES-E-Eth.png', 'eth[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (28, 'PF4XPS8XGES-E-Ten', 'DPtech', 'PF4XPS8XGES-E端口10', 10, '4', 'image', 317, 5, 14, 7, 'red', 1, 'PF4XPS8XGES-E-Eth.png', 'eth[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (29, 'PF4XPS8XGES-E-Eleven', 'DPtech', 'PF4XPS8XGES-E端口11', 11, '4', 'image', 317, 19, 14, 7, 'red', 1, 'PF4XPS8XGES-E-Eth.png', 'eth[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (30, 'PF4XPS8XGES-E-Zero', 'DPtech', 'PF4XPS8XGES-E端口0', 0, '4', 'image', 41, 18, 18, 8, 'red', 1, 'PF4XPS8XGES-E-POS.png', 'pos[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (31, 'MPUA-Port1', 'DPtech', 'MPUA主控板默认端口1', 1, '2', 'image', 104, 21, 11, 8, 'red', 1, 'MPUA-Port1.png', 'meth0_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (32, 'S5048E-1', 'H3C', 'H3C S5048E交换机端口1', 1, '6', 'image', 14, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (33, 'S5048E-2', 'H3C', 'H3C S5048E交换机端口2', 2, '6', 'image', 14, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (34, 'S5048E-3', 'H3C', 'H3C S5048E交换机端口3', 3, '6', 'image', 30, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (35, 'S5048E-4', 'H3C', 'H3C S5048E交换机端口4', 4, '6', 'image', 30, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (36, 'S5048E-5', 'H3C', 'H3C S5048E交换机端口5', 5, '6', 'image', 46, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (37, 'S5048E-6', 'H3C', 'H3C S5048E交换机端口6', 6, '6', 'image', 46, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (38, 'S5048E-7', 'H3C', 'H3C S5048E交换机端口7', 7, '6', 'image', 62, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (39, 'S5048E-8', 'H3C', 'H3C S5048E交换机端口8', 8, '6', 'image', 62, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (40, 'S5048E-9', 'H3C', 'H3C S5048E交换机端口9', 9, '6', 'image', 78, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (41, 'S5048E-10', 'H3C', 'H3C S5048E交换机端口10', 10, '6', 'image', 78, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (42, 'S5048E-11', 'H3C', 'H3C S5048E交换机端口11', 11, '6', 'image', 94, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (44, 'S5048E-13', 'H3C', 'H3C S5048E交换机端口13', 13, '6', 'image', 110, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (45, 'S5048E-14', 'H3C', 'H3C S5048E交换机端口14', 14, '6', 'image', 110, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (46, 'S5048E-15', 'H3C', 'H3C S5048E交换机端口15', 15, '6', 'image', 126, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (47, 'S5048E-16', 'H3C', 'H3C S5048E交换机端口16', 16, '6', 'image', 126, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (48, 'S5048E-17', 'H3C', 'H3C S5048E交换机端口17', 17, '6', 'image', 150, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (49, 'S5048E-18', 'H3C', 'H3C S5048E交换机端口18', 18, '6', 'image', 150, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (50, 'S5048E-19', 'H3C', 'H3C S5048E交换机端口19', 19, '6', 'image', 166, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (51, 'S5048E-20', 'H3C', 'H3C S5048E交换机端口20', 20, '6', 'image', 166, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (52, 'S5048E-21', 'H3C', 'H3C S5048E交换机端口21', 21, '6', 'image', 182, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (53, 'S5048E-22', 'H3C', 'H3C S5048E交换机端口22', 22, '6', 'image', 182, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (54, 'S5048E-23', 'H3C', 'H3C S5048E交换机端口23', 23, '6', 'image', 198, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (55, 'S5048E-24', 'H3C', 'H3C S5048E交换机端口24', 24, '6', 'image', 198, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (56, 'S5048E-25', 'H3C', 'H3C S5048E交换机端口25', 25, '6', 'image', 214, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (57, 'S5048E-26', 'H3C', 'H3C S5048E交换机端口26', 26, '6', 'image', 214, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (58, 'S5048E-27', 'H3C', 'H3C S5048E交换机端口27', 27, '6', 'image', 230, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (59, 'S5048E-28', 'H3C', 'H3C S5048E交换机端口28', 28, '6', 'image', 230, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (61, 'S5048E-30', 'H3C', 'H3C S5048E交换机端口30', 30, '6', 'image', 246, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (62, 'S5048E-31', 'H3C', 'H3C S5048E交换机端口31', 31, '6', 'image', 262, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (63, 'S5048E-32', 'H3C', 'H3C S5048E交换机端口32', 32, '6', 'image', 262, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (64, 'S5048E-33', 'H3C', 'H3C S5048E交换机端口33', 33, '6', 'image', 286, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (65, 'S5048E-34', 'H3C', 'H3C S5048E交换机端口34', 34, '6', 'image', 286, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (87, 'MPUA_SUB', 'DPtech', '虚拟的第三级设备（测试用）', 1, '0', 'image', 400, 400, 170, 15, 'red', 1, 'MPUA_SUB.png', 'meth0_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 3, 0, 1);
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)
values (96, '8XGEP-D-BLANK', 'DPtech', '8XGEP-D空白版', 1, '0', 'image', 30, 30, 370, 35, 'red', 1, '8XGEP-D-BLANK.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 0, 1);
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)
values (88, '8XGEP-D-Zero', 'DPtech', '8XGEP-D端口0', 0, '5', 'image', 22, 19, 18, 8, 'red', 1, '8XGEP-D.png', 'pos[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (89, '8XGEP-D-One', 'DPtech', '8XGEP-D端口1', 1, '5', 'image', 66, 19, 18, 8, 'red', 1, '8XGEP-D.png', 'pos[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (90, '8XGEP-D-Two', 'DPtech', '8XGEP-D端口2', 2, '5', 'image', 109, 19, 18, 8, 'red', 1, '8XGEP-D.png', 'pos[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (91, '8XGEP-D-Three', 'DPtech', '8XGEP-D端口3', 3, '5', 'image', 154, 19, 18, 8, 'red', 1, '8XGEP-D.png', 'pos[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (92, '8XGEP-D-Four', 'DPtech', '8XGEP-D端口4', 4, '5', 'image', 199, 19, 18, 8, 'red', 1, '8XGEP-D.png', 'eth[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (93, '8XGEP-D-Five', 'DPtech', '8XGEP-D端口5', 5, '5', 'image', 243, 19, 18, 8, 'red', 1, '8XGEP-D.png', 'eth[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (94, '8XGEP-D-Six', 'DPtech', '8XGEP-D端口6', 6, '5', 'image', 281, 19, 18, 8, 'red', 1, '8XGEP-D.png', 'eth[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (95, '8XGEP-D-Seven', 'DPtech', '8XGEP-D端口7', 7, '5', 'image', 324, 19, 18, 8, 'red', 1, '8XGEP-D.png', 'eth[X]_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (66, 'S5048E-35', 'H3C', 'H3C S5048E交换机端口35', 35, '6', 'image', 302, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (67, 'S5048E-36', 'H3C', 'H3C S5048E交换机端口36', 36, '6', 'image', 302, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (68, 'S5048E-37', 'H3C', 'H3C S5048E交换机端口37', 37, '6', 'image', 318, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (69, 'S5048E-38', 'H3C', 'H3C S5048E交换机端口38', 38, '6', 'image', 318, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (70, 'S5048E-39', 'H3C', 'H3C S5048E交换机端口39', 39, '6', 'image', 334, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (71, 'S5048E-40', 'H3C', 'H3C S5048E交换机端口40', 40, '6', 'image', 334, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (72, 'S5048E-41', 'H3C', 'H3C S5048E交换机端口41', 41, '6', 'image', 350, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (73, 'S5048E-42', 'H3C', 'H3C S5048E交换机端口42', 42, '6', 'image', 350, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (74, 'S5048E-43', 'H3C', 'H3C S5048E交换机端口43', 43, '6', 'image', 366, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (7, 'DPX8000-A12-Two', 'DPtech', 'DPX8000-A12默认槽位2', 2, '1', 'image', 16, 64, 370, 35, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (8, 'DPX8000-A12-Three', 'DPtech', 'DPX8000-A12默认槽位3', 3, '1', 'image', 16, 98, 370, 35, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (9, 'DPX8000-A12-Four', 'DPtech', 'DPX8000-A12默认槽位4', 4, '1', 'image', 16, 132, 370, 35, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (10, 'DPX8000-A12-Five', 'DPtech', 'DPX8000-A12默认槽位5', 5, '1', 'image', 16, 166, 370, 35, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (11, 'DPX8000-A12-Six', 'DPtech', 'DPX8000-A12默认槽位6', 6, '1', 'image', 16, 201, 370, 35, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (12, 'DPX8000-A12-Seven', 'DPtech', 'DPX8000-A12默认槽位7', 7, '1', 'image', 16, 233, 370, 35, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (13, 'DPX8000-A12-Eight', 'DPtech', 'DPX8000-A12默认槽位8', 8, '1', 'image', 16, 269, 370, 35, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (14, 'DPX8000-A12-Nine', 'DPtech', 'DPX8000-A12默认槽位9', 9, '1', 'image', 16, 303, 370, 35, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (15, 'DPX8000-A12-Ten', 'DPtech', 'DPX8000-A12默认槽位10', 10, '1', 'image', 16, 337, 370, 35, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (16, 'DPX8000-A12-Eleven', 'DPtech', 'DPX8000-A12默认槽位11', 11, '1', 'image', 16, 371, 370, 35, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (17, 'DPX8000-A12-Twelve', 'DPtech', 'DPX8000-A12默认槽位12', 12, '1', 'image', 16, 405, 370, 35, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (18, 'MPUA-Port0', 'DPtech', 'MPUA主控板默认端口0', 0, '2', 'image', 104, 8, 11, 8, 'red', 1, 'MPUA-Port0.png', 'meth0_[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 3, 1, 1);
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)
values (75, 'S5048E-44', 'H3C', 'H3C S5048E交换机端口44', 44, '6', 'image', 366, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (76, 'S5048E-45', 'H3C', 'H3C S5048E交换机端口45', 45, '6', 'image', 382, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (77, 'S5048E-46', 'H3C', 'H3C S5048E交换机端口46', 46, '6', 'image', 382, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (78, 'S5048E-47', 'H3C', 'H3C S5048E交换机端口47', 47, '6', 'image', 398, 35, 14, 14, 'red', 1, 'S5048E1.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (79, 'S5048E-48', 'H3C', 'H3C S5048E交换机端口48', 48, '6', 'image', 398, 14, 14, 14, 'red', 1, 'S5048E2.png', 'GigabitEthernet0/[Y]', to_date('01-03-2013', 'dd-mm-yyyy'), 4, to_date('01-03-2013', 'dd-mm-yyyy'), 4, 'DI_SWITCHPORT', 'IFDESCR', null, null, null, 2, 1, 1);
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)
values (1, 'DPX8000-A12', 'DPtech', 'DPtech DPX8000-A12 分流设备', 1, '0', 'image', 35, 0, 432, 540, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_SYSTEM', null, null, null, null, 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)
values (2, 'MPUA', 'DPtech', 'MPUA主控板在DPX8000系列产品中起主导作用，实现系统的初始化配置、管理以及控制报文的处理等。', 1, '0', 'image', 10, 10, 370, 35, 'red', 1, 'MPUA.png', 'MPUA', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (3, 'DPX8000-A12-One', 'DPtech', 'DPX8000-A12默认槽位1', 1, '1', 'image', 16, 30, 370, 35, 'red', 1, 'DPX8000-A12.png', 'DPX8000-A12', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (4, 'PF4XPS8XGES-E', 'DPtech', '分流业务板（PF4XPS8XGES-E），插在业务槽位，提供4个XFP 10GE  POS光接口，8个万兆以太网光接口(SFP+)。', 1, '0', 'image', 10, 10, 370, 35, 'red', 1, 'PF4XPS8XGES-E.png', 'PF4XPS8XGES-E', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (5, '8XGEP-D', 'DPtech', '接口板（8XGEP-D）插在业务槽位，提供8个XFP 10GE以太网光接口。', 1, '0', 'image', 20, 50, 370, 35, 'red', 1, '8XGEP-D.png', '8XGEP-D', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 2, 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)
values (6, 'S5048E', 'H3C', 'H3C S5048E交换机', 1, '0', 'image', 0, 25, 500, 60, 'red', 1, 'S5048E.png', 'S5048E', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, null, null, null, null, null, 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)
values (80, 'DPX8000-A12-Fan0', 'DPtech', 'DPX8000-A12风扇指示灯0', 0, '1', 'image', 387, 198, 16, 16, 'red', 1, 'DPX8000-A12-Fan.png', '[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_DPSYSTEMFANENTRY', 'DPSYSTEMFANNO', 'DPSYSTEMFANSTAT', '=', 'abnormal', 2, 0, 1);
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)
values (81, 'DPX8000-A12-Fan1', 'DPtech', 'DPX8000-A12风扇指示灯1', 1, '1', 'image', 387, 399, 16, 16, 'red', 1, 'DPX8000-A12-Fan.png', '[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_DPSYSTEMFANENTRY', 'DPSYSTEMFANNO', 'DPSYSTEMFANSTAT', '=', 'abnormal', 2, 0, 1);
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)
values (83, 'DPX8000-A12-Power0', 'DPtech', 'DPX8000-A12电源指示灯0', 0, '1', 'image', 69, 463, 16, 16, 'red', 1, 'DPX8000-A12-Power.png', '[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_DPSYSTEMPOWERENTRY', 'DPSYSTEMPOWERNO', 'DPSYSTEMPOWERSTAT', '=', 'abnormal', 2, 0, 1);
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)
values (84, 'DPX8000-A12-Power1', 'DPtech', 'DPX8000-A12电源指示灯1', 1, '1', 'image', 69, 504, 16, 16, 'red', 1, 'DPX8000-A12-Power.png', '[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_DPSYSTEMPOWERENTRY', 'DPSYSTEMPOWERNO', 'DPSYSTEMPOWERSTAT', '=', 'abnormal', 2, 0, 1);
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)
values (85, 'DPX8000-A12-Power2', 'DPtech', 'DPX8000-A12电源指示灯2', 2, '1', 'image', 289, 463, 16, 16, 'red', 1, 'DPX8000-A12-Power.png', '[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_DPSYSTEMPOWERENTRY', 'DPSYSTEMPOWERNO', 'DPSYSTEMPOWERSTAT', '=', 'abnormal', 2, 0, 1);
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)
values (86, 'DPX8000-A12-Power3', 'DPtech', 'DPX8000-A12电源指示灯3', 3, '1', 'image', 289, 504, 16, 16, 'red', 1, 'DPX8000-A12-Power.png', '[Y]', to_date('25-02-2013', 'dd-mm-yyyy'), 4, to_date('25-02-2013', 'dd-mm-yyyy'), 4, 'DI_DPSYSTEMPOWERENTRY', 'DPSYSTEMPOWERNO', 'DPSYSTEMPOWERSTAT', '=', 'abnormal', 2, 0, 1);
commit;


--添加网元图形化配置菜单（使用管理员角色登录）：
--1.系统配置->模块管理->节点管理->新增子模块：
--    模块名称：网元图形化配置
--    路径或js函数：/detection/switchDetection.do?action=toConfigSpecialDevice
--    显示类型：菜单
--    状态：有效
--    提交
--2.权限管理->角色管理：修改相应角色，为角色添加网元图形化配置菜单



