[Summary view] [Print] [Text view]

   1  <?xml version='1.0'?>
   2  <module>
   3  <exporttime>2011-09-30 10:25:56</exporttime>
   4  <name>MailManager</name>
   5  <label>MailManager</label>
   6  <parent>Tools</parent>
   7  <type>extension</type>
   8  <version>1.9</version>
   9  <dependencies>
  10  <vtiger_version>6.0.0RC</vtiger_version>
  11  </dependencies>
  12  <tables>
  13  <table>
  14  <name>vtiger_mailmanager_mailrel</name>
  15  <sql><![CDATA[CREATE TABLE `vtiger_mailmanager_mailrel` (
  16    `mailuid` varchar(999) default NULL,
  17    `crmid` int(11) default NULL,
  18    `emailid` int(11) default NULL
  19  ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql>
  20  </table>
  21  <table>
  22  <name>vtiger_mailmanager_mailrecord</name>
  23  <sql><![CDATA[CREATE TABLE `vtiger_mailmanager_mailrecord` (
  24    `userid` int(11) default NULL,
  25    `mfrom` varchar(255) default NULL,
  26    `mto` varchar(255) default NULL,
  27    `mcc` varchar(500) default NULL,
  28    `mbcc` varchar(500) default NULL,
  29    `mdate` varchar(20) default NULL,
  30    `msubject` varchar(500) default NULL,
  31    `mbody` text,
  32    `mcharset` varchar(10) default NULL,
  33    `misbodyhtml` int(1) default NULL,
  34    `mplainmessage` int(1) default NULL,
  35    `mhtmlmessage` int(1) default NULL,
  36    `muniqueid` varchar(500) default NULL,
  37    `mbodyparsed` int(1) default NULL,
  38    `muid` int(11) default NULL,
  39    `lastsavedtime` int(11) default NULL,
  40    KEY `userid_lastsavedtime_idx` (`userid`,`lastsavedtime`),
  41    KEY `userid_muid_idx` (`userid`,`muid`)
  42  ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql>
  43  </table>
  44  <table>
  45  <name>vtiger_mailmanager_mailattachments</name>
  46  <sql><![CDATA[CREATE TABLE `vtiger_mailmanager_mailattachments` (
  47    `userid` int(11) default NULL,
  48    `muid` int(11) default NULL,
  49    `aname` varchar(100) default NULL,
  50    `lastsavedtime` int(11) default NULL,
  51    `attachid` int(19) NOT NULL,
  52    `path` varchar(200) NOT NULL,
  53    `cid` varchar(50) default NULL,
  54    KEY `userid_muid_idx` (`userid`,`muid`)
  55  ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql>
  56  </table>
  57  </tables>
  58  </module>