AI_Engineering/ais_knowledge/knowledge/sql/user.sql

-- ----------------------------
-- Sequence structure for system_user_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "system_user_seq";
CREATE SEQUENCE "system_user_seq"
    INCREMENT 1
MAXVALUE 9223372036854775807
CACHE 1;

-- ----------------------------
-- Table structure for system_users
-- ----------------------------
DROP TABLE IF EXISTS "system_users";
CREATE TABLE "system_users"
(
    "id"          int8                                        NOT NULL,
    "username"    varchar(30) COLLATE "pg_catalog"."default"  NOT NULL,
    "password"    varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
    "nickname"    varchar(30) COLLATE "pg_catalog"."default"  NOT NULL,
    "remark"      varchar(500) COLLATE "pg_catalog"."default",
    "dept_id"     int8,
    "post_ids"    varchar(255) COLLATE "pg_catalog"."default",
    "email"       varchar(50) COLLATE "pg_catalog"."default",
    "mobile"      varchar(11) COLLATE "pg_catalog"."default",
    "sex"         int2,
    "avatar"      varchar(100) COLLATE "pg_catalog"."default",
    "status"      int2                                        NOT NULL,
    "login_ip"    varchar(50) COLLATE "pg_catalog"."default",
    "login_date"  timestamp(6),
    "creator"     varchar(64) COLLATE "pg_catalog"."default",
    "create_time" timestamp(6)                                NOT NULL,
    "updater"     varchar(64) COLLATE "pg_catalog"."default",
    "update_time" timestamp(6)                                NOT NULL,
    "deleted"     int2                                        NOT NULL DEFAULT 0,
    "tenant_id"   int8                                        NOT NULL DEFAULT 0
)
;
COMMENT
ON COLUMN "system_users"."id" IS '用户ID';
COMMENT
ON COLUMN "system_users"."username" IS '用户账号';
COMMENT
ON COLUMN "system_users"."password" IS '密码';
COMMENT
ON COLUMN "system_users"."nickname" IS '用户昵称';
COMMENT
ON COLUMN "system_users"."remark" IS '备注';
COMMENT
ON COLUMN "system_users"."dept_id" IS '部门ID';
COMMENT
ON COLUMN "system_users"."post_ids" IS '岗位编号数组';
COMMENT
ON COLUMN "system_users"."email" IS '用户邮箱';
COMMENT
ON COLUMN "system_users"."mobile" IS '手机号码';
COMMENT
ON COLUMN "system_users"."sex" IS '用户性别';
COMMENT
ON COLUMN "system_users"."avatar" IS '头像地址';
COMMENT
ON COLUMN "system_users"."status" IS '帐号状态（0正常 1停用）';
COMMENT
ON COLUMN "system_users"."login_ip" IS '最后登录IP';
COMMENT
ON COLUMN "system_users"."login_date" IS '最后登录时间';
COMMENT
ON COLUMN "system_users"."creator" IS '创建者';
COMMENT
ON COLUMN "system_users"."create_time" IS '创建时间';
COMMENT
ON COLUMN "system_users"."updater" IS '更新者';
COMMENT
ON COLUMN "system_users"."update_time" IS '更新时间';
COMMENT
ON COLUMN "system_users"."deleted" IS '是否删除';
COMMENT
ON COLUMN "system_users"."tenant_id" IS '租户编号';
COMMENT
ON TABLE "system_users" IS '用户信息表';

-- ----------------------------
-- Records of system_users
-- ----------------------------
BEGIN;
INSERT INTO "system_users" ("id", "username", "password", "nickname", "remark", "dept_id", "post_ids", "email",
                            "mobile", "sex", "avatar", "status", "login_ip", "login_date", "creator", "create_time",
                            "updater", "update_time", "deleted", "tenant_id")
VALUES (1, 'admin', '$2a$10$0acJOIk2D25/oC87nyclE..0lzeu9DtQ/n3geP4fkun/zIVRhHJIO', '管理员', '管理员', 103, '[1]',
        '', '', 1, '', 0,
        '127.0.0.1', '2022-05-25 23:44:33.003', 'admin', '2021-01-05 17:03:47', NULL, '2022-05-25 23:44:33.003', 0, 1);
COMMIT;

-- ----------------------------
-- Sequence structure for system_login_log_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "system_login_log_seq";
CREATE SEQUENCE "system_login_log_seq"
    INCREMENT 1
