Contents of createTables.txt

---

CREATE TABLE clients
( clientID counter ,
last char(24) ,
first char(24) ,
addr1 char(24) ,
addr2 char(24) ,
country char(24) ,
curr char(24) ,
phone char(24) ,
fax char(24) ,
email char(48) ,
password char(8) )

CREATE TABLE hotels
( hotelID counter ,
name char(32) ,
addr1 char(24) ,
addr2 char(24) ,
addr3 char(24) ,
tel char(24) ,
fax char(24) ,
web char(24) ,
email char(24) ,
descr memo ,
amenities memo ,
picture char(32) ,
width char(8) ,
height char(8) ,
alt char(32) )

CREATE TABLE rooms
( roomID counter ,
hotelID integer ,
type char(48) ,
rate currency ,
persons integer ,
inventory integer )

CREATE TABLE bookings
( clientID counter ,
hotelID integer ,
roomID integer ,
qty integer ,
arr date ,
dep date )

---