X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=remove_ou_data%2F16_remove_acq.sql;fp=remove_ou_data%2F16_remove_acq.sql;h=0000000000000000000000000000000000000000;hp=d88d1b7467e953f3e379069384eb2bfea6c5354f;hb=234d6c986f42cb7c245205bb299fa2c9d204e52a;hpb=fd5875c0d61da5e43f5539e188a451649768d646 diff --git a/remove_ou_data/16_remove_acq.sql b/remove_ou_data/16_remove_acq.sql deleted file mode 100644 index d88d1b7..0000000 --- a/remove_ou_data/16_remove_acq.sql +++ /dev/null @@ -1,30 +0,0 @@ --- Copyright 2015, Equinox Software, Inc. --- Author: Galen Charlton --- --- This program is free software; you can redistribute it and/or --- modify it under the terms of the GNU General Public License --- as published by the Free Software Foundation; either version 2 --- of the License, or (at your option) any later version. --- --- This program is distributed in the hope that it will be useful, --- but WITHOUT ANY WARRANTY; without even the implied warranty of --- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the --- GNU General Public License for more details. --- --- You should have received a copy of the GNU General Public License --- along with this program; if not, write to the Free Software --- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. - -\set ou_to_del ''''EXAMPLE'''' -\set ECHO all -\timing - -BEGIN; - -DELETE FROM acq.lineitem WHERE picklist IN (SELECT id FROM acq.picklist WHERE org_unit IN - (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del) -); - -DELETE FROM acq.picklist WHERE org_unit IN (SELECT (actor.org_unit_descendants(id)).id from actor.org_unit where shortname = :ou_to_del); - -COMMIT;