ÿþCREATE TABLE "Territories"

(

"TerritoryID" VARCHAR(20) COLLATE "UNI",

"TerritoryDescription" VARCHAR(50) COLLATE "UNI",

"RegionID" INTEGER,

CONSTRAINT "PK_TerritoryID" UNIQUE ("TerritoryID")

)

VERSION 1.00

READWRITE

UNENCRYPTED

INDEX PAGE SIZE 8192

BLOB BLOCK SIZE 1024

PUBLISH BLOCK SIZE 1024

PUBLISH COMPRESSION 0

MAX ROW BUFFER SIZE 32768

MAX INDEX BUFFER SIZE 65536

MAX BLOB BUFFER SIZE 32768

MAX PUBLISH BUFFER SIZE 32768!



INSERT INTO "Territories" VALUES ('01581',

                  'Westboro',

                  1)!



INSERT INTO "Territories" VALUES ('01730',

                  'Bedford',

                  1)!



INSERT INTO "Territories" VALUES ('01833',

                  'Georgetow',

                  1)!



INSERT INTO "Territories" VALUES ('02116',

                  'Boston',

                  1)!



INSERT INTO "Territories" VALUES ('02139',

                  'Cambridge',

                  1)!



INSERT INTO "Territories" VALUES ('02184',

                  'Braintree',

                  1)!



INSERT INTO "Territories" VALUES ('02903',

                  'Providence',

                  1)!



INSERT INTO "Territories" VALUES ('03049',

                  'Hollis',

                  3)!



INSERT INTO "Territories" VALUES ('03801',

                  'Portsmouth',

                  3)!



INSERT INTO "Territories" VALUES ('06897',

                  'Wilton',

                  1)!



INSERT INTO "Territories" VALUES ('07960',

                  'Morristown',

                  1)!



INSERT INTO "Territories" VALUES ('08837',

                  'Edison',

                  1)!



INSERT INTO "Territories" VALUES ('10019',

                  'New York',

                  1)!



INSERT INTO "Territories" VALUES ('10038',

                  'New York',

                  1)!



INSERT INTO "Territories" VALUES ('11747',

                  'Mellvile',

                  1)!



INSERT INTO "Territories" VALUES ('14450',

                  'Fairport',

                  1)!



INSERT INTO "Territories" VALUES ('19428',

                  'Philadelphia',

                  3)!



INSERT INTO "Territories" VALUES ('19713',

                  'Neward',

                  1)!



INSERT INTO "Territories" VALUES ('20852',

                  'Rockville',

                  1)!



INSERT INTO "Territories" VALUES ('27403',

                  'Greensboro',

                  1)!



INSERT INTO "Territories" VALUES ('27511',

                  'Cary',

                  1)!



INSERT INTO "Territories" VALUES ('29202',

                  'Columbia',

                  4)!



INSERT INTO "Territories" VALUES ('30346',

                  'Atlanta',

                  4)!



INSERT INTO "Territories" VALUES ('31406',

                  'Savannah',

                  4)!



INSERT INTO "Territories" VALUES ('32859',

                  'Orlando',

                  4)!



INSERT INTO "Territories" VALUES ('33607',

                  'Tampa',

                  4)!



INSERT INTO "Territories" VALUES ('40222',

                  'Louisville',

                  1)!



INSERT INTO "Territories" VALUES ('44122',

                  'Beachwood',

                  3)!



INSERT INTO "Territories" VALUES ('45839',

                  'Findlay',

                  3)!



INSERT INTO "Territories" VALUES ('48075',

                  'Southfield',

                  3)!



INSERT INTO "Territories" VALUES ('48084',

                  'Troy',

                  3)!



INSERT INTO "Territories" VALUES ('48304',

                  'Bloomfield Hills',

                  3)!



INSERT INTO "Territories" VALUES ('53404',

                  'Racine',

                  3)!



INSERT INTO "Territories" VALUES ('55113',

                  'Roseville',

                  3)!



INSERT INTO "Territories" VALUES ('55439',

                  'Minneapolis',

                  3)!



INSERT INTO "Territories" VALUES ('60179',

                  'Hoffman Estates',

                  2)!



INSERT INTO "Territories" VALUES ('60601',

                  'Chicago',

                  2)!



INSERT INTO "Territories" VALUES ('72716',

                  'Bentonville',

                  4)!



INSERT INTO "Territories" VALUES ('75234',

                  'Dallas',

                  4)!



INSERT INTO "Territories" VALUES ('78759',

                  'Austin',

                  4)!



INSERT INTO "Territories" VALUES ('80202',

                  'Denver',

                  2)!



INSERT INTO "Territories" VALUES ('80909',

                  'Colorado Springs',

                  2)!



INSERT INTO "Territories" VALUES ('85014',

                  'Phoenix',

                  2)!



INSERT INTO "Territories" VALUES ('85251',

                  'Scottsdale',

                  2)!



INSERT INTO "Territories" VALUES ('90405',

                  'Santa Monica',

                  2)!



INSERT INTO "Territories" VALUES ('94025',

                  'Menlo Park',

                  2)!



INSERT INTO "Territories" VALUES ('94105',

                  'San Francisco',

                  2)!



INSERT INTO "Territories" VALUES ('95008',

                  'Campbell',

                  2)!



INSERT INTO "Territories" VALUES ('95054',

                  'Santa Clara',

                  2)!



INSERT INTO "Territories" VALUES ('95060',

                  'Santa Cruz',

                  2)!



INSERT INTO "Territories" VALUES ('98004',

                  'Bellevue',

                  2)!



INSERT INTO "Territories" VALUES ('98052',

                  'Redmond',

                  2)!



INSERT INTO "Territories" VALUES ('98104',

                  'Seattle',

                  2)!