INSERT INTO Forms VALUES(1, 'Contact Form', 'Contact Form', 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, 0, 1, NULL, 0, 1, 0); INSERT INTO FormFields VALUES(3, 1, 0, 'Email', 'lu_fld_Email', NULL, 'la_fld_Email', 'text', NULL, 3, 0, 0, 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, '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(6, 1, 0, 'Message', 'lu_fld_Message', NULL, 'la_fld_Message', 'textarea', NULL, 0, 0, 1, 0, NULL, 0, 1, 4); ALTER TABLE FormSubmissions ADD COLUMN fld_1 text, ADD COLUMN fld_2 text, ADD COLUMN fld_3 text, ADD COLUMN fld_4 text, ADD COLUMN fld_5 text, ADD COLUMN fld_6 text; UPDATE SystemSettings SET VariableValue = 'In-Portal Shopping Cart' WHERE VariableName = 'Site_Name';