View Single Post
 
Old November 3rd, 2007, 02:13 AM
tks_muthu tks_muthu is offline
Authorized User
 
Join Date: Nov 2004
Location: CHENNAI, TamilNadu, India.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to tks_muthu
Default

CREATE TABLE `ayrshire_mini.countries` (
`cityname` varchar( 100 ) default '',
`capital` varchar( 75 ) default '',
`shown` int( 1 ) default '0',
`countrycode` char( 2 ) default NULL ,
`provincecode` char( 2 ) default NULL ,
`provincename` varchar( 100 ) default '',
`provincecountrycode` char( 2 ) default NULL ,
`countryname` varchar( 100 ) default '',
`Geog_loc` varchar( 100 ) default NULL ,
`area` varchar( 5 ) default NULL ,
`nationality` varchar( 100 ) default NULL ,
KEY `countryname` ( `countryname` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8;


Muthu