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'

'drizzle-orm/mysql-core'

'drizzle-orm/mysql-core'

'drizzle-orm/mysql-core' and i create tables with

mysqlTable()

mysqlTable()

mysqlTable()

mysqlTable() and for generating the migrations im using

drizzle-kit generate:mysql

drizzle-kit generate:mysql

drizzle-kit generate:mysql

drizzle-kit generate:mysql.
In the

drizzle.config.ts

drizzle.config.ts

drizzle.config.ts

drizzle.config.ts i set the driver to this

driver: 'mysql2'

driver: 'mysql2'

driver: 'mysql2'

driver: 'mysql2'

when i now want to run

drizzle-kit push:mysql

drizzle-kit push:mysql

drizzle-kit push:mysql

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'

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'),
});

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`)
);

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

MariaDB driver and generate migrations

Similar Threads

Similar Threads

Similar Threads