[Summary view] [Print] [Text view]

   1  <?xml version='1.0'?>
   2  <schema>
   3      <tables>
   4          <table>
   5              <name>vtiger_emailtemplates</name>
   6              <sql><![CDATA[CREATE TABLE `vtiger_emailtemplates` (
   7                      `foldername` varchar(100) DEFAULT NULL,
   8                      `templatename` varchar(100) DEFAULT NULL,
   9                      `subject` varchar(100) DEFAULT NULL,
  10                      `description` text,
  11                      `body` text,
  12                      `deleted` int(1) NOT NULL DEFAULT '0',
  13                      `templateid` int(19) NOT NULL AUTO_INCREMENT,
  14                      PRIMARY KEY (`templateid`),
  15                      KEY `emailtemplates_foldernamd_templatename_subject_idx` (`foldername`,`templatename`,`subject`
  16                  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
  17              ]]></sql>
  18          </table>
  19          <table>
  20              <name>vtiger_emailtemplates_seq</name>
  21              <sql><![CDATA[CREATE TABLE  `vtiger_emailtemplates_seq` (
  22                      `id` int(11) NOT NULL
  23                      ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  24              ]]></sql>
  25          </table>
  26      </tables>
  27  </schema>