Skip to content
Migrating from NextAuth.js v4? Read our migration guide.
API reference
@auth/drizzle-adapter
lib
Sqlite

lib/sqlite

DefaultSQLiteSchema

type DefaultSQLiteSchema: {
  accountsTable: SQLiteTableFn<typeof sqliteAccountsTable["_"]["config"]>;
  sessionsTable: SQLiteTableFn<typeof sqliteSessionsTable["_"]["config"]>;
  usersTable: SQLiteTableFn<typeof sqliteUsersTable["_"]["config"]>;
  verificationTokensTable: SQLiteTableFn<typeof sqliteVerificationTokensTable["_"]["config"]>;
};

Type declaration

accountsTable

accountsTable: SQLiteTableFn<typeof sqliteAccountsTable["_"]["config"]>;

sessionsTable

sessionsTable: SQLiteTableFn<typeof sqliteSessionsTable["_"]["config"]>;

usersTable

usersTable: SQLiteTableFn<typeof sqliteUsersTable["_"]["config"]>;

verificationTokensTable

verificationTokensTable: SQLiteTableFn<typeof sqliteVerificationTokensTable["_"]["config"]>;

SQLiteTableFn<T>

type SQLiteTableFn<T>: SQLiteTableWithColumns<{
  columns: T["columns"];
  dialect: T["dialect"];
  name: T["name"];
  schema: string | undefined;
}>;

Type declaration

columns

columns: T["columns"];

dialect

dialect: T["dialect"];

name

name: T["name"];

schema

schema: string | undefined;

Type parameters

Type parameter
T extends TableConfig

sqliteAccountsTable

const sqliteAccountsTable: SQLiteTableWithColumns<{
  columns: {
     access_token: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "access_token";
        notNull: false;
        tableName: string;
     }, object>;
     expires_at: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteInteger";
        data: number;
        dataType: "number";
        driverParam: number;
        enumValues: undefined;
        hasDefault: false;
        name: "expires_at";
        notNull: false;
        tableName: string;
     }, object>;
     id_token: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "id_token";
        notNull: false;
        tableName: string;
     }, object>;
     provider: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "provider";
        notNull: true;
        tableName: string;
     }, object>;
     providerAccountId: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "providerAccountId";
        notNull: true;
        tableName: string;
     }, object>;
     refresh_token: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "refresh_token";
        notNull: false;
        tableName: string;
     }, object>;
     scope: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "scope";
        notNull: false;
        tableName: string;
     }, object>;
     session_state: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "session_state";
        notNull: false;
        tableName: string;
     }, object>;
     token_type: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "token_type";
        notNull: false;
        tableName: string;
     }, object>;
     type: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "type";
        notNull: true;
        tableName: string;
     }, object>;
     userId: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "userId";
        notNull: true;
        tableName: string;
     }, object>;
  };
  dialect: "sqlite";
  name: string;
  schema: undefined;
}>;

Type declaration

columns

columns: {
  access_token: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "access_token";
     notNull: false;
     tableName: string;
  }, object>;
  expires_at: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteInteger";
     data: number;
     dataType: "number";
     driverParam: number;
     enumValues: undefined;
     hasDefault: false;
     name: "expires_at";
     notNull: false;
     tableName: string;
  }, object>;
  id_token: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "id_token";
     notNull: false;
     tableName: string;
  }, object>;
  provider: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "provider";
     notNull: true;
     tableName: string;
  }, object>;
  providerAccountId: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "providerAccountId";
     notNull: true;
     tableName: string;
  }, object>;
  refresh_token: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "refresh_token";
     notNull: false;
     tableName: string;
  }, object>;
  scope: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "scope";
     notNull: false;
     tableName: string;
  }, object>;
  session_state: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "session_state";
     notNull: false;
     tableName: string;
  }, object>;
  token_type: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "token_type";
     notNull: false;
     tableName: string;
  }, object>;
  type: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "type";
     notNull: true;
     tableName: string;
  }, object>;
  userId: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "userId";
     notNull: true;
     tableName: string;
  }, object>;
};

columns.access_token

access_token: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "access_token";
  notNull: false;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "access_token";
notNull
notNull: false;
tableName
tableName: string;

columns.expires_at

expires_at: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteInteger";
  data: number;
  dataType: "number";
  driverParam: number;
  enumValues: undefined;
  hasDefault: false;
  name: "expires_at";
  notNull: false;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteInteger";
data
data: number;
dataType
dataType: "number";
driverParam
driverParam: number;
enumValues
enumValues: undefined;
hasDefault
hasDefault: false;
name
name: "expires_at";
notNull
notNull: false;
tableName
tableName: string;

