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

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

<table>
  <base>CRM/Core</base>
  <class>LocBlock</class>
  <name>civicrm_loc_block</name>
  <comment>Define location specific properties</comment>
  <add>2.0</add>
  <log>true</log>
  <field>
    <name>id</name>
    <title>Location Block ID</title>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Unique ID</comment>
    <html>
      <type>Number</type>
    </html>
    <add>2.0</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>address_id</name>
    <title>Address ID</title>
    <type>int unsigned</type>
    <html>
      <label>Address</label>
    </html>
    <add>2.0</add>
  </field>
  <foreignKey>
    <name>address_id</name>
    <table>civicrm_address</table>
    <key>id</key>
    <add>2.0</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>email_id</name>
    <title>Email ID</title>
    <type>int unsigned</type>
    <html>
      <label>Email</label>
    </html>
    <add>2.0</add>
  </field>
  <foreignKey>
    <name>email_id</name>
    <table>civicrm_email</table>
    <key>id</key>
    <add>2.0</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>phone_id</name>
    <title>Phone ID</title>
    <type>int unsigned</type>
    <html>
      <label>Phone</label>
    </html>
    <add>2.0</add>
  </field>
  <foreignKey>
    <name>phone_id</name>
    <table>civicrm_phone</table>
    <key>id</key>
    <add>2.0</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>im_id</name>
    <title>IM ID</title>
    <type>int unsigned</type>
    <html>
      <label>IM</label>
    </html>
    <add>2.0</add>
  </field>
  <foreignKey>
    <name>im_id</name>
    <table>civicrm_im</table>
    <key>id</key>
    <add>2.0</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>address_2_id</name>
    <title>IM 2 ID</title>
    <type>int unsigned</type>
    <html>
      <label>IM 2</label>
    </html>
    <add>2.0</add>
  </field>
  <foreignKey>
    <name>address_2_id</name>
    <table>civicrm_address</table>
    <key>id</key>
    <add>2.0</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>email_2_id</name>
    <type>int unsigned</type>
    <title>Email 2 ID</title>
    <html>
      <label>Email 2</label>
    </html>
    <add>2.0</add>
  </field>
  <foreignKey>
    <name>email_2_id</name>
    <table>civicrm_email</table>
    <key>id</key>
    <add>2.0</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>phone_2_id</name>
    <type>int unsigned</type>
    <title>Phone 2 ID</title>
    <html>
      <label>Phone 2</label>
    </html>
    <add>2.0</add>
  </field>
  <foreignKey>
    <name>phone_2_id</name>
    <table>civicrm_phone</table>
    <key>id</key>
    <add>2.0</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>im_2_id</name>
    <type>int unsigned</type>
    <title>Instant Messenger 2 ID</title>
    <html>
      <label>Instant Messenger 2</label>
    </html>
    <add>2.0</add>
  </field>
  <foreignKey>
    <name>im_2_id</name>
    <table>civicrm_im</table>
    <key>id</key>
    <add>2.0</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
</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>LocBlock</class>
	6	<name>civicrm_loc_block</name>
	7	<comment>Define location specific properties</comment>
	8	<add>2.0</add>
	9	<log>true</log>
	10	<field>
186e0984	11	<name>id</name>
fb7786b0	12	<title>Location Block ID</title>
186e0984 EM	13	<type>int unsigned</type>
	14	<required>true</required>
	15	<comment>Unique ID</comment>
0481e12c A	16	<html>
	17	<type>Number</type>
	18	</html>
186e0984	19	<add>2.0</add>
6a488035 TO	20	</field>
6a488035 TO	21	<primaryKey>
186e0984 EM	22	<name>id</name>
186e0984 EM	23	<autoincrement>true</autoincrement>
6a488035 TO	24	</primaryKey>
6a488035 TO	25	<field>
186e0984	26	<name>address_id</name>
047c5009	27	<title>Address ID</title>
186e0984	28	<type>int unsigned</type>
57e94608	29	<html>
047c5009	30	<label>Address</label>
57e94608	31	</html>
186e0984	32	<add>2.0</add>
6a488035	33	</field>
3c7d2158	34	<foreignKey>
186e0984 EM	35	<name>address_id</name>
	36	<table>civicrm_address</table>
	37	<key>id</key>
	38	<add>2.0</add>
	39	<onDelete>SET NULL</onDelete>
