auto reply table can not be created
Joni-Pekka Kurronen <[email protected]>
| Newsgroups | gmane.mail.imap.dbmail |
|---|---|
| Message-ID | <[email protected]> |
> EXECUTE: > > CREATE TABLE dbmail_auto_replies ( > user_idnr bigint(20) UNSIGNED DEFAULT '0' NOT NULL, > start_date DATETIME NOT NULL, > stop_date DATETIME NOT NULL, > reply_body MEDIUMTEXT, > INDEX user_idnr_index (user_idnr), > FOREIGN KEY user_idnr_fk (user_idnr) > REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE ON > UPDATE CASCADE > ) ENGINE InnoDB DEFAULT CHARSET=utf8; > > > > RESULT: > > Failed to execute SQL : SQL CREATE TABLE dbmail_auto_replies ( user_idnr > bigint(20) UNSIGNED DEFAULT '0' NOT NULL, start_date DATETIME NOT NULL, > stop_date DATETIME NOT NULL, reply_body MEDIUMTEXT, INDEX > user_idnr_index (user_idnr), FOREIGN KEY user_idnr_fk (user_idnr) > REFERENCES dbmail_users (user_idnr) ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE InnoDB DEFAULT CHARSET=utf8; failed : Can't create table > `dbmail`.`dbmail_auto_replies` (errno: 121 "Duplicate key on write or > update") > > TABLES CREATED: > dbmail_acl Table (InnoDB) 0 13 > dbmail_aliases Table (InnoDB) 10 4 > dbmail_authlog Table (InnoDB) 0 12 > dbmail_auto_notifications Table (InnoDB) 0 2 > dbmail_envelope Table (InnoDB) 0 3 > dbmail_filters Table (InnoDB) 0 5 > dbmail_header Table (InnoDB) 0 3 > dbmail_headername Table (InnoDB) 0 2 > dbmail_headervalue Table (InnoDB) 0 5 > dbmail_keywords Table (InnoDB) 0 2 > dbmail_mailboxes Table (InnoDB) 1 13 > dbmail_messages Table (InnoDB) 0 12 > dbmail_mimeparts Table (InnoDB) 0 4 > dbmail_partlists Table (InnoDB) 0 6 > dbmail_pbsp Table (InnoDB) 0 3 > dbmail_physmessage Table (InnoDB) 0 4 > dbmail_referencesfield Table (InnoDB) 0 3 > dbmail_replycache Table (InnoDB) 0 4 > dbmail_sievescripts Table (InnoDB) 0 4 > dbmail_subscription Table (InnoDB) 0 2 > dbmail_upgrade_steps Table (InnoDB) 4 3 > dbmail_usermap Table (InnoDB) 0 4 > dbmail_users Table (InnoDB) 4 13 > user_id_index Index Index 2 > mailbox_id_index Index Index 2 > alias_index Index Index 1 > client_idnr_index Index Index 1 > user_idnr_index Index Index 1 > physmessage_id_1 Index Index 1 > physmessage_id_2 Index Index 2 > user_id Index Index 1 > physmessage_id Index Index 4 > headername_id Index Index 1 > headervalue_id Index Index 1 > physmessage_id_headername_id Index Index 2 > > Name Type Rows Fields > physmessage_id_headervalue_id Index Index 2 > headername_id_headervalue_id Index Index 2 > headername Index Index 1 > hash Index Index 2 > headervalue Index Index 1 > sortfield Index Index 1 > datefield Index Index 1 > owner_idnr_name_index Index Index 2 > name_index Index Index 1 > owner_idnr_index Index Index 1 > seq_index Index Index 1 > physmessage_id_index Index Index 1 > mailbox_idnr_index Index Index 1 > seen_flag_index Index Index 1 > unique_id_index Index Index 1 > status_index Index Index 1 > mailbox_status Index Index 2 > dbmail_messages_seq_index Index Index 1 > message_parts Index Index 4 > part_id Index Index 1 > ipnumber_index Index Index 1 > since_index Index Index 1 > replycache_1 Index Index 3 > owner_idnr_2 Index Index 2 > name Index Index 1 > owner_idnr Index Index 1 > from_version Index Index 2 > usermap_idx_1 Index Index 3 > userid_index Index Index 1 > dbmail_ccfield View > > dbmail_datefield View > > dbmail_fromfield View > > dbmail_subjectfield View > > dbmail_tofield View > > > >