[Vtigercrm-developers] webforms 6.1 (SIAM Translations)

[SIAM Translations]

Thanks Andreas

Got many forms so I altered tables and it works. Migration script didnt
create new columns thats why blocker.

regards
Andrew Smith

On Sat, Sep 27, 2014 at 12:56 AM, Andreas Göbel <andreas.goebel at a-g-c.de>
wrote:

> Here is the solution (all done in the database):
> Drop table vtiger_webforms.
> Then re-add vtiger_webforms and add vtiger_webforms_field as follows:
>
> CREATE TABLE IF NOT EXISTS `vtiger_webforms` (
>   `id` int(19) NOT NULL AUTO_INCREMENT,
>   `name` varchar(100) NOT NULL,
>   `publicid` varchar(100) NOT NULL,
>   `enabled` int(1) NOT NULL DEFAULT '1',
>   `targetmodule` varchar(50) NOT NULL,
>   `description` text,
>   `ownerid` int(19) NOT NULL,
>   `returnurl` varchar(250) DEFAULT NULL,
>   `captcha` tinyint(4) NOT NULL DEFAULT '0',
>   `roundrobin` tinyint(4) NOT NULL DEFAULT '0',
>   `roundrobin_userid` text,
>   `roundrobin_logic` int(11) NOT NULL DEFAULT '0',
>   PRIMARY KEY (`id`),
>   UNIQUE KEY `webformname` (`name`),
>   UNIQUE KEY `publicid` (`id`),
>   KEY `webforms_webforms_id_idx` (`id`)
> ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
>
> CREATE TABLE IF NOT EXISTS `vtiger_webforms_field` (
>   `id` int(19) NOT NULL AUTO_INCREMENT,
>   `webformid` int(19) NOT NULL,
>   `fieldname` varchar(50) NOT NULL,
>   `neutralizedfield` varchar(50) NOT NULL,
>   `defaultvalue` varchar(200) DEFAULT NULL,
>   `required` int(10) NOT NULL DEFAULT '0',
>   `sequence` int(11) NOT NULL DEFAULT '0',
>   `hidden` tinyint(4) NOT NULL DEFAULT '0',
>   PRIMARY KEY (`id`),
>   KEY `webforms_webforms_field_idx` (`id`),
>   KEY `fk_1_vtiger_webforms_field` (`webformid`),
>   KEY `fk_2_vtiger_webforms_field` (`fieldname`)
> ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
>
>
> Mit freundlichen Grüßen / Kind Regards
>   Andreas Göbel
>
> AG Consulting
>
>
>
>
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140927/a9a7d8ac/attachment-0001.html>