[Sommaire] [Imprimer]

   1  -- Use this script to convert CHAR columns in horde_prefs to VARCHAR2 and trim
   2  -- the space padding.  This is only necessary if horde_prefs was created using
   3  -- scripts/sql/create.oci8.sql
   4  --
   5  -- $Horde: horde/scripts/upgrades/2005-09-22_horde_prefs_varchar2.oci8.sql,v 1.1.2.1 2005/10/18 11:34:01 jan Exp $
   6  --
   7  ALTER TABLE horde_prefs MODIFY pref_uid VARCHAR2(255);
   8  ALTER TABLE horde_prefs MODIFY pref_scope VARCHAR2(16);
   9  ALTER TABLE horde_prefs MODIFY pref_name VARCHAR2(32);
  10  UPDATE horde_prefs SET pref_uid = RTRIM(pref_uid);
  11  UPDATE horde_prefs SET pref_scope = RTRIM(pref_scope);
  12  UPDATE horde_prefs SET pref_name = RTRIM(pref_name);