drop column from db

f0ssel · f0ssel · commit 66fb92d586fa · 2022-11-07T17:33:20.000Z
diff --git a/coderd/database/migrations/000069_remove_min_autostart.down.sql b/coderd/database/migrations/000069_remove_min_autostart.down.sql
@@ -0,0 +1,2 @@
+-- add "slug" min_autostart_interval to "templates" table
+ALTER TABLE "templates" ADD COLUMN "min_autostart_interval" int DEFAULT 0;
diff --git a/coderd/database/migrations/000069_remove_min_autostart.up.sql b/coderd/database/migrations/000069_remove_min_autostart.up.sql
@@ -0,0 +1,2 @@
+-- drop "min_autostart_interval" column from "templates" table
+ALTER TABLE "templates" DROP COLUMN "min_autostart_interval";

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+-- add "slug" min_autostart_interval to "templates" table`
	`2`	`+ALTER TABLE "templates" ADD COLUMN "min_autostart_interval" int DEFAULT 0;`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+-- drop "min_autostart_interval" column from "templates" table`
	`2`	`+ALTER TABLE "templates" DROP COLUMN "min_autostart_interval";`