Subject | Re: [ib-support] Re: time series and FB/IB |
---|---|
Author | Milan Babuskov |
Post date | 2002-12-11T07:41:02Z |
Phil Shrimpton wrote:
Drop PK & create index is the whole change.
Or maybe add a generated column, and create PK on it instead.
That's two changes on the table anyway. If you have developed an aplication
for updating your apps / dbases, this shouldn't be any problem.
Milan Babuskov
http://sourceforge.net/projects/fbexport
> Because it has business meaning. If your client/boss tells you thatA lot of changes?
> the next update of WardrobeManager.exe should allow multiple shirts,
> you will need to do a lot of changes on your DB to allow it, if you
> used a generated key that has no business meaning, the change will be
> a lot easier
Drop PK & create index is the whole change.
Or maybe add a generated column, and create PK on it instead.
That's two changes on the table anyway. If you have developed an aplication
for updating your apps / dbases, this shouldn't be any problem.
Milan Babuskov
http://sourceforge.net/projects/fbexport