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