165815 Simple data project

Devam Ediyor İlan edilme: Sep 15, 2007 Teslim sırasında ödenir
Devam Ediyor Teslim sırasında ödenir

Maximum: $10

I need city lists of Portugal and Brazil.

The lists should be in SQL format.

The DB tables are attached.

Explanation:

1- You should enter a company with name Portugal in table countries

2- Enter all districts of portugal in the districts table with countryid from the countries table

3- Enter all cities of all districts of portugal in the cities table with districtid from the districts table

4- Do the same for Brazil

Note: Take care of special portuguese letters

CREATE TABLE `cities`

(

`id` int(20) NOT NULL auto_increment,

`name` varchar(200) NOT NULL,

`districtid` int(20) NOT NULL,

PRIMARY KEY (`id`),

KEY `districtid` (`districtid`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

CREATE TABLE `countries` (

`id` int(20) NOT NULL auto_increment,

`name` varchar(200) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

CREATE TABLE `districts` (

`id` int(20) NOT NULL auto_increment,

`name` varchar(200) NOT NULL,

`countryid` int(20) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

Veri Girişi Odd Jobs SQL

Proje NO: #1912006

Proje hakkında

Uzak proje Aktif Jul 11, 2012