6.0.0-RC7
6/29/26

[#608] horde_datatree_attributes is not defined in oracle_create.sql
Summary horde_datatree_attributes is not defined in oracle_create.sql
Queue Horde Base
Queue Version HEAD
Type Bug
State Resolved
Priority 2. Medium
Owners
Requester rvs (at) angara (dot) ru
Created 9/20/04 (7952 days ago)
Due
Updated 9/21/04 (7951 days ago)
Assigned
Resolved 9/21/04 (7951 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
92 Chuck Hagenbuch Comment #2
State ⇒ Resolved
Reply to this comment
Added, thanks.
333 rvs (at) angara (dot) ru Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ horde_datatree_attributes is not defined in oracle_create.sql
Queue ⇒ Horde Base
Reply to this comment
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.


Saved Queries