DROP TABLE RoomFeatureDescs#
CREATE TABLE RoomFeatureDescs
(RoomNumber CHAR(6),
HotelCode CHAR(8),
BitNum INT,
Feature CHAR(1),
Description CHAR(32),
PRIMARY KEY (RoomNumber, HotelCode, BitNum))#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum,Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,0, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit0 = '1'
and RoomFeatures.FeatureNo= '1'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,1, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit1 = '1'
and RoomFeatures.FeatureNo= '2'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,2, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit2 = '1'
and RoomFeatures.FeatureNo= '3'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,3, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit3 = '1'
and RoomFeatures.FeatureNo= '4'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,4, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit4 = '1'
and RoomFeatures.FeatureNo= '5'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode, BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,5, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit5 = '1'
and RoomFeatures.FeatureNo= '6'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode, BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,6, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit6 = '1'
and RoomFeatures.FeatureNo= '7'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode, BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,7, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit7 = '1'
and RoomFeatures.FeatureNo= '8'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,8, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit8 = '1'
and RoomFeatures.FeatureNo= '9'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,9, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit9 = '1'
and RoomFeatures.FeatureNo= '10'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,10, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit10 = '1'
and RoomFeatures.FeatureNo= '11'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,11, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit11 = '1'
and RoomFeatures.FeatureNo= '12'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,12, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit12 = '1'
and RoomFeatures.FeatureNo= '13'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,13, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit13 = '1'
and RoomFeatures.FeatureNo= '14'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,14, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit14 = '1'
and RoomFeatures.FeatureNo= '15'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,15, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures 
where roomsetup.featuresbit15 = '1'
and RoomFeatures.FeatureNo= '16'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 16, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit16 = '1'
and RoomFeatures.FeatureNo= '17'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode, BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 17, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit17 = '1'
and RoomFeatures.FeatureNo= '18'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode, BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode,18, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit18 = '1'
and RoomFeatures.FeatureNo= '19'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 19, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit19 = '1'
and RoomFeatures.FeatureNo= '20'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 20, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit20 = '1'
and RoomFeatures.FeatureNo= '21'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 21, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit21 = '1'
and RoomFeatures.FeatureNo= '22'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 22, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit22 = '1'
and RoomFeatures.FeatureNo= '23'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 23, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit23 = '1'
and RoomFeatures.FeatureNo= '24'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 24, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit24 = '1'
and RoomFeatures.FeatureNo= '25'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 25, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit25 = '1'
and RoomFeatures.FeatureNo= '26'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 26, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit26 = '1'
and RoomFeatures.FeatureNo= '27'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode, BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 27, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit27 = '1'
and RoomFeatures.FeatureNo= '28'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 28, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit28 = '1'
and RoomFeatures.FeatureNo= '29'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 29, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit29 = '1'
and RoomFeatures.FeatureNo= '30'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 30, RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit30 = '1'
and RoomFeatures.FeatureNo= '31'#
INSERT INTO RoomFeatureDescs (RoomNumber, HotelCode,BitNum, Feature, Description)
select roomsetup.roomnumber, roomsetup.hotelcode, 31,RoomFeatures.FeatureCode, RoomFeatures.Feature from roomsetup, RoomFeatures
where roomsetup.featuresbit31 = '1'
and RoomFeatures.FeatureNo= '32'#
GRANT SELECT ON RoomFeatureDescs TO ENTIRETYGROUP#