Here it goes
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Paul J Stevens
Sent: domingo, 10 de Fevereiro de 2008 15:33
To: DBMail mailinglist
Subject: Re: [Dbmail] DBMail 2.3.2 released
Jorge Bastos wrote:
> Hum... i'm getting mad.
> Paul, can you give me a help?
>
> I have two situations:
> 1st, I have values in dbmail_subscription that doesn't have any mailbox in
> dbmail_mailboxes
> * this is the problem you already know
That also means you did not add the foreign keys. You can not add a
foreign key if there are records that violate the restraint.
>
> 2nd, I have values in dbmail_mailboxes that doesn't have the corresponding
> value in dbmail_subscription
> * this new problem, it doesn't give any problem with 2.2x code, but with
> 2.3x it complains
No Jorge, that is not a problem. That just means you have mailboxes
no-one subscribes to, which is perfectly valid.
>
>
> Can you give a hand?
Show me your schema as you have it: 'mysqldump -d dbmail'
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf
> Of Jorge Bastos
> Sent: domingo, 10 de Fevereiro de 2008 12:42
> To: 'DBMail mailinglist'
> Subject: RE: [Dbmail] DBMail 2.3.2 released
>
> Right,
>
> The other time i thinked i only had that record missing and didn't checked
> for more NULL's.
> Now I checked for that, and ops, I have a lot.
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf
> Of Paul J Stevens
> Sent: domingo, 10 de Fevereiro de 2008 9:20
> To: DBMail mailinglist
> Subject: Re: [Dbmail] DBMail 2.3.2 released
>
> Jorge Bastos wrote:
>> Ok Paul,
>> I'm really having no luck on the upgrade.
>> You have a full log in attach, i was checking the log, and saw this:
>>
>> Feb 10 02:00:27 lira dbmail/imap4d[4143]: Debug:[sql]
>> dbmysql.c,db_query(+301): query [SELECT login, sock_allow, sock_deny,
>> userid FROM dbmail_usermap WHERE login in ('mail@ *_<======
>> where's the rest of the query???
>> _*Feb 10 02:00:27 lira dbmail/imap4d[4143]: Debug:[db]
>> dbmodule.c,db_query(+154): last query took [0] seconds
>> Feb 10 02:00:27 lira dbmail/imap4d[4143]: Debug:[db]
>> dm_db.c,db_usermap_resolve(+4826): login [EMAIL PROTECTED] not found in
>> usermap
>> Feb 10 02:00:27 lira dbmail/imap4d[4143]: Debug:[sql]
>> dbmysql.c,db_query(+301): query [SELECT user_idnr FROM dbmail_users
>> WHERE lower(userid) = lower('[EMAIL PROTECTED]'
<mailto:'[EMAIL PROTECTED]'>)]
>>
>> more below:
>
>
> Nothing wrong here at all! Strings are truncated in the syslog to keep
> the linelength within bounds.
>
>> Feb 10 02:00:27 lira dbmail/imap4d[4143]: Error:[imapsession]
>> dbmail-imapsession.c,dbmail_imap_session_get_mbxinfo(+786): failure
>> retrieving mbxinfo for unreadable mailbox
>
>
> select * from dbmail_subscriptions where mailbox_id=50;
>
> select * from dbmail_mailboxes where mailbox_idnr=50;
>
> The first one returns a row, the second one does not. Hence, your
> foreign key constraints are incomplete!
>
>
>
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
-- MySQL dump 10.11
--
-- Host: localhost Database: postfix
-- ------------------------------------------------------
-- Server version 5.0.51a-1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `dbmail_acl`
--
DROP TABLE IF EXISTS `dbmail_acl`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_acl` (
`user_id` bigint(21) NOT NULL,
`mailbox_id` bigint(21) NOT NULL,
`lookup_flag` tinyint(1) NOT NULL default '0',
`read_flag` tinyint(1) NOT NULL default '0',
`seen_flag` tinyint(1) NOT NULL default '0',
`write_flag` tinyint(1) NOT NULL default '0',
`insert_flag` tinyint(1) NOT NULL default '0',
`post_flag` tinyint(1) NOT NULL default '0',
`create_flag` tinyint(1) NOT NULL default '0',
`delete_flag` tinyint(1) NOT NULL default '0',
`administer_flag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`user_id`,`mailbox_id`),
KEY `user_id_index` (`user_id`),
KEY `mailbox_id_index` (`mailbox_id`),
CONSTRAINT `dbmail_acl_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES
`dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `dbmail_acl_ibfk_2` FOREIGN KEY (`mailbox_id`) REFERENCES
`dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_aliases`
--
DROP TABLE IF EXISTS `dbmail_aliases`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_aliases` (
`alias_idnr` bigint(21) NOT NULL auto_increment,
`alias` varchar(100) NOT NULL,
`deliver_to` varchar(250) NOT NULL,
`client_idnr` bigint(21) NOT NULL default '0',
PRIMARY KEY (`alias_idnr`),
KEY `alias_index` (`alias`),
KEY `client_idnr_index` (`client_idnr`)
) ENGINE=InnoDB AUTO_INCREMENT=520 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_auto_notifications`
--
DROP TABLE IF EXISTS `dbmail_auto_notifications`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_auto_notifications` (
`user_idnr` bigint(21) NOT NULL default '0',
`notify_address` varchar(100) default NULL,
PRIMARY KEY (`user_idnr`),
KEY `user_idnr_index` (`user_idnr`),
CONSTRAINT `dbmail_auto_notifications_ibfk_1` FOREIGN KEY (`user_idnr`)
REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_auto_replies`
--
DROP TABLE IF EXISTS `dbmail_auto_replies`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_auto_replies` (
`user_idnr` bigint(21) NOT NULL default '0',
`reply_body` mediumtext,
`stop_date` datetime NOT NULL,
`start_date` datetime NOT NULL,
PRIMARY KEY (`user_idnr`),
KEY `user_idnr_index` (`user_idnr`),
CONSTRAINT `dbmail_auto_replies_ibfk_1` FOREIGN KEY (`user_idnr`) REFERENCES
`dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_ccfield`
--
DROP TABLE IF EXISTS `dbmail_ccfield`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_ccfield` (
`physmessage_id` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL auto_increment,
`ccname` varchar(100) NOT NULL,
`ccaddr` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`),
CONSTRAINT `dbmail_ccfield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES
`dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=177961 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_datefield`
--
DROP TABLE IF EXISTS `dbmail_datefield`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_datefield` (
`physmessage_id` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL auto_increment,
`datefield` datetime NOT NULL default '1970-01-01 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `physmessage_id` (`physmessage_id`,`datefield`),
CONSTRAINT `dbmail_datefield_ibfk_1` FOREIGN KEY (`physmessage_id`)
REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1095886 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_envelope`
--
DROP TABLE IF EXISTS `dbmail_envelope`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_envelope` (
`physmessage_id` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL auto_increment,
`envelope` text character set latin1 NOT NULL,
PRIMARY KEY (`id`),
KEY `physmessage_id` (`physmessage_id`),
CONSTRAINT `dbmail_envelope_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES
`dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=959335 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_fromfield`
--
DROP TABLE IF EXISTS `dbmail_fromfield`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_fromfield` (
`physmessage_id` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL auto_increment,
`fromname` varchar(100) NOT NULL,
`fromaddr` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`),
CONSTRAINT `dbmail_fromfield_ibfk_1` FOREIGN KEY (`physmessage_id`)
REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1092370 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_headername`
--
DROP TABLE IF EXISTS `dbmail_headername`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_headername` (
`id` bigint(20) NOT NULL auto_increment,
`headername` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `headername` (`headername`)
) ENGINE=InnoDB AUTO_INCREMENT=14006 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_headervalue`
--
DROP TABLE IF EXISTS `dbmail_headervalue`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_headervalue` (
`headername_id` bigint(20) NOT NULL,
`physmessage_id` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL auto_increment,
`headervalue` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`),
KEY `headername_id` (`headername_id`),
KEY `headervalue` (`headervalue`(255)),
CONSTRAINT `dbmail_headervalue_ibfk_1` FOREIGN KEY (`headername_id`)
REFERENCES `dbmail_headername` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `dbmail_headervalue_ibfk_2` FOREIGN KEY (`physmessage_id`)
REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17801744 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_keywords`
--
DROP TABLE IF EXISTS `dbmail_keywords`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_keywords` (
`message_idnr` bigint(21) NOT NULL,
`keyword` varchar(64) NOT NULL,
PRIMARY KEY (`message_idnr`,`keyword`),
CONSTRAINT `dbmail_keywords_ibfk_1` FOREIGN KEY (`message_idnr`) REFERENCES
`dbmail_messages` (`message_idnr`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_mailboxes`
--
DROP TABLE IF EXISTS `dbmail_mailboxes`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_mailboxes` (
`mailbox_idnr` bigint(21) NOT NULL auto_increment,
`owner_idnr` bigint(21) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`seen_flag` tinyint(1) NOT NULL default '0',
`answered_flag` tinyint(1) NOT NULL default '0',
`deleted_flag` tinyint(1) NOT NULL default '0',
`flagged_flag` tinyint(1) NOT NULL default '0',
`recent_flag` tinyint(1) NOT NULL default '0',
`draft_flag` tinyint(1) NOT NULL default '0',
`no_inferiors` tinyint(1) NOT NULL default '0',
`no_select` tinyint(1) NOT NULL default '0',
`permission` tinyint(1) default '2',
PRIMARY KEY (`mailbox_idnr`),
UNIQUE KEY `owner_idnr_name_index` (`owner_idnr`,`name`),
KEY `name_index` (`name`),
KEY `owner_idnr_index` (`owner_idnr`),
CONSTRAINT `dbmail_mailboxes_ibfk_1` FOREIGN KEY (`owner_idnr`) REFERENCES
`dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1691 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_messageblks`
--
DROP TABLE IF EXISTS `dbmail_messageblks`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_messageblks` (
`messageblk_idnr` bigint(21) NOT NULL auto_increment,
`physmessage_id` bigint(21) NOT NULL default '0',
`messageblk` longblob NOT NULL,
`blocksize` bigint(21) NOT NULL default '0',
`is_header` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`messageblk_idnr`),
KEY `physmessage_id_index` (`physmessage_id`),
KEY `physmessage_id_is_header_index` (`physmessage_id`,`is_header`),
CONSTRAINT `dbmail_messageblks_ibfk_1` FOREIGN KEY (`physmessage_id`)
REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2481870 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_messages`
--
DROP TABLE IF EXISTS `dbmail_messages`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_messages` (
`message_idnr` bigint(21) NOT NULL auto_increment,
`mailbox_idnr` bigint(21) NOT NULL default '0',
`physmessage_id` bigint(21) NOT NULL default '0',
`seen_flag` tinyint(1) NOT NULL default '0',
`answered_flag` tinyint(1) NOT NULL default '0',
`deleted_flag` tinyint(1) NOT NULL default '0',
`flagged_flag` tinyint(1) NOT NULL default '0',
`recent_flag` tinyint(1) NOT NULL default '0',
`draft_flag` tinyint(1) NOT NULL default '0',
`unique_id` varchar(70) NOT NULL,
`status` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`message_idnr`),
KEY `mailbox_idnr_index` (`mailbox_idnr`),
KEY `physmessage_id_index` (`physmessage_id`),
KEY `seen_flag_index` (`seen_flag`),
KEY `unique_id_index` (`unique_id`),
KEY `status_index` (`status`),
KEY `mailbox_status` (`mailbox_idnr`,`status`),
CONSTRAINT `dbmail_messages_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES
`dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `dbmail_messages_ibfk_2` FOREIGN KEY (`mailbox_idnr`) REFERENCES
`dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2122031 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_mimeparts`
--
DROP TABLE IF EXISTS `dbmail_mimeparts`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_mimeparts` (
`id` bigint(21) NOT NULL auto_increment,
`hash` char(128) NOT NULL,
`data` longblob NOT NULL,
`size` bigint(21) NOT NULL,
PRIMARY KEY (`id`),
KEY `hash` (`hash`)
) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_mydomains`
--
DROP TABLE IF EXISTS `dbmail_mydomains`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_mydomains` (
`id` int(14) NOT NULL,
`domain` varchar(255) NOT NULL,
`status` enum('true','false') NOT NULL default 'true',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_partlists`
--
DROP TABLE IF EXISTS `dbmail_partlists`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_partlists` (
`physmessage_id` bigint(21) NOT NULL,
`is_header` tinyint(1) NOT NULL default '0',
`part_key` smallint(6) NOT NULL default '0',
`part_depth` smallint(6) NOT NULL default '0',
`part_order` smallint(6) NOT NULL default '0',
`part_id` bigint(21) NOT NULL,
KEY `physmessage_id` (`physmessage_id`),
KEY `part_id` (`part_id`),
CONSTRAINT `dbmail_partlists_ibfk_1` FOREIGN KEY (`physmessage_id`)
REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `dbmail_partlists_ibfk_2` FOREIGN KEY (`part_id`) REFERENCES
`dbmail_mimeparts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_pbsp`
--
DROP TABLE IF EXISTS `dbmail_pbsp`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_pbsp` (
`idnr` bigint(21) NOT NULL auto_increment,
`since` datetime NOT NULL,
`ipnumber` varchar(40) NOT NULL,
PRIMARY KEY (`idnr`),
UNIQUE KEY `ipnumber_index` (`ipnumber`),
KEY `since_index` (`since`)
) ENGINE=InnoDB AUTO_INCREMENT=8013 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_physmessage`
--
DROP TABLE IF EXISTS `dbmail_physmessage`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_physmessage` (
`id` bigint(21) NOT NULL auto_increment,
`messagesize` bigint(21) NOT NULL default '0',
`rfcsize` bigint(21) NOT NULL default '0',
`internal_date` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1151623 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_referencesfield`
--
DROP TABLE IF EXISTS `dbmail_referencesfield`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_referencesfield` (
`physmessage_id` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL auto_increment,
`referencesfield` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `physmessage_id` (`physmessage_id`,`referencesfield`),
CONSTRAINT `dbmail_referencesfield_ibfk_1` FOREIGN KEY (`physmessage_id`)
REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=157499 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_replycache`
--
DROP TABLE IF EXISTS `dbmail_replycache`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_replycache` (
`to_addr` varchar(100) NOT NULL,
`from_addr` varchar(100) NOT NULL,
`handle` varchar(100) NOT NULL,
`lastseen` datetime NOT NULL default '0000-00-00 00:00:00',
UNIQUE KEY `replycache_1` (`to_addr`,`from_addr`,`handle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_replytofield`
--
DROP TABLE IF EXISTS `dbmail_replytofield`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_replytofield` (
`physmessage_id` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL auto_increment,
`replytoname` varchar(100) NOT NULL,
`replytoaddr` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`),
CONSTRAINT `dbmail_replytofield_ibfk_1` FOREIGN KEY (`physmessage_id`)
REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=92915 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_sievescripts`
--
DROP TABLE IF EXISTS `dbmail_sievescripts`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_sievescripts` (
`owner_idnr` bigint(20) NOT NULL default '0',
`active` tinyint(1) NOT NULL default '0',
`name` varchar(100) NOT NULL,
`script` text NOT NULL,
UNIQUE KEY `dbmail_sievescripts_1` (`owner_idnr`,`name`),
KEY `name` (`name`),
KEY `owner_idnr` (`owner_idnr`),
CONSTRAINT `dbmail_sievescripts_ibfk_1` FOREIGN KEY (`owner_idnr`) REFERENCES
`dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_subjectfield`
--
DROP TABLE IF EXISTS `dbmail_subjectfield`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_subjectfield` (
`physmessage_id` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL auto_increment,
`subjectfield` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `physmessage_id` (`physmessage_id`,`subjectfield`),
CONSTRAINT `dbmail_subjectfield_ibfk_1` FOREIGN KEY (`physmessage_id`)
REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1091755 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_subscription`
--
DROP TABLE IF EXISTS `dbmail_subscription`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_subscription` (
`user_id` bigint(21) NOT NULL,
`mailbox_id` bigint(21) NOT NULL,
PRIMARY KEY (`user_id`,`mailbox_id`),
KEY `user_id_index` (`user_id`),
KEY `mailbox_id_index` (`mailbox_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_subscription_10022008`
--
DROP TABLE IF EXISTS `dbmail_subscription_10022008`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_subscription_10022008` (
`user_id` bigint(21) NOT NULL,
`mailbox_id` bigint(21) NOT NULL,
PRIMARY KEY (`user_id`,`mailbox_id`),
KEY `user_id_index` (`user_id`),
KEY `mailbox_id_index` (`mailbox_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_subscription_com_reg_apagados`
--
DROP TABLE IF EXISTS `dbmail_subscription_com_reg_apagados`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_subscription_com_reg_apagados` (
`user_id` bigint(21) NOT NULL,
`mailbox_id` bigint(21) NOT NULL,
PRIMARY KEY (`user_id`,`mailbox_id`),
KEY `user_id_index` (`user_id`),
KEY `mailbox_id_index` (`mailbox_id`),
CONSTRAINT `dbmail_subscription_com_reg_apagados_ibfk_1` FOREIGN KEY
(`user_id`) REFERENCES `dbmail_users` (`user_idnr`) ON DELETE CASCADE ON UPDATE
CASCADE,
CONSTRAINT `dbmail_subscription_com_reg_apagados_ibfk_2` FOREIGN KEY
(`mailbox_id`) REFERENCES `dbmail_mailboxes` (`mailbox_idnr`) ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_tofield`
--
DROP TABLE IF EXISTS `dbmail_tofield`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_tofield` (
`physmessage_id` bigint(20) NOT NULL,
`id` bigint(20) NOT NULL auto_increment,
`toname` varchar(100) NOT NULL,
`toaddr` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `physmessage_id` (`physmessage_id`,`id`),
CONSTRAINT `dbmail_tofield_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES
`dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2066176 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_usermap`
--
DROP TABLE IF EXISTS `dbmail_usermap`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_usermap` (
`login` varchar(100) NOT NULL,
`sock_allow` varchar(100) NOT NULL,
`sock_deny` varchar(100) NOT NULL,
`userid` varchar(100) NOT NULL,
UNIQUE KEY `usermap_idx_1` (`login`,`sock_allow`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `dbmail_users`
--
DROP TABLE IF EXISTS `dbmail_users`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dbmail_users` (
`user_idnr` bigint(21) NOT NULL auto_increment,
`userid` varchar(100) NOT NULL,
`passwd` varchar(34) NOT NULL,
`client_idnr` bigint(21) NOT NULL default '0',
`maxmail_size` bigint(21) NOT NULL default '0',
`curmail_size` bigint(21) NOT NULL default '0',
`encryption_type` varchar(20) NOT NULL,
`last_login` datetime NOT NULL default '1979-11-03 22:05:58',
`maxsieve_size` bigint(20) NOT NULL default '0',
`cursieve_size` bigint(20) NOT NULL default '0',
PRIMARY KEY (`user_idnr`),
UNIQUE KEY `userid_index` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=419 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Table structure for table `smtp_auth_users`
--
DROP TABLE IF EXISTS `smtp_auth_users`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `smtp_auth_users` (
`username` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
`status` enum('true','false') NOT NULL default 'true',
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
/*!40103 SET [EMAIL PROTECTED] */;
/*!40101 SET [EMAIL PROTECTED] */;
/*!40014 SET [EMAIL PROTECTED] */;
/*!40014 SET [EMAIL PROTECTED] */;
/*!40101 SET [EMAIL PROTECTED] */;
/*!40101 SET [EMAIL PROTECTED] */;
/*!40101 SET [EMAIL PROTECTED] */;
/*!40111 SET [EMAIL PROTECTED] */;
-- Dump completed on 2008-02-10 15:43:09
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
