You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 

36 lines
902 B

create table t_user
(
id serial not null
constraint t_user_pk
primary key,
name varchar(255),
username varchar(255) not null,
password varchar(255) not null
);
comment on table t_user is '用户表';
comment on column t_user.id is '唯一标识';
comment on column t_user.name is '姓名';
comment on column t_user.username is '用户名';
comment on column t_user.password is '密码';
create unique index t_user_id_uindex
on t_user (id);
create table t_user_token
(
token varchar(64) not null
constraint user_token_pk
primary key,
user_info jsonb not null,
expired timestamp(6) with time zone not null
);
INSERT INTO public.t_user (id, name, username, password) VALUES (DEFAULT, '超级管理员', 'SuperAdmin', 'e10adc3949ba59abbe56e057f20f883e')