From 80397225ed6e208e50d122251fb2c95652806818 Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Sat, 17 Mar 2007 19:11:31 +0000 Subject: [PATCH] Bring in sync with maintenance/tables.sql --- maintenance/mysql5/tables-binary.sql | 5 +++++ maintenance/mysql5/tables.sql | 11 ++++++++--- 2 files changed, 13 insertions(+), 3 deletions(-) diff --git a/maintenance/mysql5/tables-binary.sql b/maintenance/mysql5/tables-binary.sql index 688771dea3..35e4e61a76 100644 --- a/maintenance/mysql5/tables-binary.sql +++ b/maintenance/mysql5/tables-binary.sql @@ -1033,6 +1033,9 @@ CREATE TABLE /*$wgDBprefix*/logging ( -- LF separated list of miscellaneous parameters log_params blob NOT NULL, + -- Log ID, for referring to this specific log entry, probably for deletion and such. + log_id int unsigned NOT NULL auto_increment, + -- rev_deleted for logs log_deleted tinyint(1) unsigned NOT NULL default '0', @@ -1143,6 +1146,8 @@ CREATE TABLE /*$wgDBprefix*/page_restrictions ( pr_user int(8) NULL, -- Field for time-limited protection. pr_expiry char(14) binary NULL, + -- Field for an ID for this restrictions row (sort-key for Special:ProtectedPages) + pr_id int unsigned NOT NULL auto_increment, PRIMARY KEY pr_pagetype (pr_page,pr_type), diff --git a/maintenance/mysql5/tables.sql b/maintenance/mysql5/tables.sql index 834901eb45..18b766f3ce 100644 --- a/maintenance/mysql5/tables.sql +++ b/maintenance/mysql5/tables.sql @@ -1024,14 +1024,17 @@ CREATE TABLE /*$wgDBprefix*/logging ( -- LF separated list of miscellaneous parameters log_params blob NOT NULL, + -- Log ID, for referring to this specific log entry, probably for deletion and such. + log_id int unsigned NOT NULL auto_increment, + + -- rev_deleted for logs + log_deleted tinyint(1) unsigned NOT NULL default '0', + KEY type_time (log_type, log_timestamp), KEY user_time (log_user, log_timestamp), KEY page_time (log_namespace, log_title, log_timestamp), KEY times (log_timestamp) - -- rev_deleted for logs - log_deleted tinyint(1) unsigned NOT NULL default '0', - ) ENGINE=InnoDB, DEFAULT CHARSET=utf8; CREATE TABLE /*$wgDBprefix*/trackbacks ( @@ -1134,6 +1137,8 @@ CREATE TABLE /*$wgDBprefix*/page_restrictions ( pr_user int(8) NULL, -- Field for time-limited protection. pr_expiry char(14) binary NULL, + -- Field for an ID for this restrictions row (sort-key for Special:ProtectedPages) + pr_id int unsigned NOT NULL auto_increment, PRIMARY KEY pr_pagetype (pr_page,pr_type), -- 2.20.1