public async Task Create() { command.Parameters.Clear(); command.CommandText = "PRAGMA foreign_keys = ON;" + "CREATE TABLE IF NOT EXISTS Users " + "(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, " + "name TEXT NOT NULL, " + "surname TEXT NOT NULL, " + "login TEXT NOT NULL, " + "pswd TEXT NOT NULL);" + "CREATE TABLE IF NOT EXISTS Coaches " + "(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, " + "usr_id INTEGER NOT NULL," + "FOREIGN KEY(usr_id) REFERENCES Users(id) ON DELETE CASCADE);"; command.CommandType = CommandType.Text; await db.ExecuteNonQueryAsyncAtomic(command); Debug.WriteLine("DB Created"); }
public async Task Create() { command.Parameters.Clear(); command.CommandText = "PRAGMA foreign_keys = ON;" + "CREATE TABLE IF NOT EXISTS Trainings " + "(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, " + "name TEXT NOT NULL, " + "coach_id INTEGER NOT NULL, " + "date INTEGER UNIQUE NOT NULL);" + "CREATE TABLE IF NOT EXISTS Trainees " + "(training_id INTEGER NOT NULL," + "user_id INTEGER NOT NULL," + "PRIMARY KEY(training_id, user_id));"; command.CommandType = CommandType.Text; await db.ExecuteNonQueryAsyncAtomic(command); Debug.WriteLine("DB Created"); }