[ Index ]

PHP Cross Reference of vtigercrm-6.1.0

title

Body

[close]

/pkg/vtiger/modules/Webforms/ -> manifest.xml (source)

   1  <?xml version='1.0'?>
   2  <module>
   3  <name>Webforms</name>
   4  <label>Webforms</label>
   5  <parent></parent>
   6  <type>extension</type>
   7  <version>1.5</version>
   8  <dependencies>
   9    <vtiger_version>6.0.0rc</vtiger_version> 
  10    <vtiger_max_version>6.*</vtiger_max_version> 
  11  </dependencies>
  12  <migrations>
  13      <migration version='1.4'>
  14          <tables>
  15              <table>
  16                  <name>vtiger_webforms_field</name>
  17                  <sql><![CDATA[ALTER TABLE vtiger_webforms_field MODIFY neutralizedfield varchar(255)]]></sql>
  18              </table>
  19          </tables>
  20      </migration>
  21  </migrations>
  22  <tables>
  23  <table>
  24  <name>vtiger_webforms</name>
  25  <sql><![CDATA[CREATE TABLE `vtiger_webforms` (
  26    `id` int(19) NOT NULL AUTO_INCREMENT,
  27    `name` varchar(100) NOT NULL,
  28    `publicid` varchar(100) NOT NULL,
  29    `enabled` int(1) NOT NULL DEFAULT '1',
  30    `targetmodule` varchar(50) NOT NULL,
  31    `description` varchar(250) DEFAULT NULL,
  32    `ownerid` int(19) NOT NULL,
  33    `returnurl` varchar(250) DEFAULT NULL,
  34    `captcha` int(1) NOT NULL DEFAULT '0',
  35    `roundrobin` int(1) NOT NULL DEFAULT '0',
  36    `roundrobin_userid` varchar(256)DEFAULT NULL,
  37    `roundrobin_logic` int(11) NOT NULL DEFAULT '0',
  38    PRIMARY KEY (`id`),
  39    UNIQUE KEY `webformname` (`name`),
  40    UNIQUE KEY `publicid` (`id`),
  41    KEY `webforms_webforms_id_idx` (`id`)
  42  ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql>
  43  </table>
  44  <table>
  45  <name>vtiger_webforms_field</name>
  46  <sql><![CDATA[CREATE TABLE `vtiger_webforms_field` (
  47    `id` int(19) NOT NULL AUTO_INCREMENT,
  48    `webformid` int(19) NOT NULL,
  49    `fieldname` varchar(50) NOT NULL,
  50    `neutralizedfield` varchar(50) NOT NULL,
  51    `defaultvalue` varchar(200) DEFAULT NULL,
  52    `required` int(10) NOT NULL DEFAULT '0',
  53    `sequence` int(10) DEFAULT NULL,
  54    `hidden` int(10) DEFAULT NULL,
  55    PRIMARY KEY (`id`),
  56    KEY `webforms_webforms_field_idx` (`id`),
  57    KEY `fk_1_vtiger_webforms_field` (`webformid`),
  58    KEY `fk_2_vtiger_webforms_field` (`fieldname`),
  59    CONSTRAINT `fk_1_vtiger_webforms_field` FOREIGN KEY (`webformid`) REFERENCES `vtiger_webforms` (`id`) ON DELETE CASCADE,
  60    CONSTRAINT `fk_3_vtiger_webforms_field` FOREIGN KEY (`fieldname`) REFERENCES `vtiger_field` (`fieldname`) ON DELETE CASCADE
  61  ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sql>
  62  </table>
  63  </tables>
  64  <crons>
  65  </crons>
  66  </module>


Generated: Fri Nov 28 20:08:37 2014 Cross-referenced by PHPXref 0.7.1