> >Righto, lunch is over. Here's what I've done:
> >Anyone like to add/modify/delete?
> >
> >Nige.
> >
> >
> >
> >/* Hotel Module
> >Supports room information, restaurant bookings, cleaning and maintenance
> >schedules
> >*/
> >
> >/* Room Types Source Table */
> >CREATE TABLE tlkp_roomtype (
> > str_type VARCHAR(20) NOT NULL,
> > PRIMARY KEY(str_type)
> >);
> >
> etc. etc....
>
> Oh God, someone still writes SQL scripts without an E-R diagram... This
> way is full of dangers and the result is a poor implementation.

What makes you think he didn't create a diagram? On paper? :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com