SF.net SVN: frontierkernel: [1710] ODBs/trunk/frontierRoot/system/verbs/ builtins/mySql/data/States2Esql.fvc

[<cre...@us...>]

Revision: 1710
          http://frontierkernel.svn.sourceforge.net/frontierkernel/?rev=1710&view=rev
Author:   creecode
Date:     2007-07-02 20:14:34 -0700 (Mon, 02 Jul 2007)

Log Message:
-----------
replaced item with dump from mysqldump command line tool instead of CocoaMySQL

Modified Paths:
--------------
    ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/data/States2Esql.fvc

Modified: ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/data/States2Esql.fvc
===================================================================
--- ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/data/States2Esql.fvc	2007-07-03 02:46:10 UTC (rev 1709)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/data/States2Esql.fvc	2007-07-03 03:14:34 UTC (rev 1710)
@@ -1,19 +1,26 @@
 FrontierVcsFile:3:TEXT:system.verbs.builtins.mySql.data.["States.sql"]
 
-# data obtained from < http://en.wikipedia.org/wiki/List_of_capitals_in_the_United_States >
+-- data obtained from < http://en.wikipedia.org/wiki/List_of_capitals_in_the_United_States >
+--
+-- MySQL dump 10.9
+--
+-- Host: localhost    Database: States
+-- ------------------------------------------------------
+-- Server version	4.1.9-standard-log
 
-# CocoaMySQL dump
-# Version 0.5
-# http://cocoamysql.sourceforge.net
-#
-# Host: localhost (MySQL 4.1.9-standard-log)
-# Database: States
-# Generation Time: 2007-07-02 01:25:01 -0700
-# ************************************************************
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */;
 
-# Dump of table States
-# ------------------------------------------------------------
+--
+-- Table structure for table `States`
+--
 
