dépôts
/
lhc
/
web
/
wiklou.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Reconcept cl_raw_sortkey as cl_sortkey_prefix
[lhc/web/wiklou.git]
/
maintenance
/
archives
/
patch-categorylinks-better-collation.sql
diff --git
a/maintenance/archives/patch-categorylinks-better-collation.sql
b/maintenance/archives/patch-categorylinks-better-collation.sql
index
f73dd52
..
5722a33
100644
(file)
--- a/
maintenance/archives/patch-categorylinks-better-collation.sql
+++ b/
maintenance/archives/patch-categorylinks-better-collation.sql
@@
-8,9
+8,9
@@
-- to work for MySQL for now, without table prefixes, possibly other random
-- limitations.
ALTER TABLE categorylinks
-- to work for MySQL for now, without table prefixes, possibly other random
-- limitations.
ALTER TABLE categorylinks
- ADD COLUMN cl_
raw_sortkey varchar(255) binary NULL default NULL
,
+ ADD COLUMN cl_
sortkey_prefix varchar(255) binary NOT NULL default ''
,
ADD COLUMN cl_collation tinyint NOT NULL default 0,
ADD COLUMN cl_collation tinyint NOT NULL default 0,
- ADD COLUMN cl_type ENUM('page', 'subcat', 'file') NOT NULL,
+ ADD COLUMN cl_type ENUM('page', 'subcat', 'file') NOT NULL
default 'page'
,
ADD INDEX (cl_collation),
DROP INDEX cl_sortkey,
ADD INDEX cl_sortkey (cl_to, cl_type, cl_sortkey, cl_from);
ADD INDEX (cl_collation),
DROP INDEX cl_sortkey,
ADD INDEX cl_sortkey (cl_to, cl_type, cl_sortkey, cl_from);