[SOGo] Calendars tables names in Mysql

[alberto ayllon]

Hello.

I'm trying migrate one Kerio Connect mailserver to a new installation of
SOGo.
Migrate user's calendars is the part where I'm having more difficulty.

I found a way to do it through MySQL, first of all i have to make an insert
in sogo_folder_info table, here is where new calendars are defined, next
step is create 3 new tables, the sql statements are;

CREATE TABLE `sogonuevocro001649ef499` (
  `c_name` varchar(255) NOT NULL,
  `c_content` mediumtext NOT NULL,
  `c_creationdate` int(11) NOT NULL,
  `c_lastmodified` int(11) NOT NULL,
  `c_version` int(11) NOT NULL,
  `c_deleted` int(11) DEFAULT NULL,
  PRIMARY KEY (`c_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `sogonuevocro001649ef499_acl` (
  `c_uid` varchar(255) NOT NULL,
  `c_object` varchar(255) NOT NULL,
  `c_role` varchar(80) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `sogonuevocro001649ef499_quick` (
  `c_name` varchar(255) NOT NULL,
  `c_uid` varchar(255) NOT NULL,
  `c_startdate` int(11) DEFAULT NULL,
  `c_enddate` int(11) DEFAULT NULL,
  `c_cycleenddate` int(11) DEFAULT NULL,
  `c_title` varchar(1000) NOT NULL,
  `c_participants` text,
  `c_isallday` int(11) DEFAULT NULL,
  `c_iscycle` int(11) DEFAULT NULL,
  `c_cycleinfo` text,
  `c_classification` int(11) NOT NULL,
  `c_isopaque` int(11) NOT NULL,
  `c_status` int(11) NOT NULL,
  `c_priority` int(11) DEFAULT NULL,
  `c_location` varchar(255) DEFAULT NULL,
  `c_orgmail` varchar(255) DEFAULT NULL,
  `c_partmails` text,
  `c_partstates` varchar(255) DEFAULT NULL,
  `c_category` varchar(255) DEFAULT NULL,
  `c_sequence` int(11) DEFAULT NULL,
  `c_component` varchar(10) NOT NULL,
  `c_nextalarm` int(11) DEFAULT NULL,
  PRIMARY KEY (`c_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


These tables store calendar events,

I'm trying to avoid choose tables names by my self, because maybe it can
agree on names choose by Sogo, and produce some kind of problems.
in the example I chose sogonuevocro001649ef499[_acl|_quick] as tables names.

Could someone explain me how SOGO choose tables names, like 001649ef499?

Thanks.
-- 
users@sogo.nu
https://inverse.ca/sogo/lists