summaryrefslogtreecommitdiff
path: root/sql/hc/updateMetadata.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/hc/updateMetadata.sql')
-rw-r--r--sql/hc/updateMetadata.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/hc/updateMetadata.sql b/sql/hc/updateMetadata.sql
new file mode 100644
index 0000000..3ec6e9c
--- /dev/null
+++ b/sql/hc/updateMetadata.sql
@@ -0,0 +1,3 @@
+update metadata set SORT_SIGN=1 where TABLE_NAME='DI_SWITCHPORT' and FILED_NAME='ifIndex' and check_type_id = 10;
+update metadata set SORT_SIGN=0 where TABLE_NAME='DI_SWITCHPORT' and FILED_NAME='ifDescr' and check_type_id = 10;
+commit;