[Tickets #533] oci8 sessionhandler

[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=533
-----------------------------------------------------------------------
 Ticket     | 533
 Updated By | trent.hornibrook at gmail.com
 Summary    | oci8 sessionhandler
 Queue      | Horde Base
 Version    | 2.2.5
 State      | Feedback
 Priority   | 2. Medium
 Type       | Bug
 Owners     | 
-----------------------------------------------------------------------


trent.hornibrook at gmail.com (2004-09-02 21:07) wrote:

Also the sessionhandler.sql is incorrect for oci8 as oracle doesnt have
a LONGBLOB or IMAGE datatype

/horde/scripts/db
$ cat sessionhandler.sql
-- $Horde: horde/scripts/db/sessionhandler.sql,v 1.2.2.1 2003/01/16 20:14:49
slusarz Exp $

CREATE TABLE horde_sessionhandler (
    session_id             VARCHAR(32) NOT NULL,
    session_lastmodified   INT NOT NULL,
    session_data           LONGBLOB,
-- Or, on some DBMS systems:
--  session_data           IMAGE,

    PRIMARY KEY (session_id)
);

GRANT SELECT, INSERT, UPDATE, DELETE ON horde_sessionhandler TO horde;

---------

I have set mine to:

CREATE TABLE horde_sessionhandler (
    session_id             VARCHAR(32) NOT NULL,
    session_lastmodified   INT NOT NULL,
    session_data           BLOB,
    PRIMARY KEY (session_id)
);

GRANT SELECT, INSERT, UPDATE, DELETE ON horde_sessionhandler TO horde;