[Kolab-devel] Adding features to kolab2.schema

Thu Feb 26 12:50:46 CET 2009

Hi,

I am proposing the attached patch to kolab2.schema and adding some external 
definitions (external.kolab.schema) to the Kolab delivery.

The ideas are following:
- add the following attributes to kolabInetOrgPerson
-- dateOfBirth
-- placeOfBirth
-- birthName
-- gender
-- countryOfCitizenship
-- countryOfResidence
-- legalForm
-- tradeRegisterLocation
-- tradeRegisterIdentifier
-- VATNumber
-- germanTaxId

- and add the following new objectclasses
-- kolabExternalPop3Account 
--- this is useful to integrate agregation of externel pop3 accounts e.g. via 
fetchmail
-- kolabGermanBankArrangement
--- often used for billing etc.

All newly added features and modifications are 100% backwards compatible and 
currently erfrakon.de runs on this enhanced LDAP directory schema.

In general I would like to hear your opinion about the proposed change.

Especially I would like to know if you think that the added complexity of 
seperating legal person (like a company or a foundation) from a natural person 
(individual) is worthwile? 

(I have my doubts because mail for a company is not so much different from 
mail for an individual)

Yours,
-- martin

-- 
e r f r a k o n
Erlewein, Frank, Konold & Partner - Beratende Ingenieure und Physiker
Sitz: Adolfstraße 23, 70469 Stuttgart, Partnerschaftsregister Stuttgart PR 126
http://www.erfrakon.com/
-------------- next part --------------
# /kolab/etc/openldap/schema/external.kolab.schema
# LDAP schema extension for Kolab
#
# Prefix for OIDs: depending on source
# Prefix for names: depending on source
# Postfix for object classes: Object
#

# extended from apple.schema
attributetype ( 1.3.6.1.4.1.63.1000.1.1.1.1.27
  NAME ( 'apple-birthday' 'dateOfBirth' 'dateOfIncorporation' )
  DESC 'Birthday or date of incorporation'
  EQUALITY generalizedTimeMatch
  SUBSTR caseExactIA5SubstringsMatch
  SINGLE-VALUE
  SYNTAX 1.3.6.1.4.1.1466.115.121.1.24 )

# from http://www.stroeder.com/stroeder.com.schema
attributetype ( 1.3.6.1.4.1.5427.1.389.4.12 
  NAME ( 'birthPlace' 'placeOfBirth' )
  DESC 'Place of birth'
  SUP l
  SINGLE-VALUE )

# from http://www.stroeder.com/stroeder.com.schema
attributetype ( 1.3.6.1.4.1.5427.1.389.4.14
  NAME 'birthName'
  DESC 'Last name at time of birth, e.g. maiden name'
  SUP sn
  SINGLE-VALUE )

# from http://www.stroeder.com/stroeder.com.schema
# The following data items and codes are used (see ISO 5218):
# 	Not known	0
# 	Male		1
# 	Female		2
# 	Not specified	9
#
attributetype ( 1.3.6.1.4.1.5427.1.389.4.7
  NAME 'gender'
  DESC 'Representation of human sex (see ISO 5218)'
  EQUALITY integerMatch
  SINGLE-VALUE
  SYNTAX 1.3.6.1.4.1.1466.115.121.1.27{1} )

# from http://www.stroeder.com/stroeder.com.schema
# tax ID of person or company within Germany
#
attributetype ( 1.3.6.1.4.1.5427.1.389.4.666
  NAME 'germanTaxId'
  DESC 'tax ID of person or company within Germany'
  EQUALITY caseIgnoreMatch
  SYNTAX 1.3.6.1.4.1.1466.115.121.1.15{20} )

# rfc 3039
# ISO 3166 Country Code
# multiple citizenships are possible!
attributetype ( 1.3.6.1.5.5.7.9.4
  NAME 'countryOfCitizenship'
  DESC 'Country of citizenship'
  SYNTAX 1.3.6.1.4.1.1466.115.121.1.11 )

