/* Copyright (c) 2009 Steven N. Oliver */

/* This file is part of Falcon.
 *
 * Falcon is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * Falcon is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with Falcon.  If not, see <http://www.gnu.org/licenses/>.
 */

DROP DATABASE falcon;

CREATE DATABASE falcon;

USE falcon;

/****************************************************************
 *		Primary Data Storage				*
 ***************************************************************/
CREATE TABLE wells
(
    well_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    well_number VARCHAR(10) NOT NULL,
    well_name VARCHAR(30) NOT NULL,
    created_on DATE NOT NULL,
    created_by VARCHAR(8) NOT NULL,
    last_updated DATE NOT NULL,
    updater VARCHAR(8) NOT NULL,
    PRIMARY KEY (well_id)
);

CREATE UNIQUE INDEX well_id ON wells (well_id);
CREATE UNIQUE INDEX well_info ON wells (well_number, well_name);

CREATE TABLE leases
(
    lease_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    lease_number VARCHAR(10) NOT NULL,
    lease_name VARCHAR(30) NOT NULL,
    created_on DATE NOT NULL,
    created_by VARCHAR(8) NOT NULL,
    last_updated DATE NOT NULL,
    updater VARCHAR(8) NOT NULL,
    PRIMARY KEY (lease_id)
);

CREATE UNIQUE INDEX lease_id ON leases (lease_id);
CREATE UNIQUE INDEX lease_info ON leases (lease_number, lease_name);

CREATE TABLE contracts
(
    contract_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    contract_number VARCHAR(10) NOT NULL,
    contract_name VARCHAR(30) NOT NULL,
    created_on DATE NOT NULL,
    created_by VARCHAR(8) NOT NULL,
    last_updated DATE NOT NULL,
    updater VARCHAR(8) NOT NULL,
    PRIMARY KEY (contract_id)
);

CREATE UNIQUE INDEX contract_id ON contracts (contract_id);
CREATE UNIQUE INDEX contract_info ON contracts (contract_name, contract_number);

CREATE TABLE area
(
    area_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    well_id INT,
    size INT,
    units VARCHAR(5),
    PRIMARY KEY (area_id)
);

/****************************************************************
 *			Address Book				*
 ***************************************************************/
CREATE TABLE names
(
    name_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    first VARCHAR(20),
    middle VARCHAR(20),
    last VARCHAR(20),
    created_on DATE NOT NULL,
    created_by VARCHAR(8) NOT NULL,
    last_updated DATE NOT NULL,
    updater VARCHAR(8) NOT NULL,
    tax_id_type VARCHAR(10),
    tax_id_num VARCHAR(15),
    PRIMARY KEY (name_id)
);

CREATE TABLE addresses
(
    address_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    name_id INT UNSIGNED NOT NULL,
    line_1 VARCHAR(30),
    line_2 VARCHAR(30),
    city VARCHAR(20),
    state VARCHAR(2),
    zip VARCHAR(10),
    created_on DATE NOT NULL,
    created_by VARCHAR(8) NOT NULL,
    last_updated DATE NOT NULL,
    updater VARCHAR(8) NOT NULL,
    PRIMARY KEY (address_id),
    FOREIGN KEY (name_id) REFERENCES names (name_id)
);

CREATE TABLE roles
(
    role_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    created_on DATE NOT NULL,
    created_by VARCHAR(8) NOT NULL,
    last_updated DATE NOT NULL,
    updater VARCHAR(8) NOT NULL,
    PRIMARY KEY (role_id)
);

/****************************************************************
 *		     Accounting and Finance  			*
 ***************************************************************/
CREATE TABLE entity_interest
(
    interest_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    name_id INT NOT NULL,
    well_interest INT,
    well_percentage INT,
    lease_interest INT,
    lease_percentage INT,
    contract_interest INT,
    contract_percentage INT,
    PRIMARY KEY (interest_id),
    FOREIGN KEY (name_id) REFERENCES names (name_id)
);

