Merge pull request #19284 from eileenmcnaughton/mem_r
[civicrm-core.git] / xml / schema / Financial / Currency.xml
CommitLineData
6a488035
TO
1<?xml version="1.0" encoding="iso-8859-1" ?>
2
3<table>
4 <base>CRM/Financial</base>
5 <class>Currency</class>
6 <name>civicrm_currency</name>
7 <add>1.7</add>
8 <log>true</log>
d31fb4e3 9 <component>CiviContribute</component>
6a488035 10 <field>
8f069c03 11 <name>id</name>
f3ea5182 12 <title>Currency ID</title>
8f069c03
EM
13 <type>int unsigned</type>
14 <required>true</required>
15 <comment>Currency Id</comment>
16 <add>1.7</add>
6a488035
TO
17 </field>
18 <primaryKey>
8f069c03
EM
19 <name>id</name>
20 <autoincrement>true</autoincrement>
6a488035
TO
21 </primaryKey>
22 <field>
8f069c03
EM
23 <name>name</name>
24 <title>Currency</title>
25 <type>varchar</type>
26 <length>64</length>
27 <import>true</import>
28 <comment>Currency Name</comment>
29 <add>1.7</add>
30 <html>
31 <type>Text</type>
32 </html>
6a488035
TO
33 </field>
34 <field>
8f069c03 35 <name>symbol</name>
f3ea5182 36 <title>Currency Symbol</title>
8f069c03
EM
37 <type>varchar</type>
38 <length>8</length>
39 <comment>Currency Symbol</comment>
40 <add>1.7</add>
41 <html>
42 <type>Text</type>
43 </html>
6a488035
TO
44 </field>
45 <field>
8f069c03 46 <name>numeric_code</name>
f3ea5182 47 <title>Currency Numeric Code</title>
8f069c03
EM
48 <type>varchar</type>
49 <length>3</length>
50 <import>true</import>
51 <comment>Numeric currency code</comment>
52 <add>1.9</add>
6a488035
TO
53 </field>
54 <field>
8f069c03 55 <name>full_name</name>
f3ea5182 56 <title>Full Currency Name</title>
8f069c03
EM
57 <type>varchar</type>
58 <length>64</length>
59 <comment>Full currency name</comment>
60 <html>
61 <type>Text</type>
62 </html>
63 <add>1.9</add>
6a488035
TO
64 </field>
65</table>