[Summary view] [Print] [Text view]

   1  --- This table stores all the IDs of users whose talk
   2  --- page has been changed (the respective row is deleted
   3  --- when the user looks at the page).
   4  --- The respective column in the user table is no longer
   5  --- required and therefore dropped.
   6  
   7  CREATE TABLE /*$wgDBprefix*/user_newtalk (
   8    user_id int NOT NULL default '0',
   9    user_ip varbinary(40) NOT NULL default '',
  10    KEY user_id (user_id),
  11    KEY user_ip (user_ip)
  12  ) /*$wgDBTableOptions*/;
  13  
  14  INSERT INTO
  15    /*$wgDBprefix*/user_newtalk (user_id, user_ip)
  16    SELECT user_id, ''
  17      FROM user
  18      WHERE user_newtalk != 0;
  19  
  20  ALTER TABLE /*$wgDBprefix*/user DROP COLUMN user_newtalk;