MAXVALUE 9223372036854775807
CACHE 1;

-- ----------------------------
-- Table structure for system_login_log
-- ----------------------------
DROP TABLE IF EXISTS "system_login_log";
CREATE TABLE "system_login_log"
(
    "id"          int8                                        NOT NULL,
    "log_type"    int8                                        NOT NULL,
    "trace_id"    varchar(64) COLLATE "pg_catalog"."default"  NOT NULL,
    "user_id"     varchar(64) COLLATE "pg_catalog"."default"  NOT NULL,
    "user_type"   int2                                        ,
    "username"    varchar(50) COLLATE "pg_catalog"."default"  NOT NULL,
    "result"      int2                                        NOT NULL,
    "user_ip"     varchar(50) COLLATE "pg_catalog"."default"  NOT NULL,
    "user_agent"  varchar(512) COLLATE "pg_catalog"."default" NOT NULL,
    "creator"     varchar(64) COLLATE "pg_catalog"."default",
    "create_time" timestamp(6)                                NOT NULL,
    "updater"     varchar(64) COLLATE "pg_catalog"."default",
    "update_time" timestamp(6)                                NOT NULL,
    "deleted"     int2                                        NOT NULL DEFAULT 0,
    "tenant_id"   int8                                        NOT NULL DEFAULT 0
)
;
COMMENT
ON COLUMN "system_login_log"."id" IS '访问ID';
COMMENT
ON COLUMN "system_login_log"."log_type" IS '日志类型';
COMMENT
ON COLUMN "system_login_log"."trace_id" IS '链路追踪编号';
COMMENT
ON COLUMN "system_login_log"."user_id" IS '用户编号';
COMMENT
ON COLUMN "system_login_log"."user_type" IS '用户类型';
COMMENT
ON COLUMN "system_login_log"."username" IS '用户账号';
COMMENT
ON COLUMN "system_login_log"."result" IS '登陆结果';
COMMENT
ON COLUMN "system_login_log"."user_ip" IS '用户 IP';
COMMENT
ON COLUMN "system_login_log"."user_agent" IS '浏览器 UA';
COMMENT
ON COLUMN "system_login_log"."creator" IS '创建者';
COMMENT
ON COLUMN "system_login_log"."create_time" IS '创建时间';
COMMENT
ON COLUMN "system_login_log"."updater" IS '更新者';
COMMENT
ON COLUMN "system_login_log"."update_time" IS '更新时间';
COMMENT
ON COLUMN "system_login_log"."deleted" IS '是否删除';
COMMENT
ON COLUMN "system_login_log"."tenant_id" IS '租户编号';
COMMENT
ON TABLE "system_login_log" IS '系统访问记录';

-- ----------------------------
-- Sequence structure for system_operate_log_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "system_operate_log_seq";
CREATE SEQUENCE "system_operate_log_seq"
    INCREMENT 1
MAXVALUE 9223372036854775807
CACHE 1;