CREATE TABLE checks
(
    check_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    check_number INT NOT NULL,
    amount INT NOT NULL,
    payee VARCHAR(20) NOT NULL,
    payor VARCHAR(20) NOT NULL,
    void ENUM('Y','N') DEFAULT 'N',
    suspense ENUM('Y','N') DEFAULT 'N',
    created_on DATE NOT NULL,
    created_by VARCHAR(8) NOT NULL,
    last_updated DATE NOT NULL,
    updater VARCHAR(8) NOT NULL,
    PRIMARY KEY (check_id)
);

CREATE TABLE accounts
(
    account_num INT UNSIGNED NOT NULL,
    name_id INT NULL,
    name VARCHAR(20),
    PRIMARY KEY (account_num),
    FOREIGN KEY (name_id) REFERENCES names (name_id)
);

CREATE TABLE payments
(
    payment_num INT UNSIGNED NOT NULL AUTO_INCREMENT,
    payee INT NOT NULL,
    payor INT NOT NULL,
    frequency INT,
    gross_amount INT NOT NULL,
    net_amount INT NOT NULL,
    check_num INT,
    PRIMARY KEY (payment_num)
);

CREATE TABLE payees
(
    payee_num INT UNSIGNED NOT NULL AUTO_INCREMENT,
    name VARCHAR(20) NOT NULL,
    PRIMARY KEY (payee_num)
);

/****************************************************************
 *		     Reference Tables				*
 ***************************************************************/
CREATE TABLE counties
(
    county_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    state VARCHAR(2) NOT NULL,
    description VARCHAR(30),
    PRIMARY KEY (county_id)
);

CREATE UNIQUE INDEX counties ON counties(county_id, state, description);

CREATE TABLE states
(
    code VARCHAR(2) NOT NULL,
    country VARCHAR(2),
    description VARCHAR(20) NOT NULL
);

CREATE UNIQUE INDEX states ON states(code, description);

CREATE TABLE countries
(
    code VARCHAR(2) NOT NULL,
    description VARCHAR(40) NOT NULL
);

CREATE UNIQUE INDEX countries ON countries(code, description);

CREATE TABLE units
(
    unit VARCHAR(5) NOT NULL,
    squared ENUM('Y','N') DEFAULT 'N',
    description VARCHAR(20) NOT NULL
);

CREATE UNIQUE INDEX units ON units(unit, description);

CREATE TABLE tax_id_types
(
    tax_id_type VARCHAR(10) NOT NULL,
    description VARCHAR(20) NOT NULL
);

/****************************************************************
 *		    Fill Reference Tables			*
 ***************************************************************/
