From 3fad98f9b03c73964e8d099742555b0406a362ad Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 7 Aug 2006 17:29:41 +0000 Subject: [PATCH] adding migration closed dates git-svn-id: svn://svn.open-ils.org/ILS/trunk@5335 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Evergreen/src/extras/import/import_legacy_closings.pl | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/Evergreen/src/extras/import/import_legacy_closings.pl b/Evergreen/src/extras/import/import_legacy_closings.pl index a0957d2aa9..5ea37533e3 100755 --- a/Evergreen/src/extras/import/import_legacy_closings.pl +++ b/Evergreen/src/extras/import/import_legacy_closings.pl @@ -33,5 +33,12 @@ CREATE TEMP VIEW legacy_closing_view AS INSERT INTO actor.org_unit_closed (org_unit, close_start, close_end, reason) SELECT * from legacy_closing_view; +INSERT INTO actor.org_unit_closed (org_unit, close_start, close_end, reason) + SELECT au.id AS org_unit, + '2006-09-02' AS close_start, + '2006-09-05'::DATE - '1 second'::INTERVAL AS close_end, + 'Evergreen Migration' AS reason + FROM actor.org_unit au; + SQL -- 2.43.2