# ISO 3166 Country Code 
attributetype ( 1.3.6.1.5.5.7.9.5
  NAME 'countryOfResidence'
  DESC 'Country of residence'
  SYNTAX 1.3.6.1.4.1.1466.115.121.1.11 )

attributetype ( 1.3.6.1.4.1.5427.1.389.4.661
  NAME 'germanBankAccountNumber'
  DESC 'The 8-digits number of a german bank account without spaces'
  SINGLE-VALUE
  SYNTAX 1.3.6.1.4.1.1466.115.121.1.36{10} )

attributetype ( 1.3.6.1.4.1.5427.1.389.4.662
  NAME 'germanBankCode'
  DESC 'The 8-digits number of a german bank code (BLZ) without spaces'
  SINGLE-VALUE
  SYNTAX 1.3.6.1.4.1.1466.115.121.1.36{8} )

attributetype ( 1.3.6.1.4.1.5427.1.389.4.663
  NAME 'germanBankName'
  DESC 'The name of a german bank registered in the BLZ table published by Deutsche Bundesbank.'
  SUP name
  SINGLE-VALUE )

attributetype ( 1.3.6.1.4.1.5427.1.389.4.664
  NAME 'germanBankAccountInfo'
  DESC 'Composed field containing a one-line human-readable representation of all necessary information.'
  SINGLE-VALUE
  SYNTAX 1.3.6.1.4.1.1466.115.121.1.15 )

attributetype ( 1.3.6.1.4.1.5427.1.389.4.665
  NAME 'germanBankAccountHolder'
  DESC 'The name of the holder of a german bank account commonly used as recipient name.'
  SINGLE-VALUE
  SUP name )

# http://www.daasi.de/
attributetype ( 1.3.6.1.4.1.5062.1.1.3.16
  NAME 'legalForm'
  DESC 'legal form of a company'
  EQUALITY caseIgnoreMatch
  SUBSTR caseIgnoreSubstringsMatch
  SINGLE-VALUE
  SYNTAX 1.3.6.1.4.1.1466.115.121.1.15 )

# http://www.daasi.de/
# location of the trade register authority
attributetype ( 1.3.6.1.4.1.5062.1.1.3.17
  NAME 'tradeRegisterLocation'
  DESC 'Location of the trade registrar where the organization is registered'
  SUP l
  SINGLE-VALUE )

# http://www.daasi.de/
# registration number a the trade register authority
attributetype ( 1.3.6.1.4.1.5062.1.1.3.18
  NAME 'tradeRegisterIdentifier'
  DESC 'Idientifier with which an organization is registered'
  EQUALITY caseIgnoreMatch
  SUBSTR caseIgnoreSubstringsMatch
  SINGLE-VALUE
  SYNTAX 1.3.6.1.4.1.1466.115.121.1.15 )

# https://forxa.mancomun.org/plugins/scmsvn/viewcvs.php/trunk/ldap/dxpisi.schema?annotate=29&root=mancomun
# VATNumber
# Identifier number for companies and persons. In Spain it is the same as NIF/CIF.
# In Germany it is called Umsatzsteueridentifikationsnummer.
attributetype ( 1.3.6.1.4.1.27994.1.3.4
  NAME 'VATNumber'
  DESC 'Identifier number for companies and persons'
  EQUALITY caseIgnoreMatch
  SUBSTR caseIgnoreSubstringsMatch
  SYNTAX 1.3.6.1.4.1.1466.115.121.1.15{10} )

objectclass ( 1.3.6.1.4.1.5427.11.3.6.1.4.1.5427.1.389.6.660
  NAME 'germanBankArrangement'
  DESC 'German bank account information'
  SUP top STRUCTURAL
  MUST ( germanBankAccountNumber $ germanBankCode )
  MAY ( germanBankAccountHolder $ germanBankName $ germanBankAccountInfo ) )

# end of external Kolab schema
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kolab2.schema.patch
Type: text/x-patch
Size: 11544 bytes
Desc: not available
URL: <http://lists.kolab.org/pipermail/devel/attachments/20090226/e3028f73/attachment.bin>