add migration to enforce template max_ttl 7-day cap

johnstcn · johnstcn · commit c14aadd4f701 · 2022-08-24T10:05:43.000Z
diff --git a/coderd/database/migrations/000038_template_max_ttl_cap_7_days.down.sql b/coderd/database/migrations/000038_template_max_ttl_cap_7_days.down.sql
@@ -0,0 +1 @@
+-- this is a no-op
diff --git a/coderd/database/migrations/000038_template_max_ttl_cap_7_days.up.sql b/coderd/database/migrations/000038_template_max_ttl_cap_7_days.up.sql
@@ -0,0 +1,2 @@
+-- Set a cap of 7 days on template max_ttl
+UPDATE templates SET max_ttl = 604800000000000 WHERE max_ttl > 604800000000000;

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+-- Set a cap of 7 days on template max_ttl`
	`2`	`+UPDATE templates SET max_ttl = 604800000000000 WHERE max_ttl > 604800000000000;`