schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/022-web_customer.sql
| 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
New commits:
commit 07f6c961ab258ba600ed7d5100b070c8dd6cdae1
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Mon May 28 16:42:51 2012 +0200
Disable web_customer_mod_trig while updating web_customer, so that modified does not
get modified.
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/022-web_customer.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/022-web_customer.sql
index e8a6e85..02f37f8 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/022-web_customer.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/022-web_customer.sql
@@ -1,5 +1,5 @@
--
--- Copyright (c) 2008--2010 Red Hat, Inc.
+-- Copyright (c) 2008--2012 Red Hat, Inc.
--
-- This software is licensed to you under the GNU General Public License,
-- version 2 (GPLv2). There is NO WARRANTY for this software, express or
@@ -15,11 +15,13 @@
--
--
+alter trigger web_customer_mod_trig disable;
alter table web_customer add
staging_content_enabled CHAR(1)
DEFAULT ('N') NOT NULL
CONSTRAINT web_customer_stage_content_chk
CHECK (staging_content_enabled in ( 'Y' , 'N' ));
+alter trigger web_customer_mod_trig enable;
alter table web_customer drop column oracle_customer_id;
alter table web_customer drop column oracle_customer_number;
Show replies by date