Mailing List Archive

> 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
>
>
>
>


_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail