public void GenerateServerDataBaseForFirstTime()
        {
            SQLite database = new SQLite();

            database.Password = Properties.Settings.Default["DataBasePasswordSetting"].ToString();
            database.Create(this.DBPath, this.Name);
            database.Connect();
            //creating tables
            //table users
            string query = "CREATE TABLE USERS (ID Integer PRIMARY KEY AUTOINCREMENT, USERNAME varchar(255) NOT NULL, PASSWORD varchar(255) NOT NULL, IDNUMBER int NOT NULL)";

            database.ExecuteNonQuery(query);
            //table messages
            query = "CREATE TABLE MESSAGES (ID Integer PRIMARY KEY AUTOINCREMENT, IDNUMBERSENDER INT NOT NULL, MESSAGE varchar(255) NOT NULL, IDNUMBERRECEIVER INT NOT NULL)";
            database.ExecuteNonQuery(query);
            database.Disconnect();
        }