Tickets :: Comment on [#368] adding an invitation to calendar results in DB error / reusing event

* Your Email Address
* Spam protection	Enter the letters below: __ . .. ..__ . . / `\| \|\ /[__)\ / \__.\|/\\| \/ \| \ \/
Comment	> By modifying the primary key of kronolith_events requests by others > can be inserted into my own calendar: > > > > PRIMARY KEY (event_id) => PRIMARY KEY (event_id,calendar_id) > > > > > > OLD: > > > > 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; > > > > > > NEW: > > > > 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,calendar_id), > > KEY kronolith_calendar_idx (calendar_id) > > ) TYPE=MyISAM; > > > >
Attachment
Watch this ticket

Saved Queries