drop table wps_files;
create table wps_files(
                          id varchar(20) not null  ,
                          name varchar(1000) not null,
                          url varchar(1000) not null,
                          size bigint not null,
                          createTime datetime not null,
                          modifyTime datetime null,
                          version int not null,
                          creatorId varchar(20) not null,
                          modifierId varchar(20) not null
);
alter table wps_files
    add constraint pk_wps_file primary key (id,version);
 drop table wps_users;
create table wps_users(
                          id bigint  not null  primary key ,
                          nickname varchar(20) not null,
                          avatar varchar(20) not null
);

alter table wps_files add env varchar(20) null;
alter table wps_files add encrypted boolean not null default false;
alter table wps_files add permissionOption varchar(500) not null default '{}';