[Tickets #6712] seqence tables missing

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/6712
-----------------------------------------------------------------------
 Ticket             | 6712
 Created By         | adrieder at sbox.tugraz.at
 Summary            | seqence tables missing
 Queue              | Horde Base
 Version            | HEAD
 Type               | Enhancement
 State              | New
 Priority           | 2. Medium
 Milestone          |
 Patch              |
 Owners             |
-----------------------------------------------------------------------


adrieder at sbox.tugraz.at (2008-05-16 03:48) wrote:

would it be possible to provide also the sql statements for the
xxx_shares_seq tables in the corresponding sql scripts, otherwise the horde
db user needs the create table privilege.

Error message:
HORDE [debug] [kronolith] MDB2 Error: insufficient permissions: [Error
message: on demand sequence kronolith_share
s could not be created]

Solution:
e.g. for mysql:
CREATE TABLE `kronolith_shares_seq` (
  `sequence` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`sequence`)
)