|
1. Create a table in MySQL using the SQL below.
2. Try to import the database using the reverse-eng tool
— SQL to generate DB ----
CREATE DATABASE test_wm;
USE test_wm;
CREATE TABLE `country` (
`id` varchar(4) NOT NULL,
`name` varchar(24) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `k_name` (`name`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT;
CREATE TABLE `city` (
`id` varchar(4) NOT NULL,
`country_id` varchar(4) NOT NULL,
`name` varchar(24) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (`country_id`) REFERENCES `country` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
UNIQUE INDEX `k_name` (`name`) USING BTREE ,
INDEX `fk_city_country_id` (`country_id`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT;
CREATE TABLE `resort` (
`city_id` varchar(4) NOT NULL,
PRIMARY KEY (`city_id`),
FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
INDEX `fk_from_city_city_id` (`city_id`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT;
|