schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/101-update-config-schema.sql
| 25 ++++++++--
1 file changed, 22 insertions(+), 3 deletions(-)
New commits:
commit 921c54b6e87b30f37bcd610b2602ce2a296d4c6a
Author: Partha Aji <paji(a)redhat.com>
Date: Thu Jul 29 16:51:21 2010 -0400
Fixed a small glitch in the upgrade script.. The column name had an extra _
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/101-update-config-schema.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/101-update-config-schema.sql
index 5c2d431..5ab5e92 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/101-update-config-schema.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.0-to-spacewalk-schema-1.1/101-update-config-schema.sql
@@ -1,8 +1,27 @@
-alter table rhnConfigInfo add SYMLINK_TARGET_FILE_NAME_ID NUMBER
+--
+-- Copyright (c) 2008 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
+-- implied, including the implied warranties of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+-- along with this software; if not, see
+--
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+--
+-- Red Hat trademarks are not licensed under GPLv2. No permission is
+-- granted to use or replicate Red Hat trademarks that are incorporated
+-- in this software or its documentation.
+--
+
+alter table rhnConfigInfo add SYMLINK_TARGET_FILENAME_ID NUMBER
CONSTRAINT rhn_confinfo_symlink_fk
REFERENCES rhnConfigFileName (id);
-
-
+alter table rhnConfigInfo modify username NULL;
+alter table rhnConfigInfo modify groupname NULL;
+alter table rhnConfigInfo modify filemode NULL;
+drop index rhn_confinfo_ugf_uq;
+CREATE UNIQUE INDEX rhn_confinfo_ugf_uq
+ ON rhnConfigInfo (username, groupname, filemode, selinux_ctx,
symlink_target_filename_id);
alter table rhnConfigContent add delim_start VARCHAR2(16);