X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Fmssql%2Ftables.sql;h=41a2ef9dce1c6debe1459598031208cbee93c18f;hb=273eea7357c546d1a1aafd73320e10e8ddac79eb;hp=78f067173b96e8a7979e0eb1b7f9e25790ba1fe9;hpb=bdfa96eb726c9997a010f5a194eec71925bfddc2;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/mssql/tables.sql b/maintenance/mssql/tables.sql index 78f067173b..41a2ef9dce 100644 --- a/maintenance/mssql/tables.sql +++ b/maintenance/mssql/tables.sql @@ -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 @@ -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);