DT
Drizzle TeamBot Dev

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 ❤️
BD
Bot Dev•11d ago
any help would be greatly appreciated
Want results from more Discord servers?
Add your server
More Posts
Naming Migrationshow do i set a name for a new migration when running `drizzle-kit generate:mysql` ? i tried setting [postgres][zod] createInsertSchemaHey! Trying to make my Sveltekit form schema. Here is my example: ```export const userAccessesFormSUse schema definition as normal typesI want to use my schema definition as a normal type. Basically what .select().from() returns - plainWhat is a recommended way to execute migration on CI ?Build facilities for migration assume it happens during app execution I don't sure it a good idea an