Fixed issue with local sync SQL Logic error.

Added some missing columns to SQLite db.
Direct Remote Sync is fully working !!!

1 files changed, 4 insertions, 4 deletions

diff --git a/Software/Visual_Studio/Tango.Synchronization/Local/SqliteDataBase.cs b/Software/Visual_Studio/Tango.Synchronization/Local/SqliteDataBase.cs
index 6068d5b6c..2596853c6 100644
--- a/Software/Visual_Studio/Tango.Synchronization/Local/SqliteDataBase.cs
+++ b/Software/Visual_Studio/Tango.Synchronization/Local/SqliteDataBase.cs
@@ -247,13 +247,13 @@ namespace Tango.Synchronization.Local
         public DataColumn AddColumn(DataTable table, DataColumn column)
         {
             var insertCommand = _connection.CreateCommand();
-            insertCommand.CommandText = String.Format("ALTER TABLE {0} ADD COLUMN {1} {2} {3} {4} {5} {6}",
+            insertCommand.CommandText = String.Format("ALTER TABLE {0} ADD COLUMN {1} {2} {3} {4} {5}",
                 table.TableName,
                 column.ColumnName,
                 column.GetSQLType(),
                 table.PrimaryKey.Contains(column) ? "PRIMARY KEY" : null,
                 column.Unique ? "UNIQUE" : null,
-                column.IsNotNull() ? "NOT NULL" : null,
+                //column.IsNotNull() ? "NOT NULL" : null,
                 column.HasDefaultValue() ? ("DEFAULT " + column.GetDefaultValue()) : null);
 
 
@@ -272,13 +272,13 @@ namespace Tango.Synchronization.Local
         /// <returns></returns>
         public String GetAddColumnCommand(DataTable table, DataColumn column)
         {
-            String cmd = String.Format("ALTER TABLE {0} ADD COLUMN {1} {2} {3} {4} {5} {6}",
+            String cmd = String.Format("ALTER TABLE {0} ADD COLUMN {1} {2} {3} {4} {5}",
                 table.TableName,
                 column.ColumnName,
                 column.GetSQLType(),
                 table.PrimaryKey.Contains(column) ? "PRIMARY KEY" : null,
                 column.Unique ? "UNIQUE" : null,
-                column.IsNotNull() ? "NOT NULL" : null,
+                //column.IsNotNull() ? "NOT NULL" : null,
                 column.HasDefaultValue() ? ("DEFAULT " + column.GetDefaultValue()) : null);
 
             return cmd;