1 2 3 4 5 6
| DROP TRIGGER IF EXISTS `ccp_to_cac_insert_area`//
CREATE TRIGGER `ccp_to_cac_insert_area` AFTER INSERT ON `area`
FOR EACH ROW INSERT INTO `recette_cac`.cac_area (`id`,`city`, `country`, `status`, `reservation`, `automaton`, `ccp`, `address`, `nb_place`, `nb_available_place`, `state`, `created_at`)
SELECT `symfony-recette`.area.id, `symfony-recette`.interest_point.city, `symfony-recette`.interest_point.country, 1, 0, 1, 1, `symfony-recette`.interest_point.address1, `symfony-recette`.area.number_places, `symfony-recette`.area.disponibility, 1, NOW() FROM `symfony-recette`.area LEFT JOIN `symfony-recette`.interest_point ON `symfony-recette`.area.poi_id = `symfony-recette`.interest_point.id
ON DUPLICATE KEY UPDATE `recette_cac`.cac_area.city = `symfony-recette`.interest_point.city, `recette_cac`.cac_area.country = `symfony-recette`.interest_point.country, `recette_cac`.cac_area.address = `symfony-recette`.interest_point.address1, `recette_cac`.cac_area.nb_place = `symfony-recette`.area.number_places, `recette_cac`.cac_area.nb_available_place = `symfony-recette`.area.disponibility
// |
Partager