// File to create Hotel database
//=================================
//=============================================
//flatUnitNo\streetNo\name\suburb\city\provience\
*Address
\100\Pleasant Avenue\Richmond\Christchurch\Canterbury\
*Address
2\365\Degree Road\\Christchurch\Canterbury\
*Address
\\Pte Bag 18A\\Timaru\South Canterbury\
*Address
\18B\Jones Blvd\\Kaiapoi\North Canterbury\
*Address
5\203\Cogham Drive\Pukekohe\Auckland\Northland\

*Company
Tele-International\Pleasant Avenue\033555465\033555485\033555465\info@tele-international.com\
*Company
Thax Health Corp\Main East Road\044555465\044555485\044555465\info@thax.com\

//name\address\phone\fax\altphone\email\company\
*Guest
Godrey, Alice\1\044555123\\\\null\
*Guest
Gupta, Alice\4\044555285\\034555543\\null\
*Guest
Turing, Robert\2\044555835\\044555835\\Tele-International\
*Guest
Gilbert, Jackie\2\045687422\\096548541\\Tele-International\
*Guest
Guthrey, Patrick\5\044555458\044555345\\\\Thax Health Corp\
*Guest
Hanson, Claude\5\044555458\044555345\\\Thax Health Corp\
*Guest
Hanson, Cecilia\5\044555458\044555345\\\Thax Health Corp\

*Person
Turing, Silas\2\044555835\\044555835\\Tele-International\
*Person
Gupta, Ramjam\4\044555285\\034555543\\Thax Health Corp\

*RmType
Standard Double\SDB\60\
*RmType
Standard Twin\STW\60\
*RmType
Executive Double\EXD\100\
*RmType
Executive Twin\ETW\100\
*RmType
Deluxe\DXL\150\
*RmType
Suite\SUI\300\

*RmStatus
occupied and service\occ/ser\false\
*RmStatus
occupied and un-service\occ/u-ser\true\
*RmStatus
un-occupied and service\u-occ/ser\false\
*RmStatus
un-occupied and un-service\u-occ/u-ser\true\

*Room
101\EXD\u-occ/ser\
*Room
102\EXD\u-occ/ser\
*Room
103\ETW\u-occ/ser\
*Room
104\ETW\u-occ/u-ser\
*Room
105\DXL\u-occ/u-ser\
*Room
201\SDB\u-occ/ser\
*Room
202\SDB\u-occ/ser\
*Room
203\STW\u-occ/ser\
*Room
204\STW\u-occ/ser\
*Room
205\SUI\u-occ/ser\

*Room
106\EXD\u-occ/ser\
*Room
107\EXD\u-occ/ser\
*Room
108\ETW\u-occ/ser\
*Room
109\ETW\u-occ/u-ser\
*Room
110\DXL\u-occ/u-ser\
*Room
206\SDB\u-occ/ser\
*Room
207\SDB\u-occ/ser\
*Room
208\STW\u-occ/ser\
*Room
209\STW\u-occ/ser\
*Room
210\SUI\u-occ/ser\

*TransactionOutlets
Room only\1\
*TransactionOutlets
Accom\2\
*TransactionOutlets
Breakfast\6\
*TransactionOutlets
Bar\19\
*TransactionOutlets
Restaurant Lunch\20\
*TransactionOutlets
Restaurant Dinner\21\
*TransactionOutlets
Phone\36\
*TransactionOutlets
Laundrey\54\
*TransactionOutlets
Misc\99\

*RmRate
Room Only\(1\0\)\
*RmRate
Bed and Breakfast\(6\6.5\2\40\)\
*RmRate
Dinner, Bed and Breakfast\(20\19\2\40\21\30.50\)\
*RmRate
Bed and Breakfast, newspaper\(2\35\6\6.5\99\2\)\

//contactperson\groupresreference\(roomrate\roomtype\number)\special\
*GroupReservation
7\(Dinner, Bed and Breakfast\EXD\1\Bed and Breakfast, newspaper\ETW\1\)\\
*GroupReservation
8\(Bed and Breakfast\SDB\2\)\\

//contactperson\roomrate\roomtype\guest\refNo\groupResRef\special\
*IndividualReservation
7\Room Only\SDB\3\null\\201
*IndividualReservation
8\Bed and Breakfast\STW\1\null\\204
*IndividualReservation
8\Room Only\DXL\7\null\\105
//for group 1
*IndividualReservation
7\Bed and Breakfast\EXD\5\1000\\102
*IndividualReservation
7\Bed and Breakfast\EXD\2\1000\\107
// for group 2
*IndividualReservation
8\Dinner, Bed and Breakfast\EXD\6\1001\\106
*IndividualReservation
8\Bed and Breakfast, newspaper\SUI\4\1001\\210

