eWF3SAa1

1DELIMITER ;;
2CREATE DEFINER=`ops-team`@`%` PROCEDURE `daily_log_offers_2`()
3BEGIN  
4  
5CREATE TABLE IF NOT EXISTS `rep_ops_lls_DAILY_OFFERS_2` (
6`id` char(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
7`offer_id` int(4) unsigned NOT NULL,
8`property_id` int(4) unsigned NOT NULL,
9`rent` decimal(14,4) DEFAULT NULL,
10`avail` varchar(11) NOT NULL DEFAULT '',
11`price` varchar(11) NOT NULL DEFAULT '',
12`move-out` varchar(11) NOT NULL DEFAULT '',
13`ss` varchar(11) NOT NULL DEFAULT '',
14`rejected` varchar(11) NOT NULL DEFAULT '',
15`expired` varchar(11) NOT NULL DEFAULT '',
16`bonaparte` varchar(22) NOT NULL DEFAULT '', 
17`uniplaces_booking` varchar(3) NOT NULL DEFAULT '',
18`neighborhood` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
19`offer_type` enum('bedroom','entire-property','bed') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
20`status` varchar(12) DEFAULT NULL,
21`score` bigint(11) NOT NULL DEFAULT '0',
22`benchmark` varchar(25) NOT NULL DEFAULT '',
23`available_from` date DEFAULT NULL,
24`last_update` date DEFAULT NULL,
25`days_last_update` varchar(7) DEFAULT NULL,
26`contract_type` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
27`bills` varchar(16) NOT NULL DEFAULT '',
28`wifi` varchar(3) DEFAULT NULL,
29`minimum_nights` smallint(2) unsigned DEFAULT NULL,
30`resident_ap` varchar(3) NOT NULL DEFAULT '',
31`total_bookings_30` decimal(23,0) NOT NULL DEFAULT '0',
32`total_rejected_30` decimal(23,0) NOT NULL DEFAULT '0',
33`total_expired_30` decimal(23,0) NOT NULL DEFAULT '0',
34`total_accepted_30` decimal(23,0) NOT NULL DEFAULT '0',
35`total_awaiting` decimal(23,0) NOT NULL DEFAULT '0',
36`city` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
37`market` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''
38 ) ; 
39      TRUNCATE  rep_ops_lls_DAILY_OFFERS_2;
40  
41        INSERT  INTO rep_ops_lls_DAILY_OFFERS_2 
42        SELECT  ao.* 
43          FROM  rep_ops_ao_final_2 ao 
44     LEFT JOIN  rep_ops_lls_LANDLORDS_2 ll 
45            ON  ll.id = ao.id ;
46END;;
47DELIMITER ;