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.
