Merge pull request #16266 from jitendrapurohit/core-1517
[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>
9 <field>
8f069c03 10 <name>id</name>
f3ea5182 11 <title>Currency ID</title>
8f069c03
EM
12 <type>int unsigned</type>
13 <required>true</required>
14 <comment>Currency Id</comment>
15 <add>1.7</add>
6a488035
TO
16 </field>
17 <primaryKey>
8f069c03
EM
18 <name>id</name>
19 <autoincrement>true</autoincrement>
6a488035
TO
20 </primaryKey>
21 <field>
8f069c03
EM
22 <name>name</name>
23 <title>Currency</title>
24 <type>varchar</type>
25 <length>64</length>
26 <import>true</import>
27 <comment>Currency Name</comment>
28 <add>1.7</add>
29 <html>
30 <type>Text</type>
31 </html>
6a488035
TO
32 </field>
33 <field>
8f069c03 34 <name>symbol</name>
f3ea5182 35 <title>Currency Symbol</title>
8f069c03
EM
36 <type>varchar</type>
37 <length>8</length>
38 <comment>Currency Symbol</comment>
39 <add>1.7</add>
40 <html>
41 <type>Text</type>
42 </html>
6a488035
TO
43 </field>
44 <field>
8f069c03 45 <name>numeric_code</name>
f3ea5182 46 <title>Currency Numeric Code</title>
8f069c03
EM
47 <type>varchar</type>
48 <length>3</length>
49 <import>true</import>
50 <comment>Numeric currency code</comment>
51 <add>1.9</add>
6a488035
TO
52 </field>
53 <field>
8f069c03 54 <name>full_name</name>
f3ea5182 55 <title>Full Currency Name</title>
8f069c03
EM
56 <type>varchar</type>
57 <length>64</length>
58 <comment>Full currency name</comment>
59 <html>
60 <type>Text</type>
61 </html>
62 <add>1.9</add>
6a488035
TO
63 </field>
64</table>