columns.id_token

id_token: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "id_token";
  notNull: false;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "id_token";
notNull
notNull: false;
tableName
tableName: string;

columns.provider

provider: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "provider";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "provider";
notNull
notNull: true;
tableName
tableName: string;

columns.providerAccountId

providerAccountId: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "providerAccountId";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "providerAccountId";
notNull
notNull: true;
tableName
tableName: string;

columns.refresh_token

refresh_token: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "refresh_token";
  notNull: false;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "refresh_token";
notNull
notNull: false;
tableName
tableName: string;

columns.scope

scope: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "scope";
  notNull: false;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "scope";
notNull
notNull: false;
tableName
tableName: string;

columns.session_state

session_state: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "session_state";
  notNull: false;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "session_state";
notNull
notNull: false;
tableName
tableName: string;

columns.token_type

token_type: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "token_type";
  notNull: false;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "token_type";
notNull
notNull: false;
tableName
tableName: string;

columns.type

type: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "type";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "type";
notNull
notNull: true;
tableName
tableName: string;

columns.userId

userId: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "userId";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "userId";
notNull
notNull: true;
tableName
tableName: string;

dialect

dialect: "sqlite";

name

name: string;

schema

schema: undefined;

sqliteSessionsTable

const sqliteSessionsTable: SQLiteTableWithColumns<{
  columns: {
     expires: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteTimestamp";
        data: Date;
        dataType: "date";
        driverParam: number;
        enumValues: undefined;
        hasDefault: false;
        name: "expires";
        notNull: true;
        tableName: string;
     }, object>;
     id: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: true;
        name: "id";
        notNull: true;
        tableName: string;
     }, object>;
     sessionToken: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "sessionToken";
        notNull: true;
        tableName: string;
     }, object>;
     userId: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "userId";
        notNull: true;
        tableName: string;
     }, object>;
  };
  dialect: "sqlite";
  name: string;
  schema: undefined;
}>;

Type declaration

columns

columns: {
  expires: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteTimestamp";
     data: Date;
     dataType: "date";
     driverParam: number;
     enumValues: undefined;
     hasDefault: false;
     name: "expires";
     notNull: true;
     tableName: string;
  }, object>;
  id: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: true;
     name: "id";
     notNull: true;
     tableName: string;
  }, object>;
  sessionToken: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "sessionToken";
     notNull: true;
     tableName: string;
  }, object>;
  userId: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "userId";
     notNull: true;
     tableName: string;
  }, object>;
};

columns.expires

expires: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteTimestamp";
  data: Date;
  dataType: "date";
  driverParam: number;
  enumValues: undefined;
  hasDefault: false;
  name: "expires";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteTimestamp";
data
data: Date;
dataType
dataType: "date";
driverParam
driverParam: number;
enumValues
enumValues: undefined;
hasDefault
hasDefault: false;
name
name: "expires";
notNull
notNull: true;
tableName
tableName: string;

columns.id

id: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: true;
  name: "id";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: true;
name
name: "id";
notNull
notNull: true;
tableName
tableName: string;

columns.sessionToken

sessionToken: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "sessionToken";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "sessionToken";
notNull
notNull: true;
tableName
tableName: string;

columns.userId

userId: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "userId";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "userId";
notNull
notNull: true;
tableName
tableName: string;

dialect

dialect: "sqlite";

name

name: string;

schema

schema: undefined;

sqliteUsersTable

const sqliteUsersTable: SQLiteTableWithColumns<{
  columns: {
     email: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "email";
        notNull: true;
        tableName: string;
     }, object>;
     emailVerified: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteTimestamp";
        data: Date;
        dataType: "date";
        driverParam: number;
        enumValues: undefined;
        hasDefault: false;
        name: "emailVerified";
        notNull: false;
        tableName: string;
     }, object>;
     id: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: true;
        name: "id";
        notNull: true;
        tableName: string;
     }, object>;
     image: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "image";
        notNull: false;
        tableName: string;
     }, object>;
     name: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "name";
        notNull: false;
        tableName: string;
     }, object>;
  };
  dialect: "sqlite";
  name: string;
  schema: undefined;
}>;

Type declaration

columns

