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();
}