(paimon-webui) branch main updated: [Improvement] Support username field of user table unique key (#393)

[nicholasjiang]

This is an automated email from the ASF dual-hosted git repository.

nicholasjiang pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/paimon-webui.git


The following commit(s) were added to refs/heads/main by this push:
     new f3832e7a [Improvement] Support username field of user table unique key 
(#393)
f3832e7a is described below

commit f3832e7af13618240b31f1243877d730a1b83474
Author: 风向决定发型 <617401...@qq.com>
AuthorDate: Sat Jun 15 20:30:43 2024 +0800

    [Improvement] Support username field of user table unique key (#393)
---
 scripts/sql/paimon-mysql.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/scripts/sql/paimon-mysql.sql b/scripts/sql/paimon-mysql.sql
index 1fd9ce49..af47f37a 100644
--- a/scripts/sql/paimon-mysql.sql
+++ b/scripts/sql/paimon-mysql.sql
@@ -27,7 +27,8 @@ CREATE TABLE if not exists `user`
     `enabled`     tinyint(1)   NOT NULL DEFAULT 1 COMMENT 'is enable',
     `is_delete`   tinyint(1)   NOT NULL DEFAULT 0 COMMENT 'is delete',
     `create_time` datetime(0)  NULL     DEFAULT CURRENT_TIMESTAMP COMMENT 
'create time',
-    `update_time` datetime(0)  NULL     DEFAULT CURRENT_TIMESTAMP COMMENT 
'update time'
+    `update_time` datetime(0)  NULL     DEFAULT CURRENT_TIMESTAMP COMMENT 
'update time',
+    UNIQUE KEY `username` (`username`)
     ) ENGINE = InnoDB DEFAULT CHARSET=utf8;
 
 DROP TABLE IF EXISTS `tenant`;