diff options
Diffstat (limited to 'etc')
-rw-r--r-- | etc/abbr_state.txt | 72 | ||||
-rw-r--r-- | etc/countries.txt | 239 | ||||
-rw-r--r-- | etc/domain-template.txt | 231 | ||||
-rwxr-xr-x | etc/megapop.pl | 116 | ||||
-rw-r--r-- | etc/sql-reserved-words.txt | 103 |
5 files changed, 761 insertions, 0 deletions
diff --git a/etc/abbr_state.txt b/etc/abbr_state.txt new file mode 100644 index 0000000..7e4f57f --- /dev/null +++ b/etc/abbr_state.txt @@ -0,0 +1,72 @@ +State/Possession Abbreviation + +ALABAMA AL +ALASKA AK +AMERICAN SAMOA AS +ARIZONA AZ +ARKANSAS AR +CALIFORNIA CA +COLORADO CO +CONNECTICUT CT +DELAWARE DE +DISTRICT OF COLUMBIA DC +FEDERATED STATES OF MICRONESIA FM +FLORIDA FL +GEORGIA GA +GUAM GU +HAWAII HI +IDAHO ID +ILLINOIS IL +INDIANA IN +IOWA IA +KANSAS KS +KENTUCKY KY +LOUISIANA LA +MAINE ME +MARSHALL ISLANDS MH +MARYLAND MD +MASSACHUSETTS MA +MICHIGAN MI +MINNESOTA MN +MISSISSIPPI MS +MISSOURI MO +MONTANA MT +NEBRASKA NE +NEVADA NV +NEW HAMPSHIRE NH +NEW JERSEY NJ +NEW MEXICO NM +NEW YORK NY +NORTH CAROLINA NC +NORTH DAKOTA ND +NORTHERN MARIANA ISLANDS MP +OHIO OH +OKLAHOMA OK +OREGON OR +PALAU PW +PENNSYLVANIA PA +PUERTO RICO PR +RHODE ISLAND RI +SOUTH CAROLINA SC +SOUTH DAKOTA SD +TENNESSEE TN +TEXAS TX +UTAH UT +VERMONT VT +VIRGIN ISLANDS VI +VIRGINIA VA +WASHINGTON WA +WEST VIRGINIA WV +WISCONSIN WI +WYOMING WY + + +Military "State" Abbreviation + +Armed Forces Africa AE +Armed Forces Americas AA +(except Canada) +Armed Forces Canada AE +Armed Forces Europe AE +Armed Forces Middle East AE +Armed Forces Pacific AP diff --git a/etc/countries.txt b/etc/countries.txt new file mode 100644 index 0000000..73c3975 --- /dev/null +++ b/etc/countries.txt @@ -0,0 +1,239 @@ +AFGHANISTAN AF AFG 004 +ALBANIA AL ALB 008 +ALGERIA DZ DZA 012 +AMERICAN SAMOA AS ASM 016 +ANDORRA AD AND 020 +ANGOLA AO AGO 024 +ANGUILLA AI AIA 660 +ANTARCTICA AQ ATA 010 +ANTIGUA AND BARBUDA AG ATG 028 +ARGENTINA AR ARG 032 +ARMENIA AM ARM 051 +ARUBA AW ABW 533 +AUSTRALIA AU AUS 036 +AUSTRIA AT AUT 040 +AZERBAIJAN AZ AZE 031 +BAHAMAS BS BHS 044 +BAHRAIN BH BHR 048 +BANGLADESH BD BGD 050 +BARBADOS BB BRB 052 +BELARUS BY BLR 112 +BELGIUM BE BEL 056 +BELIZE BZ BLZ 084 +BENIN BJ BEN 204 +BERMUDA BM BMU 060 +BHUTAN BT BTN 064 +BOLIVIA BO BOL 068 +BOSNIA AND HERZEGOWINA BA BIH 070 +BOTSWANA BW BWA 072 +BOUVET ISLAND BV BVT 074 +BRAZIL BR BRA 076 +BRITISH INDIAN OCEAN TERRITORY IO IOT 086 +BRUNEI DARUSSALAM BN BRN 096 +BULGARIA BG BGR 100 +BURKINA FASO BF BFA 854 +BURUNDI BI BDI 108 +CAMBODIA KH KHM 116 +CAMEROON CM CMR 120 +CANADA CA CAN 124 +CAPE VERDE CV CPV 132 +CAYMAN ISLANDS KY CYM 136 +CENTRAL AFRICAN REPUBLIC CF CAF 140 +CHAD TD TCD 148 +CHILE CL CHL 152 +CHINA CN CHN 156 +CHRISTMAS ISLAND CX CXR 162 +COCOS (KEELING) ISLANDS CC CCK 166 +COLOMBIA CO COL 170 +COMOROS KM COM 174 +CONGO CG COG 178 +COOK ISLANDS CK COK 184 +COSTA RICA CR CRI 188 +COTE D'IVOIRE CI CIV 384 +CROATIA (local name: Hrvatska) HR HRV 191 +CUBA CU CUB 192 +CYPRUS CY CYP 196 +CZECH REPUBLIC CZ CZE 203 +DENMARK DK DNK 208 +DJIBOUTI DJ DJI 262 +DOMINICA DM DMA 212 +DOMINICAN REPUBLIC DO DOM 214 +EAST TIMOR TP TMP 626 +ECUADOR EC ECU 218 +EGYPT EG EGY 818 +EL SALVADOR SV SLV 222 +EQUATORIAL GUINEA GQ GNQ 226 +ERITREA ER ERI 232 +ESTONIA EE EST 233 +ETHIOPIA ET ETH 231 +FALKLAND ISLANDS (MALVINAS) FK FLK 238 +FAROE ISLANDS FO FRO 234 +FIJI FJ FJI 242 +FINLAND FI FIN 246 +FRANCE FR FRA 250 +FRANCE, METROPOLITAN FX FXX 249 +FRENCH GUIANA GF GUF 254 +FRENCH POLYNESIA PF PYF 258 +FRENCH SOUTHERN TERRITORIES TF ATF 260 +GABON GA GAB 266 +GAMBIA GM GMB 270 +GEORGIA GE GEO 268 +GERMANY DE DEU 276 +GHANA GH GHA 288 +GIBRALTAR GI GIB 292 +GREECE GR GRC 300 +GREENLAND GL GRL 304 +GRENADA GD GRD 308 +GUADELOUPE GP GLP 312 +GUAM GU GUM 316 +GUATEMALA GT GTM 320 +GUINEA GN GIN 324 +GUINEA-BISSAU GW GNB 624 +GUYANA GY GUY 328 +HAITI HT HTI 332 +HEARD AND MC DONALD ISLANDS HM HMD 334 +HONDURAS HN HND 340 +HONG KONG HK HKG 344 +HUNGARY HU HUN 348 +ICELAND IS ISL 352 +INDIA IN IND 356 +INDONESIA ID IDN 360 +IRAN (ISLAMIC REPUBLIC OF) IR IRN 364 +IRAQ IQ IRQ 368 +IRELAND IE IRL 372 +ISRAEL IL ISR 376 +ITALY IT ITA 380 +JAMAICA JM JAM 388 +JAPAN JP JPN 392 +JORDAN JO JOR 400 +KAZAKHSTAN KZ KAZ 398 +KENYA KE KEN 404 +KIRIBATI KI KIR 296 +KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF KP PRK 408 +KOREA, REPUBLIC OF KR KOR 410 +KUWAIT KW KWT 414 +KYRGYZSTAN KG KGZ 417 +LAO PEOPLE'S DEMOCRATIC REPUBLIC LA LAO 418 +LATVIA LV LVA 428 +LEBANON LB LBN 422 +LESOTHO LS LSO 426 +LIBERIA LR LBR 430 +LIBYAN ARAB JAMAHIRIYA LY LBY 434 +LIECHTENSTEIN LI LIE 438 +LITHUANIA LT LTU 440 +LUXEMBOURG LU LUX 442 +MACAU MO MAC 446 +MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF MK MKD 807 +MADAGASCAR MG MDG 450 +MALAWI MW MWI 454 +MALAYSIA MY MYS 458 +MALDIVES MV MDV 462 +MALI ML MLI 466 +MALTA MT MLT 470 +MARSHALL ISLANDS MH MHL 584 +MARTINIQUE MQ MTQ 474 +MAURITANIA MR MRT 478 +MAURITIUS MU MUS 480 +MAYOTTE YT MYT 175 +MEXICO MX MEX 484 +MICRONESIA, FEDERATED STATES OF FM FSM 583 +MOLDOVA, REPUBLIC OF MD MDA 498 +MONACO MC MCO 492 +MONGOLIA MN MNG 496 +MONTSERRAT MS MSR 500 +MOROCCO MA MAR 504 +MOZAMBIQUE MZ MOZ 508 +MYANMAR MM MMR 104 +NAMIBIA NA NAM 516 +NAURU NR NRU 520 +NEPAL NP NPL 524 +NETHERLANDS NL NLD 528 +NETHERLANDS ANTILLES AN ANT 530 +NEW CALEDONIA NC NCL 540 +NEW ZEALAND NZ NZL 554 +NICARAGUA NI NIC 558 +NIGER NE NER 562 +NIGERIA NG NGA 566 +NIUE NU NIU 570 +NORFOLK ISLAND NF NFK 574 +NORTHERN MARIANA ISLANDS MP MNP 580 +NORWAY NO NOR 578 +OMAN OM OMN 512 +PAKISTAN PK PAK 586 +PALAU PW PLW 585 +PANAMA PA PAN 591 +PAPUA NEW GUINEA PG PNG 598 +PARAGUAY PY PRY 600 +PERU PE PER 604 +PHILIPPINES PH PHL 608 +PITCAIRN PN PCN 612 +POLAND PL POL 616 +PORTUGAL PT PRT 620 +PUERTO RICO PR PRI 630 +QATAR QA QAT 634 +REUNION RE REU 638 +ROMANIA RO ROM 642 +RUSSIAN FEDERATION RU RUS 643 +RWANDA RW RWA 646 +SAINT KITTS AND NEVIS KN KNA 659 +SAINT LUCIA LC LCA 662 +SAINT VINCENT AND THE GRENADINES VC VCT 670 +SAMOA WS WSM 882 +SAN MARINO SM SMR 674 +SAO TOME AND PRINCIPE ST STP 678 +SAUDI ARABIA SA SAU 682 +SENEGAL SN SEN 686 +SEYCHELLES SC SYC 690 +SIERRA LEONE SL SLE 694 +SINGAPORE SG SGP 702 +SLOVAKIA (Slovak Republic) SK SVK 703 +SLOVENIA SI SVN 705 +SOLOMON ISLANDS SB SLB 090 +SOMALIA SO SOM 706 +SOUTH AFRICA ZA ZAF 710 +SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS GS SGS 239 +SPAIN ES ESP 724 +SRI LANKA LK LKA 144 +ST. HELENA SH SHN 654 +ST. PIERRE AND MIQUELON PM SPM 666 +SUDAN SD SDN 736 +SURINAME SR SUR 740 +SVALBARD AND JAN MAYEN ISLANDS SJ SJM 744 +SWAZILAND SZ SWZ 748 +SWEDEN SE SWE 752 +SWITZERLAND CH CHE 756 +SYRIAN ARAB REPUBLIC SY SYR 760 +TAIWAN, PROVINCE OF CHINA TW TWN 158 +TAJIKISTAN TJ TJK 762 +TANZANIA, UNITED REPUBLIC OF TZ TZA 834 +THAILAND TH THA 764 +TOGO TG TGO 768 +TOKELAU TK TKL 772 +TONGA TO TON 776 +TRINIDAD AND TOBAGO TT TTO 780 +TUNISIA TN TUN 788 +TURKEY TR TUR 792 +TURKMENISTAN TM TKM 795 +TURKS AND CAICOS ISLANDS TC TCA 796 +TUVALU TV TUV 798 +UGANDA UG UGA 800 +UKRAINE UA UKR 804 +UNITED ARAB EMIRATES AE ARE 784 +UNITED KINGDOM GB GBR 826 +UNITED STATES US USA 840 +UNITED STATES MINOR OUTLYING ISLANDS UM UMI 581 +URUGUAY UY URY 858 +UZBEKISTAN UZ UZB 860 +VANUATU VU VUT 548 +VATICAN CITY STATE (HOLY SEE) VA VAT 336 +VENEZUELA VE VEN 862 +VIET NAM VN VNM 704 +VIRGIN ISLANDS (BRITISH) VG VGB 092 +VIRGIN ISLANDS (U.S.) VI VIR 850 +WALLIS AND FUTUNA ISLANDS WF WLF 876 +WESTERN SAHARA EH ESH 732 +YEMEN YE YEM 887 +YUGOSLAVIA YU YUG 891 +ZAIRE ZR ZAR 180 +ZAMBIA ZM ZMB 894 +ZIMBABWE ZW ZWE 716 diff --git a/etc/domain-template.txt b/etc/domain-template.txt new file mode 100644 index 0000000..8e4983c --- /dev/null +++ b/etc/domain-template.txt @@ -0,0 +1,231 @@ +[ URL ftp://rs.internic.net/templates/domain-template.txt ] [ 03/98 ] + +******* Please DO NOT REMOVE Version Number or Sections A-Q ******** + +Domain Version Number: 4.0 + +******* Email completed agreement to hostmaster@internic.net ******* + + NETWORK SOLUTIONS, INC. + + DOMAIN NAME REGISTRATION AGREEMENT + + +A. Introduction. This domain name registration agreement +("Registration Agreement") is submitted to NETWORK SOLUTIONS, INC. +("NSI") for the purpose of applying for and registering a domain name +on the Internet. If this Registration Agreement is accepted by NSI, +and a domain name is registered in NSI's domain name database and +assigned to the Registrant, Registrant ("Registrant") agrees to be +bound by the terms of this Registration Agreement and the terms of +NSI's Domain Name Dispute Policy ("Dispute Policy") which is +incorporated herein by reference and made a part of this Registration +Agreement. This Registration Agreement shall be accepted at the +offices of NSI. + +B. Fees and Payments. + +1) Registration or renewal (re-registration) date through March 31, 1998: +Registrant agrees to pay a registration fee of One Hundred United States +Dollars (US$100) as consideration for the registration of each new domain +name or Fifty United States Dollars (US$50) to renew (re-register) an +existing registration. +2) Registration or renewal date on and after April 1, 1998: Registrant +agrees to pay a registration fee of Seventy United States Dollars (US$70) +as consideration for the registration of each new domain name or the +applicable renewal (re-registration) fee (currently Thirty-Five United +States Dollars (US$35)) at the time of renewal (re-registration). +3) Period of Service: The non-refundable fee covers a period of two (2) +years for each new registration, and one (1) year for each renewal, +and includes any permitted modification(s) to the domain name record +during the covered period. +4) Payment: Payment is due to Network Solutions within thirty (30) +days from the date of the invoice. + +C. Dispute Policy. Registrant agrees, as a condition to +submitting this Registration Agreement, and if the Registration +Agreement is accepted by NSI, that the Registrant shall be bound by +NSI's current Dispute Policy. The current version of the Dispute +Policy may be found at the InterNIC Registration Services web site: +"http://www.netsol.com/rs/dispute-policy.html". + +D. Dispute Policy Changes or Modifications. Registrant agrees +that NSI, in its sole discretion, may change or modify the Dispute +Policy, incorporated by reference herein, at any time. Registrant +agrees that Registrant's maintaining the registration of a domain name +after changes or modifications to the Dispute Policy become effective +constitutes Registrant's continued acceptance of these changes or +modifications. Registrant agrees that if Registrant considers any such +changes or modifications to be unacceptable, Registrant may request +that the domain name be deleted from the domain name database. + +E. Disputes. Registrant agrees that, if the registration of its +domain name is challenged by any third party, the Registrant will be +subject to the provisions specified in the Dispute Policy. + +F. Agents. Registrant agrees that if this Registration Agreement +is completed by an agent for the Registrant, such as an ISP or +Administrative Contact/Agent, the Registrant is nonetheless bound as a +principal by all terms and conditions herein, including the Dispute +Policy. + +G. Limitation of Liability. Registrant agrees that NSI shall have +no liability to the Registrant for any loss Registrant may incur in +connection with NSI's processing of this Registration Agreement, in +connection with NSI's processing of any authorized modification to the +domain name's record during the covered period, as a result of the +Registrant's ISP's failure to pay either the initial registration fee +or renewal fee, or as a result of the application of the provisions of +the Dispute Policy. Registrant agrees that in no event shall the +maximum liability of NSI under this Agreement for any matter exceed +Five Hundred United States Dollars (US$500). + +H. Indemnity. Registrant agrees, in the event the Registration +Agreement is accepted by NSI and a subsequent dispute arises with any +third party, to indemnify and hold NSI harmless pursuant to the terms +and conditions contained in the Dispute Policy. + +I. Breach. Registrant agrees that failure to abide by any +provision of this Registration Agreement or the Dispute Policy may be +considered by NSI to be a material breach and that NSI may provide a +written notice, describing the breach, to the Registrant. If, within +thirty (30) days of the date of mailing such notice, the Registrant +fails to provide evidence, which is reasonably satisfactory to NSI, +that it has not breached its obligations, then NSI may delete +Registrant's registration of the domain name. Any such breach by a +Registrant shall not be deemed to be excused simply because NSI did +not act earlier in response to that, or any other, breach by the +Registrant. + +J. No Guaranty. Registrant agrees that, by registration of a +domain name, such registration does not confer immunity from objection +to either the registration or use of the domain name. + +K. Warranty. Registrant warrants by submitting this Registration +Agreement that, to the best of Registrant's knowledge and belief, the +information submitted herein is true and correct, and that any future +changes to this information will be provided to NSI in a timely manner +according to the domain name modification procedures in place at that +time. Breach of this warranty will constitute a material breach. + +L. Revocation. Registrant agrees that NSI may delete a +Registrant's domain name if this Registration Agreement, or subsequent +modification(s) thereto, contains false or misleading information, or +conceals or omits any information NSI would likely consider material +to its decision to approve this Registration Agreement. + +M. Right of Refusal. NSI, in its sole discretion, reserves the +right to refuse to approve the Registration Agreement for any +Registrant. Registrant agrees that the submission of this Registration +Agreement does not obligate NSI to accept this Registration Agreement. +Registrant agrees that NSI shall not be liable for loss or damages +that may result from NSI's refusal to accept this Registration +Agreement. + +N. Severability. Registrant agrees that the terms of this +Registration Agreement are severable. If any term or provision is +declared invalid, it shall not affect the remaining terms or +provisions which shall continue to be binding. + +O. Entirety. Registrant agrees that this Registration Agreement +and the Dispute Policy is the complete and exclusive agreement between +Registrant and NSI regarding the registration of Registrant's domain +name. This Registration Agreement and the Dispute Policy supersede all +prior agreements and understandings, whether established by custom, +practice, policy, or precedent. + +P. Governing Law. Registrant agrees that this Registration +Agreement shall be governed in all respects by and construed in +accordance with the laws of the Commonwealth of Virginia, United +States of America. By submitting this Registration Agreement, +Registrant consents to the exclusive jurisdiction and venue of the +United States District Court for the Eastern District of Virginia, +Alexandria Division. If there is no jurisdiction in the United States +District Court for the Eastern District of Virginia, Alexandria +Division, then jurisdiction shall be in the Circuit Court of Fairfax +County, Fairfax, Virginia. + +Q. This is Domain Name Registration Agreement Version +Number 4.0. This Registration Agreement is only for registrations +under top-level domains: COM, ORG, NET, and EDU. By completing +and submitting this Registration Agreement for consideration and +acceptance by NSI, the Registrant agrees that he/she has read and +agrees to be bound by A through P above. + + +Authorization +0a. (N)ew (M)odify (D)elete....:###action### +0b. Auth Scheme................: +0c. Auth Info..................: + +1. Comments...................:###purpose### + +2. Complete Domain Name.......:###domain### + +Organization Using Domain Name + +3a. Organization Name..........:###company### +###LOOP### +3b. Street Address.............:###address### +###ENDLOOP### +3c. City.......................:###city### +3d. State......................:###state### +3e. Postal Code................:###zip### +3f. Country....................:###country### + +Administrative Contact +4a. NIC Handle (if known)......: +4b. (I)ndividual (R)ole........:I +4c. Name (Last, First).........:###last###, ###first### +4d. Organization Name..........:###company### +###LOOP### +4e. Street Address.............:###address### +###ENDLOOP### +4f. City.......................:###city### +4g. State......................:###state### +4h. Postal Code................:###zip### +4i. Country....................:###country### +4j. Phone Number...............:###daytime### +4k. Fax Number.................:###fax### +4l. E-Mailbox..................:###email### + +Technical Contact +5a. NIC Handle (if known)......:###tech_contact### +5b. (I)ndividual (R)ole........: +5c. Name (Last, First).........: +5d. Organization Name..........: +5e. Street Address.............: +5f. City.......................: +5g. State......................: +5h. Postal Code................: +5i. Country....................: +5j. Phone Number...............: +5k. Fax Number.................: +5l. E-Mailbox..................: + +Billing Contact +6a. NIC Handle (if known)......: +6b. (I)ndividual (R)ole........: +6c. Name (Last, First).........: +6d. Organization Name..........: +6e. Street Address.............: +6f. City.......................: +6g. State......................: +6h. Postal Code................: +6i. Country....................: +6j. Phone Number...............: +6k. Fax Number.................: +6l. E-Mailbox..................: + +Prime Name Server +7a. Primary Server Hostname....:###primary### +7b. Primary Server Netaddress..:###primary_ip### + +Secondary Name Server(s) +###LOOP### +8a. Secondary Server Hostname..:###secondary### +8b. Secondary Server Netaddress:###secondary_ip### +###ENDLOOP### + +END OF AGREEMENT + diff --git a/etc/megapop.pl b/etc/megapop.pl new file mode 100755 index 0000000..b250bcd --- /dev/null +++ b/etc/megapop.pl @@ -0,0 +1,116 @@ +#!/usr/bin/perl -Tw +# +# $Id: megapop.pl,v 1.1 1999-04-19 10:32:44 ivan Exp $ +# +# this will break when megapop changes the URL or format of their listing page. +# that's stupid. perhaps they can provide a machine-readable listing? + +use strict; +use LWP::UserAgent; +use FS::UID qw(adminsuidsetup); +use FS::svc_acct_pop; + +my $url = "http://www.megapop.com/location.htm"; + +my $user = shift or die &usage; +adminsuidsetup($user); + +my %state2usps = &state2usps; +$state2usps{'WASHINGTON STATE'} = 'WA'; #megapop's on crack +$state2usps{'CANADA'} = 'CANADA'; #freeside's on crack + +my $ua = new LWP::UserAgent; +my $request = new HTTP::Request('GET', $url); +my $response = $ua->request($request); +die $response->error_as_HTML unless $response->is_success; +my $line; +my $usps = ''; +foreach $line ( split("\n", $response->content) ) { + if ( $line =~ /\W(\w[\w\s]*\w)\s+LOCATIONS/i ) { + $usps = $state2usps{uc($1)} + or warn "warning: unknown state $1\n"; + } elsif ( $line =~ /(\d{3})\-(\d{3})\-(\d{4})\s+(\w[\w\s]*\w)/ ) { + print "$1 $2 $3 $4 $usps\n"; + my $svc_acct_pop = new FS::svc_acct_pop ( { + 'city' => $4, + 'state' => $usps, + 'ac' => $1, + 'exch' => $2, + } ); + my $error = $svc_acct_pop->insert; + die $error if $error; + } +} + +sub usage { + die "Usage:\n $0 user\n"; +} + +sub state2usps{ ( + 'ALABAMA' => 'AL', + 'ALASKA' => 'AK', + 'AMERICAN SAMOA' => 'AS', + 'ARIZONA' => 'AZ', + 'ARKANSAS' => 'AR', + 'CALIFORNIA' => 'CA', + 'COLORADO' => 'CO', + 'CONNECTICUT' => 'CT', + 'DELAWARE' => 'DE', + 'DISTRICT OF COLUMBIA' => 'DC', + 'FEDERATED STATES OF MICRONESIA' => 'FM', + 'FLORIDA' => 'FL', + 'GEORGIA' => 'GA', + 'GUAM' => 'GU', + 'HAWAII' => 'HI', + 'IDAHO' => 'ID', + 'ILLINOIS' => 'IL', + 'INDIANA' => 'IN', + 'IOWA' => 'IA', + 'KANSAS' => 'KS', + 'KENTUCKY' => 'KY', + 'LOUISIANA' => 'LA', + 'MAINE' => 'ME', + 'MARSHALL ISLANDS' => 'MH', + 'MARYLAND' => 'MD', + 'MASSACHUSETTS' => 'MA', + 'MICHIGAN' => 'MI', + 'MINNESOTA' => 'MN', + 'MISSISSIPPI' => 'MS', + 'MISSOURI' => 'MO', + 'MONTANA' => 'MT', + 'NEBRASKA' => 'NE', + 'NEVADA' => 'NV', + 'NEW HAMPSHIRE' => 'NH', + 'NEW JERSEY' => 'NJ', + 'NEW MEXICO' => 'NM', + 'NEW YORK' => 'NY', + 'NORTH CAROLINA' => 'NC', + 'NORTH DAKOTA' => 'ND', + 'NORTHERN MARIANA ISLANDS' => 'MP', + 'OHIO' => 'OH', + 'OKLAHOMA' => 'OK', + 'OREGON' => 'OR', + 'PALAU' => 'PW', + 'PENNSYLVANIA' => 'PA', + 'PUERTO RICO' => 'PR', + 'RHODE ISLAND' => 'RI', + 'SOUTH CAROLINA' => 'SC', + 'SOUTH DAKOTA' => 'SD', + 'TENNESSEE' => 'TN', + 'TEXAS' => 'TX', + 'UTAH' => 'UT', + 'VERMONT' => 'VT', + 'VIRGIN ISLANDS' => 'VI', + 'VIRGINIA' => 'VA', + 'WASHINGTON' => 'WA', + 'WEST VIRGINIA' => 'WV', + 'WISCONSIN' => 'WI', + 'WYOMING' => 'WY', + 'ARMED FORCES AFRICA' => 'AE', + 'ARMED FORCES AMERICAS' => 'AA', + 'ARMED FORCES CANADA' => 'AE', + 'ARMED FORCES EUROPE' => 'AE', + 'ARMED FORCES MIDDLE EAST' => 'AE', + 'ARMED FORCES PACIFIC' => 'AP', +) } + diff --git a/etc/sql-reserved-words.txt b/etc/sql-reserved-words.txt new file mode 100644 index 0000000..dc507ce --- /dev/null +++ b/etc/sql-reserved-words.txt @@ -0,0 +1,103 @@ +From http://epoch.cs.berkeley.edu:8000/sequoia/dba/montage/FAQ/SQL.html + by Jean Anderson (jta@postgres.berkeley.edu) + +What are the SQL reserved words? + +I grep'd the following list out of the sql docs available via anonymous ftp to speckle.ncsl.nist.gov:/isowg3. +SQL3 words are not set in stone, but you'd do well to avoid them. + + From sql1992.txt: + + AFTER, ALIAS, ASYNC, BEFORE, BOOLEAN, BREADTH, + COMPLETION, CALL, CYCLE, DATA, DEPTH, DICTIONARY, EACH, ELSEIF, + EQUALS, GENERAL, IF, IGNORE, LEAVE, LESS, LIMIT, LOOP, MODIFY, + NEW, NONE, OBJECT, OFF, OID, OLD, OPERATION, OPERATORS, OTHERS, + PARAMETERS, PENDANT, PREORDER, PRIVATE, PROTECTED, RECURSIVE, REF, + REFERENCING, REPLACE, RESIGNAL, RETURN, RETURNS, ROLE, ROUTINE, + ROW, SAVEPOINT, SEARCH, SENSITIVE, SEQUENCE, SIGNAL, SIMILAR, + SQLEXCEPTION, SQLWARNING, STRUCTURE, TEST, THERE, TRIGGER, TYPE, + UNDER, VARIABLE, VIRTUAL, VISIBLE, WAIT, WHILE, WITHOUT + + From sql1992.txt (Annex E): + + ABSOLUTE, ACTION, ADD, ALLOCATE, ALTER, ARE, ASSERTION, AT, BETWEEN, + BIT, BIT + +What are the SQL reserved words? + +I grep'd the following list out of the sql docs available via anonymous ftp to speckle.ncsl.nist.gov:/isowg3. +SQL3 words are not set in stone, but you'd do well to avoid them. + + From sql1992.txt: + + AFTER, ALIAS, ASYNC, BEFORE, BOOLEAN, BREADTH, + COMPLETION, CALL, CYCLE, DATA, DEPTH, DICTIONARY, EACH, ELSEIF, + EQUALS, GENERAL, IF, IGNORE, LEAVE, LESS, LIMIT, LOOP, MODIFY, + NEW, NONE, OBJECT, OFF, OID, OLD, OPERATION, OPERATORS, OTHERS, + PARAMETERS, PENDANT, PREORDER, PRIVATE, PROTECTED, RECURSIVE, REF, + REFERENCING, REPLACE, RESIGNAL, RETURN, RETURNS, ROLE, ROUTINE, + ROW, SAVEPOINT, SEARCH, SENSITIVE, SEQUENCE, SIGNAL, SIMILAR, + SQLEXCEPTION, SQLWARNING, STRUCTURE, TEST, THERE, TRIGGER, TYPE, + UNDER, VARIABLE, VIRTUAL, VISIBLE, WAIT, WHILE, WITHOUT + + From sql1992.txt (Annex E): + + ABSOLUTE, ACTION, ADD, ALLOCATE, ALTER, ARE, ASSERTION, AT, BETWEEN, + BIT, BIT + +What are the SQL reserved words? + +I grep'd the following list out of the sql docs available via anonymous ftp to speckle.ncsl.nist.gov:/isowg3. +SQL3 words are not set in stone, but you'd do well to avoid them. + + From sql1992.txt: + + AFTER, ALIAS, ASYNC, BEFORE, BOOLEAN, BREADTH, + COMPLETION, CALL, CYCLE, DATA, DEPTH, DICTIONARY, EACH, ELSEIF, + EQUALS, GENERAL, IF, IGNORE, LEAVE, LESS, LIMIT, LOOP, MODIFY, + NEW, NONE, OBJECT, OFF, OID, OLD, OPERATION, OPERATORS, OTHERS, + PARAMETERS, PENDANT, PREORDER, PRIVATE, PROTECTED, RECURSIVE, REF, + REFERENCING, REPLACE, RESIGNAL, RETURN, RETURNS, ROLE, ROUTINE, + ROW, SAVEPOINT, SEARCH, SENSITIVE, SEQUENCE, SIGNAL, SIMILAR, + SQLEXCEPTION, SQLWARNING, STRUCTURE, TEST, THERE, TRIGGER, TYPE, + UNDER, VARIABLE, VIRTUAL, VISIBLE, WAIT, WHILE, WITHOUT + + From sql1992.txt (Annex E): + + ABSOLUTE, ACTION, ADD, ALLOCATE, ALTER, ARE, ASSERTION, AT, BETWEEN, + BIT, BIT_LENGTH, BOTH, CASCADE, CASCADED, CASE, CAST, CATALOG, + CHAR_LENGTH, CHARACTER_LENGTH, COALESCE, COLLATE, COLLATION, COLUMN, + CONNECT, CONNECTION, CONSTRAINT, CONSTRAINTS, CONVERT, CORRESPONDING, + CROSS, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, + DATE, DAY, DEALLOCATE, DEFERRABLE, DEFERRED, DESCRIBE, DESCRIPTOR, + DIAGNOSTICS, DISCONNECT, DOMAIN, DROP, ELSE, END-EXEC, EXCEPT, + EXCEPTION, EXECUTE, EXTERNAL, EXTRACT, FALSE, FIRST, FULL, GET, + GLOBAL, HOUR, IDENTITY, IMMEDIATE, INITIALLY, INNER, INPUT, + INSENSITIVE, INTERSECT, INTERVAL, ISOLATION, JOIN, LAST, LEADING, + LEFT, LEVEL, LOCAL, LOWER, MATCH, MINUTE, MONTH, NAMES, NATIONAL, + NATURAL, NCHAR, NEXT, NO, NULLIF, OCTET_LENGTH, ONLY, OUTER, OUTPUT, + OVERLAPS, PAD, PARTIAL, POSITION, PREPARE, PRESERVE, PRIOR, READ, + RELATIVE, RESTRICT, REVOKE, RIGHT, ROWS, SCROLL, SECOND, SESSION, + SESSION_USER, SIZE, SPACE, SQLSTATE, SUBSTRING, SYSTEM_USER, + TEMPORARY, THEN, TIME, TIMESTAMP, TIMEZONE_HOUR, TIMEZONE_MINUTE, + TRAILING, TRANSACTION, TRANSLATE, TRANSLATION, TRIM, TRUE, UNKNOWN, + UPPER, USAGE, USING, VALUE, VARCHAR, VARYING, WHEN, WRITE, YEAR, ZONE + + From sql3part2.txt (Annex E) + + ACTION, ACTOR, AFTER, ALIAS, ASYNC, ATTRIBUTES, BEFORE, BOOLEAN, + BREADTH, COMPLETION, CURRENT_PATH, CYCLE, DATA, DEPTH, DESTROY, + DICTIONARY, EACH, ELEMENT, ELSEIF, EQUALS, FACTOR, GENERAL, HOLD, + IGNORE, INSTEAD, LESS, LIMIT, LIST, MODIFY, NEW, NEW_TABLE, NO, + NONE, OFF, OID, OLD, OLD_TABLE, OPERATION, OPERATOR, OPERATORS, + PARAMETERS, PATH, PENDANT, POSTFIX, PREFIX, PREORDER, PRIVATE, + PROTECTED, RECURSIVE, REFERENCING, REPLACE, ROLE, ROUTINE, ROW, + SAVEPOINT, SEARCH, SENSITIVE, SEQUENCE, SESSION, SIMILAR, SPACE, + SQLEXCEPTION, SQLWARNING, START, STATE, STRUCTURE, SYMBOL, TERM, + TEST, THERE, TRIGGER, TYPE, UNDER, VARIABLE, VIRTUAL, VISIBLE, + WAIT, WITHOUT + + sql3part4.txt (ANNEX E): + + CALL, DO, ELSEIF, EXCEPTION, IF, LEAVE, LOOP, OTHERS, RESIGNAL, + RETURN, RETURNS, SIGNAL, TUPLE, WHILE |