Mirek, the commit message seems to suggest that you plan to store the rpm installation date in that "created" column. It that so?
> commit 78f52b089c82e725b77b2e38e68fb02d49fe1512 > Author: Miroslav Suchý <msu...@redhat.com> > Date: Mon Oct 19 15:08:07 2009 +0200 > > 449167 - record rpm installation date > > diff --git a/schema/spacewalk/common/tables/rhnServerPackage.sql > b/schema/spacewalk/common/tables/rhnServerPackage.sql > index 6b9b091..b500019 100644 > --- a/schema/spacewalk/common/tables/rhnServerPackage.sql > +++ b/schema/spacewalk/common/tables/rhnServerPackage.sql > @@ -24,7 +24,9 @@ CREATE TABLE rhnServerPackage > evr_id NUMBER NOT NULL > REFERENCES rhnPackageEVR (id), > package_arch_id NUMBER > - REFERENCES rhnPackageArch (id) > + REFERENCES rhnPackageArch (id), > + created DATE > + DEFAULT (sysdate) NOT NULL > ) > TABLESPACE [[server_package_tablespace]] > ENABLE ROW MOVEMENT It sounds like a bad plan to me, as in all other tables in Spacewalk schema we store the timestamp/date of when the record was created. Note that it might not be the same as when the rpm was installed -- the information about rpm installation might be delayed. Could we use a different column name? -- Jan Pazdziora | adelton at #satellite*, #brno Satellite Engineering, Red Hat _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel