1

Topic: calendars tables names in Mysql

==== Required information ====
- iRedMail version: 0.9.0
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Ubuntu 14.04 LTS
- Related log if you're reporting an issue:
====

Hello.


I'm trying migrate one Kerio Connect mailser to a new instalation of iRedmail.

Migrate user's calendars is the part where I'm having more dificulty.

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 statemets 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 tring 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 choose sogonuevocro001649ef499[_acl|_quick] as tables names, Could someone explain me how SOGO choose tables names, like 001649ef499 ?

Thanks.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: calendars tables names in Mysql

Dear aayllon,

I suggest you ask in SOGo mailing list instead.
http://www.sogo.nu/en/support/community.html