CREATE TABLE report_values_updates(element_id int(10) AUTO_INCREMENT PRIMARY KEY, report_id int(11), element_descr varchar(500), element_text_value varchar(500), element_double_value double, active_flag varchar(1) default 'Y', create_date timestamp, inactive_date date, user_comment varchar(2000), FOREIGN KEY(report_id) REFERENCES report_params(rpt_id)); INSERT INTO report_values_updates (report_id, element_descr, element_text_value, user_comment) VALUES(43, '...bids are coming in between xx pct range of retail', '15% to 23%', 'text value replaces the xx'); INSERT INTO report_values_updates (report_id, element_descr, element_double_value, user_comment) VALUES(43, '...Print with a Retail Cost of xx', '45640', 'double (dollar) value replaces the xx'); INSERT INTO report_values_updates (report_id, element_descr, element_text_value, user_comment) VALUES(43, '...is coming in at xx of Retail', '$7,342...16%', 'text value replaces the xx');