maintenance/archives/patch-watchlist-null.sql


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 varchar(14) binary;

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