165815 Simple data project
N/A
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 ;
Proje NO: #1912006