--States
INSERT INTO states (code, country, description) VALUES ('AL','US','Alabama');
INSERT INTO states (code, country, description) VALUES ('AK','US','Alaska');
INSERT INTO states (code, country, description) VALUES ('AZ','US','Arizona');
INSERT INTO states (code, country, description) VALUES ('AR','US','Arkansas');
INSERT INTO states (code, country, description) VALUES ('CA','US','California');
INSERT INTO states (code, country, description) VALUES ('CO','US','Colorado');
INSERT INTO states (code, country, description) VALUES ('CT','US','Connecticut');
INSERT INTO states (code, country, description) VALUES ('DE','US','Delaware');
INSERT INTO states (code, country, description) VALUES ('FL','US','Flordia');
INSERT INTO states (code, country, description) VALUES ('GA','US','Georgia');
INSERT INTO states (code, country, description) VALUES ('HI','US','Hawaii');
INSERT INTO states (code, country, description) VALUES ('ID','US','Idaho');
INSERT INTO states (code, country, description) VALUES ('IL','US','Illinois');
INSERT INTO states (code, country, description) VALUES ('IN','US','Indiana');
INSERT INTO states (code, country, description) VALUES ('IA','US','Iowa');
INSERT INTO states (code, country, description) VALUES ('KS','US','Kansas');
INSERT INTO states (code, country, description) VALUES ('KY','US','Kentucky');
INSERT INTO states (code, country, description) VALUES ('LA','US','Louisiana');
INSERT INTO states (code, country, description) VALUES ('ME','US','Maine');
INSERT INTO states (code, country, description) VALUES ('MD','US','Maryland');
INSERT INTO states (code, country, description) VALUES ('MA','US','Massachusetts');
INSERT INTO states (code, country, description) VALUES ('MI','US','Michigan');
INSERT INTO states (code, country, description) VALUES ('MN','US','Minnesota');
INSERT INTO states (code, country, description) VALUES ('MS','US','Mississippi');
INSERT INTO states (code, country, description) VALUES ('MO','US','Missouri');
INSERT INTO states (code, country, description) VALUES ('MT','US','Montana');
INSERT INTO states (code, country, description) VALUES ('NE','US','Nebraska');
INSERT INTO states (code, country, description) VALUES ('NV','US','Nevada');
INSERT INTO states (code, country, description) VALUES ('NH','US','New Hampshire');
INSERT INTO states (code, country, description) VALUES ('NJ','US','New Jersey');
INSERT INTO states (code, country, description) VALUES ('NM','US','New Mexico');
INSERT INTO states (code, country, description) VALUES ('NY','US','New York');
INSERT INTO states (code, country, description) VALUES ('NC','US','North Carolina');
INSERT INTO states (code, country, description) VALUES ('ND','US','North Dakota');
INSERT INTO states (code, country, description) VALUES ('OH','US','Ohio');
INSERT INTO states (code, country, description) VALUES ('OK','US','Oklahoma');
INSERT INTO states (code, country, description) VALUES ('OR','US','Oregon');
INSERT INTO states (code, country, description) VALUES ('PA','US','Pennsylvania');
INSERT INTO states (code, country, description) VALUES ('RI','US','Rhode Island');
INSERT INTO states (code, country, description) VALUES ('SC','US','South Carolina');
INSERT INTO states (code, country, description) VALUES ('SD','US','South Dakota');
INSERT INTO states (code, country, description) VALUES ('TN','US','Tennessee');
INSERT INTO states (code, country, description) VALUES ('TX','US','Texas');
INSERT INTO states (code, country, description) VALUES ('UT','US','Utah');
INSERT INTO states (code, country, description) VALUES ('VT','US','Vermont');
INSERT INTO states (code, country, description) VALUES ('VA','US','Virginia');
INSERT INTO states (code, country, description) VALUES ('WA','US','Washinton');
INSERT INTO states (code, country, description) VALUES ('WV','US','West Virginia');
INSERT INTO states (code, country, description) VALUES ('WI','US','Wisconsin');
INSERT INTO states (code, country, description) VALUES ('WY','US','Wyoming');

