coder
diff --git a/‎coderd/coderd.go
+1-1 b/‎coderd/coderd.go
+1-1
diff --git a/‎coderd/database/dump.sql
+4-1 b/‎coderd/database/dump.sql
+4-1
diff --git a/‎coderd/database/foreign_key_constraint.go
+1 b/‎coderd/database/foreign_key_constraint.go
+1
diff --git a/‎coderd/database/migrations/000293_user_configs.up.sql
+1-4 b/‎coderd/database/migrations/000293_user_configs.up.sql
+1-4
diff --git a/‎coderd/database/queries.sql.go
+1-1 b/‎coderd/database/queries.sql.go
+1-1
diff --git a/‎coderd/database/queries/users.sql
+1-1 b/‎coderd/database/queries/users.sql
+1-1
diff --git a/‎coderd/database/unique_constraint.go
+1-1 b/‎coderd/database/unique_constraint.go
+1-1
diff --git a/‎coderd/users.go
+1-1 b/‎coderd/users.go
+1-1
@@ -1124,7 +1124,7 @@ func New(options *Options) *API {
 						r.Put("/suspend", api.putSuspendUserAccount())
 						r.Put("/activate", api.putActivateUserAccount())
 					})
-					r.Get("/appearance", api.getUserAppearanceSettings)
+					r.Get("/appearance", api.userAppearanceSettings)
 					r.Put("/appearance", api.putUserAppearanceSettings)
 					r.Route("/password", func(r chi.Router) {
 						r.Use(httpmw.RateLimit(options.LoginRateLimit, time.Minute))
 
@@ -7,11 +7,8 @@ CREATE TABLE IF NOT EXISTS user_configs (
 	FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE
 );
 
-ALTER TABLE ONLY user_configs
-    ADD CONSTRAINT unique_key_per_user UNIQUE (user_id, key);
 
-
---
+-- Copy "theme_preference" from "users" table
 INSERT INTO user_configs (user_id, key, value)
   SELECT id, 'theme_preference', theme_preference
     FROM users
 
@@ -113,7 +113,7 @@ INSERT INTO
 VALUES
 	(@user_id, 'theme_preference', @theme_preference)
 ON CONFLICT
-	ON CONSTRAINT unique_key_per_user
+	ON CONSTRAINT user_configs_pkey
 DO UPDATE
 SET
 	value = @theme_preference
 
@@ -982,7 +982,7 @@ func (api *API) notifyUserStatusChanged(ctx context.Context, actingUserName stri
 // @Param user path string true "User ID, name, or me"
 // @Success 200 {object} codersdk.UserAppearanceSettings
 // @Router /users/{user}/appearance [get]
-func (api *API) getUserAppearanceSettings(rw http.ResponseWriter, r *http.Request) {
+func (api *API) userAppearanceSettings(rw http.ResponseWriter, r *http.Request) {
 	var (
 		ctx  = r.Context()
 		user = httpmw.UserParam(r)