-- ----------------------------
-- Table structure for system_operate_log
-- ----------------------------
DROP TABLE IF EXISTS "system_operate_log";
CREATE TABLE "system_operate_log"
(
    "id"               int8                                         NOT NULL,
    "trace_id"         varchar(64) COLLATE "pg_catalog"."default"   NOT NULL,
    "user_id"          varchar(64) COLLATE "pg_catalog"."default"   NOT NULL,
    "user_type"        int2                                         NOT NULL,
    "module"           varchar(50) COLLATE "pg_catalog"."default"   NOT NULL,
    "name"             varchar(50) COLLATE "pg_catalog"."default"   NOT NULL,
    "type"             int8                                         NOT NULL,
    "content"          varchar(2000) COLLATE "pg_catalog"."default" NOT NULL DEFAULT '':: character varying,
    "exts"             varchar(512) COLLATE "pg_catalog"."default"  NOT NULL DEFAULT '':: character varying,
    "request_method"   varchar(16) COLLATE "pg_catalog"."default",
    "request_url"      varchar(255) COLLATE "pg_catalog"."default",
    "user_ip"          varchar(50) COLLATE "pg_catalog"."default",
    "user_agent"       varchar(200) COLLATE "pg_catalog"."default",
    "java_method"      varchar(512) COLLATE "pg_catalog"."default"  NOT NULL,
    "java_method_args" varchar(8000) COLLATE "pg_catalog"."default",
    "start_time"       timestamp(6)                                 NOT NULL,
    "duration"         int4                                         NOT NULL,
    "result_code"      int4                                         NOT NULL,
    "result_msg"       varchar(512) COLLATE "pg_catalog"."default",
    "result_data"      varchar(4000) COLLATE "pg_catalog"."default",
    "creator"          varchar(64) COLLATE "pg_catalog"."default",
    "create_time"      timestamp(6)                                 NOT NULL,
    "updater"          varchar(64) COLLATE "pg_catalog"."default",
    "update_time"      timestamp(6)                                 NOT NULL,
    "deleted"          int2                                         NOT NULL DEFAULT 0,
    "tenant_id"        int8                                         NOT NULL DEFAULT 0
)
;
COMMENT
ON COLUMN "system_operate_log"."id" IS '日志主键';
COMMENT
ON COLUMN "system_operate_log"."trace_id" IS '链路追踪编号';
COMMENT
ON COLUMN "system_operate_log"."user_id" IS '用户编号';
COMMENT
ON COLUMN "system_operate_log"."user_type" IS '用户类型';
COMMENT
ON COLUMN "system_operate_log"."module" IS '模块标题';
COMMENT
ON COLUMN "system_operate_log"."name" IS '操作名';
COMMENT
ON COLUMN "system_operate_log"."type" IS '操作分类';
COMMENT
ON COLUMN "system_operate_log"."content" IS '操作内容';
COMMENT
ON COLUMN "system_operate_log"."exts" IS '拓展字段';
COMMENT
ON COLUMN "system_operate_log"."request_method" IS '请求方法名';
COMMENT
ON COLUMN "system_operate_log"."request_url" IS '请求地址';
COMMENT
ON COLUMN "system_operate_log"."user_ip" IS '用户 IP';
COMMENT
ON COLUMN "system_operate_log"."user_agent" IS '浏览器 UA';
COMMENT
ON COLUMN "system_operate_log"."java_method" IS 'Java 方法名';
COMMENT
ON COLUMN "system_operate_log"."java_method_args" IS 'Java 方法的参数';
COMMENT
ON COLUMN "system_operate_log"."start_time" IS '操作时间';
COMMENT
ON COLUMN "system_operate_log"."duration" IS '执行时长';
COMMENT
ON COLUMN "system_operate_log"."result_code" IS '结果码';
COMMENT
ON COLUMN "system_operate_log"."result_msg" IS '结果提示';
COMMENT
ON COLUMN "system_operate_log"."result_data" IS '结果数据';
COMMENT
ON COLUMN "system_operate_log"."creator" IS '创建者';
COMMENT
ON COLUMN "system_operate_log"."create_time" IS '创建时间';
COMMENT
ON COLUMN "system_operate_log"."updater" IS '更新者';
COMMENT
ON COLUMN "system_operate_log"."update_time" IS '更新时间';
COMMENT
ON COLUMN "system_operate_log"."deleted" IS '是否删除';
COMMENT
ON COLUMN "system_operate_log"."tenant_id" IS '租户编号';
COMMENT
ON TABLE "system_operate_log" IS '操作日志记录';

-- ----------------------------
-- Sequence structure for system_oauth2_access_token_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "system_oauth2_access_token_seq";
CREATE SEQUENCE "system_oauth2_access_token_seq"
    INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for system_oauth2_approve_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "system_oauth2_approve_seq";
CREATE SEQUENCE "system_oauth2_approve_seq"
    INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for system_oauth2_client_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "system_oauth2_client_seq";
CREATE SEQUENCE "system_oauth2_client_seq"
    INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for system_oauth2_code_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "system_oauth2_code_seq";
CREATE SEQUENCE "system_oauth2_code_seq"
    INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for system_oauth2_refresh_token_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "system_oauth2_refresh_token_seq";
CREATE SEQUENCE "system_oauth2_refresh_token_seq"
    INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;
