GeezerVison is showing static-codereview.wikimedia.org — r33552 MediaWiki - Code Review archive
r33552 MediaWiki - Code Review archive
| Repository: | MediaWiki |
| Revision: | < r33551 | r33552 | r33553 > |
| Date: | 15:21, 18 April 2008 |
| Author: | greg |
| Status: | old |
| Tags: | |
| Comment: | Add user_last_timestamp column to user_newtalk table |
| Modified paths: |
- /trunk/phase3/maintenance/postgres/tables.sql (modified) (history)
- /trunk/phase3/maintenance/updaters.inc (modified) (history)
|
| 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 | |
Status & tagging log
- 15:26, 12 September 2011 Meno25 (talk | contribs) changed the status of r33552 [removed: ok added: old]