Interpret SQL file

Listed below are the contents of this SQL file:

/lib/tools/AM/sql/regions-create.sql

To evaluate the contents of the file, select a database pool and press the Post SQL button. If the database pool you select connects to an Illustra database and error is encountered, the database will be rolled back to its state just before the server began processing the file.

Warning: The window below contains only the first 50 lines of this file. You may want to download the entire file and examine it locally before loading it into your database.

-- Creates and populates Tables of Regions (i.e. US states, Canadian provinces, US territories) and Countries

CREATE TABLE NorthAmericaRegions (
    id              INTEGER NOT NULL IDENTITY PRIMARY KEY,
    abbrev          CHAR(2) NOT NULL UNIQUE,
    name            VARCHAR(100) NOT NULL UNIQUE,

-- For the moment we use:
    -- Type 0 == U.S. State / DC
    -- Type 1 == Canadian Province or Territory
    -- Type 2 == U.S. Territory
    -- Type 3 == Toll Free (not really a territory - used by DNC)
    -- But we may want finer grained distinction later
    type            INTEGER NOT NULL DEFAULT 0 
);

CREATE TABLE Countries (
    id              INTEGER NOT NULL IDENTITY PRIMARY KEY,
    ftcCode         CHAR(3) NOT NULL UNIQUE,

-- We should probably add support for showing both a formal name and a
    -- display, name, e.g. United States of America, and United States
    name            VARCHAR(50) NOT NULL UNIQUE,
);

INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('AL', 'Alabama');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('AK', 'Alaska');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('AZ', 'Arizona');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('AR', 'Arkansas');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('CA', 'California');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('CO', 'Colorado');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('CT', 'Connecticut'); 
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('DE', 'Delaware');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('DC', 'District of Columbia');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('FL', 'Florida');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('GA', 'Georgia');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('HI', 'Hawaii');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('ID', 'Idaho');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('IL', 'Illinois'); 
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('IN', 'Indiana');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('IA', 'Iowa');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('KS', 'Kansas');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('KY', 'Kentucky');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('LA', 'Louisiana');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('ME', 'Maine');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('MD', 'Maryland'); 
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('MA', 'Massachusetts');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('MI', 'Michigan');
INSERT INTO NorthAmericaRegions (abbrev, name) VALUES ('MN', 'Minnesota');

AOLserver/4.5.2 on https://am.net