diff options
| author | zhangshuai <[email protected]> | 2023-08-31 15:06:22 +0800 |
|---|---|---|
| committer | zhangshuai <[email protected]> | 2023-08-31 15:06:22 +0800 |
| commit | db7bd2b77519fc50ea426882491518074738e109 (patch) | |
| tree | 2a45ba5152a2a97cd2c1537fda71a300b8d11bc1 | |
| parent | 86f3f056ef4e39f97bb549545247e6e665b52359 (diff) | |
fix: 用户偏好表添加索引
| -rw-r--r-- | nz-admin/src/main/resources/db/V2023.08.10.2__user preference add index.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/nz-admin/src/main/resources/db/V2023.08.10.2__user preference add index.sql b/nz-admin/src/main/resources/db/V2023.08.10.2__user preference add index.sql new file mode 100644 index 00000000..4971394b --- /dev/null +++ b/nz-admin/src/main/resources/db/V2023.08.10.2__user preference add index.sql @@ -0,0 +1,8 @@ +/** + * + * user preference add index + * + **/ + +CREATE INDEX IF NOT EXISTS idx_uid ON sys_user_preference(`uid`) USING BTREE; +CREATE INDEX IF NOT EXISTS idx_pref_key ON sys_user_preference(`pref_key`) USING BTREE;
\ No newline at end of file |