columns: {
  email: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "email";
     notNull: true;
     tableName: string;
  }, object>;
  emailVerified: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteTimestamp";
     data: Date;
     dataType: "date";
     driverParam: number;
     enumValues: undefined;
     hasDefault: false;
     name: "emailVerified";
     notNull: false;
     tableName: string;
  }, object>;
  id: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: true;
     name: "id";
     notNull: true;
     tableName: string;
  }, object>;
  image: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "image";
     notNull: false;
     tableName: string;
  }, object>;
  name: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "name";
     notNull: false;
     tableName: string;
  }, object>;
};

columns.email

email: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "email";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "email";
notNull
notNull: true;
tableName
tableName: string;

columns.emailVerified

emailVerified: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteTimestamp";
  data: Date;
  dataType: "date";
  driverParam: number;
  enumValues: undefined;
  hasDefault: false;
  name: "emailVerified";
  notNull: false;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteTimestamp";
data
data: Date;
dataType
dataType: "date";
driverParam
driverParam: number;
enumValues
enumValues: undefined;
hasDefault
hasDefault: false;
name
name: "emailVerified";
notNull
notNull: false;
tableName
tableName: string;

columns.id

id: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: true;
  name: "id";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: true;
name
name: "id";
notNull
notNull: true;
tableName
tableName: string;

columns.image

image: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "image";
  notNull: false;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "image";
notNull
notNull: false;
tableName
tableName: string;

columns.name

name: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "name";
  notNull: false;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "name";
notNull
notNull: false;
tableName
tableName: string;

dialect

dialect: "sqlite";

name

name: string;

schema

schema: undefined;

sqliteVerificationTokensTable

const sqliteVerificationTokensTable: SQLiteTableWithColumns<{
  columns: {
     expires: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteTimestamp";
        data: Date;
        dataType: "date";
        driverParam: number;
        enumValues: undefined;
        hasDefault: false;
        name: "expires";
        notNull: true;
        tableName: string;
     }, object>;
     identifier: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "identifier";
        notNull: true;
        tableName: string;
     }, object>;
     token: SQLiteColumn<{
        baseColumn: never;
        columnType: "SQLiteText";
        data: string;
        dataType: "string";
        driverParam: string;
        enumValues: [string, ...string[]];
        hasDefault: false;
        name: "token";
        notNull: true;
        tableName: string;
     }, object>;
  };
  dialect: "sqlite";
  name: string;
  schema: undefined;
}>;

Type declaration

columns

columns: {
  expires: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteTimestamp";
     data: Date;
     dataType: "date";
     driverParam: number;
     enumValues: undefined;
     hasDefault: false;
     name: "expires";
     notNull: true;
     tableName: string;
  }, object>;
  identifier: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "identifier";
     notNull: true;
     tableName: string;
  }, object>;
  token: SQLiteColumn<{
     baseColumn: never;
     columnType: "SQLiteText";
     data: string;
     dataType: "string";
     driverParam: string;
     enumValues: [string, ...string[]];
     hasDefault: false;
     name: "token";
     notNull: true;
     tableName: string;
  }, object>;
};

columns.expires

expires: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteTimestamp";
  data: Date;
  dataType: "date";
  driverParam: number;
  enumValues: undefined;
  hasDefault: false;
  name: "expires";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteTimestamp";
data
data: Date;
dataType
dataType: "date";
driverParam
driverParam: number;
enumValues
enumValues: undefined;
hasDefault
hasDefault: false;
name
name: "expires";
notNull
notNull: true;
tableName
tableName: string;

columns.identifier

identifier: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "identifier";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "identifier";
notNull
notNull: true;
tableName
tableName: string;

columns.token

token: SQLiteColumn<{
  baseColumn: never;
  columnType: "SQLiteText";
  data: string;
  dataType: "string";
  driverParam: string;
  enumValues: [string, ...string[]];
  hasDefault: false;
  name: "token";
  notNull: true;
  tableName: string;
}, object>;
Type declaration
baseColumn
baseColumn: never;
columnType
columnType: "SQLiteText";
data
data: string;
dataType
dataType: "string";
driverParam
driverParam: string;
enumValues
enumValues: [string, ...string[]];
hasDefault
hasDefault: false;
name
name: "token";
notNull
notNull: true;
tableName
tableName: string;

dialect

dialect: "sqlite";

name

name: string;

schema

schema: undefined;

SQLiteDrizzleAdapter()

SQLiteDrizzleAdapter(client, schema): Adapter

Parameters

ParameterType
clientBaseSQLiteDatabase<"sync" | "async", any, any, ExtractTablesWithRelations<any>>
schemaDefaultSQLiteSchema

Returns

Adapter

PgUtils

About Auth.js

Download

Acknowledgements

Auth.js © Balázs Orbán and Team - 2024