xml/schema/Financial/Currency.xml

   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>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <comment>Currency Id</comment>
  14       <add>1.7</add>
  15   </field>
  16   <primaryKey>
  17        <name>id</name>
  18        <autoincrement>true</autoincrement>
  19   </primaryKey>
  20   <field>
  21        <name>name</name>
  22        <title>Currency</title>
  23        <type>varchar</type>
  24        <length>64</length>
  25        <import>true</import>
  26        <comment>Currency Name</comment>
  27        <add>1.7</add>
  28   </field>
  29   <field>
  30        <name>symbol</name>
  31        <type>varchar</type>
  32        <length>8</length>
  33        <comment>Currency Symbol</comment>
  34        <add>1.7</add>
  35   </field>
  36   <field>
  37        <name>numeric_code</name>
  38        <type>varchar</type>
  39        <length>3</length>
  40        <import>true</import>
  41        <comment>Numeric currency code</comment>
  42        <add>1.9</add>
  43   </field>
  44   <field>
  45        <name>full_name</name>
  46        <type>varchar</type>
  47        <length>64</length>
  48        <comment>Full currency name</comment>
  49        <add>1.9</add>
  50   </field>
  51 </table>