8R3d5Ykw

1CREATE TABLE IF NOT EXISTS `route` (
2    `id`           INT(11) UNSIGNED AUTO_INCREMENT,
3    `name`         VARCHAR(255)                                    NOT NULL,
4    `country_id`   INT(11) UNSIGNED                                NOT NULL,
5    `locality_id`  INT(11) UNSIGNED                                NOT NULL,
6    `area_id`      INT(11) UNSIGNED                                NOT NULL,
7    `subarea_id`   INT(11) UNSIGNED                                NOT NULL,
8    `sector_id`    INT(11) UNSIGNED                                NOT NULL,
9    `grade_id`     INT(11) UNSIGNED                                NOT NULL,
10    `type`         ENUM ('rock', 'boulder', 'mountain', 'drytool') NOT NULL,
11    `protection`   VARCHAR(255) DEFAULT NULL,
12    `first_ascend` VARCHAR(255) DEFAULT NULL,
13    `length`       INT(11)      DEFAULT NULL,
14    `description`  TEXT         DEFAULT NULL,
15    `note`         TEXT         DEFAULT NULL,
16    `active`       TINYINT(1)   DEFAULT 1                          NOT NULL,
17    INDEX route_active_index (active),
18    PRIMARY KEY (`id`)
19)
20    ENGINE InnoDB
21    CHARACTER SET `utf8mb4`
22    COLLATE `utf8mb4_general_ci`;