lasdf1234 commented on code in PR #10969: URL: https://github.com/apache/gravitino/pull/10969#discussion_r3208465561
########## scripts/postgresql/schema-1.3.0-postgresql.sql: ########## @@ -427,6 +427,68 @@ COMMENT ON COLUMN group_role_rel.current_version IS 'relation current version'; COMMENT ON COLUMN group_role_rel.last_version IS 'relation last version'; COMMENT ON COLUMN group_role_rel.deleted_at IS 'relation deleted at'; +CREATE TABLE IF NOT EXISTS idp_user_meta ( + user_id BIGINT NOT NULL, + user_name VARCHAR(128) NOT NULL, + password_hash VARCHAR(1024) NOT NULL, + audit_info TEXT NOT NULL, + current_version INT NOT NULL DEFAULT 1, + last_version INT NOT NULL DEFAULT 1, + deleted_at BIGINT NOT NULL DEFAULT 0, + PRIMARY KEY (user_id), + UNIQUE (user_name, deleted_at) +); +COMMENT ON TABLE idp_user_meta IS 'local IdP user metadata'; + +COMMENT ON COLUMN idp_user_meta.user_id IS 'idp user id'; +COMMENT ON COLUMN idp_user_meta.user_name IS 'idp username'; +COMMENT ON COLUMN idp_user_meta.password_hash IS 'idp user password hash'; +COMMENT ON COLUMN idp_user_meta.audit_info IS 'idp user audit info'; +COMMENT ON COLUMN idp_user_meta.current_version IS 'idp user current version'; +COMMENT ON COLUMN idp_user_meta.last_version IS 'idp user last version'; +COMMENT ON COLUMN idp_user_meta.deleted_at IS 'idp user deleted at'; + +CREATE TABLE IF NOT EXISTS idp_group_meta ( + group_id BIGINT NOT NULL, + group_name VARCHAR(128) NOT NULL, + audit_info TEXT NOT NULL, + current_version INT NOT NULL DEFAULT 1, + last_version INT NOT NULL DEFAULT 1, + deleted_at BIGINT NOT NULL DEFAULT 0, + PRIMARY KEY (group_id), + UNIQUE (group_name, deleted_at) +); +COMMENT ON TABLE idp_group_meta IS 'local IdP group metadata'; + +COMMENT ON COLUMN idp_group_meta.group_id IS 'idp group id'; +COMMENT ON COLUMN idp_group_meta.group_name IS 'idp group name'; +COMMENT ON COLUMN idp_group_meta.audit_info IS 'idp group audit info'; +COMMENT ON COLUMN idp_group_meta.current_version IS 'idp group current version'; +COMMENT ON COLUMN idp_group_meta.last_version IS 'idp group last version'; +COMMENT ON COLUMN idp_group_meta.deleted_at IS 'idp group deleted at'; + +CREATE TABLE IF NOT EXISTS idp_group_user_rel ( + id BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, + group_id BIGINT NOT NULL, + user_id BIGINT NOT NULL, + audit_info TEXT NOT NULL, + current_version INT NOT NULL DEFAULT 1, + last_version INT NOT NULL DEFAULT 1, + deleted_at BIGINT NOT NULL DEFAULT 0, + PRIMARY KEY (id), + UNIQUE (group_id, user_id, deleted_at) +); Review Comment: resolved ########## scripts/postgresql/upgrade-1.2.0-to-1.3.0-postgresql.sql: ########## @@ -91,3 +91,65 @@ COMMENT ON COLUMN view_version_info.default_schema IS 'default schema for view S COMMENT ON COLUMN view_version_info.representations IS 'view representations (JSON array)'; COMMENT ON COLUMN view_version_info.audit_info IS 'view version audit info'; COMMENT ON COLUMN view_version_info.deleted_at IS 'view version deleted at'; + +CREATE TABLE IF NOT EXISTS idp_user_meta ( + user_id BIGINT NOT NULL, + user_name VARCHAR(128) NOT NULL, + password_hash VARCHAR(1024) NOT NULL, + audit_info TEXT NOT NULL, + current_version INT NOT NULL DEFAULT 1, + last_version INT NOT NULL DEFAULT 1, + deleted_at BIGINT NOT NULL DEFAULT 0, + PRIMARY KEY (user_id), + UNIQUE (user_name, deleted_at) +); +COMMENT ON TABLE idp_user_meta IS 'local IdP user metadata'; + +COMMENT ON COLUMN idp_user_meta.user_id IS 'idp user id'; +COMMENT ON COLUMN idp_user_meta.user_name IS 'idp username'; +COMMENT ON COLUMN idp_user_meta.password_hash IS 'idp user password hash'; +COMMENT ON COLUMN idp_user_meta.audit_info IS 'idp user audit info'; +COMMENT ON COLUMN idp_user_meta.current_version IS 'idp user current version'; +COMMENT ON COLUMN idp_user_meta.last_version IS 'idp user last version'; +COMMENT ON COLUMN idp_user_meta.deleted_at IS 'idp user deleted at'; + +CREATE TABLE IF NOT EXISTS idp_group_meta ( + group_id BIGINT NOT NULL, + group_name VARCHAR(128) NOT NULL, + audit_info TEXT NOT NULL, + current_version INT NOT NULL DEFAULT 1, + last_version INT NOT NULL DEFAULT 1, + deleted_at BIGINT NOT NULL DEFAULT 0, + PRIMARY KEY (group_id), + UNIQUE (group_name, deleted_at) +); +COMMENT ON TABLE idp_group_meta IS 'local IdP group metadata'; + +COMMENT ON COLUMN idp_group_meta.group_id IS 'idp group id'; +COMMENT ON COLUMN idp_group_meta.group_name IS 'idp group name'; +COMMENT ON COLUMN idp_group_meta.audit_info IS 'idp group audit info'; +COMMENT ON COLUMN idp_group_meta.current_version IS 'idp group current version'; +COMMENT ON COLUMN idp_group_meta.last_version IS 'idp group last version'; +COMMENT ON COLUMN idp_group_meta.deleted_at IS 'idp group deleted at'; + +CREATE TABLE IF NOT EXISTS idp_group_user_rel ( + id BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, + group_id BIGINT NOT NULL, + user_id BIGINT NOT NULL, + audit_info TEXT NOT NULL, + current_version INT NOT NULL DEFAULT 1, + last_version INT NOT NULL DEFAULT 1, + deleted_at BIGINT NOT NULL DEFAULT 0, + PRIMARY KEY (id), + UNIQUE (group_id, user_id, deleted_at) +); +CREATE INDEX IF NOT EXISTS idp_group_user_rel_idx_user_id ON idp_group_user_rel (user_id); Review Comment: resolved -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
