[civicrm-core.git] / xml / schema / Core / Preferences.xml

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/Core</base>
  <class>Preferences</class>
  <name>civicrm_preferences</name>
  <comment>Define preferences for the site and users</comment>
  <add>1.8</add>
  <drop>4.1</drop>
  <log>true</log>
  <field>
    <name>id</name>
    <type>int unsigned</type>
    <required>true</required>
    <html>
      <type>Number</type>
    </html>
    <add>1.8</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>domain_id</name>
    <title>Domain ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Which Domain is this menu item for</comment>
    <html>
      <label>Domain</label>
    </html>
    <add>3.0</add>
  </field>
  <foreignKey>
    <name>domain_id</name>
    <table>civicrm_domain</table>
    <key>id</key>
    <onDelete>CASCADE</onDelete>
    <add>3.0</add>
  </foreignKey>
  <field>
    <name>contact_id</name>
    <title>Contact ID</title>
    <type>int unsigned</type>
    <comment>FK to Contact ID</comment>
    <html>
      <label>Contact</label>
    </html>
    <add>1.8</add>
  </field>
  <foreignKey>
    <name>contact_id</name>
    <table>civicrm_contact</table>
    <key>id</key>
    <onDelete>CASCADE</onDelete>
    <add>1.8</add>
  </foreignKey>
  <field>
    <name>is_domain</name>
    <type>boolean</type>
    <comment>Is this the record for the domain setting?</comment>
    <add>1.8</add>
  </field>
  <field>
    <name>location_count</name>
    <type>int unsigned</type>
    <comment>Number of locations to be displayed on edit page?</comment>
    <add>1.8</add>
    <drop>3.0</drop>
  </field>
  <field>
    <name>contact_view_options</name>
    <type>varchar</type>
    <length>128</length>
    <comment>What tabs are displayed in the contact summary</comment>
    <add>1.8</add>
  </field>
  <index>
    <name>index_contact_view_options</name>
    <fieldName>contact_view_options</fieldName>
    <add>1.8</add>
  </index>
  <field>
    <name>contact_edit_options</name>
    <type>varchar</type>
    <length>128</length>
    <comment>What tabs are displayed in the contact edit</comment>
    <add>1.8</add>
  </field>
  <index>
    <name>index_contact_edit_options</name>
    <fieldName>contact_edit_options</fieldName>
    <add>1.8</add>
  </index>
  <field>
    <name>advanced_search_options</name>
    <type>varchar</type>
    <length>128</length>
    <comment>What tabs are displayed in the advanced search screen</comment>
    <add>1.8</add>
  </field>
  <index>
    <name>index_advanced_search_options</name>
    <fieldName>advanced_search_options</fieldName>
    <add>1.8</add>
  </index>
  <field>
    <name>user_dashboard_options</name>
    <type>varchar</type>
    <length>128</length>
    <comment>What tabs are displayed in the contact edit</comment>
    <add>1.8</add>
  </field>
  <index>
    <name>index_user_dashboard_options</name>
    <fieldName>user_dashboard_options</fieldName>
    <add>1.8</add>
  </index>
  <field>
    <name>address_options</name>
    <type>varchar</type>
    <length>128</length>
    <comment>What fields are displayed from the address table</comment>
    <add>1.8</add>
  </field>
  <index>
    <name>index_address_options</name>
    <fieldName>address_options</fieldName>
    <add>1.8</add>
  </index>
  <field>
    <name>address_format</name>
    <type>text</type>
    <comment>Format to display the address</comment>
    <add>1.8</add>
  </field>
  <field>
    <name>mailing_format</name>
    <type>text</type>
    <comment>Format to display a mailing label</comment>
    <add>1.8</add>
  </field>
  <field>
    <name>display_name_format</name>
    <type>text</type>
    <comment>Format to display contact display name</comment>
    <add>3.2</add>
  </field>
  <field>
    <name>sort_name_format</name>
    <type>text</type>
    <comment>Format to display contact sort name</comment>
    <add>3.2</add>
  </field>
  <field>
    <name>individual_name_format</name>
    <type>text</type>
    <comment>Format to display a individual name</comment>
    <add>1.8</add>
    <drop>3.0</drop>
  </field>
  <field>
    <name>address_standardization_provider</name>
    <type>varchar</type>
    <length>64</length>
    <comment>object name of provider for address standarization</comment>
    <add>1.8</add>
  </field>
  <field>
    <name>address_standardization_userid</name>
    <type>varchar</type>
    <length>64</length>
    <comment>user id for provider login</comment>
    <add>1.8</add>
  </field>
  <field>
    <name>address_standardization_url</name>
    <type>varchar</type>
    <length>255</length>
    <comment>url of address standardization service</comment>
    <add>1.8</add>
  </field>
  <field>
    <name>editor_id</name>
    <type>int unsigned</type>
    <length>4</length>
    <comment>ID of the editor</comment>
    <add>2.1</add>
  </field>
  <field>
    <name>mailing_backend</name>
    <type>text</type>
    <comment>Smtp Backend configuration.</comment>
    <html>
      <type>TextArea</type>
      <rows>20</rows>
      <cols>80</cols>
    </html>
    <add>2.2</add>
  </field>
  <field>
    <name>navigation</name>
    <type>text</type>
    <comment>Store navigation for the Contact</comment>
    <add>3.0</add>
  </field>
  <field>
    <name>contact_autocomplete_options</name>
    <type>varchar</type>
    <length>255</length>
    <comment>What Autocomplete has to return</comment>
    <add>3.1</add>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2
	3	<table>
	4	<base>CRM/Core</base>
	5	<class>Preferences</class>
	6	<name>civicrm_preferences</name>
	7	<comment>Define preferences for the site and users</comment>
	8	<add>1.8</add>
	9	<drop>4.1</drop>
	10	<log>true</log>
	11	<field>
