summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorlsces <lester@lsces.co.uk>2016-02-07 17:03:14 +0000
committerlsces <lester@lsces.co.uk>2016-02-07 17:03:14 +0000
commit9509d850147e09cd7479116fd5e9cd26251e8ff9 (patch)
tree8ac5ba7f70be50dbc71f268c7979c95857c7b041
parent7392e0514a1fc729b6666cf7089285c6824b2126 (diff)
downloadcontact-9509d850147e09cd7479116fd5e9cd26251e8ff9.tar.gz
contact-9509d850147e09cd7479116fd5e9cd26251e8ff9.tar.bz2
contact-9509d850147e09cd7479116fd5e9cd26251e8ff9.zip
Adjust xref categories
This needs to be transfered to an aplication specific format on top of the basic generic set
-rw-r--r--admin/schema_inc.php6
1 files changed, 4 insertions, 2 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php
index af514e5..38fd7c7 100644
--- a/admin/schema_inc.php
+++ b/admin/schema_inc.php
@@ -127,12 +127,14 @@ $gBitInstaller->registerSchemaDefault( CONTACT_PKG_NAME, array(
"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$08', 'PHX Client', '0', '0', '3', '/contact/?type=8', NULL, NULL)",
"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$09', 'LSCES Supplier', '0', '0', '3', '/contact/?type=9', NULL, NULL)",
"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$10', 'Paypal Client', '0', '0', '3', '/contact/?type=10', NULL, NULL)",
-"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#C', 'Correspondence Address', '1', '0', '3', '../nlpg/?uprn=', 'address', NULL)",
+"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#C', 'Contact Address', '1', '0', '3', '../nlpg/?uprn=', 'address', NULL)",
"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#E', 'eMail Address', '1', '1', '3', '../contact/?contact_id=', 'text', NULL)",
"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#F', 'Fax', '1', '1', '3', '../contact/?contact_id=', 'text', NULL)",
-"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#O', 'Owner Address', '1', '0', '3', '../nlpg/?uprn=', 'address', NULL)",
+"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#E', 'eMail Address', '1', '1', '3', '../contact/?contact_id=', 'text', NULL)",
+"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#I', 'Invoice Address', '1', '0', '3', '../nlpg/?uprn=', 'address', NULL)",
"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#P', 'Telephone', '1', '1', '3', '../contact/?contact_id=', 'phone', NULL)",
"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#R', 'Residential Address', '1', '0', '3', '../nlpg/?uprn=', 'address', NULL)",
+"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#S', 'Service Address', '1', '0', '3', '../nlpg/?uprn=', 'address', NULL)",
"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#T', 'Tenant Address', '1', '0', '3', '../nlpg/?uprn=', 'address', NULL)",
"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#W', 'Web Site Url', '1', '1', '3', '../contact/?contact_id=', 'text', NULL)",
"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('0', 'Free format information', '1', '1', '3', '../contact/?xref=', 'text', NULL)",