xml/schema/Core/LocationType.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>LocationType</class>
   6   <name>civicrm_location_type</name>
   7   <add>1.1</add>
   8   <log>true</log>
   9   <field>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <comment>Location Type ID</comment>
  14        <add>1.1</add>
  15   </field>
  16   <primaryKey>
  17        <name>id</name>
  18        <autoincrement>true</autoincrement>
  19   </primaryKey>
  20   <field>
  21        <name>name</name>
  22        <title>Location Type</title>
  23        <type>varchar</type>
  24        <length>64</length>
  25        <comment>Location Type Name.</comment>
  26        <add>1.1</add>
  27   </field>
  28   <field>
  29        <name>display_name</name>
  30        <title>Display Name</title>
  31        <type>varchar</type>
  32        <length>64</length>
  33        <comment>Location Type Display Name.</comment>
  34        <localizable>true</localizable>
  35        <add>4.1</add>
  36   </field>
  37   <field>
  38        <name>vcard_name</name>
  39        <title>vCard Location Type</title>
  40        <type>varchar</type>
  41        <length>64</length>
  42        <comment>vCard Location Type Name.</comment>
  43        <add>1.1</add>
  44   </field>
  45   <field>
  46        <name>description</name>
  47        <type>varchar</type>
  48        <length>255</length>
  49        <comment>Location Type Description.</comment>
  50        <add>1.1</add>
  51   </field>
  52   <field>
  53        <name>is_reserved</name>
  54        <type>boolean</type>
  55        <comment>Is this location type a predefined system location?</comment>
  56        <add>1.1</add>
  57   </field>
  58   <field>
  59        <name>is_active</name>
  60        <type>boolean</type>
  61        <comment>Is this property active?</comment>
  62        <add>1.1</add>
  63   </field>
  64   <field>
  65         <name>is_default</name>
  66         <type>boolean</type>
  67         <comment>Is this location type the default?</comment>
  68        <add>1.1</add>
  69   </field>
  70   <index>
  71     <name>UI_name</name>
  72     <fieldName>name</fieldName>
  73     <unique>true</unique>
  74     <add>2.1</add>
  75   </index>
  76 </table>