36 lines
1.0 KiB
Plaintext
36 lines
1.0 KiB
Plaintext
UPDATE `Availability`
|
|
SET
|
|
`startTime` = ADDTIME(`startTime`, '01:00:00'),
|
|
`endTime` = ADDTIME(`endTime`, '01:00:00'),
|
|
`name` = CONCAT(`name`, ' (DHT)')
|
|
WHERE
|
|
`startTime` LIKE '%05:00%' -- this is 9:00; -4 hours difference, where -3 is expected
|
|
OR `startTime` LIKE '%06:30%' -- this is 10:30; -4 hours difference, where -3 is expected
|
|
OR `startTime` LIKE '%08:00%' -- this is 12:00; -4 hours difference, where -3 is expected
|
|
OR `startTime` LIKE '%09:30%' -- this is 13:30 UTC
|
|
OR `startTime` LIKE '%11:00%' -- this is 15:00 UTC
|
|
OR `startTime` LIKE '%12:30%' -- this is 16:30 UTC
|
|
OR `startTime` LIKE '%14:00%' -- this is 18:00 UTC
|
|
|
|
SELECT
|
|
p.id,
|
|
p.firstName,
|
|
p.lastName,
|
|
a.id,
|
|
name,
|
|
dayofweek,
|
|
startTime,
|
|
endTime,
|
|
dayOfMonth,
|
|
weekOfMonth,
|
|
isFromPreviousAssignment,
|
|
isFromPreviousMonth,
|
|
endDate,
|
|
repeatWeekly,
|
|
dateOfEntry,
|
|
parentAvailabilityId
|
|
FROM
|
|
`Availability` a
|
|
left join Publisher p on p.id = publisherId
|
|
WHERE
|
|
name LIKE '%(DHT)%' |