Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zarankumar/5631b99d7dabe9c0c8ccb0f986c397d4 to your computer and use it in GitHub Desktop.
Save zarankumar/5631b99d7dabe9c0c8ccb0f986c397d4 to your computer and use it in GitHub Desktop.
/*
While installing new vtiger 6.5 or 7.0 you will face a troubele while creating webform. This is atually because of table error.
use following quick fix.
*/
CREATE TABLE 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(10) DEFAULT NULL,
hidden int(10) DEFAULT NULL,
PRIMARY KEY (id),
KEY webforms_webforms_field_idx (id),
KEY fk_1_vtiger_webforms_field (webformid),
KEY fk_2_vtiger_webforms_field (fieldname),
CONSTRAINT fk_1_vtiger_webforms_field FOREIGN KEY (webformid)
REFERENCES vtiger_webforms (id) ON DELETE CASCADE,
CONSTRAINT fk_3_vtiger_webforms_field FOREIGN KEY (fieldname)
REFERENCES vtiger_field (fieldname) ON DELETE CASCADE
) ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment