schema/spacewalk/upgrade/spacewalk-schema-0.3-to-spacewalk-schema-0.4/139-rhnKickstartableTrees.sql
| 2 +
schema/spacewalk/upgrade/spacewalk-schema-0.3-to-spacewalk-schema-0.4/156-rhnPackage-compat-number.sql
| 2 +
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-2-rhnPackage-data.sql
| 6 +++++
schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-2-rhnKSTreeFile-data.sql
| 6 +++++
schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-1.0/006-rhnKSInstallType.sql
| 12 +++++-----
5 files changed, 23 insertions(+), 5 deletions(-)
New commits:
commit de6ba4d02405aee3b047f7a7a4d59d44111c6882
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Wed Dec 1 14:23:12 2010 +0100
650129 - don't change last_modified values during schema upgrade
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.3-to-spacewalk-schema-0.4/139-rhnKickstartableTrees.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.3-to-spacewalk-schema-0.4/139-rhnKickstartableTrees.sql
index c5ec44c..44a5c5a 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.3-to-spacewalk-schema-0.4/139-rhnKickstartableTrees.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.3-to-spacewalk-schema-0.4/139-rhnKickstartableTrees.sql
@@ -16,7 +16,9 @@
-- $Id$
--
+alter trigger rhn_kstree_mod_trig disable;
update rhnKickstartableTree set boot_image='spacewalk-koan';
+alter trigger rhn_kstree_mod_trig enable;
ALTER TABLE rhnKickstartableTree
MODIFY( boot_image varchar2(128) default('spacewalk-koan'));
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.3-to-spacewalk-schema-0.4/156-rhnPackage-compat-number.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.3-to-spacewalk-schema-0.4/156-rhnPackage-compat-number.sql
index 3cdd093..f1341f1 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.3-to-spacewalk-schema-0.4/156-rhnPackage-compat-number.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.3-to-spacewalk-schema-0.4/156-rhnPackage-compat-number.sql
@@ -16,8 +16,10 @@
-- $Id$
--
+alter trigger rhn_package_mod_trig disable;
alter TABLE rhnPackage add (compat_new number(1) default 0);
update rhnPackage set compat_new = compat;
+alter trigger rhn_package_mod_trig enable;
alter TABLE rhnPackage drop column compat;
alter TABLE rhnPackage rename column compat_new to compat;
show errors
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-2-rhnPackage-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-2-rhnPackage-data.sql
index 0c7d115..f93e9ed 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-2-rhnPackage-data.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/011-2-rhnPackage-data.sql
@@ -1,3 +1,7 @@
+-- 650129: we need to disable the trigger to prevent it from
+-- automatically updating rhnPackage.last_modified values
+alter trigger rhn_package_mod_trig disable;
+
declare
md5_id number;
begin
@@ -24,3 +28,5 @@ begin
end;
/
+-- enable the trigger again
+alter trigger rhn_package_mod_trig enable;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-2-rhnKSTreeFile-data.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-2-rhnKSTreeFile-data.sql
index 279d08a..385a10d 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-2-rhnKSTreeFile-data.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.7-to-spacewalk-schema-0.8/015-2-rhnKSTreeFile-data.sql
@@ -1,3 +1,7 @@
+-- 650129: we need to disable the trigger here to prevent it from
+-- automatically updating rhnKSTreeFile.last_modified values
+alter trigger rhn_kstreefile_mod_trig disable;
+
declare
md5_id number;
begin
@@ -24,3 +28,5 @@ begin
end;
/
+-- we need to enable the trigger again
+alter trigger rhn_kstreefile_mod_trig enable;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-1.0/006-rhnKSInstallType.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-1.0/006-rhnKSInstallType.sql
index c5130d3..1377c8a 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-1.0/006-rhnKSInstallType.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.8-to-spacewalk-schema-1.0/006-rhnKSInstallType.sql
@@ -1,13 +1,15 @@
insert into rhnKSInstallType (id, label, name) values (rhn_ksinstalltype_id_seq.nextval,
'fedora', 'Fedora');
+-- 650129: we need to disable the trigger to prevent it from automatically
+-- updating rhnKickstartableTree.last_modified values
+alter trigger rhn_kstree_mod_trig disable;
+
update rhnKickstartableTree K set K.INSTALL_TYPE = (select id from rhnKSInstallType where
label = 'fedora') where K.INSTALL_TYPE in (select id from rhnKSInstallType where
label like '%fedora%');
+-- we need to enable the trigger again
+alter trigger rhn_kstree_mod_trig enable;
+
delete from rhnKSInstallType where label = 'fedora_8';
delete from rhnKSInstallType where label = 'fedora_9';
delete from rhnKSInstallType where label = 'fedora_10';
-
-
-
-
-
Show replies by date