3c7d2158	40	</foreignKey>
6a488035	41	<field>
186e0984	42	<name>email_id</name>
047c5009	43	<title>Email ID</title>
186e0984	44	<type>int unsigned</type>
57e94608	45	<html>
047c5009	46	<label>Email</label>
57e94608	47	</html>
186e0984	48	<add>2.0</add>
6a488035	49	</field>
3c7d2158	50	<foreignKey>
186e0984 EM	51	<name>email_id</name>
	52	<table>civicrm_email</table>
	53	<key>id</key>
	54	<add>2.0</add>
	55	<onDelete>SET NULL</onDelete>
3c7d2158	56	</foreignKey>
6a488035	57	<field>
186e0984	58	<name>phone_id</name>
047c5009	59	<title>Phone ID</title>
186e0984	60	<type>int unsigned</type>
57e94608	61	<html>
047c5009	62	<label>Phone</label>
57e94608	63	</html>
186e0984	64	<add>2.0</add>
6a488035	65	</field>
3c7d2158	66	<foreignKey>
186e0984 EM	67	<name>phone_id</name>
	68	<table>civicrm_phone</table>
	69	<key>id</key>
	70	<add>2.0</add>
	71	<onDelete>SET NULL</onDelete>
3c7d2158	72	</foreignKey>
6a488035	73	<field>
186e0984	74	<name>im_id</name>
047c5009	75	<title>IM ID</title>
186e0984	76	<type>int unsigned</type>
57e94608	77	<html>
047c5009	78	<label>IM</label>
57e94608	79	</html>
186e0984	80	<add>2.0</add>
6a488035	81	</field>
3c7d2158	82	<foreignKey>
186e0984 EM	83	<name>im_id</name>
	84	<table>civicrm_im</table>
	85	<key>id</key>
	86	<add>2.0</add>
	87	<onDelete>SET NULL</onDelete>
3c7d2158	88	</foreignKey>
6a488035	89	<field>
186e0984	90	<name>address_2_id</name>
047c5009	91	<title>IM 2 ID</title>
186e0984	92	<type>int unsigned</type>
57e94608	93	<html>
047c5009	94	<label>IM 2</label>
57e94608	95	</html>
186e0984	96	<add>2.0</add>
6a488035	97	</field>
3c7d2158	98	<foreignKey>
186e0984 EM	99	<name>address_2_id</name>
	100	<table>civicrm_address</table>
	101	<key>id</key>
	102	<add>2.0</add>
	103	<onDelete>SET NULL</onDelete>
3c7d2158	104	</foreignKey>
6a488035	105	<field>
186e0984 EM	106	<name>email_2_id</name>
186e0984 EM	107	<type>int unsigned</type>
57e94608 A	108	<title>Email 2 ID</title>
	109	<html>
	110	<label>Email 2</label>
	111	</html>
186e0984	112	<add>2.0</add>
6a488035	113	</field>
3c7d2158	114	<foreignKey>
186e0984 EM	115	<name>email_2_id</name>
	116	<table>civicrm_email</table>
	117	<key>id</key>
	118	<add>2.0</add>
	119	<onDelete>SET NULL</onDelete>
3c7d2158	120	</foreignKey>
6a488035	121	<field>
186e0984 EM	122	<name>phone_2_id</name>
186e0984 EM	123	<type>int unsigned</type>
57e94608 A	124	<title>Phone 2 ID</title>
	125	<html>
	126	<label>Phone 2</label>
	127	</html>
186e0984	128	<add>2.0</add>
6a488035	129	</field>
3c7d2158	130	<foreignKey>
186e0984 EM	131	<name>phone_2_id</name>
	132	<table>civicrm_phone</table>
	133	<key>id</key>
	134	<add>2.0</add>
	135	<onDelete>SET NULL</onDelete>
3c7d2158	136	</foreignKey>
6a488035	137	<field>
186e0984 EM	138	<name>im_2_id</name>
186e0984 EM	139	<type>int unsigned</type>
57e94608 A	140	<title>Instant Messenger 2 ID</title>
	141	<html>
	142	<label>Instant Messenger 2</label>
	143	</html>
186e0984	144	<add>2.0</add>
6a488035	145	</field>
3c7d2158	146	<foreignKey>
186e0984 EM	147	<name>im_2_id</name>
	148	<table>civicrm_im</table>
	149	<key>id</key>
	150	<add>2.0</add>
	151	<onDelete>SET NULL</onDelete>
3c7d2158	152	</foreignKey>
6a488035	153	</table>