Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitf694cfc

Browse files
committed
down
1 parent8036b87 commitf694cfc

File tree

1 file changed

+4
-4
lines changed

1 file changed

+4
-4
lines changed

‎coderd/database/migrations/000293_user_configs.down.sql‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -3,11 +3,11 @@ ALTER TABLE users ADD COLUMN IF NOT EXISTS
33
theme_preferencetext DEFAULT''::textNOT NULL;
44

55
-- Copy "theme_preference" back to "users"
6-
UPDATE users (theme_preference)
7-
SELECT value
6+
UPDATE users
7+
SET theme_preference= (SELECT value
88
FROM user_configs
9-
WHEREusers.id=user_configs.user_id
10-
ANDuser_configs.key='theme_preference';
9+
WHEREuser_configs.user_id=users.id
10+
ANDuser_configs.key='theme_preference');
1111

1212
-- Drop the "user_configs" table.
1313
DROPTABLE user_configs;

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp