On Mon, Jul 27, 2009 at 07:54:32PM +0200, Milan Zazrivec wrote: > On Monday 27 July 2009 15:54:13 Pradeep Kilambi wrote: > > diff --git a/schema/spacewalk/rhnsat/tables/rhnChannel.sql > > b/schema/spacewalk/rhnsat/tables/rhnChannel.sql index 95a54dc..b4e1fab > > 100644 > > --- a/schema/spacewalk/rhnsat/tables/rhnChannel.sql > > +++ b/schema/spacewalk/rhnsat/tables/rhnChannel.sql > > @@ -49,6 +49,8 @@ rhnChannel > > gpg_key_id varchar2(14), > > gpg_key_fp varchar2(50), > > end_of_life date, > > + checksum_type_id number constraint rhn_channel_checksum_fk > > + references rhnChecksumType(id), > > receiving_updates char(1) > > default 'Y' > > constraint rhn_channel_ru_nn not null > > Now that rhnChannel table depends on rhnChecksumType, this relation > needs to be put into the Makefile.deps (and the pgsql branch equivalent) > so that the resulting schema deploys cleanly.
Also, shouldn't the id in rhnChecksumType and that checksum_type_id here be some type of integer? It seems strange to see it defined as generic number. -- Jan Pazdziora Satellite Engineering, Red Hat _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel