Nigel Weeks wrote:

>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.
Ciao
Antonio Petrelli