[Tickets #608] NEW: horde_datatree_attributes is not defined in oracle_create.sql

[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=608
-----------------------------------------------------------------------
 Ticket     | 608
 Created By | rvs at angara.ru
 Summary    | horde_datatree_attributes is not defined in oracle_create.sql
 Queue      | Horde Base
 Version    | HEAD
 State      | Unconfirmed
 Priority   | 2. Medium
 Type       | Bug
 Owners     | 
-----------------------------------------------------------------------


rvs at angara.ru (2004-09-20 08:57) wrote:

The table horde_datatree_attributes definition is absent in
horde/scripts/db/oracle_create.sql,v 1.6 while table horde_datatree is
present there.
The table horde_datatree_attributes can't be created correctly using
datatree.sql because it has to be defined a bit differently for Oracle.
Suggest adding this into oracle_create.sql:

--------------------------------------------------------

CREATE TABLE horde_datatree_attributes (
    datatree_id INT NOT NULL,
    attribute_name VARCHAR(255) NOT NULL,
    attribute_key VARCHAR(255),
    attribute_value VARCHAR(4000)
);

CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes
(datatree_id);
CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes
(attribute_name);
CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes
(attribute_key);


GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree TO horde;
GRANT SELECT, INSERT, UPDATE, DELETE ON horde_datatree_attributes TO horde;

--------------------------------------------------------

Note that attribute_value column should be VARCHAR, not CLOB because of
using it in comparisons in the framework code Horde/DataTree/sql.php. CLOBs
can't be compared in SQL statements on Oracle.