text: #
  #  Copyright 2017 Amazon.com
  #
  #  Licensed under the Apache License, Version 2.0 (the "License");
  #  you may not use this file except in compliance with the License.
  #  You may obtain a copy of the License at
  #
  #    http://www.apache.org/licenses/LICENSE-2.0
  #
  #  Unless required by applicable law or agreed to in writing, software
  #  distributed under the License is distributed on an "AS IS" BASIS,
  #  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  #  See the License for the specific language governing permissions and
  #  limitations under the License.
  
  
  
  
  create table if not exists seat_type
  (name varchar(15) NOT NULL,
   description varchar(120),
   relative_quality TINYINT,
   constraint st_seat_type_pk primary key(name)
  );
  
  insert into seat_type(name,description,relative_quality)
  values('luxury','Excellent seats - box seats, behind the plate, etc. etc.',1);
  insert into seat_type(name,description,relative_quality)
  values('premium','Really good seats - first level, mid field, etc. etc.',2);
  insert into seat_type(name,description,relative_quality)
  values('standard','Standard seats - not super awesome but pretty good',3);
  insert into seat_type(name,description,relative_quality)
  values('sub-standard','End zone, nose bleed, etc.',4);
  insert into seat_type(name,description,relative_quality)
  values('obstructed','Pretty crappy, partially obstructed seats',5);
  insert into seat_type(name,description,relative_quality)
  values('standing','Really? That''s not a seat at all now, is it?',10);
  
  