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