coder
diff --git a/‎coderd/database/dump.sql
+4 b/‎coderd/database/dump.sql
+4
diff --git a/‎coderd/database/migrations/000077_job_logs_job_id_id_index.down.sql
+1 b/‎coderd/database/migrations/000077_job_logs_job_id_id_index.down.sql
+1
diff --git a/‎coderd/database/migrations/000077_job_logs_job_id_id_index.up.sql
+1 b/‎coderd/database/migrations/000077_job_logs_job_id_id_index.up.sql
+1
diff --git a/‎coderd/database/migrations/000078_workspace_agents_resource_id_idx.down.sql
+1 b/‎coderd/database/migrations/000078_workspace_agents_resource_id_idx.down.sql
+1
diff --git a/‎coderd/database/migrations/000078_workspace_agents_resource_id_idx.up.sql
+1 b/‎coderd/database/migrations/000078_workspace_agents_resource_id_idx.up.sql
+1
diff --git a/‎coderd/database/migrations/000077_license_ids.down.sql renamed to ‎coderd/database/migrations/000079_license_ids.down.sql b/‎coderd/database/migrations/000077_license_ids.down.sql renamed to ‎coderd/database/migrations/000079_license_ids.down.sql
diff --git a/‎coderd/database/migrations/000077_license_ids.up.sql renamed to ‎coderd/database/migrations/000079_license_ids.up.sql b/‎coderd/database/migrations/000077_license_ids.up.sql renamed to ‎coderd/database/migrations/000079_license_ids.up.sql
diff --git a/‎coderd/database/queries.sql.go
+4-4 b/‎coderd/database/queries.sql.go
+4-4
diff --git a/‎coderd/database/queries/provisionerjoblogs.sql
+1-1 b/‎coderd/database/queries/provisionerjoblogs.sql
+1-1
diff --git a/‎coderd/database/queries/provisionerjobs.sql
+3-3 b/‎coderd/database/queries/provisionerjobs.sql
+3-3
diff --git a/‎site/src/pages/GroupsPage/SettingsGroupPageView.tsx
+1-1 b/‎site/src/pages/GroupsPage/SettingsGroupPageView.tsx
+1-1
@@ -0,0 +1 @@
+DROP INDEX provisioner_job_logs_id_job_id_idx;
@@ -0,0 +1 @@
+CREATE INDEX provisioner_job_logs_id_job_id_idx ON provisioner_job_logs USING btree (job_id, id ASC);
@@ -0,0 +1 @@
+DROP INDEX workspace_agents_resource_id_idx;
@@ -0,0 +1 @@
+CREATE INDEX workspace_agents_resource_id_idx ON workspace_agents USING btree (resource_id);
@@ -8,7 +8,7 @@ WHERE
 	AND (
 		id > @created_after
 		OR id < @created_before
-	) ORDER BY id;
+	) ORDER BY id ASC;
 
 -- name: InsertProvisionerJobLogs :many
 INSERT INTO
 
@@ -23,9 +23,9 @@ WHERE
 			AND nested.completed_at IS NULL
 			AND nested.provisioner = ANY(@types :: provisioner_type [ ])
 		ORDER BY
-			nested.created_at FOR
-		UPDATE
-			SKIP LOCKED
+			nested.created_at
+		FOR UPDATE
+		SKIP LOCKED
 		LIMIT
 			1
 	) RETURNING *;
 
@@ -27,7 +27,7 @@ type FormData = {
 
 const validationSchema = Yup.object({
   name: nameValidator("Name"),
-  quota_allowance: Yup.number().required().positive().integer(),
+  quota_allowance: Yup.number().required().min(0).integer(),
 })
 
 const UpdateGroupForm: React.FC<{
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+DROP INDEX provisioner_job_logs_id_job_id_idx;`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+CREATE INDEX provisioner_job_logs_id_job_id_idx ON provisioner_job_logs USING btree (job_id, id ASC);`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+DROP INDEX workspace_agents_resource_id_idx;`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+CREATE INDEX workspace_agents_resource_id_idx ON workspace_agents USING btree (resource_id);`