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@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]]
spacewalk-commits@lists.fedorahosted.org