[Summary view] [Print] [Text view]

   1  <?xml version='1.0'?>
   2  <module>
   3      <name>EmailTemplates</name>
   4      <label>Email Templates</label>
   5      <parent>Tools</parent>
   6      <type>extension</type>
   7      <version>1.0</version>
   8      <dependencies>
   9          <vtiger_version>6.0.0rc</vtiger_version>
  10          <vtiger_max_version>6.*</vtiger_max_version>
  11      </dependencies>
  12      <tables>
  13          <table>
  14              <name>vtiger_emailtemplates</name>
  15               <sql><![CDATA[CREATE TABLE `vtiger_emailtemplates` (
  16                      `foldername` varchar(100) DEFAULT NULL,
  17                      `templatename` varchar(100) DEFAULT NULL,
  18                      `subject` varchar(100) DEFAULT NULL,
  19                      `description` text,
  20                      `body` text,
  21                      `deleted` int(1) NOT NULL DEFAULT '0',
  22                      `templateid` int(19) NOT NULL AUTO_INCREMENT,
  23                      PRIMARY KEY (`templateid`),
  24                      KEY `emailtemplates_foldernamd_templatename_subject_idx` (`foldername`,`templatename`,`subject`
  25                  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8]]>
  26              </sql>
  27          </table>
  28          <table>
  29              <name>vtiger_emailtemplates_seq</name>
  30              <sql><![CDATA[CREATE TABLE  `vtiger_emailtemplates_seq` (
  31                      `id` int(11) NOT NULL
  32                      ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]>
  33              </sql>
  34          </table>
  35      </tables>    
  36  </module>