[Tikiwiki-devel] Short key length for Calendar custom info problem

[Nelson Ko <ne...@wo...>]

Looking at the database schema,
for `tiki_calendar_locations` UNIQUE KEY `locname` (`calendarId`, `name`(16))
for `tiki_calendar_categories`  UNIQUE KEY `catname` (`calendarId`, `name`(16))
for `tiki_calendar_roles` PRIMARY KEY (`calitemId`,`username`(16),`role`)

Why is the length set to only 16? This could be a problem. In fact, I
ran into this problem with location, where I had multiple locations:
Centre communautaires de ... and Centre communautaires de ...., the
first 16 chars is the same, causing a duplicate key db error when
trying to create the second location.

Is there some calendar standard somewhere out there that suggest a
unique length of 16 for things like location, roles, categories? Or
should we simply extend the key length?

Nelson (nkoth)