summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-watchlist-null.sql
blob: d4869a0254f3557f3aa3663509c25895b695e6d0 (plain)
1
2
3
4
5
6
7
8
9
-- Set up wl_notificationtimestamp with NULL support.
-- 2005-08-17

ALTER TABLE /*$wgDBprefix*/watchlist
  CHANGE wl_notificationtimestamp wl_notificationtimestamp varbinary(14);

UPDATE /*$wgDBprefix*/watchlist
  SET wl_notificationtimestamp=NULL
  WHERE wl_notificationtimestamp='0';