From cda4adc30d4799d55cc4863e468dca3924f3108b Mon Sep 17 00:00:00 2001 From: "Mr. E23" Date: Wed, 10 Mar 2004 23:43:54 +0000 Subject: [PATCH] Made linkscc title column case sensitive --- maintenance/archives/patch-linkscc.sql | 2 +- maintenance/tables.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/maintenance/archives/patch-linkscc.sql b/maintenance/archives/patch-linkscc.sql index 49ffe5800c..32370b7f28 100644 --- a/maintenance/archives/patch-linkscc.sql +++ b/maintenance/archives/patch-linkscc.sql @@ -5,6 +5,6 @@ CREATE TABLE IF NOT EXISTS linkscc ( lcc_pageid INT UNSIGNED NOT NULL UNIQUE KEY, - lcc_title VARCHAR(255) NOT NULL UNIQUE KEY, + lcc_title VARCHAR(255) binary NOT NULL UNIQUE KEY, lcc_cacheobj MEDIUMBLOB NOT NULL); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index c4a5133386..d9a034a0ed 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -93,7 +93,7 @@ CREATE TABLE brokenlinks ( DROP TABLE IF EXISTS linkscc; CREATE TABLE linkscc ( lcc_pageid INT UNSIGNED NOT NULL UNIQUE KEY, - lcc_title VARCHAR(255) NOT NULL UNIQUE KEY, + lcc_title VARCHAR(255) binary NOT NULL UNIQUE KEY, lcc_cacheobj MEDIUMBLOB NOT NULL ) TYPE=MyISAM; -- 2.20.1