INSERT INTO `amigotours`.`continent`
(id, `name`,
`name_en`,
`slug`,
`slug_en`)
SELECT id, `name`,
`name_en`,
`slug`,
`slug_en` FROM trekzy.continent;

INSERT INTO `amigotours`.`country`
(id, `code`,
`name`,
`name_en`,
`slug`,
`slug_en`,
`id_continent`)
SELECT id, `code`,
`name`,
`name_en`,
`slug`,
`slug_en`,
`id_continent` FROM trekzy.country;

INSERT INTO `amigotours`.`region`
(id, `name`,
`name_en`,
`abbreviation`,
`abbreviation_en`,
`id_country`,
`slug`,
`slug_en`)
SELECT id, `name`,
`name_en`,
`abbreviation`,
`abbreviation_en`,
`id_country`,
`slug`,
`slug_en` FROM trekzy.region;

INSERT INTO `amigotours`.`city`
(id, `name`,
`name_en`,
`id_region`,
`slug`,
`slug_en`,
`image`,
`is_zone`)
SELECT id, `name`,
`name_en`,
`id_region`,
`slug`,
`slug_en`,
`image`,
`is_zone` from trekzy.city;

INSERT INTO `amigotours`.`company`
(`id`,
`name`,
`comertial_name`,
`comertial_email`,
`financial_email`,
`booking_email`,
`is_active`,
`address`,
`isDefault`)
SELECT `id`,
`name`,
`comertial_name`,
`comertial_email`,
`financial_email`,
`booking_email`,
`is_active`,
`address`,
`isDefault` FROM trekzy.company;

INSERT INTO `amigotours`.`users_type`
(`id`,
`name`)
SELECT `id`,
`name` FROM trekzy.users_type;

INSERT INTO `amigotours`.`users_position` (`name`) VALUES ('default');
INSERT INTO `amigotours`.`company_branch` (`name`, `id_city`, `id_company`) VALUES ('CDMX', '1102', '1');

INSERT INTO `amigotours`.`users`
(`id`,
`email`,
`password`,
`name`,
`surname`,
`phone`,
`active`,
`approved`,
`id_company`,
`id_company_branch`,
`id_user_position`,
`id_user_type`,
`deleted`)
SELECT `id`,
`email`,
`password`,
`name`,
`surname`,
`phone`,
`active`,
`approved`,
`id_company`,
1,
1,
`id_user_type`,
`deleted` FROM trekzy.users;