schema/spacewalk/upgrade/rhn-satellite-schema-5.1-to-spacewalk-schema-0.2/055-1-rhnPackageChangeLog-id.sql
| 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
New commits:
commit d6c844b22916e09f5ed07ffe8f3a05f0888c7a1a
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Tue Sep 22 13:53:27 2009 +0200
523389 - can't add NOT NULL column into non-empty table
so we have to add nullable one and then modify it
diff --git
a/schema/spacewalk/upgrade/rhn-satellite-schema-5.1-to-spacewalk-schema-0.2/055-1-rhnPackageChangeLog-id.sql
b/schema/spacewalk/upgrade/rhn-satellite-schema-5.1-to-spacewalk-schema-0.2/055-1-rhnPackageChangeLog-id.sql
index f5c8733..b56b79d 100644
---
a/schema/spacewalk/upgrade/rhn-satellite-schema-5.1-to-spacewalk-schema-0.2/055-1-rhnPackageChangeLog-id.sql
+++
b/schema/spacewalk/upgrade/rhn-satellite-schema-5.1-to-spacewalk-schema-0.2/055-1-rhnPackageChangeLog-id.sql
@@ -1,6 +1,8 @@
alter table rhnPackageChangelog
-add id number
+add id number;
+alter table rhnPackageChangelog
+modify id
constraint rhn_pkg_cl_id_nn not null novalidate
constraint rhn_pkg_cl_id_pk primary key
using index tablespace [[64k_tbs]]
Show replies by date