-- ----------------------------
-- Table structure for system_oauth2_access_token
-- ----------------------------
DROP TABLE IF EXISTS "system_oauth2_access_token";
CREATE TABLE "system_oauth2_access_token"
(
    "id"            int8                                        NOT NULL,
    "user_id"       int8                                        NOT NULL,
    "access_token"  varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "refresh_token" varchar(32) COLLATE "pg_catalog"."default"  NOT NULL,
    "user_type"     int2                                        NOT NULL,
    "client_id"     varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "expires_time"  timestamp(6)                                NOT NULL,
    "creator"       varchar(64) COLLATE "pg_catalog"."default",
    "create_time"   timestamp(6)                                NOT NULL,
    "updater"       varchar(64) COLLATE "pg_catalog"."default",
    "update_time"   timestamp(6)                                NOT NULL,
    "deleted"       int2                                        NOT NULL DEFAULT 0,
    "tenant_id"     int8                                        NOT NULL DEFAULT 0,
    "scopes"        varchar(255) COLLATE "pg_catalog"."default"          DEFAULT '':: character varying
)
;
COMMENT
ON COLUMN "system_oauth2_access_token"."id" IS '编号';
COMMENT
ON COLUMN "system_oauth2_access_token"."user_id" IS '用户编号';
COMMENT
ON COLUMN "system_oauth2_access_token"."access_token" IS '访问令牌';
COMMENT
ON COLUMN "system_oauth2_access_token"."refresh_token" IS '刷新令牌';
COMMENT
ON COLUMN "system_oauth2_access_token"."user_type" IS '用户类型';
COMMENT
ON COLUMN "system_oauth2_access_token"."client_id" IS '客户端编号';
COMMENT
ON COLUMN "system_oauth2_access_token"."expires_time" IS '过期时间';
COMMENT
ON COLUMN "system_oauth2_access_token"."creator" IS '创建者';
COMMENT
ON COLUMN "system_oauth2_access_token"."create_time" IS '创建时间';
COMMENT
ON COLUMN "system_oauth2_access_token"."updater" IS '更新者';
COMMENT
ON COLUMN "system_oauth2_access_token"."update_time" IS '更新时间';
COMMENT
ON COLUMN "system_oauth2_access_token"."deleted" IS '是否删除';
COMMENT
ON COLUMN "system_oauth2_access_token"."tenant_id" IS '租户编号';
COMMENT
ON COLUMN "system_oauth2_access_token"."scopes" IS '授权范围';
COMMENT
ON TABLE "system_oauth2_access_token" IS '刷新令牌';

-- ----------------------------
-- Records of system_oauth2_access_token
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for system_oauth2_approve
-- ----------------------------
DROP TABLE IF EXISTS "system_oauth2_approve";
CREATE TABLE "system_oauth2_approve"
(
    "id"           int8                                        NOT NULL,
    "user_id"      int8                                        NOT NULL,
    "user_type"    int2                                        NOT NULL,
    "client_id"    varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "scope"        varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "approved"     bool                                        NOT NULL,
    "expires_time" timestamp(6)                                NOT NULL,
    "creator"      varchar(64) COLLATE "pg_catalog"."default",
    "create_time"  timestamp(6)                                NOT NULL,
    "updater"      varchar(64) COLLATE "pg_catalog"."default",
    "update_time"  timestamp(6)                                NOT NULL,
    "deleted"      int2                                        NOT NULL DEFAULT 0,
    "tenant_id"    int8                                        NOT NULL DEFAULT 0
)
;
COMMENT
ON COLUMN "system_oauth2_approve"."id" IS '编号';
COMMENT
ON COLUMN "system_oauth2_approve"."user_id" IS '用户编号';
COMMENT
ON COLUMN "system_oauth2_approve"."user_type" IS '用户类型';
COMMENT
ON COLUMN "system_oauth2_approve"."client_id" IS '客户端编号';
COMMENT
ON COLUMN "system_oauth2_approve"."scope" IS '授权范围';
COMMENT
ON COLUMN "system_oauth2_approve"."approved" IS '是否接受';
COMMENT
ON COLUMN "system_oauth2_approve"."expires_time" IS '过期时间';
COMMENT
ON COLUMN "system_oauth2_approve"."creator" IS '创建者';
COMMENT
ON COLUMN "system_oauth2_approve"."create_time" IS '创建时间';
COMMENT
ON COLUMN "system_oauth2_approve"."updater" IS '更新者';
COMMENT
ON COLUMN "system_oauth2_approve"."update_time" IS '更新时间';
COMMENT
ON COLUMN "system_oauth2_approve"."deleted" IS '是否删除';
COMMENT
ON COLUMN "system_oauth2_approve"."tenant_id" IS '租户编号';
COMMENT
ON TABLE "system_oauth2_approve" IS 'OAuth2 批准表';