8f069c03 EM	12	<name>id</name>
	13	<type>int unsigned</type>
	14	<required>true</required>
0481e12c A	15	<html>
	16	<type>Number</type>
	17	</html>
8f069c03	18	<add>1.8</add>
6a488035 TO	19	</field>
6a488035 TO	20	<primaryKey>
8f069c03 EM	21	<name>id</name>
8f069c03 EM	22	<autoincrement>true</autoincrement>
6a488035 TO	23	</primaryKey>
6a488035 TO	24	<field>
8f069c03	25	<name>domain_id</name>
57e94608	26	<title>Domain ID</title>
8f069c03 EM	27	<type>int unsigned</type>
	28	<required>true</required>
	29	<comment>Which Domain is this menu item for</comment>
57e94608 A	30	<html>
	31	<label>Domain</label>
	32	</html>
8f069c03	33	<add>3.0</add>
6a488035 TO	34	</field>
6a488035 TO	35	<foreignKey>
8f069c03 EM	36	<name>domain_id</name>
	37	<table>civicrm_domain</table>
	38	<key>id</key>
	39	<onDelete>CASCADE</onDelete>
	40	<add>3.0</add>
6a488035 TO	41	</foreignKey>
6a488035 TO	42	<field>
8f069c03	43	<name>contact_id</name>
57e94608	44	<title>Contact ID</title>
8f069c03 EM	45	<type>int unsigned</type>
8f069c03 EM	46	<comment>FK to Contact ID</comment>
57e94608 A	47	<html>
	48	<label>Contact</label>
	49	</html>
8f069c03	50	<add>1.8</add>
6a488035 TO	51	</field>
6a488035 TO	52	<foreignKey>
8f069c03 EM	53	<name>contact_id</name>
	54	<table>civicrm_contact</table>
	55	<key>id</key>
	56	<onDelete>CASCADE</onDelete>
	57	<add>1.8</add>
6a488035 TO	58	</foreignKey>
6a488035 TO	59	<field>
8f069c03 EM	60	<name>is_domain</name>
	61	<type>boolean</type>
	62	<comment>Is this the record for the domain setting?</comment>
	63	<add>1.8</add>
6a488035 TO	64	</field>
6a488035 TO	65	<field>
8f069c03 EM	66	<name>location_count</name>
	67	<type>int unsigned</type>
	68	<comment>Number of locations to be displayed on edit page?</comment>
	69	<add>1.8</add>
	70	<drop>3.0</drop>
6a488035 TO	71	</field>
6a488035 TO	72	<field>
8f069c03 EM	73	<name>contact_view_options</name>
	74	<type>varchar</type>
	75	<length>128</length>
	76	<comment>What tabs are displayed in the contact summary</comment>
	77	<add>1.8</add>
6a488035 TO	78	</field>
	79	<index>
	80	<name>index_contact_view_options</name>
	81	<fieldName>contact_view_options</fieldName>
	82	<add>1.8</add>
	83	</index>
	84	<field>
8f069c03 EM	85	<name>contact_edit_options</name>
	86	<type>varchar</type>
	87	<length>128</length>
	88	<comment>What tabs are displayed in the contact edit</comment>
	89	<add>1.8</add>
6a488035 TO	90	</field>
	91	<index>
	92	<name>index_contact_edit_options</name>
	93	<fieldName>contact_edit_options</fieldName>
	94	<add>1.8</add>
	95	</index>
	96	<field>
