| 1 | <?xml version="1.0" encoding="UTF-8" ?> |
| 2 | <!-- $Id: contact_17.xml 30511 2010-11-03 11:36:36Z shot $ --> |
| 3 | <dataset> |
| 4 | <table name="civicrm_contact"> |
| 5 | <column>id</column> |
| 6 | <column>contact_type</column> |
| 7 | <column>contact_sub_type</column> |
| 8 | <column>do_not_email</column> |
| 9 | <column>do_not_phone</column> |
| 10 | <column>do_not_mail</column> |
| 11 | <column>do_not_sms</column> |
| 12 | <column>do_not_trade</column> |
| 13 | <column>is_opt_out</column> |
| 14 | <column>legal_identifier</column> |
| 15 | <column>external_identifier</column> |
| 16 | <column>sort_name</column> |
| 17 | <column>display_name</column> |
| 18 | <column>nick_name</column> |
| 19 | <column>legal_name</column> |
| 20 | <column>image_URL</column> |
| 21 | <column>preferred_communication_method</column> |
| 22 | <column>preferred_mail_format</column> |
| 23 | <column>hash</column> |
| 24 | <column>api_key</column> |
| 25 | <column>source</column> |
| 26 | <column>first_name</column> |
| 27 | <column>middle_name</column> |
| 28 | <column>last_name</column> |
| 29 | <column>prefix_id</column> |
| 30 | <column>suffix_id</column> |
| 31 | <column>email_greeting_id</column> |
| 32 | <column>email_greeting_custom</column> |
| 33 | <column>postal_greeting_id</column> |
| 34 | <column>postal_greeting_custom</column> |
| 35 | <column>addressee_id</column> |
| 36 | <column>addressee_custom</column> |
| 37 | <column>job_title</column> |
| 38 | <column>gender_id</column> |
| 39 | <column>birth_date</column> |
| 40 | <column>is_deceased</column> |
| 41 | <column>deceased_date</column> |
| 42 | <column>household_name</column> |
| 43 | <column>primary_contact_id</column> |
| 44 | <column>organization_name</column> |
| 45 | <column>sic_code</column> |
| 46 | <column>user_unique_id</column> |
| 47 | <column>employer_id</column> |
| 48 | <row> |
| 49 | <value>17</value> <!-- id --> |
| 50 | <value>Individual</value> <!-- contact_type --> |
| 51 | <null /> <!-- contact_sub_type --> |
| 52 | <null /> <!-- do_not_email --> |
| 53 | <null /> <!-- do_not_phone --> |
| 54 | <null /> <!-- do_not_mail --> |
| 55 | <null /> <!-- do_not_sms --> |
| 56 | <null /> <!-- do_not_trade --> |
| 57 | <value>0</value> <!-- is_opt_out --> |
| 58 | <null /> <!-- legal_identifier --> |
| 59 | <null /> <!-- external_identifier --> |
| 60 | <null /> <!-- sort_name --> |
| 61 | <value>Test Contact</value> <!-- display_name --> |
| 62 | <null /><!-- nick_name --> |
| 63 | <null /><!-- legal_name --> |
| 64 | <null /><!-- image_URL --> |
| 65 | <null /><!-- preferred_communication_method --> |
| 66 | <null /><!-- preferred_mail_format --> |
| 67 | <null /><!-- hash --> |
| 68 | <null /><!-- api_key --> |
| 69 | <null /><!-- source --> |
| 70 | <value>Test</value><!-- first_name --> |
| 71 | <null /><!-- middle_name --> |
| 72 | <value>Contact</value> <!-- last_name --> |
| 73 | <null /><!-- prefix_id --> |
| 74 | <null /><!-- suffix_id --> |
| 75 | <null /><!-- email_greeting_id --> |
| 76 | <null /><!-- email_greeting_custom --> |
| 77 | <null /><!-- postal_greeting_id --> |
| 78 | <null /><!-- postal_greeting_custom --> |
| 79 | <null /><!-- addressee_id --> |
| 80 | <null /><!-- addressee_custom --> |
| 81 | <null /><!-- job_title --> |
| 82 | <null /><!-- gender_id --> |
| 83 | <null /><!-- birth_date --> |
| 84 | <value>0</value> <!-- is_deceased --> |
| 85 | <null /><!-- deceased_date --> |
| 86 | <null /><!-- household_name --> |
| 87 | <null /><!-- primary_contact_id --> |
| 88 | <null /><!-- organization_name --> |
| 89 | <null /><!-- sic_code --> |
| 90 | <null /><!-- user_unique_id --> |
| 91 | <null /><!-- employer_id --> |
| 92 | </row> |
| 93 | </table> |
| 94 | </dataset> |