change sql to use is_default vs first org

Emyrk · Emyrk · commit 01fb30c8e914 · 2024-03-05T08:29:59.000-06:00
diff --git a/coderd/coderd.go b/coderd/coderd.go
@@ -1239,7 +1239,7 @@ func (api *API) CreateInMemoryProvisionerDaemon(dialCtx context.Context, name st
 		}
 	}()
 
-	// All in memory provisioners will be apart of the default org for now.
+	// All in memory provisioners will be part of the default org for now.
 	//nolint:gocritic // in-memory provisioners are owned by system
 	defaultOrg, err := api.Database.GetDefaultOrganization(dbauthz.AsSystemRestricted(dialCtx))
 	if err != nil {
diff --git a/coderd/database/migrations/000198_org_provisioners.up.sql b/coderd/database/migrations/000198_org_provisioners.up.sql
@@ -8,7 +8,7 @@ UPDATE
 	provisioner_daemons
 SET
 	-- Default to the first org
-	organization_id = (SELECT id FROM organizations ORDER BY organizations.created_at ASC LIMIT 1 );
+	organization_id = (SELECT id FROM organizations WHERE is_default = true LIMIT 1 );
 
 ALTER TABLE provisioner_daemons
 	ALTER COLUMN organization_id SET NOT NULL;

Original file line number	Diff line number	Diff line change
`@@ -1239,7 +1239,7 @@ func (api *API) CreateInMemoryProvisionerDaemon(dialCtx context.Context, name st`
`1239`	`1239`	`}`
`1240`	`1240`	`}()`
`1241`	`1241`
`1242`		`- // All in memory provisioners will be apart of the default org for now.`
	`1242`	`+ // All in memory provisioners will be part of the default org for now.`
`1243`	`1243`	`//nolint:gocritic // in-memory provisioners are owned by system`
`1244`	`1244`	`defaultOrg, err := api.Database.GetDefaultOrganization(dbauthz.AsSystemRestricted(dialCtx))`
`1245`	`1245`	`if err != nil {`