DELIMITER $$

DROP VIEW IF EXISTS `graphs`.`cat_agg_lin_view`$$

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `cat_agg_lin_view` AS select left(`series_m1ns`.`datemonth`,4) AS `datemonth`,`series_currns`.`lin` AS `currns`,`series_dddfcbns`.`lin` AS `dddfcbns`,`series_dddfoins`.`lin` AS `ddfoins`,`series_savingns`.`lin` AS `savingns`,`series_tcdns`.`lin` AS `tcdns`,`series_usgvddns`.`lin` AS `usgvddns`,`series_m1ns`.`lin` AS `m1ns`,`series_m2ns`.`lin` AS `m2ns`,`series_m3ns`.`lin` AS `m3ns`,`series_mzmns`.`lin` AS `mzmns`,(((((`series_currns`.`lin` + `series_dddfcbns`.`lin`) + `series_dddfoins`.`lin`) + `series_savingns`.`lin`) + `series_tcdns`.`lin`) + `series_usgvddns`.`lin`) AS `asms` from (((((((((`series_m1ns` left join `series_currns` on((`series_m1ns`.`datemonth` = `series_currns`.`datemonth`))) left join `series_dddfcbns` on((`series_m1ns`.`datemonth` = `series_dddfcbns`.`datemonth`))) left join `series_dddfoins` on((`series_m1ns`.`datemonth` = `series_dddfoins`.`datemonth`))) left join `series_savingns` on((`series_m1ns`.`datemonth` = `series_savingns`.`datemonth`))) left join `series_tcdns` on((`series_m1ns`.`datemonth` = `series_tcdns`.`datemonth`))) left join `series_usgvddns` on((`series_m1ns`.`datemonth` = `series_usgvddns`.`datemonth`))) left join `series_m2ns` on((`series_m1ns`.`datemonth` = `series_m2ns`.`datemonth`))) left join `series_m3ns` on((`series_m1ns`.`datemonth` = `series_m3ns`.`datemonth`))) left join `series_mzmns` on((`series_m1ns`.`datemonth` = `series_mzmns`.`datemonth`))) order by `series_currns`.`datemonth`$$

DELIMITER ;