From dc1bb0233604e62df0169f3f2b400345d4146c3d Mon Sep 17 00:00:00 2001 From: Rob Church Date: Wed, 21 Jun 2006 22:40:40 +0000 Subject: [PATCH] Remove unused "validation" table definitions from the schema files --- RELEASE-NOTES | 4 ++-- maintenance/mysql5/tables.sql | 13 ------------- maintenance/oracle/tables.sql | 11 ----------- maintenance/postgres/tables.sql | 13 ------------- maintenance/tables.sql | 13 ------------- 5 files changed, 2 insertions(+), 52 deletions(-) diff --git a/RELEASE-NOTES b/RELEASE-NOTES index bdc4feae6e..998086f18a 100644 --- a/RELEASE-NOTES +++ b/RELEASE-NOTES @@ -530,8 +530,8 @@ Some default configuration options have changed: * (bug 6345) Update to Indonesian localisation (id) #22 * (bug 6279) Add genitive month names to Slovenian localisation * (bug 6351) Update to German translation (de) -* Show an arrow in the right direction also in Broken Redirects special page, - not only in the Double Redirects. +* Respect language directionality when displaying arrow in Special:Brokenredirects +* Remove unused "validation" table definitions from the schema files == Compatibility == diff --git a/maintenance/mysql5/tables.sql b/maintenance/mysql5/tables.sql index e11ccb012e..cc6818d39c 100644 --- a/maintenance/mysql5/tables.sql +++ b/maintenance/mysql5/tables.sql @@ -933,19 +933,6 @@ CREATE TABLE /*$wgDBprefix*/transcache ( UNIQUE INDEX tc_url_idx(tc_url) ) TYPE=InnoDB, DEFAULT CHARSET=utf8; --- For article validation -CREATE TABLE /*$wgDBprefix*/validate ( - val_user int(11) NOT NULL default '0', - val_page int(11) unsigned NOT NULL default '0', - val_revision int(11) unsigned NOT NULL default '0', - val_type int(11) unsigned NOT NULL default '0', - val_value int(11) default '0', - val_comment varchar(255) NOT NULL default '', - val_ip varchar(20) NOT NULL default '', - KEY val_user (val_user,val_revision) -) TYPE=InnoDB, DEFAULT CHARSET=utf8; - - CREATE TABLE /*$wgDBprefix*/logging ( -- Symbolic keys for the general log type and the action type -- within the log. The output format will be controlled by the diff --git a/maintenance/oracle/tables.sql b/maintenance/oracle/tables.sql index 7ccdb60f8c..6733f95074 100644 --- a/maintenance/oracle/tables.sql +++ b/maintenance/oracle/tables.sql @@ -290,17 +290,6 @@ CREATE TABLE objectcache ( CREATE UNIQUE INDEX oc_keyname_idx ON objectcache(keyname); CREATE INDEX oc_exptime_idx ON objectcache(exptime); -CREATE TABLE "validate" ( - val_user NUMBER(11) DEFAULT 0 NOT NULL, - val_page NUMBER(11) DEFAULT 0 NOT NULL, - val_revision NUMBER(11) DEFAULT 0 NOT NULL, - val_type NUMBER(11) DEFAULT 0 NOT NULL, - val_value NUMBER(11) DEFAULT 0, - val_comment VARCHAR2(255), - val_ip VARCHAR2(20) -); -CREATE INDEX val_user ON "validate" (val_user,val_revision); - CREATE TABLE logging ( log_type VARCHAR2(10) NOT NULL, log_action VARCHAR2(10) NOT NULL, diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 9d686e5182..ba2babfaec 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -303,19 +303,6 @@ CREATE TABLE transcache ( tc_time TIMESTAMPTZ NOT NULL ); - -CREATE TABLE validate ( - val_user INTEGER NOT NULL REFERENCES "user"(user_id) ON DELETE CASCADE, - val_page INTEGER NOT NULL REFERENCES page(page_id) ON DELETE CASCADE, - val_revision INTEGER DEFAULT 0 NOT NULL, - val_type INTEGER DEFAULT 0 NOT NULL, - val_value INTEGER DEFAULT 0, - val_comment TEXT, - val_ip TEXT -- change to CIDR later -); -CREATE INDEX val_user ON validate (val_user,val_revision); - - CREATE TABLE logging ( log_type TEXT NOT NULL, log_action TEXT NOT NULL, diff --git a/maintenance/tables.sql b/maintenance/tables.sql index c998f78305..5dd851f530 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -919,19 +919,6 @@ CREATE TABLE /*$wgDBprefix*/transcache ( UNIQUE INDEX tc_url_idx(tc_url) ) TYPE=InnoDB; --- For article validation -CREATE TABLE /*$wgDBprefix*/validate ( - val_user int(11) NOT NULL default '0', - val_page int(11) unsigned NOT NULL default '0', - val_revision int(11) unsigned NOT NULL default '0', - val_type int(11) unsigned NOT NULL default '0', - val_value int(11) default '0', - val_comment varchar(255) NOT NULL default '', - val_ip varchar(20) NOT NULL default '', - KEY val_user (val_user,val_revision) -) TYPE=InnoDB; - - CREATE TABLE /*$wgDBprefix*/logging ( -- Symbolic keys for the general log type and the action type -- within the log. The output format will be controlled by the -- 2.20.1