-- ----------------------------
-- Records of system_oauth2_approve
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for system_oauth2_client
-- ----------------------------
DROP TABLE IF EXISTS "system_oauth2_client";
CREATE TABLE "system_oauth2_client"
(
    "id"                             int8                                        NOT NULL,
    "client_id"                      varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "secret"                         varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "name"                           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "logo"                           varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "description"                    varchar(255) COLLATE "pg_catalog"."default",
    "status"                         int2                                        NOT NULL,
    "access_token_validity_seconds"  int4                                        NOT NULL,
    "refresh_token_validity_seconds" int4                                        NOT NULL,
    "redirect_uris"                  varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "authorized_grant_types"         varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "scopes"                         varchar(255) COLLATE "pg_catalog"."default",
    "authorities"                    varchar(255) COLLATE "pg_catalog"."default",
    "resource_ids"                   varchar(255) COLLATE "pg_catalog"."default",
    "additional_information"         varchar(4096) COLLATE "pg_catalog"."default",
    "creator"                        varchar(64) COLLATE "pg_catalog"."default",
    "create_time"                    timestamp(6)                                NOT NULL,
    "updater"                        varchar(64) COLLATE "pg_catalog"."default",
    "update_time"                    timestamp(6)                                NOT NULL,
    "deleted"                        int2                                        NOT NULL DEFAULT 0,
    "auto_approve_scopes"            varchar(255) COLLATE "pg_catalog"."default"
)
;
COMMENT
ON COLUMN "system_oauth2_client"."id" IS '编号';
COMMENT
ON COLUMN "system_oauth2_client"."client_id" IS '客户端编号';
COMMENT
ON COLUMN "system_oauth2_client"."secret" IS '客户端密钥';
COMMENT
ON COLUMN "system_oauth2_client"."name" IS '应用名';
COMMENT
ON COLUMN "system_oauth2_client"."logo" IS '应用图标';
COMMENT
ON COLUMN "system_oauth2_client"."description" IS '应用描述';
COMMENT
ON COLUMN "system_oauth2_client"."status" IS '状态';
COMMENT
ON COLUMN "system_oauth2_client"."access_token_validity_seconds" IS '访问令牌的有效期';
COMMENT
ON COLUMN "system_oauth2_client"."refresh_token_validity_seconds" IS '刷新令牌的有效期';
COMMENT
ON COLUMN "system_oauth2_client"."redirect_uris" IS '可重定向的 URI 地址';
COMMENT
ON COLUMN "system_oauth2_client"."authorized_grant_types" IS '授权类型';
COMMENT
ON COLUMN "system_oauth2_client"."scopes" IS '授权范围';
COMMENT
ON COLUMN "system_oauth2_client"."authorities" IS '权限';
COMMENT
ON COLUMN "system_oauth2_client"."resource_ids" IS '资源';
COMMENT
ON COLUMN "system_oauth2_client"."additional_information" IS '附加信息';
COMMENT
ON COLUMN "system_oauth2_client"."creator" IS '创建者';
COMMENT
ON COLUMN "system_oauth2_client"."create_time" IS '创建时间';
COMMENT
ON COLUMN "system_oauth2_client"."updater" IS '更新者';
COMMENT
ON COLUMN "system_oauth2_client"."update_time" IS '更新时间';
COMMENT
ON COLUMN "system_oauth2_client"."deleted" IS '是否删除';
COMMENT
ON COLUMN "system_oauth2_client"."auto_approve_scopes" IS '自动通过的授权范围';
COMMENT
ON TABLE "system_oauth2_client" IS 'OAuth2 客户端表';

