3 replies

How to change schema without losing data?

I want to change my schema & add a new field

hidden: boolean("hidden").notNull().default(false),

hidden: boolean("hidden").notNull().default(false),

My current schema looks like:

id: serial('id').primaryKey(),
slug: varchar('slug', { length: 64 }).unique().notNull(),
title: varchar('title', { length: 64 }).unique().notNull(),
content: text('content').notNull(),
createdAt: timestamp('created_at').defaultNow(),
lastEdit: timestamp('last_edit').defaultNow(),
readTime: smallint('read_time').notNull()

id: serial('id').primaryKey(),
slug: varchar('slug', { length: 64 }).unique().notNull(),
title: varchar('title', { length: 64 }).unique().notNull(),
content: text('content').notNull(),
createdAt: timestamp('created_at').defaultNow(),
lastEdit: timestamp('last_edit').defaultNow(),
readTime: smallint('read_time').notNull()

Now whenever I edit my schema the data from my supabase(postgres) database gets deleted. How can I change the schema while also preserving all the rows in my database??

Drizzle Team•2y ago•

3 replies

textYash

How to change schema without losing data?

I want to change my schema & add a new field

hidden: boolean("hidden").notNull().default(false),

hidden: boolean("hidden").notNull().default(false),

My current schema looks like:

id: serial('id').primaryKey(),
slug: varchar('slug', { length: 64 }).unique().notNull(),
title: varchar('title', { length: 64 }).unique().notNull(),
content: text('content').notNull(),
createdAt: timestamp('created_at').defaultNow(),
lastEdit: timestamp('last_edit').defaultNow(),
readTime: smallint('read_time').notNull()

id: serial('id').primaryKey(),
slug: varchar('slug', { length: 64 }).unique().notNull(),
title: varchar('title', { length: 64 }).unique().notNull(),
content: text('content').notNull(),
createdAt: timestamp('created_at').defaultNow(),
lastEdit: timestamp('last_edit').defaultNow(),
readTime: smallint('read_time').notNull()

Now whenever I edit my schema the data from my supabase(postgres) database gets deleted. How can I change the schema while also preserving all the rows in my database??

How to change schema without losing data?

Similar Threads

How to change schema without losing data?

Similar Threads

Similar Threads

Similar Threads