X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Foracle%2Farchives%2Fpatch-externallinks-el_index_60.sql;h=39680ef3b4fdc9c54fe05495375286756305f3a6;hb=13df3d2290ba2836ad14e7de664a2671952c5ddb;hp=c4b906d1a702f608e9006e48eb31f2f8f3c5cfbc;hpb=30f28501243ba58faf4063b701cf3148bd1d1280;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/oracle/archives/patch-externallinks-el_index_60.sql b/maintenance/oracle/archives/patch-externallinks-el_index_60.sql index c4b906d1a7..39680ef3b4 100644 --- a/maintenance/oracle/archives/patch-externallinks-el_index_60.sql +++ b/maintenance/oracle/archives/patch-externallinks-el_index_60.sql @@ -1,5 +1,5 @@ define mw_prefix='{$wgDBprefix}'; -ALTER TABLE &mw_prefix.externallinks ADD el_index_60 VARBINARY(60) NOT NULL DEFAULT ''; +ALTER TABLE &mw_prefix.externallinks ADD el_index_60 VARCHAR2(60); CREATE INDEX &mw_prefix.externallinks_i04 ON &mw_prefix.externallinks (el_index_60, el_id); CREATE INDEX &mw_prefix.externallinks_i05 ON &mw_prefix.externallinks (el_from, el_index_60, el_id);