-- Hang tuyen ngan

DELETE FROM haidv_hanghoa
WHERE thoigiannhanhanggui < '2016-12-31 23:59:59'
AND Id <> 0

-- Hang tuyen dai
DELETE FROM cargos
WHERE add_time < '2016-12-31 23:59:59'
AND id <> 0

-- Ve Cat Ba
DELETE FROM cb_reservations
WHERE timestamp < '2016-12-31 23:59:59'
AND id <> 0

-- Thong tin Chuyen Cat Ba
DELETE FROM cb_shift_info
WHERE Date < '2016-12-31 23:59:59'

-- Khoa chuyen HCM
DELETE FROM reports
WHERE timestamp < '2012-12-31 23:59:59'
AND rep_Id <> 0

-- Thong tin chuyen HCM
DELETE FROM shift_info
WHERE (Date < '2012-12-31 23:59:59' OR Date is NULL)
And id <> 0

-- Lich su He thong
DELETE FROM eticket_logs
WHERE date_done < '2017-12-31 23:59:59'
AND id <> 0