From e73e14cf4e6c7a26e7fb17a1ea30040b95c84cb5 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Fri, 18 Apr 2008 15:21:24 +0000 Subject: [PATCH] Add user_last_timestamp column to user_newtalk table --- maintenance/postgres/tables.sql | 5 +++-- maintenance/updaters.inc | 1 + 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index e6648f5cb0..faf1cd1309 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -40,8 +40,9 @@ CREATE TABLE user_groups ( CREATE UNIQUE INDEX user_groups_unique ON user_groups (ug_user, ug_group); CREATE TABLE user_newtalk ( - user_id INTEGER NOT NULL REFERENCES mwuser(user_id) ON DELETE CASCADE, - user_ip TEXT NULL + user_id INTEGER NOT NULL REFERENCES mwuser(user_id) ON DELETE CASCADE, + user_ip TEXT NULL, + user_last_timestamp TIMESTAMPTZ ); CREATE INDEX user_newtalk_id_idx ON user_newtalk (user_id); CREATE INDEX user_newtalk_ip_idx ON user_newtalk (user_ip); diff --git a/maintenance/updaters.inc b/maintenance/updaters.inc index 3371beb246..936e34fa8e 100644 --- a/maintenance/updaters.inc +++ b/maintenance/updaters.inc @@ -1407,6 +1407,7 @@ function do_postgres_updates() { array("recentchanges", "rc_params", "TEXT"), array("revision", "rev_len", "INTEGER"), array("revision", "rev_deleted", "SMALLINT NOT NULL DEFAULT 0"), + array("user_newtalk", "user_last_timestamp", "TIMESTAMPTZ"), ); -- 2.20.1