Skip to content
The Auth.js project is now part of Better Auth.

lib/sqlite

DefaultSQLiteAccountsTable

type DefaultSQLiteAccountsTable = SQLiteTableWithColumns<{  columns: {  access_token: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: boolean;  }>;  expires_at: DefaultSQLiteColumn<{  columnType: "SQLiteInteger";  data: number;  dataType: "number";  notNull: boolean;  }>;  id_token: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: boolean;  }>;  provider: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: true;  }>;  providerAccountId: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: true;  }>;  refresh_token: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: boolean;  }>;  scope: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: boolean;  }>;  session_state: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: boolean;  }>;  token_type: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: boolean;  }>;  type: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: true;  }>;  userId: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: true;  }>;  };  dialect: "sqlite";  name: string;  schema: string | undefined; }>;

DefaultSQLiteAuthenticatorTable

type DefaultSQLiteAuthenticatorTable = SQLiteTableWithColumns<{  columns: {  counter: DefaultSQLiteColumn<{  columnType: "SQLiteInteger";  data: number;  dataType: "number";  notNull: true;  }>;  credentialBackedUp: DefaultSQLiteColumn<{  columnType: "SQLiteBoolean";  data: boolean;  dataType: "boolean";  notNull: true;  }>;  credentialDeviceType: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: true;  }>;  credentialID: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: true;  }>;  credentialPublicKey: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: true;  }>;  providerAccountId: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: true;  }>;  transports: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: false;  }>;  userId: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: true;  }>;  };  dialect: "sqlite";  name: string;  schema: string | undefined; }>;

DefaultSQLiteSchema

type DefaultSQLiteSchema = {  accountsTable: DefaultSQLiteAccountsTable;  authenticatorsTable: DefaultSQLiteAuthenticatorTable;  sessionsTable: DefaultSQLiteSessionsTable;  usersTable: DefaultSQLiteUsersTable;  verificationTokensTable: DefaultSQLiteVerificationTokenTable; };

Type declaration

accountsTable

accountsTable: DefaultSQLiteAccountsTable;

authenticatorsTable?

optional authenticatorsTable: DefaultSQLiteAuthenticatorTable;

sessionsTable?

optional sessionsTable: DefaultSQLiteSessionsTable;

usersTable

usersTable: DefaultSQLiteUsersTable;

verificationTokensTable?

optional verificationTokensTable: DefaultSQLiteVerificationTokenTable;

DefaultSQLiteSessionsTable

type DefaultSQLiteSessionsTable = SQLiteTableWithColumns<{  columns: {  expires: DefaultSQLiteColumn<{  columnType: "SQLiteTimestamp";  data: Date;  dataType: "date";  notNull: true;  }>;  sessionToken: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  isPrimaryKey: true;  notNull: true;  }>;  userId: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: true;  }>;  };  dialect: "sqlite";  name: string;  schema: string | undefined; }>;

DefaultSQLiteUsersTable

type DefaultSQLiteUsersTable = SQLiteTableWithColumns<{  columns: {  email: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: boolean;  }>;  emailVerified: DefaultSQLiteColumn<{  columnType: "SQLiteTimestamp";  data: Date;  dataType: "date";  notNull: boolean;  }>;  id: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  isPrimaryKey: true;  notNull: true;  }>;  image: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: boolean;  }>;  name: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: boolean;  }>;  };  dialect: "sqlite";  name: string;  schema: string | undefined; }>;

DefaultSQLiteVerificationTokenTable

type DefaultSQLiteVerificationTokenTable = SQLiteTableWithColumns<{  columns: {  expires: DefaultSQLiteColumn<{  columnType: "SQLiteTimestamp";  data: Date;  dataType: "date";  notNull: true;  }>;  identifier: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: true;  }>;  token: DefaultSQLiteColumn<{  columnType: "SQLiteText";  data: string;  dataType: "string";  notNull: true;  }>;  };  dialect: "sqlite";  name: string;  schema: string | undefined; }>;

defineTables()

function defineTables(schema): Required<DefaultSQLiteSchema>

Parameters

ParameterType
schemaPartial<DefaultSQLiteSchema>

Returns

Required<DefaultSQLiteSchema>


SQLiteDrizzleAdapter()

function SQLiteDrizzleAdapter(client, schema?): Adapter

Parameters

ParameterType
clientBaseSQLiteDatabase<"sync" | "async", any, any>
schema?DefaultSQLiteSchema

Returns

Adapter

Auth.js © Better Auth Inc. - 2025