fix in DB upgrade procedure and schema init script

diff --git a/sql/schema.in b/sql/schema.in
index 8bfba28..e37a3dc 100644 (file)
--- a/sql/schema.in
+++ b/sql/schema.in
@@ -1765,8 +1765,8 @@ CREATE TABLE graphs
   owner_id integer not null,
   flags integer not null,
   name varchar(255) not null,
-  config SQL_TEXT not null,
-  filters SQL_TEXT not null,
+  config SQL_TEXT null,
+  filters SQL_TEXT null,
   PRIMARY KEY(graph_id)
 ) TABLE_TYPE;
 

diff --git a/src/server/tools/nxdbmgr/upgrade.cpp b/src/server/tools/nxdbmgr/upgrade.cpp
index ed8c1ae..e0fc347 100644 (file)
--- a/src/server/tools/nxdbmgr/upgrade.cpp
+++ b/src/server/tools/nxdbmgr/upgrade.cpp
@@ -1977,6 +1977,7 @@ static BOOL H_UpgradeFromV383(int currVersion, int newVersion)
    static TCHAR batch[] =
       _T("ALTER TABLE graphs ADD flags integer\n")
       _T("ALTER TABLE graphs ADD filters $SQL:TEXT\n")
+      _T("UPDATE graphs SET flags=0\n")
       _T("<END>");
    CHK_EXEC(SQLBatch(batch));
    CHK_EXEC(SetSchemaVersion(384));