+DROP TABLE IF EXISTS `States`;
 CREATE TABLE `States` (
   `State` varchar(32) NOT NULL default '',
   `Date_of_statehood` smallint(6) unsigned NOT NULL default '0',
@@ -24,58 +31,24 @@
   `Notes_on_current_capital` tinytext NOT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Alabama","1819","Montgomery","1846","No","200127","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Alaska","1959","Juneau","1906","No","30987","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Arizona","1912","Phoenix","1889","No","1475834","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Arkansas","1836","Little Rock","1836","No","184564","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("California","1850","Sacramento","1854","No","467343","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Colorado","1876","Denver","1867","No","566974","Denver City served as the capital of the Colorado Territory 1861-1862 and 1867-1876.");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Connecticut","1776","Hartford","1875","No","124397","Hartford also served as the capital 1639-1686 and 1689-1700, and as the co-capital with New Haven 1701-1875.");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Delaware","1776","Dover","1777","No","32135","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Florida","1845","Tallahassee","1824","No","156612","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Georgia","1776","Atlanta","1868","No","483108","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Hawaii","1959","Honolulu","1845","No","371657","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Idaho","1890","Boise","1865","No","216248","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Illinois","1818","Springfield","1839","No","111454","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Indiana","1816","Indianapolis","1825","No","791926","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Iowa","1846","Des Moines","1857","No","194163","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Kansas","1861","Topeka","1856","No","122327","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Kentucky","1792","Frankfort","1792","No","27741","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Louisiana","1812","Baton Rouge","1880","No","224097","Baton Rouge also served as the capital 1849-1862.");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Maine","1820","Augusta","1832","No","18560","Augusta was officially capital from 1827 but the legislature did not sit there until 1832.");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Maryland","1776","Annapolis","1694","No","36217","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Massachusetts","1776","Boston","1630","No","596368","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Michigan","1837","Lansing","1847","No","119128","Lansing is the only state capital that is not also the county seat of the county in which it is situated.");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Minnesota","1858","Saint Paul","1849","No","287151","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Mississippi","1817","Jackson","1821","No","184256","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Missouri","1821","Jefferson City","1826","No","39636","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Montana","1889","Helena","1889","No","25780","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Nebraska","1867","Lincoln","1867","No","225581","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Nevada","1864","Carson City","1861","No","57701","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("New Hampshire","1776","Concord","1808","No","42221","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("New Jersey","1776","Trenton","1784","No","84639","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("New Mexico","1912","Santa Fe","1610","No","70631","El Paso del Norte served as the capital of the Santa Fé de Nuevo Méjico colony-in-exile during the Pueblo Revolt of 1680-1692.");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("New York","1776","Albany","1797","No","95993","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("North Carolina","1776","Raleigh","1794","No","359332","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("North Dakota","1889","Bismarck","1883","No","55532","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Ohio","1803","Columbus","1816","No","730657","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Oklahoma","1907","Oklahoma City","1910","No","541500","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Oregon","1859","Salem","1855","No","149305","Salem first served as the capital in 1851, but Corvallis was briefly the capital in 1855.");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Pennsylvania","1776","Harrisburg","1812","No","48950","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Rhode Island","1776","Providence","1900","No","176862","Providence also served as the capital 1636-1686 and 1689-1776. It was one of five co-capitals 1776-1853, and one of two co-capitals 1853-1900.");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("South Carolina","1776","Columbia","1786","No","122819","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("South Dakota","1889","Pierre","1889","No","13876","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Tennessee","1796","Nashville","1826","No","607413","Nashville also served as the capital 1812-1818.");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Texas","1845","Austin","1839","No","690252","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Utah","1896","Salt Lake City","1858","No","181743","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Vermont","1791","Montpelier","1805","No","8035","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Virginia","1776","Richmond","1780","No","195251","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Washington","1889","Olympia","1853","No","42514","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("West Virginia","1863","Charleston","1885","No","52700","Charleston also served as the capital 1870-1875.");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Wisconsin","1848","Madison","1838","No","221551","");
-INSERT INTO `States` (`State`,`Date_of_statehood`,`Capital`,`Capital_since`,`Most populous city?`,`Population`,`Notes_on_current_capital`) VALUES ("Wyoming","1890","Cheyenne","1869","No","55362","");
+--
+-- Dumping data for table `States`
+--
 
 
+/*!40000 ALTER TABLE `States` DISABLE KEYS */;
+LOCK TABLES `States` WRITE;
+INSERT INTO `States` VALUES ('Alabama',1819,'Montgomery',1846,'No',200127,''),('Alaska',1959,'Juneau',1906,'No',30987,''),('Arizona',1912,'Phoenix',1889,'No',1475834,''),('Arkansas',1836,'Little Rock',1836,'No',184564,''),('California',1850,'Sacramento',1854,'No',467343,''),('Colorado',1876,'Denver',1867,'No',566974,'Denver City served as the capital of the Colorado Territory 1861-1862 and 1867-1876.'),('Connecticut',1776,'Hartford',1875,'No',124397,'Hartford also served as the capital 1639-1686 and 1689-1700, and as the co-capital with New Haven 1701-1875.'),('Delaware',1776,'Dover',1777,'No',32135,''),('Florida',1845,'Tallahassee',1824,'No',156612,''),('Georgia',1776,'Atlanta',1868,'No',483108,''),('Hawaii',1959,'Honolulu',1845,'No',371657,''),('Idaho',1890,'Boise',1865,'No',216248,''),('Illinois',1818,'Springfield',1839,'No',111454,''),('Indiana',1816,'Indianapolis',1825,'No',791926,''),('Iowa',1846,'Des Moines',1857,'No',194163,''),('Kansas',1861,'Topeka',1856,'No',122327,''),('Kentucky',1792,'Frankfort',1792,'No',27741,''),('Louisiana',1812,'Baton Rouge',1880,'No',224097,'Baton Rouge also served as the capital 1849-1862.'),('Maine',1820,'Augusta',1832,'No',18560,'Augusta was officially capital from 1827 but the legislature did not sit there until 1832.'),('Maryland',1776,'Annapolis',1694,'No',36217,''),('Massachusetts',1776,'Boston',1630,'No',596368,''),('Michigan',1837,'Lansing',1847,'No',119128,'Lansing is the only state capital that is not also the county seat of the county in which it is situated.'),('Minnesota',1858,'Saint Paul',1849,'No',287151,''),('Mississippi',1817,'Jackson',1821,'No',184256,''),('Missouri',1821,'Jefferson City',1826,'No',39636,''),('Montana',1889,'Helena',1889,'No',25780,''),('Nebraska',1867,'Lincoln',1867,'No',225581,''),('Nevada',1864,'Carson City',1861,'No',57701,''),('New Hampshire',1776,'Concord',1808,'No',42221,''),('New Jersey',1776,'Trenton',1784,'No',84639,''),('New Mexico',1912,'Santa Fe',1610,'No',70631,'El Paso del Norte served as the capital of the Santa Fé de Nuevo Méjico colony-in-exile during the Pueblo Revolt of 1680-1692.'),('New York',1776,'Albany',1797,'No',95993,''),('North Carolina',1776,'Raleigh',1794,'No',359332,''),('North Dakota',1889,'Bismarck',1883,'No',55532,''),('Ohio',1803,'Columbus',1816,'No',730657,''),('Oklahoma',1907,'Oklahoma City',1910,'No',541500,''),('Oregon',1859,'Salem',1855,'No',149305,'Salem first served as the capital in 1851, but Corvallis was briefly the capital in 1855.'),('Pennsylvania',1776,'Harrisburg',1812,'No',48950,''),('Rhode Island',1776,'Providence',1900,'No',176862,'Providence also served as the capital 1636-1686 and 1689-1776. It was one of five co-capitals 1776-1853, and one of two co-capitals 1853-1900.'),('South Carolina',1776,'Columbia',1786,'No',122819,''),('South Dakota',1889,'Pierre',1889,'No',13876,''),('Tennessee',1796,'Nashville',1826,'No',607413,'Nashville also served as the capital 1812-1818.'),('Texas',1845,'Austin',1839,'No',690252,''),('Utah',1896,'Salt Lake City',1858,'No',181743,''),('Vermont',1791,'Montpelier',1805,'No',8035,''),('Virginia',1776,'Richmond',1780,'No',195251,''),('Washington',1889,'Olympia',1853,'No',42514,''),('West Virginia',1863,'Charleston',1885,'No',52700,'Charleston also served as the capital 1870-1875.'),('Wisconsin',1848,'Madison',1838,'No',221551,''),('Wyoming',1890,'Cheyenne',1869,'No',55362,'');
+UNLOCK TABLES;
+/*!40000 ALTER TABLE `States` ENABLE KEYS */;
 
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 
 
+
+


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.