Last active
July 21, 2017 06:56
-
-
Save zarankumar/5631b99d7dabe9c0c8ccb0f986c397d4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
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