From 643e4c9414845523c8d31a91fca19216bd88f821 Mon Sep 17 00:00:00 2001 From: phasefx <phasefx@dcc99617-32d9-48b4-a31d-7c20da2025e4> Date: Mon, 31 Jan 2011 18:56:09 +0000 Subject: [PATCH] use tabs & spaces consistently, bleh :) git-svn-id: svn://svn.open-ils.org/ILS/trunk@19345 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/999.functions.global.sql | 12 ++++++------ .../src/sql/Pg/upgrade/0480.schema.actor_usr_purge_data.sql | 12 ++++++------ 2 files changed, 12 insertions(+), 12 deletions(-) diff --git a/Open-ILS/src/sql/Pg/999.functions.global.sql b/Open-ILS/src/sql/Pg/999.functions.global.sql index 0b86aef278..d621300cf2 100644 --- a/Open-ILS/src/sql/Pg/999.functions.global.sql +++ b/Open-ILS/src/sql/Pg/999.functions.global.sql @@ -374,14 +374,14 @@ CREATE OR REPLACE FUNCTION actor.usr_purge_data( DECLARE suffix TEXT; renamable_row RECORD; - dest_usr INTEGER; + dest_usr INTEGER; BEGIN - IF specified_dest_usr IS NULL THEN - dest_usr := 1; -- Admin user on stock installs - ELSE - dest_usr := specified_dest_usr; - END IF; + IF specified_dest_usr IS NULL THEN + dest_usr := 1; -- Admin user on stock installs + ELSE + dest_usr := specified_dest_usr; + END IF; UPDATE actor.usr SET active = FALSE, diff --git a/Open-ILS/src/sql/Pg/upgrade/0480.schema.actor_usr_purge_data.sql b/Open-ILS/src/sql/Pg/upgrade/0480.schema.actor_usr_purge_data.sql index adea30c2ad..5e27dc58cd 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0480.schema.actor_usr_purge_data.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0480.schema.actor_usr_purge_data.sql @@ -9,14 +9,14 @@ CREATE OR REPLACE FUNCTION actor.usr_purge_data( DECLARE suffix TEXT; renamable_row RECORD; - dest_usr INTEGER; + dest_usr INTEGER; BEGIN - IF specified_dest_usr IS NULL THEN - dest_usr := 1; -- Admin user on stock installs - ELSE - dest_usr := specified_dest_usr; - END IF; + IF specified_dest_usr IS NULL THEN + dest_usr := 1; -- Admin user on stock installs + ELSE + dest_usr := specified_dest_usr; + END IF; UPDATE actor.usr SET active = FALSE, -- 2.11.0