DROP PROCEDURE IF EXISTS copy_ev_plan
//

CREATE PROCEDURE copy_ev_plan (IN xnew_id INT, IN xold_id INT)
BEGIN
    INSERT INTO fl_on_calendar_abs (cal_id, event_id, calendar_offset,
                                    event_time)
    SELECT cal_id, xnew_id, calendar_offset, event_time
      FROM fl_on_calendar_abs
     WHERE event_id = xold_id;

    INSERT INTO fl_on_calendar_neg (cal_id, event_id, calendar_offset,
                                    event_time)
    SELECT cal_id, xnew_id, calendar_offset, event_time
      FROM fl_on_calendar_neg
     WHERE event_id = xold_id;

    INSERT INTO fl_on_calendar_pos (cal_id, event_id, calendar_offset,
                                    event_time)
    SELECT cal_id, xnew_id, calendar_offset, event_time
      FROM fl_on_calendar_pos
     WHERE event_id = xold_id;

    INSERT INTO fl_once_abs (id, event_id, event_time)
    SELECT id, xnew_id, event_time
      FROM fl_once_abs
     WHERE event_id = xold_id;

    INSERT INTO fl_once_neg (id, event_id, event_time)
    SELECT id, xnew_id, event_time
      FROM fl_once_neg
     WHERE event_id = xold_id;

    INSERT INTO fl_once_pos (id, event_id, event_time)
    SELECT id, xnew_id, event_time
      FROM fl_once_pos
     WHERE event_id = xold_id;

    INSERT INTO fl_weekly_abs (event_id, cal_week_day, event_time)
    SELECT xnew_id, cal_week_day, event_time
      FROM fl_weekly_abs
     WHERE event_id = xold_id;

    INSERT INTO fl_weekly_pos (event_id, cal_week_day, event_time)
    SELECT xnew_id, cal_week_day, event_time
      FROM fl_weekly_pos
     WHERE event_id = xold_id;

    INSERT INTO fl_weekly_neg (event_id, cal_week_day, event_time)
    SELECT xnew_id, cal_week_day, event_time
      FROM fl_weekly_neg
     WHERE event_id = xold_id;

    INSERT INTO fl_monthly_abs (event_id, monthly_offset, event_time)
    SELECT xnew_id, monthly_offset, event_time
      FROM fl_monthly_abs
     WHERE event_id = xold_id;

    INSERT INTO fl_monthly_pos (event_id, monthly_offset, event_time)
    SELECT xnew_id, monthly_offset, event_time
      FROM fl_monthly_pos
     WHERE event_id = xold_id;

    INSERT INTO fl_monthly_neg (event_id, monthly_offset, event_time)
    SELECT xnew_id, monthly_offset, event_time
      FROM fl_monthly_neg
     WHERE event_id = xold_id;

    INSERT INTO fl_yearly_abs (event_id, yearly_offset, event_time)
    SELECT xnew_id, yearly_offset, event_time
      FROM fl_yearly_abs
     WHERE event_id = xold_id;

    INSERT INTO fl_yearly_pos (event_id, yearly_offset, event_time)
    SELECT xnew_id, yearly_offset, event_time
      FROM fl_yearly_pos
     WHERE event_id = xold_id;

    INSERT INTO fl_yearly_neg (event_id, yearly_offset, event_time)
    SELECT xnew_id, yearly_offset, event_time
      FROM fl_yearly_neg
     WHERE event_id = xold_id;

    INSERT INTO fl_monthly_work (event_id, offset, event_time)
    SELECT xnew_id, offset, event_time
      FROM fl_monthly_work
     WHERE event_id = xold_id;

    INSERT INTO fl_weekly_work (event_id, offset, event_time)
    SELECT xnew_id, offset, event_time
      FROM fl_weekly_work
     WHERE event_id = xold_id;

    INSERT INTO fl_yearly_work (event_id, offset, event_time)
    SELECT xnew_id, offset, event_time
      FROM fl_yearly_work
     WHERE event_id = xold_id;

    INSERT INTO fl_daily_nocal (event_id, event_time)
    SELECT xnew_id, event_time
      FROM fl_daily_nocal
     WHERE event_id = xold_id;

    INSERT INTO fl_daily_offcal (event_id, event_time)
    SELECT xnew_id, event_time
      FROM fl_daily_offcal
     WHERE event_id = xold_id;

    INSERT INTO fl_daily_oncal (event_id, event_time)
    SELECT xnew_id, event_time
      FROM fl_daily_oncal
     WHERE event_id = xold_id;

    INSERT INTO fl_yearly_date_abs (event_id, cal_month, cal_day, event_time)
    SELECT xnew_id, cal_month, cal_day, event_time
      FROM fl_yearly_date_abs
     WHERE event_id = xold_id;

    INSERT INTO fl_yearly_date_neg (event_id, cal_month, cal_day, event_time)
    SELECT xnew_id, cal_month, cal_day, event_time
      FROM fl_yearly_date_neg
     WHERE event_id = xold_id;

    INSERT INTO fl_yearly_date_pos (event_id, cal_month, cal_day, event_time)
    SELECT xnew_id, cal_month, cal_day, event_time
      FROM fl_yearly_date_pos
     WHERE event_id = xold_id;

    INSERT INTO fl_monthly_range_nocal (event_id, firstday,
                                        lastday, event_time)
    SELECT xnew_id, firstday, lastday, event_time
      FROM fl_monthly_range_nocal
     WHERE event_id = xold_id;

    INSERT INTO fl_monthly_range_offcal (event_id, firstday,
                                        lastday, event_time)
    SELECT xnew_id, firstday, lastday, event_time
      FROM fl_monthly_range_offcal
     WHERE event_id = xold_id;

    INSERT INTO fl_monthly_range_oncal (event_id, firstday,
                                        lastday, event_time)
    SELECT xnew_id, firstday, lastday, event_time
      FROM fl_monthly_range_oncal
     WHERE event_id = xold_id;

    INSERT INTO fl_nthday_abs (id, event_id, freq, event_time)
    SELECT id, xnew_id, freq, event_time
      FROM fl_nthday_abs
     WHERE event_id = xold_id;

    INSERT INTO fl_nthday_neg (id, event_id, freq, event_time)
    SELECT id, xnew_id, freq, event_time
      FROM fl_nthday_neg
     WHERE event_id = xold_id;

    INSERT INTO fl_nthday_pos (id, event_id, freq, event_time)
    SELECT id, xnew_id, freq, event_time
      FROM fl_nthday_pos
     WHERE event_id = xold_id;

END
//