lib/mysql
DefaultMySqlAccountsTable
type DefaultMySqlAccountsTable = MySqlTableWithColumns<{
columns: {
access_token: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
driverParam: string | number;
notNull: boolean;
}>;
expires_at: DefaultMyqlColumn<{
columnType: "MySqlInt";
data: number;
dataType: "number";
notNull: boolean;
}>;
id_token: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: boolean;
}>;
provider: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: true;
}>;
providerAccountId: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: true;
}>;
refresh_token: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: boolean;
}>;
scope: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: boolean;
}>;
session_state: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: boolean;
}>;
token_type: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: boolean;
}>;
type: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: true;
}>;
userId: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: true;
}>;
};
dialect: "mysql";
name: string;
schema: string | undefined;
}>;
DefaultMySqlAuthenticatorTable
type DefaultMySqlAuthenticatorTable = MySqlTableWithColumns<{
columns: {
counter: DefaultMyqlColumn<{
columnType: "MySqlInt";
data: number;
dataType: "number";
notNull: true;
}>;
credentialBackedUp: DefaultMyqlColumn<{
columnType: "MySqlBoolean";
data: boolean;
dataType: "boolean";
notNull: true;
}>;
credentialDeviceType: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: true;
}>;
credentialID: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: true;
}>;
credentialPublicKey: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: true;
}>;
providerAccountId: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: true;
}>;
transports: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: false;
}>;
userId: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: true;
}>;
};
dialect: "mysql";
name: string;
schema: string | undefined;
}>;
DefaultMySqlSchema
type DefaultMySqlSchema = {
accountsTable: DefaultMySqlAccountsTable;
authenticatorsTable: DefaultMySqlAuthenticatorTable;
sessionsTable: DefaultMySqlSessionsTable;
usersTable: DefaultMySqlUsersTable;
verificationTokensTable: DefaultMySqlVerificationTokenTable;
};
Type declaration
accountsTable
accountsTable: DefaultMySqlAccountsTable;
authenticatorsTable?
optional authenticatorsTable: DefaultMySqlAuthenticatorTable;
sessionsTable?
optional sessionsTable: DefaultMySqlSessionsTable;
usersTable
usersTable: DefaultMySqlUsersTable;
verificationTokensTable?
optional verificationTokensTable: DefaultMySqlVerificationTokenTable;
DefaultMySqlSessionsTable
type DefaultMySqlSessionsTable = MySqlTableWithColumns<{
columns: {
expires: DefaultMyqlColumn<{
columnType: "MySqlTimestamp";
data: Date;
dataType: "date";
notNull: true;
}>;
sessionToken: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
isPrimaryKey: true;
notNull: true;
}>;
userId: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: true;
}>;
};
dialect: "mysql";
name: string;
schema: string | undefined;
}>;
DefaultMySqlUsersTable
type DefaultMySqlUsersTable = MySqlTableWithColumns<{
columns: {
email: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: boolean;
}>;
emailVerified: DefaultMyqlColumn<{
columnType: "MySqlTimestamp";
data: Date;
dataType: "date";
notNull: boolean;
}>;
id: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
isPrimaryKey: true;
notNull: true;
}>;
image: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: boolean;
}>;
name: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: boolean;
}>;
};
dialect: "mysql";
name: string;
schema: string | undefined;
}>;
DefaultMySqlVerificationTokenTable
type DefaultMySqlVerificationTokenTable = MySqlTableWithColumns<{
columns: {
expires: DefaultMyqlColumn<{
columnType: "MySqlTimestamp";
data: Date;
dataType: "date";
notNull: true;
}>;
identifier: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: true;
}>;
token: DefaultMyqlColumn<{
columnType: "MySqlVarChar" | "MySqlText";
data: string;
dataType: "string";
notNull: true;
}>;
};
dialect: "mysql";
name: string;
schema: string | undefined;
}>;
defineTables()
function defineTables(schema): Required<DefaultMySqlSchema>
Parameters
Parameter | Type |
---|---|
schema | Partial <DefaultMySqlSchema > |
Returns
MySqlDrizzleAdapter()
function MySqlDrizzleAdapter(client, schema?): Adapter
Parameters
Parameter | Type |
---|---|
client | MySqlDatabase <MySqlQueryResultHKT , PreparedQueryHKTBase , any > |
schema ? | DefaultMySqlSchema |