INSERT INTO wp_wic_option_group ( option_group_slug, option_group_desc, enabled, is_system_reserved, last_updated_time) VALUES
( 'email_parse_options', 'Parse overall options', 1,  1, '2000-01-01 01:01:01'),
( 'email_source_options', 'Email Source Options', 1,  1, '2000-01-01 01:01:01'),
( 'zip_options', 'Parse zip options', 1,  1, '2000-01-01 01:01:01'),
( 'capitalization_options', 'Capitalization options', 1,  1, '2000-01-01 01:01:01'),
( 'city_word_count_options', 'City Word Count options', 1,  1, '2000-01-01 01:01:01'),
( 'street_word_count_options', 'Street Word Count options', 1,  1, '2000-01-01 01:01:01'),
( 'minimum_name_length_options', 'Minimum name length options', 1,  1, '2000-01-01 01:01:01'),
( 'maximum_name_length_options', 'Maximum name length options', 1,  1, '2000-01-01 01:01:01');
INSERT INTO wp_wic_option_value ( parent_option_group_slug, option_value, option_label, value_order, enabled, last_updated_time ) VALUES
( 'email_parse_options', '1', 'Strict name and address', 10, 1, '2000-01-01 01:01:01'),
( 'email_parse_options', '2', 'Medium name and address', 20, 1, '2000-01-01 01:01:01'),
( 'email_parse_options', '3', 'Medium with name only', 30, 1, '2000-01-01 01:01:01'),
( 'email_parse_options', '4', 'Medium with no name (email or email and address)', 40, 1, '2000-01-01 01:01:01'),
( 'email_parse_options', '5', 'Loose -- will accept essentially all emails', 50, 1, '2000-01-01 01:01:01'),
( 'email_source_options', '1', 'Auto -- accept best guess from headers or text body', 10, 1, '2000-01-01 01:01:01'),
( 'email_source_options', '2', 'Auto soft -- accept best guess from headers or text body regardless of positioning', 20, 1, '2000-01-01 01:01:01'),
( 'email_source_options', '3', 'Force -- take from text body regardless of positioning (may fail parse)', 25, 1, '2000-01-01 01:01:01'),
( 'email_source_options', '4', 'Force -- ignore email in body (use reply_to, if available, or from)', 30, 1, '2000-01-01 01:01:01'),
( 'zip_options', '1', 'Require proper zip code -- 02133 or 02133-9943', 10, 1, '2000-01-01 01:01:01'),
( 'zip_options', '2', 'Accept sloppy zip -- 021339943', 20, 1, '2000-01-01 01:01:01'),
( 'zip_options', '3', 'Allow address with no zip', 30, 1, '2000-01-01 01:01:01'),
( 'capitalization_options', '1', 'Require proper capitalization -- Boston, MA', 10, 1, '2000-01-01 01:01:01'),
( 'capitalization_options', '2', 'Ignore capitalization -- accept boston, mA', 20, 1, '2000-01-01 01:01:01'),
( 'city_word_count_options', '1', 'Accept only one word cities -- Fallsburg', 10, 1, '2000-01-01 01:01:01'),
( 'city_word_count_options', '2', 'Accept up to two word cities -- South Fallsburg', 20, 1, '2000-01-01 01:01:01'),
( 'city_word_count_options', '3', 'Accept up to three word cities -- South Fallsburg Beach', 30, 1, '2000-01-01 01:01:01'),
( 'city_word_count_options', '4', 'Accept up to four word cities -- Lower South Fallsburg Beach', 40, 1, '2000-01-01 01:01:01'),
( 'street_word_count_options', '1', 'Accept only one word street names -- Main St', 10, 1, '2000-01-01 01:01:01'),
( 'street_word_count_options', '2', 'Accept up to two word street names -- South Main St', 20, 1, '2000-01-01 01:01:01'),
( 'street_word_count_options', '3', 'Accept up to three word street names -- Major Joseph Deegan Parkway', 30, 1, '2000-01-01 01:01:01'),
( 'street_word_count_options', '4', 'Accept up to four word street names -- Major Joseph L Deegan Parkway', 40, 1, '2000-01-01 01:01:01'),
( 'minimum_name_length_options', '1', 'Accept one word names -- John', 10, 1, '2000-01-01 01:01:01'),
( 'minimum_name_length_options', '2', 'Require at least two words in a name -- John Doe', 20, 1, '2000-01-01 01:01:01'),
( 'maximum_name_length_options', '2', 'Accept up to two word names -- Mr. John Doe', 10, 1, '2000-01-01 01:01:01'),
( 'maximum_name_length_options', '3', 'Accept up to three word names-- Mr. John M Doe-Jones Esq.', 20, 1, '2000-01-01 01:01:01'),
( 'maximum_name_length_options', '4', 'Accept up to four word names -- John Parker Hudgens Doe-Jones, A.B., M.A., Ph.D.', 30, 1, '2000-01-01 01:01:01'),
( 'maximum_name_length_options', '5', 'Accept up to five word names -- John L Parker Hudgens Doe-Jones', 40, 1, '2000-01-01 01:01:01');