LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   needs clarification on user's quota on MySQL database (https://www.linuxquestions.org/questions/linux-server-73/needs-clarification-on-users-quota-on-mysql-database-4175428875/)

said76 09-24-2012 08:55 PM

needs clarification on user's quota on MySQL database
 
Hi,

I have a question that I'm wondering anyone might be able to help me with.

I'm installing Postfix, Dovecot, MySQL and Roundcube mail on my Ubuntu Server 12.04 LTS.

Now, I have created the following tables into my Postfix database in MySQL.
Table domains
Table forwardings
Table users
Table transport

The question that I'd like to ask is in the user table, there is an attribute called 'quote' of type (int) as follows:
email varchar(80) NOT NULL,
password varchar(20) NOT NULL,
quota INT(10) DEFAULT '10485760',
PRIMARY KEY (email)

Does that 10 digits of Integer of 'quota' represent the size of user's inbox. For example, I have a user who needs at least 5G of storage of his emails, do I set it to 5000000000 which is equivalent to 5G. If users need 10G, it would be 10000000000. Please correct me if I'm wrong.

Any help would be greatly appreciated.

Thank you

jayakrishnan 10-10-2012 05:06 AM

10 represent 10 digits either 10,000,000,00


All times are GMT -5. The time now is 04:33 AM.