-- ----------------------------
-- Records of system_oauth2_client
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for system_oauth2_code
-- ----------------------------
DROP TABLE IF EXISTS "system_oauth2_code";
CREATE TABLE "system_oauth2_code"
(
    "id"           int8                                        NOT NULL,
    "user_id"      int8                                        NOT NULL,
    "user_type"    int2                                        NOT NULL,
    "code"         varchar(32) COLLATE "pg_catalog"."default"  NOT NULL,
    "client_id"    varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "scopes"       varchar(255) COLLATE "pg_catalog"."default",
    "expires_time" timestamp(6)                                NOT NULL,
    "redirect_uri" varchar(255) COLLATE "pg_catalog"."default",
    "state"        varchar(255) COLLATE "pg_catalog"."default",
    "creator"      varchar(64) COLLATE "pg_catalog"."default",
    "create_time"  timestamp(6)                                NOT NULL,
    "updater"      varchar(64) COLLATE "pg_catalog"."default",
    "update_time"  timestamp(6)                                NOT NULL,
    "deleted"      int2                                        NOT NULL DEFAULT 0,
    "tenant_id"    int8                                        NOT NULL DEFAULT 0
)
;
COMMENT
ON COLUMN "system_oauth2_code"."id" IS '编号';
COMMENT
ON COLUMN "system_oauth2_code"."user_id" IS '用户编号';
COMMENT
ON COLUMN "system_oauth2_code"."user_type" IS '用户类型';
COMMENT
ON COLUMN "system_oauth2_code"."code" IS '授权码';
COMMENT
ON COLUMN "system_oauth2_code"."client_id" IS '客户端编号';
COMMENT
ON COLUMN "system_oauth2_code"."scopes" IS '授权范围';
COMMENT
ON COLUMN "system_oauth2_code"."expires_time" IS '过期时间';
COMMENT
ON COLUMN "system_oauth2_code"."redirect_uri" IS '可重定向的 URI 地址';
COMMENT
ON COLUMN "system_oauth2_code"."state" IS '状态';
COMMENT
ON COLUMN "system_oauth2_code"."creator" IS '创建者';
COMMENT
ON COLUMN "system_oauth2_code"."create_time" IS '创建时间';
COMMENT
ON COLUMN "system_oauth2_code"."updater" IS '更新者';
COMMENT
ON COLUMN "system_oauth2_code"."update_time" IS '更新时间';
COMMENT
ON COLUMN "system_oauth2_code"."deleted" IS '是否删除';
COMMENT
ON COLUMN "system_oauth2_code"."tenant_id" IS '租户编号';
COMMENT
ON TABLE "system_oauth2_code" IS 'OAuth2 授权码表';

-- ----------------------------
-- Records of system_oauth2_code
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for system_oauth2_refresh_token
-- ----------------------------
DROP TABLE IF EXISTS "system_oauth2_refresh_token";
CREATE TABLE "system_oauth2_refresh_token"
(
    "id"            int8                                        NOT NULL,
    "user_id"       int8                                        NOT NULL,
    "refresh_token" varchar(32) COLLATE "pg_catalog"."default"  NOT NULL,
    "user_type"     int2                                        NOT NULL,
    "client_id"     varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
    "expires_time"  timestamp(6)                                NOT NULL,
    "creator"       varchar(64) COLLATE "pg_catalog"."default",
    "create_time"   timestamp(6)                                NOT NULL,
    "updater"       varchar(64) COLLATE "pg_catalog"."default",
    "update_time"   timestamp(6)                                NOT NULL,
    "deleted"       int2                                        NOT NULL DEFAULT 0,
    "tenant_id"     int8                                        NOT NULL DEFAULT 0,
    "scopes"        varchar(255) COLLATE "pg_catalog"."default"          DEFAULT '':: character varying
)
;
COMMENT
ON COLUMN "system_oauth2_refresh_token"."id" IS '编号';
COMMENT
ON COLUMN "system_oauth2_refresh_token"."user_id" IS '用户编号';
COMMENT
ON COLUMN "system_oauth2_refresh_token"."refresh_token" IS '刷新令牌';
COMMENT
ON COLUMN "system_oauth2_refresh_token"."user_type" IS '用户类型';
COMMENT
ON COLUMN "system_oauth2_refresh_token"."client_id" IS '客户端编号';
COMMENT
ON COLUMN "system_oauth2_refresh_token"."expires_time" IS '过期时间';
COMMENT
ON COLUMN "system_oauth2_refresh_token"."creator" IS '创建者';
COMMENT
ON COLUMN "system_oauth2_refresh_token"."create_time" IS '创建时间';
COMMENT
ON COLUMN "system_oauth2_refresh_token"."updater" IS '更新者';
COMMENT
ON COLUMN "system_oauth2_refresh_token"."update_time" IS '更新时间';
COMMENT
ON COLUMN "system_oauth2_refresh_token"."deleted" IS '是否删除';
COMMENT
ON COLUMN "system_oauth2_refresh_token"."tenant_id" IS '租户编号';
COMMENT
ON COLUMN "system_oauth2_refresh_token"."scopes" IS '授权范围';
COMMENT
ON TABLE "system_oauth2_refresh_token" IS '刷新令牌';

-- ----------------------------
-- Records of system_oauth2_refresh_token
-- ----------------------------
BEGIN;
COMMIT;