install_data.sql
No OneTemporary
Actions

Subscribers

None

File Metadata

	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';