CREATE TABLE geodesic_price_plan_ad_lengths (
  length_id int(11) NOT NULL auto_increment,
  price_plan_id int(11) NOT NULL default '0',
  length_of_ad int(11) NOT NULL default '0',
  display_length_of_ad tinytext NOT NULL,
  length_charge double(5,2) NOT NULL default '0.00',
  UNIQUE KEY length_id (length_id)
) TYPE=MyISAM<br>
CREATE TABLE geodesic_classifieds_price_plans_categories (
  category_price_plan_id int(11) NOT NULL auto_increment,
  price_plan_id int(11) NOT NULL default '0',
  category_id int(11) NOT NULL default '0',
  charge_per_ad_type int(11) NOT NULL default '0',
  charge_per_ad double(5,2) NOT NULL default '0.00',
  featured_ad_price double(5,2) NOT NULL default '0.00',
  bolding_price double(5,2) NOT NULL default '0.00',
  attention_getter_price double(5,2) NOT NULL default '0.00',
  charge_per_picture double(5,2) NOT NULL default '0.00',
  better_placement_charge double(5,2) NOT NULL default '0.00',
  ad_renewal_cost double(5,2) NOT NULL default '0.00',
  UNIQUE KEY category_price_plan_id (category_price_plan_id)
) TYPE=MyISAM<br>
CREATE TABLE geodesic_cc_twocheckout (
  sid varchar(25) NOT NULL default '',
  demo_mode int(11) NOT NULL default '0'
) TYPE=MyISAM<br>
CREATE TABLE geodesic_cc_twocheckout_transactions (
  transaction_id int(11) NOT NULL auto_increment,
  user_id tinytext NOT NULL,
  order_number varchar(50) NOT NULL default '',
  card_holder_name tinytext NOT NULL,
  street_address tinytext NOT NULL,
  city tinytext NOT NULL,
  state tinytext NOT NULL,
  zip tinytext NOT NULL,
  country tinytext NOT NULL,
  email tinytext NOT NULL,
  phone tinytext NOT NULL,
  merchant_order_id int(11) NOT NULL default '0',
  credit_card_processed tinytext NOT NULL,
  tax double(10,2) NOT NULL default '0.00',
  total double(10,2) NOT NULL default '0.00',
  ship_name tinytext NOT NULL,
  ship_street_address tinytext NOT NULL,
  ship_city tinytext NOT NULL,
  ship_state tinytext NOT NULL,
  ship_country tinytext NOT NULL,
  ship_zip tinytext NOT NULL,
  product_id int(11) NOT NULL default '0',
  quantity int(11) NOT NULL default '0',
  merchant_product_id int(11) NOT NULL default '0',
  product_description tinytext NOT NULL,
  KEY transacation_id (transaction_id)
) TYPE=MyISAM<br>
CREATE TABLE geodesic_worldpay_transactions (
  transaction_id int(11) NOT NULL auto_increment,
  session_id tinytext NOT NULL,
  classified_id int(11) NOT NULL default '0',
  user_id int(11) NOT NULL default '0',
  first_name tinytext NOT NULL,
  last_name tinytext NOT NULL,
  address tinytext NOT NULL,
  city tinytext NOT NULL,
  state tinytext NOT NULL,
  country tinytext NOT NULL,
  zip varchar(15) NOT NULL default '',
  email tinytext NOT NULL,
  tax double(5,2) NOT NULL default '0.00',
  amount double(5,2) NOT NULL default '0.00',
  fax varchar(20) NOT NULL default '',
  phone varchar(20) NOT NULL default '',
  company tinytext NOT NULL,
  transaction_description tinytext NOT NULL,
  transStatus varchar(4) NOT NULL default '',
  transTime varchar(20) NOT NULL default '',
  authAmount double(5,2) NOT NULL default '0.00',
  authCurrency varchar(10) NOT NULL default '',
  authAmountString tinytext NOT NULL,
  rawAuthMessage tinytext NOT NULL,
  rawAuthCode tinytext NOT NULL,
  callbackPW tinytext NOT NULL,
  cardType varchar(20) NOT NULL default '',
  countryString varchar(20) NOT NULL default '',
  countryMatch varchar(5) NOT NULL default '',
  AVS varchar(5) NOT NULL default '',
  ad_placement int(11) NOT NULL default '0',
  renew int(11) NOT NULL default '0',
  bolding int(11) NOT NULL default '0',
  better_placement int(11) NOT NULL default '0',
  featured_ad int(11) NOT NULL default '0',
  attention_getter int(11) NOT NULL default '0',
  attention_getter_choice int(11) NOT NULL default '0',
  UNIQUE KEY transaction_id (transaction_id)
) TYPE=MyISAM<br>
CREATE TABLE geodesic_worldpay_settings (
  worldpay_installation_id int(11) NOT NULL default '0',
  currency_type varchar(4) NOT NULL default '',
  test_mode int(11) NOT NULL default '0',
  callback_password tinytext NOT NULL
) TYPE=MyISAM<br>
CREATE TABLE geodesic_currency_types (
  type_id int(11) NOT NULL auto_increment,
  type_name tinytext NOT NULL,
  precurrency tinytext NOT NULL,
  postcurrency tinytext NOT NULL,
  display_order int(11) NOT NULL default '0',
  UNIQUE KEY type_id (type_id),
  KEY type_id_2 (type_id)
) TYPE=MyISAM<br>
INSERT INTO geodesic_credit_card_choices VALUES (2, 0, '2 Checkout', 'This allows the use of the 2Checkout.com payment gateway', 'geodesic_cc_twocheckout', 'geodesic_cc_twocheckout_transactions', 'cc_initiate_2checkout.php', 'cc_process_2checkout.php', 'admin_cc_2checkout.php')<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `place_ads_only_in_terminal_categories` INT default '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `use_explorer_category_process` INT default '1' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `category_tree_display` INT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `edit_details` INT default '1' NOT NULL <br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `edit_images` INT default '1' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `edit_category` INT default '1' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `entry_date_configuration` VARCHAR(20) default 'M j-G:i' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `send_ad_expire_email` INT default '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `email_configuration` INT default '1' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `days_to_renew` INT default '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `show_country_dropdown` TINYINT NOT NULL default '1'<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `show_state_dropdown` TINYINT NOT NULL default '1'<br>
ALTER TABLE geodesic_classifieds_configuration ADD classifieds_ssl_url TINYTEXT not null AFTER classifieds_url <br>
ALTER TABLE `geodesic_classifieds_configuration` ADD use_ssl_in_sell_process TINYINT DEFAULT '0' not null AFTER classifieds_ssl_url<br>
ALTER TABLE geodesic_classifieds_configuration ADD registration_ssl_url TINYTEXT not null AFTER registration_url<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD use_ssl_in_registration TINYINT DEFAULT '0' not null AFTER registration_ssl_url<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `use_email_verification_at_registration` INT NOT NULL AFTER `send_register_attempt_email_admin`<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `send_ad_expire_email` INT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `number_of_featured_ads_to_display_home` INT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `number_of_new_ads_to_display_home` INT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `use_zip_field` INT NOT NULL AFTER `use_country_field`<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `use_address_field` INT NOT NULL AFTER `use_company_name_field`<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `use_city_field` INT NOT NULL AFTER `use_address_field`<br>
ALTER TABLE `geodesic_classifieds_configuration` CHANGE `width_of_pages` `width_of_pages` VARCHAR(6) DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `meta_tags` MEDIUMTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `body_background_color` VARCHAR(25) NOT NULL<br>
ALTER TABLE `geodesic_paypal_transactions` ADD `ad_placement` INT NOT NULL<br>
ALTER TABLE `geodesic_paypal_transactions` ADD `transaction_id` INT NOT NULL FIRST<br>
ALTER TABLE `geodesic_paypal_transactions` ADD `renew` INT NOT NULL AFTER `verify_sign`<br>
ALTER TABLE `geodesic_classifieds_ad_configuration` ADD `send_successful_placement_email` TINYINT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_ad_configuration` ADD `price_field_number_only` INT NOT NULL AFTER `use_price_field`<br>
ALTER TABLE `geodesic_classifieds_ad_configuration` ADD `image_upload_type` INT NOT NULL AFTER `user_extra_template`<br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `currency_type` INT NOT NULL AFTER `price`<br>
ALTER TABLE `geodesic_classifieds` ADD `precurrency` VARCHAR(25) NOT NULL AFTER `description`<br>
ALTER TABLE `geodesic_classifieds` ADD `postcurrency` VARCHAR(25) NOT NULL AFTER `price`<br>
ALTER TABLE `geodesic_classifieds` ADD `expiration_notice` INT NOT NULL<br>
ALTER TABLE `geodesic_classifieds` CHANGE `price` `price` VARCHAR(50) NOT NULL<br>
ALTER TABLE `geodesic_classifieds` CHANGE `duration` `duration` INT (11) DEFAULT NULL<br>
ALTER TABLE `geodesic_classifieds_ads_extra` ADD `display_order` INT NOT NULL<br>
ALTER TABLE `geodesic_font_elements` ADD `text_transform` VARCHAR(15) NOT NULL, ADD `text_vertical_align` VARCHAR(15) NOT NULL<br>
ALTER TABLE `geodesic_cc_authorizenet` ADD `transaction_key` VARCHAR(50) NOT NULL AFTER `merchant_login`<br>
ALTER TABLE `geodesic_cc_authorizenet` ADD `currency_code` VARCHAR(10) NOT NULL AFTER `transaction_key`<br>
ALTER TABLE `geodesic_cc_authorizenet` ADD `merchant_password` TINYTEXT NOT NULL<br>
ALTER TABLE `geodesic_cc_authorizenet` ADD `merchant_type` INT NOT NULL<br>
ALTER TABLE `geodesic_cc_authorizenet` ADD `connection_type` INT NOT NULL<br>
ALTER TABLE `geodesic_cc_authorizenet_transactions` ADD `ad_placement` INT NOT NULL<br>
ALTER TABLE `geodesic_cc_authorizenet_transactions` ADD `renew` INT NOT NULL<br>
ALTER TABLE geodesic_classifieds_categories CHANGE parent_id parent_id INT (11)<br>
ALTER TABLE geodesic_classifieds_categories CHANGE category_id category_id INT (11) not null AUTO_INCREMENT<br>
ALTER TABLE geodesic_classifieds_categories CHANGE display_order display_order INT (6)<br>
ALTER TABLE `geodesic_classifieds_price_plans` ADD `charge_per_ad_type` INT NOT NULL AFTER `charge_per_ad`<br>
ALTER TABLE `geodesic_classifieds_price_plans` CHANGE `credits_expire_period` `credits_expire_period` INT (11) DEFAULT '1' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_price_plans` CHANGE `subscription_billing_period` `subscription_billing_period` INT (11)  DEFAULT '1' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_price_plans` CHANGE `free_subscription_period_upon_registration` `free_subscription_period_upon_registration` INT (11)  DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_price_plans` CHANGE `ad_and_subscription_expiration` `ad_and_subscription_expiration` INT (11)  DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_price_plans` CHANGE `max_ads_allowed` `max_ads_allowed` INT (11)  DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_font_elements` CHANGE `background_image` `background_image` TINYTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_sell_session_questions` ADD `display_order` INT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_ad_configuration` ADD `photo_quality` INT DEFAULT '75' NOT NULL<br>
ALTER TABLE `geodesic_cc_twocheckout_transactions` ADD `first_name` TINYTEXT NOT NULL AFTER `card_holder_name` ,
ADD `last_name` TINYTEXT NOT NULL AFTER `first_name` <br>
ALTER TABLE `geodesic_cc_twocheckout_transactions` ADD `fax` TINYTEXT NOT NULL AFTER `phone` <br>
ALTER TABLE `geodesic_cc_twocheckout_transactions` ADD `company` TINYTEXT NOT NULL AFTER `last_name` <br>
ALTER TABLE `geodesic_cc_twocheckout_transactions` ADD `renew` INT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_userdata` ADD `expose_email` INT NOT NULL, ADD `expose_company_name` INT NOT NULL, ADD `expose_firstname` INT NOT NULL, ADD `expose_lastname` INT NOT NULL, ADD `expose_address` INT NOT NULL, ADD `expose_city` INT NOT NULL, ADD `expose_state` INT NOT NULL, ADD `expose_country` INT NOT NULL, ADD `expose_zip` INT NOT NULL, ADD `expose_phone` INT NOT NULL, ADD `expose_phone2` INT NOT NULL, ADD `expose_fax` INT NOT NULL, ADD `expose_url` INT NOT NULL<br>
update geodesic_text_messages set text_page_sub_id = 39, text_name = 'registration+success+email+subject', text_description = 'Subject+field+of+registration+success+email+sent+to+registrant+once+registration+is+complete' where text_id = 196<br>
ALTER TABLE `geodesic_classifieds_sell_session_questions` CHANGE `question_value` `question_value` TEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_ads_extra` CHANGE `value` `value` TEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_user_credits` CHANGE `credit_count` `credit_count` INT DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_file_types` ADD `icon_to_use` TINYTEXT NOT NULL AFTER `accept`<br>
ALTER TABLE `geodesic_classifieds_file_types` ADD `extension` TINYTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_images_urls` ADD `filesize` INT NOT NULL, ADD `filesize_displayed` VARCHAR(20) NOT NULL, ADD `icon` TINYTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` CHANGE `thumbnail_max_height` `thumbnail_max_height` INT(11) DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifeds_configuration` CHANGE `thumbnail_max_width` `thumbnail_max_width` INT(11) DEFAULT '0' NOT NULL<br>
update geodesic_text_messages set text_page_sub_id = 38 where text_id = 209<br>
update geodesic_text_messages set text_page_sub_id = 38 where text_id = 208<br>
update geodesic_text_messages set text_page_sub_id = 39 where text_id = 210<br>
update geodesic_text_messages set text_page_sub_id = 37 where text_id = 199<br>
update geodesic_text_messages set text_page_sub_id = 39 where text_id = 197<br>
update geodesic_text_messages set text_page_sub_id = 38 where text_id = 196<br>
update geodesic_text_messages set text_page_sub_id = 0 where text_id = 231<br>
update geodesic_text_messages set text_page_sub_id = 13 where text_id = 59<br>
update geodesic_text_messages set text_name = 'successful email subject',text_description=''  where text_id = 210<br>
update geodesic_text_messages set text_name = 'registration confirmation email subject',text_description=''  where text_id = 196<br>
update geodesic_text_messages set text_name = 'welcome text before username',text_description=''  where text_id = 208<br>
update geodesic_text_messages set text_name = 'welcome paragraph after username',text_description=''  where text_id = 209<br>
update geodesic_text_messages set text_name = 'registration success email body',text_description=''  where text_id = 197<br>
update geodesic_font_elements set text_align = 'right', text_vertical_align='top' where element_id = 74<br>
ALTER TABLE `geodesic_classifieds_ads_extra` ADD `checkbox` INT NOT NULL AFTER `explanation`<br>
ALTER TABLE `geodesic_classifieds_ads_extra` CHANGE `explanation` `explanation` MEDIUMTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `paypal_currency_rate` DOUBLE(5,4) NOT NULL AFTER `paypal_id`<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `paypal_currency` VARCHAR(15) NOT NULL AFTER `paypal_currency_rate`<br>
ALTER TABLE `geodesic_classifieds_sell_questions` ADD `url_icon` TINYTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_ads_extra` ADD `url_icon` TINYTEXT NOT NULL<br>
ALTER TABLE `geodesic_banners` CHANGE `external_code_use` `external_code_use` MEDIUMTEXT NOT NULL<br>
ALTER TABLE `geodesic_price_plan_ad_lengths` ADD `category_id` INT DEFAULT '0' NOT NULL AFTER `price_plan_id` <br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `levels_of_categories_displayed` INT DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `admin_approves_all_ads` INT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_states` CHANGE `abbreviation` `abbreviation` TINYTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_states` CHANGE `name` `name` TINYTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_countries` CHANGE `name` `name` TINYTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_countries` CHANGE `abbreviation` `abbreviation` TINYTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `use_template_within_ad_approval` INT DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds` ADD `email` TINYTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `email_option` TINYTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_ad_configuration` ADD `use_email_override` INT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `use_api` INT default '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_ad_configuration` ADD `use_email_override` INT DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_ad_configuration` ADD `username_is_email_link` INT DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_ad_configuration` ADD `imagecreatetruecolor_switch` INT DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `use_zip_distance_calculator` INT DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `display_entry_date_in_newest` INT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `edit_reset_date` INT DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `subcategory_description` INT DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `seller_contact` INT DEFAULT '0' NOT NULL<br>
ALTER TABLE `geodesic_classifieds_categories` CHANGE `description` `description` MEDIUMTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_categories_languages` CHANGE `description` `description` MEDIUMTEXT NOT NULL<br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `show_date` INT DEFAULT '1' NOT NULL <br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `category_table_width` VARCHAR(11) DEFAULT '100%' NOT NULL <br>
UPDATE `geodesic_font_pages` SET `page_name` = 'Menu bar/Miscellaneous site wide' WHERE `text_page_id` = '4' LIMIT 1 <br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `user_greeting` INT DEFAULT '0' NOT NULL <br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `quick_search` INT DEFAULT '0' NOT NULL <br>
UPDATE `geodesic_text_pages` SET `page_name` = 'menu bar/miscellaneous site wide' WHERE `text_page_id` = '4' LIMIT 1 <br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `number_of_hottest_ads_to_display_home` INT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_s` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_ss` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_sd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_sss` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_ssd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_sds` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_sdd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_d` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_ds` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_dd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_dss` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_dsd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_dds` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds` ADD `pedigree_ddd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_s` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_ss` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_sd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_sss` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_ssd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_sds` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_sdd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_d` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_ds` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_dd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_dss` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_dsd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_dds` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_sell_session` ADD `pedigree_ddd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_s` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_ss` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_sd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_sss` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_ssd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_sds` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_sdd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_d` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_ds` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_dd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_dss` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_dsd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_dds` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_expired` ADD `pedigree_ddd` TINYTEXT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_configuration` ADD `use_pedigree` TINYINT NOT NULL <br>
ALTER TABLE `geodesic_classifieds_ad_configuration` ADD `textarea_wrap` INT DEFAULT '0' NOT NULL <br>
CREATE TABLE `geodesic_version`
(
`db_version` TINYTEXT NOT NULL
)<br>
<br><b>general table upgrades performed</b><br><br>
font element key 102 or required_field_marker - already exists<bR>
font element key 103 or category_specific_description - already exists<bR>
font element key 104 or image_collection - already exists<bR>
font element key 109 or submit_button_place_ad - already exists<bR>
font element key 105 or left_column_1 - already exists<bR>
font element key 106 or right_column_1 - already exists<bR>
font element key 107 or cat_tree - already exists<bR>
font element key 108 or title_ad - already exists<bR>
font element key 110 or place_an_ad_final_approval_cost_header_right - already exists<bR>
font element key 111 or total_field_right - already exists<bR>
font element key 112 or tax_field_right - already exists<bR>
font element key 113 or subtotal_field_right - already exists<bR>
font element key 114 or final_approval_section_title - already exists<bR>
font element key 115 or cost_item_row_right - already exists<bR>
font element key 116 or user_management_error_message - already exists<bR>
font element key 117 or renewal_title - already exists<bR>
font element key 118 or renewal_instructions - already exists<bR>
font element key 119 or renewal_field_label - already exists<bR>
font element key 120 or renewal_field_data - already exists<bR>
font element key 121 or renewal_field_explanation - already exists<bR>
font element key 122 or renewal_payment_title - already exists<bR>
font element key 123 or renewal_payment_explanation - already exists<bR>
font element key 124 or renewal_cc_payment_fields - already exists<bR>
font element key 125 or renewal_error_message - already exists<bR>
font element key 126 or renewal_submit_button - already exists<bR>
font element key 127 or renewal_back_to_my_ads_link - already exists<bR>
font element key 128 or renewal_transaction_header - already exists<bR>
font element key 129 or renewal_transaction_label_header - already exists<bR>
font element key 130 or renewal_transaction_data_header - already exists<bR>
font element key 131 or seller_info_header - already exists<bR>
font element key 132 or seller_info_fields - already exists<bR>
font element key 133 or seller_info_data - already exists<bR>
font element key 134 or search_page_field_data - already exists<bR>
font element key 135 or search_submit_button - already exists<bR>
font element key 136 or browsing_category_td - already exists<bR>
font element key 137 or date_display - already exists<bR>
font element key 138 or top_right_links - already exists<bR>
font element key 139 or welcome_user - already exists<bR>
font element key 140 or quick_search_box - already exists<bR>
font element key 142 or quick_search_box_text - already exists<bR>
font element key 143 or hottest_ad_row_header - already exists<bR>
font element key 144 or pedigree_data - already exists<bR>
delete from geodesic_font_elements where element_id = 45<br>
delete from geodesic_font_elements where element_id = 46<br>
delete from geodesic_font_elements where element_id = 47<br>
delete from geodesic_font_elements where element_id = 83<br>
delete from geodesic_font_elements where element_id = 85<br>
delete from geodesic_font_elements where element_id = 86<br>
delete from geodesic_font_elements where element_id = 87<br>
delete from geodesic_font_elements where element_id = 88<br>
delete from geodesic_font_elements where element_id = 95<br>
delete from geodesic_font_elements where element_id = 98<br>
delete from geodesic_text_subpages where sub_page_id = 11<br>
INSERT INTO geodesic_font_elements VALUES (45, 2, 7, 'left_column_data', 'Left field data', '', 'Arial, Helvetica, sans-serif', 12, 'normal', 'bold', '', '', '', '', 'right', '', '')<br>
INSERT INTO geodesic_font_elements VALUES (46, 2, 7, 'right_column_data', 'Right field data', '', 'Arial, Helvetica, sans-serif', 12, 'normal', 'normal', '', '', '', '', 'left', '', '')<br>
INSERT INTO geodesic_font_elements VALUES (47, 2, 7, 'category_specific_title', 'Category Specific Title', 'category fields area title', 'Arial, Helvetica, sans-serif', 14, 'normal', 'bold', '', '', '', '', 'center', '', '')<br>
INSERT INTO geodesic_font_elements VALUES (83, 2, 13, 'place_an_ad_section_titles', 'Section Title of Billing Information Page', 'Section titles of the subsections within the billing information form', 'Arial, Helvetica, sans-serif', 14, 'normal', 'bolder', '', '', '', '', 'center', '', '')<br>
INSERT INTO geodesic_font_elements VALUES (85, 2, 12, 'total_field_left', 'Total field - Left Side', 'Text appearing in the total line (left side)', 'Arial, Helvetica, sans-serif', 12, 'normal', 'bold', '', '', '', '', 'right', '', '')<br>
INSERT INTO geodesic_font_elements VALUES (86, 2, 12, 'tax_field_left', 'Tax Field - Left Side', 'Text and row of the tax field (left side)', 'Arial, Helvetica, sans-serif', 12, 'normal', 'bold', '', '', '', '', 'right', '', '')<br>
INSERT INTO geodesic_font_elements VALUES (87, 2, 12, 'subtotal_field_left', 'Subtotal Field - Left Side', 'Subtotal text and row', 'Arial, Helvetica, sans-serif', 12, 'normal', 'bold', '', '', '', '', 'right', '', '')<br>
INSERT INTO geodesic_font_elements VALUES (88, 2, 12, 'cost_item_row_left', 'Classified Ad Cost Rows - Left Side', 'Classified ad item costs (cost of ad, bolding, featured ad,....)', 'Arial, Helvetica, sans-serif', 12, 'normal', 'bold', '', '', '', '', 'right', '', '')<br>
INSERT INTO geodesic_font_elements VALUES (95, 2, 12, 'place_an_ad_final_approval_cost_header_left', 'Column Header for Final Cost Left Side', 'Column header in the form showing the final totals for the transaction(left side)', 'Arial, Helvetica, sans-serif', 14, 'normal', 'bolder', '', '', '', '', 'right', '', '')<br>
<br><b>geodesic_font_elements table upgraded</b><br><Br>geodesic_text_messages key 539 of Email+Verifier+Does+Not+Match+Error+Message - already exists<bR>
geodesic_text_messages key 540 of Email+Verifier+Field - already exists<bR>
geodesic_text_messages key 541 of Choose+Terminal+Category+Message - already exists<bR>
geodesic_text_messages key 542 of Choose+Category - already exists<bR>
geodesic_text_messages key 543 of Place+Only+in+Lowest+Categories+ - already exists<bR>
geodesic_text_messages key 544 of Communications+Configuration+Submission+Button - already exists<bR>
geodesic_text_messages key 545 of Price+Column+Header - already exists<bR>
geodesic_text_messages key 546 of days+next+to+duration - already exists<bR>
geodesic_text_messages key 547 of No+Communications+Currently+Message - already exists<bR>
geodesic_text_messages key 548 of Save+Filter+Button - already exists<bR>
geodesic_text_messages key 550 of All+Categories+Choice+in+Category+Dropdown - already exists<bR>
geodesic_text_messages key 601 of Ad+Renewal+Page+Instructions - already exists<bR>
geodesic_text_messages key 551 of Main+Category+Name+in+Ad+Detail - already exists<bR>
geodesic_text_messages key 552 of Optional+Search+Criteria+Search+Fields+Appearing+Before+Category+Name - already exists<bR>
geodesic_text_messages key 553 of Successful+Ad+Placement+Email+Subject - already exists<bR>
geodesic_text_messages key 554 of Salutation+Before+Name - already exists<bR>
geodesic_text_messages key 555 of Successful+Ad+Placement+Email+Body - already exists<bR>
geodesic_text_messages key 556 of Ad+Expiring+Email+Subject - already exists<bR>
geodesic_text_messages key 557 of Email+Salutation - already exists<bR>
geodesic_text_messages key 558 of Email+Body - already exists<bR>
geodesic_text_messages key 559 of Renewal+Form+Title - already exists<bR>
geodesic_text_messages key 560 of Renewal+Form+Instructions - already exists<bR>
geodesic_text_messages key 561 of Renew+Ad+Cost+Label - already exists<bR>
geodesic_text_messages key 562 of Explanation+of+Renewal+Charge - already exists<bR>
geodesic_text_messages key 563 of Yes+to+Renew - already exists<bR>
geodesic_text_messages key 564 of No+to+Renewal - already exists<bR>
geodesic_text_messages key 565 of Your+Ad+is+Renewable+But+Not+at+this+Time+Message - already exists<bR>
geodesic_text_messages key 566 of Your+Ad+Cannot+Be+Renewed+Message - already exists<bR>
geodesic_text_messages key 567 of Please+Choose+a+Method+of+Payment+Instruction - already exists<bR>
geodesic_text_messages key 568 of Choose+a+Method+of+Payment+Error+Message - already exists<bR>
geodesic_text_messages key 569 of Credit+Card+Label - already exists<bR>
geodesic_text_messages key 570 of Credit+Card+Explanation - already exists<bR>
geodesic_text_messages key 571 of Credit+Card+Number - already exists<bR>
geodesic_text_messages key 572 of Credit+Card+Expiration+Label - already exists<bR>
geodesic_text_messages key 573 of Paypal+Choice+Label - already exists<bR>
geodesic_text_messages key 574 of PayPal+Payment+Type+Choice+Transaction+Instruction - already exists<bR>
geodesic_text_messages key 575 of Submit+Button - already exists<bR>
geodesic_text_messages key 576 of Link+Back+to+the+My+Current+Ads - already exists<bR>
geodesic_text_messages key 577 of Credit+Card+Number+Error+Message - already exists<bR>
geodesic_text_messages key 578 of Credit+Card+Expiration+Error+ - already exists<bR>
geodesic_text_messages key 579 of You+Must+Choose+to+Renew+to+Continue+Message - already exists<bR>
geodesic_text_messages key 580 of Currency+Type+Dropdown+Box+Label - already exists<bR>
geodesic_text_messages key 581 of Price+Field+Label - already exists<bR>
geodesic_text_messages key 582 of Title - already exists<bR>
geodesic_text_messages key 584 of Currency+Type+Dropdown+Box+Label - already exists<bR>
geodesic_text_messages key 585 of Worldpay+Choice+Title - already exists<bR>
geodesic_text_messages key 586 of Worldpay+Explanation - already exists<bR>
geodesic_text_messages key 587 of No+Image+Data+Was+Received+Message - already exists<bR>
geodesic_text_messages key 588 of Image+Too+Large+Error+Message - already exists<bR>
geodesic_text_messages key 589 of Newest+Ad+Title - already exists<bR>
geodesic_text_messages key 590 of Renew+Ad+Link+Label - already exists<bR>
geodesic_text_messages key 591 of Worldpay+Payment+Type+Choice+Transaction+Instruction - already exists<bR>
geodesic_text_messages key 592 of Renewal+Approval+Page - already exists<bR>
geodesic_text_messages key 593 of Renewal+Approval+Page+Instructions - already exists<bR>
geodesic_text_messages key 594 of Charge+Column+Header - already exists<bR>
geodesic_text_messages key 595 of Costs+Column+Header - already exists<bR>
geodesic_text_messages key 596 of Ad+Renewal+Cost+Label - already exists<bR>
geodesic_text_messages key 597 of Approval+Button - already exists<bR>
geodesic_text_messages key 598 of Ad+Renewal+Success+Message - already exists<bR>
geodesic_text_messages key 599 of Ad+Renewal+Failure+Message - already exists<bR>
geodesic_text_messages key 600 of Ad+Renewal+Page+Title - already exists<bR>
geodesic_text_messages key 602 of Personal+Information+Header+ - already exists<bR>
geodesic_text_messages key 603 of Sellers+Name - already exists<bR>
geodesic_text_messages key 604 of Sellers+Address - already exists<bR>
geodesic_text_messages key 605 of Sellers+City+State+and+Zip - already exists<bR>
geodesic_text_messages key 606 of Sellers+Country - already exists<bR>
geodesic_text_messages key 607 of Sellers+Phone - already exists<bR>
geodesic_text_messages key 608 of Sellers+Secondary+Phone - already exists<bR>
geodesic_text_messages key 609 of Sellers+Fax - already exists<bR>
geodesic_text_messages key 610 of Sellers+Url - already exists<bR>
geodesic_text_messages key 611 of Expose+In+Other+Ad+Checkbox+Label - already exists<bR>
geodesic_text_messages key 612 of Sellers+Other+Ads+Link - already exists<bR>
geodesic_text_messages key 613 of Email+Address - already exists<bR>
geodesic_text_messages key 614 of Sellers+Other+Ads+Page+Label - already exists<bR>
geodesic_text_messages key 549 of All+Categories+Choice+in+Category+Dropdown - already exists<bR>
geodesic_text_messages key 615 of Subject+Line+of+Email+Notifying+of+Registration+Success - already exists<bR>
geodesic_text_messages key 616 of User+Choice+Removal+Message - already exists<bR>
geodesic_text_messages key 617 of Sellers Company Name - already exists<bR>
geodesic_text_messages key 618 of Yes+to+Extra+Feature - already exists<bR>
geodesic_text_messages key 619 of No+to+Extra+Feature - already exists<bR>
geodesic_text_messages key 620 of registration successful text footer - already exists<bR>
geodesic_text_messages key 621 of zip code distance dropdown - already exists<bR>
geodesic_text_messages key 622 of distance column - already exists<bR>
geodesic_text_messages key 623 of Paypal+Currency+Type+After+Totals - already exists<bR>
geodesic_text_messages key 624 of Paypal+Currency+Type+Pre+Totals - already exists<bR>
geodesic_text_messages key 625 of Email+Communication+Address - already exists<bR>
geodesic_text_messages key 626 of Email+Communication+Address+Error+Message - already exists<bR>
geodesic_text_messages key 627 of Email+Communication+Address - already exists<bR>
geodesic_text_messages key 628 of Email+Communication+Address+Error+Message - already exists<bR>
geodesic_text_messages key 629 of yes+to+subcategories+also - already exists<bR>
geodesic_text_messages key 630 of no+to+subcategories+also - already exists<bR>
geodesic_text_messages key 631 of advanced+search+link+%28top+right%29 - already exists<bR>
geodesic_text_messages key 632 of my+account+link+%28top+right%29 - already exists<bR>
geodesic_text_messages key 633 of top+right+links+seperator - already exists<bR>
geodesic_text_messages key 634 of greeting - already exists<bR>
geodesic_text_messages key 635 of guest+text - already exists<bR>
geodesic_text_messages key 636 of home+link+%28top+right%29 - already exists<bR>
geodesic_text_messages key 637 of quick+search+label - already exists<bR>
geodesic_text_messages key 638 of quick+search+button+text - already exists<bR>
geodesic_text_messages key 639 of confirmation+message - already exists<bR>
geodesic_text_messages key 640 of Hottest+Ad+Header - already exists<bR>
geodesic_text_messages key 641 of number+of+credits+label - already exists<bR>
geodesic_text_messages key 642 of Pedigree+Section+Instructions - already exists<bR>
geodesic_text_messages key 643 of Pedigree+Section+Title - already exists<bR>
geodesic_text_messages key 644 of Sire+Title - already exists<bR>
geodesic_text_messages key 645 of Dam+Title - already exists<bR>
geodesic_text_messages key 646 of Sire+Label - already exists<bR>
geodesic_text_messages key 647 of Sire+Sire+Label - already exists<bR>
geodesic_text_messages key 648 of Sire+Dam+Label - already exists<bR>
geodesic_text_messages key 649 of Sire+Sire+Sire+Label - already exists<bR>
geodesic_text_messages key 650 of Sire+Sire+Dam+Label - already exists<bR>
geodesic_text_messages key 651 of Sire+Dam+Sire+Label - already exists<bR>
geodesic_text_messages key 652 of Sire+Dam+Dam+Label - already exists<bR>
geodesic_text_messages key 653 of Dam+Label - already exists<bR>
geodesic_text_messages key 654 of Dam+Sire+Label - already exists<bR>
geodesic_text_messages key 655 of Dam+Dam+Label - already exists<bR>
geodesic_text_messages key 656 of Dam+Sire+Sire+Label - already exists<bR>
geodesic_text_messages key 657 of Dam+Sire+Dam+Label - already exists<bR>
geodesic_text_messages key 658 of Dam+Dam+Sire+Label - already exists<bR>
geodesic_text_messages key 659 of Dam+Dam+Dam+Label - already exists<bR>
geodesic_text_messages key 660 of Sire+Label - already exists<bR>
geodesic_text_messages key 661 of Dam+Label - already exists<bR>
geodesic_text_messages key 662 of Sire+Label - already exists<bR>
geodesic_text_messages key 663 of Sire+Sire+Label - already exists<bR>
geodesic_text_messages key 664 of Sire+Dam+Label - already exists<bR>
geodesic_text_messages key 665 of Sire+Sire+Sire+Label - already exists<bR>
geodesic_text_messages key 666 of Sire+Sire+Dam+Label - already exists<bR>
geodesic_text_messages key 667 of Sire+Dam+Sire+Label - already exists<bR>
geodesic_text_messages key 668 of Sire+Dam+Dam+Label - already exists<bR>
geodesic_text_messages key 669 of Dam+Label - already exists<bR>
geodesic_text_messages key 670 of Dam+Sire+Label - already exists<bR>
geodesic_text_messages key 671 of Dam+Dam+Label - already exists<bR>
geodesic_text_messages key 672 of Dam+Sire+Sire+Label - already exists<bR>
geodesic_text_messages key 673 of Dam+Sire+Dam+Label - already exists<bR>
geodesic_text_messages key 674 of Dam+Dam+Sire+Label - already exists<bR>
geodesic_text_messages key 675 of Dam+Dam+Dam+Label - already exists<bR>
<br><b>geodesic_text_messages table upgraded</b><br><Br>geodesic_text_languages_messages key 539 of language Your+email+verification+does+not+match.++Try+again. - already exists<bR>
geodesic_text_languages_messages key 540 of language email+verifier. - already exists<bR>
geodesic_text_languages_messages key 541 of language The+category+you+chose+is+not+a+lowest+category.++Please+choose+a+category+with+an+%2A. - already exists<bR>
geodesic_text_languages_messages key 542 of language choose+category - already exists<bR>
geodesic_text_languages_messages key 543 of language Please+choose+a+category+with+an+%2A+next+to+it. - already exists<bR>
geodesic_text_languages_messages key 544 of language save+communication+selection - already exists<bR>
geodesic_text_languages_messages key 545 of language price - already exists<bR>
geodesic_text_languages_messages key 578 of language Please+enter+a+valid+expiration+date - already exists<bR>
geodesic_text_languages_messages key 579 of language You+must+click+yes+to+renew+your+ad+to+continue. - already exists<bR>
geodesic_text_languages_messages key 580 of language Currency+Option - already exists<bR>
geodesic_text_languages_messages key 574 of language If+you+wish+to+use+Paypal+to+pay+for+the+renewal+of+your+ad+select+paypal. - already exists<bR>
geodesic_text_languages_messages key 575 of language Renew+My+Ad - already exists<bR>
geodesic_text_languages_messages key 576 of language Back+to+My+Current+Ads - already exists<bR>
geodesic_text_languages_messages key 577 of language Please+enter+a+valid+credit+card+number - already exists<bR>
geodesic_text_languages_messages key 570 of language If+paying+by+credit+card+use+this+method+of+payment. - already exists<bR>
geodesic_text_languages_messages key 571 of language credit+card+number - already exists<bR>
geodesic_text_languages_messages key 572 of language Expiration - already exists<bR>
geodesic_text_languages_messages key 573 of language Paypal - already exists<bR>
geodesic_text_languages_messages key 569 of language Credit+Card - already exists<bR>
geodesic_text_languages_messages key 567 of language Please+choose+a+method+of+payment+from+the+options+below. - already exists<bR>
geodesic_text_languages_messages key 568 of language Please+choose+a+method+of+payment+to+move+to+the+next+step - already exists<bR>
geodesic_text_languages_messages key 566 of language You+will+not+be+able+to+renew+your+ad.++ - already exists<bR>
geodesic_text_languages_messages key 565 of language You+have+the+ability+to+renew+your+ad+but+you+cannot+at+this+time.++Check+back+closer+to+the+end+of+the+ad. - already exists<bR>
geodesic_text_languages_messages key 563 of language yes - already exists<bR>
geodesic_text_languages_messages key 564 of language Do+Not+Renew - already exists<bR>
geodesic_text_languages_messages key 561 of language Cost+to+Renew+Your+Ad - already exists<bR>
geodesic_text_languages_messages key 562 of language Your+ad+will+be+renewed+for+the+length+of+time+you+used+for+your+original+ad. - already exists<bR>
geodesic_text_languages_messages key 560 of language You+can+renew+your+classified+through+this+form.++Click+yes+to+renew+your+ad+and+then+click+the+submit+button+at+the+bottom+of+this+page. - already exists<bR>
geodesic_text_languages_messages key 559 of language Renew+Your+Ad - already exists<bR>
geodesic_text_languages_messages key 558 of language Your+ad+is+about+to+expire.++Below+is+the+direct+link+to+the+ad+about+to+expire. - already exists<bR>
geodesic_text_languages_messages key 557 of language Hello+ - already exists<bR>
geodesic_text_languages_messages key 556 of language Your+ad+is+about+to+expire - already exists<bR>
geodesic_text_languages_messages key 555 of language Your+classified+ad+was+successfully+placed+on+our+site.++Below+is+a+link+directly+to+it. - already exists<bR>
geodesic_text_languages_messages key 553 of language Your+Ad+Was+Successfully+Placed - already exists<bR>
geodesic_text_languages_messages key 554 of language Congratulations+ - already exists<bR>
geodesic_text_languages_messages key 552 of language Optional+search+criteria+for+the+ - already exists<bR>
geodesic_text_languages_messages key 551 of language Main - already exists<bR>
geodesic_text_languages_messages key 549 of language All+Categories - already exists<bR>
geodesic_text_languages_messages key 550 of language All+Categories - already exists<bR>
geodesic_text_languages_messages key 548 of language save+filter - already exists<bR>
geodesic_text_languages_messages key 547 of language You+currently+have+no+messages+awaiting+you - already exists<bR>
geodesic_text_languages_messages key 546 of language days - already exists<bR>
geodesic_text_languages_messages key 588 of language The+image+you+tried+to+upload+was+too+large.++Please+try+another. - already exists<bR>
geodesic_text_languages_messages key 587 of language We+received+no+image+data.++Please+try+again. - already exists<bR>
geodesic_text_languages_messages key 586 of language If+you+wish+to+pay+using+Worldpay+click+the+bubble+to+the+right - already exists<bR>
geodesic_text_languages_messages key 585 of language Worldpay - already exists<bR>
geodesic_text_languages_messages key 584 of language currency+type - already exists<bR>
geodesic_text_languages_messages key 582 of language title: - already exists<bR>
geodesic_text_languages_messages key 581 of language price: - already exists<bR>
geodesic_text_languages_messages key 589 of language Newest+Ads+In - already exists<bR>
geodesic_text_languages_messages key 601 of language Below+is+the+failure%2Fsuccess+message+of+your+ad+renewal+request. - already exists<bR>
geodesic_text_languages_messages key 600 of language Ad+Renewal+Success%2FFailure - already exists<bR>
geodesic_text_languages_messages key 599 of language Your+ad+was+not+successfully+renewed - already exists<bR>
geodesic_text_languages_messages key 596 of language ad+renewal - already exists<bR>
geodesic_text_languages_messages key 597 of language Approve+Ad+Renewal - already exists<bR>
geodesic_text_languages_messages key 598 of language Your+ad+has+been+successfully+renewed. - already exists<bR>
geodesic_text_languages_messages key 595 of language cost - already exists<bR>
geodesic_text_languages_messages key 594 of language Charges - already exists<bR>
geodesic_text_languages_messages key 593 of language If+you+approve+of+the+renewal+charges+below+click+the+submit+button+below. - already exists<bR>
geodesic_text_languages_messages key 592 of language Renewal+Approval - already exists<bR>
geodesic_text_languages_messages key 591 of language Explanation+and+instruction+on+how+to+complete+your+transaction+through+Worldpay - already exists<bR>
geodesic_text_languages_messages key 590 of language renew - already exists<bR>
geodesic_text_languages_messages key 614 of language All+Ads+for+ - already exists<bR>
geodesic_text_languages_messages key 612 of language Show+sellers+other+ads - already exists<bR>
geodesic_text_languages_messages key 613 of language email%3A - already exists<bR>
geodesic_text_languages_messages key 611 of language expose+in+other+ads - already exists<bR>
geodesic_text_languages_messages key 608 of language secondary+phone%3A - already exists<bR>
geodesic_text_languages_messages key 609 of language fax%3A - already exists<bR>
geodesic_text_languages_messages key 610 of language url%3A - already exists<bR>
geodesic_text_languages_messages key 605 of language city%2C+state+and+zip%3A - already exists<bR>
geodesic_text_languages_messages key 606 of language country%3A - already exists<bR>
geodesic_text_languages_messages key 607 of language phone%3A - already exists<bR>
geodesic_text_languages_messages key 603 of language name%3A - already exists<bR>
geodesic_text_languages_messages key 604 of language address%3A - already exists<bR>
geodesic_text_languages_messages key 602 of language This+sellers+contact+information - already exists<bR>
geodesic_text_languages_messages key 616 of language User+Choice - already exists<bR>
geodesic_text_languages_messages key 615 of language Your+registration+is+almost+done... - already exists<bR>
geodesic_text_languages_messages key 617 of language company+name - already exists<bR>
geodesic_text_languages_messages key 618 of language yes - already exists<bR>
geodesic_text_languages_messages key 619 of language no - already exists<bR>
geodesic_text_languages_messages key 620 of language success+footer - already exists<bR>
geodesic_text_languages_messages key 621 of language choose+max+distance+in+miles - already exists<bR>
geodesic_text_languages_messages key 622 of language distance+in+miles - already exists<bR>
geodesic_text_languages_messages key 623 of language USD - already exists<bR>
geodesic_text_languages_messages key 624 of language %24 - already exists<bR>
geodesic_text_languages_messages key 625 of language Communication+Email+Address%3A - already exists<bR>
geodesic_text_languages_messages key 626 of language Please+reenter+the+email+where+you+wish+to+receive+communications+about+this+ad. - already exists<bR>
geodesic_text_languages_messages key 627 of language Email+Communication+Address - already exists<bR>
geodesic_text_languages_messages key 628 of language Please+enter+a+valid+email+address+for+users+to+communicate+with+for+this+ad - already exists<bR>
geodesic_text_languages_messages key 629 of language yes - already exists<bR>
geodesic_text_languages_messages key 630 of language no - already exists<bR>
geodesic_text_languages_messages key 631 of language advanced+search - already exists<bR>
geodesic_text_languages_messages key 632 of language my+account - already exists<bR>
geodesic_text_languages_messages key 633 of language %7C - already exists<bR>
geodesic_text_languages_messages key 634 of language Welcome%3A - already exists<bR>
geodesic_text_languages_messages key 635 of language Guest - already exists<bR>
geodesic_text_languages_messages key 636 of language home - already exists<bR>
geodesic_text_languages_messages key 637 of language Quick+Search%3A - already exists<bR>
geodesic_text_languages_messages key 638 of language go - already exists<bR>
geodesic_text_languages_messages key 639 of language Your+login+information+has+been+sent%21 - already exists<bR>
geodesic_text_languages_messages key 640 of language Hottest+Ads - already exists<bR>
geodesic_text_languages_messages key 641 of language Number+of+credits%3A - already exists<bR>
geodesic_text_languages_messages key 642 of language Pedigree+Information - already exists<bR>
geodesic_text_languages_messages key 643 of language Enter+the+pedigree+specific+information+below. - already exists<bR>
geodesic_text_languages_messages key 644 of language Sire+Information - already exists<bR>
geodesic_text_languages_messages key 645 of language Dam+Information - already exists<bR>
geodesic_text_languages_messages key 646 of language Sire - already exists<bR>
geodesic_text_languages_messages key 647 of language Sire+Sire - already exists<bR>
geodesic_text_languages_messages key 648 of language Sire+Dam - already exists<bR>
geodesic_text_languages_messages key 649 of language Sire+Sire+Sire - already exists<bR>
geodesic_text_languages_messages key 650 of language Sire+Sire+Dam - already exists<bR>
geodesic_text_languages_messages key 651 of language Sire+Dam+Sire - already exists<bR>
geodesic_text_languages_messages key 652 of language Sire+Dam+Dam - already exists<bR>
geodesic_text_languages_messages key 653 of language Dam - already exists<bR>
geodesic_text_languages_messages key 654 of language Dam+Sire - already exists<bR>
geodesic_text_languages_messages key 655 of language Dam+Dam - already exists<bR>
geodesic_text_languages_messages key 656 of language Dam+Sire+Sire - already exists<bR>
geodesic_text_languages_messages key 657 of language Dam+Sire+Dam - already exists<bR>
geodesic_text_languages_messages key 658 of language Dam+Dam+Sire - already exists<bR>
geodesic_text_languages_messages key 659 of language Dam+Dam+Dam - already exists<bR>
geodesic_text_languages_messages key 660 of language Sire - already exists<bR>
geodesic_text_languages_messages key 661 of language Dam - already exists<bR>
geodesic_text_languages_messages key 662 of language Sire - already exists<bR>
geodesic_text_languages_messages key 663 of language Sire+Sire - already exists<bR>
geodesic_text_languages_messages key 664 of language Sire+Dam - already exists<bR>
geodesic_text_languages_messages key 665 of language Sire+Sire+Sire - already exists<bR>
geodesic_text_languages_messages key 666 of language Sire+Sire+Dam - already exists<bR>
geodesic_text_languages_messages key 667 of language Sire+Dam+Sire - already exists<bR>
geodesic_text_languages_messages key 668 of language Sire+Dam+Dam - already exists<bR>
geodesic_text_languages_messages key 669 of language Dam - already exists<bR>
geodesic_text_languages_messages key 670 of language Dam+Sire - already exists<bR>
geodesic_text_languages_messages key 671 of language Dam+Dam - already exists<bR>
geodesic_text_languages_messages key 672 of language Dam+Sire+Sire - already exists<bR>
geodesic_text_languages_messages key 673 of language Dam+Sire+Dam - already exists<bR>
geodesic_text_languages_messages key 674 of language Dam+Dam+Sire - already exists<bR>
geodesic_text_languages_messages key 675 of language Dam+Dam+Dam - already exists<bR>
<br><b>geodesic_text_languages_messages table upgraded</b><br><Br>geodesic_text_subpages key 49 or Successful+Ad+Placement+Email - already exists<bR>
geodesic_text_subpages key 50 or Ad+Expiration+Email - already exists<bR>
geodesic_text_subpages key 51 or Renewal+Form - already exists<bR>
geodesic_text_subpages key 52 or Renewal+Approval+Form - already exists<bR>
geodesic_text_subpages key 53 or Renewal+Success+Page - already exists<bR>
geodesic_text_subpages key 14 or Ad+Renewal - already exists<bR>
geodesic_text_subpages key 54 or Seller+Other+Ads+Page - already exists<bR>
geodesic_text_subpages key 42 or Place+an+ad+Success+Page - already exists<bR>
geodesic_text_subpages key 48 or Send+Seller+a+Question - already exists<bR>
geodesic_text_subpages key 47 or Success+Pages - already exists<bR>
geodesic_text_subpages key 46 or Final+Approval+Page - already exists<bR>
geodesic_text_subpages key 43 or Browse+Categories+Home - already exists<bR>
geodesic_text_subpages key 44 or Registration+Code+Form - already exists<bR>
geodesic_text_subpages key 45 or transaction+detail - already exists<bR>
<br><b>geodesic_text_subpages table upgraded</b><br><Br>geodesic_text_subpages key 14 or Ad+Renewal - already exists<bR>
geodesic_text_subpages key 15 or Show+Sellers+Other+Ads+Page - already exists<bR>
<br><b>geodesic_font_subpages table upgraded</b><br><Br>ALTER TABLE `geodesic_paypal_transactions` ADD UNIQUE(`transaction_id`)<br>
ALTER TABLE `geodesic_paypal_transactions` CHANGE `transaction_id` `transaction_id` INT(11) DEFAULT '0' NOT NULL AUTO_INCREMENT<br>
<br><b>geodesic_paypal_transactions table upgraded</b><br><Br>geodesic_classifieds_price_increments table already exists...upgraded<br><Br>
<br><b>Bitel Transaction Ability Installed<br><br><b>Linkpoint Transaction Ability Installed<br><br><b>Database has been updated to 2.0.1</b><br><br><b>UPGRADE COMPLETE<br>Now upload all of the files contained within the distribution to your site.  Make sure to overwrite the current files
	with the same name.<br>