[chronojump] DB:2.23 Inserted socialNetwork variables at preferences

[Xavier de Blas <xaviblas src gnome org>]

commit aa3568bab80cc68c96be82c0116b55903cad7633
Author: Xavier de Blas <xaviblas gmail com>
Date:   Tue Jun 8 17:59:45 2021 +0200

    DB:2.23 Inserted socialNetwork variables at preferences

 src/preferences.cs        |  4 ++++
 src/sqlite/main.cs        | 11 ++++++++++-
 src/sqlite/preferences.cs | 11 +++++++++++
 3 files changed, 25 insertions(+), 1 deletion(-)
---
diff --git a/src/preferences.cs b/src/preferences.cs
index 9e1614c07..54176a284 100644
--- a/src/preferences.cs
+++ b/src/preferences.cs
@@ -203,6 +203,10 @@ public class Preferences
        public string serverNewsDatetime;       // NOT on SQL
        public string clientNewsDatetime;       // on SQL
 
+       //socialNetwork poll
+       public string socialNetwork;
+       public string socialNetworkDatetime; // "": not answered, -1: it should be sent when there's network 
(after a ping)
+
        //jumps
        public bool jumpsFVProfileOnlyBestInWeight;
        public bool jumpsFVProfileShowFullGraph;
diff --git a/src/sqlite/main.cs b/src/sqlite/main.cs
index 81a0faab4..0115d550f 100644
--- a/src/sqlite/main.cs
+++ b/src/sqlite/main.cs
@@ -129,7 +129,7 @@ class Sqlite
        /*
         * Important, change this if there's any update to database
         */
-       static string lastChronojumpDatabaseVersion = "2.22";
+       static string lastChronojumpDatabaseVersion = "2.23";
 
        public Sqlite()
        {
@@ -3010,7 +3010,15 @@ class Sqlite
 
                                currentVersion = updateVersion("2.22");
                        }
+                       if(currentVersion == "2.22")
+                       {
+                               LogB.SQL("Inserted socialNetwork variables at preferences");
+
+                               SqlitePreferences.Insert (SqlitePreferences.SocialNetwork, "");
+                               SqlitePreferences.Insert (SqlitePreferences.SocialNetworkDatetime, "");
 
+                               currentVersion = updateVersion("2.23");
+                       }
 
 
                        /*
@@ -3232,6 +3240,7 @@ class Sqlite
 //just testing: 1.79 - 1.80 Converted DB to 1.80 Created table ForceSensorElasticBandGlue and moved 
stiffnessString records there
 
 
+               //2.22 - 2.23 Converted DB to 2.23 Inserted socialNetwork variables at preferences
                //2.21 - 2.22 Converted DB to 2.22 Inserted forceSensorFeedbackPath params
                //2.20 - 2.21 Converted DB to 2.21 Inserted into preferences: runsEvolutionShowTime
                //2.19 - 2.20 Converted DB to 2.20 Inserted into preferences: runsEvolutionOnlyBestInSession
diff --git a/src/sqlite/preferences.cs b/src/sqlite/preferences.cs
index 48a2733cc..aa1d7966f 100644
--- a/src/sqlite/preferences.cs
+++ b/src/sqlite/preferences.cs
@@ -44,6 +44,9 @@ class SqlitePreferences : Sqlite
        public const string ServerNewsDatetime = "serverNewsDatetime"; // NOT stored on SQL. string of last 
news in server, obtained on pingAtNewsAtStart
        public const string ClientNewsDatetime = "clientNewsDatetime"; // stored on SQL. string of last news 
local, when user clicks on getNews(), if this is diff than server... news are downloaded and this is updated
 
+       public const string SocialNetwork = "socialNetwork";
+       public const string SocialNetworkDatetime = "socialNetworkDatetime"; //"": not answered, -1: should 
be sent when there's network (after a ping)
+
        //contacts
        public const string JumpsFVProfileOnlyBestInWeight = "jumpsFVProfileOnlyBestInWeight";
        public const string JumpsFVProfileShowFullGraph = "jumpsFVProfileShowFullGraph";
@@ -357,6 +360,10 @@ class SqlitePreferences : Sqlite
                                Insert (NewsLanguageEs, "False", dbcmdTr);
                                Insert (ClientNewsDatetime, "", dbcmdTr);
 
+                               //socialNetwork
+                               Insert (SocialNetwork, "", dbcmdTr);
+                               Insert (SocialNetworkDatetime, "", dbcmdTr);
+
                                //session
                                Insert (LoadLastSessionAtStart, "True", dbcmdTr);
                                Insert (LastSessionID, "-1", dbcmdTr);
@@ -506,6 +513,10 @@ class SqlitePreferences : Sqlite
                                preferences.newsLanguageEs = reader[1].ToString() == "True"; //bool
                        else if(reader[0].ToString() == ClientNewsDatetime )
                                preferences.clientNewsDatetime = reader[1].ToString();
+                       else if(reader[0].ToString() == SocialNetwork )
+                               preferences.socialNetwork = reader[1].ToString();
+                       else if(reader[0].ToString() == SocialNetworkDatetime )
+                               preferences.socialNetworkDatetime = reader[1].ToString();
                        else if(reader[0].ToString() == UnitsStr)
                                preferences.units = (Preferences.UnitsEnum)
                                        Enum.Parse(typeof(Preferences.UnitsEnum), reader[1].ToString());