tjwyrwpC

1let fileUrl = try!
2            FileManager.default.url(for: .documentDirectory, in: .userDomainMask, appropriateFor: nil, create: false).appendingPathComponent("RateappDatabase.sqlite")
3
4if sqlite3_open(fileUrl.path, &db) != SQLITE_OK{
5    print("Error opening database")
6    return
7}
8
9let createTableQuery1 = "CREATE TABLE IF NOT EXISTS UserDetails (UserID INTEGER PRIMARY KEY AUTOINCREMENT, Firstname TEXT, Lastname TEXT, DoB NUMERIC, Email TEXT, Username TEXT, Password TEXT, PostID INTEGER)"
10
11if sqlite3_exec(db, createTableQuery1, nil, nil, nil) != SQLITE_OK{
12    print("Error creating userdetails table")
13    return
14
15}