S0VV6x0U

1ALTER TABLE  `hotels` ADD FOREIGN KEY (  `city` )
2REFERENCES  `mydatabase`.`cities` (`id`)
3ON DELETE CASCADE ON UPDATE CASCADE ;
4	
5CREATE TABLE IF NOT EXISTS `cities` (
6  `id` int(11) NOT NULL AUTO_INCREMENT,
7  PRIMARY KEY (`id`)
8) ENGINE=InnoDB;
9
10
11CREATE TABLE IF NOT EXISTS `hotels` (
12  `id` int(11) NOT NULL AUTO_INCREMENT,
13  `city` bigint(20) DEFAULT NULL,
14  PRIMARY KEY (`id`),
15  KEY `city` (`city`)
16) ENGINE=InnoDB;
17	
18cities.id int(11)
19hotels.city bigint(20)
20	
21cities.id bigint(20)
22hotels.city bigint(20)
23	
24cities.id int(11)
25hotels.city int(11)