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

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

Revision: 1714
          http://frontierkernel.svn.sourceforge.net/frontierkernel/?rev=1714&view=rev
Author:   creecode
Date:     2007-07-10 19:08:31 -0700 (Tue, 10 Jul 2007)

Log Message:
-----------
renamed 'Most populous city?' field to Most_populous_city?, consistent with other fields

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-10 19:54:16 UTC (rev 1713)
+++ ODBs/trunk/frontierRoot/system/verbs/builtins/mySql/data/States2Esql.fvc	2007-07-11 02:08:31 UTC (rev 1714)
@@ -1,20 +1,23 @@
 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 >
+
+-- MySQL dump 10.11
 --
--- MySQL dump 10.9
---
 -- Host: localhost    Database: States
 -- ------------------------------------------------------
--- Server version	4.1.9-standard-log
+-- Server version	5.0.37
 
 /*!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 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
 /*!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" */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
 --
 -- Table structure for table `States`
@@ -26,7 +29,7 @@
   `Date_of_statehood` smallint(6) unsigned NOT NULL default '0',
   `Capital` varchar(32) NOT NULL default '',
   `Capital_since` smallint(6) unsigned NOT NULL default '0',
-  `Most populous city?` enum('Yes','No') NOT NULL default 'No',
+  `Most_populous_city?` enum('Yes','No') NOT NULL default 'No',
   `Population` mediumint(8) unsigned NOT NULL default '0',
   `Notes_on_current_capital` tinytext NOT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
@@ -35,12 +38,12 @@
 -- Dumping data for table `States`
 --
 
-
+LOCK TABLES `States` WRITE;
 /*!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,'');
+/*!40000 ALTER TABLE `States` ENABLE KEYS */;
 UNLOCK TABLES;
-/*!40000 ALTER TABLE `States` ENABLE KEYS */;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
@@ -48,7 +51,9 @@
 /*!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 */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
+-- Dump completed on 2007-07-11  1:49:51
 
 
 


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