Added ss_images to site_stats, to replace the slow count(*) query in Parser.php.

[lhc/web/wiklou.git] / maintenance / tables.sql

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 9053646..b14b7b0 100644 (file)
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -507,6 +507,9 @@ CREATE TABLE /*$wgDBprefix*/site_stats (
   -- Deprecated, no longer updated as of 1.5
   ss_admins int(10) default '-1',
 
+  -- Number of images, equivalent to SELECT COUNT(*) FROM image
+  ss_images int(10) default '0',
+
   UNIQUE KEY ss_row_id (ss_row_id)
 
 ) ENGINE=InnoDB;