Re: Changes to trunk, Testing
On May 29, 2007, at 11:41, Helge Hess wrote:
On Mon, 2007-05-28 at 19:40 -0400, Adam Tauno Williams wrote:
> >I've done a few changes to the way insert/update operations work.
> > First of all primary key batches now work again, don't know how they
> > got lost (the SQL sequences reserves a batch of 10 keys per
> > invocation, so far we only used one of them resulting in wasted key
> > space ...).
> > Next I changed the way object_version, last_modified, etc fields are
> > updated, and I added those to a few classes which didn't have them
> > before (eg docs, notes and projects)
> > Finally I plan to enhance the database schema for 5.4. Mostly:
> > - notes/documents attached to company records
> Awesome!
Didn't ever see the schema changes come across and am in need of
notes<->contact. Were you thinking -
ALTER TABLE document ADD company_id INT;
- or -
ALTER TABLE document ADD contact_id INT;
ALTER TABLE document ADD enterprise_id INT;
- personally I'd like the later (in part because it matches how we are
'hacking' notes currently)
?
--
--
(Continue reading)