From 0f64750bb9cb57d1a44f1004ed84d30f8cd5c171 Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Sat, 10 Mar 2007 18:23:51 +0000
Subject: [PATCH] auditor schema fixups for the recent logical split

git-svn-id: svn://svn.open-ils.org/ILS/trunk@7051 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/sql/Pg/900.audit-functions.sql | 6 +++---
 Open-ILS/src/sql/Pg/901.audit-tables.sql    | 2 --
 2 files changed, 3 insertions(+), 5 deletions(-)

diff --git a/Open-ILS/src/sql/Pg/900.audit-functions.sql b/Open-ILS/src/sql/Pg/900.audit-functions.sql
index 07e64d5c39..802516fe90 100644
--- a/Open-ILS/src/sql/Pg/900.audit-functions.sql
+++ b/Open-ILS/src/sql/Pg/900.audit-functions.sql
@@ -8,7 +8,7 @@ CREATE SCHEMA auditor;
 CREATE FUNCTION auditor.create_auditor ( sch TEXT, tbl TEXT ) RETURNS BOOL AS $creator$
 BEGIN
 	EXECUTE $$
-			CREATE SEQUENCE auditior.$$ || sch || $$_$$ || tbl || $$_pkey_seq;
+			CREATE SEQUENCE auditor.$$ || sch || $$_$$ || tbl || $$_pkey_seq;
 	$$;
 
 	EXECUTE $$
@@ -25,7 +25,7 @@ BEGIN
 			RETURNS TRIGGER AS $func$
 			BEGIN
 				INSERT INTO auditor.$$ || sch || $$_$$ || tbl || $$_history
-					SELECT	nextval('auditior.$$ || sch || $$_$$ || tbl || $$_pkey_seq'),
+					SELECT	nextval('auditor.$$ || sch || $$_$$ || tbl || $$_pkey_seq'),
 						now(),
 						SUBSTR(TG_OP,1,1),
 						OLD.*;
@@ -42,7 +42,7 @@ BEGIN
 
 	EXECUTE $$
 			CREATE VIEW auditor.$$ || sch || $$_$$ || tbl || $$_lifecycle AS
-				SELECT	now() as audit_time, '-' as audit_action, *
+				SELECT	-1, now() as audit_time, '-' as audit_action, *
 				  FROM	$$ || sch || $$.$$ || tbl || $$
 				  	UNION ALL
 				SELECT	*
diff --git a/Open-ILS/src/sql/Pg/901.audit-tables.sql b/Open-ILS/src/sql/Pg/901.audit-tables.sql
index bb8ea26294..d0cef3fd90 100644
--- a/Open-ILS/src/sql/Pg/901.audit-tables.sql
+++ b/Open-ILS/src/sql/Pg/901.audit-tables.sql
@@ -1,5 +1,3 @@
-DROP SCHEMA auditor CASCADE;
-
 BEGIN;
 
 SELECT auditor.create_auditor ( 'actor', 'usr' );
-- 
2.11.0