| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -40,8 +40,9 @@ |
| 41 | 41 | CREATE UNIQUE INDEX user_groups_unique ON user_groups (ug_user, ug_group); |
| 42 | 42 | |
| 43 | 43 | CREATE TABLE user_newtalk ( |
| 44 | | - user_id INTEGER NOT NULL REFERENCES mwuser(user_id) ON DELETE CASCADE, |
| 45 | | - user_ip TEXT NULL |
| | 44 | + user_id INTEGER NOT NULL REFERENCES mwuser(user_id) ON DELETE CASCADE, |
| | 45 | + user_ip TEXT NULL, |
| | 46 | + user_last_timestamp TIMESTAMPTZ |
| 46 | 47 | ); |
| 47 | 48 | CREATE INDEX user_newtalk_id_idx ON user_newtalk (user_id); |
| 48 | 49 | CREATE INDEX user_newtalk_ip_idx ON user_newtalk (user_ip); |
| Index: trunk/phase3/maintenance/updaters.inc |
| — | — | @@ -1407,6 +1407,7 @@ |
| 1408 | 1408 | array("recentchanges", "rc_params", "TEXT"), |
| 1409 | 1409 | array("revision", "rev_len", "INTEGER"), |
| 1410 | 1410 | array("revision", "rev_deleted", "SMALLINT NOT NULL DEFAULT 0"), |
| | 1411 | + array("user_newtalk", "user_last_timestamp", "TIMESTAMPTZ"), |
| 1411 | 1412 | ); |
| 1412 | 1413 | |
| 1413 | 1414 | |