Index: branches/5.2.x/_install/install_data.sql =================================================================== diff -u -r14242 -r14613 --- branches/5.2.x/_install/install_data.sql (.../install_data.sql) (revision 14242) +++ branches/5.2.x/_install/install_data.sql (.../install_data.sql) (revision 14613) @@ -22,14 +22,14 @@ INSERT INTO PermCache VALUES(DEFAULT, 202, 1, '11'); INSERT INTO PermCache VALUES(DEFAULT, 203, 1, '11'); -INSERT INTO Forms VALUES(1, 'Contact Us', 'Form for contacts', 0, 1, 0, 0, '', '', '', '', '', '', '110', '', '', '', '', '110', '', ''); +INSERT INTO Forms VALUES(1, 'Contact Us', 'Form for contacts', 0, 1, '', 0, 0, '', '', '', '', '', '', '110', '', '', '', '', '110', '', ''); -INSERT INTO FormFields VALUES(1, 1, 0, 'Name', 'lu_fld_Name', NULL, 'la_fld_Name', 'text', NULL, 5, 0, 1, 1, NULL, 0, 1, 1); -INSERT INTO FormFields VALUES(2, 1, 0, 'Company', 'lu_fld_Company', NULL, 'la_fld_Company', 'text', NULL, 4, 0, 1, 1, NULL, 0, 1, 0); -INSERT INTO FormFields VALUES(3, 1, 0, 'Email', 'lu_fld_Email', NULL, 'la_fld_Email', 'text', NULL, 3, 0, 1, 1, NULL, 1, 1, 2); -INSERT INTO FormFields VALUES(4, 1, 0, 'Phone', 'lu_fld_Phone', NULL, 'la_fld_Phone', 'text', NULL, 2, 0, 0, 1, NULL, 0, 1, 0); -INSERT INTO FormFields VALUES(5, 1, 0, 'Message', 'lu_fld_Message', NULL, 'la_fld_Message', 'textarea', NULL, 0, 0, 1, 0, NULL, 0, 1, 4); -INSERT INTO FormFields VALUES(6, 1, 0, 'Subject', 'lu_fld_Subject', NULL, 'la_fld_Subject', 'select', '=+-- Please select --||0=+Sales questions||1=+General questions||2=+Billing questions||3=+Support questions', 1, 0, 1, 0, NULL, 0, 1, 3); +INSERT INTO FormFields VALUES(1, 1, 0, 'Name', 'lu_fld_Name', NULL, 'la_fld_Name', 'text', NULL, 5, 0, 1, 1, NULL, 0, '', NULL, 1, 1); +INSERT INTO FormFields VALUES(2, 1, 0, 'Company', 'lu_fld_Company', NULL, 'la_fld_Company', 'text', NULL, 4, 0, 1, 1, NULL, 0, '', NULL, 1, 0); +INSERT INTO FormFields VALUES(3, 1, 0, 'Email', 'lu_fld_Email', NULL, 'la_fld_Email', 'text', NULL, 3, 0, 1, 1, NULL, 1, '', NULL, 1, 2); +INSERT INTO FormFields VALUES(4, 1, 0, 'Phone', 'lu_fld_Phone', NULL, 'la_fld_Phone', 'text', NULL, 2, 0, 0, 1, NULL, 0, '', NULL, 1, 0); +INSERT INTO FormFields VALUES(5, 1, 0, 'Message', 'lu_fld_Message', NULL, 'la_fld_Message', 'textarea', NULL, 0, 0, 1, 0, NULL, 0, '', NULL, 1, 4); +INSERT INTO FormFields VALUES(6, 1, 0, 'Subject', 'lu_fld_Subject', NULL, 'la_fld_Subject', 'select', '=+-- Please select --||0=+Sales questions||1=+General questions||2=+Billing questions||3=+Support questions', 1, 0, 1, 0, NULL, 0, '', NULL, 1, 3); ALTER TABLE FormSubmissions ADD COLUMN fld_1 text,