/* SQL-92 Table Creation Script
This does not automatically create the Venue_Map graphics*/

DROP TABLE IF EXISTS "Venues";

CREATE TABLE IF NOT EXISTS "Venues"
(
   "VenueNo" INTEGER,
   "Venue" VARCHAR(30),
   "Capacity" INTEGER,
   "Venue_Map" GRAPHIC,
   "Remarks" MEMO,
PRIMARY KEY ("RecordID") COMPRESS NONE
LOCALE CODE 0
USER MAJOR VERSION 1
);


INSERT INTO "venues" VALUES (2, 
         'Memorial Stadium', 360, NULL, 
         'Standard bleacher seating -- sides only.'+
         '  Special cushion seating will be provid'+
         'ed for VIP/comp section.'+
         '');
INSERT INTO "venues" VALUES (3, 
         'Main Auditorium', 2010, NULL, 
         'Advise hearing-impaired guests to select'+
         ' seats in the rear, due to acoustic prob'+
         'lems.'+
         '');
INSERT INTO "venues" VALUES (4, 
         'Coliseum', 12500, NULL, 
         'Partially covered venue.  Cancellations '+
         'are possible due to inclement weather.'+
         '');
INSERT INTO "venues" VALUES (5, 
         'Frye Track', 1400, NULL, 
         'Track & field events will use a modified'+
         ' configuration with limited seating.'+
         '');
INSERT INTO "venues" VALUES (6, 
         'Guillermo Field', 2200, NULL, 
         'Track & field events will use a modified'+
         ' configuration with limited seating.'+
         '');
INSERT INTO "venues" VALUES (7, 
         'Memorial Stadium', 1000, NULL, 
         'Acoustics are best in sections A through'+
         ' C, mezannine level.'+
         '');
INSERT INTO "venues" VALUES (8, 
         'Special City Route', 15000, NULL, 
         'Advise spectators of limited access at S'+
         'AG stops S5 and S5'+
         '');
INSERT INTO "venues" VALUES (9, 
         'Ayung River', 500, NULL, 
         'Severe access problems, except for Falls'+
         ' park.'+
         '');
INSERT INTO "venues" VALUES (10, 
         'County Line Beach', 240, NULL, 
         'Advise spectators of access route:  park'+
         'ing only in Zuma Beach P1 lot.'+
         '');
INSERT INTO "venues" VALUES (11, 
         'Parker Aquatic Ctr', 420, NULL, 
         'Purple section is bleachers only.  Advis'+
         'e guests accordingly.'+
         '');
