Changeset 1864 for alternc/trunk/install/mysql.sql

Timestamp:

08/21/07 01:49:42 (6 years ago)

Author:

anarcat

Message:

create the size_* tables properly
Closes: 1057

File:

• alternc/trunk/install/mysql.sql (modified) (1 diff)

alternc/trunk/install/mysql.sql

@@ -439 +439 @@
 
 
+-- --------------------------------------------------------
+-- 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 '',
+  `size` int(10) unsigned NOT NULL default '0',
+  `ts` timestamp(14) NOT NULL,
+  PRIMARY KEY  (`alias`),
+  KEY `ts` (`ts`)
+) TYPE=MyISAM COMMENT='Mail space used by pop accounts.';
+
+-- --------------------------------------------------------
+CREATE TABLE IF NOT EXISTS `size_web` (
+  `uid` int(10) unsigned NOT NULL default '0',
+  `size` int(10) unsigned NOT NULL default '0',
+  `ts` timestamp(14) NOT NULL,
+  PRIMARY KEY  (`uid`),
+  KEY `ts` (`ts`)
+) TYPE=MyISAM COMMENT='Web space used by accounts.';
+