diff options
| author | lsces <lester@lsces.co.uk> | 2012-08-06 08:33:59 +0100 |
|---|---|---|
| committer | lsces <lester@lsces.co.uk> | 2012-08-06 08:33:59 +0100 |
| commit | 71b81ea184bc96e6615dc346e88aad80f5cdc063 (patch) | |
| tree | aa7effd6688d137d3928dd3719a925c0178101af /admin | |
| parent | 44b287fca95e3ed5eb074ead88fc5be4c3e29afc (diff) | |
| download | contact-71b81ea184bc96e6615dc346e88aad80f5cdc063.tar.gz contact-71b81ea184bc96e6615dc346e88aad80f5cdc063.tar.bz2 contact-71b81ea184bc96e6615dc346e88aad80f5cdc063.zip | |
xref_source defaults expanded to include multi tag and displey style template
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 62 |
1 files changed, 31 insertions, 31 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index d603932..af514e5 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -116,37 +116,37 @@ $gBitInstaller->registerSchemaDefault( CONTACT_PKG_NAME, array( "INSERT INTO `".BIT_DB_PREFIX."contact_xref_type` VALUES ('3', 'alarm', 'Security System Links', '3', '')", "INSERT INTO `".BIT_DB_PREFIX."contact_xref_type` VALUES ('4', 'council', 'Council reference links', '3', '')", "INSERT INTO `".BIT_DB_PREFIX."contact_xref_type` VALUES ('5', 'account', 'Account Details', '4', '')", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$00', 'Personal', '0', '3', '/contact/?type=0', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$01', 'Business', '0', '3', '/contact/?type=1', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$02', 'Manufacturer', '0', '3', '/contact/?type=2', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$03', 'Distributor', '0', '3', '/contact/?type=3', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$04', 'Supplier', '0', '3', '/contact/?type=4', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$05', 'Record Company', '0', '3', '/contact/?type=5', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$06', 'Record Artist', '0', '3', '/contact/?type=6', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$07', 'Cartographer', '0', '3', '/contact/?type=7', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$08', 'PHX Client', '0', '3', '/contact/?type=8', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$09', 'LSCES Supplier', '0', '3', '/contact/?type=9', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$10', 'Paypal Client', '0', '3', '/contact/?type=10', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#C', 'Correspondence Address', '1', '3', '../nlpg/?uprn=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#E', 'eMail Address', '1', '3', '../contact/?contact_id=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#F', 'Fax', '1', '3', '../contact/?contact_id=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#O', 'Owner Address', '1', '3', '../nlpg/?uprn=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#P', 'Telephone', '1', '3', '../contact/?contact_id=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#R', 'Residential Address', '1', '3', '../nlpg/?uprn=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#T', 'Tenant Address', '1', '3', '../nlpg/?uprn=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#W', 'Web Site Url', '1', '3', '../contact/?contact_id=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('0', 'Free format information', '1', '3', '../contact/?xref=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('CON', 'Contact', '1', '3', '../nlpg/?uprn=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#A', 'Alarm Maintainer', '3', '3', '../nlpg/?uprn=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#K', 'Keyholder', '3', '3', '../nlpg/?uprn=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('ALARM', 'Alarm System', '3', '3', '../nlpg/?uprn=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('CTAX', 'Council Tax', '4', '3', '../nlpg/?uprn=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('ER', 'Electoral Roll', '4', '3', '../nlpg/?uprn=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('HBEN', 'Housing Benefit', '4', '3', '../nlpg/?uprn=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('NNDR', 'National Non-domestic Rates', '4', '3', '../nlpg/?uprn=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('ACC_TO', 'Account Turnover', '5', '3', '../vat/?vat=', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('SAGEID', 'SAGE Account Reference', '5', '3', '''sage''', NULL)", -"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('VAT_NO', 'VAT Number', '5', '3', '../vat/?vat=', NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$00', 'Personal', '0', '0', '3', '/contact/?type=0', NULL, NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$01', 'Business', '0', '0', '3', '/contact/?type=1', NULL, NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$02', 'Manufacturer', '0', '0', '3', '/contact/?type=2', NULL, NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$03', 'Distributor', '0', '0', '3', '/contact/?type=3', NULL, NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$04', 'Supplier', '0', '0', '3', '/contact/?type=4', NULL, NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$05', 'Record Company', '0', '0', '3', '/contact/?type=5', NULL, NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$06', 'Record Artist', '0', '0', '3', '/contact/?type=6', NULL, NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('$07', 'Cartographer', '0', '0', '3', '/contact/?type=7', NULL, NULL)", +"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 ('#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 ('#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 ('#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)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('CON', 'Contact', '1', '1', '3', '../nlpg/?uprn=', 'text', NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#A', 'Alarm Maintainer', '3', '0', '3', '../nlpg/?uprn=', 'text', NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('#K', 'Keyholder', '3', '1', '3', '../nlpg/?uprn=', 'phone', NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('ALARM', 'Alarm System', '3', '0', '3', '../nlpg/?uprn=', 'text', NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('CTAX', 'Council Tax', '4', '0', '3', '../nlpg/?uprn=', 'text', NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('ER', 'Electoral Roll', '4', '0', '3', '../nlpg/?uprn=', 'text', NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('HBEN', 'Housing Benefit', '4', '0', '3', '../nlpg/?uprn=', 'text', NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('NNDR', 'National Non-domestic Rates', '4', '0', '3', '../nlpg/?uprn=', 'text', NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('ACC_TO', 'Account Turnover', '5', '0', '3', '../vat/?vat=', 'text', NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('SAGEID', 'SAGE Account Reference', '5', '0', '3', '''sage''', 'text', NULL)", +"INSERT INTO `".BIT_DB_PREFIX."contact_xref_source` VALUES ('VAT_NO', 'VAT Number', '5', '0', '3', '../vat/?vat=', 'text', NULL)", ) ); |
