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
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')
|