CiviCRM Community Forums (archive)

pst:

might be easier and faster to see if the old code base is still lying around and check the civicrm-version.txt file there. If thats not a possibility, your next option will be to try to get sql files for the older versions and do a manual compare  of the structure and the schema. You can also check to see if there are contribute / member / event tables since they were introduced over a period of time in different versions in that order

lobo

Looks like I have contribution and member tables ...but not Event.  Does that pinpoint a version better ?

I include the tables in my `old` database below.

I was also thinking that i could just attempt inserts into the tables, but the problem is that my SQL dump looks something like this:

INSERT INTO `civicrm_activity_type` VALUES (1,1,'Meeting','Schedule a Meeting',1,1)

Not the omission of the field list.  That means that if the order of the fields have changed at all from my old schema to the new ... it would try to insert fields in all kinds of funky locations. 

And, as it happens, I found at least one big table where the fields are in different orders   -  Bummer !   

Other than manually inserting the order of fields and checking doing table one by one ...i was hoping there would be some helpful scripts.

Any thoughts ?

Thanks.


Tables:

civicrm_accept_credit_card
civicrm_acl
civicrm_acl_group
civicrm_acl_group_join
civicrm_activity
civicrm_activity_history
civicrm_activity_type
civicrm_address
civicrm_contact
civicrm_contribution
civicrm_contribution_page
civicrm_contribution_product
civicrm_contribution_recur
civicrm_contribution_type
civicrm_country
civicrm_county
civicrm_custom_field
civicrm_custom_group
civicrm_custom_option
civicrm_custom_value
civicrm_domain
civicrm_dupe_match
civicrm_email
civicrm_email_history
civicrm_entity_file
civicrm_entity_tag
civicrm_file
civicrm_financial_trxn
civicrm_gender
civicrm_geo_coord
civicrm_group
civicrm_group_contact
civicrm_household
civicrm_im
civicrm_im_provider
civicrm_individual
civicrm_individual_prefix
civicrm_individual_suffix
civicrm_location
civicrm_location_type
civicrm_log
civicrm_mailing
civicrm_mailing_bounce_pattern
civicrm_mailing_bounce_type
civicrm_mailing_component
civicrm_mailing_event_bounce
civicrm_mailing_event_confirm
civicrm_mailing_event_delivered
civicrm_mailing_event_forward
civicrm_mailing_event_opened
civicrm_mailing_event_queue
civicrm_mailing_event_reply
civicrm_mailing_event_subscribe
civicrm_mailing_event_trackable_url_open
civicrm_mailing_event_unsubscribe
civicrm_mailing_group
civicrm_mailing_job
civicrm_mailing_trackable_url
civicrm_mapping
civicrm_mapping_field
civicrm_meeting
civicrm_membership
civicrm_membership_block
civicrm_membership_log
civicrm_membership_payment
civicrm_membership_status
civicrm_membership_type
civicrm_mobile_provider
civicrm_note
civicrm_option_group
civicrm_option_value
civicrm_organization
civicrm_payment_instrument
civicrm_phone
civicrm_phonecall
civicrm_premiums
civicrm_premiums_product
civicrm_product
civicrm_project
civicrm_relationship
civicrm_relationship_type
civicrm_saved_search
civicrm_sms_history
civicrm_state_province
civicrm_subscription_history
civicrm_tag
civicrm_task
civicrm_task_status
civicrm_uf_field
civicrm_uf_group
civicrm_uf_join
civicrm_uf_match
civicrm_validation

Thanks, I'll investigate.