8f069c03 EM	97	<name>advanced_search_options</name>
	98	<type>varchar</type>
	99	<length>128</length>
	100	<comment>What tabs are displayed in the advanced search screen</comment>
	101	<add>1.8</add>
6a488035 TO	102	</field>
	103	<index>
	104	<name>index_advanced_search_options</name>
	105	<fieldName>advanced_search_options</fieldName>
	106	<add>1.8</add>
	107	</index>
	108	<field>
8f069c03 EM	109	<name>user_dashboard_options</name>
	110	<type>varchar</type>
	111	<length>128</length>
	112	<comment>What tabs are displayed in the contact edit</comment>
	113	<add>1.8</add>
6a488035 TO	114	</field>
	115	<index>
	116	<name>index_user_dashboard_options</name>
	117	<fieldName>user_dashboard_options</fieldName>
	118	<add>1.8</add>
	119	</index>
	120	<field>
8f069c03 EM	121	<name>address_options</name>
	122	<type>varchar</type>
	123	<length>128</length>
	124	<comment>What fields are displayed from the address table</comment>
	125	<add>1.8</add>
6a488035	126	</field>
8f069c03	127	<index>
6a488035 TO	128	<name>index_address_options</name>
	129	<fieldName>address_options</fieldName>
	130	<add>1.8</add>
	131	</index>
	132	<field>
8f069c03 EM	133	<name>address_format</name>
	134	<type>text</type>
	135	<comment>Format to display the address</comment>
	136	<add>1.8</add>
6a488035 TO	137	</field>
6a488035 TO	138	<field>
8f069c03 EM	139	<name>mailing_format</name>
	140	<type>text</type>
	141	<comment>Format to display a mailing label</comment>
	142	<add>1.8</add>
6a488035 TO	143	</field>
6a488035 TO	144	<field>
8f069c03 EM	145	<name>display_name_format</name>
	146	<type>text</type>
	147	<comment>Format to display contact display name</comment>
	148	<add>3.2</add>
6a488035 TO	149	</field>
6a488035 TO	150	<field>
8f069c03 EM	151	<name>sort_name_format</name>
	152	<type>text</type>
	153	<comment>Format to display contact sort name</comment>
	154	<add>3.2</add>
6a488035 TO	155	</field>
6a488035 TO	156	<field>
8f069c03 EM	157	<name>individual_name_format</name>
	158	<type>text</type>
	159	<comment>Format to display a individual name</comment>
	160	<add>1.8</add>
	161	<drop>3.0</drop>
6a488035 TO	162	</field>
6a488035 TO	163	<field>
8f069c03 EM	164	<name>address_standardization_provider</name>
	165	<type>varchar</type>
	166	<length>64</length>
	167	<comment>object name of provider for address standarization</comment>
	168	<add>1.8</add>
6a488035 TO	169	</field>
6a488035 TO	170	<field>
8f069c03 EM	171	<name>address_standardization_userid</name>
	172	<type>varchar</type>
	173	<length>64</length>
	174	<comment>user id for provider login</comment>
	175	<add>1.8</add>
6a488035 TO	176	</field>
6a488035 TO	177	<field>
8f069c03 EM	178	<name>address_standardization_url</name>
	179	<type>varchar</type>
	180	<length>255</length>
	181	<comment>url of address standardization service</comment>
	182	<add>1.8</add>
6a488035	183	</field>
8f069c03 EM	184	<field>
	185	<name>editor_id</name>
	186	<type>int unsigned</type>
	187	<length>4</length>
	188	<comment>ID of the editor</comment>
	189	<add>2.1</add>
6a488035	190	</field>
8f069c03 EM	191	<field>
	192	<name>mailing_backend</name>
	193	<type>text</type>
	194	<comment>Smtp Backend configuration.</comment>
	195	<html>
	196	<type>TextArea</type>
	197	<rows>20</rows>
	198	<cols>80</cols>
	199	</html>
	200	<add>2.2</add>
6a488035 TO	201	</field>
6a488035 TO	202	<field>
8f069c03 EM	203	<name>navigation</name>
	204	<type>text</type>
	205	<comment>Store navigation for the Contact</comment>
	206	<add>3.0</add>
6a488035 TO	207	</field>
6a488035 TO	208	<field>
8f069c03 EM	209	<name>contact_autocomplete_options</name>
	210	<type>varchar</type>
	211	<length>255</length>
	212	<comment>What Autocomplete has to return</comment>
	213	<add>3.1</add>
6a488035 TO	214	</field>
6a488035 TO	215	</table>