[kronolith] adding an invitation to calendar results in DB error / reusing event_ids as a primary key

[Bernhard Erdmann]

Daniel Eckl wrote:
> Hi Bernhard!
> 
> You didn't update the mysql tables through some horde changes.
> 
> Look at the sql generation scripts and compare the data type of the
> event_id field with that in your database.


Hi Daniel,

the table definitions are the same both in the database and in 
Kronolith's sql script:

-- $Horde: kronolith/scripts/drivers/kronolith.sql,v 1.14 2004/03/12 
03:23:44 chuck Exp $

CREATE TABLE kronolith_events (
     event_id VARCHAR(32) NOT NULL,
     calendar_id VARCHAR(255) NOT NULL,
     event_creator_id VARCHAR(255) NOT NULL,
     event_description TEXT,
     event_location TEXT,
     event_status INT DEFAULT 0,
     event_attendees TEXT,
     event_keywords TEXT,
     event_exceptions TEXT,
     event_title VARCHAR(80),
     event_category VARCHAR(80),
     event_recurtype VARCHAR(11) DEFAULT 0,
     event_recurinterval VARCHAR(11),
     event_recurdays VARCHAR(11),
     event_recurenddate DATETIME,
     event_start DATETIME,
     event_end DATETIME,
     event_alarm INT DEFAULT 0,
     event_modified INT NOT NULL,

     PRIMARY KEY (event_id)
);
[...]


excerpt from mysqldump:

[...]
-- Table structure for table 'kronolith_events'
--

DROP TABLE IF EXISTS kronolith_events;
CREATE TABLE kronolith_events (
   event_id varchar(32) NOT NULL default '',
   calendar_id varchar(255) NOT NULL default '',
   event_creator_id varchar(255) NOT NULL default '',
   event_description text,
   event_location text,
   event_status int(11) default '0',
   event_attendees text,
   event_keywords text,
   event_exceptions text,
   event_title varchar(80) default NULL,
   event_category varchar(80) default NULL,
   event_recurtype varchar(11) default '0',
   event_recurinterval varchar(11) default NULL,
   event_recurdays varchar(11) default NULL,
   event_recurenddate datetime default NULL,
   event_start datetime default NULL,
   event_end datetime default NULL,
   event_alarm int(11) default '0',
   event_modified int(11) NOT NULL default '0',
   PRIMARY KEY  (event_id),
   KEY kronolith_calendar_idx (calendar_id)
) TYPE=MyISAM;
[...]