All pastes #717171 Raw Edit

Stuff

public text v1 · immutable
#717171 ·published 2007-09-27 13:15 UTC
rendered paste body
        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);