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
| Parameter | Type |
|---|---|
schema | Partial<DefaultSQLiteSchema> |
Returns
SQLiteDrizzleAdapter()
function SQLiteDrizzleAdapter(client, schema?): AdapterParameters
| Parameter | Type |
|---|---|
client | BaseSQLiteDatabase<"sync" | "async", any, any> |
schema? | DefaultSQLiteSchema |