[Tickets #9835] Re: db schema update for h3->h4 conversion

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/9835
------------------------------------------------------------------------------
  Ticket             | 9835
  Updated By         | sr at parabola.me.uk
  Summary            | db schema update for h3->h4 conversion
  Queue              | Horde Base
  Version            | 4.0
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


sr at parabola.me.uk (2011-07-01 21:39) wrote:


In the database dump the table is created first without any primary
key and then the primary key is added with a given name eg:

   ALTER TABLE ONLY imp_sentmail
     ADD CONSTRAINT imp_primary_idx PRIMARY KEY (sentmail_id);

So it can be named anything, but yes, I can't imagine how it got to be the
wrong name in the first place.

The other person that had the problem with exactly the same tables as  
me, so they
may be able to shed some light on it - it can't be just peculiar to me.