LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 09-24-2012, 08:55 PM   #1
said76
Member
 
Registered: Aug 2011
Posts: 113

Rep: Reputation: Disabled
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
 
Old 10-10-2012, 05:06 AM   #2
jayakrishnan
Member
 
Registered: Feb 2002
Location: India
Distribution: Slacky 12.1, XP
Posts: 992

Rep: Reputation: 30
10 represent 10 digits either 10,000,000,00
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a new mysql user and a mysql database at the shell prompt? puppymagic Linux - Newbie 1 08-07-2010 06:33 AM
Dovecot quota warning message for mysql virtual user ssilayaraja Linux - Server 0 07-28-2009 01:07 AM
If I have public_html website for every user whereis MYSQL database for each user? RMLinux Linux - Newbie 1 12-02-2008 05:37 AM
Create mysql user for backup of database timgerr Linux - Server 2 01-04-2008 10:44 AM
creat MySQL database for each user ? Data-Base SUSE / openSUSE 3 03-07-2005 02:42 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 01:50 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration