• Home
• org.beangle.ems
• beangle-ems-core
• 4.10.1
• source code
• 4.9.0.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.postgresql.migrate.4.9.0.sql Maven / Gradle / Ivy

alter table ems.usr_users add  password varchar(200);
alter table ems.usr_users add  passwd_expired_on date;
alter table ems.usr_users add  enabled bool default true;
alter table ems.usr_users add  locked bool default false;
update ems.usr_users u set (password,passwd_expired_on,enabled,locked)=
(select  a.password,a.passwd_expired_on,a.enabled,a.locked from ems.usr_accounts a where a.user_id=u.id);

select * from ems.usr_users u where
(select count(*) from ems.usr_accounts a where a.user_id=u.id )>1;