MariaDB driver and generate migrations

The company im working for insists on using MariaDB but im having issues generating migrations for my mariaDB. For schemas i am using 'drizzle-orm/mysql-core' and i create tables with mysqlTable() and for generating the migrations im using drizzle-kit generate:mysql. In the drizzle.config.ts i set the driver to this driver: 'mysql2' when i now want to run drizzle-kit push:mysql i get this error message
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUTO_INCREMENT NOT NULL'
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUTO_INCREMENT NOT NULL'
this is my user.ts schema:
export const users = mysqlTable('users', {
id: serial('id').primaryKey(),
fullName: text('full_name'),
});
export const users = mysqlTable('users', {
id: serial('id').primaryKey(),
fullName: text('full_name'),
});
this is the generated migration:
CREATE TABLE `users` (
`id` serial AUTO_INCREMENT NOT NULL,
`full_name` text,
CONSTRAINT `users_id` PRIMARY KEY(`id`)
);
CREATE TABLE `users` (
`id` serial AUTO_INCREMENT NOT NULL,
`full_name` text,
CONSTRAINT `users_id` PRIMARY KEY(`id`)
);
Am i doing something wrong?? 😆 thx for help in advance ❤️
1 Reply
Bot Dev
Bot Dev2mo ago
any help would be greatly appreciated