[horde] Where does Ingo maintain the id for the primary key for the ingu_rules table?
Jan Schneider
jan at horde.org
Fri Aug 28 14:58:52 UTC 2009
Zitat von Bjørn T Johansen <btj at havleik.no>:
> I am trying to copy the rows in the ingo_rules table to a new
> installation but when I try to create a new rule, the sql insert
> fails because of of
> duplicate key... And that makes sense, cause the id it tries to use
> is already used... Where can I update Ingo so that it knows how many
> rules it has
> already created?
It depends on your database. We use sequences for all incrementing
primary keys. If your database doesn't support sequences, the DB
package's sequence emulation is used, usually with a table name called
..._seq.
Jan.
--
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/
More information about the horde
mailing list