--Countries
INSERT INTO countries (code, description) VALUES ('AF','Afghanistan');
INSERT INTO countries (code, description) VALUES ('AX','Aland Islands');
INSERT INTO countries (code, description) VALUES ('AL','Albania');
INSERT INTO countries (code, description) VALUES ('DZ','Algeria');
INSERT INTO countries (code, description) VALUES ('AS','American Samoa');
INSERT INTO countries (code, description) VALUES ('AD','Andorra');
INSERT INTO countries (code, description) VALUES ('AO','Angola');
INSERT INTO countries (code, description) VALUES ('AI','Anguilla');
INSERT INTO countries (code, description) VALUES ('AQ','Antarctica');
INSERT INTO countries (code, description) VALUES ('AG','Antigua and Barbuda');
INSERT INTO countries (code, description) VALUES ('AR','Argentina');
INSERT INTO countries (code, description) VALUES ('AM','Anmenia');
INSERT INTO countries (code, description) VALUES ('AW','Aruba');
INSERT INTO countries (code, description) VALUES ('AU','Australia');
INSERT INTO countries (code, description) VALUES ('AT','Austria');
INSERT INTO countries (code, description) VALUES ('AZ','Azerbaijan');
INSERT INTO countries (code, description) VALUES ('BS','Bahamas');
INSERT INTO countries (code, description) VALUES ('BH','Bahrain');
INSERT INTO countries (code, description) VALUES ('BD','Bangladesh');
INSERT INTO countries (code, description) VALUES ('BB','Barbados');
INSERT INTO countries (code, description) VALUES ('BY','Belarus');
INSERT INTO countries (code, description) VALUES ('BE','Belgium');
INSERT INTO countries (code, description) VALUES ('BZ','Belize');
INSERT INTO countries (code, description) VALUES ('BJ','Benin');
INSERT INTO countries (code, description) VALUES ('BM','Bermuda');
INSERT INTO countries (code, description) VALUES ('BT','Bhutan');
INSERT INTO countries (code, description) VALUES ('BO','Bolivia');
INSERT INTO countries (code, description) VALUES ('BA','Bosnia and Herzegovina');
INSERT INTO countries (code, description) VALUES ('BW','Botswana');
INSERT INTO countries (code, description) VALUES ('BV','Bouvet Island');
INSERT INTO countries (code, description) VALUES ('BR','Brazil');
INSERT INTO countries (code, description) VALUES ('IO','British Indian Ocean Territory');
INSERT INTO countries (code, description) VALUES ('BN','Brune Darussalam');
INSERT INTO countries (code, description) VALUES ('BG','Bulgaria');
INSERT INTO countries (code, description) VALUES ('BF','Burkina Faso');
INSERT INTO countries (code, description) VALUES ('BI','Burundi');
INSERT INTO countries (code, description) VALUES ('KH','Cambodia');
INSERT INTO countries (code, description) VALUES ('CM','Cameroon');
INSERT INTO countries (code, description) VALUES ('CA','Canada');
INSERT INTO countries (code, description) VALUES ('CV','Cape Verde');
INSERT INTO countries (code, description) VALUES ('KY','Cayman Islands');
INSERT INTO countries (code, description) VALUES ('CF','Central African Republic');
INSERT INTO countries (code, description) VALUES ('TD','Chad');
INSERT INTO countries (code, description) VALUES ('CL','Chile');
INSERT INTO countries (code, description) VALUES ('CN','China');
INSERT INTO countries (code, description) VALUES ('CX','Chrismas Island');
INSERT INTO countries (code, description) VALUES ('CC','Cocos (Keeling) Islands');
INSERT INTO countries (code, description) VALUES ('CO','Columbia');
INSERT INTO countries (code, description) VALUES ('KM','Comoros');
INSERT INTO countries (code, description) VALUES ('CG','Congo');
INSERT INTO countries (code, description) VALUES ('CD','The Democratic Republic of the Congo');
INSERT INTO countries (code, description) VALUES ('CK','Cook Islands');
INSERT INTO countries (code, description) VALUES ('CR','Costa Rico');
INSERT INTO countries (code, description) VALUES ('CI','Cote DiVoire');
INSERT INTO countries (code, description) VALUES ('HR','Croatia');
INSERT INTO countries (code, description) VALUES ('CU','Cuba');
INSERT INTO countries (code, description) VALUES ('CY','Cyprus');
INSERT INTO countries (code, description) VALUES ('CZ','Czech Republic');
INSERT INTO countries (code, description) VALUES ('DK','Denmakr');
INSERT INTO countries (code, description) VALUES ('DJ','Djibouti');
INSERT INTO countries (code, description) VALUES ('DM','Dominica');
INSERT INTO countries (code, description) VALUES ('DO','Dominican Republic');
INSERT INTO countries (code, description) VALUES ('EC','Ecuador');
INSERT INTO countries (code, description) VALUES ('EG','Egypt');
INSERT INTO countries (code, description) VALUES ('SV','El Salvador');
INSERT INTO countries (code, description) VALUES ('GQ','Equatorial Guinea');
INSERT INTO countries (code, description) VALUES ('ER','Eritrea');
INSERT INTO countries (code, description) VALUES ('EE','Estonia');
INSERT INTO countries (code, description) VALUES ('ET','Ethiopia');
INSERT INTO countries (code, description) VALUES ('FK','Falkland Islands (Malvinas)');
INSERT INTO countries (code, description) VALUES ('FO','Faroe Islands');
INSERT INTO countries (code, description) VALUES ('FJ','Fiji');
INSERT INTO countries (code, description) VALUES ('FI','Finland');
INSERT INTO countries (code, description) VALUES ('FR','France');
INSERT INTO countries (code, description) VALUES ('GF','French Guiana');
INSERT INTO countries (code, description) VALUES ('PF','French Polynesia');
INSERT INTO countries (code, description) VALUES ('TF','French Southern Territories');
INSERT INTO countries (code, description) VALUES ('GA','Gabon');
INSERT INTO countries (code, description) VALUES ('GM','Gambia');
INSERT INTO countries (code, description) VALUES ('GE','Georgia');
INSERT INTO countries (code, description) VALUES ('DE','Germany');
INSERT INTO countries (code, description) VALUES ('GH','Ghana');
INSERT INTO countries (code, description) VALUES ('GI','Gibraltar');
INSERT INTO countries (code, description) VALUES ('GR','Greence');
INSERT INTO countries (code, description) VALUES ('GL','Greenland');
INSERT INTO countries (code, description) VALUES ('GD','Grenada');
INSERT INTO countries (code, description) VALUES ('GP','Guadeloupe');
INSERT INTO countries (code, description) VALUES ('GU','Guam');
INSERT INTO countries (code, description) VALUES ('GT','Guatemala');
INSERT INTO countries (code, description) VALUES ('GG','Guernsey');
INSERT INTO countries (code, description) VALUES ('GN','Guinea');
INSERT INTO countries (code, description) VALUES ('GW','guinea-Bissau');
INSERT INTO countries (code, description) VALUES ('GY','Guyana');
INSERT INTO countries (code, description) VALUES ('HT','Haiti');
INSERT INTO countries (code, description) VALUES ('HM','Heard Island and McDonald Islands');
INSERT INTO countries (code, description) VALUES ('VA','Holy See (Vatican City State)');
INSERT INTO countries (code, description) VALUES ('HN','Honduras');
INSERT INTO countries (code, description) VALUES ('HK','Hong Kong');
INSERT INTO countries (code, description) VALUES ('HU','Hungary');
INSERT INTO countries (code, description) VALUES ('IS','Iceland');
INSERT INTO countries (code, description) VALUES ('IN','India');
INSERT INTO countries (code, description) VALUES ('ID','Indonesia');
INSERT INTO countries (code, description) VALUES ('IR','Islamic Republic of Iran');
INSERT INTO countries (code, description) VALUES ('IQ','Iraq');
INSERT INTO countries (code, description) VALUES ('IE','Ireland');
INSERT INTO countries (code, description) VALUES ('IM','Ilse of Man');
INSERT INTO countries (code, description) VALUES ('IL','Israel');
INSERT INTO countries (code, description) VALUES ('IT','Italy');
INSERT INTO countries (code, description) VALUES ('JM','Jamaica');
INSERT INTO countries (code, description) VALUES ('JP','Japan');
INSERT INTO countries (code, description) VALUES ('JE','Jersey');
INSERT INTO countries (code, description) VALUES ('JO','Jordan');
INSERT INTO countries (code, description) VALUES ('KZ','Kazakhstan');
INSERT INTO countries (code, description) VALUES ('KE','Kenya');
INSERT INTO countries (code, description) VALUES ('KI','Kiribati');
INSERT INTO countries (code, description) VALUES ('KP','Democratic People's Replubic of Korea');
INSERT INTO countries (code, description) VALUES ('KR','Republic of Korea');
INSERT INTO countries (code, description) VALUES ('KW','Kuwait');
INSERT INTO countries (code, description) VALUES ('KG','Kyrgyzstan');
INSERT INTO countries (code, description) VALUES ('LA','Lao People's Democratic Republic');
INSERT INTO countries (code, description) VALUES ('LV','Latvia');
INSERT INTO countries (code, description) VALUES ('LB','Lebanon');
INSERT INTO countries (code, description) VALUES ('LS','Lesotho');
INSERT INTO countries (code, description) VALUES ('LR','Liberia');
INSERT INTO countries (code, description) VALUES ('LY','Libyan Arab Jamahiriya');
INSERT INTO countries (code, description) VALUES ('LI','Liechtenstein');
INSERT INTO countries (code, description) VALUES ('LT','Lithuania');
INSERT INTO countries (code, description) VALUES ('LU','Luxembourg');
INSERT INTO countries (code, description) VALUES ('MO','Macao');
INSERT INTO countries (code, description) VALUES ('MK','The Former Yugoslav Republic of Macedonia');
INSERT INTO countries (code, description) VALUES ('MG','Madagascar');
INSERT INTO countries (code, description) VALUES ('MW','Malawi');
INSERT INTO countries (code, description) VALUES ('MY','Malaysia');
INSERT INTO countries (code, description) VALUES ('MV','Maldives');
INSERT INTO countries (code, description) VALUES ('ML','Mali');
INSERT INTO countries (code, description) VALUES ('MT','Malta');
INSERT INTO countries (code, description) VALUES ('MH','Marshall Islands');
INSERT INTO countries (code, description) VALUES ('MQ','Martinique');
INSERT INTO countries (code, description) VALUES ('MR','Mauritania');
INSERT INTO countries (code, description) VALUES ('MU','Mauritius');
INSERT INTO countries (code, description) VALUES ('YT','Mayotte');
INSERT INTO countries (code, description) VALUES ('MX','Mexico');
INSERT INTO countries (code, description) VALUES ('FM','Federated States of Micronesia');
INSERT INTO countries (code, description) VALUES ('MD','Republic of Moldova');
INSERT INTO countries (code, description) VALUES ('MC','Monaco');
INSERT INTO countries (code, description) VALUES ('MN','Mongolia');
INSERT INTO countries (code, description) VALUES ('ME','Montenegro');
INSERT INTO countries (code, description) VALUES ('MS','Montserrat');
INSERT INTO countries (code, description) VALUES ('MA','Morocco');
INSERT INTO countries (code, description) VALUES ('MZ','Mozambique');
INSERT INTO countries (code, description) VALUES ('MM','Myanmar');
INSERT INTO countries (code, description) VALUES ('NA','Namibia');
INSERT INTO countries (code, description) VALUES ('NR','Nauru');
INSERT INTO countries (code, description) VALUES ('NP','Nepal');
INSERT INTO countries (code, description) VALUES ('NL','Netherlands');
INSERT INTO countries (code, description) VALUES ('AN','Netherlands Antilles');
INSERT INTO countries (code, description) VALUES ('NC','New Caledonia');
INSERT INTO countries (code, description) VALUES ('NZ','New Zealand');
INSERT INTO countries (code, description) VALUES ('NI','Nicaragua');
INSERT INTO countries (code, description) VALUES ('NE','Niger');
INSERT INTO countries (code, description) VALUES ('NG','Nigeria');
INSERT INTO countries (code, description) VALUES ('NU','Niue');
INSERT INTO countries (code, description) VALUES ('NF','Norfolk Island');
INSERT INTO countries (code, description) VALUES ('MP','Northern Mariana Islands');
INSERT INTO countries (code, description) VALUES ('NO','Norway');
INSERT INTO countries (code, description) VALUES ('OM','Oman');
INSERT INTO countries (code, description) VALUES ('OK','Pakistan');
INSERT INTO countries (code, description) VALUES ('PW','Palau');
INSERT INTO countries (code, description) VALUES ('PS','Occupied Palestinian Territory');
INSERT INTO countries (code, description) VALUES ('PA','Panama');
INSERT INTO countries (code, description) VALUES ('PG','Papua New Guinea');
INSERT INTO countries (code, description) VALUES ('PY','Paraguay');
INSERT INTO countries (code, description) VALUES ('PE','Peru');
INSERT INTO countries (code, description) VALUES ('PH','Philippines');
INSERT INTO countries (code, description) VALUES ('PN','Pitcairn');
INSERT INTO countries (code, description) VALUES ('PL','Poland');
INSERT INTO countries (code, description) VALUES ('PT','Portugal');
INSERT INTO countries (code, description) VALUES ('PR','Puerto Rico');
INSERT INTO countries (code, description) VALUES ('QA','Qatar');
INSERT INTO countries (code, description) VALUES ('RE','Reunion');
INSERT INTO countries (code, description) VALUES ('RO','Romania');
INSERT INTO countries (code, description) VALUES ('RU','Russian Federation');
INSERT INTO countries (code, description) VALUES ('US','United States of America');

--Counties
INSERT INTO counties (state, description) VALUES ('WV','Barbour');
INSERT INTO counties (state, description) VALUES ('WV','Berkeley');
INSERT INTO counties (state, description) VALUES ('WV','Boone');
INSERT INTO counties (state, description) VALUES ('WV','Braxton');
INSERT INTO counties (state, description) VALUES ('WV','Brooke');
INSERT INTO counties (state, description) VALUES ('WV','Cabell');
INSERT INTO counties (state, description) VALUES ('WV','Calhoun');
INSERT INTO counties (state, description) VALUES ('WV','Clay');
INSERT INTO counties (state, description) VALUES ('WV','Doddridge');
INSERT INTO counties (state, description) VALUES ('WV','Fayette');
INSERT INTO counties (state, description) VALUES ('WV','Gilmer');
INSERT INTO counties (state, description) VALUES ('WV','Grant');
INSERT INTO counties (state, description) VALUES ('WV','Greenbrier');
INSERT INTO counties (state, description) VALUES ('WV','Hampshire');
INSERT INTO counties (state, description) VALUES ('WV','Hancock');
INSERT INTO counties (state, description) VALUES ('WV','Hardy');
INSERT INTO counties (state, description) VALUES ('WV','Harrison');
INSERT INTO counties (state, description) VALUES ('WV','Jackson');
INSERT INTO counties (state, description) VALUES ('WV','Jefferson');
INSERT INTO counties (state, description) VALUES ('WV','Kanawha');
INSERT INTO counties (state, description) VALUES ('WV','Lewis');
INSERT INTO counties (state, description) VALUES ('WV','Lincoln');
INSERT INTO counties (state, description) VALUES ('WV','Logan');
INSERT INTO counties (state, description) VALUES ('WV','Marion');
INSERT INTO counties (state, description) VALUES ('WV','Marshall');
INSERT INTO counties (state, description) VALUES ('WV','Mason');
INSERT INTO counties (state, description) VALUES ('WV','Mercer');
INSERT INTO counties (state, description) VALUES ('WV','Mineral');
INSERT INTO counties (state, description) VALUES ('WV','Mingo');
INSERT INTO counties (state, description) VALUES ('WV','Monogalia');
INSERT INTO counties (state, description) VALUES ('WV','Monroe');
INSERT INTO counties (state, description) VALUES ('WV','Morgan');
INSERT INTO counties (state, description) VALUES ('WV','McDowell');
INSERT INTO counties (state, description) VALUES ('WV','Nicholas');
INSERT INTO counties (state, description) VALUES ('WV','Ohio');
INSERT INTO counties (state, description) VALUES ('WV','Pendleton');
INSERT INTO counties (state, description) VALUES ('WV','Pleasants');
INSERT INTO counties (state, description) VALUES ('WV','Pocahontas');
INSERT INTO counties (state, description) VALUES ('WV','Preston');
INSERT INTO counties (state, description) VALUES ('WV','Putnam');
INSERT INTO counties (state, description) VALUES ('WV','Raleigh');
INSERT INTO counties (state, description) VALUES ('WV','Randolph');
INSERT INTO counties (state, description) VALUES ('WV','Ritchie');
INSERT INTO counties (state, description) VALUES ('WV','Roane');
INSERT INTO counties (state, description) VALUES ('WV','Summers');
INSERT INTO counties (state, description) VALUES ('WV','Taylor');
INSERT INTO counties (state, description) VALUES ('WV','Tucker');
INSERT INTO counties (state, description) VALUES ('WV','Tyler');
INSERT INTO counties (state, description) VALUES ('WV','Upshur');
INSERT INTO counties (state, description) VALUES ('WV','Wayne');
INSERT INTO counties (state, description) VALUES ('WV','Webster');
INSERT INTO counties (state, description) VALUES ('WV','Wetzel');
INSERT INTO counties (state, description) VALUES ('WV','Wirt');
INSERT INTO counties (state, description) VALUES ('WV','Wood');
INSERT INTO counties (state, description) VALUES ('WV','Wyoming');

--Units
INSERT INTO units (unit, squared, description) VALUES ('AC','Y','Acres');

--Tax ID Types
INSERT INTO tax_id_types (tax_id_type, description) VALUES ('SSN','Social Security Number');

/* vim: set sw=4 sts=4 et foldmethod=syntax : */