adding migration closed dates
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 7 Aug 2006 17:29:41 +0000 (17:29 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 7 Aug 2006 17:29:41 +0000 (17:29 +0000)
git-svn-id: svn://svn.open-ils.org/ILS/trunk@5335 dcc99617-32d9-48b4-a31d-7c20da2025e4

Evergreen/src/extras/import/import_legacy_closings.pl

index a0957d2..5ea3753 100755 (executable)
@@ -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