1 CREATE TABLE /*_*/watchlist_tmp (
2 wl_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
3 wl_user INTEGER UNSIGNED NOT NULL,
4 wl_namespace INTEGER DEFAULT 0 NOT NULL,
5 wl_title BLOB DEFAULT '' NOT NULL,
6 wl_notificationtimestamp BLOB DEFAULT NULL
9 INSERT INTO /*_*/watchlist_tmp
10 SELECT wl_id, wl_user, wl_namespace, wl_title, wl_notificationtimestamp
12 DROP TABLE /*_*/watchlist;
13 ALTER TABLE /*_*/watchlist_tmp RENAME TO /*_*/watchlist;
15 CREATE UNIQUE INDEX wl_user ON /*_*/watchlist (wl_user, wl_namespace, wl_title);
17 CREATE INDEX namespace_title ON /*_*/watchlist (wl_namespace, wl_title);
19 CREATE INDEX wl_user_notificationtimestamp ON /*_*/watchlist (
20 wl_user, wl_notificationtimestamp