Database.swift

func setupDatabase() {
    // That "collation" helps us compare person names in a localized case insensitive fashion
    let collation = DatabaseCollation.localizedCaseInsensitiveCompare
    
    try! dbQueue.execute(
        "CREATE TABLE persons (" +
            "id INTEGER PRIMARY KEY, " +
            "name TEXT NOT NULL COLLATE \(collation.name), " +
            "score INTEGER NOT NULL " +
        ")")
    
    try! Person(name: "Arthur", score: 250).insert(dbQueue)
    try! Person(name: "Barbara", score: 750).insert(dbQueue)
    try! Person(name: "Craig", score: 500).insert(dbQueue)
}