[Tickets #1426] NEW: Use native Oracle types for horde_datatreee and horde_datatree_attributes

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=1426
-----------------------------------------------------------------------
 Ticket             | 1426
 Created By         | selsky at columbia.edu
 Summary            | Use native Oracle types for horde_datatreee and horde_datatree_attributes
 Queue              | Horde Base
 Version            | 3.0.3
 State              | Unconfirmed
 Priority           | 1. Low
 Type               | Bug
 Owners             | 
+New Attachment     | create.oci8.sql.patch
-----------------------------------------------------------------------


selsky at columbia.edu (2005-02-22 22:48) wrote:

This patch updates the oracle table creation script to bring it more inline
with the generic table creation script and to use Oracle types in
horde_datatree_attributes.

* Nulls aren't allowed in horde_datatree.datatree_parents
* Use varchar2 instead of varchar
* Use number(16) instead of int
* Use clob instead of varchar(4000)