Index: openacs-4/packages/acs-reference/sql/common/us-states.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/common/Attic/us-states.sql,v diff -u -N --- openacs-4/packages/acs-reference/sql/common/us-states.sql 17 Jul 2001 05:03:55 -0000 1.2 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,78 +0,0 @@ --- packages/acs-reference/sql/common/us-states.sql --- --- @author jon@jongriffin.com --- @creation-date 2000-11-28 --- @cvs-id $Id: us-states.sql,v 1.2 2001/07/17 05:03:55 jong Exp $ - -insert into us_states values ('AL','ALABAMA','01'); -insert into us_states values ('AK','ALASKA','02'); -insert into us_states values ('AZ','ARIZONA','04'); -insert into us_states values ('AR','ARKANSAS','05'); -insert into us_states values ('CA','CALIFORNIA','06'); -insert into us_states values ('CO','COLORADO','08'); -insert into us_states values ('CT','CONNECTICUT','09'); -insert into us_states values ('DE','DELAWARE','10'); -insert into us_states values ('DC','DISTRICT OF COLUMBIA','11'); -insert into us_states values ('FL','FLORIDA','12'); -insert into us_states values ('GA','GEORGIA','13'); -insert into us_states values ('HI','HAWAII','15'); -insert into us_states values ('ID','IDAHO','16'); -insert into us_states values ('IL','ILLINOIS','17'); -insert into us_states values ('IN','INDIANA','18'); -insert into us_states values ('IA','IOWA','19'); -insert into us_states values ('KS','KANSAS','20'); -insert into us_states values ('KY','KENTUCKY','21'); -insert into us_states values ('LA','LOUISIANA','22'); -insert into us_states values ('ME','MAINE','23'); -insert into us_states values ('MD','MARYLAND','24'); -insert into us_states values ('MA','MASSACHUSETTS','25'); -insert into us_states values ('MI','MICHIGAN','26'); -insert into us_states values ('MN','MINNESOTA','27'); -insert into us_states values ('MS','MISSISSIPPI','28'); -insert into us_states values ('MO','MISSOURI','29'); -insert into us_states values ('MT','MONTANA','30'); -insert into us_states values ('NE','NEBRASKA','31'); -insert into us_states values ('NV','NEVADA','32'); -insert into us_states values ('NH','NEW HAMPSHIRE','33'); -insert into us_states values ('NJ','NEW JERSEY','34'); -insert into us_states values ('NM','NEW MEXICO','35'); -insert into us_states values ('NY','NEW YORK','36'); -insert into us_states values ('NC','NORTH CAROLINA','37'); -insert into us_states values ('ND','NORTH DAKOTA','38'); -insert into us_states values ('OH','OHIO','39'); -insert into us_states values ('OK','OKLAHOMA','40'); -insert into us_states values ('OR','OREGON','41'); -insert into us_states values ('PA','PENNSYLVANIA','42'); -insert into us_states values ('RI','RHODE ISLAND','44'); -insert into us_states values ('SC','SOUTH CAROLINA','45'); -insert into us_states values ('SD','SOUTH DAKOTA','46'); -insert into us_states values ('TN','TENNESSEE','47'); -insert into us_states values ('TX','TEXAS','48'); -insert into us_states values ('UT','UTAH','49'); -insert into us_states values ('VT','VERMONT','50'); -insert into us_states values ('VA','VIRGINIA','51'); -insert into us_states values ('WA','WASHINGTON','53'); -insert into us_states values ('WV','WEST VIRGINIA','54'); -insert into us_states values ('WI','WISCONSIN','55'); -insert into us_states values ('WY','WYOMING','56'); -insert into us_states values ('AS','AMERICAN SAMOA','60'); -insert into us_states values ('GU','GUAM','66'); -insert into us_states values ('MP','NORTHERN MARIANA ISLANDS','69'); -insert into us_states values ('PR','PUERTO RICO','72'); -insert into us_states values ('VI','VIRGIN ISLANDS','78'); -insert into us_states values ('FM','FED. STATES OF MICRONESIA','64'); -insert into us_states values ('UM','US MINOR OUTLYING ISLANDS','74'); -insert into us_states values ('67','JOHNSTON ATOLL','67'); -insert into us_states values ('MH','MARSHALL ISLANDS','68'); -insert into us_states values ('PW','PALAU','70'); -insert into us_states values ('71','MIDWAY ISLANDS','71'); -insert into us_states values ('76','NAVASSA ISLAND','76'); -insert into us_states values ('79','WAKE ISLAND','79'); -insert into us_states values ('81','BAKER ISLAND','81'); -insert into us_states values ('84','HOWLAND ISLAND','84'); -insert into us_states values ('86','JARVIS ISLAND','86'); -insert into us_states values ('89','KINGMAN REEF','89'); -insert into us_states values ('95','PALMYRA ATOLL','95'); - -commit; -