• Home
• org.openurp.platform
• openurp-platform-portal
• 0.5.25
• source code
• 0.2.28_0.2.29.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.

evolutions.0.2.28_0.2.29.sql Maven / Gradle / Ivy

delete from session.session_infoes;
alter table session.session_infoes rename tti_minutes  to tti_seconds;

CREATE OR REPLACE FUNCTION add_seconds(timestamp without time zone, integer)
RETURNS timestamp  without time zone
    LANGUAGE 'plpgsql'
    COST 100
    VOLATILE
AS $BODY$
begin
  return $1 +  $2 * (interval '1' second);
end;
$BODY$;

drop FUNCTION add_minutes;