Changeset 1865

Timestamp:

08/21/07 02:14:13 (6 years ago)

Author:

anarcat

Message:

remove the size_db cache, it wasn't used in the code and is fully accessible from the PHP/MySQL API

Location:

alternc/trunk

Files:

• install/mysql.sql (modified) (1 diff)
• install/upgrades/0.9.7.sql (added)
• src/spoolsize.php (modified) (1 diff)

alternc/trunk/install/mysql.sql

@@ -440 +440 @@
 
 -- --------------------------------------------------------
--- TABLES de mémorisation de la taille des dossiers web/mail/db
-
-CREATE TABLE IF NOT EXISTS `size_db` (
-  `db` varchar(255) NOT NULL default '',
-  `size` int(10) unsigned NOT NULL default '0',
-  `ts` timestamp(14) NOT NULL,
-  PRIMARY KEY  (`db`),
-  KEY `ts` (`ts`)
-) TYPE=MyISAM COMMENT='MySQL Database used space';
-
-
--- --------------------------------------------------------
 CREATE TABLE IF NOT EXISTS `size_mail` (
   `alias` varchar(255) NOT NULL default '',

alternc/trunk/src/spoolsize.php

@@ -15 +15 @@
 }
 
-echo "---------------------------\n Generating size-cache for db accounts\n\n";
-$r=mysql_query("SELECT db FROM db;");
-while ($c=mysql_fetch_array($r)) {
-  echo $c["db"]; flush();
-  $size=$mysql->get_db_size($c["db"]);
-  mysql_query("REPLACE INTO size_db SET db='".addslashes($c["db"])."',size='$size';");
-  echo " done ($size KB) \n"; flush();
-}
-
 echo "---------------------------\n Generating size-cache for web accounts\n\n";
 $r=mysql_query("SELECT uid,login FROM membres;");