11 replies

MySQL Table Schemas

I need to generate the following structure of tables:

1. Sales
2.Sales
....

1. Sales
2.Sales
....

Currently if I use what the docs say regarding the configuration of schemas, when I run

drizzle-kit generate:mysql

drizzle-kit generate:mysql

I get the following sql file:

CREATE DATABASE

CREATE DATABASE

127

;
--> statement-breakpoint
CREATE TABLE

;
--> statement-breakpoint
CREATE TABLE

127

sales

 int AUTO_INCREMENT NOT NULL,

 int AUTO_INCREMENT NOT NULL,

double

 double DEFAULT 0,
    CONSTRAINT

 double DEFAULT 0,
    CONSTRAINT

sales_id

 PRIMARY KEY(

 PRIMARY KEY(

)
);

)
);

What I'm looking for is not to create a database for each tenant but only create their set of tables.

This is my schema definition:

import { mysqlTable, int, double, mysqlSchema } from "drizzle-orm/mysql-core";

export const mySchema = mysqlSchema("dynamic_value_here")

export const sales = mySchema.table("sales", {
  id: int("id").primaryKey().autoincrement(),
  total_price_dlrs: double("double").default(0),
});
export type Sale = typeof sales.$inferSelect;
export type NewSale = typeof sales.$inferInsert;

import { mysqlTable, int, double, mysqlSchema } from "drizzle-orm/mysql-core";

export const mySchema = mysqlSchema("dynamic_value_here")

export const sales = mySchema.table("sales", {
  id: int("id").primaryKey().autoincrement(),
  total_price_dlrs: double("double").default(0),
});
export type Sale = typeof sales.$inferSelect;
export type NewSale = typeof sales.$inferInsert;

Could someone please help me and point me in the right direction? Thanks in advance

MySQL Table Schemas

I need to generate the following structure of tables:

1. Sales
2.Sales
....

1. Sales
2.Sales
....

Currently if I use what the docs say regarding the configuration of schemas, when I run

drizzle-kit generate:mysql

drizzle-kit generate:mysql

I get the following sql file:

CREATE DATABASE

CREATE DATABASE

127

;
--> statement-breakpoint
CREATE TABLE

;
--> statement-breakpoint
CREATE TABLE

127

sales

 int AUTO_INCREMENT NOT NULL,

 int AUTO_INCREMENT NOT NULL,

double

 double DEFAULT 0,
    CONSTRAINT

 double DEFAULT 0,
    CONSTRAINT

sales_id

 PRIMARY KEY(

 PRIMARY KEY(

)
);

)
);

What I'm looking for is not to create a database for each tenant but only create their set of tables.

This is my schema definition:

import { mysqlTable, int, double, mysqlSchema } from "drizzle-orm/mysql-core";

export const mySchema = mysqlSchema("dynamic_value_here")

export const sales = mySchema.table("sales", {
  id: int("id").primaryKey().autoincrement(),
  total_price_dlrs: double("double").default(0),
});
export type Sale = typeof sales.$inferSelect;
export type NewSale = typeof sales.$inferInsert;

import { mysqlTable, int, double, mysqlSchema } from "drizzle-orm/mysql-core";

export const mySchema = mysqlSchema("dynamic_value_here")

export const sales = mySchema.table("sales", {
  id: int("id").primaryKey().autoincrement(),
  total_price_dlrs: double("double").default(0),
});
export type Sale = typeof sales.$inferSelect;
export type NewSale = typeof sales.$inferInsert;

Could someone please help me and point me in the right direction? Thanks in advance

MySQL Table Schemas

Similar Threads

MySQL Table Schemas

Similar Threads

Similar Threads

Similar Threads