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

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

<table>
  <base>CRM/Core</base>
  <class>PreferencesDate</class>
  <name>civicrm_preferences_date</name>
  <comment>Define date preferences for the site</comment>
  <add>2.0</add>
  <log>true</log>
  <field>
    <name>id</name>
    <title>Date Preference ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <html>
      <type>Number</type>
    </html>
    <add>2.0</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>name</name>
    <title>Date Preference Name</title>
    <type>varchar</type>
    <length>64</length>
    <required>true</required>
    <comment>The meta name for this date (fixed in code)</comment>
    <add>2.0</add>
  </field>
  <index>
    <name>index_name</name>
    <fieldName>name</fieldName>
    <add>2.0</add>
  </index>
  <field>
    <name>description</name>
    <type>varchar</type>
    <length>255</length>
    <comment>Description of this date type.</comment>
    <html>
      <label>Description</label>
    </html>
    <add>2.0</add>
  </field>
  <field>
    <name>start</name>
    <type>int</type>
    <required>true</required>
    <comment>The start offset relative to current year</comment>
    <html>
      <label>Start</label>
    </html>
    <add>2.0</add>
  </field>
  <field>
    <name>end</name>
    <title>End Offset</title>
    <type>int</type>
    <required>true</required>
    <comment>The end offset relative to current year, can be negative</comment>
    <add>2.0</add>
  </field>
  <field>
    <name>minute_increment</name>
    <type>int</type>
    <comment>The minute increment number</comment>
    <html>
      <label>Minute Increment</label>
    </html>
    <add>2.0</add>
    <drop>3.1</drop>
  </field>
  <field>
    <name>date_format</name>
    <type>varchar</type>
    <length>64</length>
    <comment>The date type</comment>
    <html>
      <label>Date Format</label>
    </html>
    <add>2.0</add>
  </field>
  <field>
    <name>time_format</name>
    <type>varchar</type>
    <length>64</length>
    <comment>time format</comment>
    <html>
      <label>Time Format</label>
    </html>
    <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>PreferencesDate</class>
	6	<name>civicrm_preferences_date</name>
	7	<comment>Define date preferences for the site</comment>
	8	<add>2.0</add>
	9	<log>true</log>
	10	<field>
8f069c03	11	<name>id</name>
fa6ace1a	12	<title>Date Preference ID</title>
8f069c03 EM	13	<type>int unsigned</type>
8f069c03 EM	14	<required>true</required>
0481e12c A	15	<html>
	16	<type>Number</type>
	17	</html>
8f069c03	18	<add>2.0</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>name</name>
fa6ace1a	26	<title>Date Preference Name</title>
8f069c03 EM	27	<type>varchar</type>
	28	<length>64</length>
	29	<required>true</required>
	30	<comment>The meta name for this date (fixed in code)</comment>
	31	<add>2.0</add>
6a488035 TO	32	</field>
	33	<index>
	34	<name>index_name</name>
	35	<fieldName>name</fieldName>
	36	<add>2.0</add>
	37	</index>
	38	<field>
8f069c03 EM	39	<name>description</name>
	40	<type>varchar</type>
	41	<length>255</length>
	42	<comment>Description of this date type.</comment>
1662d426 A	43	<html>
	44	<label>Description</label>
	45	</html>
8f069c03	46	<add>2.0</add>
6a488035 TO	47	</field>
6a488035 TO	48	<field>
8f069c03 EM	49	<name>start</name>
	50	<type>int</type>
	51	<required>true</required>
	52	<comment>The start offset relative to current year</comment>
1662d426 A	53	<html>
	54	<label>Start</label>
	55	</html>
8f069c03	56	<add>2.0</add>
6a488035 TO	57	</field>
6a488035 TO	58	<field>
8f069c03	59	<name>end</name>
f3ea5182	60	<title>End Offset</title>
8f069c03 EM	61	<type>int</type>
	62	<required>true</required>
	63	<comment>The end offset relative to current year, can be negative</comment>
	64	<add>2.0</add>
6a488035 TO	65	</field>
6a488035 TO	66	<field>
8f069c03 EM	67	<name>minute_increment</name>
	68	<type>int</type>
	69	<comment>The minute increment number</comment>
1662d426 A	70	<html>
	71	<label>Minute Increment</label>
	72	</html>
8f069c03 EM	73	<add>2.0</add>
8f069c03 EM	74	<drop>3.1</drop>
6a488035 TO	75	</field>
6a488035 TO	76	<field>
8f069c03 EM	77	<name>date_format</name>
	78	<type>varchar</type>
	79	<length>64</length>
	80	<comment>The date type</comment>
1662d426 A	81	<html>
	82	<label>Date Format</label>
	83	</html>
8f069c03	84	<add>2.0</add>
6a488035 TO	85	</field>
6a488035 TO	86	<field>
8f069c03 EM	87	<name>time_format</name>
	88	<type>varchar</type>
	89	<length>64</length>
	90	<comment>time format</comment>
1662d426 A	91	<html>
	92	<label>Time Format</label>
	93	</html>
8f069c03	94	<add>3.1</add>
6a488035 TO	95	</field>
6a488035 TO	96	</table>