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
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;