| 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 |
State ⇒ Resolved
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ horde_datatree_attributes is not defined in oracle_create.sql
Queue ⇒ Horde Base
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.