[ Index ] |
PHP Cross Reference of vtigercrm-6.1.0 |
[Summary view] [Print] [Text view]
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>
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
Generated: Fri Nov 28 20:08:37 2014 | Cross-referenced by PHPXref 0.7.1 |