Thread: more on database design

On Tue, 2006-11-21 at 04:18, Desmond Coughlan wrote:
> X-No-Archive: true
>
> Hi,
> Almost finished this database .. anyone able to take a glance at this,
> and tell me if with the ALTER TABLE statements at the bottom, I'm
> giving myself more work than necessary?
>
> http://www.chez.com/desmondcoughlan/unix/bibliotheque.sql
>
> Once it's over, I can concentrate on learning enough PhP to get a
> search page going.  :)

Just looks like you're doing it the hard way.

Most tables you can do something like:

create table abc (field1 int primary key, field2 not null references
someothertable(id));

i.e. do it at once.

But it's not a big deal.