From c9dcdbc00710863c0258518ac8520d913deea62a Mon Sep 17 00:00:00 2001 From: Tim Starling Date: Sat, 7 Aug 2004 03:59:20 +0000 Subject: [PATCH] Added primary key for the recentchanges table. Patch already committed. Not in config/index.php yet. --- maintenance/tables.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/maintenance/tables.sql b/maintenance/tables.sql index a55f335ed7..340fb19f1b 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -175,6 +175,7 @@ CREATE TABLE oldimage ( ) PACK_KEYS=1; CREATE TABLE recentchanges ( + rc_id int(8) NOT NULL auto_increment, rc_timestamp varchar(14) binary NOT NULL default '', rc_cur_time varchar(14) binary NOT NULL default '', rc_user int(10) unsigned NOT NULL default '0', @@ -191,7 +192,8 @@ CREATE TABLE recentchanges ( rc_type tinyint(3) unsigned NOT NULL default '0', rc_moved_to_ns tinyint(3) unsigned NOT NULL default '0', rc_moved_to_title varchar(255) binary NOT NULL default '', - rc_ip char(15) NOT NULL default '' + rc_ip char(15) NOT NULL default '', + UNIQUE KEY rc_id (rc_id) ) PACK_KEYS=1; CREATE TABLE watchlist ( -- 2.20.1