[cvs] commit: turba/scripts/sql turba_objects.mssql.sql turba_objects.mysql.sql turba_objects.oci8.sql turba_objects.pgsql.sql turba_objects.sql turba/scripts/upgrades 2007-08-05_remove_lastname_null_constraint.sql turba/config attributes.php.dist sources.php.dist

[Michael Rubinsky]

mrubinsk    2007-08-05 12:24:57 EDT

  Modified files:
    scripts/sql          turba_objects.mssql.sql 
                         turba_objects.mysql.sql 
                         turba_objects.oci8.sql 
                         turba_objects.pgsql.sql turba_objects.sql 
    config               attributes.php.dist sources.php.dist 
  Added files:
    scripts/upgrades     
                         2007-08-05_remove_lastname_null_constraint.sql 
  Log:
  - Remove the NOT NULL constraint from object_lastname field in default schema - causes problems with contact list creation while using composite fields
  
  - Make 'lastname' attribute required, and 'firstname' not required by default in attributes.php.dist
  
  - Reorder 'fields' array for the localsql configuration so that 'lastname' is the first field - this assures that contact lists named with a single word will populate the required lastname field.
  
  This at least solves the immediate issue, but there is still an issue of naming contact lists with more than two words (when using localsql config out of the box) - they are parsed as a lastname, firstname and then the remaining words are dropped.
  
  Revision  Changes    Path
  1.50      +2 -2      turba/config/attributes.php.dist
  1.176     +2 -2      turba/config/sources.php.dist
  1.6       +3 -3      turba/scripts/sql/turba_objects.mssql.sql
  1.8       +2 -2      turba/scripts/sql/turba_objects.mysql.sql
  1.7       +2 -2      turba/scripts/sql/turba_objects.oci8.sql
  1.10      +3 -3      turba/scripts/sql/turba_objects.pgsql.sql
  1.8       +2 -2      turba/scripts/sql/turba_objects.sql
  1.1       +6 -0      turba/scripts/upgrades/2007-08-05_remove_lastname_null_constraint.sql (new)

  Chora Links:
  http://cvs.horde.org/diff.php/turba/config/attributes.php.dist?r1=1.49&r2=1.50&ty=u
  http://cvs.horde.org/diff.php/turba/config/sources.php.dist?r1=1.175&r2=1.176&ty=u
  http://cvs.horde.org/diff.php/turba/scripts/sql/turba_objects.mssql.sql?r1=1.5&r2=1.6&ty=u
  http://cvs.horde.org/diff.php/turba/scripts/sql/turba_objects.mysql.sql?r1=1.7&r2=1.8&ty=u
  http://cvs.horde.org/diff.php/turba/scripts/sql/turba_objects.oci8.sql?r1=1.6&r2=1.7&ty=u
  http://cvs.horde.org/diff.php/turba/scripts/sql/turba_objects.pgsql.sql?r1=1.9&r2=1.10&ty=u
  http://cvs.horde.org/diff.php/turba/scripts/sql/turba_objects.sql?r1=1.7&r2=1.8&ty=u
  http://cvs.horde.org/co.php/turba/scripts/upgrades/2007-08-05_remove_lastname_null_constraint.sql?r=1.1