xml/schema/Core/Country.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>Country</class>
   6   <name>civicrm_country</name>
   7   <add>1.1</add>
   8   <field>
   9       <name>id</name>
  10       <type>int unsigned</type>
  11       <required>true</required>
  12       <comment>Country Id</comment>
  13        <add>1.1</add>
  14   </field>
  15   <primaryKey>
  16        <name>id</name>
  17        <autoincrement>true</autoincrement>
  18   </primaryKey>
  19   <field>
  20        <name>name</name>
  21        <title>Country</title>
  22        <type>varchar</type>
  23        <length>64</length>
  24        <import>true</import>
  25        <headerPattern>/country/i</headerPattern>
  26        <dataPattern>/^[A-Z][a-z]+\.?(\s+[A-Z][a-z]+){0,3}$/</dataPattern>
  27        <comment>Country Name</comment>
  28        <add>1.1</add>
  29   </field>
  30   <field>
  31        <name>iso_code</name>
  32        <type>char</type>
  33        <length>2</length>
  34        <comment>ISO Code</comment>
  35        <add>1.1</add>
  36   </field>
  37   <field>
  38        <name>country_code</name>
  39        <type>varchar</type>
  40        <length>4</length>
  41        <comment>National prefix to be used when dialing TO this country.</comment>
  42        <add>1.1</add>
  43   </field>
  44   <field>
  45       <name>address_format_id</name>
  46       <type>int unsigned</type>
  47       <comment>Foreign key to civicrm_address_format.id.</comment>
  48        <add>3.2</add>
  49   </field>
  50   <foreignKey>
  51       <name>address_format_id</name>
  52       <table>civicrm_address_format</table>
  53       <key>id</key>
  54       <add>3.2</add>
  55   </foreignKey>
  56   <field>
  57        <name>idd_prefix</name>
  58        <type>varchar</type>
  59        <length>4</length>
  60        <comment>International direct dialing prefix from within the country TO another country</comment>
  61        <add>1.1</add>
  62   </field>
  63   <field>
  64        <name>ndd_prefix</name>
  65        <type>varchar</type>
  66        <length>4</length>
  67        <comment>Access prefix to call within a country to a different area</comment>
  68        <add>1.1</add>
  69   </field>
  70   <field>
  71       <name>region_id</name>
  72       <type>int unsigned</type>
  73       <required>true</required>
  74       <comment>Foreign key to civicrm_worldregion.id.</comment>
  75        <add>1.8</add>
  76   </field>
  77   <foreignKey>
  78       <name>region_id</name>
  79       <table>civicrm_worldregion</table>
  80       <key>id</key>
  81       <add>1.8</add>
  82   </foreignKey>
  83   <field>
  84        <name>is_province_abbreviated</name>
  85        <type>boolean</type>
  86        <default>0</default>
  87        <comment>Should state/province be displayed as abbreviation for contacts from this country?</comment>
  88        <add>3.1</add>
  89   </field>
  90   <index>
  91     <name>UI_name_iso_code</name>
  92     <fieldName>name</fieldName>
  93     <fieldName>iso_code</fieldName>
  94     <unique>true</unique>
  95     <add>1.1</add>
  96   </index>
  97 </table>