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.
7 CREATE TABLE user_newtalk (
8 user_id int(5) NOT NULL default '0',
9 user_ip varchar(40) NOT NULL default '',
10 KEY user_id (user_id),
15 user_newtalk (user_id, user_ip)
18 WHERE user_newtalk != 0;
20 ALTER TABLE user DROP COLUMN user_newtalk;