Back to Drizzle Orm

CreateSingleStoreTable

src/mdx/get-started/singlestore/CreateSingleStoreTable.mdx

latest419 B
Original Source

Create a schema.ts file in the src/db directory and declare your table:

typescript
import { int, singlestoreTable, varchar } from 'drizzle-orm/singlestore-core';

export const usersTable = singlestoreTable('users_table', {
  id: int().primaryKey(),
  name: varchar({ length: 255 }).notNull(),
  age: int().notNull(),
  email: varchar({ length: 255 }).notNull().unique(),
});