Re: [MRBS-general] moving all bookings forward 1 week

[John B. <jo...@re...>]

Flowers Jon wrote:
> Hi
> 
>  
> 
> I know some basic sql but not enough. Is there a query I can run that
> will move all existing bookings forward 1 week? At our school we work to
> a bi-weekly rota so after half term all the bookings that have been put
> in are the wrong week. Any help would be appreciated.

Replace the XX-XX bits below with the start of your new term.
(It's MM-DD)

UPDATE mrbs_entry SET start_time=start_time+604800, end_time=end_time+604800
WHERE start_time >= UNIX_TIMESTAMP('2007-XX-XX 00:00:00');

UPDATE mrbs_repeat SET start_time=start_time+604800,
end_time=end_time+604800 WHERE start_time >= UNIX_TIMESTAMP('2007-XX-XX
00:00:00');


John.

-- 
John Beranek                         To generalise is to be an idiot.
http://redux.org.uk/                                 -- William Blake