size of instance column in dct_threshold_instances table reduced because of MySQL...
authorVictor Kirhenshtein <victor@netxms.org>
Wed, 10 May 2017 16:34:16 +0000 (19:34 +0300)
committerVictor Kirhenshtein <victor@netxms.org>
Wed, 10 May 2017 16:34:16 +0000 (19:34 +0300)
sql/schema.in
src/server/tools/nxdbmgr/upgrade.cpp

index 07220f8..fefc6ae 100644 (file)
@@ -722,7 +722,7 @@ CREATE TABLE dct_threshold_conditions
 CREATE TABLE dct_threshold_instances
 (
   threshold_id integer not null,
-  instance varchar(1024) not null,
+  instance varchar(255) not null,
   match_count integer not null,
   is_active char(1) not null,
   PRIMARY KEY(threshold_id,instance)
index 0a3d04f..33fad85 100644 (file)
@@ -777,7 +777,7 @@ static BOOL H_UpgradeFromV449(int currVersion, int newVersion)
    CHK_EXEC(CreateTable(
       _T("CREATE TABLE dct_threshold_instances (")
       _T("  threshold_id integer not null,")
-      _T("  instance varchar(1024) not null,")
+      _T("  instance varchar(255) not null,")
       _T("  match_count integer not null,")
       _T("  is_active char(1) not null,")
       _T("PRIMARY KEY(threshold_id,instance))")));