coder
diff --git a/‎coderd/database/dump.sql
+4-1 b/‎coderd/database/dump.sql
+4-1
diff --git a/‎coderd/database/migrations/000175_add_user_theme_preference.down.sql
+1 b/‎coderd/database/migrations/000175_add_user_theme_preference.down.sql
+1
diff --git a/‎coderd/database/migrations/000175_add_user_theme_preference.up.sql
+3 b/‎coderd/database/migrations/000175_add_user_theme_preference.up.sql
+3
diff --git a/‎coderd/database/migrations/create_migration.sh
+4-4 b/‎coderd/database/migrations/create_migration.sh
+4-4
diff --git a/‎coderd/database/modelmethods.go
+13-12 b/‎coderd/database/modelmethods.go
+13-12
diff --git a/‎coderd/database/modelqueries.go
+1 b/‎coderd/database/modelqueries.go
+1
diff --git a/‎coderd/database/models.go
+2 b/‎coderd/database/models.go
+2
diff --git a/‎coderd/database/queries.sql.go
+25-12 b/‎coderd/database/queries.sql.go
+25-12
@@ -0,0 +1 @@
+ALTER TABLE users DROP COLUMN "theme_preference";
@@ -0,0 +1,3 @@
+ALTER TABLE users ADD COLUMN "theme_preference" text NOT NULL DEFAULT '';
+
+COMMENT ON COLUMN "users"."theme_preference" IS '"" can be interpreted as "the user does not care", falling back to the default theme';
@@ -1,9 +1,9 @@
 #!/usr/bin/env bash
 
 # Usage:
-# ./create_migration name of migration
-# ./create_migration "name of migration"
-# ./create_migration name_of_migration
+# ./create_migration.sh name of migration
+# ./create_migration.sh "name of migration"
+# ./create_migration.sh name_of_migration
 
 set -euo pipefail
 
@@ -27,7 +27,7 @@ CREATE TYPE new_logintype AS ENUM (
 
 ALTER TABLE users
 	ALTER COLUMN login_type DROP DEFAULT, -- if the column has a default, it must be dropped first
-	ALTER COLUMN login_type TYPE new_logintype USING (login_type::text::new_logintype), -- converts the old enum until the new enum using text as an intermediary
+	ALTER COLUMN login_type TYPE new_logintype USING (login_type::text::new_logintype), -- converts the old enum into the new enum using text as an intermediary
 	ALTER COLUMN login_type SET DEFAULT 'password'::new_logintype; -- re-add the default using the new enum
 
 DROP TYPE login_type;
 
@@ -332,18 +332,19 @@ func ConvertUserRows(rows []GetUsersRow) []User {
 	users := make([]User, len(rows))
 	for i, r := range rows {
 		users[i] = User{
-			ID:             r.ID,
-			Email:          r.Email,
-			Username:       r.Username,
-			HashedPassword: r.HashedPassword,
-			CreatedAt:      r.CreatedAt,
-			UpdatedAt:      r.UpdatedAt,
-			Status:         r.Status,
-			RBACRoles:      r.RBACRoles,
-			LoginType:      r.LoginType,
-			AvatarURL:      r.AvatarURL,
-			Deleted:        r.Deleted,
-			LastSeenAt:     r.LastSeenAt,
+			ID:              r.ID,
+			Email:           r.Email,
+			Username:        r.Username,
+			HashedPassword:  r.HashedPassword,
+			CreatedAt:       r.CreatedAt,
+			UpdatedAt:       r.UpdatedAt,
+			Status:          r.Status,
+			RBACRoles:       r.RBACRoles,
+			LoginType:       r.LoginType,
+			AvatarURL:       r.AvatarURL,
+			Deleted:         r.Deleted,
+			LastSeenAt:      r.LastSeenAt,
+			ThemePreference: r.ThemePreference,
 		}
 	}
 
 
@@ -316,6 +316,7 @@ func (q *sqlQuerier) GetAuthorizedUsers(ctx context.Context, arg GetUsersParams,
 			&i.Deleted,
 			&i.LastSeenAt,
 			&i.QuietHoursSchedule,
+			&i.ThemePreference,
 			&i.Count,
 		); err != nil {
 			return nil, err
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+ALTER TABLE users DROP COLUMN "theme_preference";`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+ALTER TABLE users ADD COLUMN "theme_preference" text NOT NULL DEFAULT '';`
	`2`	`+`
	`3`	`+COMMENT ON COLUMN "users"."theme_preference" IS '"" can be interpreted as "the user does not care", falling back to the default theme';`