sqlite3_exec (db, "CREATE TABLE users (id INTEGER PRIMARY KEY, uid INTEGER UNIQUE, name TEXT, domain TEXT)", 0, 0, &zErrMsg); sqlite3_exec (db, "CREATE UNIQUE INDEX uid_index ON users (uid)", 0, 0, &zErrMsg); sqlite3_exec (db, "CREATE UNIQUE INDEX name_index ON users (name)", 0, 0, &zErrMsg); sqlite3_exec (db, "CREATE UNIQUE INDEX domain_index ON users (domain)", 0, 0, &zErrMsg);