X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Fmssql%2Ftables.sql;h=41a2ef9dce1c6debe1459598031208cbee93c18f;hb=273eea7357c546d1a1aafd73320e10e8ddac79eb;hp=1c633beb77c35acecdef422ad8b7a3b880fc43e2;hpb=a4b09439bde4ce968eebe0a5049d65be3d518471;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/mssql/tables.sql b/maintenance/mssql/tables.sql index 1c633beb77..41a2ef9dce 100644 --- a/maintenance/mssql/tables.sql +++ b/maintenance/mssql/tables.sql @@ -301,7 +301,7 @@ CREATE TABLE /*_*/categorylinks ( -- conversion algorithm is run. We store this so that we can update -- collations without reparsing all pages. -- Note: If you change the length of this field, you also need to change - -- code in LinksUpdate.php. See bug 25254. + -- code in LinksUpdate.php. See T27254. cl_sortkey_prefix varbinary(255) NOT NULL default 0x, -- This isn't really used at present. Provided for an optional @@ -469,7 +469,7 @@ CREATE TABLE /*_*/site_stats ( ss_users bigint default '-1', -- Number of users that still edit - ss_active_users bigint default '-1', + ss_active_users bigint default '1', -- Number of images, equivalent to SELECT COUNT(*) FROM image ss_images int default 0 @@ -528,7 +528,7 @@ CREATE TABLE /*_*/ipblocks ( -- Size chosen to allow IPv6 -- FIXME: these fields were originally blank for single-IP blocks, -- but now they are populated. No migration was ever done. They - -- should be fixed to be blank again for such blocks (bug 49504). + -- should be fixed to be blank again for such blocks (T51504). ipb_range_start varchar(255) NOT NULL, ipb_range_end varchar(255) NOT NULL, @@ -661,7 +661,6 @@ CREATE TABLE /*_*/oldimage ( CREATE INDEX /*i*/oi_usertext_timestamp ON /*_*/oldimage (oi_user_text,oi_timestamp); CREATE INDEX /*i*/oi_name_timestamp ON /*_*/oldimage (oi_name,oi_timestamp); -CREATE INDEX /*i*/oi_name_archive_name ON /*_*/oldimage (oi_name,oi_archive_name); CREATE INDEX /*i*/oi_sha1 ON /*_*/oldimage (oi_sha1);