DO $script$
DECLARE
type_id BIGINT;
port_id BIGINT;
slot_id BIGINT;
port_node_property_id_for_name BIGINT;
slot_node_property_id_for_name BIGINT;
BEGIN
port_node_property_id_for_name := (SELECT np.id FROM node_properties np WHERE node_type_id = 26000000000006 AND name = '名称');
slot_node_property_id_for_name := (SELECT np.id FROM node_properties np WHERE node_type_id = 26000000000009 AND name = '名称');
INSERT INTO node_types (name, image, image2, background, default_width, default_height, type_group, is_favourite, is_enabled, hierarchy_browser_label, is_system, width, height, vendor_id, description, keep_aspect_ratio, show_container_children, double_click_behavior, snmp_oid, independent_mounting, deep)
VALUES ('Huawei CloudEngine 6881 48S6CQ','ixnhouml.png', '5oj0ihkx.png', 'rdim16en.svg', 482.6000061035156, 44.45000076293945, 7, true,true, 28000000157120, false, 482.6, 44.45, null, null, false, false, '0', null, false, 0.0);
type_id := currval('node_types_id_seq'::regclass);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_unique_for_all_types, justification, snmp_oid)
VALUES (type_id, 'IP', null, 12, true, false, 10.0, 0, true, false, 0.0, -15.0, 0, 0, 0, null, null, null, null, true, null, 0, false, false, null, null, 0, null);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_unique_for_all_types, justification, snmp_oid)
VALUES (type_id, '登陆方式', null, 9, true, false, 10.0, 0, true, false, 0.0, -15.0, 0, 0, 0, null, null, null, null, true, null, 0, false, false, null, null, 0, null);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_unique_for_all_types, justification, snmp_oid)
VALUES (type_id, '读团体字', null, 5, true, false, 10.0, 0, true, false, 0.0, -15.0, 0, 0, 0, null, null, null, null, true, null, 0, false, false, null, null, 0, null);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_unique_for_all_types, justification, snmp_oid)
VALUES (type_id, '二级密码', null, 10, true, false, 10.0, 0, true, false, 0.0, -15.0, 0, 0, 0, null, null, null, null, true, null, 0, false, false, null, null, 0, null);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_unique_for_all_types, justification, snmp_oid)
VALUES (type_id, '峰值功率KW', '258', 0, true, false, 10.0, 0, true, false, 0.0, -15.0, 0, 0, 0, false, false, false, null, true, null, 0, false, false, false, false, 0, null);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_unique_for_all_types, justification, snmp_oid)
VALUES (type_id, '河北港口项目--业务', null, 13, true, null, 10.0, 0, false, false, 0.0, -15.0, 0, 0, 0, null, null, null, null, true, null, 0, false, false, null, null, 0, null);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_unique_for_all_types, justification, snmp_oid)
VALUES (type_id, '监测状态', null, 2, false, false, 10.0, 0, true, false, 0.0, -15.0, 0, 0, 0, null, null, null, null, true, null, 0, null, false, null, null, 0, null);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_unique_for_all_types, justification, snmp_oid)
VALUES (type_id, '密码', null, 8, true, false, 10.0, 0, true, false, 0.0, -15.0, 0, 0, 0, null, null, null, null, true, null, 0, false, false, null, null, 0, null);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_unique_for_all_types, justification, snmp_oid)
VALUES (type_id, '名称', null, -1, true, true, 10.0, 0, true, false, 0.0, -15.0, 0, 0, 0, false, false, false, '', true, '', 0, false, false, false, false, 0, null);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_unique_for_all_types, justification, snmp_oid)
VALUES (type_id, '设备厂商', null, 11, true, false, 10.0, 0, true, false, 0.0, -15.0, 0, 0, 0, null, null, null, null, true, null, 0, false, false, null, null, 0, null);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_unique_for_all_types, justification, snmp_oid)
VALUES (type_id, '生命周期', null, 4, true, null, 10.0, 0, false, false, 0.0, -15.0, 0, 0, 0, null, null, null, null, true, null, 0, false, false, null, null, 0, null);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_unique_for_all_types, justification, snmp_oid)
VALUES (type_id, '写团体字', null, 6, true, false, 10.0, 0, true, false, 0.0, -15.0, 0, 0, 0, null, null, null, null, true, null, 0, false, false, null, null, 0, null);
INSERT INTO node_properties (node_type_id, name, default_value, position, mandatory, displayed, font_size, font_color, is_system, not_editable, offset_x, offset_y, angle, anchor_point_x, anchor_point_y, bold, italic, underline, font_family, is_in_properties, fill_color, align, lock_list, is_type_field, is_unique_for_this_type, is_uni
nVisual模型库:Huawei CloudEngine 6881 48S6CQ
需积分: 5 126 浏览量
2023-02-21
17:28:47
上传
评论
收藏 591KB ZIP 举报
耐威迪NWVDI
- 粉丝: 0
- 资源: 5