X-Git-Url: https://git.exim.org/buildfarm-server.git/blobdiff_plain/a19a7c8ebfe9459a0d5521c5ba3366658b24989f..5e30c08ac3884e9699ed2c6339796f44083690bf:/schema/missing.sql diff --git a/schema/missing.sql b/schema/missing.sql index 23adcc4..e73998d 100644 --- a/schema/missing.sql +++ b/schema/missing.sql @@ -3,7 +3,7 @@ -- CREATE VIEW build_status_recent_500 AS - SELECT bs.sysname, bs.status, bs.snapshot, bs.stage, bs.conf_sum, bs.branch, bs.changed_this_run, bs.changed_since_success, bs.log_archive_filenames, bs.build_flags, bs.report_time, bs.log FROM build_status AS bs WHERE ((build_status.snapshot + '3 mons'::interval) > ('now'::text)::timestamp(6) with time zone); + SELECT bs.sysname, bs.status, bs.snapshot, bs.stage, bs.conf_sum, bs.branch, bs.changed_this_run, bs.changed_since_success, bs.log_archive_filenames, bs.build_flags, bs.report_time, bs.log FROM build_status AS bs WHERE ((bs.snapshot + '3 mons'::interval) > ('now'::text)::timestamp(6) with time zone); ALTER TABLE public.build_status_recent_500 OWNER TO eximbuild;